CREATE TABLE  ITEM_TEST 
   (	ITEMID NUMBER(6,0) NOT NULL ENABLE, 
	ITYPE VARCHAR2(2 CHAR) NOT NULL ENABLE, 
	NAMED VARCHAR2(50), 
	PRICE NUMBER(8,2), 
	PUOM_COST NUMBER(8,2), 
	SUOM_CONVERT NUMBER(12,6), 
	PUOM NUMBER(7,2), 
	SUOM NUMBER(7,2), 
	PUOMDES CHAR(1), 
	SUOMDES CHAR(1), 
	SOURCE CHAR(1), 
	MINIBAR CHAR(1), 
	COMPONENT CHAR(1), 
	SUPPLIER NUMBER(6,0), 
	LOT_SIZE NUMBER(6,0), 
	PARENTID NUMBER(5,0), 
	SECTION CHAR(1), 
	INACTIVE CHAR(1), 
	NOTES VARCHAR2(600), 
	REORDER NUMBER(4,0), 
	OARSLOGDT TIMESTAMP (6), 
	UPDATEDT TIMESTAMP (0) WITH LOCAL TIME ZONE, 
	UPDATEBY NUMBER(6,0), 
	VINTAGE NUMBER(4,0), 
	RCP_RECALC NUMBER(8,2), 
	BRAND VARCHAR2(10), 
	MENUCODE VARCHAR2(5), 
	VARIETY CHAR(1), 
	LDES VARCHAR2(200), 
	APPROVEDBY NUMBER(5,0), 
	 CONSTRAINT ITEM_TEST_PK PRIMARY KEY (ITEMID)
   )