| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/D_PFP_PH_KF | Mapped Key Figure | 4 | KEYFIGURE | InfoObject | nvarchar | 30 | 0 | | |
2 | AFWKFRA_KB4 | Key Figures: MtM with Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
3 | AFWKFRA_KB4_H | Key Figures: MtM with Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
4 | AFWKFRA_KB5 | Key Figures: Cashflow (based on Spot Prices) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
5 | AFWKFRA_KB5_H | Key Figures: Cashflow (based on Spot Prices) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
6 | AFWKFRA_KB6 | Key Figures: Cashflow for Cashflow-at-Risk | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
7 | AFWKFRA_KB6_H | Key Figures: Cashflow for Cashflow-at-Risk | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
8 | AFWKFRA_KBMX | Key Figures: MtM with Market Data Shift | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
9 | AFWKFRA_KBMX_H | Key Figures: MtM with Market Data Shift | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
10 | AFWKFRA_KCFARC | Key Figures: CfaR by variance/covariance | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
11 | AFWKFRA_KCFARC_H | Key Figures: CfaR by variance/covariance | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
12 | AFWKFRA_KCFARS | Key Figures: CfaR from simulation method | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
13 | AFWKFRA_KCFARS_H | Key Figures: CfaR from simulation method | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
14 | AFWKFRA_KCFO | Key Figures: Cashflow (in original currency) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
15 | AFWKFRA_KCFO_H | Key Figures: Cashflow (in original currency) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
16 | AFWKFRA_KCFP | Key Figures: CfaR - Risk Factor Positions | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
17 | AFWKFRA_KCFPL | Key Figures: CfaR - Profit/Loss Distribution | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
18 | AFWKFRA_KCFPL_H | Key Figures: CfaR - Profit/Loss Distribution | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
19 | AFWKFRA_KCFP_H | Key Figures: CfaR - Risk Factor Positions | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
20 | AFWKFRA_KGD | Key Figures: Greeks - Delta | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
21 | AFWKFRA_KGD_H | Key Figures: Greeks - Delta | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
22 | AFWKFRA_KMGD | Key Figures: MtM, Greeks - Delta | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
23 | AFWKFRA_KMGD_H | Key Figures: MtM, Greeks - Delta | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
24 | AIS_LAYOUT_MRTAB | Key Figures on CfaR Tab for Std Rep. on RDB (Period ALV) | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
25 | AIS_LAYOUT_MRTB2 | Key Figures on CfaR Tab for Std Rep. on RDB (Period ALV) | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
26 | RDBRA_NSUM_CFAR | RA: Final Results for Cash Flow at Risk | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
27 | RDBRA_NSUM_CFP | RA: Final Results Positions (Delta/Gamma) of Cashflows | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
28 | RDBRA_NSUM_CFPL | RA: Final Results for P&L Distributions of Cashflows | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
29 | RDBRA_REC_CF | RA RDB: Single Records for Cashflows in Eval. Currency | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
30 | RDBRA_REC_CFP | RA RDB: Single Records for Delta/Gamma of Cashflows | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
31 | RDBRA_REC_CFPL | RA RDB: Single Records for Key Figure Cat. P&L for Cashflows | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
32 | RDBRA_SUM_CF | RA RDB: Final Results for Cashflows in Evaluation Currency | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
33 | HRT1776 | Table Section for IT 1776 | 5 | KEYFIGURE | Key Figure (Abbreviation) | nvarchar | 4 | 0 | | |
34 | PIQDBAPPR_AUD5 | Audit: Result Folder for Calculation | 3 | KEYFIGURE | Key Figure (Abbreviation) | nvarchar | 4 | 0 | | |
35 | T7PIQAUDREXMKEYF | Irrelevant Key Figures/Perform. Indices per Execution Mode | 3 | KEYFIGURE | Key Figure (Abbreviation) | nvarchar | 4 | 0 | | |
TOPAnalyzer |
36 | AFWBM_CALCADMIN | Administration of Calculation of Benchmark | 3 | KEYFIGURE | Benchmark Key Figure | nvarchar | 8 | 0 | | |
37 | AFWBM_CALC_PROT | Administration of Authorization for Benchmarks | 3 | KEYFIGURE | Benchmark Key Figure | nvarchar | 8 | 0 | | |
38 | AFWBM_DEL_OBJ | Deleted Objects from PAEPBM as a Worklist | 4 | KEYFIGURE | Benchmark Key Figure | nvarchar | 8 | 0 | | |
39 | AFWGO_EPROCK | Evaluation Procedure: Key Figure Assignment Transport Table | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
40 | AFWGO_EPROCK_H | Eval. Proc.: Key Fig. Assignment / Attribute Table Time-Dep. | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
41 | AFWGO_EVALPROC1K | Obsolete: Eval.Proc. for Single Records: Key Figure Groups | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
42 | AFWGO_EVALPROC2K | Obsolete: Eval. Proc. for Final Result Rcds: Key Fig. Assmt | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
43 | AFWKFAA_AAPOS | Key Figures: Position in Position Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
44 | AFWKFAA_AAPOSCC | Key Figures: Position in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
45 | AFWKFAA_GENPOS | Key Figure: Generic Position Key Figure | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
46 | AFWKFAA_GENPOSCC | Key Figure: Generic Position Key Figure in Calculation Curre | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
47 | AFWKFAA_POSCOMP | Key Figures: Position Components for Genric Position Key fig | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
48 | AFWKF_AAPOSCC_H | Key Figures: Position in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
49 | AFWKF_AAPOS_H | Key Figures: Position in Position Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
50 | AFWKF_DEFIN | Key Figure Definition (General Part) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
51 | AFWKF_DEFINT | Key Figure Definition (Text Table) | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
52 | AFWKF_GENPOSCC_H | Key Figure: Generic Position Key Figure History | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
53 | AFWKF_GENPOS_H | Key Figure: Generic Position Key Figure History | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
54 | AFWKF_KB0 | Key Figure Definition: Attribution of NPV Basis | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
55 | AFWKF_KB0_H | Key Fig. Definition: Attributes for NPV Basis (Attrib.Table) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
56 | AFWKF_POSCOMP_H | Key Figure: Position Component History | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
57 | RDBAA_REC_CCYPOS | "Generic" Single Record Items with Currency | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
58 | RDBAA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-AA | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
59 | RDBAA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-AA | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
60 | RDB_FIENM_POS | Encryption of Key Figure ID in Field Name and Item No. | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
61 | RDB_KFCREC_TEM | Single Record Item Table for Key Fig. Category (Template) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
62 | RDB_NSUM_CURR | Final Results for Non-Add. Key Figures in Crcy (Template) | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
63 | RDB_NSUM_GEN | Final Results for Non-Add. Generic Key Figures (Template) | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
64 | RDB_REC_CURRPOS1 | Single Record Items: Generic Key Figs with Crcy (Template) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
65 | RDB_REC_GENPOS1 | Single Record Items: Generic Key Figs w/o Crcy (Template) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
66 | RDB_REC_QUAN1 | Single Record Items: Quantity Generic Key Figs (Template) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
67 | RDB_SUM_CURR | Final Results: Additive Key Figures in Currency (Template) | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
68 | RDB_SUM_GEN | Final Results: Additive Generic Key Figures (Template) | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
69 | RDB_SUM_NSUM_TEM | Specific Final Results (Template) | 8 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
TOPData Basis |
70 | RSDMFACTAB | Model table: Fact table | 2 | KEYFIGURE | Key figure | nvarchar | 1 | 0 | | |
TOPData Mining |
71 | RSDMESC_ABC_H | Settings for Filling ABC Indicator | 5 | KEYFIGURE | Key Figure for Determining the ABC Indicator | nvarchar | 30 | 0 | | |
TOPFinancials Basis |
72 | FINB_DMT_KEYF | Data Retention: Key Figures | 4 | KEYFIGURE | Field Name | nvarchar | 30 | 0 | | |
TOPInformation System |
73 | AIS_LAYOUT_BTTAB | Key Figs for Backtesting Tab Page in Std Report for RDB | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
74 | AIS_LAYOUT_FLTAB | Key Figures on PA Flow Tab for Standard Reporting on RDB | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
75 | AIS_LAYOUT_MATAB | Key Figures on Mat. Band Tab for Standard Reporting on RDB | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
76 | AIS_LAYOUT_PHFRM | Key Figures in PH Frame for Standard Reporting on the RDB | 3 | KEYFIGURE | Layout for Key Figure | nvarchar | 10 | 0 | | |
77 | AIS_LAYOUT_RHTAB | Key Figures on RH Tab for Standard Reporting on the RDB | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
78 | AIS_LAYOUT_SSTAB | Key Figures on Line Items Tab for Standard Rep. on RDB | 3 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
TOPMarket Risk Analyzer |
79 | AFWKFRA_BCK0 | Key Figures: Backtesting for Profit and Loss | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
80 | AFWKFRA_BCK0_H | Key Figures: Backtesting for Profit and Loss - History | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
81 | AFWKFRA_FML | Key Figures: Formula Definition | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
82 | AFWKFRA_K00 | Key Figures: Direct Redefinition of Dual Interest Rate Shift | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
83 | AFWKFRA_K00_H | Key Figures: Direct Redefinition of Dual Interest Rate Shift | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
84 | AFWKFRA_K01 | Key Figures: Direct Redefinition of Int. Rate Sensitivities | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
85 | AFWKFRA_K01_H | Key Figures: Direct Redefinition of Int. Rate Sensitivities | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
86 | AFWKFRA_KB0 | Key Figures: NPV with Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
87 | AFWKFRA_KB00 | Key Figures: NPV in transaction currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
88 | AFWKFRA_KB00_H | Key Figures: NPV in transaction currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
89 | AFWKFRA_KB0_H | Key Figures: NPV with Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
90 | AFWKFRA_KB2 | Key Figures: Net Present Value with Currency - VaR Basis | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
91 | AFWKFRA_KB2_H | Key Figures: NPV with Currency - VaR Basis | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
92 | AFWKFRA_KBB | Key Figures: Backtesting | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
93 | AFWKFRA_KBE | Key Figures: Exposure | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
94 | AFWKFRA_KBE_H | Key Figures: Exposure | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
95 | AFWKFRA_KBF | Key Figures: Key Figure Formulas | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
96 | AFWKFRA_KBX | Key Figures: NPV with Market Data Shift | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
97 | AFWKFRA_KBX_H | Key Figures: NPV with Market Data Shift | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
98 | AFWKFRA_KD0 | Key Figures: Positions in Risk Hierarchy | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
99 | AFWKFRA_KD0_H | Key Figures: Items in the Risk Hierarchy | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
100 | AFWKFRA_KG1 | Key Figures: P&L Delta/Gamma | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
101 | AFWKFRA_KG1_H | Key Figures: P+L Delta/Gamma | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
102 | AFWKFRA_KS0 | Key Figures: Direct Redefinition | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
103 | AFWKFRA_KS0_H | Key Figures: Direct Redifinition | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
104 | AFWKFRA_KS1 | Key Figure: Direct Redefinition of YTM | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
105 | AFWKFRA_KS1_H | Key Figures: Direct Redefinition / AT (for YTM) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
106 | AFWKFRA_KS2 | Key Figures: Direct Redefinition (for Modified Duration) | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
107 | AFWKFRA_KS2_H | Key Figure: Direct Redefinition / AT | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
108 | AFWKFRA_KVK | Key Figures: Value at Risk with Parameters | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
109 | AFWKFRA_KVK1 | Key Figures: Value at Risk with Parameters | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
110 | AFWKFRA_KVK1_H | Key Figures: Value-at-Risk with Parameters | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
111 | AFWKFRA_KVK2 | Key Figures: Marginal Value at Risk with Parameters | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
112 | AFWKFRA_KVK2_H | Key Figures: Marginal Value-at-Risk with Parameters / AT | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
113 | AFWKFRA_KVK_H | Key Figures: Value-at-Risk with Parameters | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
114 | AFWKFRA_KVS | Key Figures: Value at Risk Simulated | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
115 | AFWKFRA_KVS1 | Key Figures: Mean Excess Loss Simulated | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
116 | AFWKFRA_KVS1_H | Key Figures: Mean Excess Loss Simulated / AT | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
117 | AFWKFRA_KVS_H | Key Figures: Value-at-Risk - Simulated | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
118 | AFWKFRA_QKF | Key Figures: Quantity Key Figure for commodity instruments | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
119 | AFWKFRA_QKF_H | Key Figures: Commodity Key Figure for commodity instruments | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
120 | RDBRA_NSUM_CURR | CFM-RA: Final Results for Non-Additive Key Figures in Crcy | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
121 | RDBRA_NSUM_GEN | CFM-RA: Final Results for Non-Additive Generic Key Figures | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
122 | RDBRA_NSUM_TBG | RA: Final Results for P&L Distributions | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
123 | RDBRA_NSUM_TBP | RA: Final Results Positions (Delta/Gamma) | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
124 | RDBRA_NSUM_TVK | RA: Final Results for Value at Risk | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
125 | RDBRA_REC_CURPOS | RA RDB: Single Record Position Table in Currency (Generic) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
126 | RDBRA_REC_GENPOS | RA RDB: Single Record Position Table (Generic) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
127 | RDBRA_REC_QUAN | RA RDB: Single Record Position Table for Quantity (Generic) | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
128 | RDBRA_REC_TBE | RA RDB: Single Records for Key Figure Category BE | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
129 | RDBRA_REC_TBG | RA RDB: Single Records for Key Figure Category P&L | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
130 | RDBRA_REC_TBK | RA RDB: Single Records for Key Figure Category BK0 | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
131 | RDBRA_REC_TBP | RA RDB: Single Records for Key Figure Category Delta/Gamma | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
132 | RDBRA_SUM_CURR | CFM-RA: Final Results for Additive Key Figures in Currency | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
133 | RDBRA_SUM_GEN | CFM-RA: Final Results for Additive Generic Key Figures | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
134 | RDBRA_SUM_TBE | RA RDB: Final Results for Key Figure Category BE | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
135 | RDBRA_TBG | RA RDB: Single Records for Key Figure Category P&L | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
TOPMaster Data Framework |
136 | FINB_MD_0100 | Registration: Data Elements | 7 | KEYFIGURE | Boolean Value (True or False) | nvarchar | 1 | 0 | | |
TOPMedia Product Sales and Distribution |
137 | TJKSDSTATHORIZON | IS-M: Horizon for Calculating Statistical Key Figures | 5 | KEYFIGURE | LIS Key Figure | nvarchar | 10 | 0 | | |
TOPPortfolio Analyzer |
138 | AFWKFPA_FLW | Key Figures: Flow in Transaction Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
139 | AFWKFPA_FLWCC | Key Figures: Flow in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
140 | AFWKFPA_INFO | Key Figures: Information Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
141 | AFWKFPA_JENSEN | Key Figures: Jensen's Alpha | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
142 | AFWKFPA_POS | Key Figures: Position in Position Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
143 | AFWKFPA_POSCC | Key Figures: Position in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
144 | AFWKFPA_PRDFLW | Key Figures: Flow for Period in Transaction Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
145 | AFWKFPA_PRDFLWCC | Key Figures: Flow for Period in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
146 | AFWKFPA_SHARPE | Key Figures: Sharpe Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
147 | AFWKFPA_SORTINO | Key Figures: Sortino Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
148 | AFWKFPA_TREYNOR | Key Figures: Treynor's Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
149 | AFWKFPA_YLD | Key Figures: Yield Calculated from Transaction Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
150 | AFWKFPA_YLDCC | Key Figures: Yield Calculated from Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
151 | AFWKFPA_YLDSNC | Key Figures: Yield from Transaction Currency Since CALCSINCE | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
152 | AFWKFPA_YLDSNCCC | Key Figures: Yield from Evaluation Currency Since CALCSINCE | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
153 | AFWKF_FLWCC_H | Key Figures: Flow in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
154 | AFWKF_FLW_H | Key Figures: Flow in Transaction Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
155 | AFWKF_INFO_H | Key Figures: Information Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
156 | AFWKF_JENSEN_H | Key Figures: Jensen's Alpha | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
157 | AFWKF_POSCC_H | Key Figures: Position in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
158 | AFWKF_POS_H | Key Figures: Position in Position Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
159 | AFWKF_PRDFLWCC_H | Key Figures: Flow for Period in Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
160 | AFWKF_PRDFLW_H | Key Figures: Flow for Period in Transaction Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
161 | AFWKF_SHARPE_H | Key Figures: Sharpe Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
162 | AFWKF_SORTINO_H | Key Figures: Sortino Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
163 | AFWKF_TREYNOR_H | Key Figures: Treynor's Ratio | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
164 | AFWKF_YLDCC_H | Key Figures: Yield Calculated from Evaluation Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
165 | AFWKF_YLDSNCCC_H | Key Figures: Yield from Evaluation Currency Since CALCSINCE | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
166 | AFWKF_YLDSNC_H | Key Figures: Yield from Transaction Currency Since CALCSINCE | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
167 | AFWKF_YLD_H | Key Figures: Yield Calculated from Transaction Currency | 2 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
168 | RDBPA_NSUM_CURR | Final Results for Non-Additive Key Figures in Crcy: TRM-PA | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
169 | RDBPA_NSUM_GEN | Final Results for Non-Additive Generic Key Figures: TRM-PA | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
170 | RDBPA_NSUM_GEN_R | Final Results for Ratio BM Key Figures: TRM-PA | 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
171 | RDBPA_REC_CCYPOS | "Generic" Single Record Items with Currency | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
172 | RDBPA_REC_FLW | Key Figure Values FLW: Single Record Items with Currency | 4 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
173 | RDBPA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-PA | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
174 | RDBPA_SUM_FLW | Key Figure Values FLW: Totals Records with Currency | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
175 | RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |
176 | RDBPA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-PA | 5 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | | |