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
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
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
Last updated
