| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInformation System |
| 1 | AIS_FORMULA_ADM | Customizing of Formulas in AIS | 10 | DINTERVAL | Yield Period | nvarchar | 1 | 0 | | |
| TOPPortfolio Analyzer |
| 2 | AFWKFPA_PRDFLW | Key Figures: Flow for Period in Transaction Currency | 4 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 3 | AFWKFPA_PRDFLWCC | Key Figures: Flow for Period in Evaluation Currency | 4 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 4 | AFWKFPA_YLD | Key Figures: Yield Calculated from Transaction Currency | 6 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 5 | AFWKFPA_YLDCC | Key Figures: Yield Calculated from Evaluation Currency | 6 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 6 | AFWKF_PRDFLWCC_H | Key Figures: Flow for Period in Evaluation Currency | 5 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 7 | AFWKF_PRDFLW_H | Key Figures: Flow for Period in Transaction Currency | 5 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 8 | AFWKF_YLDCC_H | Key Figures: Yield Calculated from Evaluation Currency | 7 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 9 | AFWKF_YLD_H | Key Figures: Yield Calculated from Transaction Currency | 7 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
| 10 | PFA_DINTERVALS | TRM-PA: Time Intervals for Period-Based Key Figures | 2 | DINTERVAL | Time Interval for Period-Based Key Figures | nvarchar | 10 | 0 | | |
