| 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 | | |