Non Conformance Report
This table shows the Infor LN table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| qmncm100 | Non Conformance Report |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Assigned Date | qmncm100.asdt |
| Buy-From BP Outgoing | qmncm100.owbp |
| Canceled Date | qmncm100.cadt |
| Closing Date | qmncm100.cldt |
| Company | qmncm100.compnr |
| Contact | qmncm100.ccnt |
| Corrective Action Plan | qmncm100.capc |
| Customer Cross Reference Item | qmncm100.criw |
| Customer Item Code System | qmncm100.citw |
| Department Internal | qmncm100.dept |
| Disposition Date | qmncm100.didt |
| Disposition Order | qmncm100.dior |
| Disposition Order Origin | qmncm100.dorg |
| Disposition Order Origin Filter | qmncm100.dorg |
| Disposition Order Origin Sort | qmncm100.dorg |
| Disposition Order Position | qmncm100.diln |
| Disposition Type | qmncm100.disp |
| Disposition Type Filter | qmncm100.disp |
| Disposition Type Sort | qmncm100.disp |
| Document Number | qmncm100.docn |
| Document Received Date | qmncm100.drdt |
| Document Sent Date | qmncm100.drst |
| E-Item Revision | qmncm100.revi |
| Effectivity Unit | qmncm100.effn |
| Handling Unit | qmncm100.huid |
| Is Current | 1 if latest record, else 0 |
| Line Type | qmncm100.styp |
| Line Type Filter | qmncm100.styp |
| Line Type Sort | qmncm100.styp |
| Location | qmncm100.loca |
| Lot | qmncm100.clot |
| Material Disposition | qmncm100.ndis |
| Material Disposition Cause | qmncm100.ncmc |
| Material Disposition Cause Desc | qmncm004.dsca |
| Material Disposition Desc | qmncm007.dsca |
| Material Disposition Reason | qmncm100.disr |
| Material Disposition Responsible | tcmcs005.dsca |
| Material Responsible BP | qmncm100.rsbp |
| Material Severity | qmncm100.slvl |
| Material Severity Desc | qmncm002.dsca |
| Material Type | qmncm100.nctp |
| Material Type Desc | qmncm001.dsca |
| New Item | qmncm100.ditm |
| Non Conformance Report | qmncm100.ncmr |
| Non Conformance Report Desc | qmncm100.dsca |
| Non Conformance Report ID Desc | qmncm100.ncmr + qmncm100.dsca |
| Non Conformance Status | qmncm100.stat |
| Non Conformance Status Filter | qmncm100.stat |
| Non Conformance Status Sort | qmncm100.stat |
| Non Material Disposition | qmncm100.mdis |
| Non Material Disposition Cause | qmncm100.ncca |
| Non Material Disposition Desc | qmncm004.dsca |
| Non Material Severity | qmncm100.svty |
| Non Material Severity Filter | qmncm100.svty |
| Non Material Severity Sort | qmncm100.svty |
| Non-Material Disposition Responsible | qmncm100.ncrr |
| Open Date | qmncm100.opdt |
| Operation | qmncm100.opno |
| Order Position | qmncm100.pono |
| Origin Order | qmncm100.orno |
| Parent Item | qmncm100.mitm |
| Parent NCMR | qmncm100.pncm |
| Planned Review Date | qmncm100.prvd |
| Reporting BP | qmncm100.rtbp |
| Reset Date | qmncm100.redt |
| Review Board | qmncm100.mrbc |
| Review Board Desc | tcppl040.dsca |
| Sequence | qmncm100.seqn |
| Serial Number | qmncm100.serl |
| Split Date | qmncm100.spdt |
| Sold-to BP-Waiver | qmncm100.wvbp |
| Submitted Date | qmncm100.sudt |
| Supplier Cross Reference Item | qmncm100.crit |
| Supplier Item Code System | qmncm100.citd |
| Waiver Outgoing Required | qmncm100.owrd |
| Waiver Outgoing Required Filter | qmncm100.owrd |
| Waiver Outgoing Required Sort | qmncm100.owrd |
| Warehouse Inspection | qmncm100.apno |
| Warehouse Inspection Sequence | qmncm100.apsq |
| Work Station | qmncm100.wstt |
| Unknown | 1 for null records, else 0 |
| Deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |