| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 91 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 33 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 91 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 33 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 5 | T7CNRA | Assignment of Tax Calculation Rule to Income Category | 6 | INGRP | Income Category Grouping | nvarchar | 3 | 0 | | |
| TOPConditions |
| 6 | B060 | PM Message - Plant Maintenance | 6 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPEquipment |
| 7 | EQUZ | Equipment time segment | 22 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 8 | IEQT_WL_ITEMS | Interim Statuses - Items | 40 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 9 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 41 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 10 | T024I | Maintenance planner groups | 3 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPFunctional Locations |
| 11 | IFLOT | Functional Location (Table) | 27 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 12 | IFLOT_VS | Functional Location (Version Table) | 28 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 13 | IRLOT | Reference Functional Location (Table) | 21 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPMaintenance Notifications |
| 14 | QMIH | Quality message - maintenance data excerpt | 27 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPMaintenance Orders |
| 15 | /CUM/CUDESIGN | CU: Design Header Data | 14 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 16 | /CUM/PRF_ORD | CU: Profile for Order Generation | 9 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 17 | TPMUS | PM/SM - User default values | 5 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPPlant Maintenance |
| 18 | T390_U | Print control by user | 5 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPReporting |
| 19 | S061 | Location and planning | 12 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 20 | S061E | S061 - Structural Information | 7 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| TOPWork Clearance Management |
| 21 | WCAAP | WCM: Application | 12 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 22 | WCAHE | WCM: Work Clearance Document (Header) | 13 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 23 | WCAJ | WCM: Lineup | 8 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
| 24 | WCAW | WCM: Work Approval | 11 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | | |
