Database – Holding Account Transaction (holding_account_transaction_entity)
Holds transaction information for a holding account.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
holding_account_id | int(11) | ID of associated holding account | ||
amount | decimal(11,2) | Transaction amount | ||
balance | decimal(11,2) | Remaining balance | ||
type | varchar(100) | Identifier for the entity type | ||
sub_type | char(64) | transaction subtype | ||
category_id | int(11) | Associated category id | ||
date | date | Transaction Date | ||
description | varchar(500) | The description of the entity instance | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |