| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDPT_CONDITION | Condition within Redemption Schedule | 24 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
2 | VIYCADVPAY | Advance Payments | 30 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPAccounting |
3 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 38 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPBack Office |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 69 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 69 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPLoans Management |
6 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 33 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
7 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 33 | SVULT | Ultimokennzeichen für Berechnungstermin | nvarchar | 1 | 0 | | |
8 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 64 | SVULT | Ultimokennzeichen für Valuta | nvarchar | 1 | 0 | | |
9 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 34 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
10 | VDBEPI | Posted line items for document header | 78 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
11 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 78 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
12 | VDBEPP | Flow Data - Planned Item | 112 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
13 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 112 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
14 | VDCFWAREHOUSE | Cash Flow Management | 38 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
15 | VDREPAYMENT | Payoff Master Data | 39 | SVULT | Month-End Indicator for Due Date | nvarchar | 1 | 0 | | |
16 | VDVORTR | Loan carry-forward totals | 17 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
17 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 115 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPMaster Data |
18 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 32 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
TOPPortfolio |
19 | VDCOT_VER_CON | Conditions in the Condition Table | 26 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
TOPReal Estate Contract |
20 | VICDCFOBJ | Object-Related Cash Flow | 26 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
21 | VICDCFPAY | Payment-Related Cash Flow | 26 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
22 | TZK02 | Condition group, condition group - condition type allocation | 13 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
23 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 23 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
24 | /BEV3/CHAKONDALT | Test transfer structure cash flow for conditions | 38 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPTransaction Data Pool |
25 | JBCFBEWEG | Cash Flow Transaction: Flows | 13 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
26 | JBCFZSTRBEWEG | Cash Flow Transaction: Flow Data for Cash Flow | 14 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPTransaction Management |
27 | TCHT_HD_COND | Instrument Conditions | 14 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
TOPTransaction Manager |
28 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 86 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
29 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 37 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
30 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 69 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
31 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 36 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
32 | VTBFHAPO | Transaction Flow | 86 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
33 | VTBFHAPO_MIGR | Migrated Financial Flows | 86 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
34 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 86 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
35 | VTBFINKO | Transaction Condition | 37 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
36 | VTBPFHAPO | Treasury: Flow Shells | 77 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
37 | VTIFHAPO | Underlying transaction flows | 69 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
38 | VTIFINKO | Underlying transaction conditions | 36 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |
39 | VWBEPI | Treasury Securities: Actual Flows - Item | 66 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
40 | VWBEPP | Treasury Securities: Planned Flows | 113 | SVULT | Month-End Indicator for Value Date | nvarchar | 1 | 0 | | |
TOPTreasury |
41 | VZZKOPO | Table condition items | 35 | SVULT | Month-end indicator for calculation date | nvarchar | 1 | 0 | | |