http://wiki.geosales.com.br:8000/index.php?action=history&feed=atom&title=An%C3%A1lise_de_Tributa%C3%A7%C3%A3o_-_HAFELE 2026-05-05T18:23:41Z Histórico de revisões para esta página neste wiki MediaWiki 1.35.0 http://wiki.geosales.com.br:8000/index.php?title=An%C3%A1lise_de_Tributa%C3%A7%C3%A3o_-_HAFELE&diff=8183&oldid=prev 2018-07-02T12:43:23Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="pt-BR"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Edição anterior</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Edição das 12h43min de 2 de julho de 2018</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Linha 1:</td> <td colspan="2" class="diff-lineno">Linha 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Segue abaixo SCRIPT para análise de <del class="diffchange diffchange-inline">tributração</del>:</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">:*</ins>Segue abaixo SCRIPT para análise de <ins class="diffchange diffchange-inline">tributação</ins>:</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&lt;pre&gt;</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">----</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>DECLARE @CD_CLI INT = <ins class="diffchange diffchange-inline">--&lt;inserir cliente&gt;</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>DECLARE @CD_PRO INT = <ins class="diffchange diffchange-inline">--&lt;inserir produto&gt;</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">USE BD_SSM_HAFELE</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>DECLARE @CD_CLI INT = <del class="diffchange diffchange-inline">6702</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>DECLARE @CD_PRO INT = <del class="diffchange diffchange-inline">83374172</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>DECLARE @UF_CLI VARCHAR(2) = (SELECT NM_ESTADO FROM CLIENTE WHERE CD_CLIENTE = @CD_CLI)</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>DECLARE @UF_CLI VARCHAR(2) = (SELECT NM_ESTADO FROM CLIENTE WHERE CD_CLIENTE = @CD_CLI)</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l29" >Linha 29:</td> <td colspan="2" class="diff-lineno">Linha 26:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>AND UF = @UF_CLI</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>AND UF = @UF_CLI</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>AND CD_ORG_VENDA IN (SELECT CD_ORG_VENDA FROM ORG_VENDA_CLIENTE WHERE CD_CLIENTE = @CD_CLI)</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>AND CD_ORG_VENDA IN (SELECT CD_ORG_VENDA FROM ORG_VENDA_CLIENTE WHERE CD_CLIENTE = @CD_CLI)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&lt;/pre&gt;</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">----</del></div></td><td colspan="2"> </td></tr> <!-- diff cache key wiki:diff::1.12:old-8182:rev-8183 --> </table>

Fabio.jose http://wiki.geosales.com.br:8000/index.php?title=An%C3%A1lise_de_Tributa%C3%A7%C3%A3o_-_HAFELE&diff=8182&oldid=prev 2018-07-02T12:38:50Z

<p>Criou página com &#039;Segue abaixo SCRIPT para análise de tributração: ---- USE BD_SSM_HAFELE DECLARE @CD_CLI INT = 6702 DECLARE @CD_PRO INT = 83374172 DECLARE @UF_CLI VARCHAR(2) = (SELECT NM...&#039;</p> <p><b>Página nova</b></p><div>Segue abaixo SCRIPT para análise de tributração:<br /> <br /> ----<br /> <br /> USE BD_SSM_HAFELE<br /> <br /> DECLARE @CD_CLI INT = 6702<br /> DECLARE @CD_PRO INT = 83374172<br /> DECLARE @UF_CLI VARCHAR(2) = (SELECT NM_ESTADO FROM CLIENTE WHERE CD_CLIENTE = @CD_CLI)<br /> <br /> SELECT<br /> CD_ORG_VENDA,<br /> UF,<br /> CD_GRUPO_CLIENTE,<br /> CD_GRUPO_PRODUTO,<br /> PR_ALIQ_ICMS,<br /> PR_ALIQ_IPI,<br /> --------------------------------------<br /> -- ANALISANDO &quot;IPI&quot; NA NOVA TABELA. --<br /> --------------------------------------<br /> (SELECT PR_ALIQ_IPI FROM IPI WHERE CD_PRODUTO = @CD_PRO AND CD_ORG_VENDA = (SELECT CD_ORG_VENDA FROM ORG_VENDA_CLIENTE WHERE CD_CLIENTE = @CD_CLI)) AS 'NEW IPI',<br /> --------------------------------------<br /> -- ANALISANDO &quot;IPI&quot; NA NOVA TABELA. --<br /> --------------------------------------<br /> (SELECT PR_ALIQ_ICMS FROM ICMS_PROPRIO WHERE UF_DESTINO = @UF_CLI AND CD_ORG_VENDA = (SELECT CD_ORG_VENDA FROM ORG_VENDA_CLIENTE WHERE CD_CLIENTE = @CD_CLI)) AS 'NEW ICMS'<br /> FROM TRIBUTACAO T<br /> WHERE CD_GRUPO_CLIENTE IN (SELECT CD_GRUPO FROM TRIBUTACAO_CLIENTE WHERE CD_CLIENTE = @CD_CLI)<br /> AND CD_GRUPO_PRODUTO IN (SELECT CD_GRUPO FROM TRIBUTACAO_PRODUTO WHERE CD_PRODUTO = @CD_PRO)<br /> AND UF = @UF_CLI<br /> AND CD_ORG_VENDA IN (SELECT CD_ORG_VENDA FROM ORG_VENDA_CLIENTE WHERE CD_CLIENTE = @CD_CLI)<br /> <br /> ----</div>

Fabio.jose