| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinancial Conditions |
| 1 | FICOT_AMT | Amount Table (Obsolete; Not used for persistency) | 7 | D_VALIDTO | Valid-Top Date of Condition | nvarchar | 8 | 0 | | |
| 2 | FICOT_CONDI | Conditions (Unbuffered) | 16 | D_VALIDTO | Valid-Top Date of Condition | nvarchar | 8 | 0 | | |
| 3 | FICOT_CONDI_BUFF | Conditions (Buffered) | 16 | D_VALIDTO | Valid-Top Date of Condition | nvarchar | 8 | 0 | | |
| 4 | FICOT_DATE | Date (Obsolete; Not used for persistency) | 7 | D_VALIDTO | Valid-Top Date of Condition | nvarchar | 8 | 0 | | |
| 5 | FICOT_LIST_COND | Assignment Condition List - Condition | 5 | D_VALIDTO | Valid-Top Date of Condition | nvarchar | 8 | 0 | | |
| TOPPortfolio |
| 6 | VDCOT_VER | Versions of Condition Tables | 12 | D_VALIDTO | Valid To | nvarchar | 8 | 0 | | |
| 7 | VDCO_PRO_ASS1 | Assignment: Product + Parameters ---> Condition Table | 14 | D_VALIDTO | Valid To | nvarchar | 8 | 0 | | |
| 8 | VDCO_PRO_ASS2 | Assignment: Product ---> Condition Table | 12 | D_VALIDTO | Valid To | nvarchar | 8 | 0 | | |
