Transaction data enables CRB to collect interest based on an adjusted loan balance.
The table below is the transaction reference information for the files.
- File format is CSV.
- Naming convention: MplId_TransactionTape_yyyymmdd.csv, where yyyymmdd is the date of file generation.
- File should contain prior day transactions.
- Make sure to provide a list of possible TransactionCodes and SourceCodes.
- This file should include all borrower payments, payment reversals, cancelations, refunds, charge offs, loan modifications, and fee assessments.
Unique identifier for the loan transaction.
Unique identifier for the loan.
Date of the transaction event.
An identifier used to describe the method of the transaction.
A description that correlates to the source_code identifier.
Personal check, money order, and AutoPay
An identifier used to describe the type of transaction.
11100 - 90001
A description that correlates to the trans_code identifier.
Boarding, scheduled payment, AutoPay fee payment, refund, cancelation
The gross transaction amount.
If the transaction was cash or not.
0 - Cash payment
A code that indicates the reason for a transaction reversal.
0 - Original transaction
A description that indicates the reason for reversal.
ACH return, bounced check or other
The date the transaction affected the loan.
The date the funds are remitted to CRB.
The balance prior to the transaction.
Amount of the transaction paid to the loan principal.
Amount of the transaction paid to interest.
Amount of the transaction paid to late fees.
Remaining balance after the transaction was applied.
Date the next payment is due on the loan.
Open field for text for an agent.
Examples: Boarding transaction, zero-order-hold, balance due to pay off
Updated about 13 hours ago