| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TIV0A | RU Usage type ID's | 3 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 2 | VIXCITCADRO | Temporary rental object data | 24 | SNUNR | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPBasic Data |
| 3 | TIVBDMEASRO | Measurement Type: Settings per Usage Type | 3 | SNUNR | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 4 | TIVBDROFSTATUS | Field Status of Rental Object per Usage Type | 2 | SNUNR | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 5 | VIBDRO | Rental Object | 23 | SNUNR | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPFlexible Real Estate Management |
| 6 | TIVBDROUSGREL | OBSOLETE: Rental Object Type: Permitted Usage Types | 3 | SNUNR | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 7 | TIVCACTUSTYPE | Usage-Type-Dependent Settings for Differing Condition Crcy | 2 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| TOPLoans Management |
| 8 | DIV01 | Loans: External usage types of a rental unit | 2 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| TOPLogistics - General |
| 9 | HBSAUT | Helper table for auto generation ... | 15 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| TOPMigration |
| 10 | TIG08 | Immobilien gew.: zulässige Nutzungsart je Flächentyp | 4 | SNUNR | Vuokrayksikön ulkoinen käyttölaji | nvarchar | 4 | 0 | | |
| 11 | TIVMISETUSGTYPE | Mapping of Usage Type of Rental Object | 2 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| TOPReal Estate Contract |
| 12 | TIVCNUSGCNTYPE | Allowed Usage Type per Contract Type | 3 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| TOPReal Estate Management |
| 13 | S406 | Rental units | 62 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 14 | S407 | Rental agreements | 192 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 15 | TIV01 | External usage types of rental unit | 2 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 16 | TIV29 | Combination of adjustment type - usage cat./ext. usage type | 4 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 17 | TIV76 | Area types for each external usage type | 2 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 18 | TIVBW01 | RE: Settings for Extracting Imminent Vacancies | 3 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 19 | TIVN1 | Defaults for Settlement Participation of Service Charge Key | 3 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 20 | TIVN2 | Defaults for Settlement Participation of Condition Type | 3 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 21 | VIMI01 | Rental unit - Master data | 10 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 22 | VIMI03 | Occupancy type history for rental unit | 4 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 23 | VIMI12 | Rental requests in an application | 5 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 24 | VIOB24 | Rental units per usage type (plan) | 6 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
| 25 | VIRPS406 | Rental units | 62 | SNUNR | Rental unit external usage type | nvarchar | 4 | 0 | | |
