| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTransaction Manager |
1 | TCORT_CODMD | Deal: Main Data | 19 | TRANSACTION_CAT | Transaction Category | nvarchar | 3 | 0 | | |
2 | TEMT_POLICY | Hedging Policy | 5 | TRANSACTION_CAT | Transaction Category (E-HA) | nvarchar | 2 | 0 | | |
3 | TEMT_RAWEXPOS | Raw Exposure | 9 | TRANSACTION_CAT | Transaction Category (E-HA) | nvarchar | 2 | 0 | | |
4 | TEMT_VERSEXPOS | Versioned Exposure | 11 | TRANSACTION_CAT | Transaction Category (E-HA) | nvarchar | 2 | 0 | | |
5 | TEXC_MAP_IN | Mapping for Incoming Raw Exposures | 8 | TRANSACTION_CAT | Exposure Category of Raw Exposure | nvarchar | 2 | 0 | | |
6 | TEXT_POSITIONS | Exposure Positions | 8 | TRANSACTION_CAT | Exposure Category of Raw Exposure | nvarchar | 2 | 0 | | |
7 | TEXT_POS_FLOW | Exposure Position Flows | 7 | TRANSACTION_CAT | Exposure Category of Raw Exposure | nvarchar | 2 | 0 | | |
8 | TEXT_RAWEXPOS | Raw Exposure | 14 | TRANSACTION_CAT | Default Exposure Category | nvarchar | 2 | 0 | | |
9 | TEXT_REXP_SUBIT | Sub Raw Exposures (Split Items) | 19 | TRANSACTION_CAT | Exposure Category of Raw Exposure | nvarchar | 2 | 0 | | |
10 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 7 | TRANSACTION_CAT | Exposure Category of Raw Exposure | nvarchar | 2 | 0 | | |
TOPTreasury and Risk Management |
11 | ZTR_EXPOINTEGRAT | Maintain attributes for Exposure from other modules | 12 | TRANSACTION_CAT | Exposure Category of Raw Exposure | nvarchar | 2 | 0 | | |