- Contents
Exchange Manager Help
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 Customer 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 customer associated to the phone number. If you selected "Debtor ID" as the unique customer 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 customer criteria, you must map this field. |
50 |
VarChar |
Debtors/Relationship |
NB, M |
Name |
Customer name. If you selected "Name" as the unique customer criteria, you must map this field. |
300 |
VarChar |
Debtors/Name |
NB, M |
Seq |
Code that indicates whether the customer is the primary or secondary customer on the account. If you selected "Seq" as the unique customer criteria, you must map this field. 0 = Primary customer
|
4 |
Integer |
Debtors/SEQ |
NB, M |
SSN |
Customer's social security number. If you selected "SSN" as the unique customer 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 |
Customer's phone number, including country code and extension. |
30 |
VarChar |
None |
NB, M |
PhoneExt |
Customer's telephone extension number. |
10 |
VarChar |
None |
NB, M |
PhoneName |
Name of the customer associated to the phone number. |
50 |
VarChar |
None |
NB, M |
Source |
Source who provided the phone number, such as customer, client, or credit bureau. |
255 |
VarChar |
None |
NB, M |