| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogbook |
1 | ADFSH_FLGTDET | Flight Scheduling: Flight Schedule Details | 65 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
TOPMaintenance History |
2 | HIKO | Order master data history | 59 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
TOPMaintenance Notifications |
3 | QMIH | Quality message - maintenance data excerpt | 37 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
TOPMaintenance Orders |
4 | AFIH | Maintenance order header | 30 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
5 | T352R | Maintenance revisions | 3 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
TOPProduct Lifecycle Management |
6 | DIWPS_REV_ORDER | Revision Order Table | 3 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
7 | DIWPS_RV_CA | Revision: Characteristics for Work Package | 2 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |
TOPSimulation |
8 | VSAFIH_CN | Version: Order header for plant maintenance | 31 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | | |