Route Delivery List Export
File type: Pipe delimited
Location: /dti/exchange/cm. The user defines the file name when running the report. Note that the header and totals records for area, region, zone and district are similar in function to the sorting in the report. So, for example, the region records will only be included if the Selection Type is area or region.
Header
E1
Beginning of Header record
Export Order
The order of this record in the export (will always be 1)
Selection Date
The date the export was created for
Process Date
The date the export was processed (format mmddyyyy)
Process Time
The time the export was processed
User
The user who created the export
Subscriber Type
The type of subscriber selected to be exported (Active Subscribers, All Subscribers, All Households, Inactive Subscribers, Non-subscribers, or Active or Additional Product)
Billing Method
A comma separated list of Billing Methods selected to be exported (if selection is based on billing method)
Delivery Schedule
A comma separated list of Delivery Schedules selected to be exported (if selection is based on delivery schedule)
Day Of Week
The day of week selected to be exported
Includes Pending
Indicates whether pending transactions were considered in export
Selection Type
The selection type used in generating the export (Area, Region, Zone, District or Route)
Bonus Day
Indicates whether bonus day papers were included in export (can be “Yes”, “No”, or “Only”)
Publication Header
P1
Beginning of Publication Header
Export Order
The order of this record in the export
Product ID
The publication for the detail records that follow
Name
The publication’s name
Area Header
A1
Beginning of Area Header
Export Order
The order of this record in the export
Area ID
The area for the detail records that follow
Area Description
A description of the area
Region Header
G1
Beginning of Region Header
Export Order
The order of this record in the export
Region ID
The region for the detail records that follow
Region Description
A description of the region
Zone Header
Z1
Beginning of Zone Header
Export Order
The order of this record in the export
Zone ID
The zone for the detail records that follow
Zone Description
A description of the zone
District Header
D1
Beginning of District Header
Export Order
The order of this record in the export
District ID
The district for the detail records that follow
District Description
A description of the district
Route Header
R1
Beginning of Route Header
Export Order
The order of this record in the export
Route ID
The route for the occupant/address records that follow
Route Name
The route’s name
Route Type
The route’s route type
Depot
The route’s depot
Drop Location (2 fields)
The route’s drop location(s)
Truck
The truck’s ID
Truck Name
Name of the truck
Supplying Truck ID
ID of the supplying truck
Household Record
H1
Beginning of Household record
Export Order
The order of this record in the export
Address ID
The household’s address ID
Subscriber ID
The household’s subscriber ID, if a subscriber. If an external subscriber ID has been imported for the subscription (i.e. it is for an external publication), that is exported instead of the subscriber ID
Name
The occupant’s first and last name (“Resident” if no occupant)
Address (5 fields)
Address of the occupant
House Number
House Number Modifier
Odd or Even
Pre Directional
Street Name
Street Suffix
Post Directional
Complex
Building
Unit Designator
Unit Number
Military Foreign
(2 fields)
City
State
ZIP Code
ZIP Extension
Country
Phone
Occupant’s phone number
Copies (7 fields)
Copies by day of week (Sunday through Saturday)
Route Walk Sequence
Newspaper route walk sequence for this address
Postal Walk Sequence
Postal walk sequence for this address
Status
Subscriber status (Active, Inactive, Non Sub, etc.)
Expire Date
Current expire date for the subscription (if office pay)
Last Start
The last start date that has been processed
Rate Expire
The next rate change
Billing Method
Subscriber billing method (Office Pay, Carrier Collect, etc.)
Delivery Schedule
Subscriber delivery schedule ID
Directions
Delivery directions to the address (max 90 characters)
Delivery Placement
Delivery placement ID
Placement Description
Delivery placement description
Delivery Instructions
Address delivery instructions (maximum 90 characters)
Reassigned Address
Indicates if the subscription is route different from the address route
Pending Transaction
Indicates whether the subscription has been changed because of a pending transaction. If INCLUDE PENDING is set to “n”, this will be “no” in all records
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.). Field will be 0 if there are no bonus days for the household, or if SHOW BONUS DAY is set to “no”
Trip
Trip ID, if the route belongs to a trip
Trip Sequence
Occupant’s trip sequence
Other Name
Occupant’s other name
Additional Products Record
H2
Beginning of Additional Products record (1 record will exist for each additional product the household receives on the delivery date, if INCLUDE ADDITIONAL PRODUCTS is “y”)
Export Order
The order of this record in the export
Address ID
The household’s address ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Number of copies of additional product delivered to occupant
Subscription ID
The household’s subscriber ID, if a subscriber
Expire Date
Current expire date for the subscription (if office pay)
Last Start
The last start date that has been processed
Rate Expire
The next rate change
Billing Method
Subscriber billing method (Office Pay, Carrier Collect, etc.)
Delivery Schedule
Subscriber delivery schedule ID
Delivery Placement
Delivery placement ID
Delivery Instructions
Address delivery instructions (maximum 90 characters)
Delivery Directions
Occupant delivery directions s (maximum 90 characters)
Rate Code
Subscriber’s assigned rate, if a subscriber
Directions
Delivery directions to the address (max 90 characters)
Copies (7 fields)
Copies by day of week (Sunday through Saturday)
Route Total
R2
Beginning of route total record
Export Order
The order of this record in the export
Route ID
Addresses
Total number of households for the route
Non-subscribers
Total number of non-subscribers for the route
Copies (7 fields)
Total copies delivered by route by day of week
Pending
Number of occupants whose status was changed by a pending transaction
Bonus Day
Number of bonus day papers delivered by route
Route Additional Product Record
R3
Beginning of Route Additional Product Record (one record will be created for each additional product delivered by route)
Export Order
The order of this record in the export
Route ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Copies of the additional product delivered by route
Route Billing Method Totals
R4
Beginning of Route Billing Method Totals record (one record will be created for each billing method/delivery schedule/subscriber status combination delivered by route)
Export Order
The order of this record in the export
Route ID
Delivery Schedule
Billing Method
Subscriber Status
Total copies (7)
Total copies for this route, delivery schedule, billing method, and subscriber status for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.). Field will be 0 if there are no bonus days
Draw Totals by Rate Code
R5
Beginning of Draw Totals by Rate Code record (one record will be created for each rate code assigned to subscribers delivered by route)
Export Order
The order of this record in the export
Route ID
Rate Code
A subscriber rate code
Subscribers
The number of subscribers on the route with this subscriber rate code
Total copies (7)
Total copies for this route and subscriber rate code for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.). Field will be 0 if there are no bonus days
District Totals
D2
Beginning of district totals record
Export Order
The order of this record in the export
District ID
Addresses
Total number of households for the district
Non-subscribers
Total number of non-subscribers for the district
Copies (7 fields)
Total copies delivered by district by day of week
Pending
Number of occupants whose status was changed by a pending transaction
Bonus Day
Number of bonus day papers delivered by district
District Additional Product
D3
Beginning of District Additional Product Record (one record will be created for each additional product)
Export Order
The order of this record in the export
District ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Copies of the additional product delivered by district
District Billing Method Totals
D4
Beginning of District Billing Method Totals record (one record will be created for each billing method/delivery schedule/subscriber status combination)
Export Order
The order of this record in the export
District ID
Delivery Schedule
Billing Method
Subscriber Status
Total copies (7)
Total copies for this route, delivery schedule, billing method, and subscriber status for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.)
Zone Totals
Z2
Beginning of zone totals record
Export Order
The order of this record in the export
Zone ID
Addresses
Total number of households for the zone
Non-subscribers
Total number of non-subscribers for the zone
Copies (7 fields)
Total copies delivered by zone by day of week
Pending
Number of occupants whose status was changed by a pending transaction
Bonus Day
Number of bonus day papers delivered by zone
Zone Additional Product
Z3
Beginning of Zone Additional Product Record (one record will be created for each additional product)
Export Order
The order of this record in the export
Zone ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Copies of the additional product delivered by zone
Zone Billing Method Totals
Z4
Beginning of Zone Billing Method Totals record (one record will be created for each billing method/delivery schedule/subscriber status combination)
Export Order
The order of this record in the export
Zone ID
Delivery Schedule
Billing Method
Subscriber Status
Total copies (7)
Total copies for this route, delivery schedule, billing method, and subscriber status for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.)
Region Totals
G2
Beginning of region totals record
Export Order
The order of this record in the export
Region ID
Addresses
Total number of households for the region
Non-subscribers
Total number of non-subscribers for the region
Copies (7 fields)
Total copies delivered by region by day of week
Pending
Number of occupants whose status was changed by a pending transaction
Bonus Day
Number of bonus day papers delivered by region
Region Additional Product
G3
Beginning of Region Additional Product Record (one record will be created for each additional product)
Export Order
The order of this record in the export
Region ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Copies of the additional product delivered by region
Region Billing Method Totals
G4
Beginning of Region Billing Method Totals record (one record will be created for each billing method/delivery schedule/subscriber status combination)
Export Order
The order of this record in the export
Region ID
Delivery Schedule
Billing Method
Subscriber Status
Total copies (7)
Total copies for this route, delivery schedule, billing method, and subscriber status for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.)
Area Totals
D2
Beginning of area totals record
Export Order
The order of this record in the export
Area ID
Addresses
Total number of households for the area
Non-subscribers
Total number of non-subscribers for the area
Copies (7 fields)
Total copies delivered by area by day of week
Pending
Number of occupants whose status was changed by a pending transaction
Bonus Day
Number of bonus day papers delivered by area
Area Additional Product
A3
Beginning of Area Additional Product Record (one record will be created for each additional product delivered by area)
Export Order
The order of this record in the export
Area ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Copies of the additional product delivered by area
Area Billing Method Totals
A4
Beginning of Area Billing Method Totals record (one record will be created for each billing method/delivery schedule/subscriber status combination)
Export Order
The order of this record in the export
Area ID
Delivery Schedule
Billing Method
Subscriber Status
Total copies (7)
Total copies for this route, delivery schedule, billing method, and subscriber status for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.)
Publication Totals
P2
Beginning of publication totals record
Export Order
The order of this record in the export
Publication ID
Addresses
Total number of households for the publication
Non-subscribers
Total number of non-subscribers for the publication
Copies (7 fields)
Total copies delivered by publication by day of week
Pending
Number of occupants whose status was changed by a pending transaction
Bonus Day
Number of bonus day papers delivered by publication
Publication Additional Product
P3
Beginning of Publication Additional Product Record (one record will be created for each additional product)
Export Order
The order of this record in the export
Publication ID
Product ID
ID of the additional product
Product Name
Name of the additional product
Copies
Copies of the additional product delivered by publication
Publication Billing Method Totals
P4
Beginning of Publication Billing Method Totals record (one record will be created for each billing method/delivery schedule/subscriber status combination)
Export Order
The order of this record in the export
Publication ID
Delivery Schedule
Billing Method
Subscriber Status
Total copies (7)
Total copies for this route, delivery schedule, billing method, and subscriber status for each day of the week
Bonus Day
Numeric value of the day the copies are affected by the bonus day (1=Sunday, 2=Monday, etc.)
Trailer
E2
Beginning of Export Trailer
Export Order
The order of this record in the export
End Date
The date the export was completed
End Time
The time the export was completed
Last updated
