| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInformation System |
1 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 13 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
TOPTransaction Management |
2 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 9 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
3 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 121 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | | |
4 | TCORT_CODFL | Deal: Flows | 49 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | | |
5 | THAEXT_EXP_HDG | E-HA: Relationship Table Exposure - Hedged Item | 6 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
6 | THAHRT_ASS_PROSP | Retrospective effectiveness assessment result | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
7 | THAHRT_EFF_HEAD | Effectiveness test result header | 6 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
8 | THAHRT_EXT_RETRO | External Retrospective Assessment | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
9 | THMEXT_EXPOS | E-HA: Exposure Created by Transactions | 5 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
10 | THMHRT_ASS_RETRO | Retrospective effectiveness assessment result | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
11 | THMHRT_CASH_FLOW | Calculated cash flows for effectiveness | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
12 | THMHRT_EXT_PROS | External Prospective Assessment | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
13 | THMHRT_HI_MEAS | Fair value change of the hedge comp. in an effective hedge | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
14 | THMHRT_HR | Hedge Relationship | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
15 | THMHRT_HR_STRAT | Effectiveness strategy for the hedging relationship | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
16 | THMHRT_HR_VAL | Valuation details for the hedging relationship | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
17 | THMHRT_MEASURE | Effectiveness measurement result | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
18 | THMT_HEDGE_ITEM | Hedged Item | 3 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
19 | TPMHRT_EXT_RETRO | External Retrospective Assessment | 4 | HEDGE_ID | Identification Number of Hedge Item | nvarchar | 10 | 0 | | |
20 | VTBFHAPO | Transaction Flow | 121 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | | |
21 | VTBFHAPO_MIGR | Migrated Financial Flows | 121 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | | |
22 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 121 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | | |
TOPTransfer to Financial Accounting |
23 | TRILT_DFLOW | Derived Flows in the Income Ledger | 6 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | | |