Import/Export Client 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 From Different File Formats Set Default Values For Imports Batch Process Accounts After Importing

Client Contact Fields

These are the Data Fields that are associated with the Client Contacts 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 Client Contact record also contains virtual links which can be used to append the Contact to the correct Client.

Client Contact Field Types
Field	Record	Field index	Sub index	Type	Width	Description
Client	Client Contact	0	177	String	62	Client to be contacted
Type	Client Contact	1	177	Integer	4	Type of contact
Class	Client Contact	2	177	Integer	4	User defined field
Due date	Client Contact	3	177	Long	8	Scheduled date for contact
Time	Client Contact	4	177	Long	8	Scheduled time for contact
Priority	Client Contact	5	177	Integer	2	Priority level of contact
Description	Client Contact	6	177	String	79	Description of contact
Data	Client Contact	7	177	String	39	Metafile attached to contact
Attachment	Client Contact	8	177	String	62	File attached to contact
Collector	Client Contact	9	177	String	6	Operator assigned to contact
Amount	Client Contact	10	177	Double	9	Dollar amount of promise contact
Elapsed	Client Contact	11	177	Long	8	Time spent on the contact
Repeat	Client Contact	12	177	Integer	4	Controls automatically repeating contacts
Number of days	Client Contact	13	177	Integer	4	Repeat contact after this number
Advance overpayments	Client Contact	14	177	Integer	1	Used with Promise payments to breakdown overpayments
Do not autodelete	Client Contact	15	177	Integer	1	Switch to control contact
Do not autocomplete	Client Contact	16	177	Integer	1	Switch to control contact
In progress	Client Contact	17	177	Integer	1	Indicates contact has not been done
Completed	Client Contact	18	177	Integer	1	Indicates contact has been completed
Assigned by	Client Contact	19	177	String	7	Operator who assigned the contact
Done	Client Contact	20	177	Integer	4
Done date	Client Contact	21	177	Long	8	Date contact was done
Done time	Client Contact	22	177	Long	8	Time contact was done
Done by	Client Contact	23	177	String	7	Operator who did the contact
Originator	Client Contact	25	177	String	7	Operator who created the contact
Created date	Client Contact	26	177	Long	8	Date contact was created
Created time	Client Contact	27	177	Long	8	Time contact was created
Estimate	Client Contact	44	177	Long	8	*** Internal Use Only
UID	Client Contact	47	177	Long	7	*** Internal Use Only
Created	Client Contact	48	177	Long	8	*** Internal Use Only
Ctime	Client Contact	49	177	Long	8	*** Internal Use Only
Cby	Client Contact	50	177	String	7	*** Internal Use Only
Modified	Client Contact	51	177	Long	8	*** Internal Use Only
Mtime	Client Contact	52	177	Long	8	*** Internal Use Only
Mby	Client Contact	53	177	String	7	*** Internal Use Only
C1	Client Contact	54	177	Integer	4	Category field
C2	Client Contact	55	177	Integer	4	Category field
C3	Client Contact	56	177	Integer	4	Category field
Blob	Client Contact	57	177	Long		*** Internal Use Only

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	Client Contact	45	177	Long	8	Client's file number
*Home Phone	Client Contact	46	177	String	14	Client's phone number

Notes:

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

Client Contact Fields

See Also