| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 118 | KZLTX | Long Text Indicator | nvarchar | 1 | 0 | | |
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 116 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 118 | KZLTX | Long Text Indicator | nvarchar | 1 | 0 | | |
| 4 | /SMERP/STG_PM004 | Data staging - Equipment list set - Measuring Points | 14 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| 5 | /SMERP/STG_PM009 | Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab | 14 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| TOPCompany Pension Scheme Germany |
| 6 | T5DC9 | Grouping Texts | 5 | KZLTX | Long Text Indicator | nvarchar | 40 | 0 | | |
| 7 | T5DCGT | Texts for CPS Indicator | 5 | KZLTX | Long Text Indicator | nvarchar | 40 | 0 | | |
| TOPEquipment |
| 8 | EQKT | Equipment Short Texts | 5 | KZLTX | Long Text Indicator | nvarchar | 1 | 0 | | |
| TOPExternal Services |
| 9 | ASMDT | Service Short Texts | 5 | KZLTX | Long Text Indicator | nvarchar | 1 | 0 | | |
| TOPFunctional Locations |
| 10 | IFLOTX | Functional Location: Short Texts | 5 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| 11 | IFLOTX_VS | Functional Location Data Fields: Short Texts (Version Table) | 6 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| 12 | IRLOTX | Reference Functional Location: Short Texts | 5 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| TOPMeasuring Points and Counters |
| 13 | IMPTT | Measuring Point (Table) | 8 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| 14 | IMRG | Measurement Document | 10 | KZLTX | Indicator: Long text exists | nvarchar | 1 | 0 | | |
| TOPObject Networking |
| 15 | INETX | Language-dependent texts for INET | 5 | KZLTX | Long Text Indicator | nvarchar | 1 | 0 | | |
| TOPPermits |
| 16 | IHSG | Object-Related Permits in Plant Maintenance | 13 | KZLTX | Long Text for Permit | nvarchar | 1 | 0 | | |
| 17 | T357G | Permits | 4 | KZLTX | Long Text for Permit | nvarchar | 1 | 0 | | |
| 18 | T357G_T | Text for Table 357GT | 5 | KZLTX | Long Text for Permit | nvarchar | 1 | 0 | | |
| TOPProduction Allocation |
| 19 | GHO_SIMU_INETX | Language-dependent texts for Links in Simulated Networks | 7 | KZLTX | Long Text Indicator | nvarchar | 1 | 0 | | |
| TOPWarranties |
| 20 | BGMS | Master Warranty Text Item | 6 | KZLTX | Indicator: More long text exists | nvarchar | 1 | 0 | | |
| 21 | BGMT | Master Warranty Text | 5 | KZLTX | Indicator: More long text exists | nvarchar | 1 | 0 | | |
| TOPWork Clearance Management |
| 22 | WCAGN | WCM: Approvals | 5 | KZLTX | Long Text for Permit | nvarchar | 1 | 0 | | |
