| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccounting |
| 1 | VDDUNN_DISP | Dunning run data per loan and dunning run | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 2 | VDIOA_CALC_CF | Original Documents Without Model Account Int. on Arrears | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 3 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 4 | VDIOA_CALC_HEAD | Calculation Details for Interest on Arrears Calculation | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPBank Components |
| 5 | JBSSICH | Regulatory Reporting - Collateral | 7 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPFlexible Real Estate Management |
| 6 | VIGA3DARL | LUM: Grundbuch - Abteilung III Darlehensanbindung | 6 | SARCHIV | Kennzeichen Archivklasse | nvarchar | 1 | 0 | | |
| TOPLoans Management |
| 7 | TTONFTEXCLOAN | Vom Vergleich ausgeschlossene Darlehen | 3 | SARCHIV | Kennzeichen Archivklasse | nvarchar | 1 | 0 | | |
| 8 | TTONFTVDARL | Test neue Fima: Grunddaten und VDARL | 4 | SARCHIV | Kennzeichen Archivklasse | nvarchar | 1 | 0 | | |
| 9 | VDARL | Loans | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 10 | VDARLDVS | Print and dispatch control data for VDARL | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 11 | VDARLINSURE | Do Not Use: Insurance Policies for Loan (Relationship Table) | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 12 | VDARL_EU | Loans: Currency Data Before EURO Conversion | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 13 | VDARL_RP | adContract - Repayment Plan Data | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 14 | VDBOHEAD | Business Operation: Header | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 15 | VDBOHEAD_EU | Business Operation: Header | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 16 | VDBOINS | Business Operation Insurance Data | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 17 | VDCAPTR | CAPTR: Master Data of Capital Transfer | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 18 | VDCHARACDOC | Processing Characteristics: Change Documents | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 19 | VDCHGPTR | Change Pointers Loan | 4 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 20 | VDCORR_CNTRL | Control Table for Creation of Correspondence | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 21 | VDDEBTTRANS | Borrower Change Without Capital Transfer | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 22 | VDDEF_COUNTER | Number of Times in Arrears per Days Past Due Category | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 23 | VDDUNN | Dunning run data per loan and dunning run | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 24 | VDLOANCHARAC | Processing Characteristics per Loan | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 25 | VDREPAYMENT | Payoff Master Data | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 26 | VDRISKCLASS | Risk Classification for Individual Value Adjustment | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 27 | VDVORK | Table for preemption conditions | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 28 | VDWORKLIST | Loan Worklist for Postprocessing | 5 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPMaster Data |
| 29 | VDCLI_CNCL_DIS | Business Operation: CLI Rescission/Notice | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 30 | VDDISBTEMP | Disbursements That Were Not Released | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 31 | VDESCROWGUID | Escrow Reference Table for VDARL | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPOutgoing Payments |
| 32 | VDDISB | Disbursement Specific Header Data | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPPortfolio |
| 33 | VDCAPITAL | Data for Capitalization of Overdue Items | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 34 | VDCNCL | Rescission of Business Operation | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 35 | VDDEFERRAL | Deferral Data | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 36 | VDEXTSKIP | Master Data Extension and Skip | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPReceivablesPayment Management |
| 37 | VDARL_RLS | Direct Debits Per Contract | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| TOPTransaction Data Pool |
| 38 | JBDMANPOSTLOAN | Indicator Table for Manual Postings | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
| 39 | TJBD_VDARL_ARCH | Archiving Status for Loans | 3 | SARCHIV | Archiving Category Indicator | nvarchar | 1 | 0 | | |
