| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BCKTRDT_MULTASSG | Multiple Account Assignment of Flows | 9 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
2 | BCKTRLT_VCL_FLOW | Flows Valuation Class Transfer | 5 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
TOPBack Office |
3 | TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
4 | TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
5 | TRSB_POSCHG_FLOW | CFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos. | 5 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
6 | TRSB_SECACCTRANS | CFM: Backup Table for Securities Account Transfer | 5 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
7 | TRSB_SUBTOTAL | CFM: Backup Table with Transaction Figures | 5 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
8 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 23 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
9 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 23 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
10 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 6 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
11 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 14 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
12 | TRST_SUBTOTAL | Treasury: Table with Trans.Figs - Class Pos. in Sec. Acct | 6 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
TOPTransaction Management |
13 | THXT_HR_FLOWS | Treasury: Hedging Relationship Flows | 9 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
14 | THXT_MD_PV | market data present value | 12 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
TOPTransaction Manager |
15 | BCKSLDT_FLOW | Backup: Subledger Distributor: Trans. Before Issue Currency | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
16 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 14 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
17 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 16 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
18 | BCKTRDT_FLOW | Backup: Distributor Flows Before Issue Currency Changeover | 6 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
19 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 16 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
20 | SLDT_FLOW | Subledger Distributor Transactions | 30 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
21 | TCAT_FLOW | Flow Table of the Corporate Actions | 17 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
22 | TCORT_COSAFL | Security Account Transfer: Flows | 9 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
23 | TCORT_COSAPO | Security Account Transfer: Positions | 9 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
24 | TERT_FLOW | Flow Table for Rights that can be Exercised | 38 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
25 | TERT_TRANSACTION | Business Transaction: Exercise of Rights | 18 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
26 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 15 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
27 | TRDT_FLOW | Persistent distributor flows | 28 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
28 | TRDT_MULTASSGN | Multiple Account Assignment of Flows | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
29 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
30 | TRQB_FLOW | CFM: Backup Table for Flow Data in Quantity Ledger | 5 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
31 | TRQB_LOTFLOW | CFM: Backup Table with Lot Flows | 5 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
32 | TRQB_SUBTOTAL | CFM: Backup Table with Quantity Ledger Pos. Transact. Figs | 4 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
33 | TRQT_ASSIGN_HIST | CFM: Lot Assignment History | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
34 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 9 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
35 | TRQT_INIT_LOT | (obsolete) | 9 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
36 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 7 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
37 | TRQT_SUBTOTAL | Treasury: Table with Quantity Ledger Position Trans. Figures | 4 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
38 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 6 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
TOPTransfer to Financial Accounting |
39 | BCKTRLT_DERIVFLO | Treasury: Flows for Derived Business Transactions | 12 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
40 | BCKTRLT_FLOW | Treasury Ledger Flows | 8 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
41 | TLVT_VAL_STEP | Treasury: Valuation Step | 22 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
42 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 18 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
43 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 11 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
44 | TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition | 7 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
45 | TRLT_FLOW | Treasury Ledger Flows | 12 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
46 | TRLT_FS_COMP | TR Ledger: Transaction Figures per Component | 6 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
47 | TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition | 7 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
48 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 10 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
49 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 18 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |
TOPTreasury and Risk Management |
50 | TREAT_FLOW | Treasury: TREA Flows | 23 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | |