This file is comma-delimited, with each field surrounded by quotes. The file will be written to the PW/data directory and named <productid>dd.txt, where “dd” is the day of the month.
The additional fields for single copy mail routes will only export for routes with a single copy type that matches the single copy type specified in the Business Rule— For which single copy type should mail labels print when using Postalsoft Presort and Label? These fields will not be exported if the Business Rule is not answered. If exported, the additional fields will be blank for subscriber records.
Label Group ID
CAPS
Edition ID
CAPS
First Name
Last Name
Firm Name
Address Line
Unit
Extra Address Line
City
County
State
Format x(2)
Country
Zip Code
Zip Extension
Zip Bar Code
Format x(2)
PO Route Type
PO Route Walk Sequence
Format “9999999”
Lot
Format “9999”
Lot Sequence
Delivery Point Usage Code
Format x(1)
Subscriber
Subscription ID
Expire Date
Address ID
Billing Method
Additional fields for single copy routes
Route ID
Draw Total
Publication Firm Name
Publication Name
Publishing Date
Publication Address
Publication Unit
Publication Extra Line
Publication City
Publication State
Publication ZIP
Publication ZIP Extension
Publication Delivery Point Bar Code
USPS Number
Truck ID
Truck Name
Truck Drop Order
Relay Info (4 fields)
Format x(30)
Bundle Info (4 fields)
Format x(30)
Route Drop Location
Route Drop Instructions
Truck Drop Location (4 fields)
Format x(30)
Truck Drop Instructions (4 fields)
Format x(30)