# mass2one Export Format

{% hint style="info" %}
**Note:** *The mass2one interface requires a separate license fee to use. Contact the Naviga Support Center for details.*
{% endhint %}

**File type:** tab-delimited.

**Location:** `/dti/exchange/cm`. The file name is user-defined.

<table><thead><tr><th width="150">Field</th><th width="362.33333333333337">Description</th><th width="150">Format</th></tr></thead><tbody><tr><td>Subscriber ID</td><td>Subscriber’s account ID. Blank for non-subscribers.</td><td>9999999999</td></tr><tr><td>Occupant ID</td><td>Subscriber’s occupant ID.</td><td>9999999999</td></tr><tr><td>Product ID</td><td>Subscriber’s product. Blank for non-subscribers.</td><td>x(8)</td></tr><tr><td>First Name</td><td>Occupant’s first name</td><td>x(12)</td></tr><tr><td>Last Name</td><td>Occupant’s last name</td><td>x(30)</td></tr><tr><td>Address Line 1</td><td>House number, street name, street type and any pre-directional or post directional</td><td>x(30)</td></tr><tr><td>Address Line 2</td><td>Unit designator and unit number</td><td>x(30)</td></tr><tr><td>City</td><td>Occupant’s city</td><td>x(28)</td></tr><tr><td>State</td><td>Occupant’s state or province ID</td><td>x(2)</td></tr><tr><td>ZIP Code</td><td>Occupant’s ZIP, including ZIP extension</td><td>99999-9999</td></tr><tr><td>Phone</td><td>Occupant’s phone, including area code</td><td>999-999-9999</td></tr><tr><td>House #</td><td>Occupant’s address information</td><td>x(10)</td></tr><tr><td>House # Modifier</td><td>Occupant’s address information</td><td>x(3)</td></tr><tr><td>Predirectional</td><td>Occupant’s address information</td><td>x(2)</td></tr><tr><td>Street Name</td><td>Occupant’s address information</td><td>x(28)</td></tr><tr><td>Street Suffix</td><td>Occupant’s address information</td><td>x(7)</td></tr><tr><td>Post Directional</td><td>Occupant’s address information</td><td>x(2)</td></tr><tr><td>Unit Type</td><td>Occupant’s address information</td><td>x(6)</td></tr><tr><td>Unit Number</td><td>Occupant’s address information</td><td>x(8)</td></tr><tr><td>Latitude</td><td>Occupant’s address information</td><td>999.999999</td></tr><tr><td>Longitude</td><td>Occupant’s address information</td><td>999.999999</td></tr><tr><td>PO route Type</td><td>Occupant’s address information</td><td>x</td></tr><tr><td>PO Route Number</td><td>Occupant’s address information</td><td>999</td></tr><tr><td>PO Route Sequence</td><td>Occupant’s address information</td><td>99999</td></tr><tr><td>Email Address</td><td>Occupant’s e-mail</td><td>unlimited</td></tr><tr><td>Subscriber Status</td><td>Occupant’s subscriber status: active, former, never or temp stopped</td><td>x(30)</td></tr><tr><td>Delivery Schedule</td><td>Subscriber’s delivery schedule (blank for non-subscribers)</td><td>x(8)</td></tr><tr><td>Start Date</td><td>Date of subscriber’s current (last) start date (blank for non-subscribers)</td><td>99/99/9999</td></tr><tr><td>Expire Date</td><td>Current expire date for office pay subscribers (blank for all other occupants)</td><td>99/99/9999</td></tr><tr><td>Original Start Date</td><td>Date of subscriber’s original start (blank for non-subscribers)</td><td>99/99/9999</td></tr><tr><td>Start Source Code</td><td>Source code for current start (blank for non-subscribers)</td><td>x(8)</td></tr><tr><td>Start Reason Code</td><td>Reason code for current start (blank for non-subscribers)</td><td>x(8)</td></tr><tr><td>Payment Type</td><td>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</td><td>x(20)</td></tr><tr><td>Route (7 fields)</td><td>Occupant’s route ID for each day of the week, or “mail” if mail-delivered</td><td>x(8)</td></tr><tr><td>Billing Method</td><td>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</td><td>x(20)</td></tr><tr><td>Last Complaint Date</td><td>Date of occupant’s last complaint</td><td>99/99/9999</td></tr><tr><td>Last Complaint Reason</td><td>Reason code of occupant’s last complaint</td><td>x(8)</td></tr><tr><td>Perm Stop Date</td><td>Last perm stop date for former subscribers (blank for all others)</td><td>99/99/9999</td></tr><tr><td>Perm Stop Source</td><td>Source code for the perm stop.</td><td>x(8)</td></tr><tr><td>Perm Stop Reason</td><td>Reason code for former subscriber’s last perm stop (blank for all others)</td><td>x(8)</td></tr><tr><td>Temp Stop Date</td><td>If temp stopped, stop date for current temp stop (blank for all others)</td><td>99/99/9999</td></tr><tr><td>Temp Stop Source</td><td>Source code for the temp stop.</td><td>x(8)</td></tr><tr><td>Temp Stop Reason</td><td>If temp stopped, reason code for current temp stop (blank for all others)</td><td>x(8)</td></tr><tr><td>Restart Date</td><td>If temp stopped, restart date for current temp stop, if known (blank for all others)</td><td>99/99/9999</td></tr><tr><td>Last Payment Length and Term</td><td>If office pay, payment length and term of last payment (blank for all others)</td><td>x(12)</td></tr><tr><td>Last Payment Date</td><td>If office pay, date of last payment (blank for all others)</td><td>99/99/9999</td></tr><tr><td>Rate Code ID</td><td>Subscriber’s rate code.</td><td>x(20)</td></tr><tr><td>“Do not Email” Indicator</td><td>If the occupant is assigned a solicitation code entered for the export, this will be set to “yes”; otherwise, “no”</td><td>yes/no</td></tr></tbody></table>