Database – Investment Position Entity (investment_position_entity)
Description
Holds information concerning an investment and its position on holding accounts and loans.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
holding_account_id | int(11) | Associated holding account id | ||
loan_id | int(11) | The id of the associated loan account | ||
position_type | char(64) | investment position type | ||
effective_date | date | Effective Date | ||
priority | tinyint(4) | Investment position priority | 1 - yes, 0 - no | |
amount_purchased | decimal(11,2) | Investment position amount purchased for | ||
amount_paid | decimal(11,2) | Investment amount paid | ||
discount_fee | decimal(11,2) | Investment discount fee | ||
discount_calc_type | char(64) | Investment discount calc type | ||
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 |