The reports are those that are generated by default and their intention is to provide a complete visibility of the lending core product operation. Below, you will find the list of reports and the fields they include.

Consideration: The following reports are generated via API and saved in a local bucket where, with secure integration, they can be consulted and exported.

1. Loans

Periodicity: daily

Field name	Type	Length	Description
LOAN_ID			Unique ID for each loan.
CUSTOMER_ID			Unique ID for each customer.
OFFER_ID			Unique 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.
TAKEN_AT			Loan request date.
DISBURSED_AT			Loan activation date.
MAXIMUM_PAYMENT_DATE			Maximum payment date.

2. Payments

Periodicity: daily

Field name	Type	Length	Description
PAYMENT_ID			Unique ID for payment.
LOAN_ID			Unique ID for each loan.
CUSTOMER_ID			Unique ID for each customer.
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	Type	Length	Description
LOAN_ID			Unique ID for each loan.
CUSTOMER_ID			Unique ID for each customer.
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.
ADMIN_COST_DEBT			Total amount owed in administration costs.
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	Type	Length	Description
LOAN_ID			Unique ID for each loan.
CUSTOMER_ID			Unique ID for each customer.
OFFER_ID			Unique ID for the associated offer
LOAN_AMOUNT			Amount requested by the customer
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
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.
ADMIN_COST_DEBT			Total amount owed in administration costs.
LOAN_HEALTH_STATUS			Current loan health status: Up to-date, 1 overdue instalment, 1+ overdue installments, Over maximum payment date, Bad debt.
LAST_PAYMENT_DATE			Date of last payment.
MAXIMUM_PAYMENT_DATE			Maximum payment date.
TAKEN_AT			Loan request date.
DISBURSED_AT			Loan activation date.

5. Score

Periodicity: daily

This report includes the Score or credit line assigned by the client to its customers.

Field name	Type	Length	Description
CUSTOMER_ID			Unique ID for each customer.
PRE_APPROVED_AMOUNT			Scoring model result preapproved amount in local currency.
SCORE			Scoring model result assigned to customer. Value between 0 and 1.
PRODUCT_ID			Unique ID for the associated product.
PRODUCT_NAME			Name of the credit product.
SCORE_DATE			Scoring date.