ALTER TABLE ITEMDEMOF ADD DSNOTAEXPITEM VARCHAR2(4000) NULL
/
CREATE TABLE  NOTAS_EXPLICATIVAS(
  CDEMPRESA 		VARCHAR2(02) NOT NULL,
  DSOBSERVEMP          	CLOB, 
   NRORG                       	NUMBER DEFAULT 	 SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO                    	VARCHAR2(1)     DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_NF_EXPLICAT CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO             	DATE                   NULL,
   DTULTATU                  	DATE                  NULL,
   NRORGINCLUSAO      	NUMBER             DEFAULT 1 NULL,
   CDOPERINCLUSAO    	VARCHAR2(12)  DEFAULT '1' NULL,
   NRORGULTATU          	NUMBER             DEFAULT 1 NULL,
   CDOPERULTATU        	VARCHAR2(12)  DEFAULT '1',
	CONSTRAINT PK_NF_EXPLICATIVAS PRIMARY KEY (CDEMPRESA)
)