soma_lancamentos.sql

select 
		t.id_transacao_contabil,
        t.somatorio_lancamentos,
        sum(ti.valor) as somaValores
from 
		AccountingTransaction t 
inner join AccountingTransactionItem ti on ti.id_transacao_contabil = t.id_transacao_contabil and ti.stat <> 0 and ti.natureza = 'D'
where 
	t.stat <> 0 
group by  t.id_transacao_contabil order by t.id_transacao_contabil;