| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
2 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 8 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
3 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 8 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
4 | L2TC_COMP_EXP | Raw exposure aggregation rules | 4 | COMMODITY_ID | Physical Commodity | nvarchar | 18 | 0 | | |
5 | L2TC_IM_RELEVANT | Exp. from Material Stock: Relevance Settings | 3 | COMMODITY_ID | Physical Commodity | nvarchar | 18 | 0 | | |
6 | TEXT_CTY_EXPOS | Commodity Price Exposure | 16 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
7 | TEXT_REXP_FO_IDX | Index for Financial Object Raw Exposure (TC) | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
8 | THAEXT_EXPOS_COP | Obsolet: Commodity exposure pricing data | 12 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
9 | THAEXT_TRANS_COP | Commodity exposure pricing data | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
10 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 23 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
11 | TLRT_RISKM_DER | Derivation for Risk Mitigation Indicator | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
12 | TRCOT_CTY_DCSMIC | Details for DCS MIC Tuple | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
13 | TRCOT_CTY_MCS | Specify Market Data Access for Mass Cash Settlement | 5 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
14 | TREAT_CLEAR_ASG | Treasury: Central Clearing Assignement | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
15 | ZMTMPERS | CM MtM Persistency | 10 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
TOPMarket Risk Analyzer |
16 | ATVO66 | Volatilities - Mapping from Commodity IDs | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
17 | TCCT_CCURVE_MAST | Commodity Curve Master Data | 4 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
TOPTransaction Management |
18 | TCHT_HD_BEWEG_CY | SFGDT Commodity Flows Table | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
19 | TRCPAT | TR: Commodity Price Adjustment-Registration and Fixing | 6 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
TOPTransaction Manager |
20 | FTR_AVG_ASGN | Assign one flow to many adjustments for average | 10 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
21 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 152 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
22 | TCORT_CODCPA | Deal: Commodity Price Adjustment | 10 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
23 | TCORT_CODFL | Deal: Flows | 57 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
24 | TCORT_CODMD | Deal: Main Data | 69 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
25 | TCORT_CODUL | Deal: Underlying | 24 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
26 | TEXT_POSITIONS | Exposure Positions | 15 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
27 | TEXT_POS_FLOW | Exposure Position Flows | 14 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
28 | TEXT_REXP_ITEM | Raw Exposure Item | 9 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
29 | TEXT_REXP_SUBIT | Sub Raw Exposures (Split Items) | 7 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
30 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 14 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
31 | THAEXT_EXPOS_CO | Commodity exposure | 8 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
32 | THAEXT_TRANS_CO | Transaction for commodity price exposure | 10 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
33 | THMHRT_HR | Hedge Relationship | 44 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
34 | THMT_HEDGE_ITEM | Hedged Item | 21 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
35 | TRCOT_CTY_EXCHNG | Commodity Exchange relevant data | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
36 | TRCOT_CTY_FWDPER | obsolete | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
37 | TRCOT_CTY_MASTER | Commodity master data | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
38 | TRCOT_CTY_PROV | Provider dependent Forward Period Settings for a CO | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
39 | TRCOT_CTY_QUOTE | Commodity quotation source | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
40 | VTBFHA | Transaction | 59 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
41 | VTBFHAPO | Transaction Flow | 152 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
42 | VTBFHAPO_MIGR | Migrated Financial Flows | 152 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
43 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 152 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
44 | VTIFHA | Underlying transaction | 43 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
45 | VTIFHAPO | Underlying transaction flows | 82 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
TOPTreasury |
46 | ATCOVO | Commodity Price Volatilities | 3 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
47 | TCRT_CTY_FWDRATE | Market Data for Forward Rates | 2 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
48 | VTIDERI | Master Data Listed Options and Futures | 44 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |
TOPTreasury and Risk Management Integration |
49 | L2TC_CONDICOMM | Condition type - Commodity ID Mapping | 4 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | | |