Feedback

  • Contents
 

Placement Export File Note Record

Fixed record type = CNOT

Excel worksheet name = Notes

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CNOT

File 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 Date

14-27

3

created_datetime

DateTime (CCYYMMDD)

Date and time a user or Latitude created the note.

Note Action

28-33

4

note_action

String (6)

Action code assigned to the note.

Note Result

34-39

5

note_result

String (6)

Result code assigned to the note.

Note Comment

40-339

6

note_comment

String (300)

Note text.

Filler

340-3000

7

Filler

String (2661)

Filler. Delimited expects reference.

Related Topics

Placements Export File Layout

Export File Layouts