Database – Disbursement Entity (disbursement_entity)
Holds information about escrow disbursement.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
account_type | char(32) | Associated account type | ||
account_id | int(11) | ID of the account that the task is running on | ||
escrow_subset_id | int(11) | Escrow subset id | ||
date | date | Disbursement date | ||
estimated_amount | decimal(11,2) | Estimated disbursement amount | ||
last_payment_date | date | last payment date | ||
last_payment_amount | decimal(11,2) | last payment amount | ||
actual_amount | decimal(11,2) | Actual amount | ||
recurring_frequency | char(64) | autopay recurring frequency | autopay.recurringFrequency.* | |
next_payment_date | date | next payment date | ||
next_payment_amount | decimal(11,2) | next payment amount | ||
memo | text | Memo | ||
vendor_id | int(11) | associated vendor id | ||
category_id | int(11) | Associated category id | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |