Database – Loan Credit Entity (loan_credit_entity)
Description
Holds credit information for a loan
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 | ||
import_id | varchar(15) | Payment account import ID | ||
mod_id | int(11) | The id of the associated loan modification | ||
title | varchar(255) | The name/title of the entity instance | ||
date | date | credit date | ||
amount | decimal(11,2) | Charge amount | ||
category | int(11) | credit category | ||
payment_type | int(11) | payment type | ||
custom_application | varchar(500) | custom application | ||
reset_past_due | tinyint(1) | reset days past due | 1 - yes, 0 - no | |
apd_adjustment_id | int(11) | associated apd adjustment id | ||
dpd_adjustment_id | int(11) | associated dpd adjustment id | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |