Import/Export Client Attachment 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 Attachment Fields

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

Client Attachment Field Types
Field	Record	Field index	Sub index	Type	Width	Description
Class	Client Attachment	0	190	Integer	4	Category for attachment
Type	Client Attachment	1	190	Integer	4	Further categorization for attachment
Description	Client Attachment	2	190	String	127	Description of attachment
Index 1	Client Attachment	3	190	String	63	Indexed Information for quick access
Index 2	Client Attachment	4	190	String	63	Indexed Information for quick access
Date 1	Client Attachment	5	190	Long	8	Indexed date for quick access
Date 2	Client Attachment	6	190	Long	8	Indexed date for quick access
Date 3	Client Attachment	7	190	Long	8	Non-indexed date field
Value	Client Attachment	8	190	Integer	5	Numeric user field
Factor	Client Attachment	9	190	Integer	5	Numeric user field
Credits	Client Attachment	10	190	Double	13	Currency user field
Debits	Client Attachment	11	190	Double	13	Currency user field
Result	Client Attachment	12	190	Double	13	Numeric user field
User 8	Client Attachment	13	190	String	63	User field
User 9	Client Attachment	14	190	String	63	User field
User 10	Client Attachment	15	190	String	63	User field
User 11	Client Attachment	16	190	String	63	User field
User 12	Client Attachment	17	190	String	63	User field
User 13	Client Attachment	18	190	String	63	User field
User 14	Client Attachment	19	190	String	63	User field
User 15	Client Attachment	20	190	String	63	User field
User 16	Client Attachment	21	190	String	63	User field
User 17	Client Attachment	22	190	String	63	User field
User 18	Client Attachment	23	190	String	63	User field
User 19	Client Attachment	24	190	String	63	User field
User 20	Client Attachment	25	190	String	63	User field
User 21	Client Attachment	26	190	String	63	User field
File	Client Attachment	27	190	String	260	Stores the path of a file
Created	Client Attachment	28	190	Long	8	*** Internal Use Only
Created By	Client Attachment	29	190	String	3	*** Internal Use Only
Modified	Client Attachment	30	190	Long	8	*** Internal Use Only
Modified By	Client Attachment	31	190	String	3	*** Internal Use Only
UID	Client Attachment	49	190	Long	7	*** Internal Use Only
Cby	Client Attachment	50	190	String	7	*** Internal Use Only
Mby	Client Attachment	51	190	String	7	*** Internal Use Only
Category	Client Attachment	52	190	Integer	4	Category field
Category 1	Client Attachment	53	190	Integer	4	Category field
Category 2	Client Attachment	54	190	Integer	4	Category field

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
*Client	Client Attachment	45	190	String	62	Client
*Client Number	Client Attachment	46	190	Long	8	Client's file number
*Phone	Client Attachment	47	190	String	14	Client's phone number
*Contact	Client Attachment	48	190	String	62	Client 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.

Client Attachment Fields

See Also