Feedback

  • Contents
 

Notes Import File Record

Delimited/fixed record type = ANOT

Excel worksheet name = NoteRecord

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = ANOT

File Number

5-13

2

file_number

Integer (9)

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

Created DateTime

14-27

3

created_datetime

DateTime (CCYYMMDDHHMMSS)

Date and time you created the note.

Note Action

28-33

4

note_action

String (6)

Action code associated to the note.

Note Result

34-39

5

note_result

String (6)

Result code associated to the note.

Note Comment

40-339

6

note_comment

String (300)

Comment regarding the not.

Is Private

340

7

is_private

String (1)

Indicates whether the note is private. Only users with the appropriate permissions can view private notes in Latitude.

Related Topics

Notes Import File Layout

Import File Layouts