CREATE TABLE PREVALIDECD
(
    CDEMPRESA           VARCHAR2(2)       NOT NULL,
    DTPERIODO           DATE              NOT NULL,
    NRSEQERRO           VARCHAR2(5)       NOT NULL,
    DSERRONFPRE         VARCHAR2(300)     NULL    ,
    DSAJUDA             VARCHAR2(300)     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_PREVALIDECD CHECK (IDATIVO IN ('S','N')),
		CONSTRAINT PK_PREVALIDECD PRIMARY KEY (CDEMPRESA, DTPERIODO, NRSEQERRO)
)
/