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