Streamline/efficient documentation of color code in part number?
My company is working to implement the use of ESI to publish to ERP via Windchill Change Notice.
Our current business practice is for Product Engineering to design product, responsible for form/fit/function, then Manufacturing Engineering takes the Design BOM and defines the manufacturing BOM in Windchill.
We are on a journey to change the way mBOMs are built. Previously the End Items, Shipping Unit (parcels), Mechanical Parts and Plant Data were structured in the Windchill mBOM, then a home-grown middleware between Windchill and ERP was used to massage the Windchill mBOM by adding raw materials, semi-finished parts, routing/process information, and addition of -FINISH information (ex PARTNUMBER-BLACK) used for purchasing and inventory of parts with finish.
Going forward a complete mBOM will be build in Windchill and published through ESI; including all raw materials, semi-finished parts, Process Plans, -FINISH parts, and Plant and Enterprise Data.
Today our process leverages Downstream Branches and Equivalent links wherever possible and necessary, where we see both Design and Manufacturing view objects in our mBOMs, this is going to remain as we go forward on our journey.
Product engineering is holding strong on the fact they are "color blind" and does not specify part color in their models/drawings/parts.
This decision is driving the requirement for all -FINSIH parts be authored in the mBOM. As I think about the data architecture, downstream parts, and the maintenance of the data created; I am feeling this is going to create more Downstream Parts and a lot of duplicate effort for our manufacturing friends who will need to mirror changes made in Design on the Downstream Parts that now have unique master data.
In my investigation for this post, I had read many people who post/comment are documenting part color all the way back in CAD (for visualization and re-use downstream).
Are there best practices out there for this scenario? Or instances that folks have experienced and changed course due to inefficiencies or issues down the road?
I appreciate any input as it will help me understand any potentially push for a change where certain information is authored for improved efficiency across the development process.

