| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTransaction Manager |
| 1 | THAHRT_ASS_PROSP | Retrospective effectiveness assessment result | 7 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 2 | THAHRT_EFF_HEAD | Effectiveness test result header | 7 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 3 | THAHRT_EXT_RETRO | External Retrospective Assessment | 5 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 4 | THMHRT_ASS_RETRO | Retrospective effectiveness assessment result | 7 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 5 | THMHRT_CASH_FLOW | Calculated cash flows for effectiveness | 6 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 6 | THMHRT_EXT_PROS | External Prospective Assessment | 5 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 7 | THMHRT_HI_MEAS | Fair value change of the hedge comp. in an effective hedge | 6 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 8 | THMHRT_HR | Hedge Relationship | 5 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 9 | THMHRT_HR_STRAT | Effectiveness strategy for the hedging relationship | 5 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 10 | THMHRT_HR_VAL | Valuation details for the hedging relationship | 5 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 11 | THMHRT_MEASURE | Effectiveness measurement result | 6 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
| 12 | TPMHRT_EXT_RETRO | External Retrospective Assessment | 5 | HR_VERSION | Version of the hedging relationship | nvarchar | 3 | 0 | | |
