Database – Disbursement Entity (disbursement_entity)
Description
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 |