- 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 |

