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

Field	Length	Contents
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