Payments Export File Record

Fixed record type = CPAY

Excel worksheet name = PayHistory

Note: For more information about the Paid3 through Paid9 fields, see your agency coordinator.

Latitude	Position	Col	Column Name	Format	Comment
PayHistory Record	1-4	1	record_type	String (4)	Value = CPAY
Number	5-13	2	file_number	Integer (9)	Unique number assigned to each account placed. Use this value for all data sent to AIM.
Master.Account	14-43	3	account	String (30)	Account number that the creditor assigned to this account.
Paid1	44-55	4	principal	Decimal (12)	Amount of principal included in the payment.
Paid2	56-67	5	interest	Decimal (12)	Amount of interest included in the payment.
Paid3	68-79	6	other3	Decimal (12)	Other amounts included in the payment.
Paid4	80-91	7	other4	Decimal (12)	Other amounts included in the payment.
Paid5	92-103	8	other5	Decimal (12)	Other amounts included in the payment.
Paid6	104-115	9	other6	Decimal (12)	Other amounts included in the payment.
Paid7	116-127	10	other7	Decimal (12)	Other amounts included in the payment.
Paid8	128-139	11	other8	Decimal (12)	Other amounts included in the payment.
Paid9	140-151	12	other9	Decimal (12)	Other amounts included in the payment.
DatePaid	152-159	13	payment_date	DateTime (CCYYMMDD)	Date AIM processed the payment.
BatchType	160-162	14	batch_type	String (3)	Type of payment batch.
Payhistory.UID	163-192	15	payment_identifier	String (30)	Unique code that identifies the payment.
Comment	193-222	16	comment	String (30)	Description of the payment transaction.