- Contents
Exchange Manager Help
Account References Table
The Account References table contains references for accounts. Each account can have multiple reference records.
Field Name |
Description |
Length |
Data Type |
Parent Table and Field |
Import Types |
AccountID |
Code that Latitude assigns to identify the account. Don't map this field. |
4 |
Integer |
Master/Number |
NB |
ReferencesID |
Code that Latitude assigns to identify a reference record on the account. Don't map this field. |
4 |
Integer |
None |
NB |
Address1 |
Reference person's address line 1. |
128 |
VarChar |
None |
NB |
Address2 |
Reference person's address line 2. |
128 |
VarChar |
None |
NB |
City |
Reference person's city. |
30 |
VarChar |
None |
NB |
State |
Reference person's state. |
2 |
VarChar |
None |
NB |
ZIPCode |
Reference person's postal code. |
10 |
VarChar |
None |
NB |
HomePhone |
Reference person's home phone number. |
30 |
VarChar |
None |
NB |
WorkPhone |
Reference person's work phone number. |
30 |
VarChar |
None |
NB |
|
Reference person's email address. |
100 |
VarChar |
None |
NB |
Relationship |
Reference person's relationship to the account. |
100 |
VarChar |
None |
NB |
Prefix |
Optional name prefix (Mr, Ms, Miss, Mrs, Dr, Prof). |
15 |
VarChar |
None |
NB |
FirstName |
Reference person's first name. |
100 |
VarChar |
None |
NB |
MiddleName |
Reference person's middle name. |
100 |
VarChar |
None |
NB |
LastName |
Reference person's last name. |
100 |
VarChar |
None |
NB |
Suffix |
Optional name suffix (I, II, III, Jr, Sr). |
15 |
VarChar |
None |
NB |