- Contents
AIM Help
Payments Import File Record
Fixed record type = APAY
Excel worksheet name = PaymentRecord
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = APAY |
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. |
Payment Amount |
44-55 |
4 |
payment_amount |
Decimal (12) |
Principal payment amount (always a positive amount). |
Payment Date |
56-63 |
5 |
payment_date |
DateTime (CCYYMMDD) |
Date the agency received the payment. For Excel file, use date/time format (for example, 6/20/2008 10:30:00 AM). |
Payment Type |
64-66 |
6 |
payment_type |
String (3) |
Type of payment batch. PA = Payment PAR - Payment reversal |
Payment Identifier |
67-96 |
7 |
payment_identifier |
String (30) |
Unique code that identifies the payment. |
Comment |
97-126 |
8 |
comment |
String (30) |
Description of the payment transaction. |
Payment Amount Bucket 1 |
127-138 |
9 |
payment_amount_bucket1 |
Decimal (12) |
Amount of payment to apply toward money bucket 1. |
Payment Amount Bucket 2 |
139-150 |
10 |
payment_amount_bucket2 |
Decimal (12) |
Amount of payment to apply toward money bucket 2. |
Payment Amount Bucket 3 |
151-162 |
11 |
payment_amount_bucket3 |
Decimal (12) |
Amount of payment to apply toward money bucket 3. |
Payment Amount Bucket 4 |
163-174 |
12 |
payment_amount_bucket4 |
Decimal (12) |
Amount of payment to apply toward money bucket 4. |
Payment Amount Bucket 5 |
175-186 |
13 |
payment_amount_bucket5 |
Decimal (12) |
Amount of payment to apply toward money bucket 5. |
Payment Amount Bucket 6 |
187-198 |
14 |
payment_amount_bucket6 |
Decimal (12) |
Amount of payment to apply toward money bucket 6. |
Payment Amount Bucket 7 |
199-210 |
15 |
payment_amount_bucket7 |
Decimal (12) |
Amount of payment to apply toward money bucket 7. |
Payment Amount Bucket 8 |
211-222 |
16 |
payment_amount_bucket8 |
Decimal (12) |
Amount of payment to apply toward money bucket 8. |
Payment Amount Bucket 9 |
223-234 |
17 |
payment_amount_bucket9 |
Decimal (12) |
Amount of payment to apply toward money bucket 9. |
Payment Method |
235-264 |
18 |
payment_method |
String (30) |
Payment method to use to process the payments. |
Is SIF |
265 |
19 |
is_SIF |
String (1) |
Indicates whether this payment arrangement settles the account in full, regardless of the account balance. |
Fee Amount |
266-277 |
20 |
fee_amount |
Decimal (12) |
Total fees associated to the payment. |
Fee Amount Bucket 1 |
278-289 |
21 |
fee_amount_bucket1 |
Decimal (12) |
Amount of fee to apply toward money bucket 1. |
Fee Amount Bucket 2 |
290-301 |
22 |
fee_amount_bucket2 |
Decimal (12) |
Amount of fee to apply toward money bucket 2. |
Fee Amount Bucket 3 |
302-313 |
23 |
fee_amount_bucket3 |
Decimal (12) |
Amount of fee to apply toward money bucket 3. |
Fee Amount Bucket 4 |
314-325 |
24 |
fee_amount_bucket4 |
Decimal (12) |
Amount of fee to apply toward money bucket 4. |
Fee Amount Bucket 5 |
326-337 |
25 |
fee_amount_bucket5 |
Decimal (12) |
Amount of fee to apply toward money bucket 5. |
Fee Amount Bucket 6 |
338-349 |
26 |
fee_amount_bucket6 |
Decimal (12) |
Amount of fee to apply toward money bucket 6. |
Fee Amount Bucket 7 |
350-361 |
27 |
fee_amount_bucket7 |
Decimal (12) |
Amount of fee to apply toward money bucket 7. |
Fee Amount Bucket 8 |
362-373 |
28 |
fee_amount_bucket8 |
Decimal (12) |
Amount of fee to apply toward money bucket 8. |
Fee Amount Bucket 9 |
374-385 |
29 |
fee_amount_bucket9 |
Decimal (12) |
Amount of fee to apply toward money bucket 9. |
Remit Amount |
386-397 |
30 |
remit_amount |
Decimal (12) |
Amount of the payment remitted. |
Invoice ID |
398-447 |
31 |
invoice_identifier |
String (50) |
Unique code that identifies the invoice that includes the payment. |