Inspection Order
This table shows the Infor LN table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| qmptc100 | Inspection Order |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| AQL Switching | qmptc100.aqls |
| AQL Switching Filter | qmptc100.aqls |
| AQL Switching Sort | qmptc100.aqls |
| Company | qmptc100.compnr |
| Completion Date | qmptc100.cdat |
| Conformance Code | qmptc100.cncd |
| Conformance Reporting | qmptc100.conr |
| Conformance Reporting Filter | qmptc100.conr |
| Conformance Reporting Sort | qmptc100.conr |
| Conversion Factor Sample Size | qmptc100.cvss |
| Critical Characteristic AQL | qmptc100.carq |
| Critical Characteristic Rejected Quantity | qmptc100.crrj |
| Critical Characteristics Accepted Quantity | qmptc100.crac |
| E-Item Revision | qmptc100.revi |
| Effectivity Unit | qmptc100.effn |
| Inspection Level | qmptc100.ilvl |
| Inspection Order | qmptc100.orno |
| Inspection Severity | qmptc100.inse |
| Inspection Severity Filter | qmptc100.inse |
| Inspection Severity Sort | qmptc100.inse |
| Inspection Standard | qmptc100.inss |
| Iteration | qmptc100.iter |
| Location | qmptc100.loca |
| Major Characteristic AQL | qmptc100.mcaq |
| Major Characteristic Rejected Quantity | qmptc100.mcrj |
| Major Characteristics Accepted Quantity | qmptc100.mcaq |
| Minor Characteristic AQL | qmptc100.miaq |
| Minor Characteristic Rejected Quantity | qmptc100.mirj |
| Minor Characteristics Accepted Quantity | qmptc100.miaq |
| Number of Iteration | qmptc100.noit |
| Order AQL | qmptc100.aqll |
| Order Date | qmptc100.odat |
| Order Specific Test Procedure | qmptc100.ostp |
| Order Specific Test Procedure Filter | qmptc100.odat |
| Order Specific Test Procedure Sort | qmptc100.odat |
| Original Inspection Order | qmptc100.orio |
| Re-Inspection Order | qmptc100.reio |
| Sample Size | qmptc100.sams |
| Sample Unit | qmptc100.cuss |
| Sampling Plan | qmptc100.sapl |
| Sampling Rule | qmptc100.saru |
| Skip Lot | qmptc100.skio |
| Skip Lot Filter | qmptc100.skio |
| Skip Lot Sort | qmptc100.skio |
| Standard Test Procedure | qmptc100.quid |
| Team | qmptc100.team |
| Test Group | qmptc100.tstg |
| Test Type | qmptc100.tsty |
| Test Type Filter | qmptc100.tsty |
| Test Type Sort | qmptc100.tsty |
| Version | qmptc100.vrsn |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |