delete_lancamentos_encerramento.sql

DELETE FROM AccountingTransactionItem 
WHERE
    id_transacao_contabil IN (SELECT 
        id_transacao_contabil
    FROM
        dev_gestorfox.AccountingTransaction
    
    WHERE
        id_descricao_transacao_contabil = 79);
        
        
DELETE FROM AccountingTransaction 
WHERE
    id_descricao_transacao_contabil = 79;
    

DELETE FROM AccountingBalanceSheetAccountBalance WHERE id_balanco_contabil in(SELECT id_balanco_contabil FROM dev_gestorfox.AccountingBalanceSheet where tipo_balanco = 'E');

DELETE FROM AccountingBalanceSheet where tipo_balanco = 'E';