| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFlexible Real Estate Management |
1 | ATIVABGBHEB | Tab. TIVABGBHEB Änderungsbelegstruktur manuell erzeugt | 5 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
2 | TIVABGBHEB | LUM: Hebesätze f. Grundsteuerermittlung im Abgabenbescheid | 5 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
3 | VIAKHO21 | Mandatsverwaltung: Gesplittete Abrechnungsgrößen | 7 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
4 | VIFKATFL | LUM: Flurstück - Katasterfläche | 3 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
5 | VIFLEINHW | LUM: Flurstück - Einheitswerte | 4 | DGULTAB | Gültig-ab-Jahr | nvarchar | 4 | 0 | | |
6 | VILSCNAREA | LUM: Vertrag - Vertragsflächen | 4 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
7 | VILSCNOBJ | LUM: Vertrag - Objektflächen | 4 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
8 | VILSCNPARC | LUM: Vertrag - Flurstückszuordnung | 4 | DGULTAB | Datum, ab dem die Zuordnung beachtet wird | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
9 | S406 | Rental units | 61 | DGULTAB | Condition: effective from | nvarchar | 8 | 0 | | |
10 | S407 | Rental agreements | 97 | DGULTAB | Condition: effective from | nvarchar | 8 | 0 | | |
11 | VIAK02 | Settlement Participation for Service Charge Settlement | 7 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
12 | VIAK04 | Allocation of Settlement Variants to Settlement Unit | 6 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
13 | VIAK17 | Interface for settlement / transfer of advance payments | 7 | DGULTAB | Start of effective period | nvarchar | 8 | 0 | | |
14 | VIAK21 | Split settlement factors for settlement variant | 6 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
15 | VIAK22 | Heat.oil supply | 6 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
16 | VIAK22T | Heat.oil supply texts | 6 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
17 | VICNSCS | Real Estate Contract: Service Charge Key | 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
18 | VICNSCSAU | Real Estate Contract: Settlement Unit | 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
19 | VIEA06 | Management information: Owner for owner settlement | 12 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
20 | VIEIGE | Owners of real estate objects | 13 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
21 | VIEIGT | OLD, replaced by VIEIGE in 3.0 | 13 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
22 | VIOB27 | Relationship between properties and buildings | 6 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
23 | VIOB40 | Time-dependent areas of real estate obj.: Newest entry | 4 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
24 | VIOB41 | History of time-dependent areas of real estate objects | 4 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
25 | VIRPS406 | Rental units | 61 | DGULTAB | Condition: effective from | nvarchar | 8 | 0 | | |
26 | VIRPS407 | Rental agreements | 97 | DGULTAB | Condition: effective from | nvarchar | 8 | 0 | | |
27 | VIVW02 | Management contract: Periodic fee types | 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
28 | VIVW03 | Management contract: Calculation forms with selections | 8 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
29 | VIVW04 | Management contract: Settlement periods for fee types | 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
30 | VIVW05 | Management contract: Managed objects | 4 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
31 | VIVW06 | Management contract: Event-driven fee types | 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
32 | VIVW07 | Allocation periods: Real estate obj. to management contract | 5 | DGULTAB | Date from when assignment is valid | nvarchar | 8 | 0 | | |
33 | VIVW10 | Interface prop.man.settlement/transfer advance payments | 5 | DGULTAB | Start of effective period | nvarchar | 8 | 0 | | |