escrow__transactions - Escrow Transaction Metadata

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

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

loan_id

int(11)

The id of the associated loan account

tx_id

char(30)

Transaction ID

subset

int(11)

Escrow subset id

category

int(11)

Transaction category

description

varchar(255)

The description of the entity instance

date

date

date

type

char(30)

transaction type

from_payment

tinyint(1)

Whether or not from a loan payment

1 - yes, 0 - no

escrow_transaction_id

int(11)

associated escrow transaction id

deposit_amount

decimal(11,2)

deposit amount

withdrawal_amount

decimal(11,2)

withdrawal amount

balance

decimal(11,2)

Ending balance

sort_order

int(11)

sort order

deleted

tinyint(1)

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)