| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAustralia |
1 | T5Q0P | Personnel area, business subsection (Australia) | 39 | ABNUM | Australian Business Number | nvarchar | 11 | 0 | | |
2 | T5QGP | Personnel area, business subsection (Australia) | 41 | ABNUM | Australian Business Number | nvarchar | 11 | 0 | | |
3 | T5QGP_CE | AU CE : Define Grouping Value for Australian Business Number | 2 | ABNUM | Australian Business Number | nvarchar | 11 | 0 | | |
4 | T5QSF | Superannuation Fund Code Designation Australia | 23 | ABNUM | Australian Business Number | nvarchar | 11 | 0 | | |
TOPExternal Services |
5 | ESSR | Service Entry Sheet Header Data | 44 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPIndustry-Specific Component Automotive |
6 | MHIO_UNPACKED | Copy of database table MHIO (Data cat.INT4 replaced by NUMC) | 3 | ABNUM | Copy of data element ABNUM with category NUMC | nvarchar | 10 | 0 | | |
7 | MHIS_UNPACKED | Copy of DB table MHIS (Data category INT4 replaced by NUMC) | 3 | ABNUM | Copy of data element ABNUM with category NUMC | nvarchar | 10 | 0 | | |
TOPMaintenance History |
8 | HIKO | Order master data history | 55 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPMaintenance Notifications |
9 | QMIH | Quality message - maintenance data excerpt | 29 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPMaintenance Orders |
10 | AFIH | Maintenance order header | 26 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPMaintenance Task Lists |
11 | MHIO | Call Object from Maintenance Order | 3 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
12 | MHIS | Maintenance plan history | 3 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
13 | MPLA | Maintenance plan | 18 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPQuality Inspection |
14 | QALS | Inspection lot record | 224 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPSimulation |
15 | VSAFIH_CN | Version: Order header for plant maintenance | 27 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | | |
TOPTransportation |
16 | TVRAB | Route Stages | 3 | ABNUM | Stage Number | nvarchar | 4 | 0 | | |