| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 32 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 59 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 32 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| 4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 59 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| TOPBulk Distribution Requirements Planning |
| 5 | OIIGMMK | GMM: General meter header table | 9 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| TOPEquipment |
| 6 | EQUI | Equipment master data | 26 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| TOPFunctional Locations |
| 7 | IFLOT | Functional Location (Table) | 53 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| 8 | IFLOT_VS | Functional Location (Version Table) | 54 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| TOPReporting |
| 9 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 13 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 10 | OIISOCK | SOC: Storage object characteristic segment header | 12 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | | |
