| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 115 | PLTXT | Description of functional location | nvarchar | 40 | 0 | | |
| 2 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 111 | PLTXT | Description of functional location | nvarchar | 40 | 0 | | |
| 3 | SFTT_SN | Shift Notes: Master Data | 8 | PLTXT | Character 100 | nvarchar | 100 | 0 | | |
| TOPFunctional Locations |
| 4 | IFLOTX | Functional Location: Short Texts | 4 | PLTXT | Description of functional location | nvarchar | 40 | 0 | | |
| 5 | IFLOTX_VS | Functional Location Data Fields: Short Texts (Version Table) | 5 | PLTXT | Description of functional location | nvarchar | 40 | 0 | | |
| 6 | IRLOTX | Reference Functional Location: Short Texts | 4 | PLTXT | Description of the reference functional location | nvarchar | 40 | 0 | | |
| TOPPension fund General Parts |
| 7 | T5CA5 | Processing Schedule Names | 6 | PLTXT | HR-CH: Name of a processing schedule | nvarchar | 20 | 0 | | |
| 8 | T72A3T | HR-PF: Schedule Modifiers (Texts) | 6 | PLTXT | Description | nvarchar | 60 | 0 | | |
| TOPPersonnel Cost Planning and Simulation |
| 9 | HRHCP_PLAN_T | Personnel Cost Plan Texts | 5 | PLTXT | Name | nvarchar | 40 | 0 | | |
