| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | THAEXT_EXPOS_COP | Obsolet: Commodity exposure pricing data | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
2 | THAEXT_TRANS_COP | Commodity exposure pricing data | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
3 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
TOPTransaction Management |
4 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 8 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
TOPTransaction Manager |
5 | THAEXT_EXPOS_CO | Commodity exposure | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
6 | THAEXT_EXP_HDG | E-HA: Relationship Table Exposure - Hedged Item | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
7 | THAEXT_TRANS_CO | Transaction for commodity price exposure | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
8 | THMEXT_EXPOS | E-HA: Exposure Created by Transactions | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
9 | THMEXT_EXPOS_FX | E-HA: Exposure Created by Transactions | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
10 | THMEXT_EXPOS_IR | E-HA: Exposure Created by Transactions | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
11 | THMEXT_LOG | Log: External Exposure Data Applied to E-HA | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
12 | THMEXT_PLANNER | E-HA: Hedge Plan | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
13 | THMEXT_ROLL_LOG | Log: Rollover of contracts linked to RO created exposures | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
14 | THMEXT_TRANS | E-HA: Transactions | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
15 | THMEXT_TRANS_FX | E-HA: Transactions | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |
16 | THMEXT_TRANS_IR | E-HA: IR Transactions | 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | | |