Database – Credit Breakdown Report (credit_breakdown_report)
Updated 2 years ago
Deprecated!
Column | Data Type | Column Info | Value Notes | Other |
entity_id | int(11) | ID of the associated entity | ||
entity_type | varchar(100) | Type of the associated entity | ||
credit_id | int(11) | Associated credit id | ||
apply_date | date | Date of application | ||
payment_date | date | Date the payment was made | ||
payment_amount | decimal(10,2) | payment amount | ||
payment_interest | decimal(10,2) | Amount of payment towards interest | ||
payment_principal | decimal(10,2) | Amount of payment towards principal | ||
payment_discount | decimal(10,2) | Amount of payment towards Discount | ||
payment_fees | decimal(10,2) | Amount of payment towards Fees | ||
payment_escrow | decimal(10,2) | Amount of payment towards Escrow | ||
payment_fees_breakdown | text | JSON of how fees were broken down | ||
posted_by | int(11) | ID of user who made the payment | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |