In Engineering Workbench, you can define a revision number on a manufactured subassembly. Where is this stored in the database? The Field Help unhelpfully shows it in the ECOMtl table… but that doesn’t retain it after the part is checked in. The field itself lives in PartBOM, but that table doesn’t have any data during normal operation.
Try PartMtl
I’m pretty sure the ECOMtl only has data in it when an ECO is in progress. PartBOM is also a “temporary” table
Edit:
The PartMtl.PartNum is the parent P/N, PartMtl.MtlPartNum is the component P/N
I don’t believe it is stored. When you create a job and a subassy is required, I think the subassy assigned is based on approved revision at that time it is required.
there many other details wont be at PartOper, thereby it wont be at JobOpr, e.g. Part No. and RevisionNum and becoause we need thin info to measure transaction effeciency at job level, i had to creat a Method BPM to copy them from JobHead to each operation at JobOper when Jobs released
Thanks all… @dmoon, that’s what I had discovered as well and was just hoping I missed something.
Oh darn.