Insert Base and Draw Export Formats

File type: Fixed length.

Location: /dti/exchange/cm (the draw file will be named <ProductID>mmddyy<draw type> and the base file will be named <ProductID>mmddyyBASE)

Insert Draw

Field	Type	Length	Position	Format
Product ID	character	8	01-Aug	x(8)
Route ID	character	8	Sep-16	x(8)
Draw Date	date (mm/dd/yyyy)	10	17-26	99/99/9999
Draw Type	character	9	27-35	x(9)
Section ID (blank if none)	character	8	26-43	x(8)
Draw Amount	integer	9	44-52	>,>>>,>>9

Insert Base

Field	Type	Length	Position	Format
Product ID	character	8	01-Aug	x(8)
Date	date (mm/dd/yyyy)	10	Sep-18	99/99/9999
Route ID	character	8	19-26	x(8)
Truck ID	character	8	27-34	x(8)
Distribution Ad Zone	character	8	35-42	x(8)
Distribution Ad Zone Description	character	30	43-72	x(30)
Selling Ad Zone 1	character	8	73-80	x(8)
Selling Ad Zone 1 Description	character	30	81-110	x(30)
Selling Ad Zone 2	character	8	111-118	x(8)
Selling Ad Zone 2 Description	character	30	119-148	x(30)
Selling Ad Zone 3	character	8	149-156	x(8)
Selling Ad Zone 3 Description	character	30	157-186	x(30)
Selling Ad Zone 4	character	8	187-194	x(8)
Selling Ad Zone 4 Description	character	30	195-224	x(30)
Selling Ad Zone 5	character	8	225-232	x(8)
Selling Ad Zone 5 Description	character	30	233-262	x(30)
Selling Ad Zone 6	character	8	263-270	x(8)
Selling Ad Zone 6 Description	character	30	271-300	x(30)
Selling Ad Zone 7	character	8	301-308	x(8)
Selling Ad Zone 7 Description	character	30	309-338	x(30)
Route Type	character	8	339-346	x(8)
Preprint Demographic	character	8	347-354	x(8)
Edition ID	character	8	355-362	x(8)
District ID	character	8	363-370	x(8)
Depot ID	character	8	371-378	x(8)
AAM Zone ID	character	6	379-384	x(6)
ZIP Code	character	5	385-389	x(5)
Carrier ID	character	8	390-397	x(8)
Carrier Name	character	43	398-440	x(43)
Drop Location	character	90	441-530	x(90)
Drop Order	integer	8	531-538	>>>>>>>9