escrow_transaction_entity - Escrow Transaction

Holds transaction information for escrow buckets (withdrawals or deposits)

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

subset

int(11)

Escrow subset id

category

int(11)

Transaction category

description

varchar(255)

The description of the entity instance

date

date

Transaction date

type

char(30)

Transaction type

transaction.type.deposit, transaction.type.withdrawal

amount

decimal(11,2)

Amount of transaction

vendor_id

int(11)

associated vendor id

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)