loan_active_time_tx - 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

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


How did we do?


Powered by HelpDocs (opens in a new tab)