Dorcílio João de Oliveira Neto dorcilio
🏠
dorcilio
/ Script.sql
Created
October 20, 2017 18:51
Gist criado pelo Formatador-Planos para compartilhamento de Query SQL.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select spc.gerar_sped2(10418, true) |
dorcilio
/ Script-Movimento-Operacao.sql
Created
October 20, 2017 18:52
Gist criado pelo Formatador-Planos para compartilhamento de Query SQL.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| a.operacao, | |
| SUM(a.total) AS total | |
| FROM | |
| ( | |
| WITH speds AS ( | |
| SELECT | |
| a.id_reg_0000 | |
| FROM | |
| sf.reg_0000 a |
dorcilio
/ atualizado.sql
Created
October 26, 2017 11:48
Gist criado pelo Formatador-Planos para compartilhamento de Query SQL.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| a.inf_nfe, | |
| a.n_nf, | |
| a.id_empresa, | |
| a.d_emi, | |
| a.cnpj, | |
| a.ie, | |
| b.id_nfe, | |
| CASE WHEN b.id_nfe IS NULL THEN | |
| FALSE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| a.cnpj AS empresa_cnpj, | |
| e.empresa_cod_item, | |
| e.empresa_descricao, | |
| e.empresa_operacao, | |
| b.cpf_cnpj AS fornecedor_cnpj, | |
| c.c_prod AS fornecedor_cod_item, | |
| c.x_prod AS fornecedor_descricao, | |
| c.v_prod AS fornecedor_vl_item, | |
| c.ncm AS fornecedor_ncm, |
dorcilio
/ Script_Produtos_Calculo_Pauta.sql
Created
December 7, 2017 12:30
Gist criado pelo Formatador-Planos para compartilhamento de Query SQL.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| a.id_nfe, | |
| b.cpf_cnpj, | |
| d.n_item, | |
| e.ID AS id_produto, | |
| e.c_prod, | |
| e.x_prod, | |
| e.v_prod, | |
| e.q_com, | |
| COALESCE(e.v_frete, 0) :: NUMERIC(18, 2) AS v_frete, |
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #EXTM3U | |
| #EXTINF:-1 group-title="Canais | 24 Horas" tvg-logo="http://a5.vc/IJJ" ,101 Dalmatas | |
| http://dnsx.co:80//9021560985/fireurl.co/47458 | |
| #EXTINF:-1 group-title="Canais | 24 Horas" tvg-logo="http://a5.vc/84v" ,3 Palavrinhas | |
| http://dnsx.co:80//9021560985/fireurl.co/47459 | |
| #EXTINF:-1 group-title="Canais | 24 Horas" tvg-name="3 PALAVRINHAS" ,3 PALAVRINHAS | |
| http://vvraw.com:2082/Altair567/356738473/13088 | |
| #EXTINF:-1 group-title="Canais | 24 Horas" tvg-name="44 GATOS" ,44 GATOS | |
| http://vvraw.com:2082/Altair567/356738473/13162 | |
| #EXTINF:-1 group-title="Canais | 24 Horas" tvg-name="9-1-1" ,9-1-1 |
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #EXTM3U | |
| #EXTINF:-1 tvg-id="aande.br" tvg-name="A&E FHD H265²" tvg-logo="https://upload.wikimedia.org/wikipedia/commons/thumb/0/04/A%26E-Network-Logo.svg/300px-A%26E-Network-Logo.svg.png" group-title="CANAIS | H.265",A&E FHD H265² | |
| http://vvraw.com:2082/Altair567/356738473/4088 | |
| #EXTINF:-1 tvg-id="aande.br" tvg-name="A&E FHD¹" tvg-logo="https://upload.wikimedia.org/wikipedia/commons/thumb/0/04/A%26E-Network-Logo.svg/300px-A%26E-Network-Logo.svg.png" group-title="CANAIS | ENTRETENIMENTO",A&E FHD¹ | |
| http://vvraw.com:2082/Altair567/356738473/6701 | |
| #EXTINF:-1 tvg-id="aande.br" tvg-name="A&E HD¹" tvg-logo="https://upload.wikimedia.org/wikipedia/commons/thumb/0/04/A%26E-Network-Logo.svg/300px-A%26E-Network-Logo.svg.png" group-title="CANAIS | ENTRETENIMENTO",A&E HD¹ | |
| http://vvraw.com:2082/Altair567/356738473/6882 | |
| #EXTINF:-1 tvg-id="aande.br" tvg-name="A&E SD¹" tvg-logo="https://upload.wikimedia.org/wikipedia/commons/thumb/0/04/A%26E-Network-Logo.svg/300px-A%26E-Network-Logo.svg.png" group-title="CANAIS | ENTRETENIMENTO",A& |