| 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 | 6 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
2 | QDPK | Sampling scheme header | 13 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
TOPInspection Planning |
3 | PLMK | Inspection plan characteristics | 14 | ERSTELLDAT | Date record created on | nvarchar | 8 | 0 | | |
4 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 20 | ERSTELLDAT | Date record created on | nvarchar | 8 | 0 | | |
TOPQM Control in Procurement |
5 | QINF | QM-info record for material and vendor | 5 | ERSTELLDAT | Create Date of Q-Info Record | nvarchar | 8 | 0 | | |
TOPQM Control in Sales and Distribution |
6 | QVDM | QM Info Record - QM Control in SD | 7 | ERSTELLDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
7 | QAMVRMS | Insp. Specifications/Valuation for Multiple Specifications | 7 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
8 | QASRMS | Confirmation Data for Multiple Specification Sample | 9 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
TOPResults Recording |
9 | QAKL | Results table for value classes | 8 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
10 | QAMR | Characteristic results during inspection processing | 9 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
11 | QAMV | Characteristic specifications for inspection processing | 6 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
12 | QASE | Results table for the sample unit | 8 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
13 | QASR | Sample results for inspection characteristics | 10 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
14 | QASV | Sample specifications for inspection processing | 7 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
15 | QEWL | QM Handheld: Worklist for Transfer | 8 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
TOPSamples and SPC |
16 | QDBM | Valuation mode | 18 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
17 | QDDR | Dynamic modification rule (header) | 11 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
18 | QDEP | Allowed inspection severities | 5 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
19 | QDFB | Function modules for the individual procedure categories | 10 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
20 | QDFM | Function modules for valuation mode | 15 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
21 | QDSA | Sampling type | 10 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |
22 | QDSV | Sampling procedure | 26 | ERSTELLDAT | Date on Which the Data Record Was Created | nvarchar | 8 | 0 | | |