| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 132 | BEBER | Plant section | nvarchar | 3 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 76 | BEBER | Plant section | nvarchar | 3 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 132 | BEBER | Plant section | nvarchar | 3 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 76 | BEBER | Plant section | nvarchar | 3 | 0 | | |
TOPEquipment |
5 | IEQT_WL_ITEMS | Interim Statuses - Items | 76 | BEBER | Plant section | nvarchar | 3 | 0 | | |
6 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 77 | BEBER | Plant section | nvarchar | 3 | 0 | | |
TOPFunctional Locations |
7 | ILOA | PM Object Location and Account Assignment | 14 | BEBER | Plant section | nvarchar | 3 | 0 | | |
8 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 15 | BEBER | Plant section | nvarchar | 3 | 0 | | |
9 | T357 | Plant Section | 3 | BEBER | Plant section | nvarchar | 3 | 0 | | |
TOPInvestment Programs |
10 | IMPR | Investment Program Positions | 24 | BEBER | Plant section | nvarchar | 3 | 0 | | |
TOPMaintenance Orders |
11 | TPMIM | IM allocation key | 10 | BEBER | Plant section is relevant for proposal for IM allocation | nvarchar | 1 | 0 | | |
TOPReporting |
12 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 35 | BEBER | Plant section | nvarchar | 3 | 0 | | |
13 | S061 | Location and planning | 9 | BEBER | Plant section | nvarchar | 3 | 0 | | |
14 | S061E | S061 - Structural Information | 4 | BEBER | Plant section | nvarchar | 3 | 0 | | |
TOPWaste Management |
15 | EWAROUTE | Header table of route | 55 | BEBER | Plant section | nvarchar | 3 | 0 | | |