BoM PN Changeover per Customer

Hello,

With my current employer there is some “masking” at times of our internal part numbers.
This is because certain customers may require our part number be translated to match their numbering system.

The issue is that we are expected to maintain universal/internal part numbers for our assemblies but then at times provide a customer the same assembly and drawing using only the customer’s part numbers.

I am aware it is possible to have Table Formats for each customer having a column declaring the respective customer’s number from the properties of the item, but I hope that there is some way to maintain a single drawing and assembly for translation of the assembly and BoM to reflect a customer’s numbering system dynamically.
This will remove possibility of duplicate items and entropy with that scenario.

I assume it would be best for a BoM to be adjusted outside of Creo systems, but then the assemblies themselves they would not properly identify themselves via customer part numbering.

Is there capability currently to setup something of this sort? Is there something possible to adjust or implement for maintaining a single assembly like this? I imagine there is something I am not all too familiar with that may employ this need of ours.


Thank you for your time