| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Components |
| 1 | JBSSICH | Regulatory Reporting - Collateral | 4 | JLOESCH | Deletion Indicator | nvarchar | 1 | 0 | | |
| TOPFlexible Real Estate Management |
| 2 | VIGBOOK | LUM: Grundbuch | 7 | JLOESCH | Löschvormerkung/-kennzeichen Immobilien | nvarchar | 1 | 0 | | |
| TOPLoans Management |
| 3 | VDARLOBJ | Loan objects relationship table | 9 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 4 | VDHGRPF | Encumbrances on real estate table | 24 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| TOPMigration |
| 5 | VIGWARFL | Immobilien gew.: Architektonische Fläche (statischer Teil) | 14 | JLOESCH | Poistomerkki/-tunnus - kiinteistöt | nvarchar | 1 | 0 | | |
| 6 | VIGWARRA | Immobilien gew.: Architektonischer Raum (statischer Teil) | 13 | JLOESCH | Poistomerkki/-tunnus - kiinteistöt | nvarchar | 1 | 0 | | |
| 7 | VIGWFLOBJ | Immobilien gew.: Stammdaten Fläche (statischer Teil) | 13 | JLOESCH | Poistomerkki/-tunnus - kiinteistöt | nvarchar | 1 | 0 | | |
| 8 | VIGWRAOBJ | Immobilien gew.: Stammdaten Räume (statischer Teil) | 12 | JLOESCH | Poistomerkki/-tunnus - kiinteistöt | nvarchar | 1 | 0 | | |
| 9 | VIGWVMFL | Immobilien gew.: Stammdaten Vermietfläche (statischer Teil | 15 | JLOESCH | Poistomerkki/-tunnus - kiinteistöt | nvarchar | 1 | 0 | | |
| 10 | VIMIMAPCNNR | Conversion Decisions: Contract Numbers | 14 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| TOPReal Estate Management |
| 11 | VIAK03 | Settlement Unit Master Record | 7 | JLOESCH | Real Estate Delection Indicator for Settlement Unit | nvarchar | 1 | 0 | | |
| 12 | VIAK08 | DME Settlement Units Master Data | 13 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 13 | VIBEBE | Correction items for input tax treatment | 11 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 14 | VIBEPP | Flow data - Planned items for real estate management | 76 | JLOESCH | Record planned for Real Estate archiving | nvarchar | 1 | 0 | | |
| 15 | VIGB2A | Changes in section 2 of land register | 8 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 16 | VIGB3A | Changes / deletions in section 3 of land register | 11 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 17 | VIGBA1 | Section 1 of land register | 8 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 18 | VIGBA2 | Section 2 of land register | 10 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 19 | VIGBA3 | Section 3 of land register | 20 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 20 | VIGBSTD | Real estate register of land register | 11 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 21 | VIGBUCH | Land register | 7 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 22 | VIGBZAB | Appreciations/deprecations for land register list | 8 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 23 | VIMI01 | Rental unit - Master data | 30 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 24 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 47 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 25 | VIMI11 | Applications - Real Estate Management | 35 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 26 | VIMI12 | Rental requests in an application | 26 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 27 | VIMI13 | Co-applicant - Leasing | 13 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 28 | VIMI22 | Assignment / Rental unit - rental request offers | 10 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 29 | VIMI33 | Offers for a rental unit (-> VIMIMV) | 50 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 30 | VIMI41 | Expert opinion on rent adjustment | 10 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 31 | VIMIEV | Supplementary lease-outs | 19 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 32 | VIMIMV | Lease-Out | 29 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 33 | VIOB01 | Business entities | 16 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 34 | VIOB02 | Property master data | 27 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 35 | VIOB03 | Real estate building master | 33 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 36 | VIOB12 | Areas per rental request | 7 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 37 | VIOB13 | No. of rooms per rental request | 6 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 38 | VIOB17 | Rent request: Locations | 5 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 39 | VIOB18 | Comparative apartments for rent adjustment, external accomm. | 18 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 40 | VIOB19 | Rent request: Storey table upto 15.07.94 | 5 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 41 | VIOB22 | Rooms | 22 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 42 | VIOB30 | Rent request: Storey table | 5 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 43 | VIVW01 | Management contract: General data | 18 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 44 | VIVW02 | Management contract: Periodic fee types | 14 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 45 | VIVW03 | Management contract: Calculation forms with selections | 13 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 46 | VIVW04 | Management contract: Settlement periods for fee types | 8 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 47 | VIVW05 | Management contract: Managed objects | 15 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
| 48 | VIVW06 | Management contract: Event-driven fee types | 10 | JLOESCH | Real Estate Deletion Indicator/Flag | nvarchar | 1 | 0 | | |
