CREATE TABLE TMPCOMESPPRATPME
(
   CDTMPCOMESPPRATPME         VARCHAR2(10)           NOT NULL,
   NRSEQTMPCOMESPPRATPME      NUMBER NOT NULL,
   CDREALCOMESPPRATPME        VARCHAR2(10)      NOT NULL,
   CDFILCENTPME               VARCHAR2(4)         NOT NULL,
   CDFILIAL                   VARCHAR2(4)         NOT NULL,
   CDTIPOCARD                 VARCHAR2(10)       NOT NULL,
   CDTIPOPRAT_REF             VARCHAR2(2)       NOT NULL,
   CDPRATO_REF                VARCHAR2(10)      NOT NULL,
   CDFILAUXPRAT_REF           VARCHAR2(4)         NOT NULL,
   CDCOMESPPRATPME            VARCHAR2(10) NOT NULL,
   CDTIPOPRAT_DEST            VARCHAR2(2) NOT NULL, 
   CDPRATO_DEST               VARCHAR2(10) NOT NULL,
   CDFILAUXPRAT_DEST          VARCHAR2(4) NOT NULL,
   QTCOMESPRAT                NUMBER(10) NOT NULL,
   NRSEQCNFCPME               NUMBER(10) NOT NULL,
   NRORDCNFCPME               NUMBER(10) NOT NULL,
   DTCARDIA                   DATE NOT NULL,    
   NRORG                      NUMBER(10) 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(10) DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL, 
   CDOPERINCLUSAO             VARCHAR2(12) DEFAULT '1' NULL, 
   NRORGULTATU                NUMBER(10) DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL, 
   CDOPERULTATU               VARCHAR2(12) DEFAULT '1' NULL,
      CONSTRAINT CKC_IDATIVO_TMPCOMESPPRATPME CHECK (IDATIVO IN ('S', 'N'))
)
/