CREATE TABLE LOGLISPREC (
   NRLOGLISPREC 		NUMBER 		NOT NULL,
   NRSEQPRELIST 		VARCHAR2(500),
   IDEMAILENVIADO   	VARCHAR2(1) 	NULL    
	CONSTRAINT CKC_LOGLISPREC_IDEMAILENVIADO CHECK (IDEMAILENVIADO IS NULL OR (IDEMAILENVIADO IN ('S','N'))),
   IDTIPOOPER   		VARCHAR2(1) 	NULL    
	CONSTRAINT CKC_LOGLISPREC_IDTIPOOPER CHECK (IDTIPOOPER IS NULL OR (IDTIPOOPER IN ('D','A'))),
   DTOPERACAO   		DATE,
   NRORG                       	NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO                    	VARCHAR2(1)     	DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_LOGLISPREC  CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO             	DATE                  	NULL,
   DTULTATU                  	DATE                 	NULL,
   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 PK_LOGLISPREC PRIMARY KEY (NRLOGLISPREC)
)