| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPLocalization |
| 1 | J_1BPOSREDUCTION | POS-Database Reduction (Brazilian) | 8 | SERIALNR | Serial number of POS | nvarchar | 15 | 0 | | |
| TOPMaintenance History |
| 2 | HIKO | Order master data history | 69 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| TOPMaintenance Notifications |
| 3 | QMEL | Quality Notification | 97 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| TOPMaintenance Orders |
| 4 | AFIH | Maintenance order header | 39 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| 5 | TPMUS | PM/SM - User default values | 27 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| TOPMaintenance Task Lists |
| 6 | MPOS | Maintenance item | 51 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| TOPProduction Orders |
| 7 | OCMHOMO_ARCH | Backup Table of Homogeneity List in Case of Archiving | 10 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| TOPReporting |
| 8 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 46 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
| TOPResults Recording |
| 9 | QAES | Sample unit table | 5 | SERIALNR | Single-Unit Number for the Unit to Be Inspected | nvarchar | 18 | 0 | | |
| 10 | QASE | Results table for the sample unit | 48 | SERIALNR | Single-Unit Number for the Unit to Be Inspected | nvarchar | 18 | 0 | | |
| TOPSimulation |
| 11 | VSAFIH_CN | Version: Order header for plant maintenance | 40 | SERIALNR | Serial Number | nvarchar | 18 | 0 | | |
