Corrective Action Plan
This table shows the Infor LN table from which fields are retrieved for the dimension:
Table | Description |
---|---|
qmcpl100 | Corrective Action Plan |
This table shows the attribute mapping to LN table fields for the dimension:
Attribute | Mapping |
---|---|
Approved Date | qmcpl100.apdt |
Approver | qmcpl100.appr |
Canceled Date | qmcpl100.cndt |
Category | qmcpl100.catg |
Category Desc | qmcpl100.dsca |
Closed Date | qmcpl100.cmdt |
Company | qmcpl100.compnr |
Completion Date | qmcpl100.codt |
Corrective Action Plan | qmcpl100.capn |
Corrective Action Plan Desc | qmcpl100.dsca |
Corrective Action Plan ID Desc | qmcpl100.capn + qmcpl100.dsca |
Corrective Action Plan Status | qmcpl100.stat |
Corrective Action Plan Status Filter | qmcpl100.stat |
Corrective Action Plan Status Sort | qmcpl100.stat |
Created by User | qmcpl100.cusr |
Creation Date | qmcpl100.crdt |
Due Date | qmcpl100.dudt |
Due Date for Effectiveness | qmcpl100.efdt |
E-Item Revision | qmcpl100.revi |
Effectiveness is Verified | qmcpl100.ecpv |
Effectiveness is Verified Filter | qmcpl100.ecpv |
Effectiveness is Verified Sort | qmcpl100.ecpv |
Effectivity Unit | qmcpl100.effn |
Is Current | 1 if latest record, else 0 |
Is Effective | qmcpl100.cpef |
Is Effective Filter | qmcpl100.cpef |
Is Effective Sort | qmcpl100.cpef |
Modified Date | qmcpl100.modt |
Other Method | qmcpl100.psmo |
Problem Solving Method | qmcpl100.pbsm |
Problem Solving Method Filter | qmcpl100.pbsm |
Problem Solving Method Sort | qmcpl100.pbsm |
RCA Document Number | qmcpl100.rcad |
Review Board | qmcpl100.mrcb |
Submitted Date | qmcpl100.sudt |
Supplier Corrective Action Plan | qmcpl100.scap |
Supplier Corrective Action Plan Filter | qmcpl100.scap |
Supplier Corrective Action Plan Sort | qmcpl100.scap |
Supplier Corrective Action Plan Status | qmcpl100.scas |
Supplier Corrective Action Plan Status Filter | qmcpl100.scas |
Supplier Corrective Action Plan Status Sort | qmcpl100.scas |
deleted | 1 if deleted in LN, else 0 |
Unknown | 1 for null records, else 0 |
Customer Defined Fields | Standard list of fields |