CREATE TABLE IMPERROPEDAF
(
 NRAUTOFORN   		VARCHAR2(10),
 DTPROGENTAF  		DATE,
 NMFORNECEDOR 		VARCHAR2(120),
 CONSTRAINT PK_IMPERROPEDAF PRIMARY KEY(NRAUTOFORN),
 NRORG 			 	NUMBER		    DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
 IDATIVO            VARCHAR2(1)   	DEFAULT 'S' 									NOT NULL,
    CONSTRAINT CKC_IDATIVO_IMPERROPEDAF 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'
)