 		  'P',
 		  999,
 		  0.999,
-		  30,
+		  (select min(prodcat_id) from prodcat),
 		  true,
 		  9999.9999,
-		  15,
+		  (select max(uom_id) from uom),
 		  true,
 		  'item extended description',
 		  '12345-67890',
 		  99,
-		  1,
+		  (select min(freightclass_id) from freightclass),
 		  999999.99);
 
 	-- confirm INSERT record

			"type"				= 'P',
			product_weight			= 888,
			package_weight			= 0.888,
			product_category		= 28,
			is_exclusive			= false,
			list_price			= 8888.8888,
			price_unit			= 4,
			is_configured			= false,
			extended_description		= '***updated extended description',
			barcode				= 'xxxxxx-xxxxxx',
			warranty_days			= 0,
			freight_class			= 2,
			max_cost			= 888888.88
		 WHERE id 				= 99999;


		   SET  is_active			= false,
			description1			= '***updated item description 1',
			description2			= '***updated item description 2',
			class_code			= (select max(classcode_id) from classcode),
			inventory_unit			= (select (min(uom_id) +1) from uom),
			is_picklist			= false,
			notes				= '***updated item notes',
			is_sold				= false,
