ALTER TABLE CODRECEITACONTR ADD CDNATUREND VARCHAR2(20) NULL
/

CREATE TABLE NATUREZAREND
 ( 
     NRSEQUENCIAL 	   NUMBER           NOT NULL,
     CDNATUREND   	   VARCHAR2(20)     NULL,
     DSNATUREND   	   VARCHAR2(500)    NULL,
     CDIMPOSTO    	   VARCHAR2(20)     NULL,    
     NRORG             NUMBER 	       DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
	 IDATIVO           VARCHAR2(1)     DEFAULT 'S'					NOT NULL,
     DTINCLUSAO        DATE            DEFAULT SYSDATE,
     DTULTATU          DATE            DEFAULT SYSDATE,
     NRORGINCLUSAO     NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
     CDOPERINCLUSAO    VARCHAR2(12)    DEFAULT '1' 					NULL,
     NRORGULTATU       NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
     CDOPERULTATU      VARCHAR2(12)    DEFAULT '1',   
		 CONSTRAINT CKC_IDATIVO_NATUREZAREND    CHECK (IDATIVO IN ('S','N')),
		 CONSTRAINT PK_NATUREZAREND PRIMARY KEY (NRSEQUENCIAL)
)
/