| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting |
1 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 54 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
TOPBack Office |
2 | TPMT_DEDOC_LOTPO | Derivatives Document: Document Item Per Lot | 7 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
3 | TPMT_DEDOC_POS | Derivatives Document: Document Item | 6 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
4 | TPMT_LOT_HEADER | Single Position Master Data for TR Position Management | 13 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
TOPGermany |
5 | TZBCKVWBEPI | Backup: Flow data - Position/Actual | 6 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
TOPLoans Management |
6 | BCKTRLET_LOAN_FL | Treasury: Loans Transferred | 11 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
7 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 50 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
8 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 18 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
9 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 50 | SNWHR | Währung des Nominalbetrages | nvarchar | 5 | 0 | | |
10 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 51 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
11 | VDARC_DOC_REC_EU | Carry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn | 7 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
12 | VDBEPI | Posted line items for document header | 9 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
13 | VDBEPI_EU | Flow Data / Actual Position Before EURO Conversion | 6 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
14 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 9 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
15 | VDBEPP | Flow Data - Planned Item | 38 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
16 | VDBEPP_EU | Flow Data / Planned Items Before EURO Changeover | 8 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
17 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 38 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
18 | VDBOBEPP_EU | Flow Data / Planned Items Before EURO Changeover | 9 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
19 | VDCFWAREHOUSE | Cash Flow Management | 55 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
20 | VDORDER | Borrower's note loan order data | 24 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
21 | VDORDER_EU | Order Data for Borrower's Note Loans Before EURO Conversion | 6 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
22 | VDVORTR | Loan carry-forward totals | 10 | SNWHR | Currency Key | nvarchar | 5 | 0 | | |
23 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 41 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
TOPReal Estate Management |
24 | VIBEPP | Flow data - Planned items for real estate management | 65 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
TOPRisk Analysis |
25 | JBRDBBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 18 | SNWHR | Currency of nominal amount base | nvarchar | 5 | 0 | | |
26 | JBRHBEWEG | RM: Version Table BEWEG for Extended Cat. of Primary Trans. | 19 | SNWHR | Currency of nominal amount base | nvarchar | 5 | 0 | | |
27 | JBRSVBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 19 | SNWHR | Currency of nominal amount base | nvarchar | 5 | 0 | | |
TOPTransaction Management |
28 | TCHT_HD_BEWEG_CF | SFGDT FGET Cashflows Table | 18 | SNWHR | Currency of nominal amount base | nvarchar | 5 | 0 | | |
TOPTransaction Manager |
29 | BCKVWBEPI | Backup: Flow data - Position/Actual | 6 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
30 | BCKVWBEPP | BACKUP: Flow data - Position/Planned | 9 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
31 | BCKVWBWKM | BACKUP: Flow table for corporate actions | 9 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
32 | BCKVWORDE | BACKUP: Order data | 8 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
33 | BCKVWVORTR | BACKUP: Carryover totals - securities | 10 | SNWHR | Currency Key | nvarchar | 5 | 0 | | |
34 | BCKVWZUORD | BACKUP: SEC assignment table for restraints on disposal | 7 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
35 | TERTINERKO | Header Information for Executing Security Rights | 11 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
36 | TERTVWBWER | TRTM-PM: Flow Table for Executable Rights | 31 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
37 | TRQT_VWVORTR_LOT | (obsolete) | 12 | SNWHR | Currency Key | nvarchar | 5 | 0 | | |
38 | VTBFSEC | Securities Collateral | 8 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
39 | VWBEPI | Treasury Securities: Actual Flows - Item | 16 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
40 | VWBEPP | Treasury Securities: Planned Flows | 24 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
41 | VWBWKM | TRTM-PM: Flow table for corporate actions | 30 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
42 | VWORDE | Order Data | 24 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
43 | VWVORTR | Securities: Carry-Forward Totals | 11 | SNWHR | Currency Key | nvarchar | 5 | 0 | | |
44 | VWZUORD | Securities Assignment Table for Restraints on Disposal | 8 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |
TOPTreasury |
45 | VTIDERI | Master Data Listed Options and Futures | 40 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | | |