| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Conditions |
1 | FICOC_COND_USER | Condition Type: User Information | 11 | T_CHANGETIME | Changed at | nvarchar | 6 | 0 | | |
2 | FICOT_AMT | Amount Table (Obsolete; Not used for persistency) | 73 | T_CHANGETIME | Changed at | nvarchar | 6 | 0 | | |
3 | FICOT_CONDI | Conditions (Unbuffered) | 115 | T_CHANGETIME | Changed at | nvarchar | 6 | 0 | | |
4 | FICOT_CONDI_BUFF | Conditions (Buffered) | 115 | T_CHANGETIME | Changed at | nvarchar | 6 | 0 | | |
5 | FICOT_DATE | Date (Obsolete; Not used for persistency) | 53 | T_CHANGETIME | Changed at | nvarchar | 6 | 0 | | |
6 | FICOT_FCTRL_PER | Rules of Condition Set of Rules | 13 | T_CHANGETIME | Changed at | nvarchar | 6 | 0 | | |
TOPPortfolio |
7 | VDCOT | Condition Table | 15 | T_CHANGETIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | | |
8 | VDCOT_VER | Versions of Condition Tables | 21 | T_CHANGETIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | | |
9 | VDCO_PRO_ASS1 | Assignment: Product + Parameters ---> Condition Table | 23 | T_CHANGETIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | | |
10 | VDCO_PRO_ASS2 | Assignment: Product ---> Condition Table | 21 | T_CHANGETIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | | |