Show Hide

 

Feedback

  • Contents
 

Phones Table

The Phones table contains phone information for accounts. Each account can have multiple phone records. To ensure that Exchange locates the correct customer on the account, you must map the customer 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.

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 associated to the phone number. If you selected "Debtor ID" as the unique debtor criteria, you must map this field.

4

Integer

Debtors/DebtorID

NB, M

SH_RequestID

Code that Latitude assigned to identify a vendor service request for the account.

4

Integer

ServiceHistory/RequestID

NB, M

Relationship

Relationship to the account. If you selected "Relationship" as the unique debtor criteria, you must map this field.

50

VarChar

Debtors/Relationship

NB, M

Name

Debtor name. If you selected "Name" as the unique debtor criteria, you must map this field.

300

VarChar

Debtors/Name

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

Debtors/SEQ

NB, M

SSN

Debtor's social security number. If you selected "SSN" as the unique debtor criteria, you must map this field.

15

VarChar

Debtors/SSN

NB, M

PhoneTypeID

Code that identifies the type of phone number.

4

Integer

None

NB, M

PhoneStatusID

Code that identifies the status of the phone number.

4

Integer

None

NB, M

OnHold

Flag that indicates whether the phone number is on hold.

1 = Yes

0 = No

1

Bit

None

NB, M

PhoneNumber

Debtor's phone number, including country code and extension.

30

VarChar

None

NB, M

PhoneExt

Debtor's telephone extension number.

10

VarChar

None

NB, M

PhoneName

Name of the debtor associated to the phone number.

50

VarChar

None

NB, M

Source

Source who provided the phone number, such as debtor, customer, or credit bureau.

255

VarChar

None

NB, M

Related Topics

Destination Fields