CREATE GLOBAL TEMPORARY TABLE TMP_CREDSTRJ
 (
    NUMSEQ                       NUMBER,
	 NCM                          VARCHAR2(9),
	 SUBFAMILIA                   VARCHAR2(100),
	 PRODUTO                      VARCHAR2(20),
	 DESCR_PRODUTO                VARCHAR2(400),
	 INSCRICAO                    VARCHAR2(17),
	 CNPJ                         VARCHAR2(21),
	 RAZAO_SOCIAL                 VARCHAR2(100),
	 NUMERO_NF                    VARCHAR2(10),
	 SERIE                        VARCHAR2(5),
	 MODELO                       VARCHAR2(2),
	 CHAVE                        VARCHAR2(51),
	 EMISSAO                      DATE,
	 ENTRADA                      DATE,
	 FILIAL_RECE                  VARCHAR2(4),
	 NOME_FILIAL                  VARCHAR2(30),
	 TIPO                         VARCHAR2(1),
	 OPERACAO                     VARCHAR2(2),
	 DESCR_OPERACAO               VARCHAR2(30),
	 ESTADO                       VARCHAR2(2),
	 QTDE                         FLOAT,
	 VALOR_CONTABIL               FLOAT,
	 BASE                         FLOAT,
	 IMPOSTO                      FLOAT,
	 ALIQUOTA                     FLOAT,
	 CFOP                         VARCHAR2(11),
	 CST                          VARCHAR2(3),
	 SALDO                        FLOAT,
  	 SAIDA_FILIAL                 VARCHAR2(4),
    SAIDA_NOME_FILIAL            VARCHAR2(30),
	 SAIDA_NUMERO_NF              VARCHAR2(10),
	 SAIDA_EMISSAO                DATE,
	 SAIDA_ESTADO                 VARCHAR2(2),
	 SAIDA_CHAVE                  VARCHAR2(51),
	 SAIDA_VALOR_NF               FLOAT,
	 SAIDA_QTDE_ORIGINAL          FLOAT,
	 SAIDA_QTDE                   FLOAT,
	 SAIDA_CFOP                   VARCHAR2(11),
	 SAIDA_VALOR_CONTABIL         FLOAT,
	 SAIDA_BASE                   FLOAT,
	 SAIDA_IMPOSTO                FLOAT,
	 SAIDA_BASE_ST                FLOAT,
	 SAIDA_IMPOSTO_ST             FLOAT,
	 CREDITO_ICMS_PROPRIO         FLOAT,
	 CDPRODUTO                    VARCHAR2(10),
	 NRACESSONFE                  VARCHAR2(44),
    CONSTRAINT PK_TMP_CREDSTRJ PRIMARY KEY (NUMSEQ)
) ON COMMIT PRESERVE ROWS
/