| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTransaction Manager |
1 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 76 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
2 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 60 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
3 | VTBFHAPO | Transaction Flow | 76 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
4 | VTBFHAPO_MIGR | Migrated Financial Flows | 76 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
5 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 76 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
6 | VTBFIOR | FI: open requests | 12 | WBASIS | Base currency (usually local currency) | nvarchar | 5 | 0 | | |
7 | VTBMMOR | MM: open requests | 12 | WBASIS | Base currency (usually local currency) | nvarchar | 5 | 0 | | |
8 | VTBMROR | invoice verification: open requests | 12 | WBASIS | Base currency (usually local currency) | nvarchar | 5 | 0 | | |
9 | VTBPFHAPO | Treasury: Flow Shells | 68 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
10 | VTBSI | Hedges | 10 | WBASIS | Base currency (usually local currency) | nvarchar | 5 | 0 | | |
11 | VTBSIANF | **Caution! Do not use. Will be deleted!! | 15 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |
12 | VTBSIZU | Hedge Allocation | 9 | WBASIS | Base currency (usually local currency) | nvarchar | 5 | 0 | | |
13 | VTIFHAPO | Underlying transaction flows | 60 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | | |