Roger...
35 years ago, when I started RST Engineering, I was restricted to numbers below the integer-based storage of the computer we had at the time, so all of our part numbers were 64,000 and below. (+32K to -32K and a subtraction algorithm that made them all positive).Fifteen years ago we switched to a 9-digit part number and what a pain in the labonza to change them all over. However, change them we did and it has made life one hell of a lot easier.
Send me a decent email address to jim at rstengineering point com and I'll port you back our internal company document on how the system works.
Basically, it is a number like 1-2345-6789 where the first digit is a broad class (mechanical component, electrical component, in house made component, subassembly, etc.), the 23 is a very generic class of parts (and for electrical parts, 90% of our stock, based on the first two digits of the Electronic Engineers Master [EEM] numbering system), the 4 breaks it down to through-hole, smd, etc., 5 breaks it down further (quarter watt, half watt), the 6 is the tolerance, the 789 is the value in milliohms with the 7 being the multiplier and the 89 being the significant digits.
The more I think about it, the better I like the first character being a letter. That gives me 52 options PLUS the 20 some oddball categories of @#%& non-alpha characters.
Drop me a line. You might also look at a program called Parts & Vendors that handles this sort of numbering system quite well.
Jim