| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CPEC_QUOTRULE | CPE Quotation Rule | 19 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
2 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 26 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
3 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 27 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
4 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 27 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
5 | TBAC_BADI_PER_FW | Parameters for Period Determination of Commodity Forwards | 5 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
6 | TBAC_DCS_FWD_KD | Key Dates of Derivative Contracts for Forwards | 4 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
7 | TBAC_DCS_FWD_KDP | Period table for commodity forward index | 4 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
8 | TBAC_DCS_FWD_KDT | Text Table for key date | 4 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
9 | TBAT_PRICE_FWD | Derivative Contract Specification: Commodity Forward Prices | 5 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
10 | TEXT_CTY_EXPOS | Commodity Price Exposure | 21 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
11 | TEXT_POSF_DCS_PR | Exposure Position Flow DCS Pricing Data | 15 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
12 | TEXT_REXP_DCS_PR | Raw Exposure Item DCS Pricing Data | 12 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
13 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 11 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
TOPCommodity Pricing Engine |
14 | CPEC_QUOTGRPPOS | CPE Term - Position in Quotation Group | 14 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
15 | CPEC_TERM | CPE Term | 33 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
16 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 30 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
17 | FTR_AVG_ASGN | Assign one flow to many adjustments for average | 25 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
18 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 166 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
19 | VTBFHAPO | Transaction Flow | 166 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
20 | VTBFHAPO_MIGR | Migrated Financial Flows | 166 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |
21 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 166 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | | |