| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 12 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| 2 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 12 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| 3 | SFTT_EQUI | Equipment Status diary | 7 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| 4 | SFTT_EQUIC | Equipment Current Status | 5 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| TOPFunctional Locations |
| 5 | IFLOT | Functional Location (Table) | 6 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| 6 | IFLOT_VS | Functional Location (Version Table) | 7 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| TOPReporting |
| 7 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 22 | TPLMA | Superior functional location | nvarchar | 30 | 0 | | |
| TOPTakeoverHandover of Technical Objects |
| 8 | PHINT | Phase In Table | 24 | TPLMA | Superior Functional location | nvarchar | 40 | 0 | | |
