XML vs Banco de Dados
Comparação entre XML original e dados gravados
Informações do Pedido
Pedido ID:
P006454N000003709
Chave NFe:
13240523096004000110550010000064541000037091
13240523096004000110550010000064541000037091
Tipo:
Venda
Venda
Status:
Confirmado
Confirmado
Dados Gravados no Banco
Identificação (ide)
| UF | 13 |
| Natureza | Venda |
| Modelo | 55 |
| Série | 1 |
| Número NFe | 6454 |
| Data Emissão | 20/05/2024 06:04:14 |
| Tipo NFe | 1 |
| Finalidade | 1 |
Emitente
| CNPJ | 23096004000110 |
| Razão Social | JOSE MARIA GOERSCH ANDRADE - ME |
| Nome Fantasia | ANDRADE EPIS |
| Logradouro | RUA MONTE CARLO |
| Número | 8 |
| Bairro | PLANALTO |
| Município | Manaus |
| UF | AM |
| CEP | 69045170 |
Destinatário
| CNPJ/CPF | 46461140204 |
| Nome | MARCIO KOJI MIYAMOTO |
| Logradouro | RODOVIA AM 10 KM 38 |
| Número | 100 |
| Bairro | ZONA OESTE |
| Município | MANAUS |
| UF | AM |
| CEP | 69059070 |
Produtos (5)
| Código | Descrição | NCM | Qtd | Valor |
|---|---|---|---|---|
798190027272 |
CINTA ERGONOMICA TAM M | 90211010 | 2,00 | R$ 110,00 |
582 |
LUVA PVC 36 CM - SOFT | 61161000 | 4,00 | R$ 66,00 |
2680 |
LUVA TRICOTADA 4 FIOS PlGMENTADA | 61161000 | 50,00 | R$ 165,00 |
7790652000505 |
OCULOS ECOLINE (INCOLOR) - LIBUS | 90049020 | 6,00 | R$ 36,00 |
7898530880253 |
OCULOS POLICARB AMPLAVISAO INDIRETO AR AE VICSA EVEREST INCOLOR | 90049020 | 1,00 | R$ 55,00 |
Totais
| BC ICMS | R$ 0,00 |
| Valor ICMS | R$ 0,00 |
| Produtos | R$ 432,00 |
| Frete | R$ 0,00 |
| Desconto | R$ 0,00 |
| IPI | R$ 0,00 |
| PIS | R$ 0,00 |
| COFINS | R$ 0,00 |
| Valor Total | R$ 432,00 |
Transporte
Modalidade: 3
Informações Adicionais
Complementar: 30 DIAS
XML Original
<?xml version="1.0" encoding="utf-16"?>
<nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="4.00">
<NFe>
<infNFe Id="NFe13240523096004000110550010000064541000037091" versao="4.00">
<ide>
<cUF>13</cUF>
<cNF>00003709</cNF>
<natOp>Venda</natOp>
<mod>55</mod>
<serie>1</serie>
<nNF>6454</nNF>
<dhEmi>2024-05-20T13:04:14+00:00</dhEmi>
<dhSaiEnt>2024-05-20T13:04:14+00:00</dhSaiEnt>
<tpNF>1</tpNF>
<idDest>1</idDest>
<cMunFG>1302603</cMunFG>
<tpImp>1</tpImp>
<tpEmis>1</tpEmis>
<cDV>1</cDV>
<tpAmb>1</tpAmb>
<finNFe>1</finNFe>
<indFinal>0</indFinal>
<indPres>0</indPres>
<procEmi>0</procEmi>
<verProc>4.00</verProc>
</ide>
<emit>
<CNPJ>23096004000110</CNPJ>
<xNome>JOSE MARIA GOERSCH ANDRADE - ME</xNome>
<xFant>ANDRADE EPIS</xFant>
<enderEmit>
<xLgr>RUA MONTE CARLO</xLgr>
<nro>8</nro>
<xCpl>CJ CAMPOS ELISEOS</xCpl>
<xBairro>PLANALTO</xBairro>
<cMun>1302603</cMun>
<xMun>Manaus</xMun>
<UF>AM</UF>
<CEP>69045170</CEP>
</enderEmit>
<IE>053711319</IE>
<IM>22431001</IM>
<CNAE>4782201</CNAE>
<CRT>1</CRT>
</emit>
<dest>
<CPF>46461140204</CPF>
<xNome>MARCIO KOJI MIYAMOTO</xNome>
<enderDest>
<xLgr>RODOVIA AM 10 KM 38</xLgr>
<nro>100</nro>
<xBairro>ZONA OESTE</xBairro>
<cMun>1302603</cMun>
<xMun>MANAUS</xMun>
<UF>AM</UF>
<CEP>69059070</CEP>
<cPais>1058</cPais>
<xPais>BRASIL</xPais>
<fone>92991526268</fone>
</enderDest>
<indIEDest>2</indIEDest>
</dest>
<det nItem="1">
<prod>
<cProd>798190027272</cProd>
<cEAN>0798190027272</cEAN>
<xProd>CINTA ERGONOMICA TAM M</xProd>
<NCM>90211010</NCM>
<CFOP>5102</CFOP>
<uCom>UNID</uCom>
<qCom>2.0000</qCom>
<vUnCom>55.0000000000</vUnCom>
<vProd>110.00</vProd>
<cEANTrib>0798190027272</cEANTrib>
<uTrib>UNID</uTrib>
<qTrib>2.0000</qTrib>
<vUnTrib>55.0000000000</vUnTrib>
<indTot>1</indTot>
</prod>
<imposto>
<vTotTrib>0.00</vTotTrib>
<ICMS>
<ICMSSN102>
<orig>0</orig>
<CSOSN>400</CSOSN>
</ICMSSN102>
</ICMS>
<PIS>
<PISNT>
<CST>07</CST>
</PISNT>
</PIS>
<COFINS>
<COFINSNT>
<CST>07</CST>
</COFINSNT>
</COFINS>
</imposto>
</det>
<det nItem="2">
<prod>
<cProd>582</cProd>
<cEAN>SEM GTIN</cEAN>
<xProd>LUVA PVC 36 CM - SOFT</xProd>
<NCM>61161000</NCM>
<CFOP>5102</CFOP>
<uCom>PAR</uCom>
<qCom>4.0000</qCom>
<vUnCom>16.5000000000</vUnCom>
<vProd>66.00</vProd>
<cEANTrib>SEM GTIN</cEANTrib>
<uTrib>PAR</uTrib>
<qTrib>4.0000</qTrib>
<vUnTrib>16.5000000000</vUnTrib>
<indTot>1</indTot>
</prod>
<imposto>
<vTotTrib>0.00</vTotTrib>
<ICMS>
<ICMSSN102>
<orig>0</orig>
<CSOSN>400</CSOSN>
</ICMSSN102>
</ICMS>
<PIS>
<PISNT>
<CST>07</CST>
</PISNT>
</PIS>
<COFINS>
<COFINSNT>
<CST>07</CST>
</COFINSNT>
</COFINS>
</imposto>
</det>
<det nItem="3">
<prod>
<cProd>2680</cProd>
<cEAN>SEM GTIN</cEAN>
<xProd>LUVA TRICOTADA 4 FIOS PlGMENTADA</xProd>
<NCM>61161000</NCM>
<CFOP>5102</CFOP>
<uCom>PR</uCom>
<qCom>50.0000</qCom>
<vUnCom>3.3000000000</vUnCom>
<vProd>165.00</vProd>
<cEANTrib>SEM GTIN</cEANTrib>
<uTrib>PR</uTrib>
<qTrib>50.0000</qTrib>
<vUnTrib>3.3000000000</vUnTrib>
<indTot>1</indTot>
</prod>
<imposto>
<vTotTrib>0.00</vTotTrib>
<ICMS>
<ICMSSN102>
<orig>0</orig>
<CSOSN>400</CSOSN>
</ICMSSN102>
</ICMS>
<PIS>
<PISNT>
<CST>07</CST>
</PISNT>
</PIS>
<COFINS>
<COFINSNT>
<CST>07</CST>
</COFINSNT>
</COFINS>
</imposto>
</det>
<det nItem="4">
<prod>
<cProd>7790652000505</cProd>
<cEAN>7790652000505</cEAN>
<xProd>OCULOS ECOLINE (INCOLOR) - LIBUS</xProd>
<NCM>90049020</NCM>
<CFOP>5102</CFOP>
<uCom>UNID</uCom>
<qCom>6.0000</qCom>
<vUnCom>6.0000000000</vUnCom>
<vProd>36.00</vProd>
<cEANTrib>7790652000505</cEANTrib>
<uTrib>UNID</uTrib>
<qTrib>6.0000</qTrib>
<vUnTrib>6.0000000000</vUnTrib>
<indTot>1</indTot>
</prod>
<imposto>
<vTotTrib>0.00</vTotTrib>
<ICMS>
<ICMSSN102>
<orig>0</orig>
<CSOSN>400</CSOSN>
</ICMSSN102>
</ICMS>
<PIS>
<PISNT>
<CST>07</CST>
</PISNT>
</PIS>
<COFINS>
<COFINSNT>
<CST>07</CST>
</COFINSNT>
</COFINS>
</imposto>
</det>
<det nItem="5">
<prod>
<cProd>7898530880253</cProd>
<cEAN>7898530880253</cEAN>
<xProd>OCULOS POLICARB AMPLAVISAO INDIRETO AR AE VICSA EVEREST INCOLOR</xProd>
<NCM>90049020</NCM>
<CFOP>5102</CFOP>
<uCom>UNID</uCom>
<qCom>1.0000</qCom>
<vUnCom>55.0000000000</vUnCom>
<vProd>55.00</vProd>
<cEANTrib>7898530880253</cEANTrib>
<uTrib>UNID</uTrib>
<qTrib>1.0000</qTrib>
<vUnTrib>55.0000000000</vUnTrib>
<indTot>1</indTot>
</prod>
<imposto>
<vTotTrib>0.00</vTotTrib>
<ICMS>
<ICMSSN102>
<orig>0</orig>
<CSOSN>400</CSOSN>
</ICMSSN102>
</ICMS>
<PIS>
<PISNT>
<CST>07</CST>
</PISNT>
</PIS>
<COFINS>
<COFINSNT>
<CST>07</CST>
</COFINSNT>
</COFINS>
</imposto>
</det>
<total>
<ICMSTot>
<vBC>0.00</vBC>
<vICMS>0.00</vICMS>
<vICMSDeson>0.00</vICMSDeson>
<vFCPUFDest>0.00</vFCPUFDest>
<vICMSUFDest>0.00</vICMSUFDest>
<vICMSUFRemet>0.00</vICMSUFRemet>
<vFCP>0.00</vFCP>
<vBCST>0.00</vBCST>
<vST>0.00</vST>
<vFCPST>0.00</vFCPST>
<vFCPSTRet>0.00</vFCPSTRet>
<vProd>432.00</vProd>
<vFrete>0.00</vFrete>
<vSeg>0.00</vSeg>
<vDesc>0.00</vDesc>
<vII>0.00</vII>
<vIPI>0.00</vIPI>
<vIPIDevol>0.00</vIPIDevol>
<vPIS>0.00</vPIS>
<vCOFINS>0.00</vCOFINS>
<vOutro>0.00</vOutro>
<vNF>432.00</vNF>
<vTotTrib>0.00</vTotTrib>
</ICMSTot>
</total>
<transp>
<modFrete>3</modFrete>
</transp>
<pag>
<detPag>
<tPag>15</tPag>
<vPag>432.00</vPag>
</detPag>
</pag>
<infAdic>
<infCpl>30 DIAS</infCpl>
</infAdic>
<infRespTec>
<CNPJ>23096004000110</CNPJ>
<xContato>suporte</xContato>
<email>andradeepis@hotmail.com</email>
<fone>9232287562</fone>
</infRespTec>
</infNFe>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
<SignedInfo>
<CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315" />
<SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" />
<Reference URI="#NFe13240523096004000110550010000064541000037091">
<Transforms>
<Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" />
<Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315" />
</Transforms>
<DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
<DigestValue>RvOB4QK8F25l1Yk0pPXSDs+AhYE=</DigestValue>
</Reference>
</SignedInfo>
<SignatureValue>hT0clB79YZwXMhYAuq4GiD6SRqwc+YVRmFWmky66TvkTXiYb3oDTbaWqjbgqCIpEO9ac+L1Z4vvGbWRDrT8Sz0rkuVvogQhEeLCzMVG01OlfOhWTPS1hLx2rkAHcGP5Pbe5d49ieeo0KN5x9358Z79Id9NEhgYGWmrBHUgMUGVzUw2c834flPJiEudFOSgO2Soc0DI3BdT159QtzW8PxkC+HMfKaTqVA7BijkEAHOD7aR4emPAYls1lkba5ENTaFl9f2tesEc/j8LmcDP9LCjdVFBYe3q/ROhJ4V2flpzSWW20oYJKpU0CzB3ouzl96OyqV5XDY9BHvNjCvWZZh6Zw==</SignatureValue>
<KeyInfo>
<X509Data>
<X509Certificate>MIIHlTCCBX2gAwIBAgIIUifDJAqE60EwDQYJKoZIhvcNAQELBQAwdzELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEbMBkGA1UEAxMSQUMgRE9DQ0xPVUQgUkZCIHYyMB4XDTI0MDExODE5NTUyM1oXDTI1MDExNzE5NTUyM1owgfIxCzAJBgNVBAYTAkJSMRMwEQYDVQQKEwpJQ1AtQnJhc2lsMQswCQYDVQQIEwJBTTEPMA0GA1UEBxMGTUFOQVVTMTYwNAYDVQQLEy1TZWNyZXRhcmlhIGRhIFJlY2VpdGEgRmVkZXJhbCBkbyBCcmFzaWwgLSBSRkIxFjAUBgNVBAsTDVJGQiBlLUNOUEogQTExFzAVBgNVBAsTDjIzODAyNjQ2MDAwMTk4MRMwEQYDVQQLEwpwcmVzZW5jaWFsMTIwMAYDVQQDEylKT1NFIE1BUklBIEdPRVJTQ0ggQU5EUkFERToyMzA5NjAwNDAwMDExMDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKOPr7IXsN9Ox1wg4lQfJWR7IW91/X9Ab8v47aMsZhkcQmEuPFiqI72u+K8DgXZwfc3qCWZA1J7ZuMIkkxlsiF6FBPLF7SWgd+MEGTvo4VpyZAptHa9TPP6yhVZSinq5oBNFastnjtMCLOaIrFDwFfH2hbLlGRrc3viQIOgOUZ49cDKkDbxmHsiWkIFnsntEFDFaPc3t+dmBm8+2A1JY1rU7fzBT/tIIG4/xPKE5uM7Q83b97NZjum9PiRMW17Os+kMtjCPdNBT11bm0YHEGO9IuX1WCx91/kWxuVJxRLdBJ7J2/xAeVelnfJsJhBX6/or8FbQErz3tCrlCfrWVRwZUCAwEAAaOCAqcwggKjMB8GA1UdIwQYMBaAFJ7MTbgwg/Rmw2KqNo/HDB8QaSWcMA4GA1UdDwEB/wQEAwIF4DBsBgNVHSAEZTBjMGEGBmBMAQIBOjBXMFUGCCsGAQUFBwIBFklodHRwOi8vcmVwb3NpdG9yaW8uYWNkb2NjbG91ZC5jb20uYnIvYWMtZG9jY2xvdWRyZmIvZHBjLWFjZG9jY2xvdWRyZmIucGRmMIG0BgNVHR8EgawwgakwUqBQoE6GTGh0dHA6Ly9yZXBvc2l0b3Jpby5hY2RvY2Nsb3VkLmNvbS5ici9hYy1kb2NjbG91ZHJmYi9sY3ItYWMtZG9jY2xvdWRyZmJ2NS5jcmwwU6BRoE+GTWh0dHA6Ly9yZXBvc2l0b3JpbzIuYWNkb2NjbG91ZC5jb20uYnIvYWMtZG9jY2xvdWRyZmIvbGNyLWFjLWRvY2Nsb3VkcmZidjUuY3JsMGQGCCsGAQUFBwEBBFgwVjBUBggrBgEFBQcwAoZIaHR0cDovL3JlcG9zaXRvcmlvLmFjZG9jY2xvdWQuY29tLmJyL2FjLWRvY2Nsb3VkcmZiL2FjLWRvY2Nsb3VkcmZidjUucDdiMIG6BgNVHREEgbIwga+BGEFORFJBREVFUEVJU0BIT1RNQUlMLkNPTaAlBgVgTAEDAqAcExpKT1NFIE1BUklBIEdPRVJTQ0ggQU5EUkFERaAZBgVgTAEDA6AQEw4yMzA5NjAwNDAwMDExMKA4BgVgTAEDBKAvEy0yNzA1MTk2NTI2MzAxMzkzMzY4MDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDCgFwYFYEwBAwegDhMMMDAwMDAwMDAwMDAwMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDAJBgNVHRMEAjAAMA0GCSqGSIb3DQEBCwUAA4ICAQAQa1FxowF5gAXc4S6nUPkvW4EfV5vP4xL93CDWb+oujx/62bU0F45PxbY0/LfCPAXC2gga13e56YEP6WuhiGncfWXeDL6kxRUpUpJdVhLIUDi9McIeceww7afOZ/hnCgUMwsRRwAQvgKffTEstyKABstPi2l10XVO/D9XZlYy8eoIBu32Cl60Ri9CdpmAz0ZFL8MgwfZoTrXHFrsL5262PwFDpqkFqDFhlFdWrpPlCDdUJ6e5RL6Y106sTqCuzzxCeWi6n1nOTZr4vxZ9V+wNi9xpKEyuPuj4Zz/1fSgxq+AIq1luCtDWhfhGLNADefavM7YQPimY3ZW1wx2EZ+RcTv78fc7hYkoTEk+6dTGwHeJtKjdCnBVphZNSSIV/2FFVMiluMyll1UvGkWdc8ZZ7ybJDYCYd6w3CKr/cJVUG6zeGauHRbMSqO3FGlCkSA26fY1QEeBUoSXKkm9PcsJpFtibsKjb2mmFktPDw22EJBny7mehe50te6M0Amxr/jbNkwXCoc5lvfttKt6xcZ8/zoCRYBTYPm3UIJOeokNn/TMTnZ2E7wjG+UFuxoB+7zoTyAVQJYOSHPljPt0gC5p8n9qPWGuH11RJnTP0VI0oNSLJM2Ae1Ri9RirfvSyY8S6kmAuoGbCE5QIpqkvmmsJ2i+WGj8HRnmV63/0TNoUF8+2g==</X509Certificate>
</X509Data>
</KeyInfo>
</Signature>
</NFe>
<protNFe versao="4.00">
<infProt>
<tpAmb>1</tpAmb>
<verAplic>AM4.00</verAplic>
<chNFe>13240523096004000110550010000064541000037091</chNFe>
<dhRecbto>2024-05-20T09:04:35-04:00</dhRecbto>
<nProt>113242798881002</nProt>
<digVal>RvOB4QK8F25l1Yk0pPXSDs+AhYE=</digVal>
<cStat>100</cStat>
<xMotivo>Autorizado o uso da NF-e</xMotivo>
</infProt>
</protNFe>
</nfeProc>