Database – Escrow Transaction Metadata (escrow__transactions)
Description
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 |