| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 92 | INGRPI | Data origin indicator | nvarchar | 1 | 0 | | |
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 34 | INGRPI | Data origin for maintenance planner group field | nvarchar | 1 | 0 | | |
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 92 | INGRPI | Data origin indicator | nvarchar | 1 | 0 | | |
| 4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 34 | INGRPI | Data origin for maintenance planner group field | nvarchar | 1 | 0 | | |
| TOPEquipment |
| 5 | EQUZ | Equipment time segment | 23 | INGRPI | Data origin indicator | nvarchar | 1 | 0 | | |
| 6 | IEQT_WL_ITEMS | Interim Statuses - Items | 41 | INGRPI | Data origin indicator | nvarchar | 1 | 0 | | |
| 7 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 42 | INGRPI | Data origin indicator | nvarchar | 1 | 0 | | |
| TOPFunctional Locations |
| 8 | IFLOT | Functional Location (Table) | 28 | INGRPI | Data origin for maintenance planner group field | nvarchar | 1 | 0 | | |
| 9 | IFLOT_VS | Functional Location (Version Table) | 29 | INGRPI | Data origin for maintenance planner group field | nvarchar | 1 | 0 | | |
| 10 | IRLOT | Reference Functional Location (Table) | 22 | INGRPI | Data origin for maintenance planner group field | nvarchar | 1 | 0 | | |
