| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CPEC_QUOTRULE | CPE Quotation Rule | 13 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
2 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 24 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
3 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 25 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
4 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 25 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
5 | MDUCMDCS | Market Data: Price Type Conversion: Commodities / DCS | 4 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
6 | TBAC_TENOR_USE | Customizing Table for Time to Maturity Usage | 4 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
7 | TBAT_PRICEQUOT | Derivative Contract Specification: Price Quotations | 6 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
8 | TBAT_PRICEQUOT_F | Derivative Contract Specification: Price Quotations Futures | 5 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
9 | TBAT_PRICEQUOT_O | Derivative Contract Specification: Price Quotations Options | 5 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
10 | TBAT_PRICE_FWD | Derivative Contract Specification: Commodity Forward Prices | 6 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
11 | TEXT_POSF_DCS_PR | Exposure Position Flow DCS Pricing Data | 11 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
12 | TEXT_REXP_DCS_PR | Raw Exposure Item DCS Pricing Data | 8 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
13 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 9 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
14 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 9 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
TOPBasic Market Data |
15 | /BA1/F4_SEC_CLAS | Map Charactistic Value for GUID | 6 | PRICETYPE | Rate Category | nvarchar | 4 | 0 | | |
16 | /BA1/TF4_PRTYPE | Definition of Price Types | 3 | PRICETYPE | Rate Category | nvarchar | 4 | 0 | | |
17 | /BA1/TF4_PRTYPET | Text Table for /BA1/TF4_PRTYPET | 4 | PRICETYPE | Rate Category | nvarchar | 4 | 0 | | |
18 | /BA1/TF4_SEQUCE | Definition of Read Sequence | 6 | PRICETYPE | Rate Category | nvarchar | 4 | 0 | | |
TOPClinical System |
19 | N1PRFOA | i.s.h.med: Medication, Price - Drug Assignment | 4 | PRICETYPE | Medication: Internal Key of Price Type | nvarchar | 5 | 0 | | |
20 | TN1PRICETYP | i.s.h.med: Medication, Price Types for Drug | 2 | PRICETYPE | Medication: Internal Key of Price Type | nvarchar | 5 | 0 | | |
21 | TN1PRICETYPT | i.s.h.med: Medication, Price Types for Drug - Texts | 2 | PRICETYPE | Medication: Internal Key of Price Type | nvarchar | 5 | 0 | | |
TOPCommodity Pricing Engine |
22 | CPEC_QUOTGRPPOS | CPE Term - Position in Quotation Group | 13 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
23 | CPEC_TERM | CPE Term | 27 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
24 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 24 | PRICETYPE | Type of Price Quotation | nvarchar | 2 | 0 | | |
TOPIndustry Solution Catch Weight Management |
25 | /CWM/MIG_PRCMAP | Price Type Mapping | 4 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | |
26 | /FMP/C_MP_DYNREL | Customizing for the Dynamic Price Release FMP | 6 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | |
27 | /FMP/C_MP_PTYP | Price Types | 2 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | |
28 | /FMP/C_MP_PTYP_T | Price Types | 2 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | |
29 | /FMP/D_MP_HIST | Material Price History | 4 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | |
30 | /FMP/D_MP_PRIC | Material Prices | 4 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | |