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