If you use the products_id field and add on to the prid and it keeps things tracked together it should work ...

Otherwise, you will want to use a seperate field for your code so that it doesn't conflict with product tracking etc.