| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTransaction Manager |
1 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 14 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
2 | SLDT_FLOW | Subledger Distributor Transactions | 36 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
3 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 13 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
4 | TRDTT_POS_SEC | Position Information for Securities | 10 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
5 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 14 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
6 | TRDTT_VAD_SECSUB | Valuation Area-Dependent Data for Securities w. Subpositions | 12 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
7 | TRDT_FLOW | Persistent distributor flows | 34 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
TOPTransfer to Financial Accounting |
8 | TRLT_INIT_SUB_SE | Init.Hedging Relationship for Securities with Subpositions | 12 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
9 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 16 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
10 | TRLT_POSITION | Treasury Ledger Position | 6 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |
TOPTreasury and Risk Management |
11 | TREAT_FLOW | Treasury: TREA Flows | 16 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | nvarchar | 1 | 0 | | |