CREATE TABLE FILTROPREVCONS (
    CDFILLANC 				VARCHAR2(4),
    CDFILIAL 				VARCHAR2(4),
    CDSERVFILI 				VARCHAR2(5),
    DTPREVCONS 				DATE,
    NRORG                  		NUMBER          DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') 	NOT NULL,	
    IDATIVO                		VARCHAR2(1)     DEFAULT 'S' 						NOT NULL
    	CONSTRAINT CKC_IDATIVO_FILTROPREVCONS   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',
    PRIMARY KEY (CDFILLANC, CDFILIAL, CDSERVFILI, DTPREVCONS)
)