Feedback

  • Contents
 

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

Email

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

Related Topics

Destination Fields