Note:
The Collectech interface requires a separate license fee to use. Contact the Naviga Support Center for details.
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”.
Account Number
25
Subscription account number
Responsible Party
30
Subscriber’s name (last name, first name). If subscription has bill-to occupant, then bill-to name is exported here
Account Name
30
If subscription has bill-to occupant, then delivery occupant name is exported here (otherwise blank)
Address Line 1
30
Subscriber’s street address. If subscription has bill-to address, then bill-to street address is used
Address Line 2
30
Second line of street address, if applicable
City
15
Address city
State
2
Address state
ZIP
9
Address ZIP Code, including ZIP + 4
Phone Number
10
Subscriber’s phone number, including area code. If subscription has bill-to occupant, bill-to is exported
Filler
1
This will be “0”
Social Security
9
This will be blank
Date of Last Payment
6
Last payment received for subscription, format YYMMDD
Date of Last Charge
6
This will be zeros
Balance 1
9
Cost of subscription for payment term entered (active subscribers) or grace owed amount (perm stopped subscribers). The last two digits will be decimals
Filler
1
This will be “+”
Balance 2
9
This will be zeros
Filler
1
This will be “+”
Balance 3
9
This will be zeros
Filler
1
This will be “+”
Descriptor Code 1 & 2
2
These fields will be blank
Field
Length
Contents
Account Number
25
Subscription account number
Payment Amount
8
Amount of last payment. The last two digits are decimals