| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinancial Conditions |
| 1 | FICOT_AMTPOS | Amount Item (Obsolete; not used for persistency) | 3 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 2 | FICOT_AMTPOSEXP | Interest Rates and Interest Refs for an Amt Item (Obsolete) | 3 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 3 | FICOT_DATEPOS | Date Item (Obsolete; Not used for persistency) | 3 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 4 | FICOT_FCTRL_PROP | Rules of Condition Set of Rules: Field Properties | 5 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 5 | FICOT_POS | Condition Items (Unbuffered) | 4 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 6 | FICOT_POS_BUFF | Items of the Conditions (Buffered) | 4 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 7 | FICOT_POS_REL | Relationships Between Condition Items | 4 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 8 | FICOT_POS_REL_BU | Relationships Between Condition Items (Buffered) | 4 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| 9 | FICOT_POS_RULE | Condition Item: Formula ID and Text | 4 | I_POSNO | Condition Item Number | nvarchar | 4 | 0 | | |
| TOPPortfolio |
| 10 | VDCOT_V_CON_PO | Condition Items in the Condition Table | 4 | I_POSNO | Number of Condition Item | nvarchar | 4 | 0 | | |
