| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CMM_MTM_PO | MtM per Purchase Order | 59 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
2 | CMM_MTM_SO | MtM per Sales Order | 56 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
3 | CPEC_QUOTRULE | CPE Quotation Rule | 11 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
4 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 23 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
5 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 24 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
6 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 24 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
7 | TBACT_MIC_HANDPL | Assignment of Exchange to Market Identifier Code | 2 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
8 | TBAC_DCS_MIC | Dervative contract specification - MIC | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
9 | TBAC_DCS_MIC_CTY | Derivative Contract Specification MIC LOF Commodity | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
10 | TBAC_MIC | Customizing table for Market Identification Code | 2 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
11 | TBAC_MICT | Texts for MIC | 2 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
12 | TBAC_TENOR_USE | Customizing Table for Time to Maturity Usage | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
13 | TBAT_PRICEQUOT | Derivative Contract Specification: Price Quotations | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
14 | TBAT_PRICEQUOT_F | Derivative Contract Specification: Price Quotations Futures | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
15 | TBAT_PRICEQUOT_O | Derivative Contract Specification: Price Quotations Options | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
16 | TBAT_PRICE_FWD | Derivative Contract Specification: Commodity Forward Prices | 3 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
17 | TEXT_CTY_EXPOS | Commodity Price Exposure | 18 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
18 | TEXT_POSF_DCS_PR | Exposure Position Flow DCS Pricing Data | 10 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
19 | TEXT_REXP_DCS_PR | Raw Exposure Item DCS Pricing Data | 7 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
20 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 8 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
21 | TRCOT_CTY_DCSMIC | Details for DCS MIC Tuple | 4 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
22 | TRCOT_MIC_DELLOC | Assignment of Pricing Location to Market Identifier Code | 2 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
23 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 8 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
TOPCommodity Pricing Engine |
24 | CPEC_QUOTGRPPOS | CPE Term - Position in Quotation Group | 11 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
25 | CPEC_TERM | CPE Term | 25 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
26 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 22 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
TOPMarket Risk Analyzer |
27 | TCCT_CCURVE_MAST | Commodity Curve Master Data | 23 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
28 | FTR_AVG_ASGN | Assign one flow to many adjustments for average | 14 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
29 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 163 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
30 | VTBFHAPO | Transaction Flow | 163 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
31 | VTBFHAPO_MIGR | Migrated Financial Flows | 163 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
32 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 163 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |
TOPTreasury |
33 | VTIDERI | Master Data Listed Options and Futures | 53 | MIC | Market Identifier Code | nvarchar | 4 | 0 | | |