| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIXCITCADRO | Temporary rental object data | 46 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
TOPBasic Data |
2 | VIBDRO | Rental Object | 45 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
TOPMigration |
3 | VIGWARFL | Immobilien gew.: Architektonische Fläche (statischer Teil) | 20 | SSTOCKW | Kerros | nvarchar | 3 | 0 | | |
4 | VIGWARRA | Immobilien gew.: Architektonischer Raum (statischer Teil) | 19 | SSTOCKW | Kerros | nvarchar | 3 | 0 | | |
5 | VIGWFLGGZU | Immobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück | 12 | SSTOCKW | Kerros | nvarchar | 3 | 0 | | |
6 | VIGWRAGEZU | Immobilien gew.: Ra-Zuordnung zu Gebäude oder Gebäudeteil | 11 | SSTOCKW | Kerros | nvarchar | 3 | 0 | | |
TOPReal Estate Management |
7 | S406 | Rental units | 69 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
8 | S407 | Rental agreements | 82 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
9 | TIV37 | Floor | 2 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
10 | TIV3G | Language table for floors (TIV37) | 3 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
11 | VIMI01 | Rental unit - Master data | 60 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
12 | VIOB18 | Comparative apartments for rent adjustment, external accomm. | 28 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
13 | VIOB30 | Rent request: Storey table | 4 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
14 | VIRPS406 | Rental units | 69 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |
15 | VIRPS407 | Rental agreements | 82 | SSTOCKW | Floor | nvarchar | 3 | 0 | | |