# 2. Impostos detalhados na importação de XML



# PROC001 - Impostos detalhados NFe de Entrada

<table border="1" id="bkmrk-%C2%A0-projeto%2Fsistema%3Age" style="border-collapse: collapse; width: 100.123%; height: 68px;"><tbody><tr style="border-style: solid;"><td rowspan="3" style="width: 26.6667%; height: 68px; border-color: black; border-top-style: hidden; border-left-style: hidden; border-bottom-style: hidden;">  
[![image-1762776253666.png](https://docs.softensistemas.com.br/uploads/images/gallery/2025-11/scaled-1680-/image-1762776253666.png)](https://docs.softensistemas.com.br/uploads/images/gallery/2025-11/image-1762776253666.png)

</td><td style="width: 49.9999%; height: 10px; border-color: black; border-style: solid;"><span style="color: #000000;">**Projeto/Sistema:**</span>  
<span style="color: #000000;">GERENCIAMENTO DE PROJETOS</span></td><td class="align-center" style="width: 23.3333%; height: 10px; border-color: black; border-style: solid;"><span style="color: #000000;">**Versão do *Template:***</span>  
<span style="color: #000000;">1.2</span></td></tr><tr style="border-style: solid;"><td style="width: 49.9999%; height: 29px; border-color: black; border-style: solid;"><span style="color: #000000;">**Processo:**</span>  
PROC001 - Impostos detalhados NFe de Entrada</td><td class="align-center" style="width: 23.3333%; height: 29px; border-color: black; border-style: solid;"><span style="color: #000000;">**Versão do Documento:**</span>  
<span style="color: #000000;">1.0</span></td></tr><tr style="border-style: solid;"><td style="width: 49.9999%; height: 29px; border-color: black; border-style: solid;"><span style="color: #000000;">**Responsável(eis):** </span>  
<span style="color: #000000;">Luís Leite</span></td><td class="align-center" style="width: 23.3333%; height: 29px; border-color: black; border-style: solid;"><span style="color: #000000;">**Data:** </span>

<span style="color: #000000;">05/01/2026</span>

</td></tr></tbody></table>

##### <span style="color: #000000;">**1. Introdução**</span>

<table cellpadding="9" cellspacing="0" id="bkmrk-processo-envolvidos-" width="100%"><tbody><tr valign="top"><td bgcolor="#acb9ca" style="border-style: solid; border-color: black;" width="27%"><span style="font-size: small; color: #000000;">**Processo**</span>

</td><td bgcolor="#acb9ca" style="border-style: solid; border-color: black;" width="19%"><span style="font-size: small; color: #000000;">**Envolvidos**</span>

</td><td bgcolor="#acb9ca" style="border-style: solid; border-color: black;" width="27%"><span style="font-size: small; color: #000000;">**Dados de Entrada**</span>

</td><td bgcolor="#acb9ca" style="border-style: solid; border-color: black;" width="27%"><span style="font-size: small; color: #000000;">**Dados de Saída**</span>

</td></tr><tr valign="top"><td style="border-style: solid; border-color: black;" width="27%">PROC001 - Impostos detalhados NFe de Entrada

</td><td style="border-style: solid; border-color: black;" width="19%"><span style="font-size: small; color: #000000;">N/A</span>

</td><td style="border-style: solid; border-color: black;" width="27%"><span style="font-size: small; color: #000000;">N/A</span>

</td><td style="border-style: solid; border-color: black;" width="27%"><span style="font-size: small; color: #000000;">N/A</span>

</td></tr></tbody></table>

#### **Especificação Funcional**

- - - - - -

#### **PROC001 EXEMPLO:**

##### ***Protótipo de Tela:***

[![image-1774370971960.png](https://docs.softensistemas.com.br/uploads/images/gallery/2026-03/scaled-1680-/image-1774370971960.png)](https://docs.softensistemas.com.br/uploads/images/gallery/2026-03/image-1774370971960.png)

*Imagem I - Nova coluna de imposto.*

[![image-1774372143691.png](https://docs.softensistemas.com.br/uploads/images/gallery/2026-03/scaled-1680-/image-1774372143691.png)](https://docs.softensistemas.com.br/uploads/images/gallery/2026-03/image-1774372143691.png)

*Imagem II - Rodapé com Totais.*

[![image-1774371643191.png](https://docs.softensistemas.com.br/uploads/images/gallery/2026-03/scaled-1680-/image-1774371643191.png)](https://docs.softensistemas.com.br/uploads/images/gallery/2026-03/image-1774371643191.png)

*Imagem III - Tela de imposto em visualização.*

##### ***Descrição dos Campos:***

<table border="1" cellpadding="7" cellspacing="0" id="bkmrk-campo-tipo-tamanho-o" style="width: 843px; height: 216px;"><tbody><tr style="height: 35px;" valign="top"><td bgcolor="#acb9ca" style="width: 167.969px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">**Campo**</span>

</td><td bgcolor="#acb9ca" style="width: 101.997px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">**Tipo**</span>

</td><td bgcolor="#acb9ca" style="width: 87.9688px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">**Tamanho**</span>

</td><td bgcolor="#acb9ca" style="width: 165px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">**Obrig. ?**</span>

</td><td bgcolor="#acb9ca" style="width: 118.976px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">**Máscara**</span>

</td><td bgcolor="#acb9ca" style="width: 200.99px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">**Observações**</span>

</td></tr><tr style="height: 57px;"><td style="width: 167.969px; border-style: solid; border-color: black; height: 57px;"><span style="color: #000000;">Imposto</span>

</td><td style="width: 101.997px; border-style: solid; border-color: black; height: 57px;">*<span style="color: #000000;">Column Header</span>*

</td><td style="width: 87.9688px; border-style: solid; border-color: black; height: 57px;"><span style="color: #000000;">-</span>

</td><td style="width: 165px; border-style: solid; border-color: black; height: 57px;"><span style="color: #000000;">-</span>

</td><td style="width: 118.976px; border-style: solid; border-color: black; height: 57px;">-

</td><td style="width: 200.99px; border-style: solid; border-color: black; height: 57px;">-

</td></tr><tr style="height: 35px;"><td style="width: 167.969px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">Ver/Editar</span>

</td><td style="width: 101.997px; border-style: solid; border-color: black; height: 35px;">*<span style="color: #000000;">Link</span>*

</td><td style="width: 87.9688px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">-</span>

</td><td style="width: 165px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">-</span>

</td><td style="width: 118.976px; border-style: solid; border-color: black; height: 35px;">-

</td><td style="width: 200.99px; border-style: solid; border-color: black; height: 35px;">-

</td></tr><tr style="height: 35px;"><td style="width: 167.969px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">Valor Total de ICMS</span>

</td><td style="width: 101.997px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">Decimal</span>

</td><td style="width: 87.9688px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">-</span>

</td><td style="width: 165px; border-style: solid; border-color: black; height: 35px;"><span style="color: #000000;">-</span>

</td><td style="width: 118.976px; border-style: solid; border-color: black; height: 35px;">-

</td><td style="width: 200.99px; border-style: solid; border-color: black; height: 35px;">-

</td></tr><tr style="height: 54px;"><td style="width: 167.969px; border-style: solid; border-color: black; height: 54px;"><span style="color: #000000;">Valor Total de IPI</span><span style="color: #000000;"> </span>

</td><td style="width: 101.997px; border-style: solid; border-color: black; height: 54px;"><span style="color: #000000;">Decimal</span>

</td><td style="width: 87.9688px; border-style: solid; border-color: black; height: 54px;"><span style="color: #000000;">-</span>

</td><td style="width: 165px; border-style: solid; border-color: black; height: 54px;"><span style="color: #000000;">-</span>

</td><td style="width: 118.976px; border-style: solid; border-color: black; height: 54px;">-

</td><td style="width: 200.99px; border-style: solid; border-color: black; height: 54px;">-

</td></tr></tbody></table>

##### ***Regras de Interface:***

***1.Ver Imposto:*** Deve abrir a *Dialog* (Imagem III) contendo os preenchimentos de tributos. Mesmo principio da *Dialog* da tela de Ver/Edita da Nota Fiscal de Entrada em digitação, com ressalva que os campos devem ser todos bloqueados de preenchimento.

**2. <span style="color: #000000;">Valor Total de ICMS: </span>**<span style="color: #000000;">Totalizador dos ICMS dos produtos.</span>

**<span style="color: #000000;">3. Valor Total de IPI: </span>**<span style="color: #000000;">Totalizador do IPI dos produtos.</span>

##### ***Regras de Negócio:***

***1.*** Atualmente já existem os campos referentes aos impostos da NFe de entrada na base de dados. Devem ser inseridos os impostos do XML de entrada nas tabelas 'nfeentradaproduto' e 'nfeentradaprodutoinfo'

**2.** Validar a importação de todos os campos, até a presente data da documentação ICMS não está importando.

##### ***Questões Técnicas:***

***1. Consulta dos tributos***

```SQL
SELECT * 
FROM `gerencieaqui`.`nfeentradaproduto` AS nep
LEFT JOIN `gerencieaqui`.`nfeentradaprodutoinfo` AS nepi
    ON nepi.`id` = nep.`nfeEntradaProdutoInfoId`
WHERE nep.`Id` = 121;
```

©SOFTEN SISTEMAS 2026