| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TDO6T | Text table for land registry indicator | 5 | XMBEZ | Description of land register type | nvarchar | 30 | 0 | | |
2 | TDO7T | Text table for administration cost elements | 5 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
3 | TDZWT | IS-IS: Payment terms with adjustment days | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
4 | TIV0A | RU Usage type ID's | 4 | XMBEZ | Description of external usage type of rental unit | nvarchar | 30 | 0 | | |
5 | TIV10 | Bus. entity location | 3 | XMBEZ | Description of location of business entity | nvarchar | 30 | 0 | | |
6 | TIV15 | Regional management - no longer used | 3 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
7 | TIV16 | Maintenance district | 3 | XMBEZ | Description of maintenance district | nvarchar | 30 | 0 | | |
8 | TIV22 | Representative list of rents location classes | 4 | XMBEZ | Description of location class for rep.list of rents | nvarchar | 30 | 0 | | |
9 | TIV28 | Corporate group type - Table no longer used | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
10 | TIV30 | Tenant service in a company | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
11 | TIV5B | Cost elements text table TIV51 | 5 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
12 | TIV5D | Accountancy firms fuel types - Texts | 5 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
13 | TIV5E | Texts for fuel types (Darwin) | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
14 | TIV5T | Classification of real estate objects (Text for TIV5A) | 5 | XMBEZ | Description of object type | nvarchar | 30 | 0 | | |
15 | TIV6A | Names of institutions supplying credit information | 5 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
16 | TIV6B | Credit standing of real estate applicant - Texts | 5 | XMBEZ | Description of credit standing of application | nvarchar | 30 | 0 | | |
17 | TZK0G | Texts for condition type-dependent detailed description | 7 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
TOPFlexible Real Estate Management |
18 | TIVPRHSPT | Gitterpositionstexte | 5 | XMBEZ | Normal Bezeichnung (char 30) | nvarchar | 30 | 0 | | |
19 | TIVPRHSVT | Gitterpositionstexte | 4 | XMBEZ | Normal Bezeichnung (char 30) | nvarchar | 30 | 0 | | |
TOPLoans Management |
20 | TD16T | Texts for borrower's note loan securities | 5 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
TOPReal Estate Management |
21 | S407 | Rental agreements | 115 | XMBEZ | Reason for rent reduction | nvarchar | 30 | 0 | | |
22 | TIV1R | Language table for security deposit types view | 5 | XMBEZ | Description of type of rental collateral | nvarchar | 30 | 0 | | |
23 | TIV2B | Location classes of representative list of rents - texts | 5 | XMBEZ | Description of location class acc.to rep.list of rents | nvarchar | 30 | 0 | | |
24 | TIV2F | Text table for Real Estate Contract Type (table TIV26) | 4 | XMBEZ | Description of type of RE contract type | nvarchar | 30 | 0 | | |
25 | TIV2G | Text Table for Lease-Out Adjustment Type (TIV27) | 4 | XMBEZ | Description of LO adjustment type | nvarchar | 30 | 0 | | |
26 | TIV50 | Heating Costs / Heating Systems Settlement Company | 3 | XMBEZ | Norm.desc. of heating costs/heating systems accountancy firm | nvarchar | 30 | 0 | | |
27 | TIVBC | Usage type per development plan (texts) | 4 | XMBEZ | Description of usage type according to development plan | nvarchar | 30 | 0 | | |
28 | TIVCA | Application: Processing indicator (text table) | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
29 | TIVCB | Application: Preselection indicator (text table) | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
30 | TIVCC | Application: Preselection indicator (text table) | 4 | XMBEZ | Normal name (30 characters) | nvarchar | 30 | 0 | | |
31 | TIVCD | Usage type acc. to area usage plan (text) | 4 | XMBEZ | Description of usage type of property acc. to land use map | nvarchar | 60 | 0 | | |
32 | VIRPS407 | Rental agreements | 115 | XMBEZ | Reason for rent reduction | nvarchar | 30 | 0 | | |