mass2one Export Format
Note: The mass2one interface requires a separate license fee to use. Contact the Naviga Support Center for details.
File type: tab-delimited.
Location: /dti/exchange/cm. The file name is user-defined.
Subscriber ID
Subscriber’s account ID. Blank for non-subscribers.
9999999999
Occupant ID
Subscriber’s occupant ID.
9999999999
Product ID
Subscriber’s product. Blank for non-subscribers.
x(8)
First Name
Occupant’s first name
x(12)
Last Name
Occupant’s last name
x(30)
Address Line 1
House number, street name, street type and any pre-directional or post directional
x(30)
Address Line 2
Unit designator and unit number
x(30)
City
Occupant’s city
x(28)
State
Occupant’s state or province ID
x(2)
ZIP Code
Occupant’s ZIP, including ZIP extension
99999-9999
Phone
Occupant’s phone, including area code
999-999-9999
House #
Occupant’s address information
x(10)
House # Modifier
Occupant’s address information
x(3)
Predirectional
Occupant’s address information
x(2)
Street Name
Occupant’s address information
x(28)
Street Suffix
Occupant’s address information
x(7)
Post Directional
Occupant’s address information
x(2)
Unit Type
Occupant’s address information
x(6)
Unit Number
Occupant’s address information
x(8)
Latitude
Occupant’s address information
999.999999
Longitude
Occupant’s address information
999.999999
PO route Type
Occupant’s address information
x
PO Route Number
Occupant’s address information
999
PO Route Sequence
Occupant’s address information
99999
Email Address
Occupant’s e-mail
unlimited
Subscriber Status
Occupant’s subscriber status: active, former, never or temp stopped
x(30)
Delivery Schedule
Subscriber’s delivery schedule (blank for non-subscribers)
x(8)
Start Date
Date of subscriber’s current (last) start date (blank for non-subscribers)
99/99/9999
Expire Date
Current expire date for office pay subscribers (blank for all other occupants)
99/99/9999
Original Start Date
Date of subscriber’s original start (blank for non-subscribers)
99/99/9999
Start Source Code
Source code for current start (blank for non-subscribers)
x(8)
Start Reason Code
Reason code for current start (blank for non-subscribers)
x(8)
Payment Type
Payment method for active or temp stopped subscribers (blank for non-subscribers or former subscribers). Possible values are: office pay, carrier collect, auto pay bank draft, auto pay credit card, Auto Pay PayPal, paid complimentary, unpaid complimentary
x(20)
Route (7 fields)
Occupant’s route ID for each day of the week, or “mail” if mail-delivered
x(8)
Billing Method
Billing method for active or temp stopped subscribers (blank for non-subscribers or former subscribers). Possible values are: office pay, carrier collect, paid complimentary, unpaid complimentary
x(20)
Last Complaint Date
Date of occupant’s last complaint
99/99/9999
Last Complaint Reason
Reason code of occupant’s last complaint
x(8)
Perm Stop Date
Last perm stop date for former subscribers (blank for all others)
99/99/9999
Perm Stop Source
Source code for the perm stop.
x(8)
Perm Stop Reason
Reason code for former subscriber’s last perm stop (blank for all others)
x(8)
Temp Stop Date
If temp stopped, stop date for current temp stop (blank for all others)
99/99/9999
Temp Stop Source
Source code for the temp stop.
x(8)
Temp Stop Reason
If temp stopped, reason code for current temp stop (blank for all others)
x(8)
Restart Date
If temp stopped, restart date for current temp stop, if known (blank for all others)
99/99/9999
Last Payment Length and Term
If office pay, payment length and term of last payment (blank for all others)
x(12)
Last Payment Date
If office pay, date of last payment (blank for all others)
99/99/9999
Rate Code ID
Subscriber’s rate code.
x(20)
“Do not Email” Indicator
If the occupant is assigned a solicitation code entered for the export, this will be set to “yes”; otherwise, “no”
yes/no
Last updated
