| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TEXT_CTY_EXPOS | Commodity Price Exposure | 50 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
2 | TEXTS_ACTIVITY | Sub item / Sub raw exposure activity table | 1 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
3 | TEXTS_ACTIVITY_T | Text table for activities | 1 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
4 | TEXT_POSITIONS | Exposure Positions | 9 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
5 | TEXT_POS_FLOW | Exposure Position Flows | 8 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
6 | TEXT_REXP_SUBIT | Sub Raw Exposures (Split Items) | 6 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
7 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 8 | TRANSACTIVITY | Exposure Activity | nvarchar | 2 | 0 | | |
8 | THMEXTS_ACTIVITY | E-HA: System table for Transaction Activity | 1 | TRANSACTIVITY | Transaction Activity (E-HA) | nvarchar | 2 | 0 | | |
9 | THMEXTS_ACT_TXT | E-HA: Long Texts for Transaction Acivity | 1 | TRANSACTIVITY | Transaction Activity (E-HA) | nvarchar | 2 | 0 | | |
10 | THMEXTS_TRANSACT | E-HA: Transaction Activity Assignment | 2 | TRANSACTIVITY | Transaction Activity (E-HA) | nvarchar | 2 | 0 | | |
11 | THMEXT_TRANS | E-HA: Transactions | 8 | TRANSACTIVITY | Transaction Activity (E-HA) | nvarchar | 2 | 0 | | |