| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CPEC_QUOTRULE | CPE Quotation Rule | 6 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| TOPCommodity Pricing Engine |
| 2 | CPEC_QUOTGRPPOS | CPE Term - Position in Quotation Group | 7 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 3 | CPEC_QUOTNAME | Quotation Name | 4 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 4 | CPEC_QUOTNAME_T | Description of Quotation Name | 5 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 5 | CPEC_QUOTTYPE | Quotation Type | 3 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 6 | CPEC_QUOTTYPE_T | Description of Quotation Type | 4 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 7 | CPEC_TERM | CPE Term | 20 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 8 | CPED_PRCQUOT_SIM | CPE - Price Quotation Simulation | 3 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 9 | CPED_PRICEQUOT | Price Quotation | 3 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| 10 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 17 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
| TOPMarket Risk Analyzer |
| 11 | VTVSZCTV | Scenario Database: Commodity Volatilities | 4 | QUOTTYPE | Commodity Quotation Type | nvarchar | 5 | 0 | | |
| 12 | VTVSZCTY | Scenario Database: Commodity Prices (OBSOLETE) | 4 | QUOTTYPE | Commodity Quotation Type | nvarchar | 5 | 0 | | |
| 13 | VTVSZCTYP | Scenario Database: Commodity Prices | 4 | QUOTTYPE | Commodity Quotation Type | nvarchar | 5 | 0 | | |
| TOPTreasury |
| 14 | TRCOCC_QUOTTYPE | Commodities: quotation types | 3 | QUOTTYPE | Quotation Type | nvarchar | 5 | 0 | | |
