| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIV0G | Settlement factor name | 3 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
2 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 36 | SABRG | Umlegungseinheit | nvarchar | 4 | 0 | | |
3 | VIAKHO21 | Mandatsverwaltung: Gesplittete Abrechnungsgrößen | 8 | SABRG | Umlegungseinheit | nvarchar | 4 | 0 | | |
4 | VIAKHOIR | WEG-Verwaltung: Stammdaten Bank/ Instandhaltungsrücklage | 5 | SABRG | Umlegungseinheit | nvarchar | 4 | 0 | | |
5 | VIAKHOPO | WEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen | 18 | SABRG | Umlegungseinheit | nvarchar | 4 | 0 | | |
6 | VIAKHOWP | WEG-Verwaltung: Eigentümerabrechnung Wirtschaftsplan | 12 | SABRG | Umlegungseinheit | nvarchar | 4 | 0 | | |
TOPMigration |
7 | TIVMISETMEAS | Conversion of Area Type and Apportionment Unit to Meas.Type | 2 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
8 | TIVMISETMEAST | Conversion of Area Type and Apportionment Unit to Meas.Type | 3 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
9 | TIVMISETSCKEY | Mapping of Service Charge Keys | 3 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
10 | VIGWMI08 | CRE: Umlegungseinheiten pro Mietfläche | 6 | SABRG | Jyvitysyksikkö | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
11 | IVBP | Line Item (Settlement: Service Charge Collector) (Obsolete) | 14 | SABRG | Apportionment unit (obsolete) | nvarchar | 2 | 0 | | |
12 | S406 | Rental units | 75 | SABRG | Apportionment unit: type | nvarchar | 4 | 0 | | |
13 | S407 | Rental agreements | 140 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
14 | TIV06 | Service Charge Key Attributes for each Tenancy Law | 7 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
15 | TIV07 | Apportionment unit ID | 2 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
16 | TIV07Z | Additional Attributes of Settlement Unit | 2 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
17 | TIV08 | Area types | 11 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
18 | TIV48 | Allocation of condition types to settlement factors | 2 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
19 | TIVSKZ2UE | Conversion of Statistical Key Figures for Apportionment Unit | 4 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
20 | VIAK03 | Settlement Unit Master Record | 21 | SABRG | Apportionment unit for determining option rate | nvarchar | 4 | 0 | | |
21 | VIAK04 | Allocation of Settlement Variants to Settlement Unit | 7 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
22 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 35 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
23 | VIAK21 | Split settlement factors for settlement variant | 7 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
24 | VIAK26 | Master Settlement Unit: Participating Settlement Units | 11 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
25 | VICNSCS | Real Estate Contract: Service Charge Key | 9 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
26 | VICNSCSAU | Real Estate Contract: Settlement Unit | 3 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
27 | VIMI08 | Apportionment units per rental unit | 5 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
28 | VIMI17 | RE: Adjustment Run Header | 22 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
29 | VIMI27 | Modernization Measure | 23 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |
30 | VIRPS406 | Rental units | 74 | SABRG | Apportionment unit: type | nvarchar | 4 | 0 | | |
31 | VIRPS407 | Rental agreements | 140 | SABRG | Apportionment unit | nvarchar | 4 | 0 | | |