Lender
Lender reports
This section contains reports for the lender to review and oversee their entire operation.
1. Loans
Periodicity: daily
| Field name | Description |
|---|---|
| LOAN_ID | Unique UUID for each loan. |
| LOAN_REFERENCE | Unique shorter ID for loan. |
| EXTERNAL_LOAN | An identifier used to refer to a loan in an external system. |
| CUSTOMER_ID | Unique ID for each customer. |
| CUSTOMER_REFERENCE | Unique shorter ID for customer. |
| EXTERNAL_CUSTOMER_ID | An identifier used to refer to a user in an external system. |
| AGGREGATOR_EXTERNAL_ID | An identifier used to refer to a aggregator in an external system. |
| AGGREGATOR_NAME | Name of the aggregator where the purchase took place. |
| AGGREGATOR_ID | Unique ID for the aggregator where the purchase took place. |
| AGGREGATOR_REFERENCE | Unique reference ID for the aggregator where the purchase took place. |
| AGGREGATOR_GROUP_ID | Unique ID for the aggregator group of the aggregator. |
| OFFER_ID | Unique ID for the associated offer. |
| OFFER_REFERENCE | Unique reference ID for the associated offer. |
| OFFER_NAME | Name of the credit offer. |
| LOAN_AMOUNT | Amount requested by the customer. |
| LOAN_STATUS | Current loan status: Active, Paid, Cancelled, Frozen, Lost, in dispute |
| NUMBER_INSTALLMENTS | Number of loan installments. |
| INSTALMENT_FRECUENCY | Installment frecuency. |
| INTEREST_RATE | Interest rate (APR). |
| ADMIN_COST | Administration cost amount. |
| REMAINING | Value add by the user in a refinance process |
| TAKEN_AT | Loan request date. |
| DISBURSED_AT | Loan activation date. |
| MAXIMUM_PAYMENT_DATE | Maximum payment date. |
2. Payments
Periodicity: daily
| Field name | Description |
|---|---|
| PAYMENT_ID | Unique ID for payment. |
| PAYMENT_REFERENCE | Unique reference ID for payment. |
| PAYMENT_EXTERNAL_ID | An identifier used to refer to a payment in an external system. |
| LOAN_ID | Unique ID for each loan. |
| LOAN_REFERENCE | Unique reference ID for loan. |
| CUSTOMER_ID | Unique ID for each customer. |
| CUSTOMER_REFERENCE | Unique reference ID for customer. |
| EXTERNAL_LOAN_ID | An identifier used to refer to a loan in an external system. |
| EXTERNAL_CUSTOMER_ID | An identifier used to refer to a user in an external system. |
| AGGREGATOR_EXTERNAL_ID | An identifier used to refer to a aggregator in an external system. |
| AGGREGATOR_NAME | Name of the aggregator where the purchase took place. |
| AGGREGATOR_ID | Unique ID for the aggregator where the purchase took place. |
| AGGREGATOR_REFERENCE | Unique reference ID for aggregator. |
| PAYMENT_TYPE | Type of payment: voluntary or automatic. |
| PAYMENT_STATUS | Current payment status: Successful, Processing, Rejected. |
| TOTAL_AMOUNT | Total payment amount. |
| CAPITAL_AMOUNT | Capital payment amount. |
| INTEREST_AMOUNT | Interest payment amount. |
| TAX_AMOUNT | Tax payment amount. |
| DEFAULT_INTEREST_AMOUNT | Default interest payment amount. |
| COLLECTION_COST_AMOUNT | Administration cost payment amount. |
| ADMIN_COST_AMOUNT | Collection cost payment amount. |
| LOAN_HEALTH_STATUS | Current loan health status: Up to-date, 1 overdue instalment, 1+ overdue installments, Over maximum payment date, Bad debt. |
| PAYMENT_DATE | Payment date. |
| TAKEN_AT | Loan request date. |
| DISBURSED_AT | Loan activation date. |
3. Balance
Periodicity: daily
| Field name | Description |
|---|---|
| LOAN_ID | Unique ID for each loan. |
| LOAN_REFERENCE | Unique reference ID for loan |
| EXTERNAL_LOAN_ID | An identifier used to refer to a loan in an external system. |
| CUSTOMER_ID | Unique ID for each customer. |
| CUSTOMER_REFERENCE | Unique reference ID for customer. |
| EXTERNAL_CUSTOMER_ID | An identifier used to refer to a user in an external system. |
| AGGREGATOR_EXTERNAL_ID | An identifier used to refer to a aggregator in an external system. |
| AGGREGATOR_NAME | Name of the aggregator where the purchase took place. |
| AGGREGATOR_ID | Unique ID for the aggregator where the purchase took place. |
| AGGREGATOR_REFERENCE | Unique reference ID for aggregator. |
| LOAN_TER | Term of the loan |
| LOAN_STATUS | Current loan status: Active, Paid,Cancelled, Frozen, Lost |
| PAYMENT_FRECUENCY | How is the frecuency when a user have to paid their loan |
| NUMBER_INSTALLMENTS | Number of installments choosed by the user |
| LOAN_HEALTH_STATUS | Health status: Up to-date, 1 overdue instalment, 1+ overdue instalment, past due date, bad debt |
| LOAN_AMOUNT | Amount requested by the customer. |
| TOTAL_DEBT | Total debt amount. |
| CAPITAL_DEBT | Total amount owed in capital. |
| INTEREST_DEBT | Total amount owed in interests. |
| TAX_DEBT | Total amount owed in taxes. |
| DEFAULT_INTEREST_DEBT | Total amount owed in overdue interests. |
| COLLECTION_COST_DEBT | Total amount owed in collection costs. |
| COST_DEBT | Total amount owed in costs. |
| REMAINING_DEBT | Value add by the user in a refinance process |
| MAXIMUM_PAYMENT_DATE | Maximum payment date. |
| TAKEN_AT | Loan request date. |
| DISBURSED_AT | Loan activation date. |
4. Past due
Periodicity: daily
This report only includes loans that are currently overdue
| Field name | Description |
|---|---|
| LOAN_ID | Unique ID for each loan. |
| LOAN_REFERENCE | Unique reference ID for loan. |
| EXTERNAL_LOAN_ID | An identifier used to refer to a loan in an external system. |
| CUSTOMER_ID | Unique ID for each customer. |
| CUSTOMER_REFERENCE | Unique reference ID for customer. |
| EXTERNAL_CUSTOMER_ID | An identifier used to refer to a user in an external system. |
| AGGREGATOR_EXTERNAL_ID | An identifier used to refer to a aggregator in an external system. |
| AGGREGATOR_NAME | Name of the aggregator where the purchase took place. |
| AGGREGATOR_ID | Unique ID for the aggregator where the purchase took place. |
| AGGREGATOR_REFERENCE | Unique reference ID for the aggregator where the purchase took place. |
| AGGREGATOR_GROUP_ID | Unique ID of the group of aggregators where the merchants are associated |
| OFFER_ID | Unique ID for the associated offer |
| LOAN_STATUS | Current loan status: Active, Paid,Cancelled, Frozen, Lost |
| LOAN_TERM | Term of the loan |
| PAYMENT_FRECUENCY | How is the frecuency when a user have to paid their loan |
| NUMBER_INSTALLMENTS | Number of installments choosed by the user |
| LOAN_HEALTH_STATUS | Health status: Up to-date, 1 overdue instalment, 1+ overdue instalment, past due date, bad debt |
| LOAN_AMOUNT | Amount requested by the customer |
| TOTAL_DEBT | Total debt amount. |
| CAPITAL_DEBT | Total amount owed in capital. |
| INTEREST_DEBT | Total amount owed in interests. |
| TAX_DEBT | Total amount owed in taxes. |
| DEFAULT_INTEREST_DEBT | Total amount owed in overdue interests. |
| COLLECTION_COST_DEBT | Total amount owed in collection costs. |
| COST_DEBT | Total amount owed in administration costs. |
| LAST_PAYMENT_DATE | Date of last payment. |
| MAXIMUM_PAYMENT_DATE | Maximum payment date. |
| TAKEN_AT | Loan request date. |
| DISBURSED_AT | Loan activation date. |
5. Refinance
| Field name | Description |
|---|---|
| CUSTOMER_ID | Unique ID for each customer. |
| CUSTOMER_REFERENCE | Unique shorter ID for customer. |
| EXTERNAL_CUSTOMER_ID | An identifier used to refer to a user in an external system. |
| AGGREGATOR_NAME | Name of the aggregator where the purchase took place. |
| AGGREGATOR_REFERENCE | Unique reference ID for the aggregator where the purchase took place. |
| AGGREGATOR_EXTERNAL_ID | An identifier used to refer to a aggregator in an external system. |
| AGGREGATOR_ID | Unique ID for the aggregator where the purchase took place. |
| AGGREGATOR_GROUP_ID | Unique ID for the aggregator group of the aggregator. |
| EXTERNAL_ID_PREVIOUS_LOAN | An identifier used to refer to the old loan in an external system |
| LOAN_ID_PREVIOUS_LOAN | An identifier used to refer to the old loan in the system (UUID) |
| REFERENCE_ID_PREVIOUS_LOAN | An identifier used to refer to the old loan in the system with less digits. |
| EXTERNAL_ID_CURRENT_LOAN | An identifier used to refer to the new loan in an external system. |
| LOAN_ID_CURRENT_LOAN | An identifier used to refer to the new loan in the system (UUID) |
| REFERENCE_ID_CURRENT_LOAN | An identifier used to refer to the new loan in the system with less digits. |
| OFFER_ID_PREVIOUS_LOAN | Unique ID for the associated offer. |
| OFFER_REFERENCE_PREVIOUS_LOAN | Unique reference ID for the associated offer. |
| OFFER_NAME_PREVIOUS_LOAN | Name of the credit offer. |
| OFFER_ID | Unique reference ID for the associated offer. |
| OFFER_NAME | Name of the credit offer. |
| TOTAL_AMOUNT_PREVIOUS | The full previous amount (interest, taxes, cost, remaining….) |
| CAPITAL_PREVIOUS | The previous capital amount |
| TOTAL_CHARGES_PREVIOUS | The full charges amount of the previous credit (interest, taxes, cost….) |
| TOTAL_AMOUNT | The full amount (interest, taxes, cost, remaining….) |
| CAPITAL | The new capital amount |
| TOTAL_CHARGES | The full charges amount (interest, taxes, cost, remaining….) |
| REFINANCE_DATE | The date on which a refinaced was approved by the customer. |
6. Debit note
| Field name | Description |
|---|---|
| LOAN_ID | Unique UUID for each loan. |
| LOAN_REFERENCE | Unique shorter ID for loan. |
| EXTERNAL_LOAN_ID | An identifier used to refer to a loan in an external system. |
| TOTAL_AMOUNT | The full amount including taxes of the debit note |
| CAPITAL | The capital amount of the debit note |
| COST | The cost amount of the debit note |
| COST_TAX | The tax associated with the cost amount of the debit note |
| INTEREST | The interest amount of the debit note |
| INTEREST_TAX | The interest tax amount of the debit note |
| DEFAULT_INTEREST | The default interest amount of the debit note |
| DEFAULT_INTEREST_TAX | The tax associated with the default interest amount of the debit note |
| COLLECTION_COST | The collection cost amount of the debit note |
| COLLECTION_COST_TAX | The collection cost tax amount of the debit note |
| DATE | The date on which a purchase was created. |
| ADVANCE | The Value that surpass the credit amount |
7. Credit note
| Field name | Description |
|---|---|
| LOAN_ID | Unique UUID for each loan. |
| LOAN_REFERENCE | Unique shorter ID for loan. |
| EXTERNAL_LOAN_ID | An identifier used to refer to a loan in an external system. |
| TOTAL_AMOUNT | The full amount including taxes of the credit note |
| CAPITAL | The capital amount of the credit note |
| COST | The cost amount of the credit note |
| COST_TAX | The tax associated with the cost amount of the credit note |
| INTEREST | The interest amount of the credit note |
| INTEREST_TAX | The interest tax amount of the credit note |
| DEFAULT_INTEREST | The default interest amount of the credit note |
| DEFAULT_INTEREST_TAX | The tax associated with the default interest amount of the credit note |
| COLLECTION_COST | The collection cost amount of the credit note |
| COLLECTION_COST_TAX | The collection cost tax amount of the credit note |
| DATE | The date on which a purchase was created. |
Updated about 1 month ago