- Contents
Exchange Manager Help
Customer Notes Table
The Customer Notes table contains customer notes regarding accounts. Each account can have multiple note 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 |
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 |
NoteDate |
Date a user added the note. |
8 |
DateTime |
None |
NB, M |
NotText |
Note content. |
255 |
Char |
None |
NB, M |