Skip to content

Instantly share code, notes, and snippets.

@suspecie
Last active January 5, 2017 13:15
Show Gist options
  • Save suspecie/54a6a9fd7e6c36d3ea5549ab282bc6fc to your computer and use it in GitHub Desktop.
Save suspecie/54a6a9fd7e6c36d3ea5549ab282bc6fc to your computer and use it in GitHub Desktop.
INSERT INTO AccountingBalanceSheetTechnicalEntity(des, stat) SELECT des, stat FROM con_entidade_tecnica;
INSERT INTO `AccountingBalanceSheetSubscriberQualification` (cod, des, stat) VALUES
(203,'DIRETOR',1),
(204,'CONSELHEIRO DE ADMINISTRACAO',1),
(205,'ADMINISTRADOR',1),
(206,'ADMINISTRADOR DO GRUPO',1),
(207,'ADMINISTRADOR DE SOCIEDADE FILIADA',1),
(220,'ADMINISTRADOR JUDICIAL - PESSOA FISICA', 1),
(222,'ADMINISTRADOR JUDICIAL - PESSOA JURIDICA - PROFISSIONAL RESPONSAVEL',1),
(223,'ADMINISTRADOR JUDICIAL/GESTOR',1),
(226,'GESTOR JUDICIAL',1),
(309,'PROCURADOR',1),
(312,'INVENTARIANTE',1),
(313,'LIQUIDANTE',1),
(315,'INTERVENTOR',1),
(801,'EMPRESARIO',1),
(900,'CONTADOR',1),
(900,'CONTABILISTA',1),
(999,'OUTROS',1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment