 		   SET  is_active			= false,
 			description1			= '***updated item description 1',
 			description2			= '***updated item description 2',
-			class_code			= 33,
-			inventory_unit			= 11,
+			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,

			"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;


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

	-- confirm INSERT record
