| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPGeneral status management |
| 1 | TJ02T | System status texts | 3 | TXT04 | Individual status of an object (short form) | nvarchar | 4 | 0 | | |
| 2 | TJ30T | Texts for User Status | 5 | TXT04 | Individual status of an object (short form) | nvarchar | 4 | 0 | | |
| TOPGermany |
| 3 | T5D1H | Supplementary Insurance | 9 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
| 4 | T5D1K | Branch Offices | 11 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
| TOPPayroll |
| 5 | PA0729 | Personál.kmen.záznam Infotyp 0729 | 80 | TXT04 | Text 30 míst | nvarchar | 30 | 0 | | |
| 6 | PB0729 | Personál.kmen.záznam Infotyp 0729 | 80 | TXT04 | Text 30 míst | nvarchar | 30 | 0 | | |
| 7 | T5T1J | Health insurance institutions | 9 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
| 8 | T5T1K | Health insurance institutions | 11 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
| 9 | T7SK1K | Health insurance institutions | 12 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
| TOPPlant Maintenance |
| 10 | EAMS_CVBSYSSTAT | System Status and Icon Combination of Objects | 4 | TXT04 | Individual status of an object (short form) | nvarchar | 4 | 0 | | |
| 11 | EAMS_CVBUSSTS | User Status and Icon Combination of Objects | 5 | TXT04 | Individual status of an object (short form) | nvarchar | 4 | 0 | | |
| TOPPublic Sector |
| 12 | PA0363 | Prev.Emp.Period | 38 | TXT04 | Text Field | nvarchar | 50 | 0 | | |
| TOPReal Estate Management |
| 13 | S406 | Rental units | 78 | TXT04 | Occupancy type: short text | nvarchar | 4 | 0 | | |
| 14 | VIRPS406 | Rental units | 77 | TXT04 | Occupancy type: short text | nvarchar | 4 | 0 | | |
| TOPSouth Africa |
| 15 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 13 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
| 16 | T5W1M | Social insurance companies | 5 | TXT04 | House number and street | nvarchar | 30 | 0 | | |
