Looking to create a BAQ that would pull the fields required to populate a DMT load for BOM (MOM).
Looking at method tracker field help and finding tables like ECORev, ECOOpr, ECOMtl.
Trying to pull valid from Test DB to populate Production DB.
Are you trying to pull the approved/final MOM/BOM? ECO tables, primarily, hold in-process items. I wouldn’t trust it for active revs.
1 Like
@RPLEGRAND use the Part series of tables. PartRev, PartOpr, PartOpDtl, PartMtl.
I made this last week for BOOs, for updating existing BOOs, so you may need a few more fields.
COMP01-PartOprExport.baq (23.0 KB)
2 Likes
Approved BOM’s
Thanks will check it out :-).
Then you’re going to be pulling from PartRev, PartOpr, PartOpDtl, PartMtl and DMTing into ECORev, ECOOpr, etc.
Good news is that if you get anything wrong you can just delete the ECO Group and try again.
1 Like
You will need one for the BOO and one for the BOM to update a MoM.
You will need to do the BOO first in the need of tying material to a given operation unless all materials are being placed against the entire assembly in which case your related operation column will be 0.
Fields I use for the BOM are:
ECOGroupID,Company,Plant,PartNum, RevisionNum,MtlSeq,MtlPartNum, RelatedOperation,FixedQty,EstScrapType,QtyPer,UOMCode,ViewAsAsm,PlanAsAsm,PullAsAsm