| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFlexible Real Estate Management |
| 1 | VIFLEINHW | LUM: Flurstück - Einheitswerte | 5 | DGULTBIS | Gültig-bis-Jahr | nvarchar | 4 | 0 | | |
| 2 | VILSCNAREA | LUM: Vertrag - Vertragsflächen | 5 | DGULTBIS | Datum, bis zu dem die Zuordnung gilt | nvarchar | 8 | 0 | | |
| 3 | VILSCNPARC | LUM: Vertrag - Flurstückszuordnung | 5 | DGULTBIS | Datum, bis zu dem die Zuordnung gilt | nvarchar | 8 | 0 | | |
| TOPReal Estate Management |
| 4 | VIAK17 | Interface for settlement / transfer of advance payments | 8 | DGULTBIS | End of validity period | nvarchar | 8 | 0 | | |
| 5 | VIEA06 | Management information: Owner for owner settlement | 13 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 6 | VIEIGE | Owners of real estate objects | 14 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 7 | VIEIGT | OLD, replaced by VIEIGE in 3.0 | 14 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 8 | VIVW02 | Management contract: Periodic fee types | 6 | DGULTBIS | Date from when assignment is valid | nvarchar | 8 | 0 | | |
| 9 | VIVW03 | Management contract: Calculation forms with selections | 9 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 10 | VIVW04 | Management contract: Settlement periods for fee types | 6 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 11 | VIVW05 | Management contract: Managed objects | 5 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 12 | VIVW07 | Allocation periods: Real estate obj. to management contract | 6 | DGULTBIS | Date up to when the assignment is valid | nvarchar | 8 | 0 | | |
| 13 | VIVW10 | Interface prop.man.settlement/transfer advance payments | 6 | DGULTBIS | End of validity period | nvarchar | 8 | 0 | | |
