Contents

Phones Master Table

The Phones Master table contains phone information for accounts. Each account can have multiple phone records. To ensure that Exchange locates the correct debtor on the account, you must map the debtor 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 maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.	4	Integer	Master/Number	M
PhoneType	Code that identifies the type of phone number.	4	Integer	None	M
Relationship	Relationship to the account. If you selected "Relationship" as the unique debtor criteria, you must map this field.	50	VarChar	Debtors/Relationship	M
PhoneStatus	Code that identifies the status of the phone number.	4	Integer	None	M
OnHold	Flag that indicates whether the phone number is on hold. 1 = Yes 0 = No	1	Bit	None	M
PhoneNumber	Debtor's phone number, including country code and extension.	30	VarChar	None	M
PhoneExt	Debtor's telephone extension number.	10	VarChar	None	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	M
DateAdded	Date the user added the phone number to the account.	8	DateTime	None	M
RequestID	Code that Latitude assigned to identify a vendor service request for the account.	4	Integer	ServiceHistory/RequestID	M
PhoneName	Name of the debtor associated to the phone number.	50	VarChar	None	M
LoginName	User ID of the person who added the phone number to the account.	10	VarChar	None	M

Phones Master Table

Related Topics