| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 37 | ATAGE | Number of Days | int | 10 | 0 | | |
TOPAccounting |
2 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 44 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
3 | VDIOA_CALC_HEAD | Calculation Details for Interest on Arrears Calculation | 28 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
TOPBack Office |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 75 | ATAGE | Number of Days | int | 10 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 75 | ATAGE | Number of Days | int | 10 | 0 | | |
TOPFlexible Real Estate Management |
6 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 18 | ATAGE | Anzahl Tage | nvarchar | 6 | 0 | | |
TOPLoans Management |
7 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 40 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
8 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 68 | ATAGE | Anzahl Tage | nvarchar | 6 | 0 | | |
9 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 41 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
10 | VDBEPI | Posted line items for document header | 59 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
11 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 59 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
12 | VDBEPP | Flow Data - Planned Item | 52 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
13 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 52 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
14 | VDCFWAREHOUSE | Cash Flow Management | 45 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
15 | VDORDER | Borrower's note loan order data | 38 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
16 | VDVORK | Table for preemption conditions | 11 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
17 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 55 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
TOPReal Estate Contract |
18 | VICDCFOBJ | Object-Related Cash Flow | 33 | ATAGE | Number of Days | int | 10 | 0 | | |
19 | VICDCFPAY | Payment-Related Cash Flow | 33 | ATAGE | Number of Days | int | 10 | 0 | | |
TOPReal Estate Management |
20 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 17 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
21 | VIBEPP | Flow data - Planned items for real estate management | 56 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
22 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 32 | ATAGE | Number of Days | int | 10 | 0 | | |
23 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
24 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
25 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
26 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
27 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
28 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
29 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
30 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
31 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
32 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
33 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
34 | /BEV3/CHTRMSTZ_P | CH Date Item | 88 | ATAGE | Number of Days | int | 10 | 0 | | |
35 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
36 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 89 | ATAGE | Number of Days | int | 10 | 0 | | |
TOPRisk Analysis |
37 | JBRDBBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 16 | ATAGE | Number of Days | nvarchar | 6 | 0 | | |
38 | JBRHBEWEG | RM: Version Table BEWEG for Extended Cat. of Primary Trans. | 17 | ATAGE | Number of Days | nvarchar | 6 | 0 | | |
39 | JBRSVBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 17 | ATAGE | Number of Days | nvarchar | 6 | 0 | | |
TOPSales Plan |
40 | T445Z | Period Split for Display of Time Axis | 3 | ATAGE | Number of days in display format for days | nvarchar | 3 | 0 | | |
TOPSocial Insurance |
41 | P01EE_DBFR | Data Module DBFR Entry Release from Work Illness of Child | 31 | ATAGE | Total Number of Working Days with Release from Work | nvarchar | 2 | 0 | | |
TOPTransaction Management |
42 | TCHT_HD_BEWEG_CF | SFGDT FGET Cashflows Table | 16 | ATAGE | Number of Days | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
43 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 68 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
44 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 53 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
45 | TRDT_SEC_FLOW | Persistent distributor flows: Part for BEPP adaptor | 34 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
46 | VTBFHAPO | Transaction Flow | 68 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
47 | VTBFHAPO_MIGR | Migrated Financial Flows | 68 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
48 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 68 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
49 | VTBPFHAPO | Treasury: Flow Shells | 57 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
50 | VTIFHAPO | Underlying transaction flows | 53 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
51 | VWBEPI | Treasury Securities: Actual Flows - Item | 48 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
52 | VWBEPP | Treasury Securities: Planned Flows | 86 | ATAGE | Number of days | nvarchar | 6 | 0 | | |
53 | VWORDE | Order Data | 76 | ATAGE | Number of days | nvarchar | 6 | 0 | | |