Acknowledgment Import File Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1 – 4

1

record_type

String (04)

Value = AACK

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.

Account

14 – 43

3

account

String (30)

Account number that the creditor assigned to this account.

Original Balance

44 – 55

4

original_balance

Decimal (12)

Original balance the agency received.

Received Date

56 – 63

5

received_date

DateTime (CCYYMMDD)

Date the agency flagged the account as received.

Current Balance

64 – 75

6

current_balance

Decimal (12)

Current balance held by agency.

Last Payment Date

76 – 83

7

last_payment_date

DateTime (CCYYMMDD)

Last date the agency received payment. For Excel file, use date/time format (for example, 6/20/2008  10:30:00 AM).

Last Payment Amount

84 – 95

8

last_payment_amount

Decimal (12)

Last payment amount the agency received (AIM expects a positive amount).

Filler

96-126

filler

String (31)

Filler for fixed file layout.