Notes Export File Record

Latitude

Position

Col

Column Name

Format

Comment

Notes Table

1-4

1

record_type

String (4)

Value = CNOT

Number

5-13

2

file_number

Integer (9)

Unique number assigned to each account placed (zero padded). Use this value for all data sent to AIM.

Created

14-27

3

created_datetime

DateTime (CCYYMMDDHHMMSS)

Date and time a user or Latitude created the note.

Action

28-33

4

note_action

String (6)

Action code assigned to the note.

Result

34-39

5

note_result

String (6)

Result code assigned to the note.

Comment

40-339

6

note_comment

String (300)

Comment regarding the note.