# District Manager Export

**File type:** Pipe-delimited.

**Location:** `/dti/exchange/cm/dmexp[product][edition].[MMDDYYYY]`, where “MMDDYYYY” are the month, day, and year of the run date.

<table><thead><tr><th width="181.94972067039106">Field</th><th width="356.33333333333337">Description</th><th width="150">Max Length</th></tr></thead><tbody><tr><td>Export Type</td><td>D1 (at this time there is only one record type for the export)</td><td>2</td></tr><tr><td>Product ID</td><td>The publication being exported. If a combined pub is being exported, the route’s delivery publication will be exported here</td><td>8</td></tr><tr><td>Edition ID</td><td>The route’s edition.</td><td>8</td></tr><tr><td>Publish Date</td><td>The run date for the DM Report<br>(format MM/DD/YYYY)</td><td>10</td></tr><tr><td>Truck ID</td><td>The route’s truck, if not dropped by a relay. If the route is dropped by a relay, the parent truck ID is exported</td><td>8</td></tr><tr><td>Truck Name</td><td>The name of the truck in the previous field</td><td>20</td></tr><tr><td>Relay Truck ID</td><td>The route’s truck, if dropped by a relay. If not, this field will be blank</td><td>8</td></tr><tr><td>Relay Truck Name</td><td>The name of the truck in the previous field</td><td>20</td></tr><tr><td>Drop order</td><td>The drop order of the route on the truck</td><td>8</td></tr><tr><td>District</td><td>The route’s district</td><td>8</td></tr><tr><td>Carrier</td><td>The route’s carrier ID</td><td>8</td></tr><tr><td>Route ID</td><td>The ID of the route being exported.</td><td>8</td></tr><tr><td>Subscription</td><td>The ID of the subscriber for this transaction, if any</td><td>10</td></tr><tr><td>Name</td><td>The subscriber’s first and last name</td><td>30</td></tr><tr><td>Address (fields 1-5)</td><td>The subscriber’s address</td><td>30</td></tr><tr><td>Phone Number</td><td>The subscriber’s phone number, if not unlisted. Format (999) 999-9999</td><td>14</td></tr><tr><td>Delivery Schedule</td><td>The subscriber’s delivery schedule</td><td>8</td></tr><tr><td>Billing Method</td><td>The subscriber’s billing method</td><td>15</td></tr><tr><td>Tran Type ID</td><td>The transaction type (start, stop, etc.)</td><td>15</td></tr><tr><td>Source Code</td><td>Source code for transaction</td><td>8</td></tr><tr><td>Subsource Code</td><td>The subsource for the transaction, if any</td><td>8</td></tr><tr><td>Reason Code</td><td>Reason code for transaction</td><td>8</td></tr><tr><td>Complaint Time</td><td>Complaint time, if transaction is a complaint. Format: 99:99:99</td><td>8</td></tr><tr><td>Delivery Complaint</td><td>Flag to indicate whether complaint is a delivery complaint (yes/no)</td><td>3</td></tr><tr><td>Days Adjusted</td><td>If transaction is a complaint, number of days subscription was extended</td><td>3</td></tr><tr><td>Entry Date</td><td>The entry date for the transaction</td><td>10</td></tr><tr><td>Transaction Date</td><td>The tran date entered for the transaction</td><td>10</td></tr><tr><td>Text (fields 1-5)</td><td>Complaint text, message text, or remarks (if transaction is not a complaint or message and remarks were entered)</td><td>30</td></tr><tr><td>Copies</td><td>Number of copies subscriber receives on run date</td><td>3</td></tr><tr><td>Expire Date</td><td>Subscription expire date (for office pay subscribers)</td><td>10</td></tr><tr><td>Restart Date</td><td>If the transaction is a stop and a restart date has been entered, it will be exported here</td><td>10</td></tr><tr><td>Create User</td><td>User who entered the transaction</td><td>8</td></tr><tr><td>Delivery Placement ID</td><td>The delivery placement</td><td>8</td></tr><tr><td>Placement Description</td><td>Description of the delivery placement</td><td>30</td></tr></tbody></table>