- Contents
AIM Help
Status and Notes Import File Record
Delimited/fixed record type = ASTS
Excel worksheet name = StatusRecord
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = ASTS |
Debtor ID |
5-13 |
2 |
debtor_number |
Integer (9) |
Unique number assigned to each debtor record. |
File Number |
14-22 |
3 |
file_number |
Integer (9) |
Unique number assigned to each account placed. Use this value for all data sent to AIM. |
Status |
23-25 |
4 |
status |
String (3) |
Code that identifies the status of the account. This code must exist in the receiving organization's system. |
Note |
26-100 |
5 |
note |
String (75) |
Note text to include for the status change. |
Note Date |
101-108 |
6 |
note_date |
DateTime (CCYYMMDD) |
Note creation date. For Excel file, use date/time format (for example, 6/20/2008 10:30:00 AM). |
Notification |
109-111 |
7 |
notification |
String (3) |
Notification queue to send account for action. This queue level must exist in the receiving organization's system. |