| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTransaction Management |
1 | THXET_MEAS_EFFRT | Effectiveness Test: Hedge Ratio Results. | 10 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
TOPTransaction Manager |
2 | SLDT_FLOW | Subledger Distributor Transactions | 39 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
3 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 15 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
4 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 13 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
5 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
6 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 13 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
7 | TRDTT_VAD_FUTSUB | Valuation Area-Dependent Data for Futures with Subpositions | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
8 | TRDTT_VAD_OTCSUB | Val.Area-Dependent Data for MM, FX, OTC Deriv. w. Subpos. | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
9 | TRDTT_VAD_SECSUB | Valuation Area-Dependent Data for Securities w. Subpositions | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
10 | TRDT_FLOW | Persistent distributor flows | 37 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
11 | TRGC_TAC_VA | Assignment of Accounting Code to Valuation Area | 4 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
12 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 21 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
TOPTransfer to Financial Accounting |
13 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 19 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
14 | TLVT_VAL_FLOW | Treasury: Valuation Flow | 10 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
15 | TLVT_VAL_STEP | Treasury: Valuation Step | 14 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
16 | TRILT_DFLOW | Derived Flows in the Income Ledger | 9 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
17 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 23 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
18 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 16 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
19 | TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition | 12 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
20 | TRLT_FLOW | Treasury Ledger Flows | 19 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
21 | TRLT_FS_COMP | TR Ledger: Transaction Figures per Component | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
22 | TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition | 12 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
23 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 17 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
24 | TRLT_INIT_SUB_OT | Init.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos. | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
25 | TRLT_INIT_SUB_SE | Init.Hedging Relationship for Securities with Subpositions | 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
26 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 12 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
27 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 9 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
28 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 15 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |
29 | TRLT_POSITION | Treasury Ledger Position | 5 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | |