File type: Pipe-delimited.
Location: /dti/exchange/cm/dmexp[product][edition].[MMDDYYYY], where “MMDDYYYY” are the month, day, and year of the run date.
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