Contents

Debtors Table

The Debtors table contains debtors and other parties associated to accounts. Each account can have multiple debtor records. To ensure that Exchange locates the correct debtor on the account, you must map the debtor field that you specified as unique criteria in the Unique Debtor Criteria section of the General tab. For more information, see Specify Unique Debtor Criteria.

Use DEBTORID or NAME to map to the correct debtor record. In the Master table, Exchange only populates the Debtor0 (primary debtor) record.

Field Name	Description	Length	Data Type	Parent Table and Field	Import Types
Number	Code that Latitude assigned to identify the account. For new business imports, don't map this field. For maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.	4	Integer	Master/Number	NB, M
DebtorID	Code that Latitude assigned to identify the debtor. If you selected "Debtor ID" as the unique debtor criteria, you must map this field.	4	Integer	None	NB, M
Seq	Code that indicates whether the debtor is the primary or secondary debtor on the account. If you selected "Seq" as the unique debtor criteria, you must map this field. 0 = Primary debtor 1 or greater = Secondary debtor	4	Integer	Master/Seq	NB, M
Responsible	Flag that indicates whether the person is responsible for the account. 1 = Yes 0 = No	1	Bit	None	NB, M
IsBusiness	Flag that indicates whether the account is a business account. 1 = Yes 0 = No	1	Bit	None	NB, M
BusinessName	Business name. If ISBUSINESS flag = 0, leave this field blank.	50	VarChar	None	NB, M
IsParsed	Flag that indicates whether the name is parsed. 1 = Yes 0 = No	1	Bit	None	NB, M
Name	Debtor name in "lastname, firstname MI suffix" format. If you selected "Name" as the unique debtor criteria, you must map this field.	300	VarChar	None	NB, M
Prefix	Optional name prefix (Mr, Ms, Miss, Mrs, Dr, Prof).	50	VarChar	None	NB, M
FirstName	Debtor's first name.	50	VarChar	None	NB, M
MiddleName	Debtor's middle name.	50	VarChar	None	NB, M
LastName	Debtor's last name.	50	VarChar	None	NB, M
OtherName	Debtor's alternate name.	30	VarChar	None	NB, M
Suffix	Optional name suffix (I, II, III, Jr, Sr).	50	VarChar	Master/other	NB, M
Street1	Debtor's address line 1.	128	VarChar	Master/Street1	NB, M
Street2	Debtor's address line 2.	128	VarChar	Master/Street2	NB, M
City	Debtor's city.	30	VarChar	Master/City	NB, M
State	Code that identifies the customer's state of residence.	3	VarChar	Master/State	NB, M
ZIPCode	Debtor's ZIP Code.	10	VarChar	Master/Zipcode	NB, M
County	Debtor's county of residence.	50	VarChar	None	NB, M
Country	Debtor's country of residence.	50	VarChar	None	NB, M
MR	Flag that indicates whether the address is good. Y = Yes, address is good N = No, address is bad or unknown	1	VarChar	None	NB, M
SSN	Debtor's social security number. If you selected "SSN" as the unique debtor criteria, you must map this field.	15	VarChar	Master/SSN	NB, M
HomePhone	Debtor's home phone number.	30	VarChar	Master/Homephone	NB, M
WorkPhone	Debtor's work phone number.	30	VarChar	Master/Workphone	NB, M
Pager	Debtor's pager number.	20	VarChar	None	NB, M
Fax	Debtor's fax number.	50	VarChar	None	NB, M
OtherPhone1	Not used.	20	VarChar	None	NB, M
OtherPhoneType	Not used.	15	VarChar	None	NB, M
OtherPhone2	Not used.	20	VarChar	None	NB, M
OtherPhone2Type	Not used.	15	VarChar	None	NB, M
OtherPhone3	Not used.	20	VarChar	None	NB, M
OtherPhone3Type	Not used.	15	VarChar	None	NB, M
Email	Debtor's email address.	50	VarChar	None	NB, M
Gender	Debtor's gender. M = Male F = Female U = Unknown N = Neutral C = Company	1	Char	None	NB, M
Language	Debtor's native language.	30	VarChar	None	NB, M
DLNum	Debtor's driver license number.	50	VarChar	None	NB, M
DOB	Debtor's date of birth.	8	DateTime	Master/DOB	NB, M
JobName	Debtor's employer's name.	50	VarChar	None	NB, M
JobAddr1	Debtor's employer's address line 1.	128	VarChar	None	NB, M
JobAddr2	Debtor's employer's address line 2.	128	VarChar	None	NB, M
JobCSZ	Debtor's employer's city, state, and ZIP Code.	50	VarChar	None	NB, M
JobMemo	Note about the debtor's employment.	16	Text	None	NB, M
Spouse	Spouse's name.	50	VarChar	None	NB, M
SpouseHomePhone	Spouse's home phone number.	20	VarChar	None	NB, M
SpouseJobName	Spouse's employer's name.	50	VarChar	None	NB, M
SpouseJobAddr1	Spouse's employer's address line 1.	128	VarChar	None	NB, M
SpouseJobAddr2	Spouse's employer's address line 2.	128	VarChar	None	NB, M
SpouseJobCSZ	Spouse's employer's city, state, and ZIP Code.	50	VarChar	None	NB, M
SpouseWorkPhone	Spouse's work phone number.	20	VarChar	None	NB, M
SpouseJobMemo	Note about the spouse's employment.	16	Text	None	NB, M
SpouseResponsible	Not used.	1	VarChar	None	NB, M
Relationship	Debtor's relationship to the account. If you selected "Relationship" as the unique debtor criteria, you must map this field.	30	VarChar	None	NB, M
USPSKeyLine	Unique code that identifies a mail item.	16	VarChar	None	NB, M
IsHomeOwner	Not used.	1	Bit	None	NB, M
CBRException	Exception that prevents reporting the debtor to the credit bureaus.	2	SmallInt	None	NB, M
CBRExclude	Flag that indicates whether to prevent reporting of the account to the credit bureaus. 1 = Yes 0 = No	1	Bit	None	NB, M
DebtorMemo	Not used.	16	Text	None	NB, M
EarlyTimeZone	Code that identifies the earliest time zone (for example, 5 is Eastern) allowed to call the debtor.	4	Integer	None	NB, M
LateTimeZone	Code that identifies the latest time zone (for example, 5 is Eastern) allowed to call the debtor.	4	Integer	None	NB, M
ObserveDST	Flag that indicates whether the debtor is in a location that observes daylight savings time. 1= Yes 0 = No	1	Bit	None	NB, M
RegionCode	Not used.	2	Char	None	NB, M
TimeZoneOverride	Not used.	1	Bit	None	NB, M
IsAuthorizedAccountUser	Flag that indicates whether the person is an authorized user of the account. 1 = Yes 0 = No	1	Bit	None	NB, M

Debtors Table

Related Topics