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

		  'P',
		  999,
		  0.999,
		  30,
		  true,
		  9999.9999,
		  15,
		  true,
		  'item extended description',
		  '12345-67890',
		  99,
		  1,
		  999999.99);

	-- confirm INSERT record

		   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,
