- Contents
Exchange Manager Help
Customer Notes Table
The Customer Notes table contains debtor notes regarding accounts. Each account can have multiple note 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 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 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 |
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 |