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

Debtor Cosigner Fields

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

Debtor Cosigner Field Types
Field	Record	Field index	Sub index	Type	Width	Description
Class	Debtor Cosigner	0	7	Integer	4	General category of information
Type	Debtor Cosigner	1	7	Integer	4	Relationship to the debtor
Name	Debtor Cosigner	2	7	String	62	Cosigner's name here
Legal entity	Debtor Cosigner	3	7	Integer	15	Legal entity such as Ltd. or Inc.
Contact	Debtor Cosigner	4	7	String	62	Name of the contact person
Generation	Debtor Cosigner	5	7	String	15	Generation of the contact person. (Jr., Sr.,II, III etc.)
Same address as main debtor	Debtor Cosigner	6	7	Integer	1	Indicates same address as debtor
Address	Debtor Cosigner	7	7	String	40	Cosigner's address
Street Number	Debtor Cosigner	8	7	String	11	Street number
OK	Debtor Cosigner	9	7	Integer	1	Indicates address is valid
Address 2	Debtor Cosigner	10	7	String	63	Cosigner's address line 2
City	Debtor Cosigner	11	7	String	31	Cosigner's city
State	Debtor Cosigner	12	7	String	31	Cosigner's state or code
Zip	Debtor Cosigner	13	7	String	15	Cosigner's zip or postal code
Country	Debtor Cosigner	14	7	String	31	Cosigner's country name
Home	Debtor Cosigner	15	7	String	14	Cosigner's home phone
Phone Ext	Debtor Cosigner	16	7	String	7	Cosigner's home phone extension
Work	Debtor Cosigner	17	7	String	14	Cosigner's work phone
Work Extension	Debtor Cosigner	18	7	String	7	Cosigner's work phone extension
Other	Debtor Cosigner	19	7	String	14	Cosigner's alternate phone
Other Extension	Debtor Cosigner	20	7	String	7	Cosigner's alternate phone extension
Cell	Debtor Cosigner	21	7	String	14	Cosigner's cell phone
Cell Ext	Debtor Cosigner	22	7	String	7	Cosigner's cell phone extension
Email	Debtor Cosigner	23	7	String	63	Cosigner's email address
SSN	Debtor Cosigner	24	7	String	31	Cosigner's social security number
DL	Debtor Cosigner	25	7	String	31	Cosigner's driver's license
DOB	Debtor Cosigner	26	7	Long	8	Cosigner's date of birth as MM/DD/YY
Association	Debtor Cosigner	27	7	String	4	Relationship cosigner has to debtor
ECOA	Debtor Cosigner	28	7	String	1	Valid ECOA for CBR
Indicator	Debtor Cosigner	29	7	String	1	Indicator for DBR
Percent	Debtor Cosigner	30	7	Double	8
Amount	Debtor Cosigner	31	7	Double	13	Dollar amount
Timezone	Debtor Cosigner	32	7	Integer	4	Cosigner's Time Zone
User 1	Debtor Cosigner	33	7	String	64	User field
User 2	Debtor Cosigner	34	7	String	64	User field
User 3	Debtor Cosigner	35	7	String	64	User field
User 4	Debtor Cosigner	36	7	String	64	User field
UID	Debtor Cosigner	62	7	Long	7	*** Internal Use Only
C1	Debtor Cosigner	63	7	Integer	4	Category field
C2	Debtor Cosigner	64	7	Integer	4	Category field
C3	Debtor Cosigner	65	7	Integer	4	Category field
Created	Debtor Cosigner	66	7	Long	8	*** Internal Use Only
Cos Ctime	Debtor Cosigner	67	7	Long	8	*** Internal Use Only
Cos Cby	Debtor Cosigner	68	7	String	7	*** Internal Use Only
Modified	Debtor Cosigner	69	7	Long	8	*** Internal Use Only
Cos Mtime	Debtor Cosigner	70	7	Long	8	*** Internal Use Only
Cos Mby	Debtor Cosigner	71	7	String	7	*** 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
*Debtor Name	Debtor Cosigner	53	7	String	62	Debtor associated with cosigner
*Debtor Client	Debtor Cosigner	54	7	Long	8	Debtor's client name
*Debtor Home	Debtor Cosigner	55	7	String	23	Debtor's home phone
*Debtor Work	Debtor Cosigner	56	7	String	14	Debtor's work phone
*Debtor Cl Acct	Debtor Cosigner	57	7	String	31	Debtor's client account number
*Debtor File	Debtor Cosigner	58	7	Long	9	Debtor's file number
*Debtor Contact	Debtor Cosigner	59	7	String	62	Contact person for debtor
*Debtor DL	Debtor Cosigner	60	7	String	31	Debtor's driver's license
*Debtor SSN	Debtor Cosigner	61	7	String	31	Debtor's social security 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.

Debtor Cosigner Fields

See Also