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 |