| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /GEP/T_NEED | Graphischer Leitstand: Bedarfe (einzuplanende Objekte) | 41 | SWERK | Standortwerk | nvarchar | 4 | 0 | | |
| 2 | /GEP/T_SPLIT | Graphischer Leitstand: Splits (eingeplante Objekte) | 42 | SWERK | Standortwerk | nvarchar | 4 | 0 | | |
| 3 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 126 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 4 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 70 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 5 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 126 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 6 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 70 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 7 | S555E | S555 - Structural Information | 3 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPData Collection |
| 8 | S555 | Info structure Wolgang Backes | 8 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPEquipment |
| 9 | IEQT_WL_ITEMS | Interim Statuses - Items | 70 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 10 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 71 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPFunctional Locations |
| 11 | ILOA | PM Object Location and Account Assignment | 8 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 12 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 9 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPMaintenance Task Lists |
| 13 | EAPL | Allocation of task lists to pieces of equipment | 13 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPPlant Maintenance |
| 14 | TEQUI_HIER | Definition of Hierarchies for Equipment | 7 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 15 | TFUNCT_LOC_HIER | Definition of Hierarchies for Functional Locations | 6 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPPool Asset Management |
| 16 | PAMS_NEED | Graphical Planning Board: Requests (Objects to Schedule) | 25 | SWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | | |
| 17 | PAMS_SPLIT | Graphical Planning Board: Splits (Scheduled Objects) | 26 | SWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | | |
| TOPProcessing |
| 18 | EWA_WDOC_WA_PC | Selection Data from Work Area for Regional Structure | 6 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPReporting |
| 19 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 32 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 20 | S061 | Location and planning | 8 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 21 | S061E | S061 - Structural Information | 3 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 22 | S114 | Fahrzeugverbrauchsanalyse | 9 | SWERK | Vestiging | nvarchar | 4 | 0 | | |
| 23 | S114E | S114 - Strukturinformationen | 4 | SWERK | Vestiging | nvarchar | 4 | 0 | | |
| TOPWaste Management |
| 24 | EWAROUTE | Header table of route | 53 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 25 | EWA_OBJADDRESS | Object Address | 4 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| 26 | EWA_SERVADDRESS | Service Address | 5 | SWERK | Maintenance plant | nvarchar | 4 | 0 | | |
| TOPWork Center |
| 27 | CRHH | Hierarchy Header Data | 8 | SWERK | Hierarchy objects in different plants | nvarchar | 1 | 0 | | |
