| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BCKTRLIT_AD_TRAN | Accrual/Deferral Business Transactions Backup | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
2 | BCKTRLT_VCL_FLOW | Flows Valuation Class Transfer | 9 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
3 | TREAT_CASH_POS | TREA: Cash Position | 6 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
4 | TREAT_MLM_PRCLOG | Treasury: Margin Limit Result Procedure Log | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
5 | TREAT_MLM_RESULT | Treasury: Margin Limit Result Entity | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
TOPBack Office |
6 | TRFB_CLASS_POS | CFM: Backup Table for TRF Class Position | 4 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
7 | TRFB_FLOW | CFM: Backup Table with TRF Flows | 4 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
8 | TRFB_SUBTOTAL | CFM: Backup Table with TRF Transaction Figures | 5 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
9 | TRFB_SUBTRANS | CFM: Backup Table for TRF Business Subtransaction | 5 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
10 | TRFT_CLASS_POS | Treasury: TRF Class Position | 6 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
11 | TRFT_FLOW | Treasury: Table with TRF Flows | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
12 | TRFT_MAN_PT_FLOW | TRF: Flows for Manual Posting | 6 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
13 | TRFT_MATCH_FLOW | Treasury: Table with Matching Process Flows | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
14 | TRFT_SUBTOTAL | Treasury: Table with TRF Transaction Figure | 6 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
15 | TRFT_SUBTRANS | Treasury: TRF Business Subtransaction | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
16 | TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account | 4 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
17 | TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account | 4 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
18 | TRSB_POSCHG_FLOW | CFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos. | 7 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
19 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 17 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
20 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 17 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
21 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
TOPTransaction Manager |
22 | BCKSLDT_FLOW | Backup: Subledger Distributor: Trans. Before Issue Currency | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
23 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 16 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
24 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 18 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
25 | BCKTRDT_FLOW | Backup: Distributor Flows Before Issue Currency Changeover | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
26 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 12 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
27 | SLDT_FLOW | Subledger Distributor Transactions | 32 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
28 | TCAT_FLOW | Flow Table of the Corporate Actions | 19 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
29 | TERT_FLOW | Flow Table for Rights that can be Exercised | 40 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
30 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 11 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
31 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 14 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
32 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 12 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
33 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
34 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 12 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
35 | TRDTT_VAD_FUTSUB | Valuation Area-Dependent Data for Futures with Subpositions | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
36 | TRDTT_VAD_OTCSUB | Val.Area-Dependent Data for MM, FX, OTC Deriv. w. Subpos. | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
37 | TRDTT_VAD_SECSUB | Valuation Area-Dependent Data for Securities w. Subpositions | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
38 | TRDT_FLOW | Persistent distributor flows | 30 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
39 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 18 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
40 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 28 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
41 | TRQB_FLOW | CFM: Backup Table for Flow Data in Quantity Ledger | 7 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
42 | TRQB_LOTFLOW | CFM: Backup Table with Lot Flows | 7 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
43 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 11 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
44 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 9 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
45 | TRXT_FLOW | TRM Tax Transaction Flows | 12 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
TOPTransfer to Financial Accounting |
46 | BCKTLVT_VAL_FLOW | Backup: Treasury: Valuation Flow | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
47 | BCKTRACT_ACCITEM | Treasury: Accounting Items | 6 | POSITION_CURR | Transaction Currency | nvarchar | 5 | 0 | | |
48 | BCKTRLT_DERIVFLO | Treasury: Flows for Derived Business Transactions | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
49 | BCKTRLT_FLOW | Treasury Ledger Flows | 13 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
50 | BCKTRLT_POSITION | Backup: Treasury Ledger Position | 6 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
51 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 17 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
52 | TLVT_VAL_FLOW | Treasury: Valuation Flow | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
53 | TLVT_VAL_STEP | Treasury: Valuation Step | 13 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
54 | TRACT_ACCITEM | Accounting Items | 13 | POSITION_CURR | Transaction Currency | nvarchar | 5 | 0 | | |
55 | TRAC_ACCSYMBREP2 | OLD: Prelim. Solut.: Replace Acct Symbols per Acct Ass.Ref. | 6 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
56 | TRILT_DFLOW | Derived Flows in the Income Ledger | 7 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
57 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 21 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
58 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 13 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
59 | TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition | 9 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
60 | TRLT_FLOW | Treasury Ledger Flows | 17 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
61 | TRLT_FS_COMP | TR Ledger: Transaction Figures per Component | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
62 | TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition | 9 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
63 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 16 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
64 | TRLT_INIT_SUB_OT | Init.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos. | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
65 | TRLT_INIT_SUB_SE | Init.Hedging Relationship for Securities with Subpositions | 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
66 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 11 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
67 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 8 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
68 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 14 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
69 | TRLT_POSITION | Treasury Ledger Position | 4 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
TOPTreasury and Risk Management |
70 | TREAT_FLOW | Treasury: TREA Flows | 24 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |
71 | TREAT_SUBTOTAL_C | TREA: Subtotal Components | 4 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | |