| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | TEXT_CTY_EXPOS | Commodity Price Exposure | 4 | EXPOSURE_ID | Commodity Price Exposure ID | nvarchar | 13 | 0 | ||
| 2 | TEXT_POSF_DCS_PR | Exposure Position Flow DCS Pricing Data | 5 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||
| 3 | TEXT_REXP_FO_IDX | Index for Financial Object Raw Exposure (TC) | 4 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||
| 4 | ZMTMPERS | CM MtM Persistency | 8 | EXPOSURE_ID | Commodity Price Exposure ID | nvarchar | 13 | 0 | ||
| Transaction Manager | ||||||||||
| 5 | TEMT_RAWEXPOS | Raw Exposure | 2 | EXPOSURE_ID | Exposure ID | nvarchar | 32 | 0 | ||
| 6 | TEMT_VERSEXPOS | Versioned Exposure | 4 | EXPOSURE_ID | Exposure ID | nvarchar | 32 | 0 | ||
| 7 | TEXT_POSF_PRICES | Exposure Position Flow Pricing Data | 5 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||
| 8 | TEXT_POSITIONS | Exposure Positions | 29 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||
| 9 | TEXT_POS_FLOW | Exposure Position Flows | 28 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||
| 10 | TEXT_RAWEXPOS | Raw Exposure | 3 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||
| 11 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 28 | EXPOSURE_ID | Raw Exposure ID | nvarchar | 13 | 0 | ||