Collectech Export Format
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”.
Active and Stopped Subscribers
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
Paid Subscribers
Field
Length
Contents
Account Number
25
Subscription account number
Payment Amount
8
Amount of last payment. The last two digits are decimals
Last updated
