| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCMAJTENANT | Major Tenant Parameters | 10 | FEINS | Area unit | nvarchar | 3 | 0 | | |
2 | VIYCPROV | Provision Parameters | 28 | FEINS | Area unit | nvarchar | 3 | 0 | | |
TOPBasic Data |
3 | VIBDBE | Business Entity | 23 | FEINS | Area unit | nvarchar | 3 | 0 | | |
TOPBasic Functions |
4 | ANKA | Asset classes: general data | 38 | FEINS | Area unit | nvarchar | 3 | 0 | | |
5 | ANLA | Asset Master Record Segment | 71 | FEINS | Area unit | nvarchar | 3 | 0 | | |
TOPFlexible Real Estate Management |
6 | VIEINHWJ | LUM: Einheitswertbescheid - jahresabhängige Daten | 19 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
7 | VIFKATFL | LUM: Flurstück - Katasterfläche | 5 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
8 | VIGBOOK | LUM: Grundbuch | 9 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
9 | VILUBIAO | LUM: Ausschreibung - Zugeordnete Objekte | 5 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
10 | VILUBIKATUSA | LUM: Ausschreibung - Katasterliche Nutzung | 9 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
11 | VILUBIUSAHIST | LUM: Ausschreibung - Historie zur internen Nutzung | 8 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
12 | VILUCSNCSO | LUM: Altlast / Verunreinigung - Belastete Objekte | 7 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
13 | VILULBAFPA | LUM: Bebauungsplanung - Betroffene Flurstücke | 5 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
14 | VILUPSAO | LUM: Schutzstellung - Zugeordnete Objekte | 5 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
15 | VIVNACHW | LUM: Veränderungsnachweis - Allgemeine Daten | 11 | FEINS | Flächeneinheit | nvarchar | 3 | 0 | | |
TOPLoans Management |
16 | TDPZZ | IS-IS Loans: Installation parameters on client level | 3 | FEINS | Area unit | nvarchar | 3 | 0 | | |
17 | VDHOBJ | Collateral Objects | 35 | FEINS | Area unit | nvarchar | 3 | 0 | | |
TOPReal Estate Management |
18 | S402 | Business entities | 38 | FEINS | Unit: area | nvarchar | 5 | 0 | | |
19 | S404 | Properties | 18 | FEINS | Area unit | nvarchar | 3 | 0 | | |
20 | S405 | Building | 23 | FEINS | Area unit | nvarchar | 3 | 0 | | |
21 | S406 | Rental units | 28 | FEINS | Area unit | nvarchar | 3 | 0 | | |
22 | S407 | Rental agreements | 20 | FEINS | Area unit | nvarchar | 3 | 0 | | |
23 | S408 | Land registers | 12 | FEINS | Area unit | nvarchar | 3 | 0 | | |
24 | TIVWB09 | WB: Laufende Aufwendungen: Einheiten | 2 | FEINS | WB: Verwendbare Einheiten | nvarchar | 3 | 0 | | |
25 | VIGBUCH | Land register | 9 | FEINS | Area unit | nvarchar | 3 | 0 | | |
26 | VIMI12 | Rental requests in an application | 27 | FEINS | Area unit | nvarchar | 3 | 0 | | |
27 | VIMI16 | RE: Records of a Rent Adjustment Run | 40 | FEINS | Area unit | nvarchar | 3 | 0 | | |
28 | VIMI17 | RE: Adjustment Run Header | 11 | FEINS | Area unit | nvarchar | 3 | 0 | | |
29 | VIMI41 | Expert opinion on rent adjustment | 8 | FEINS | Area unit | nvarchar | 3 | 0 | | |
30 | VIMIWB | Accomm.entitlement certif. for application and LO | 13 | FEINS | Area unit | nvarchar | 3 | 0 | | |
31 | VIOB01 | Business entities | 14 | FEINS | Area unit | nvarchar | 3 | 0 | | |
32 | VIOB12 | Areas per rental request | 6 | FEINS | Area unit | nvarchar | 3 | 0 | | |
33 | VIOB18 | Comparative apartments for rent adjustment, external accomm. | 15 | FEINS | Area unit | nvarchar | 3 | 0 | | |
34 | VIOB23 | Area per room | 5 | FEINS | Area unit | nvarchar | 3 | 0 | | |
35 | VIOB40 | Time-dependent areas of real estate obj.: Newest entry | 6 | FEINS | Area unit | nvarchar | 3 | 0 | | |
36 | VIOB41 | History of time-dependent areas of real estate objects | 6 | FEINS | Area unit | nvarchar | 3 | 0 | | |
37 | VIRPS405 | Building | 23 | FEINS | Area unit | nvarchar | 3 | 0 | | |
38 | VIRPS406 | Rental units | 28 | FEINS | Area unit | nvarchar | 3 | 0 | | |
39 | VIRPS407 | Rental agreements | 20 | FEINS | Area unit | nvarchar | 3 | 0 | | |
40 | VIWB00 | Hauptwirtschaftlichkeitsberechnung | 7 | FEINS | WB: Flächeneinheit | nvarchar | 3 | 0 | | |