| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 78 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| 2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 78 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| TOPEquipment |
| 3 | EQUI | Equipment master data | 34 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| 4 | EQUZ | Equipment time segment | 4 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| 5 | IEQT_WL_HDR_BAC | Interim Statuses - Header Data (Backup) | 9 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| 6 | IEQT_WL_HEADER | Interim Statuses - Header Data | 8 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| 7 | IEQT_WL_ITEMS | Interim Statuses - Items | 22 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| 8 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 23 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
| TOPReporting |
| 9 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 16 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | | |
