Can anyone tell me where the fields like FailedReasonCode in inspection Processing are saved to the database? It shows as in the invView table but there isn’t a table (or view) like that, that I can see anywhere.
Reason codes show up in many places in Epicor.
Reason codes maintenance has a quirky landing page.
First you need to select the DMR type of reason code.
When the codes are created they can be set to be used for inspection Fail, DMR reject or DMR accept.
By default when a code is created all boxes get which typically is not what you want
@LarsonSolutions Thank you for responding.
I was meaning once I complete the inspection process where is the data in those fields saved in the database. I was hoping to do some analysis on the inspection data and don’t see the FailedReasonCode in the NonConf table. I think the PO (porview) data is stored in the rcvdtl table (at least there is a ReasonCode field in there and it seems to match up) but I am struggling to figure out where the inventory data would be stored.
When I did a Trace… well that wasn’t much help either it gave me a InspNonConf table which I also don’t see in the database.
Did you check PartTran table? Try looking mainly by TranType = “INS-DMR” and reason code field.
That’s where it is, Thank you.
1 Like
