Table: Escrow Transaction Metadata

Table: Escrow Transaction Metadata

Provides a many-to-many mapping between escrows and transactions.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
loan_idint(11)The id of the associated loan account
tx_idchar(30)Transaction ID
subsetint(11)Escrow subset id
categoryint(11)Transaction category
descriptionvarchar(255)The description of the entity instance
datedatedate
typechar(30)transaction type
from_paymenttinyint(1)Whether or not from a loan payment1 - yes, 0 - no
escrow_transaction_idint(11)associated escrow transaction id
deposit_amountdecimal(11,2)deposit amount
withdrawal_amountdecimal(11,2)withdrawal amount
balancedecimal(11,2)Ending balance
sort_orderint(11)sort order
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List