| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAnalyzer |
1 | AFWBM_ASS | TRM: Assignment of Benchmarks to Portfolio per Variant | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
2 | AFWBM_ASS_BMPH | TRM: Assignment of Benchmarks to Portfolio per Variant | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
3 | AFWBM_ASS_T | TRM: Text Table for Assignment Variants | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
4 | AFWBM_PH_EVALP | TRM: Definition of Exception Handling for PH Variant | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
5 | AFWCH_FL | AFWCH: Filter List | 13 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
6 | AFWCH_FL_BK | AFWCH: Header Data for Filter History | 7 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
7 | AFWCH_PHDEFALT | Alternative Portfolio Hierarchy Definition | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
8 | AFWGO_EPROCK | Evaluation Procedure: Key Figure Assignment Transport Table | 7 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
9 | AFWGO_EPROCK_H | Eval. Proc.: Key Fig. Assignment / Attribute Table Time-Dep. | 7 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
10 | AFWGO_EVALPROC1 | Evaluation Procedure for Single Records: Definition | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
11 | JBRHISPHBAUMS | Tree Structure for Deactivated Portfolio Hierarchies | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
12 | JBRHISPHTEXT | RM: Portfolio Texts for Deactivated Portfolio Hierachy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
13 | JBRHISPHZUORDN | RM Deactivated PH: Assign Base Portfolios to End Nodes | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
TOPAssetLiability Management |
14 | JBAMPGPAR | ALM Market Price Weighting: Parameters | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
15 | JBAPHKMERK | ALM Assignment of Characteristics to PH Nodes | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
16 | JBAPLANPAR | ALM Assignment of Planning Parameters to Planning Variant | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
17 | JBAPLANPARLZB | ALM Assignment of Planning Parameters to Planning Variant | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
18 | JBAPLANV | ALM Planning Variant | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
19 | JBAPLANVT | ALM Planning Variant: Text Table | 4 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
20 | JBASIMPARASAVEDB | ALM: Additional Information when Saving Sim. Transactions | 15 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
21 | JBRALMPARASAVE | ALM: Evaluation Parameters | 4 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
22 | JBRSVGAPHD | RM: Header Data (Saved Gap Evaluation Results) | 5 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
23 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 5 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
24 | JBRSVGAPRES | RM: Saved Gap Evaluation Results | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
TOPMarket Risk Analysis |
25 | I74TRM | Treasury Standard | 2 | SICHTID | Sicht einer Analysestruktur | nvarchar | 3 | 0 | | |
TOPPortfolio Analyzer |
26 | BMA_BMLAYER | OLD CFM Benchmarking: Benchmark Layer | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
27 | BMA_BMLAYERDET | OLD CFM Benchmarking: Benchmark Layer | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
28 | BMA_BMLAYERT | OLD CFM Benchmarking: Benchmark Layer (TEXTS) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
TOPRisk Analysis |
29 | I9AMBPK | IS-B: RM Model/Include DBTab Base Portfolio Determination | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
30 | JBRAMOUNT | RM: Account Balance Summarization in Base Portfolio | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
31 | JBRBP | Base Portfolio Definition | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
32 | JBRBPCFKN | RM: Aggregated Capital Commitment Cash Flows | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
33 | JBRBPCFV | RM: BP Update Administration for Cash Flows | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
34 | JBRBPCFVN | RM: BP Update Management for Cash Flows | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
35 | JBRBPCFZN | RM: Aggregated Interest Commitment Cash Flows | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
36 | JBRBPFART | RM: Update Type for Objects per View | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
37 | JBRBPGENUE | Generated Views for an RM Area | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
38 | JBRBPKSV | RM BP Update Administration for Account Balances | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
39 | JBRBPT | Base Portfolio Definition: Text | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
40 | JBRBPWPV | RM: BP Update Administration for Positions/Securities | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
41 | JBRBSTD | RM: Base Portfolios - Single Positions (until F3.03) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
42 | JBRBSTV | RM: Base Portfolio for Position Management | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
43 | JBRCFKAP | RM: Aggregated Capital Commitment Cash Flows per BP | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
44 | JBRCFZINS | RM: Aggregated Fixed-Interest Cash Flows per BP | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
45 | JBREGSH | RM Base Portfolio for Single Transactions | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
46 | JBRKON | RM: Account Balance Summarization in Base Portfolio | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
47 | JBRMZBG | RM: Assignment of Transactions to Business Partners | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
48 | JBRNODETXT | All Information for Display of Hierarchies | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
49 | JBRPH | Portfolio hierarchy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
50 | JBRPHARC | RM: Archiving Data for Portfolio Hierarchies | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
51 | JBRPHBAUMS | Storage of Portfolio Hierarchy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
52 | JBRPHDEF | Definitions Used to Derive Portfolio Hierarchy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
53 | JBRPHDEFBK | RM: Backup for Table JBRPHDEF | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
54 | JBRPHGE | RM: Portfolio Hierarchy: Generation Data | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
55 | JBRPHT | Portfolio hierarchy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
56 | JBRSHBAUM | Tree Structure of Nodes in a Portfolio Hierarchy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
57 | JBRSHKN | Nodes in Portfolio Hierarchy | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
58 | JBRSI | Views | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
59 | JBRSICRIT | Restrictions for Subviews | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
60 | JBRSIHIM | Hierarchy of Characteristics | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
61 | JBRSIM | Assign Characteristics to Views | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
62 | JBRSIT | Dims texts | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
63 | JBRSPH | Definition of Portfolio Hierarchy (Check Table) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
64 | JBRSPHT | Definition of Portfolio Hierarchy (Text Table) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
65 | JBRSVABEST | RM: Header Table SDTFT (Additional Info.) for Saved Datasets | 4 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
66 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 5 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
67 | JBRSVGAPRES2 | RM: Saved Gap Evaluation Results | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
68 | JBRSVKO | RM: Header Table of SDTFT for Saved Datasets | 14 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
69 | JBRSVPHBAUM | RM: Portfolio Hierarchy for Saved Datasets (Backtesting) | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
70 | JBRSVPHZUORDN | RM: Assignment of PH->BP for Saved Datasets (Backtesting) | 7 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
71 | JBRSVRBR | Assignment of View and Summarization Rule to Valuation Rule | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
72 | JBRSVRCFK | Assignment of View and Summarization Rule to Cash Flow Ind. | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
73 | JBRSVSTATE | RM: Administration Table for Saved Datasets (Backtesting) | 4 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
74 | JBRTKCHABK | RM: Backup Table for Characteristic Hierarchies | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
75 | JBRUBSTV | RM: Base Portfolio - Management of Non-Int-Bearing Positions | 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
76 | JBRVBRDEF | RM: Default Setting for Summarization (with Valuation Rule) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
77 | JBRVBRSA | RM: Summarization for Balances (with Valuation Rule) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
78 | JBRVBRSPEZ | RM: Specific Settings for Summarization(with Valuation Rule) | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
79 | JBRVRCA | Assignment of Flow Type to RM Cash Flow Type | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
80 | JBRVRDEF | Summarization Rule - Default Setting | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
81 | JBRVRSA | Assignment of Summarization Rule to Balance Type | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |
82 | JBRZUORDNT | RM: Assignment of Base Portfolios to PH End Nodes | 2 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | | |