| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIV19 | Repres.list of rents size classes | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
2 | TIV20 | Rep.list of rents master data | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
3 | TIV21 | Building age classes | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
4 | TIV22 | Representative list of rents location classes | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
5 | TIV23 | Fixtures/Fittings Categories | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
6 | TIV24 | Surch./Reduct. for each Charact.Category and Area Interval | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
7 | TIV25 | Value table / Representative list of rents | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
8 | TIV70 | Surcharge/reduction categories | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
TOPReal Estate Management |
9 | S402 | Business entities | 56 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
10 | S405 | Building | 95 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
11 | S406 | Rental units | 104 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
12 | S407 | Rental agreements | 121 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
13 | TIV04 | Repr.list of rents surcharge/reductions features | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
14 | TIV2B | Location classes of representative list of rents - texts | 3 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
15 | TIV2C | Characteristics classes - Names | 3 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
16 | TIV2J | Representative list of rents master texts | 3 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
17 | TIV70T | Surch./reduction classes - Texts language-dep. | 3 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
18 | TIVO2 | Rent Adjustment: Control Table for RRP Adjustment | 2 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
19 | VIMI16 | RE: Records of a Rent Adjustment Run | 70 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
20 | VIOB01 | Business entities | 11 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
21 | VIOB18 | Comparative apartments for rent adjustment, external accomm. | 17 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
22 | VIRPS405 | Building | 95 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
23 | VIRPS406 | Rental units | 103 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |
24 | VIRPS407 | Rental agreements | 121 | SMIETSP | Representative list of rents assignment | nvarchar | 6 | 0 | | |