Database – Holding Account Archive Info (holding_account_archive_entity)
Holds archived information for holding accounts.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
holding_account_id | int(11) | Holding Account ID | ||
date | date | Date of archival. | ||
status | varchar(255) | Status code of the entity | ||
sub_status | varchar(255) | holding account sub status | ||
groups | text | group information | ||
balance | decimal(11,2) | Archived holding account balance. | ||
balance_diff | decimal(11,2) | holding account difference | ||
stream_positions_count | int(11) | stream positions count | ||
stream_total_principal_balance | decimal(11,2) | stream total balance (principal) | ||
stream_total_discount | decimal(11,2) | stream total discount | ||
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 |