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