Looking to add the FAI_Required_c field from the Part (Part Attributes tab) not the PartNum. The field is Part_FAI_Required_c when I run a BAQ but when I’m in the data dictionary I only see PartNum_FAI_Required_c.
I didn’t have any luck finding a linked table that had the data so I figured I may have to add the Part Table and include all columns. The issue I am facing is I do not know what the relationship for the parent would be.
Extra fields added to the Part table will show up on the Part_UD table in Data Dictionary. Not sure where you’re seeing it on “PartNum_…”, that doesn’t exist in data dictionary? Send a screenshot.
The BAQs (and BPMs, everything) run on the Part “view”, which automatically combines Part and Part_UD behind the scenes. If it isn’t working right perhaps your tables are not yet synced; need to regenerate the database and restart client application.
I was able to figure out via a Linked Table, MtlPartNum was the field.