permissoes_lancamento_contabil

permissoes.sql

INSERT INTO `AccountingTransactionDescriptionProfile`(`id_descricao_transacao_contabil`,`id_perfil`)
VALUES ((SELECT 1 FROM AccountingTransactionDescription where des = 'MIGRACAO DE DADOS'),117);

INSERT INTO AccountingTransactionDescriptionEnvironment(id_descricao_transacao_contabil, id_empresa) SELECT
	id_descricao_transacao_contabil ,
	id_empresa
FROM
	AccountingTransactionDescription
LEFT JOIN erp_empresa  e ON 1 = 1
WHERE e.stat <> 0;