Feedback

  • Contents
 

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
1 or greater = Secondary customer information

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

Related Topics

Destination Fields