| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDPT_CONDITION | Condition within Redemption Schedule | 21 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
2 | VIYCADVPAY | Advance Payments | 27 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPAccounting |
3 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 36 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPBack Office |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 67 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 67 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPBank Components |
6 | JBAFOKOPO | Condition Items | 8 | DVALUT | Value Date | nvarchar | 8 | 0 | | |
7 | JBASTCP | Standard Conditions: Condition Item | 10 | DVALUT | Value Date | nvarchar | 8 | 0 | | |
TOPLoans Management |
8 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 31 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
9 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 25 | DVALUT | Berechnungstag | nvarchar | 8 | 0 | | |
10 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 62 | DVALUT | Berechnungstag | nvarchar | 8 | 0 | | |
11 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 32 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
12 | VDBEPI | Posted line items for document header | 19 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
13 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 19 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
14 | VDBEPP | Flow Data - Planned Item | 46 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
15 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 46 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
16 | VDCFWAREHOUSE | Cash Flow Management | 36 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
17 | VDORDER | Borrower's note loan order data | 32 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
18 | VDVORTR | Loan carry-forward totals | 15 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
19 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 49 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPMaster Data |
20 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 24 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPReal Estate Contract |
21 | VICDCFOBJ | Object-Related Cash Flow | 23 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
22 | VICDCFPAY | Payment-Related Cash Flow | 23 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
23 | VIBEPP | Flow data - Planned items for real estate management | 22 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
24 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 20 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
25 | /BEV3/CHAKONDALT | Test transfer structure cash flow for conditions | 36 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPTransaction Data Pool |
26 | JBCFBEWEG | Cash Flow Transaction: Flows | 11 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
27 | JBCFZSTRBEWEG | Cash Flow Transaction: Flow Data for Cash Flow | 12 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
28 | JBDBEWE | Position Flows Generated by Position Changes | 6 | DVALUT | Interest Value Date/Calculation Date | nvarchar | 8 | 0 | | |
29 | JBDKOPO | Condition Items | 13 | DVALUT | Value Date | nvarchar | 8 | 0 | | |
30 | JBDKUMS | Turnovers for Business Partner Accounts | 6 | DVALUT | Value Date | nvarchar | 8 | 0 | | |
31 | JBDVTCP | Variable Transaction - Condition Items | 9 | DVALUT | Value Date | nvarchar | 8 | 0 | | |
TOPTransaction Management |
32 | TCHT_HD_COND | Instrument Conditions | 12 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
33 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 84 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
34 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 36 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
35 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 67 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
36 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 35 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
37 | TERTVWBWER | TRTM-PM: Flow Table for Executable Rights | 26 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
38 | VTBFHAPO | Transaction Flow | 84 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
39 | VTBFHAPO_MIGR | Migrated Financial Flows | 84 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
40 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 84 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
41 | VTBFINKO | Transaction Condition | 36 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
42 | VTBPFHAPO | Treasury: Flow Shells | 75 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
43 | VTIFHAPO | Underlying transaction flows | 67 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
44 | VTIFINKO | Underlying transaction conditions | 35 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
45 | VWBEPI | Treasury Securities: Actual Flows - Item | 28 | DVALUT | Interest Value Date/Calculation Date | nvarchar | 8 | 0 | | |
46 | VWBEPP | Treasury Securities: Planned Flows | 37 | DVALUT | Interest Value Date/Calculation Date | nvarchar | 8 | 0 | | |
47 | VWBWKM | TRTM-PM: Flow table for corporate actions | 26 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |
48 | VWORDE | Order Data | 37 | DVALUT | Interest Value Date/Calculation Date | nvarchar | 8 | 0 | | |
TOPTreasury |
49 | VZZKOPO | Table condition items | 27 | DVALUT | Calculation Date | nvarchar | 8 | 0 | | |