Notes Table

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 all other imports, you must map this field to ensure that Exchange Manager locates the correct account.

4

Integer

Master/Number

NB, F, M, R

Created

Date a user or the system created the note creation.

8

DateTime

None

NB, F, M, R

User0

Code that identifies the user who created the note. You must have already created this code in Latitude.

10

VarChar

None

NB, F, M, R

Action

Latitude action code to associate to the note. You must have already created this code in Latitude.

6

VarChar

None

NB, F, M, R

Result

Latitude result code to associate to the note. You must have already created this code in Latitude.

6

VarChar

None

NB, F, M, R

Comment

Content of the note.

256

Text

None

NB, F, M, R