Gilberto - XML

DECLARE @Dados VARCHAR(MAX) = '
<root>
    <fisNFePedido cd_empfatura="20" nr_fatura="351483" dt_fatura="2019-08-20" nr_nf="22959" cd_serie="200" dt_emissao="2019-08-20" cd_emppedido="20" cd_pedido="20023573" nr_pedidocliente="573677" tp_situacaonf="X" tp_modalidade="4" cd_transport="2166">
        <?xml version="1.0"?>
        <NFe xmlns="http://www.portalfiscal.inf.br/nfe">
            <infNFe versao="4.00" Id="NFe32190810718110001119552000000229591166753606">
                <ide>
                    <cUF>32</cUF>
                    <cNF>16675360</cNF>
                    <natOp>VENDA DE MERCADORIA ADQUIRIDA OU RECEBIDA DE TERCEIROS</natOp>
                    <mod>55</mod>
                    <serie>200</serie>
                    <nNF>22959</nNF>
                    <dhEmi>2019-08-20T12:24:54-03:00</dhEmi>
                    <dhSaiEnt>2019-08-20T12:24:54-03:00</dhSaiEnt>
                    <tpNF>1</tpNF>
                    <idDest>1</idDest>
                    <cMunFG>3205002</cMunFG>
                    <tpImp>1</tpImp>
                    <tpEmis>1</tpEmis>
                    <cDV>6</cDV>
                    <tpAmb>1</tpAmb>
                    <finNFe>1</finNFe>
                    <indFinal>1</indFinal>
                    <indPres>9</indPres>
                    <procEmi>0</procEmi>
                    <verProc>1.3.2</verProc>
                </ide>
                <emit>
                    <CNPJ>10718110001119</CNPJ>
                    <xNome>TNF COMERCIAL E IMPORTADORA LTDA</xNome>
                    <xFant>THE NORTH FACE - ECOMMERCE / ES - SERRA</xFant>
                    <enderEmit>
                        <xLgr>AV AV OITOCENTOS</xLgr>
                        <nro>QUADRA19 M-01 SALA 12</nro>
                        <xBairro>TIMS</xBairro>
                        <cMun>3205002</cMun>
                        <xMun>SERRA</xMun>
                        <UF>ES</UF>
                        <CEP>29161389</CEP>
                        <cPais>1058</cPais>
                        <xPais>BRASIL</xPais>
                        <fone>2721274777</fone>
                    </enderEmit>
                    <IE>083200304</IE>
                    <IEST>808011852117</IEST>
                    <CRT>3</CRT>
                </emit>
                <dest>
                    <CPF>01674139888</CPF>
                    <xNome>VANJA NASCIMENTO</xNome>
                    <enderDest>
                        <xLgr>AV PRESIDENTE JOAO B. M. GOULART</xLgr>
                        <nro>260</nro>
                        <xBairro>PARQUE DAS NACOES</xBairro>
                        <cMun>3549102</cMun>
                        <xMun>SAO JOAO DA BOA VISTA</xMun>
                        <UF>SP</UF>
                        <CEP>13870579</CEP>
                        <cPais>1058</cPais>
                        <xPais>BRASIL</xPais>
                        <fone>5519981335101</fone>
                    </enderDest>
                    <indIEDest>9</indIEDest>
                    <email>vanjabrn@uol.com.br</email>
                </dest>
                <det nItem="1">
                    <prod>
                        <cProd>21623</cProd>
                        <cEAN>191932493630</cEAN>
                        <xProd>COLETE FEMI ADU ACONCAGUA II 3JRN 5MW AZUL G</xProd>
                        <NCM>62029300</NCM>
                        <CFOP>5102</CFOP>
                        <uCom>PC</uCom>
                        <qCom>1.0000</qCom>
                        <vUnCom>639.2000000000</vUnCom>
                        <vProd>639.20</vProd>
                        <cEANTrib>191932493630</cEANTrib>
                        <uTrib>PC</uTrib>
                        <qTrib>1.0000</qTrib>
                        <vUnTrib>639.2000000000</vUnTrib>
                        <vFrete>9.29</vFrete>
                        <indTot>1</indTot>
                    </prod>
                    <imposto>
                        <vTotTrib>432.67</vTotTrib>
                        <ICMS>
                            <ICMS00>
                                <orig>1</orig>
                                <CST>00</CST>
                                <modBC>3</modBC>
                                <vBC>648.49</vBC>
                                <pICMS>12.0000</pICMS>
                                <vICMS>77.82</vICMS>
                            </ICMS00>
                        </ICMS>
                        <IPI>
                            <cEnq>999</cEnq>
                            <IPINT>
                                <CST>53</CST>
                            </IPINT>
                        </IPI>
                        <PIS>
                            <PISAliq>
                                <CST>01</CST>
                                <vBC>648.49</vBC>
                                <pPIS>0.6500</pPIS>
                                <vPIS>4.22</vPIS>
                            </PISAliq>
                        </PIS>
                        <COFINS>
                            <COFINSAliq>
                                <CST>01</CST>
                                <vBC>648.49</vBC>
                                <pCOFINS>3.0000</pCOFINS>
                                <vCOFINS>19.45</vCOFINS>
                            </COFINSAliq>
                        </COFINS>
                    </imposto>
                </det>
                <total>
                    <ICMSTot>
                        <vBC>648.49</vBC>
                        <vICMS>77.82</vICMS>
                        <vICMSDeson>0.00</vICMSDeson>
                        <vFCP>0.00</vFCP>
                        <vBCST>0.00</vBCST>
                        <vST>0.00</vST>
                        <vFCPST>0.00</vFCPST>
                        <vFCPSTRet>0.00</vFCPSTRet>
                        <vProd>639.20</vProd>
                        <vFrete>9.29</vFrete>
                        <vSeg>0.00</vSeg>
                        <vDesc>0.00</vDesc>
                        <vII>0.00</vII>
                        <vIPI>0.00</vIPI>
                        <vIPIDevol>0.00</vIPIDevol>
                        <vPIS>4.22</vPIS>
                        <vCOFINS>19.45</vCOFINS>
                        <vOutro>0.00</vOutro>
                        <vNF>648.49</vNF>
                        <vTotTrib>432.67</vTotTrib>
                    </ICMSTot>
                </total>
                <transp>
                    <modFrete>0</modFrete>
                    <transporta>
                        <CNPJ>73939449002137</CNPJ>
                        <xNome>TEX COURIER S.A.</xNome>
                        <IE>082819580</IE>
                        <xEnder>R HOLDERCIN 1</xEnder>
                        <xMun>SERRA</xMun>
                        <UF>ES</UF>
                    </transporta>
                    <vol>
                        <qVol>1</qVol>
                        <esp>EMBALAGEM</esp>
                        <pesoL>0.351</pesoL>
                        <pesoB>0.351</pesoB>
                    </vol>
                </transp>
                <pag>
                    <detPag>
                        <indPag>1</indPag>
                        <tPag>03</tPag>
                        <vPag>648.49</vPag>
                        <card>
                            <tpIntegra>2</tpIntegra>
                        </card>
                    </detPag>
                </pag>
                <infAdic>
                    <infCpl>PEDIDO 20023573 - VLR APROXIMADO DOS TRIBUTOS: 432,67 - 67,69 %</infCpl>
                </infAdic>
            </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="#NFe32190810718110001119552000000229591166753606">
                        <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>oZw89Eek8pVQzKNJhCPUYdH4PkY=</DigestValue>
                    </Reference>
                </SignedInfo>
                <SignatureValue>5BH/eqGd89AghvrvMTGQDLITfBjtXmdVQB62U9p6kqicnjIjamPiAiKv5HOKwzSyEADBtfResDOxdjdMEgtqsaT4HTgPO+ZQszrEQkD1+YaBHCQoX7ls/GB4bYPipn/t8FwijjllkLguTPfDlRCOedQwelQQZiOSu07i4P1iFnTYVNVMbESgZ+Vb5DxENkR270N6m/4zGVRTXp2BKgNhI6PsbrO/W+X4Ofe+DtNnTw0LuQdeOuZu3JQO6AkHGIXV1s0Rt/a0C/FnteJZKnhPOYdko1LA4c9iRzwHKaTip2splpsXnqnsPJdPlLSyq5ueVClskRM6IdzQBG4fb+Arhw==</SignatureValue>
                <KeyInfo>
                    <X509Data>
                        <X509Certificate>MIIH9TCCBd2gAwIBAgIIPRwmk8OlNUgwDQYJKoZIhvcNAQELBQAwcDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxMjAwBgNVBAsTKUF1dG9yaWRhZGUgQ2VydGlmaWNhZG9yYSBWQUxJRCAtIEFDIFZBTElEMRgwFgYDVQQDEw9BQyBWQUxJRCBCUkFTSUwwHhcNMTgxMDIzMTMwMDUxWhcNMTkxMDIzMTMwMDUxWjCBsTELMAkGA1UEBhMCQlIxCzAJBgNVBAgTAkVTMQ4wDAYDVQQHEwVTRVJSQTETMBEGA1UEChMKSUNQLUJyYXNpbDEYMBYGA1UECxMPQUMgVkFMSUQgQlJBU0lMMRswGQYDVQQLExJQZXNzb2EgSnVyaWRpY2EgQTExDjAMBgNVBAsTBVZBTElEMSkwJwYDVQQDEyBUTkYgQ09NRVJDSUFMIEUgSU1QT1JUQURPUkEgTFREQTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAOg0AKEABjSpghhw7+3VpiioKrWaqVj5zkRm5dPikYV+7zszwEtnvs2Jy9SE4c8GZw6+Igmfh7vo/Ja7VZGYibttaXDmplCevc2WMrOMZCvakkvBNmgIKUEQI6usIbQr/fVaQDMft6N+yIwvaMZpEc9swCmS9xZXiF7ByR1v6J8ckZ3I4qnlibrYoKLi2KWezMKA4wm5zj9EZhf5bPMUxXLEWZrnVWIV9f5bFSbvFPuH1tnOJBXrDUk9FhNvLZr0jeM1TMAm3l2o41Ow3TykTqTaF0SNBLtVCEHPWYKDE+wVwBg1fVjZgAB4GHhkYjsRNB/Vj49igJfuN2daZi7iMBkCAwEAAaOCA08wggNLMIGgBggrBgEFBQcBAQSBkzCBkDBbBggrBgEFBQcwAoZPaHR0cDovL2ljcC1icmFzaWwudmFsaWRjZXJ0aWZpY2Fkb3JhLmNvbS5ici9hYy12YWxpZGJyYXNpbC9hYy12YWxpZGJyYXNpbHYyLnA3YjAxBggrBgEFBQcwAYYlaHR0cDovL29jc3AudmFsaWRjZXJ0aWZpY2Fkb3JhLmNvbS5icjAJBgNVHRMEAjAAMB8GA1UdIwQYMBaAFAXNF43GHxRGjejn0+MMvU0cNhGtMHQGA1UdIARtMGswaQYGYEwBAgEkMF8wXQYIKwYBBQUHAgEWUWh0dHA6Ly9pY3AtYnJhc2lsLnZhbGlkY2VydGlmaWNhZG9yYS5jb20uYnIvYWMtdmFsaWRicmFzaWwvZHBjLWFjLXZhbGlkYnJhc2lsLnBkZjCCARIGA1UdHwSCAQkwggEFMFmgV6BVhlNodHRwOi8vaWNwLWJyYXNpbC52YWxpZGNlcnRpZmljYWRvcmEuY29tLmJyL2FjLXZhbGlkYnJhc2lsL2xjci1hYy12YWxpZGJyYXNpbHYyLmNybDBaoFigVoZUaHR0cDovL2ljcC1icmFzaWwyLnZhbGlkY2VydGlmaWNhZG9yYS5jb20uYnIvYWMtdmFsaWRicmFzaWwvbGNyLWFjLXZhbGlkYnJhc2lsdjIuY3JsMEygSqBIhkZodHRwOi8vcmVwb3NpdG9yaW8uaWNwYnJhc2lsLmdvdi5ici9sY3IvVkFMSUQvbGNyLWFjLXZhbGlkYnJhc2lsdjIuY3JsMA4GA1UdDwEB/wQEAwIF4DAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwgb4GA1UdEQSBtjCBs4EYcmVnaXN0cm9AYXN0ZXNlcnYuY29tLmJyoDgGBWBMAQMEoC8ELTE5MDYxOTUxMTk5OTA3NzQ4MjAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMKApBgVgTAEDAqAgBB5BVUdVU1RPIFNBTFZBRE9SIEdBUkNJQSBFUk5BTkmgGQYFYEwBAwOgEAQOMTA3MTgxMTAwMDAxNDegFwYFYEwBAwegDgQMMDAwMDAwMDAwMDAwMA0GCSqGSIb3DQEBCwUAA4ICAQCQLiSu5i7XR5b2Y94bHslN7yK2w3ZqgGRZlFINh1pE219HmCvgI3iSK390Ag2lIQ1h0EP31zZijQWovkdWbUdMfLgZGqLKVEVBOuAuapNtFSujYpdWZhCIsw/c8ppfHI+AO5exEKFkIF4X4Wc0upFrAM5r7tKQQaFOHGNzu5cpF7XuZIwXxIZiPZzVznfZZfBQIQUYjNNrnFukDZ5QpyZNqEmFDDlo7Qe7GM1Z8wK4+0Q+Vj29AWfeSyZFNs1WyeGXK7PmoZjYO9K+3vRndSuj6Y8eyvxb32k7vUQN0uAJ08rYcuA77Vpcb3Xn5rWcjHwgR68uDbIxvL7m1CQmUgSHvsfYU41YYzFRex4dXqkQZb3sPqGCJ1fJj5enE2xFHaj809TYfGw4HRFgrZVMpWgs1FoaH5LEKNFyEV69THPmsAMxZQIwhJ/dBYyY9Mx3DnYIn+BmsGLnpPfaKib/vMKtz/8CYQCQB3cauHa+ki8o7DAgPEuk9gFS5W8HXXK7NePUhX7JhXgwHSlYQXrL/ijxl9kn55A5OJNoGCldAMO2nTrTRU5YxMOAKMSPc2b0WY9LfCVkFJWzXYCnHb8/fNUCFfuOL2UG34wDu9th+Nflf9sb+RSwJcaCJk3kbVwszK1ZqGtdnuD4vtSJuPjwmvAVRh7Qjpc6LKI3iJVtRiAt1Q==</X509Certificate>
                    </X509Data>
                </KeyInfo>
            </Signature>
        </NFe>
    </fisNFePedido>
    <fisNFePedido cd_empfatura="20" nr_fatura="352065" dt_fatura="2019-08-20" nr_nf="22998" cd_serie="200" dt_emissao="2019-08-20" cd_emppedido="20" cd_pedido="20023573" nr_pedidocliente="573677" tp_situacaonf="E" tp_modalidade="4" cd_transport="2166">
        <?xml version="1.0"?>
        <NFe xmlns="http://www.portalfiscal.inf.br/nfe">
            <infNFe versao="4.00" Id="NFe32190810718110001119552000000229981292739208">
                <ide>
                    <cUF>32</cUF>
                    <cNF>29273920</cNF>
                    <natOp>VENDA DE MERCADORIA ADQUIRIDA OU RECEBIDA DE TERCEIROS, DEST</natOp>
                    <mod>55</mod>
                    <serie>200</serie>
                    <nNF>22998</nNF>
                    <dhEmi>2019-08-20T12:53:38-03:00</dhEmi>
                    <dhSaiEnt>2019-08-20T12:53:38-03:00</dhSaiEnt>
                    <tpNF>1</tpNF>
                    <idDest>2</idDest>
                    <cMunFG>3205002</cMunFG>
                    <tpImp>1</tpImp>
                    <tpEmis>1</tpEmis>
                    <cDV>8</cDV>
                    <tpAmb>1</tpAmb>
                    <finNFe>1</finNFe>
                    <indFinal>1</indFinal>
                    <indPres>9</indPres>
                    <procEmi>0</procEmi>
                    <verProc>1.3.2</verProc>
                </ide>
                <emit>
                    <CNPJ>10718110001119</CNPJ>
                    <xNome>TNF COMERCIAL E IMPORTADORA LTDA</xNome>
                    <xFant>THE NORTH FACE - ECOMMERCE / ES - SERRA</xFant>
                    <enderEmit>
                        <xLgr>AV AV OITOCENTOS</xLgr>
                        <nro>QUADRA19 M-01 SALA 12</nro>
                        <xBairro>TIMS</xBairro>
                        <cMun>3205002</cMun>
                        <xMun>SERRA</xMun>
                        <UF>ES</UF>
                        <CEP>29161389</CEP>
                        <cPais>1058</cPais>
                        <xPais>BRASIL</xPais>
                        <fone>2721274777</fone>
                    </enderEmit>
                    <IE>083200304</IE>
                    <IEST>808011852117</IEST>
                    <CRT>3</CRT>
                </emit>
                <dest>
                    <CPF>01674139888</CPF>
                    <xNome>VANJA NASCIMENTO</xNome>
                    <enderDest>
                        <xLgr>AV PRESIDENTE JOAO B. M. GOULART</xLgr>
                        <nro>260</nro>
                        <xBairro>PARQUE DAS NACOES</xBairro>
                        <cMun>3549102</cMun>
                        <xMun>SAO JOAO DA BOA VISTA</xMun>
                        <UF>SP</UF>
                        <CEP>13870579</CEP>
                        <cPais>1058</cPais>
                        <xPais>BRASIL</xPais>
                        <fone>5519981335101</fone>
                    </enderDest>
                    <indIEDest>9</indIEDest>
                    <email>vanjabrn@uol.com.br</email>
                </dest>
                <det nItem="1">
                    <prod>
                        <cProd>21623</cProd>
                        <cEAN>191932493630</cEAN>
                        <xProd>COLETE FEMI ADU ACONCAGUA II 3JRN 5MW AZUL G</xProd>
                        <NCM>62029300</NCM>
                        <CFOP>6108</CFOP>
                        <uCom>PC</uCom>
                        <qCom>1.0000</qCom>
                        <vUnCom>639.2000000000</vUnCom>
                        <vProd>639.20</vProd>
                        <cEANTrib>191932493630</cEANTrib>
                        <uTrib>PC</uTrib>
                        <qTrib>1.0000</qTrib>
                        <vUnTrib>639.2000000000</vUnTrib>
                        <vFrete>9.29</vFrete>
                        <indTot>1</indTot>
                    </prod>
                    <imposto>
                        <vTotTrib>432.67</vTotTrib>
                        <ICMS>
                            <ICMS00>
                                <orig>1</orig>
                                <CST>00</CST>
                                <modBC>3</modBC>
                                <vBC>648.49</vBC>
                                <pICMS>4.0000</pICMS>
                                <vICMS>25.94</vICMS>
                            </ICMS00>
                        </ICMS>
                        <IPI>
                            <cEnq>999</cEnq>
                            <IPINT>
                                <CST>53</CST>
                            </IPINT>
                        </IPI>
                        <PIS>
                            <PISAliq>
                                <CST>01</CST>
                                <vBC>648.49</vBC>
                                <pPIS>0.6500</pPIS>
                                <vPIS>4.22</vPIS>
                            </PISAliq>
                        </PIS>
                        <COFINS>
                            <COFINSAliq>
                                <CST>01</CST>
                                <vBC>648.49</vBC>
                                <pCOFINS>3.0000</pCOFINS>
                                <vCOFINS>19.45</vCOFINS>
                            </COFINSAliq>
                        </COFINS>
                        <ICMSUFDest>
                            <vBCUFDest>648.49</vBCUFDest>
                            <vBCFCPUFDest>648.49</vBCFCPUFDest>
                            <pFCPUFDest>0.0000</pFCPUFDest>
                            <pICMSUFDest>18.0000</pICMSUFDest>
                            <pICMSInter>4.00</pICMSInter>
                            <pICMSInterPart>100.0000</pICMSInterPart>
                            <vFCPUFDest>0.00</vFCPUFDest>
                            <vICMSUFDest>90.79</vICMSUFDest>
                            <vICMSUFRemet>0.00</vICMSUFRemet>
                        </ICMSUFDest>
                    </imposto>
                </det>
                <total>
                    <ICMSTot>
                        <vBC>648.49</vBC>
                        <vICMS>25.94</vICMS>
                        <vICMSDeson>0.00</vICMSDeson>
                        <vICMSUFDest>90.79</vICMSUFDest>
                        <vFCP>0.00</vFCP>
                        <vBCST>0.00</vBCST>
                        <vST>0.00</vST>
                        <vFCPST>0.00</vFCPST>
                        <vFCPSTRet>0.00</vFCPSTRet>
                        <vProd>639.20</vProd>
                        <vFrete>9.29</vFrete>
                        <vSeg>0.00</vSeg>
                        <vDesc>0.00</vDesc>
                        <vII>0.00</vII>
                        <vIPI>0.00</vIPI>
                        <vIPIDevol>0.00</vIPIDevol>
                        <vPIS>4.22</vPIS>
                        <vCOFINS>19.45</vCOFINS>
                        <vOutro>0.00</vOutro>
                        <vNF>648.49</vNF>
                        <vTotTrib>432.67</vTotTrib>
                    </ICMSTot>
                </total>
                <transp>
                    <modFrete>0</modFrete>
                    <transporta>
                        <CNPJ>73939449002137</CNPJ>
                        <xNome>TEX COURIER S.A.</xNome>
                        <IE>082819580</IE>
                        <xEnder>R HOLDERCIN 1</xEnder>
                        <xMun>SERRA</xMun>
                        <UF>ES</UF>
                    </transporta>
                    <vol>
                        <qVol>1</qVol>
                        <esp>EMBALAGEM</esp>
                        <pesoL>0.351</pesoL>
                        <pesoB>0.351</pesoB>
                    </vol>
                </transp>
                <pag>
                    <detPag>
                        <indPag>1</indPag>
                        <tPag>03</tPag>
                        <vPag>648.49</vPag>
                        <card>
                            <tpIntegra>2</tpIntegra>
                        </card>
                    </detPag>
                </pag>
                <infAdic>
                    <infCpl>PEDIDO 20023573 - VLR APROXIMADO DOS TRIBUTOS: 432,67 - 67,69 % - VLR ICMS UF DESTINO 100% 90,79</infCpl>
                </infAdic>
            </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="#NFe32190810718110001119552000000229981292739208">
                        <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>sZSJC8a27Pz/4Prbab8XIpLOVgM=</DigestValue>
                    </Reference>
                </SignedInfo>
                <SignatureValue>hfKE8sqHzlW051GJXBrh/LEG1rZeWAOPGQsr60codt9Ly2jFws1CUAx6Ff8pHdyRTotYcZ+YMKSWHSiYLCSmZd5F4FwGZQ3tV6w8BTsgTkTumm5LnY2ZAeO8hnOZ9S1vEeQtYefoUhmRcAowEWYlfvPEKS4V9gLfNAnVZPqSynmGibglXkFGk8z9p/1ZpDg61dDCBDcKReMYaqXWGWjkhzXn5+XOlb9AwsCT03olrFVl80Zzj1+ZZ66v4ePUWJeWTykr3kcNac01xgutnsTXe31q51ouoL6hCaXw/mwiKcTmS40+jl7AxZNQIHZ0KzajksoFseH6mvsv8Z49RStllQ==</SignatureValue>
                <KeyInfo>
                    <X509Data>
                        <X509Certificate>MIIH9TCCBd2gAwIBAgIIPRwmk8OlNUgwDQYJKoZIhvcNAQELBQAwcDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxMjAwBgNVBAsTKUF1dG9yaWRhZGUgQ2VydGlmaWNhZG9yYSBWQUxJRCAtIEFDIFZBTElEMRgwFgYDVQQDEw9BQyBWQUxJRCBCUkFTSUwwHhcNMTgxMDIzMTMwMDUxWhcNMTkxMDIzMTMwMDUxWjCBsTELMAkGA1UEBhMCQlIxCzAJBgNVBAgTAkVTMQ4wDAYDVQQHEwVTRVJSQTETMBEGA1UEChMKSUNQLUJyYXNpbDEYMBYGA1UECxMPQUMgVkFMSUQgQlJBU0lMMRswGQYDVQQLExJQZXNzb2EgSnVyaWRpY2EgQTExDjAMBgNVBAsTBVZBTElEMSkwJwYDVQQDEyBUTkYgQ09NRVJDSUFMIEUgSU1QT1JUQURPUkEgTFREQTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAOg0AKEABjSpghhw7+3VpiioKrWaqVj5zkRm5dPikYV+7zszwEtnvs2Jy9SE4c8GZw6+Igmfh7vo/Ja7VZGYibttaXDmplCevc2WMrOMZCvakkvBNmgIKUEQI6usIbQr/fVaQDMft6N+yIwvaMZpEc9swCmS9xZXiF7ByR1v6J8ckZ3I4qnlibrYoKLi2KWezMKA4wm5zj9EZhf5bPMUxXLEWZrnVWIV9f5bFSbvFPuH1tnOJBXrDUk9FhNvLZr0jeM1TMAm3l2o41Ow3TykTqTaF0SNBLtVCEHPWYKDE+wVwBg1fVjZgAB4GHhkYjsRNB/Vj49igJfuN2daZi7iMBkCAwEAAaOCA08wggNLMIGgBggrBgEFBQcBAQSBkzCBkDBbBggrBgEFBQcwAoZPaHR0cDovL2ljcC1icmFzaWwudmFsaWRjZXJ0aWZpY2Fkb3JhLmNvbS5ici9hYy12YWxpZGJyYXNpbC9hYy12YWxpZGJyYXNpbHYyLnA3YjAxBggrBgEFBQcwAYYlaHR0cDovL29jc3AudmFsaWRjZXJ0aWZpY2Fkb3JhLmNvbS5icjAJBgNVHRMEAjAAMB8GA1UdIwQYMBaAFAXNF43GHxRGjejn0+MMvU0cNhGtMHQGA1UdIARtMGswaQYGYEwBAgEkMF8wXQYIKwYBBQUHAgEWUWh0dHA6Ly9pY3AtYnJhc2lsLnZhbGlkY2VydGlmaWNhZG9yYS5jb20uYnIvYWMtdmFsaWRicmFzaWwvZHBjLWFjLXZhbGlkYnJhc2lsLnBkZjCCARIGA1UdHwSCAQkwggEFMFmgV6BVhlNodHRwOi8vaWNwLWJyYXNpbC52YWxpZGNlcnRpZmljYWRvcmEuY29tLmJyL2FjLXZhbGlkYnJhc2lsL2xjci1hYy12YWxpZGJyYXNpbHYyLmNybDBaoFigVoZUaHR0cDovL2ljcC1icmFzaWwyLnZhbGlkY2VydGlmaWNhZG9yYS5jb20uYnIvYWMtdmFsaWRicmFzaWwvbGNyLWFjLXZhbGlkYnJhc2lsdjIuY3JsMEygSqBIhkZodHRwOi8vcmVwb3NpdG9yaW8uaWNwYnJhc2lsLmdvdi5ici9sY3IvVkFMSUQvbGNyLWFjLXZhbGlkYnJhc2lsdjIuY3JsMA4GA1UdDwEB/wQEAwIF4DAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwgb4GA1UdEQSBtjCBs4EYcmVnaXN0cm9AYXN0ZXNlcnYuY29tLmJyoDgGBWBMAQMEoC8ELTE5MDYxOTUxMTk5OTA3NzQ4MjAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMKApBgVgTAEDAqAgBB5BVUdVU1RPIFNBTFZBRE9SIEdBUkNJQSBFUk5BTkmgGQYFYEwBAwOgEAQOMTA3MTgxMTAwMDAxNDegFwYFYEwBAwegDgQMMDAwMDAwMDAwMDAwMA0GCSqGSIb3DQEBCwUAA4ICAQCQLiSu5i7XR5b2Y94bHslN7yK2w3ZqgGRZlFINh1pE219HmCvgI3iSK390Ag2lIQ1h0EP31zZijQWovkdWbUdMfLgZGqLKVEVBOuAuapNtFSujYpdWZhCIsw/c8ppfHI+AO5exEKFkIF4X4Wc0upFrAM5r7tKQQaFOHGNzu5cpF7XuZIwXxIZiPZzVznfZZfBQIQUYjNNrnFukDZ5QpyZNqEmFDDlo7Qe7GM1Z8wK4+0Q+Vj29AWfeSyZFNs1WyeGXK7PmoZjYO9K+3vRndSuj6Y8eyvxb32k7vUQN0uAJ08rYcuA77Vpcb3Xn5rWcjHwgR68uDbIxvL7m1CQmUgSHvsfYU41YYzFRex4dXqkQZb3sPqGCJ1fJj5enE2xFHaj809TYfGw4HRFgrZVMpWgs1FoaH5LEKNFyEV69THPmsAMxZQIwhJ/dBYyY9Mx3DnYIn+BmsGLnpPfaKib/vMKtz/8CYQCQB3cauHa+ki8o7DAgPEuk9gFS5W8HXXK7NePUhX7JhXgwHSlYQXrL/ijxl9kn55A5OJNoGCldAMO2nTrTRU5YxMOAKMSPc2b0WY9LfCVkFJWzXYCnHb8/fNUCFfuOL2UG34wDu9th+Nflf9sb+RSwJcaCJk3kbVwszK1ZqGtdnuD4vtSJuPjwmvAVRh7Qjpc6LKI3iJVtRiAt1Q==</X509Certificate>
                    </X509Data>
                </KeyInfo>
            </Signature>
        </NFe>
    </fisNFePedido>
</root>'


DECLARE @dadosXML XML = REPLACE(REPLACE(@Dados, '<?xml version="1.0"?>', ''), ' xmlns="http://www.portalfiscal.inf.br/nfe"', '')

SELECT
    Nf.linhas.value('@cd_empfatura', 'int') AS cd_empfatura,
    Nf.linhas.value('@nr_fatura', 'int') AS nr_fatura,
    Nf.linhas.value('@nr_nf', 'int') AS nr_nf,
    Nf.linhas.value('@cd_serie', 'int') AS cd_serie,
    Nf.linhas.value('@dt_emissao', 'datetime') AS dt_emissao,
    infNFe.linhas.value('@Id', 'varchar(200)') AS Id
FROM
    @dadosXML.nodes('//fisNFePedido') AS Nf(linhas)
    OUTER APPLY Nf.linhas.nodes('NFe/infNFe') AS infNFe(linhas)