CREATE TABLE PREVALIDXML (
   NRSEQVALIDXML  VARCHAR2(10)  NOT NULL,
   NRSEQERROXML   VARCHAR2(5)   NOT NULL,
   IDTPVALIDXML   VARCHAR2(1)   DEFAULT 'E' NOT NULL
		CONSTRAINT CKC_IDTPVALIDXML_PREVALIDXML CHECK (IDTPVALIDXML IN ('E','A')),
   NMARQXML       VARCHAR2(150) NULL,
   CDFILIAL       VARCHAR2(4)   NULL,
   CDCAIXA        VARCHAR2(3)   NULL,
   NRNOTAFISCALCE VARCHAR2(9)   NULL,
   NRACESSONFCE   VARCHAR2(50)  NULL,
   CDPRODUTO      VARCHAR2(30)  NULL,
   NMPRODUTO      VARCHAR2(50)  NULL,
   DSERROXML      VARCHAR2(300) NULL,
   DSAJUDAXML     VARCHAR2(300) NULL,
   NRORG          NUMBER        DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO        VARCHAR2(1)   DEFAULT 'S' NOT NULL
		CONSTRAINT CKC_IDATIVO_PREVALIDXML CHECK (IDATIVO IN ('S','N')),
   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' NULL,
		CONSTRAINT PK_PREVALIDXML PRIMARY KEY (NRSEQVALIDXML, NRSEQERROXML)
)
/