| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 128 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 72 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 128 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 72 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
5 | FIKZD_PROPTAX | Property tax Kazakstan | 15 | STORT | Asset location | nvarchar | 10 | 0 | | |
6 | FIKZD_TRTAX | Transport tax Kazakstan | 35 | STORT | Asset location | nvarchar | 10 | 0 | | |
TOPAppropriation Requests |
7 | IMAK | Appropriation requests - general data | 33 | STORT | Planned location of appropriation request | nvarchar | 10 | 0 | | |
TOPBasic Functions |
8 | ANLZ | Time-Dependent Asset Allocations | 13 | STORT | Asset location | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
9 | AAUUFK | Order master data | 18 | STORT | Location | nvarchar | 10 | 0 | | |
TOPEquipment |
10 | IEQT_WL_ITEMS | Interim Statuses - Items | 72 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
11 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 73 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
TOPFunctional Locations |
12 | ILOA | PM Object Location and Account Assignment | 10 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
13 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 11 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |
TOPOperative Structures |
14 | PROJ | Project definition | 66 | STORT | Location | nvarchar | 10 | 0 | | |
15 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 91 | STORT | Location | nvarchar | 10 | 0 | | |
TOPOverhead Cost Orders |
16 | AUFK | Order master data | 18 | STORT | Location | nvarchar | 10 | 0 | | |
TOPPatient Management |
17 | NADR | IS-H: Addresses (Central Address Management) | 25 | STORT | Standardized City Name | nvarchar | 40 | 0 | | |
18 | NPLZ | IS-H: Postal code catalog | 5 | STORT | Standardized City Name | nvarchar | 40 | 0 | | |
TOPProduction ResourcesTools |
19 | CRFH | CIM production resource/tool master data | 20 | STORT | Location of a production resource or tool | nvarchar | 10 | 0 | | |
TOPProject Summarization |
20 | PSERB | Inheritance data, Project System | 35 | STORT | Location | nvarchar | 10 | 0 | | |
TOPReporting |
21 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 33 | STORT | Asset location | nvarchar | 10 | 0 | | |
22 | S061 | Location and planning | 10 | STORT | Asset location | nvarchar | 10 | 0 | | |
23 | S061E | S061 - Structural Information | 5 | STORT | Asset location | nvarchar | 10 | 0 | | |
TOPSimulation |
24 | VSAUFK_CN | Version: Order master data | 19 | STORT | Location | nvarchar | 10 | 0 | | |
25 | VSPROJ_CN | Version: Project definition | 67 | STORT | Location | nvarchar | 10 | 0 | | |
26 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 92 | STORT | Location | nvarchar | 10 | 0 | | |
TOPTemplates |
27 | PROJS | Standard project definition | 67 | STORT | Location | nvarchar | 10 | 0 | | |
28 | PRPSS | Standard WBS Element (WBS element) - Master Data | 83 | STORT | Location | nvarchar | 10 | 0 | | |
TOPWaste Management |
29 | EWAROUTE | Header table of route | 54 | STORT | Location of maintenance object | nvarchar | 10 | 0 | | |