| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 21 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPAccounting |
2 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 8 | DBERVON | From Date for Flow Type Grouping for Interest on Arrears | nvarchar | 8 | 0 | | |
3 | VDIOA_CALC_HEAD | Calculation Details for Interest on Arrears Calculation | 7 | DBERVON | From Date for Flow Type Grouping for Interest on Arrears | nvarchar | 8 | 0 | | |
TOPAssetLiability Management |
4 | JBALMDLLOC | ALM: Higher-Level Data of Detailed Log | 8 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPBack Office |
5 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 61 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
6 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 61 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPInformation System |
7 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 56 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPLoans Management |
8 | TDESRVDINVIH | CML Corr.: Invoice Header | 23 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
9 | TDESRVDINVIP | CML Corr.: Invoice Positions | 22 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
10 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 34 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
11 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 53 | DBERVON | Berechnungszeitraumbeginn | nvarchar | 8 | 0 | | |
12 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 35 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
13 | VDBEPI | Posted line items for document header | 23 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
14 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 23 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
15 | VDBEPP | Flow Data - Planned Item | 50 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
16 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 50 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
17 | VDCFWAREHOUSE | Cash Flow Management | 39 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
18 | VDORDER | Borrower's note loan order data | 36 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
19 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 53 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPReal Estate Contract |
20 | VICDCFOBJ | Object-Related Cash Flow | 17 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
21 | VICDCFPAY | Payment-Related Cash Flow | 17 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
22 | VIBEPP | Flow data - Planned items for real estate management | 52 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
23 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 14 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
24 | /BEV3/CHASTEU | Control Table | 7 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPRisk Analysis |
25 | JBRDBBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 12 | DBERVON | 'Calculate From' Date (Inclusive of that date) | nvarchar | 8 | 0 | | |
26 | JBRHBEWEG | RM: Version Table BEWEG for Extended Cat. of Primary Trans. | 13 | DBERVON | 'Calculate From' Date (Inclusive of that date) | nvarchar | 8 | 0 | | |
27 | JBRSVBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 13 | DBERVON | 'Calculate From' Date (Inclusive of that date) | nvarchar | 8 | 0 | | |
TOPTransaction Data Pool |
28 | JBCFBEWEG | Cash Flow Transaction: Flows | 17 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
29 | JBCFZSTRBEWEG | Cash Flow Transaction: Flow Data for Cash Flow | 18 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
TOPTransaction Management |
30 | TCHT_HD_BEWEG_CF | SFGDT FGET Cashflows Table | 12 | DBERVON | 'Calculate From' Date (Inclusive of that date) | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
31 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 66 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
32 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 51 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
33 | TERTVWBWER | TRTM-PM: Flow Table for Executable Rights | 56 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
34 | VTBFHAPO | Transaction Flow | 66 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
35 | VTBFHAPO_MIGR | Migrated Financial Flows | 66 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
36 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 66 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
37 | VTBPFHAPO | Treasury: Flow Shells | 55 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
38 | VTIFHAPO | Underlying transaction flows | 51 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
39 | VWBEPI | Treasury Securities: Actual Flows - Item | 46 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
40 | VWBEPP | Treasury Securities: Planned Flows | 84 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |
41 | VWORDE | Order Data | 74 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | | |