| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TEXT_CTY_EXPOS | Commodity Price Exposure | 39 | PRICE_DATE | Price Date | nvarchar | 8 | 0 | | |
2 | TEXT_POSF_DCS_PR | Exposure Position Flow DCS Pricing Data | 13 | PRICE_DATE | Date of Price Quotation | nvarchar | 8 | 0 | | |
3 | TEXT_REXP_DCS_PR | Raw Exposure Item DCS Pricing Data | 4 | PRICE_DATE | Date on which the Item will be priced | nvarchar | 8 | 0 | | |
4 | THAEXT_EXPOS_COP | Obsolet: Commodity exposure pricing data | 5 | PRICE_DATE | Date on which the Item will be priced | nvarchar | 8 | 0 | | |
5 | THAEXT_TRANS_COP | Commodity exposure pricing data | 6 | PRICE_DATE | Date on which the Item will be priced | nvarchar | 8 | 0 | | |
6 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 6 | PRICE_DATE | Date on which the Item will be priced | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
7 | TEXT_POSF_PRICES | Exposure Position Flow Pricing Data | 7 | PRICE_DATE | Date on which the Item will be priced | nvarchar | 8 | 0 | | |
8 | TEXT_REXP_PRICES | Raw Exposure Item Pricing Data | 4 | PRICE_DATE | Date on which the Item will be priced | nvarchar | 8 | 0 | | |