Database – Loan Active Time Transactions (loan_active_time_tx)
Description
Holds transaction information spanning a period of time in which the loan was active.
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 | ||
tx_id | char(40) | Transaction ID | ||
date | datetime | Disbursement date | ||
period | int(11) | transaction period | ||
period_start | date | Transaction period start | ||
period_end | date | Transaction period end | ||
title | varchar(255) | The name/title of the entity instance | ||
type | char(20) | Identifier for the entity type | ||
charge_amount | decimal(10,2) | amount charge | ||
charge_i | decimal(10,2) | charge interest | ||
charge_p | decimal(10,2) | charge principal | ||
charge_d | decimal(10,2) | charge discount | ||
charge_f | decimal(10,2) | charge fees | ||
charge_e | decimal(10,2) | charge escrow | ||
charge_e_breakdown | varchar(2000) | charge escrow breakdown | ||
adb_days | int(11) | Average Daily Balance Days | ||
adb | decimal(10,2) | Average Daily Balance | ||
principal_balance | decimal(10,2) | principal balance | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |