Import/Export Contact Fields

Examples & Tutorials

Use Import/Export Create A Single Record Import Map Create A Fixed Length Import Map Create An Import Map Use A Custom Import Routine Get Help With Import/Export Order Custom Import/Export Routines Attach Credit Reports To Debtor Accounts Import Inter Office Files Import From Different File Formats Set Default Values For Imports Batch Process Accounts After Importing

Contact Fields

These are the Data Fields that are associated with the Contact Record.

Each Data Field has its own FIELD INDEX within the record. Each Data Field has a set maximum character WIDTH as well as the TYPE of data the field can contain.

The Contact record also contains virtual links which can be used to append the Contact to the correct Debtor.

Contact Field Types
Field	Record	Field index	Sub index	Type	Width	Description
Debtor	Contact	0	29	String	62	Debtor to be contacted
Type	Contact	1	29	Integer	4	Type of contact
Due date	Contact	2	29	Long	8	Scheduled date for contact
Time	Contact	3	29	Long	8	Scheduled time for contact
Priority	Contact	4	29	Integer	2	Priority level of contact
Data	Contact	5	29	String	39	Metafile attached to contact
Attachment	Contact	6	29	String	62	File attached to contact
Description	Contact	7	29	String	79	Description of contact
Collector	Contact	8	29	String	7	Operator assigned to contact
Amount	Contact	9	29	Double	9	Dollar amount of promise contact
Elapsed	Contact	11	29	Long	8	Time spent on the contact
Repeat	Contact	12	29	Integer	4	Controls automatically repeating contacts
Number of days	Contact	13	29	Integer	4	Repeat contact after this number
Class	Contact	14	29	Integer	4	User defined field
Advance overpayments	Contact	15	29	Integer	1	Used with Promise payments to breakdown overpayments
Do not autodelete	Contact	16	29	Integer	1	Switch to control contact
No autocomplete	Contact	17	29	Integer	1	Switch to control contact
Record event history	Contact	18	29	Integer	1	Switch to control contact
In progress	Contact	19	29	Integer	1	Indicates contact has not been done
Completed	Contact	20	29	Integer	1	Indicates contact has been completed
Assigned by	Contact	21	29	String	7	Operator who assigned the contact
Done	Contact	22	29	Integer	4
Done date	Contact	23	29	Long	8	Date contact was done
Done time	Contact	24	29	Long	8	Time contact was done
Done by	Contact	25	29	String	7	Operator who did the contact
Status	Contact	26	29	String	8
**Client	Contact	27	29	Long	8	The Client that the Debtor is assigned to
Originator	Contact	28	29	String	7	Operator who created the contact
Created date	Contact	29	29	Long	8	Date contact was created
Created time	Contact	30	29	Long	8	Time contact was created
UID	Contact	53	29	Long	7	*** Internal Use Only
Created	Contact	54	29	Long	8	*** Internal Use Only
Ctime	Contact	55	29	Long	8	*** Internal Use Only
Cby	Contact	56	29	String	7	*** Internal Use Only
Modified	Contact	57	29	Long	8	*** Internal Use Only
Mtime	Contact	58	29	Long	8	*** Internal Use Only
Mby	Contact	59	29	String	7	*** Internal Use Only
C1	Contact	60	29	Integer	4	Category field
C2	Contact	61	29	Integer	4	Category field
C3	Contact	62	29	Integer	4	Category field
Estimate	Contact	63	29	Long	8	*** Internal Use Only
Blob	Contact	64	29	Long		*** Internal Use Only
Create copy on repeat	Contact	65	29	Integer	1	Switch used with repeating contacts
Log repeat to notes	Contact	66	29	Integer	1	Switch used with repeating contacts

Virtual Links	If you use one of these virtual fields in your import, make sure that 'Use as key to find existing' is switched OFF (no check mark).
Field	Record	Field index	Sub index	Type	Width	Description
*File	Contact	46	29	Long	9	Debtor's file number
*Home Phone	Contact	47	29	String	23	Debtor's home phone
*Work Phone	Contact	48	29	String	14	Debtor's work phone
*Client Account #	Contact	49	29	String	31	Debtor's client account number
*Contact	Contact	50	29	String	62	Contact person for debtor
*DL	Contact	51	29	String	31	Debtor's driver's license
*SSN	Contact	52	29	String	31	Debtor's social security number
Copy	Contact	67	29	Integer	1
Number of payments	Contact	68	29	Integer	6
*Date	Contact	0	68	Long	10	Schedule next contact
*Advance on overpayment	Contact	4	68	Integer	1	Schedule next contact
*Operator	Contact	6	68	String	7	Schedule next contact

Notes:

* These fields are fields from related records.
** For efficiency, use only for exporting.
+ Collect! automatically calculates this value from the transactions. Use only for export.

Contact Fields

See Also