| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BCKTRLIT_AD_TRAN | Accrual/Deferral Business Transactions Backup | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
2 | BCKTRLT_VCL_FLOW | Flows Valuation Class Transfer | 8 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
3 | TREAT_CASH_POS | TREA: Cash Position | 7 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
4 | TREAT_MLM_PRCLOG | Treasury: Margin Limit Result Procedure Log | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
5 | TREAT_MLM_RESULT | Treasury: Margin Limit Result Entity | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
TOPBack Office |
6 | TRFB_FLOW | CFM: Backup Table with TRF Flows | 5 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
7 | TRFT_FLOW | Treasury: Table with TRF Flows | 11 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
8 | TRFT_MAN_PT_FLOW | TRF: Flows for Manual Posting | 7 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
9 | TRFT_MATCH_FLOW | Treasury: Table with Matching Process Flows | 11 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
10 | TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account | 5 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
11 | TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account | 5 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
12 | TRSB_POSCHG_FLOW | CFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos. | 8 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
13 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 18 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
14 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 18 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
15 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
TOPTransaction Manager |
16 | BCKSLDT_FLOW | Backup: Subledger Distributor: Trans. Before Issue Currency | 11 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
17 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 17 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
18 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 19 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
19 | BCKTRDT_FLOW | Backup: Distributor Flows Before Issue Currency Changeover | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
20 | SLDT_FLOW | Subledger Distributor Transactions | 33 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
21 | TCAT_FLOW | Flow Table of the Corporate Actions | 20 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
22 | TERT_FLOW | Flow Table for Rights that can be Exercised | 41 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
23 | TRDT_FLOW | Persistent distributor flows | 31 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
24 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 19 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
25 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 27 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
26 | TRQB_FLOW | CFM: Backup Table for Flow Data in Quantity Ledger | 8 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
27 | TRQB_LOTFLOW | CFM: Backup Table with Lot Flows | 8 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
28 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 12 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
29 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 10 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
30 | TRXT_FLOW | TRM Tax Transaction Flows | 13 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
TOPTransfer to Financial Accounting |
31 | BCKTLVT_VAL_FLOW | Backup: Treasury: Valuation Flow | 7 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
32 | BCKTRACT_ACCITEM | Treasury: Accounting Items | 5 | POSITION_AMT | Amount in Transaction Currency | decimal | 21 | 2 | | |
33 | BCKTRLT_DERIVFLO | Treasury: Flows for Derived Business Transactions | 8 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
34 | BCKTRLT_FLOW | Treasury Ledger Flows | 11 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
35 | TLVT_VAL_FLOW | Treasury: Valuation Flow | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
36 | TRACT_ACCITEM | Accounting Items | 12 | POSITION_AMT | Amount in Transaction Currency | decimal | 21 | 2 | | |
37 | TRILT_DFLOW | Derived Flows in the Income Ledger | 8 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
38 | TRLTS_INIT_COMP | Mapping of Position Components to Treasury Ledger | 4 | POSITION_AMT | Field name | nvarchar | 30 | 0 | | |
39 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 20 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
40 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 14 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
41 | TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition | 10 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
42 | TRLT_FLOW | Treasury Ledger Flows | 16 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
43 | TRLT_FS_COMP | TR Ledger: Transaction Figures per Component | 9 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
44 | TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition | 10 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
TOPTreasury and Risk Management |
45 | TREAT_FLOW | Treasury: TREA Flows | 25 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |
46 | TREAT_SUBTOTAL_C | TREA: Subtotal Components | 5 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | |