| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | RDPT_CONDITION | Condition within Redemption Schedule | 36 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 2 | VIYCADVPAY | Advance Payments | 28 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPAccounting |
| 3 | TDIOA_TEMPL | Template for Interest On Arrears Calculation | 6 | SINCL | Key Date Inclusive | nvarchar | 1 | 0 | | |
| 4 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 37 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPBack Office |
| 5 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 68 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 6 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 68 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPLease Accounting |
| 7 | TFILA_GF_007C | Value IDs to Be Included in Payment Schedule | 7 | SINCL | FIMA Inclusive Indicator for Due Date | nvarchar | 1 | 0 | | |
| TOPLoans Management |
| 8 | TDREPAY_TEMPL | Table for Payoff and Notice Templates | 15 | SINCL | Inclusive Indicator for Due Date | nvarchar | 1 | 0 | | |
| 9 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 32 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 10 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 50 | SINCL | Inklusivkennzeichen für Anfang und Ende eines Zeitraumes | nvarchar | 1 | 0 | | |
| 11 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 63 | SINCL | Inklusivkennzeichen für Anfang und Ende eines Zeitraumes | nvarchar | 1 | 0 | | |
| 12 | TTONFTVZZKOKO | Test neue FIMA: VZZKOKO | 48 | SINCL | Inklusivkennzeichen für Anfang und Ende eines Zeitraumes | nvarchar | 1 | 0 | | |
| 13 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 33 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 14 | VDBEPI | Posted line items for document header | 73 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 15 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 73 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 16 | VDBEPP | Flow Data - Planned Item | 107 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 17 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 107 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 18 | VDCFWAREHOUSE | Cash Flow Management | 37 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 19 | VDREPAYMENT | Payoff Master Data | 37 | SINCL | Inclusive Indicator for Due Date | nvarchar | 1 | 0 | | |
| 20 | VDVORTR | Loan carry-forward totals | 16 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 21 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 110 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPMaster Data |
| 22 | VDESCROWKOKO0 | TEMPORARY USE: Escrow Condition Headers | 49 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 23 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 49 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPPortfolio |
| 24 | VDCOT_VER_CON | Conditions in the Condition Table | 25 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPReal Estate Contract |
| 25 | VICDCFOBJ | Object-Related Cash Flow | 24 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 26 | VICDCFPAY | Payment-Related Cash Flow | 24 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPReal Estate Management |
| 27 | TZK02 | Condition group, condition group - condition type allocation | 35 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 28 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 21 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 29 | /BEV3/CHAKONDALT | Test transfer structure cash flow for conditions | 37 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 30 | /BEV3/CHASTEU | Control Table | 12 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPTransaction Management |
| 31 | TCHT_HD_COND | Instrument Conditions | 18 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPTransaction Manager |
| 32 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 78 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 33 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 30 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 34 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 61 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 35 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 29 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 36 | TERTVWBWER | TRTM-PM: Flow Table for Executable Rights | 58 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 37 | VTBFHAPO | Transaction Flow | 78 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 38 | VTBFHAPO_MIGR | Migrated Financial Flows | 78 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 39 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 78 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 40 | VTBFINKO | Transaction Condition | 30 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 41 | VTBPFHAPO | Treasury: Flow Shells | 69 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 42 | VTIFHAPO | Underlying transaction flows | 61 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 43 | VTIFINKO | Underlying transaction conditions | 29 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 44 | VWBEPI | Treasury Securities: Actual Flows - Item | 65 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 45 | VWBEPP | Treasury Securities: Planned Flows | 112 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| 46 | VWORDE | Order Data | 90 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPTreasury |
| 47 | VZZKOPO | Table condition items | 52 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
| TOPTreasury and Risk Management |
| 48 | VZZKOKO | Table condition header | 47 | SINCL | Inclusive indicator for beginning and end of a period | nvarchar | 1 | 0 | | |
