I’m trying to find which table where the UPC codes are stored for parts. I found UPC fields on Part table but nothing is populated so I’m guessing that’s not the correct table. I checked PartUOM table and field name UPC12 is an invalid column name.
DMT is showing UPC12 exists on PartUOM which is how we got the majority of the UPC codes into Epicor when we went live back in August.
Does anyone know how to retrieve a list of all part numbers and their UPC codes using a BAQ or SQL query?
Thanks!
It’s in PartPC and PCType=‘UPC-12’
SELECT PartNum, ProdCode
FROM Erp.PartPC
Where PCType='UPC-12'
Thank you for the quick response! I would have never guessed that. Didn’t even know of that table.
Unfortunately, sometimes you have to look around because they don’t have the DB binding show in the field level help:
Doug: You’re brilliant but I can’t understand the programming logic to put the UPC codes in a separate table like this when there are already UPC1, UPC2, etc. fields in the part master table. And, they named the field ProdCode, which has a completely different use in other places. Seems needlessly complicated to me