Skip to content

Instantly share code, notes, and snippets.

@primogf

primogf/importaLancamentosCabecalho.sql

Created January 3, 2017 16:55
Show Gist options
  • Save primogf/c2d6fbb54f26bf4f99839d75534dab1d to your computer and use it in GitHub Desktop.
Save primogf/c2d6fbb54f26bf4f99839d75534dab1d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
importaLancamentosCabecalho.sql
insert into AccountingTransaction (id_transacao_contabil,id_empresa,id_parceiro_principal,id_parceiro_operacional,id_descricao_transacao_contabil,dt_contabil,somatorio_lancamentos,stat_fechamento,des_complemento,tipo_lancamento_sped,stat)
select a.id_lancamento_contabil,a.id_empresa,null,a.id_parceiro,null,a.dt_contabil,a.somatorio_lancamentos,a.status_fechamento,a.des,a.tipo_lancto_sped,a.stat from con_lancamento_contabil a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment