| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRET_PROTOCOL | Transactions Generated for Endowments | 3 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
2 | TRET_TRANSACTION | Transactions to Be Created for Endowments | 3 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
3 | TRFT_BUSTRANS | Treasury: TRF Business Transaction | 6 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
4 | TRFT_FLOW | Treasury: Table with TRF Flows | 12 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
5 | TRFT_MAN_POST | Manual Posting | 7 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
6 | TRFT_MATCH_TRANS | Treasury: Matching Process Business Transaction | 6 | POSITION_DATE | Posting Date for the Subledger | nvarchar | 8 | 0 | | |
7 | TRFT_SUBTOTAL | Treasury: Table with TRF Transaction Figure | 3 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
8 | TRFT_SUBTRANS | Treasury: TRF Business Subtransaction | 3 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
9 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 20 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
10 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 20 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
11 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 7 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
12 | TRST_POS_CHG | CFM: Securities Account Position Change | 6 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
13 | TRST_RECON_RCE | Treasury: External Securities Account Statement | 7 | POSITION_DATE | Key Date in External Securities Account Statement | nvarchar | 8 | 0 | | |
14 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 11 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
15 | TRST_SUBTOTAL | Treasury: Table with Trans.Figs - Class Pos. in Sec. Acct | 8 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
16 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 11 | POSITION_DATE | Position Date - Corporate Action | nvarchar | 8 | 0 | | |
17 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 13 | POSITION_DATE | Position Date: Rights that can be Exercised | nvarchar | 8 | 0 | | |
18 | SLDT_TRANSACTION | Subledger Distributor Business Transactions | 15 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
19 | TCAT_FLOW | Flow Table of the Corporate Actions | 14 | POSITION_DATE | Position Date - Corporate Action | nvarchar | 8 | 0 | | |
20 | TCORT_COSA | Security Account Transfer: Main Data | 9 | POSITION_DATE | Key Date in External Securities Account Statement | nvarchar | 8 | 0 | | |
21 | TCORT_COSAFL | Security Account Transfer: Flows | 10 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
22 | TCORT_COSAPO | Security Account Transfer: Positions | 10 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
23 | TERT_FLOW | Flow Table for Rights that can be Exercised | 35 | POSITION_DATE | Position Date: Rights that can be Exercised | nvarchar | 8 | 0 | | |
24 | TRDT_TRDBUSTRANS | Treasury: Persistent distributor business transaction | 16 | POSITION_DATE | Posting Date for the Subledger | nvarchar | 8 | 0 | | |
25 | TRQT_BUSTRANS | Treasury: Business Transactions | 7 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
26 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 14 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
27 | TRQT_LOT | Treasury: Lot | 3 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
28 | TRQT_LOTFLOW | Treasury: Table with Lot Flows | 12 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
29 | TRQT_SUBTOTAL | Treasury: Table with Quantity Ledger Position Trans. Figures | 3 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
TOPTransfer to Financial Accounting |
30 | TRLT_DERIVTRANS | Derived Business Transactions | 8 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
31 | TRSET_BUSTRANS | OLD! Preliminary Solution: Transferred Sec. Bus.Transactions | 4 | POSITION_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
TOPTreasury and Risk Management |
32 | TREAT_FLOW | Treasury: TREA Flows | 9 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |
33 | TREAT_SUBTOTAL | TREA: Position Subtotal | 5 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | | |