| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CMM_MTM_PO | MtM per Purchase Order | 58 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
2 | CMM_MTM_SO | MtM per Sales Order | 55 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
3 | CPEC_QUOTRULE | CPE Quotation Rule | 10 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
4 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 22 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
5 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 23 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
6 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 23 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
7 | TBAC_DCS | Derivative contract specification customizing table | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
8 | TBAC_DCST | Texts for Derivative Contract Specifications | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
9 | TBAC_DCS_CTY | Definition Contract Specification LOF Commodity | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
10 | TBAC_DCS_FWD_KD | Key Dates of Derivative Contracts for Forwards | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
11 | TBAC_DCS_FWD_KDP | Period table for commodity forward index | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
12 | TBAC_DCS_FWD_KDT | Text Table for key date | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
13 | TBAC_DCS_KD | Key Dates of Derivative Contracts | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
14 | TBAC_DCS_KDT | Text Table for key date | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
15 | TBAC_DCS_KD_PRDS | DCS Periods | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
16 | TBAC_DCS_LOF | Derivative Contrac Specification for Listed Options, Futures | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
17 | TBAC_DCS_MIC | Dervative contract specification - MIC | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
18 | TBAC_DCS_MIC_CTY | Derivative Contract Specification MIC LOF Commodity | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
19 | TBAC_DCS_STRIKE | Derivative Contract Specification-Option: Strike Structure | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
20 | TBAT_PRICEQUOT | Derivative Contract Specification: Price Quotations | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
21 | TBAT_PRICEQUOT_F | Derivative Contract Specification: Price Quotations Futures | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
22 | TBAT_PRICEQUOT_O | Derivative Contract Specification: Price Quotations Options | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
23 | TBAT_PRICE_FWD | Derivative Contract Specification: Commodity Forward Prices | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
24 | TRCOT_CTY_DCSMIC | Details for DCS MIC Tuple | 3 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
25 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 7 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
26 | ZCM_DCS_DATA_TAB | Database table for DCS | 2 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
TOPCommodity Pricing Engine |
27 | CPEC_QUOTGRPPOS | CPE Term - Position in Quotation Group | 10 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
28 | CPEC_TERM | CPE Term | 24 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
29 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 21 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
TOPMarket Risk Analyzer |
30 | TCCT_CCURVE_MAST | Commodity Curve Master Data | 22 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
31 | FTR_AVG_ASGN | Assign one flow to many adjustments for average | 13 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
32 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 162 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
33 | VTBFHAPO | Transaction Flow | 162 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
34 | VTBFHAPO_MIGR | Migrated Financial Flows | 162 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
35 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 162 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
36 | VTIFHAPO | Underlying transaction flows | 85 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |
TOPTreasury |
37 | VTIDERI | Master Data Listed Options and Futures | 51 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | | |