If I understand what you are trying to achieve then a simple procedure would be to use, for example, the last four digits of all customer issued part nos, to refer to your internal listing where those four digit numbers are used to designate the original manufacturer's part no.