| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 36 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | | |
| 2 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 36 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | | |
| TOPFunctional Locations |
| 3 | IFLOT | Functional Location (Table) | 30 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | | |
| 4 | IFLOT_VS | Functional Location (Version Table) | 31 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | | |
| 5 | IRLOT | Reference Functional Location (Table) | 24 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | | |
| TOPReporting |
| 6 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 28 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | | |
