| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 93 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 35 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 93 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 35 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
TOPEquipment |
5 | EQUZ | Equipment time segment | 24 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
6 | IEQT_WL_ITEMS | Interim Statuses - Items | 42 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
7 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 43 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
TOPFunctional Locations |
8 | IFLOT | Functional Location (Table) | 29 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
9 | IFLOT_VS | Functional Location (Version Table) | 30 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
10 | IRLOT | Reference Functional Location (Table) | 23 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
TOPMaintenance History |
11 | HIKO | Order master data history | 42 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
TOPMaintenance Orders |
12 | AFIH | Maintenance order header | 13 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
13 | T352R | Maintenance revisions | 10 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
14 | TPMUS | PM/SM - User default values | 21 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
TOPReporting |
15 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 29 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |
TOPSimulation |
16 | VSAFIH_CN | Version: Order header for plant maintenance | 14 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | | |