| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 20 | BNWHR | Nominal amount | decimal | 23 | 2 | | |
TOPAccounting |
2 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 55 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
TOPBack Office |
3 | TPMT_DEDOC_LOTPO | Derivatives Document: Document Item Per Lot | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
4 | TPMT_DEDOC_POS | Derivatives Document: Document Item | 7 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
5 | TPMT_LOT_HEADER | Single Position Master Data for TR Position Management | 12 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
TOPGermany |
6 | TZBCKVWBEPI | Backup: Flow data - Position/Actual | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
TOPLoans Management |
7 | BCKTRLET_LOAN_FL | Treasury: Loans Transferred | 10 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
8 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 51 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
9 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 17 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
10 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 51 | BNWHR | Nominalbetrag / Nennbetrag | decimal | 13 | 2 | | |
11 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 52 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
12 | VDARC_DOC_REC_EU | Carry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
13 | VDAVIS | Payment advice note table | 5 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
14 | VDBEPI | Posted line items for document header | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
15 | VDBEPI_EU | Flow Data / Actual Position Before EURO Conversion | 5 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
16 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
17 | VDBEPP | Flow Data - Planned Item | 37 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
18 | VDBEPP_EU | Flow Data / Planned Items Before EURO Changeover | 7 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
19 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 37 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
20 | VDBOBEPP_EU | Flow Data / Planned Items Before EURO Changeover | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
21 | VDCFWAREHOUSE | Cash Flow Management | 56 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
22 | VDORDER | Borrower's note loan order data | 23 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
23 | VDORDER_EU | Order Data for Borrower's Note Loans Before EURO Conversion | 5 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
24 | VDREPAYMENT | Payoff Master Data | 63 | BNWHR | Nominal Payoff Amount | decimal | 13 | 2 | | |
25 | VDVORTR | Loan carry-forward totals | 11 | BNWHR | Totals storage for group values | decimal | 15 | 2 | | |
26 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 40 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
TOPReal Estate Contract |
27 | VICDCFOBJ | Object-Related Cash Flow | 16 | BNWHR | Nominal amount | decimal | 23 | 2 | | |
28 | VICDCFPAY | Payment-Related Cash Flow | 16 | BNWHR | Nominal amount | decimal | 23 | 2 | | |
TOPReal Estate Management |
29 | VIBEPP | Flow data - Planned items for real estate management | 64 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
TOPRemaining Beverage - Obsolete Objects |
30 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 11 | BNWHR | Nominal amount | decimal | 23 | 2 | | |
TOPRisk Analysis |
31 | JBRDBBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 19 | BNWHR | Nominal amount base for cash flow determination | decimal | 17 | 2 | | |
32 | JBRHBEWEG | RM: Version Table BEWEG for Extended Cat. of Primary Trans. | 20 | BNWHR | Nominal amount base for cash flow determination | decimal | 17 | 2 | | |
33 | JBRSVBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 20 | BNWHR | Nominal amount base for cash flow determination | decimal | 17 | 2 | | |
TOPTransaction Data Pool |
34 | JBDBEWE | Position Flows Generated by Position Changes | 9 | BNWHR | Position - Nominal Amount | decimal | 17 | 2 | | |
TOPTransaction Management |
35 | TCHT_HD_BEWEG_CF | SFGDT FGET Cashflows Table | 19 | BNWHR | Nominal amount base for cash flow determination | decimal | 17 | 2 | | |
TOPTransaction Manager |
36 | BCKVTBFHAPO | Backup: Transaction Flows | 9 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
37 | BCKVWBEPI | Backup: Flow data - Position/Actual | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
38 | BCKVWBEPP | BACKUP: Flow data - Position/Planned | 11 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
39 | BCKVWBWKM | BACKUP: Flow table for corporate actions | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
40 | BCKVWORDE | BACKUP: Order data | 10 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
41 | BCKVWVORTR | BACKUP: Carryover totals - securities | 11 | BNWHR | Totals storage for group values | decimal | 15 | 2 | | |
42 | BCKVWZUORD | BACKUP: SEC assignment table for restraints on disposal | 6 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
43 | BCK_VTIFHAPO | Backup for Currency Changeover of Bond Underlying | 8 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
44 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 63 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
45 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 48 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
46 | TERTINERKO | Header Information for Executing Security Rights | 10 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
47 | TERTVWBWER | TRTM-PM: Flow Table for Executable Rights | 29 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
48 | TRQT_VWVORTR_LOT | (obsolete) | 13 | BNWHR | Totals storage for group values | decimal | 15 | 2 | | |
49 | VTBFHAPO | Transaction Flow | 63 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
50 | VTBFHAPO_MIGR | Migrated Financial Flows | 63 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
51 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 63 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
52 | VTBFSEC | Securities Collateral | 7 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
53 | VTBPFHAPO | Treasury: Flow Shells | 52 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
54 | VTIFHAPO | Underlying transaction flows | 48 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
55 | VWBEPI | Treasury Securities: Actual Flows - Item | 21 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
56 | VWBEPP | Treasury Securities: Planned Flows | 29 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
57 | VWBWKM | TRTM-PM: Flow table for corporate actions | 29 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
58 | VWORDE | Order Data | 29 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
59 | VWVORTR | Securities: Carry-Forward Totals | 12 | BNWHR | Totals storage for group values | decimal | 15 | 2 | | |
60 | VWZUORD | Securities Assignment Table for Restraints on Disposal | 7 | BNWHR | Nominal amount | decimal | 13 | 2 | | |
TOPTreasury |
61 | VTIDERI | Master Data Listed Options and Futures | 39 | BNWHR | Nominal amount | decimal | 13 | 2 | | |