# Collectech Export Format

{% hint style="info" %}
**Note:**

*The Collectech interface requires a separate license fee to use. Contact the Naviga Support Center for details.*
{% endhint %}

**File type:** Fixed length. Active, stopped and paid will be exported to separate files.

**Location:** `/dti/exchange/cm`. The file name is user-defined, and the name will be appended with “active”, “stop” or “paid”.

### Active and Stopped Subscribers

<table><thead><tr><th width="222.62962962962962">Field</th><th width="150">Length</th><th width="325">Contents</th></tr></thead><tbody><tr><td>Account Number</td><td>25</td><td>Subscription account number</td></tr><tr><td>Responsible Party</td><td>30</td><td>Subscriber’s name (last name, first name). If subscription has bill-to occupant, then bill-to name is exported here</td></tr><tr><td>Account Name</td><td>30</td><td>If subscription has bill-to occupant, then delivery occupant name is exported here (otherwise blank)</td></tr><tr><td>Address Line 1</td><td>30</td><td>Subscriber’s street address. If subscription has bill-to address, then bill-to street address is used</td></tr><tr><td>Address Line 2</td><td>30</td><td>Second line of street address, if applicable</td></tr><tr><td>City</td><td>15</td><td>Address city</td></tr><tr><td>State</td><td>2</td><td>Address state</td></tr><tr><td>ZIP</td><td>9</td><td>Address ZIP Code, including ZIP + 4</td></tr><tr><td>Phone Number</td><td>10</td><td>Subscriber’s phone number, including area code. If subscription has bill-to occupant, bill-to is exported</td></tr><tr><td>Filler</td><td>1</td><td>This will be “0”</td></tr><tr><td>Social Security</td><td>9</td><td>This will be blank</td></tr><tr><td>Date of Last Payment</td><td>6</td><td>Last payment received for subscription, format YYMMDD</td></tr><tr><td>Date of Last Charge</td><td>6</td><td>This will be zeros</td></tr><tr><td>Balance 1</td><td>9</td><td>Cost of subscription for payment term entered (active subscribers) or grace owed amount (perm stopped subscribers). The last two digits will be decimals</td></tr><tr><td>Filler</td><td>1</td><td>This will be “+”</td></tr><tr><td>Balance 2</td><td>9</td><td>This will be zeros</td></tr><tr><td>Filler</td><td>1</td><td>This will be “+”</td></tr><tr><td>Balance 3</td><td>9</td><td>This will be zeros</td></tr><tr><td>Filler</td><td>1</td><td>This will be “+”</td></tr><tr><td>Descriptor Code 1 &#x26; 2</td><td>2</td><td>These fields will be blank</td></tr></tbody></table>

### Paid Subscribers

<table data-header-hidden><thead><tr><th width="231.1523220166648"></th><th width="150"></th><th width="325"></th></tr></thead><tbody><tr><td>Field</td><td>Length</td><td>Contents</td></tr><tr><td>Account Number</td><td>25</td><td>Subscription account number</td></tr><tr><td>Payment Amount</td><td>8</td><td>Amount of last payment. The last two digits are decimals</td></tr></tbody></table>
