| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDBRA_NSUM_CFAR | RA: Final Results for Cash Flow at Risk | 15 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
2 | RDBRA_NSUM_CFP | RA: Final Results Positions (Delta/Gamma) of Cashflows | 15 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
3 | RDBRA_NSUM_CFPL | RA: Final Results for P&L Distributions of Cashflows | 25 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
4 | RDBRA_SUM_CF | RA RDB: Final Results for Cashflows in Evaluation Currency | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
TOPAnalyzer |
5 | AFWBM_ASS_BMPH | TRM: Assignment of Benchmarks to Portfolio per Variant | 10 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
6 | AFWBM_ATT_BM | TRM: Key Table for Benchmark Master Data(General Attributes) | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
7 | AFWBM_BASIC | TRM: Additional Attributes of a Basic Benchmark | 6 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
8 | AFWBM_CHVAL | TRM: Benchmark: Assignment of Characteristics and Values | 9 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
9 | AFWBM_COMP | TRM: Additional Attributes of a Composite Benchmark | 6 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
10 | AFWBM_PH_EVALP | TRM: Definition of Exception Handling for PH Variant | 7 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
11 | AFWCH_FL | AFWCH: Filter List | 11 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
12 | AFWCH_FL_BK | AFWCH: Header Data for Filter History | 17 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
13 | AFWGO_EVALPROC1 | Evaluation Procedure for Single Records: Definition | 9 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
14 | AFWGO_EVALPROC2 | Evaluation Procedure Final Results Records: Definition | 7 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
15 | AFWKF_DEFIN | Key Figure Definition (General Part) | 8 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
16 | RDBAA_REC_HEADER | Single Record Header for Accounting Analyzer | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
17 | RDBAA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-AA | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
18 | RDBAA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-AA | 11 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
19 | RDB_NSUM_CURR | Final Results for Non-Add. Key Figures in Crcy (Template) | 13 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
20 | RDB_NSUM_GEN | Final Results for Non-Add. Generic Key Figures (Template) | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
21 | RDB_REC_HEADER | Single Record Header (Template) | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
22 | RDB_SUM_CURR | Final Results: Additive Key Figures in Currency (Template) | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
23 | RDB_SUM_GEN | Final Results: Additive Generic Key Figures (Template) | 11 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
24 | RDB_SUM_NSUM_TEM | Specific Final Results (Template) | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
TOPAssetLiability Management |
25 | JBRSVGAPHD | RM: Header Data (Saved Gap Evaluation Results) | 42 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
26 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 42 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
TOPBack Office |
27 | TRFT_CLASS_POS | Treasury: TRF Class Position | 17 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
28 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 18 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
TOPBusiness Partner |
29 | VTBSTA1 | Allocation of Payment Details as Standing Instructions | 16 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
30 | VTBSTA2 | Standing Instructions for Correspondence | 14 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
31 | VTBSTA3 | SI for Business Partner: Transaction Authorizations | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
32 | VTBSTA4 | SI for Business Partner: Derived Flows | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
33 | VTBSTC1 | Components of Payment Details for Standing Instruction | 24 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
TOPClinical System |
34 | N1PRERROR | IS-H*MED: PATREG: Nicht verbuchbare Pat.Reg.-Datensätze | 17 | UPUSER | IS-H: Degistiren sorumlunun adi | nvarchar | 12 | 0 | | |
TOPLoans Management |
35 | VDZV | Payment Details for the Loan | 11 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
TOPMarket Risk Analyzer |
36 | RDBRA_NSUM_CURR | CFM-RA: Final Results for Non-Additive Key Figures in Crcy | 13 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
37 | RDBRA_NSUM_GEN | CFM-RA: Final Results for Non-Additive Generic Key Figures | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
38 | RDBRA_NSUM_TBG | RA: Final Results for P&L Distributions | 23 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
39 | RDBRA_NSUM_TBP | RA: Final Results Positions (Delta/Gamma) | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
40 | RDBRA_NSUM_TVK | RA: Final Results for Value at Risk | 13 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
41 | RDBRA_REC_HEADER | RA RDB: Single Record Header Table | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
42 | RDBRA_SUM_CURR | CFM-RA: Final Results for Additive Key Figures in Currency | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
43 | RDBRA_SUM_GEN | CFM-RA: Final Results for Additive Generic Key Figures | 11 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
44 | RDBRA_SUM_TBE | RA RDB: Final Results for Key Figure Category BE | 13 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
TOPPortfolio Analyzer |
45 | BMA_BM | OLD CFM Benchmarking: BM Central Master Data | 8 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
46 | BMA_BMBM | OLD CFM Benchmarking: Benchmark Relationships | 10 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
47 | BMA_CH | OLD CFM Benchmarking: Characteristics | 4 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
48 | BMA_CHVAL | OLD CFM Benchmarking: Characteristic Values | 5 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
49 | RDBPA_NSUM_CURR | Final Results for Non-Additive Key Figures in Crcy: TRM-PA | 13 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
50 | RDBPA_NSUM_GEN | Final Results for Non-Additive Generic Key Figures: TRM-PA | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
51 | RDBPA_NSUM_GEN_R | Final Results for Ratio BM Key Figures: TRM-PA | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
52 | RDBPA_REC_HEADER | Single Record Header | 14 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
53 | RDBPA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-PA | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
54 | RDBPA_SUM_FLW | Key Figure Values FLW: Totals Records with Currency | 13 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
55 | RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency | 12 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
56 | RDBPA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-PA | 11 | UPUSER | Last Changed By | nvarchar | 12 | 0 | | |
TOPRisk Analysis |
57 | JBRBDSLFNS | RM-BDS: Run Number Status | 7 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
58 | JBRDBKO | RM: DB Table Header Information Extended Risk Object | 23 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
59 | JBRHKO | RM: Version Table: Header Information: Extended Risk Object | 24 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
60 | JBRPH | Portfolio hierarchy | 5 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
61 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 42 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
TOPTransaction Data Pool |
62 | JBDGSCH | IS-B: Transaction Master Data | 32 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
63 | JBDKKOF_BACKUP | Backup Table for the Conversion of JBDKKOF | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
64 | JBDOBJ1 | Object Table for Financial Transactions, General Part | 26 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
65 | JBDVTMD | Variable transaction - master data | 16 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
TOPTransaction Manager |
66 | OTC_CONV_AFINKO | Backup Table for Fin. Transaction Alternative Conditions | 15 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
67 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
68 | OTC_CONV_FHAZU | Backup Table for Financial Transaction Activities | 8 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
69 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
70 | OTC_CONV_IAFINKO | Backup Table for Transaction Underlying Old Conditions | 14 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
71 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 8 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
72 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 12 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
73 | REFCC | References between CO object numbers, currency differences | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
74 | REFH | References between CO object numbers, header table | 8 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
75 | REFON | References between object numbers (CO object no.) | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
76 | TCORT_CO | Correspondence Administrative Data | 43 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
77 | THMEXT_LOG | Log: External Exposure Data Applied to E-HA | 10 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
78 | THMEXT_PLANNER | E-HA: Hedge Plan | 10 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
79 | THMHRT_HR | Hedge Relationship | 12 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
80 | THMHRT_HR_VAL | Valuation details for the hedging relationship | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
81 | THMT_HEDGE_ITEM | Hedged Item | 6 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
82 | TPMTVMFL | Position management variation margin flows at sec. account | 25 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
83 | VTBAFINKO | Alternative Conditions | 15 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
84 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 15 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
85 | VTBFATHD | Acct Assmt Templates for PS Mult. Acct Assmts: Header Info. | 8 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
86 | VTBFHA | Transaction | 7 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
87 | VTBFHAPO | Transaction Flow | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
88 | VTBFHAPO_MIGR | Migrated Financial Flows | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
89 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
90 | VTBFHAZU | Transaction Activity | 8 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
91 | VTBFINKO | Transaction Condition | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
92 | VTBFSEC | Securities Collateral | 12 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
93 | VTBKORES | Correspondence Data | 37 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
94 | VTBMA | Master Agreement | 6 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
95 | VTBPFHAPO | Treasury: Flow Shells | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
96 | VTBRATE | Rate for Activity | 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
97 | VTBSI | Hedges | 26 | UPUSER | Last changed by | nvarchar | 12 | 0 | | |
98 | VTBSIANF | **Caution! Do not use. Will be deleted!! | 17 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
99 | VTBSIZU | Hedge Allocation | 19 | UPUSER | Last changed by | nvarchar | 12 | 0 | | |
100 | VTBTRA1 | Transaction Authoriz. for Traders | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
101 | VTBZV | Payment Details for Transaction | 11 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
102 | VTB_TRADER_AUTH | Transparent Table for Trader Authorizations | 13 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
103 | VTIAFINKO | Alternative Conditions Underlying | 14 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
104 | VTIFHA | Underlying transaction | 6 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
105 | VTIFHAPO | Underlying transaction flows | 8 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
106 | VTIFHAZU | Underlying transaction status table | 7 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |
107 | VTIFINKO | Underlying transaction conditions | 12 | UPUSER | Last Changed by | nvarchar | 12 | 0 | | |