 			"type"				= 'P',
 			product_weight			= 888,
 			package_weight			= 0.888,
-			product_category		= 28,
+			product_category		= (select max(prodcat_id) from prodcat),
 			is_exclusive			= false,
 			list_price			= 8888.8888,
-			price_unit			= 4,
+			price_unit			= (select (max(uom_id) -1) from uom),
 			is_configured			= false,
 			extended_description		= '***updated extended description',
 			barcode				= 'xxxxxx-xxxxxx',
 			warranty_days			= 0,
-			freight_class			= 2,
+			freight_class			= (select max(freightclass_id) from freightclass),
 			max_cost			= 888888.88
 		 WHERE id 				= 99999;
 

		   SET  is_active			= false,
			description1			= '***updated item description 1',
			description2			= '***updated item description 2',
			class_code			= 33,
			inventory_unit			= 11,
			is_picklist			= false,
			notes				= '***updated item notes',
			is_sold				= false,

		  true,
		  'item description 1',
		  'item description 2',
		  (select min(classcode_id) from classcode),
		  (select min(uom_id) from uom),
		  true,
		  'item notes',
		  true,
