| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | TNCST | IS-HCM Communication Standards | 6 | STADT | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
| TOPBasic Functions |
| 2 | ANKA | Asset classes: general data | 41 | STADT | Municipality | nvarchar | 25 | 0 | | |
| 3 | ANLA | Asset Master Record Segment | 69 | STADT | Municipality | nvarchar | 25 | 0 | | |
| TOPIndustry-Specific Component Automotive |
| 4 | MHIS_UNPACKED | Copy of DB table MHIS (Data category INT4 replaced by NUMC) | 7 | STADT | Start date | nvarchar | 8 | 0 | | |
| TOPMaintenance Program Definition |
| 5 | MPDPSD | MPD: MPD and MP header data | 24 | STADT | Start date | nvarchar | 8 | 0 | | |
| TOPMaintenance Task Lists |
| 6 | MHIS | Maintenance plan history | 7 | STADT | Start date | nvarchar | 8 | 0 | | |
| 7 | MPLA | Maintenance plan | 36 | STADT | Start date | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 8 | T462 | Customizing Table Selection Rule / Display Filter | 34 | STADT | Start date of the import transaction | nvarchar | 1 | 0 | | |
| 9 | T463 | Customizing Table Display Filter - Settings - | 36 | STADT | Start date of previous period | nvarchar | 1 | 0 | | |
| TOPQuality Notifications |
| 10 | QMEL_EXT | Extension Table for Notification | 11 | STADT | Start date | nvarchar | 8 | 0 | | |
