| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TPMT_DEDOC_POS | Derivatives Document: Document Item | 16 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
2 | TPMT_DEPAL_FLOWS | Listed Futures: Price Gain Records | 8 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
3 | TPMT_LOT_HEADER | Single Position Master Data for TR Position Management | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
4 | TPMT_POS_IND_DE | Allocation of Acct Assignment Reference to Position | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPBasic Functions |
5 | FDT1 | CMF Line Items for Forex, Money Market, Derivatives | 16 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
6 | FDW1 | Cash Mgt and Forecast - Securities Line Items- Planned Flows | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPInformation System |
7 | FTI_MARKET_VALS | Reporting: Buffer Table for Market Values - Position Crcy | 6 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
8 | FTI_MARKET_VALST | Reporting: Buffer Table for Market Values - Evaluation Crcy | 6 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPLoans Management |
9 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 11 | RLDEPO | Depot | nvarchar | 10 | 0 | | |
10 | VDKOREF | Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. | 5 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
11 | VDSDV5 | Collateral in securities in acc. with BAV/PRF5 | 36 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPRisk Analysis |
12 | JBRDBABEST | RM: DB Table ABEST Fields | 3 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
13 | JBRHABEST | RM: Version Table for ABEST Fields | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
14 | JBRSVABEST | RM: Header Table SDTFT (Additional Info.) for Saved Datasets | 14 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPTransaction Data Pool |
15 | JBDBAEND | Position Changes | 8 | RLDEPO | Source Securities Account | nvarchar | 10 | 0 | | |
16 | JBDBSTD | SAP Banking: Positions | 8 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPTransaction Management |
17 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 34 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
18 | BCKVWBEPP | BACKUP: Flow data - Position/Planned | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
19 | BCKVWBWKM | BACKUP: Flow table for corporate actions | 3 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
20 | BCKVWVORTR | BACKUP: Carryover totals - securities | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
21 | IDCFMBRSETX_HST | History table for taxation | 18 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
22 | IDCFMSETX_CUST | Cusotmizing for tax posting to FI for funds - Brazil | 5 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
23 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 96 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
24 | TCORC_SECAC_ALRT | Customizing Alert for CO of security account | 3 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
25 | TERTVWBWER | TRTM-PM: Flow Table for Executable Rights | 3 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
26 | TPMTVMFL | Position management variation margin flows at sec. account | 9 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
27 | TRGT_TRANS_REVAL | Table with Revaluation Structures for Transfer to TR Ledger | 5 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
28 | TRQT_VWVORTR_LOT | (obsolete) | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
29 | TWD01 | Treasury: Securities Account Master Data | 3 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
30 | VTBFHA | Transaction | 37 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
31 | VTBFHAPO | Transaction Flow | 96 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
32 | VTBFHAPO_MIGR | Migrated Financial Flows | 96 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
33 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 96 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
34 | VTIFHA | Underlying transaction | 35 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
35 | VWBEKI | Treasury Securities: Actual Flows - Header | 5 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
36 | VWBEPP | Treasury Securities: Planned Flows | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
37 | VWBWKM | TRTM-PM: Flow table for corporate actions | 3 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
38 | VWORDE | Order Data | 16 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
39 | VWPBDEP | Bank Securities Account Position | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
40 | VWPDEPO | Securities Account Position | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
41 | VWVORTR | Securities: Carry-Forward Totals | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
42 | VWZUORD | Securities Assignment Table for Restraints on Disposal | 16 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |
TOPTreasury and Risk Management |
43 | TZWR1 | Valuation in sec.acct position | 4 | RLDEPO | Securities Account | nvarchar | 10 | 0 | | |