final product type revision; added inventory locations table