Feedback

  • Contents
 

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.

Related Topics

Payments Import File Layout

Import File Layouts