| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BCKTRDT_MULTASSG | Multiple Account Assignment of Flows | 12 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
2 | J_3RF_CTS_I | Currency Transaction Statement Document Items | 15 | PAYMENT_CURR | Currency Key | nvarchar | 5 | 0 | | |
3 | TREAT_STATEM_ITM | Clearing Account Statement Detail | 6 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
TOPBack Office |
4 | TRFT_MAN_PT_FLOW | TRF: Flows for Manual Posting | 11 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
5 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 28 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
6 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 28 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
7 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 14 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
TOPTransaction Manager |
8 | BCKSLDT_FLOW | Backup: Subledger Distributor: Trans. Before Issue Currency | 13 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
9 | BCKTRDT_FLOW | Backup: Distributor Flows Before Issue Currency Changeover | 11 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
10 | FDC1 | Cash Management Shadow table | 16 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
11 | SLDT_FLOW | Subledger Distributor Transactions | 47 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
12 | TCORT_CODFL | Deal: Flows | 21 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
13 | TCORT_CODUL2FL | Deal: 2nd Underlying's Flows | 24 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
14 | TCORT_CODULFL | Deal: Underlying Flows | 23 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
15 | TCORT_COSAFL | Security Account Transfer: Flows | 14 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
16 | TERT_FLOW | Flow Table for Rights that can be Exercised | 20 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
17 | TRCT_FLOW | Table of business transactions flows | 15 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
18 | TRDT_FLOW | Persistent distributor flows | 45 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
19 | TRDT_MULTASSGN | Multiple Account Assignment of Flows | 11 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
20 | TRQB_FLOW | CFM: Backup Table for Flow Data in Quantity Ledger | 10 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
21 | TRQB_LOTFLOW | CFM: Backup Table with Lot Flows | 10 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
22 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 21 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
23 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 16 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
24 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 10 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
TOPTransfer to Financial Accounting |
25 | TRPRT_PAYMENTS | Persistent Data for Payment Requests | 13 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |
TOPTreasury and Risk Management |
26 | TREAT_CLEAR_ACC | Treasury: Clearing Account Specific Data | 11 | PAYMENT_CURR | Payment Currency of Clearing Account | nvarchar | 5 | 0 | | |
27 | TREAT_FLOW | Treasury: TREA Flows | 30 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | |