| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Collection |
1 | S116 | Customer Analysis | 16 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
2 | S116E | S116 - Structural information | 11 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPInformation System |
3 | S292 | BW: Indiv. Recs f. Notif. Item | 16 | BAUTL | Assembly item | nvarchar | 18 | 0 | | |
4 | S292BIW1 | S292BIW1 * BW: Individual Records for Notification Items | 16 | BAUTL | Assembly item | nvarchar | 18 | 0 | | |
5 | S292BIW2 | S292BIW2 * BW: Individual Records for Notification Items | 16 | BAUTL | Assembly item | nvarchar | 18 | 0 | | |
6 | S296 | BW: Indiv. Recs f. Notif. Item | 15 | BAUTL | Assembly item | nvarchar | 18 | 0 | | |
7 | S296BIW1 | S296BIW1 * BW: Individual Records for Notification Items | 15 | BAUTL | Assembly item | nvarchar | 18 | 0 | | |
8 | S296BIW2 | S296BIW2 * BW: Individual Records for Notification Items | 15 | BAUTL | Assembly item | nvarchar | 18 | 0 | | |
TOPMaintenance History |
9 | HIKO | Order master data history | 35 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPMaintenance Notifications |
10 | QMFE | Quality notification - items | 17 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
11 | QMIH | Quality message - maintenance data excerpt | 7 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
12 | QMSM | Quality notification - tasks | 34 | BAUTL | Assembly Affected by the Task | nvarchar | 18 | 0 | | |
13 | QMUR | Quality notification - causes | 23 | BAUTL | Cause Assembly | nvarchar | 18 | 0 | | |
TOPMaintenance Orders |
14 | /CUM/CUDESIGN | CU: Design Header Data | 23 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
15 | /CUM/PRF_ORD | CU: Profile for Order Generation | 17 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
16 | AFIH | Maintenance order header | 6 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
17 | TPMUS | PM/SM - User default values | 26 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPMaintenance Task Lists |
18 | MPOS | Maintenance item | 28 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPRemote Logistics Management |
19 | OIO_MX_OBJECT | RLM tracking extract object data | 46 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPReporting |
20 | S061 | Location and planning | 15 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
21 | S061E | S061 - Structural Information | 10 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
22 | S062 | Object class and manufacturer | 12 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
23 | S062E | S062 - Structural Information | 7 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPSerial Numbers |
24 | OBJK | Plant Maintenance Object List | 6 | BAUTL | Assembly | nvarchar | 18 | 0 | | |
TOPSimulation |
25 | VSAFIH_CN | Version: Order header for plant maintenance | 7 | BAUTL | Assembly | nvarchar | 18 | 0 | | |