Table: Loan Active Time Transactions

Table: Loan Active Time Transactions

Holds transaction information spanning a period of time in which the loan was active.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
entity_idint(11)ID of the associated entity
entity_typevarchar(100)Type of the associated entity
tx_idchar(40)Transaction ID
datedatetimeDisbursement date
periodint(11)transaction period
period_startdateTransaction period start
period_enddateTransaction period end
titlevarchar(255)The name/title of the entity instance
typechar(20)Identifier for the entity type
charge_amountdecimal(10,2)amount charge
charge_idecimal(10,2)charge interest
charge_pdecimal(10,2)charge principal
charge_ddecimal(10,2)charge discount
charge_fdecimal(10,2)charge fees
charge_edecimal(10,2)charge escrow
charge_e_breakdownvarchar(2000)charge escrow breakdown
adb_daysint(11)Average Daily Balance Days
adbdecimal(10,2)Average Daily Balance
principal_balancedecimal(10,2)principal balance
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List