| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | QPMK | Inspection characteristic master | 3 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |
2 | QPMT | Master Inspection Characteristics Texts | 3 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |
3 | QPMZ | Assignment table - insp. methods/master insp. characteristic | 3 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |
TOPBasic Data for Certificates |
4 | QCVM | Certificate profile characteristic level | 11 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |
TOPEnvironment, Health and Safety |
5 | EHQMT_MAIN1 | EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation | 16 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |
6 | EHQMT_MAIN2 | EH&S-QM: Characteristics for Inspection Plan Creation | 18 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |
TOPInspection Planning |
7 | QMSP | QM: material specification | 7 | MKMNR | Master Inspection Characteristics | nvarchar | 8 | 0 | | |