| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaintenance Orders |
1 | ADCOMP | PM/PS Reference Element | 2 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
2 | ADCOMPT | PM/PS Text Table for ADCOMP | 3 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
3 | AFIH | Maintenance order header | 43 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPMaintenance Task Lists |
4 | MPOS | Maintenance item | 69 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPMaster Data Distribution |
5 | /ISDFPS/TL1 | Task List - Operation/Activity | 217 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPOperative Structures |
6 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 112 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPProduction Orders |
7 | AFKO | Order Header Data PP Orders | 152 | ADPSP | PM/PS Reference Element | nvarchar | 40 | 0 | | |
8 | AFVC | Operation within an order | 172 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPRouting |
9 | PLKO | Task list - header | 73 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
10 | PLPO | Task list - operation/activity | 217 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPSimulation |
11 | VSAFIH_CN | Version: Order header for plant maintenance | 44 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
12 | VSAFKO_CN | Version: Order header data for PP orders | 153 | ADPSP | PM/PS Reference Element | nvarchar | 40 | 0 | | |
13 | VSAFVC_CN | Version: Operation in order | 173 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
14 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 113 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |
TOPTemplates |
15 | PRPSS | Standard WBS Element (WBS element) - Master Data | 92 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | |