- ContentsQuick LinksAccount Analysis landing page Accounting landing page AIM help AIM Receiver help Arrangements landing page Batch Processing landing page Custodian help Dashboard help Data Exchange landing page Dialer Campaigns landing page Exchange Manager help Invoices help Latitude help Latitude Console help Letter Console help Letters landing page Link Console help List Builder help Portfolio Manager help Reporting Console help Reporting landing page WorkFlow Designer help Work Queues landing page
AIM Help
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. |