Failure and Action Analysis
This table shows the Infor LN table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| qmpqm201 | Failure and Action Details |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Action Desc | qmpqm024.dsca |
| Actions | qmpqm201.racd |
| Actual Completion Date | qmpqm201.acdt |
| Actual Item | qmpqm201.aitm |
| Actual Lot | qmpqm201.alot |
| Actual Quantity IU | qmpqm201.aqty |
| Actual Serial | qmpqm201.acsr |
| Actual Start Date | qmpqm201.asst |
| Actual Unit | qmpqm201.aqua |
| Assigned Date | qmpqm201.asdt |
| Bad Fix | qmpqm201.bdfx |
| Bad Fix Filter | qmpqm201.bdfx |
| Bad Fix Sort | qmpqm201.bdfx |
| Canceled Date | qmpqm201.cndt |
| Closed Date | qmpqm201.cldt |
| Company | qmpqm201.compnr |
| Disposition | qmpqm201.disp |
| Disposition Action | qmpqm201.disa |
| Disposition Action Filter | qmpqm201.disa |
| Disposition Action Sort | qmpqm201.disa |
| Disposition Code | qmpqm201.disc |
| Disposition Code Desc | qmpqm026.dsca |
| Disposition Filter | qmpqm201.disp |
| Disposition Order Origin | qmpqm201.dorg |
| Disposition Order Origin Filter | qmpqm201.dorg |
| Disposition Order Origin Sort | qmpqm201.dorg |
| Disposition Reason | qmpqm201.disr |
| Disposition Sort | qmpqm201.disp |
| Dispositioned Date | qmpqm201.dpdt |
| Failure and Action Analysis | qmpqm200.frac |
| Failure Cannot be Solved | qmpqm201.flcs |
| Failure Cannot be Solved Filter | qmpqm201.flcs |
| Failure Cannot be Solved Sort | qmpqm201.flcs |
| Failure Category | qmpqm201.frct |
| Failure Category Desc | qmptc021.dsca |
| Failure Code | qmpqm201.frcd |
| Failure Code Desc | qmpqm022.dsca |
| Failure Solved | qmpqm201.flsv |
| Failure Solved Filter | qmpqm201.flsv |
| Failure Solved Sort | qmpqm201.flsv |
| Failure Stage | qmpqm201.frst |
| Failure Stage Desc | qmpqm020.dsca |
| Impact on Engineering Data Revision | qmpqm201.ierd |
| Impact on Engineering Data Revision Filter | qmpqm201.ierd |
| Impact on Engineering Data Revision Sort | qmpqm201.ierd |
| Instrument | qmpqm201.inst |
| Instrument Desc | qmptc008.dsca |
| Instrument Group | qmpqm201.intg |
| Instrument Group Desc | qmptc024.dsca |
| Instrument Number | qmpqm201.inno |
| New Lot | qmpqm201.nlot |
| Planned Completion Date | qmpqm201.pcdt |
| Planned Start Date | qmpqm201.psdt |
| Position | qmpqm201.fpon |
| Reference Designator | qmpqm201.rfdg |
| Repeated Failure | qmpqm201.rptd |
| Repeated Failure Filter | qmpqm201.rptd |
| Repeated Failure Sort | qmpqm201.rptd |
| Replaced Item | qmpqm201.ritm |
| Replaced Lot | qmpqm201.rlot |
| Replaced Quantity IU | qmpqm201.rqty |
| Replaced Serial | qmpqm201.rcsr |
| Replaced Unit | qmpqm201.rqua |
| Reported Quantity IU | qmpqm201.qnty |
| Reported Unit | qmpqm201.fqua |
| Responsible | qmpqm201.fcrc |
| Status | qmpqm201.stat |
| Status Filter | qmpqm201.stat |
| Status Sort | qmpqm201.stat |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |