| 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) | 15 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
2 | FICOT_AMTPOS | Amount Item (Obsolete; not used for persistency) | 4 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
3 | FICOT_AMTPOSEXP | Interest Rates and Interest Refs for an Amt Item (Obsolete) | 5 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
4 | FICOT_CONDI | Conditions (Unbuffered) | 24 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
5 | FICOT_CONDI_BUFF | Conditions (Buffered) | 24 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
6 | FICOT_DATE | Date (Obsolete; Not used for persistency) | 15 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
7 | FICOT_DATEPOS | Date Item (Obsolete; Not used for persistency) | 4 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
8 | FICOT_POS | Condition Items (Unbuffered) | 7 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
9 | FICOT_POS_BUFF | Items of the Conditions (Buffered) | 7 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
10 | FICOT_POS_REL | Relationships Between Condition Items | 7 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
11 | FICOT_POS_REL_BU | Relationships Between Condition Items (Buffered) | 7 | O_STATUS | Status of Validity Period of a Condition | nvarchar | 2 | 0 | | |
TOPPortfolio |
12 | VDCOT | Condition Table | 5 | O_STATUS | Status of Condition Table | nvarchar | 2 | 0 | | |