Advance Reconciliation Export Format

File type: Space delimited with characters in quotes.

Location: /dti/exchange/cm. The file name will be recon<publ><mmddyyyy>, where <publ> is the ID of the publication and <mmddyyyy> is the date of the export.

Fields	Description
Publication	The publication for which you are exporting rounded draw info.
Rounding Entity	The truck or route group for which rounded draw and advance draw are being listed.
Run Date	The publishing date that you are exporting information for, in mmddyyyy format (month, day, year).
Section	The advance section for which this rounded draw pertains.
Insert Mix Combination	The insert mix for which this rounded draw pertains.
Rounded Draw	The rounded draw for this truck or route group, within the section/insert combination listed above.
Advance Draw	The advance draw for this truck or route group (prior to rounding), within the section/insert combination listed above.
Rounding Model	The ID of the rounding model used to round the advance draw.

Example:

“Times” “Truck” 03/06/2001 “Comics” 0004 60 52 “Up”