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