# 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

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

## Insert Base

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