| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Collection |
1 | S305 | WIS: Applicatons PM/QM/SM | 10 | PRIOK | Priority | nvarchar | 1 | 0 | | |
2 | S305E | S305 - Structure Information | 5 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPKnowledge Base |
3 | ISMP | SDB: Symptom table | 14 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaintenance History |
4 | HIKO | Order master data history | 33 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaintenance Notifications |
5 | QMEL | Quality Notification | 6 | PRIOK | Priority | nvarchar | 1 | 0 | | |
6 | T355E_W | Response times | 3 | PRIOK | Priority | nvarchar | 1 | 0 | | |
7 | T356 | Priorities | 3 | PRIOK | Priority | nvarchar | 1 | 0 | | |
8 | T356_T | Priority text | 4 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaintenance Orders |
9 | /CUM/CUDESIGN | CU: Design Header Data | 12 | PRIOK | Priority | nvarchar | 1 | 0 | | |
10 | /CUM/PRF_ORD | CU: Profile for Order Generation | 7 | PRIOK | Priority | nvarchar | 1 | 0 | | |
11 | AFIH | Maintenance order header | 4 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaintenance Processing |
12 | ALM_ME_PUSH_PRIO | Priorities for MAM Push | 3 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaintenance Program Definition |
13 | MPDITEM | Maintenance Plan Items | 11 | PRIOK | Priority | nvarchar | 1 | 0 | | |
14 | MPDPSD | MPD: MPD and MP header data | 39 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaintenance Task Lists |
15 | MPOS | Maintenance item | 58 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMaterials Management |
16 | /ISDFPS/PURGPM | Assgmt of PM Priors to Reqmt Urgencies (Obs.--> New: PURGPM) | 3 | PRIOK | Priority | nvarchar | 1 | 0 | | |
17 | PURGPM | Assignment of Maintenance Priorities to Requirem. Urgencies | 3 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPMedia Product Sales and Distribution |
18 | JKSD_ISMTQ80 | Specific Enhancements to IS-M for TQ80 | 4 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPProcessing |
19 | TEN399A | Control: Automatic Creation of Maint./Serv. Notification | 5 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPSimulation |
20 | VSAFIH_CN | Version: Order header for plant maintenance | 5 | PRIOK | Priority | nvarchar | 1 | 0 | | |
TOPWork Clearance Management |
21 | WCAAP | WCM: Application | 25 | PRIOK | Priority | nvarchar | 1 | 0 | | |
22 | WCAHE | WCM: Work Clearance Document (Header) | 25 | PRIOK | Priority | nvarchar | 1 | 0 | | |
23 | WCAW | WCM: Work Approval | 23 | PRIOK | Priority | nvarchar | 1 | 0 | | |