PartNumber + Color

We have a pipe applicaiton one diameter with lots of lengths 1ft to 24ft.

Each length is a configuration and each configuration has a part number - there are about 700 different pipe lengths/configurations.

An assembly has a hundred or so pipes with differing lengths, we are good so far the BOM is perfect.

Now to mess it all up comes along the color. There are 255 colors any pipe can be painted.

Because I can attach an attribute to the component and an API interface lets me change the color and display it.

How can I include the color which is Component specific in a bill of materials?

I have examined using a derived configuration with the partnumber+colornumber. but that makes 255x700 configurations.

Any ideas to help me?

Thanks

SolidworksBill Of Materials