| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BCKTRLIT_AD_TRAN | Accrual/Deferral Business Transactions Backup | 10 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
TOPBack Office |
2 | TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account | 6 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
3 | TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account | 6 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
4 | TRSB_POSCHG_FLOW | CFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos. | 9 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
5 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 19 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
6 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 19 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
7 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 10 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
TOPTransaction Manager |
8 | BCKSLDT_FLOW | Backup: Subledger Distributor: Trans. Before Issue Currency | 12 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
9 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 20 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
10 | BCKTRDT_FLOW | Backup: Distributor Flows Before Issue Currency Changeover | 10 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
11 | SLDT_FLOW | Subledger Distributor Transactions | 34 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
12 | TERT_FLOW | Flow Table for Rights that can be Exercised | 42 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
13 | TRDT_FLOW | Persistent distributor flows | 32 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
14 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 20 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
15 | TRQB_FLOW | CFM: Backup Table for Flow Data in Quantity Ledger | 9 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
16 | TRQB_LOTFLOW | CFM: Backup Table with Lot Flows | 9 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
17 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 13 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
18 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 11 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
TOPTransfer to Financial Accounting |
19 | BCKTLVT_VAL_FLOW | Backup: Treasury: Valuation Flow | 9 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
20 | BCKTRLT_DERIVFLO | Treasury: Flows for Derived Business Transactions | 9 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
21 | BCKTRLT_FLOW | Treasury Ledger Flows | 12 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
22 | TLVT_VAL_FLOW | Treasury: Valuation Flow | 12 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
23 | TRLTS_INIT_COMP | Mapping of Position Components to Treasury Ledger | 6 | POSAMT_IDX_CLEAN | Field name | nvarchar | 30 | 0 | | |
24 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 15 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
25 | TRLT_FBP_CMP_VAL | Flow Backpack Values for Each Component and Subposition | 11 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
26 | TRLT_FLOW | Treasury Ledger Flows | 15 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
27 | TRLT_FS_COMP | TR Ledger: Transaction Figures per Component | 10 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |
28 | TRLT_FS_SUB_COMP | Transaction Figures for Each Component and Subposition | 11 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | |