| 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 | 5 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
2 | QDPK | Sampling scheme header | 15 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPBasic Data |
3 | QPAC | Inspection catalog codes for selected sets | 22 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
4 | QPAM | Inspection catalog selected sets | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPBasic Data for Certificates |
5 | QCVK | Certificate profile header | 12 | AENDERER | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPCatalog |
6 | QPCD | Inspection catalog codes | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
7 | QPGR | Inspection catalog code groups | 6 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
8 | TQ15 | Inspection catalog type index | 7 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPInformation System |
9 | TQ56 | Definition of quality score classes | 14 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPInspection Planning |
10 | PLMK | Inspection plan characteristics | 15 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
11 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 21 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPQM Control in Procurement |
12 | QINF | QM-info record for material and vendor | 6 | AENDERER | Name of User who Most Recently Changed the Q-Info Record | nvarchar | 12 | 0 | | |
TOPQM Control in Sales and Distribution |
13 | QVDM | QM Info Record - QM Control in SD | 8 | AENDERER | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPQuality Certificates |
14 | QCPR | QM quality certificates in procurement | 25 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPQuality Inspection |
15 | QALS | Inspection lot record | 60 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
16 | QALT | Partial lot | 20 | AENDERER | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
17 | QAMVRMS | Insp. Specifications/Valuation for Multiple Specifications | 9 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
18 | QAOBJMS | Multiple Specifications - Objects | 11 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
19 | QAPP | Inspection point | 49 | AENDERER | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
20 | QASRMS | Confirmation Data for Multiple Specification Sample | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPResults Recording |
21 | QAKL | Results table for value classes | 9 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
22 | QAMR | Characteristic results during inspection processing | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
23 | QAMV | Characteristic specifications for inspection processing | 7 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
24 | QASE | Results table for the sample unit | 9 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
25 | QASR | Sample results for inspection characteristics | 11 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
26 | QASV | Sample specifications for inspection processing | 8 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
27 | QEWL | QM Handheld: Worklist for Transfer | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPSample Management |
28 | QPRVK | Sample-drawing procedure | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
29 | QPRVP | Sample-drawing items | 26 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPSamples and SPC |
30 | QDBM | Valuation mode | 17 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
31 | QDDR | Dynamic modification rule (header) | 10 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
32 | QDEP | Allowed inspection severities | 4 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
33 | QDFB | Function modules for the individual procedure categories | 9 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
34 | QDFM | Function modules for valuation mode | 14 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
35 | QDSA | Sampling type | 9 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
36 | QDSV | Sampling procedure | 25 | AENDERER | Name of User who Most Recently Changed the Data Record | nvarchar | 12 | 0 | | |
TOPTerminologyGlossary |
37 | TERM3 | Glossary Terms | 5 | AENDERER | User Name | nvarchar | 12 | 0 | | |
38 | TERM6 | Header for Individual Entries | 9 | AENDERER | User Name | nvarchar | 12 | 0 | | |