Database – Loan Chargeoff Transaction (loan_chargeoff__transactions)
Holds information concerning which payments/credits attached to a loan count as chargeoff payments, and by how much they are considered chargeoff payments.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
entity_id | int(11) | ID of the associated entity | ||
entity_type | varchar(100) | Type of the associated entity | ||
payment_id | int(11) | Associated payment id | ||
credit_id | int(11) | Associated credit id | ||
date | date | Transaction date | ||
type | char(30) | Transaction type | ||
charge_off_amount | decimal(11,2) | Charge off amount | ||
recovery_amount | decimal(11,2) | recovery amount | ||
charge_off_balance | decimal(11,2) | charge off balance | ||
sort_order | int(11) | sort order | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |