Import/Export 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

Attachment Fields

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

Attachment Field Types
Field	Record	Field index	Sub index	Type	Width	Description
Class	Attachment	0	33	Integer	4	Category for attachment
Type	Attachment	1	33	Integer	4	Further categorization for attachment
Description	Attachment	2	33	String	131	Description of attachment
Index 1	Attachment	3	33	String	31	Indexed Information for quick access
Index 2	Attachment	4	33	String	31	Indexed Information for quick access
Date 1	Attachment	5	33	Long	8	Indexed date for quick access
Date 2	Attachment	6	33	Long	8	Indexed date for quick access
Date 3	Attachment	7	33	Long	8	Non-indexed date field
Value	Attachment	8	33	Integer	5	Numeric user field
Factor	Attachment	9	33	Integer	5	Numeric user field
Credits	Attachment	10	33	Double	13	Currency user field
Debits	Attachment	11	33	Double	13	Currency user field
Result	Attachment	12	33	Double	13	Numeric user field
User 8	Attachment	13	33	String	31	User field
User 9	Attachment	14	33	String	31	User field
User 10	Attachment	15	33	String	31	User field
User 11	Attachment	16	33	String	31	User field
User 12	Attachment	17	33	String	31	User field
User 13	Attachment	18	33	String	31	User field
User 14	Attachment	19	33	String	31	User field
User 15	Attachment	20	33	String	63	User field
User 16	Attachment	21	33	String	63	User field
User 17	Attachment	22	33	String	63	User field
User 18	Attachment	23	33	String	63	User field
User 19	Attachment	24	33	String	63	User field
User 20	Attachment	25	33	String	64	User field
User 21	Attachment	26	33	String	31	User field
File	Attachment	27	33	String	260	Stores the path of a file
Created	Attachment	28	33	Long	8	*** Internal Use Only
Created By	Attachment	29	33	String	3	*** Internal Use Only
Modified	Attachment	30	33	Long	8	*** Internal Use Only
Modified By	Attachment	31	33	String	3	*** Internal Use Only
UID	Attachment	54	33	Long	7	*** Internal Use Only
Cby	Attachment	56	33	String	7	*** Internal Use Only
Mby	Attachment	57	33	String	7	*** Internal Use Only
Category	Attachment	58	33	Integer	4	Category field
Category 1	Attachment	59	33	Integer	4	Category field
Category 2	Attachment	60	33	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
*Debtor	Attachment	45	33	String	62	Debtor
*Client	Attachment	46	33	Long	8	Client
*Home	Attachment	47	33	String	23	Debtor's home phone
*Work	Attachment	48	33	String	14	Debtor's work phone
*Cl Acct	Attachment	49	33	String	31	Client account number
*Debtor file number	Attachment	50	33	Long	9	Debtor's file number
*Contact	Attachment	51	33	String	62	Debtor's contact
*DL	Attachment	52	33	String	31	Debtor's driver's license
*SSN	Attachment	53	33	String	31	Debtor's social number

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.

Attachment Fields

See Also