Reconciliation Import File Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = AREC

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)

Account balance at time of placement.

Received Date

56-63

5

received_date

DateTime (CCYYMMDD)

Account placement date. For Excel file, use date/time format (for example, 6/20/2008  10:30:00 AM).

Current Balance

64-75

6

current_balance

Decimal (12)

Current balance of the account.

Last Payment Date

76-83

7

last_payment_date

DateTime (CCYYMMDD

Date of last payment on the account. 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)

Amount of last payment.

Filler

96-126

9

Filler

String (31)

Filler for fixed file layout.