| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPActive Quality Control |
1 | QDEB | Allwd. Relationships: Sampling Procedures/Dynamic Mod. Rules | 7 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
2 | QDPK | Sampling scheme header | 16 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
TOPBasic Data for Certificates |
3 | QCVK | Certificate profile header | 13 | AENDERDAT | Changed On | nvarchar | 8 | 0 | | |
TOPInspection Planning |
4 | PLMK | Inspection plan characteristics | 16 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
5 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 22 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
TOPQM Control in Procurement |
6 | QINF | QM-info record for material and vendor | 7 | AENDERDAT | Change Date of Q-Info Record | nvarchar | 8 | 0 | | |
TOPQM Control in Sales and Distribution |
7 | QVDM | QM Info Record - QM Control in SD | 9 | AENDERDAT | Changed On | nvarchar | 8 | 0 | | |
TOPQuality Certificates |
8 | QCPR | QM quality certificates in procurement | 26 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
9 | QALS | Inspection lot record | 61 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
10 | QALT | Partial lot | 21 | AENDERDAT | Changed On | nvarchar | 8 | 0 | | |
11 | QAMVRMS | Insp. Specifications/Valuation for Multiple Specifications | 10 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
12 | QAOBJMS | Multiple Specifications - Objects | 12 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
13 | QAPP | Inspection point | 50 | AENDERDAT | Changed On | nvarchar | 8 | 0 | | |
14 | QASRMS | Confirmation Data for Multiple Specification Sample | 11 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
TOPResults Recording |
15 | QAKL | Results table for value classes | 10 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
16 | QAMR | Characteristic results during inspection processing | 11 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
17 | QAMV | Characteristic specifications for inspection processing | 8 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
18 | QASE | Results table for the sample unit | 10 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
19 | QASR | Sample results for inspection characteristics | 12 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
20 | QASV | Sample specifications for inspection processing | 9 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
21 | QEWL | QM Handheld: Worklist for Transfer | 11 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
22 | QIWL | Transfer table for QM subsystems | 10 | AENDERDAT | Change Date of an Inspection Lot Entry in Worklist Table | nvarchar | 8 | 0 | | |
TOPSamples and SPC |
23 | QDBM | Valuation mode | 19 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
24 | QDDR | Dynamic modification rule (header) | 12 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
25 | QDEP | Allowed inspection severities | 6 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
26 | QDFB | Function modules for the individual procedure categories | 11 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
27 | QDFM | Function modules for valuation mode | 16 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
28 | QDSA | Sampling type | 11 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |
29 | QDSV | Sampling procedure | 27 | AENDERDAT | Date on Which Data Record Was Changed | nvarchar | 8 | 0 | | |