select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2104 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41230401414955000158550010000021041000009637" versao="4.00"><ide><cUF>41</cUF><cNF>00000963</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2104</nNF><dhEmi>2023-04-19T14:02:42-03:00</dhEmi><dhSaiEnt>2023-04-19T14:02:42-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>16210531997</CPF><xNome>LETICIA DE QUEIROZ CREMA</xNome><enderDest><xLgr>RUA BARAO DO CERRO AZUL</xLgr><nro>2828</nro><xBairro>BOM JESUS</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83025140</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>50</cProd><cEAN>SEM GTIN</cEAN><xProd>PRODUTO TESTE</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>25.5000</qCom><vUnCom>3.8100000000</vUnCom><vProd>97.16</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>25.5000</qTrib><vUnTrib>3.8100000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>97.16</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>97.16</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>97.16</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2105 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41230701414955000158550010000021051000009643" versao="4.00"><ide><cUF>41</cUF><cNF>00000964</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2105</nNF><dhEmi>2023-07-03T18:03:49-03:00</dhEmi><dhSaiEnt>2023-07-03T18:03:49-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>3</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>PRODUTOS DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2108 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2108 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2107 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2107 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2108 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2109 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240101414955000158550010000021091000009685" versao="4.00"><ide><cUF>41</cUF><cNF>00000968</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2109</nNF><dhEmi>2024-01-18T12:49:25-03:00</dhEmi><dhSaiEnt>2024-01-18T12:49:25-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>5</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>910</cProd><cEAN>SEM GTIN</cEAN><xProd>CAFE EXPRESSO</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>KG</uCom><qCom>1.0000</qCom><vUnCom>6.0000000000</vUnCom><vProd>6.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>KG</uTrib><qTrib>1.0000</qTrib><vUnTrib>6.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>6.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>6.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>6.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2110 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240101414955000158550010000021101000009694" versao="4.00"><ide><cUF>41</cUF><cNF>00000969</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2110</nNF><dhEmi>2024-01-19T-03:00</dhEmi><dhSaiEnt>2024-01-19T-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>4</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><det nItem="1"><prod><cProd>910</cProd><cEAN>SEM GTIN</cEAN><xProd>CAFE EXPRESSO</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>KG</uCom><qCom>1.0000</qCom><vUnCom>6.0000000000</vUnCom><vProd>6.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>KG</uTrib><qTrib>1.0000</qTrib><vUnTrib>6.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>6.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>6.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>6.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2110 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240101414955000158550010000021101000009694" versao="4.00"><ide><cUF>41</cUF><cNF>00000969</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2110</nNF><dhEmi>2024-01-19T12:51:02-03:00</dhEmi><dhSaiEnt>2024-01-19T12:51:02-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>4</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2111 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240201414955000158550010000021111000009709" versao="4.00"><ide><cUF>41</cUF><cNF>00000970</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2111</nNF><dhEmi>2024-02-21T15:17:39-03:00</dhEmi><dhSaiEnt>2024-02-21T15:17:39-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>9</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2112 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240301414955000158550010000021121000009718" versao="4.00"><ide><cUF>41</cUF><cNF>00000971</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2112</nNF><dhEmi>2024-03-01T10:44:25-03:00</dhEmi><dhSaiEnt>2024-03-01T10:44:25-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>8</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>72433295000109</CNPJ><xNome>KL RESTAURANTE LTDA</xNome><enderDest><xLgr>RUA HARRY FEEKEN</xLgr><nro>1141</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040000</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9068434553</IE></dest><det nItem="1"><prod><cProd>88260</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA THERMICA SOLUX SERIE 3310821173A0327</xProd><NCM>84433299</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>650.0000000000</vUnCom><vProd>650.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>650.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>650.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>650.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>650.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2113 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240301414955000158550010000021131000009723" versao="4.00"><ide><cUF>41</cUF><cNF>00000972</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2113</nNF><dhEmi>2024-03-01T12:51:02-03:00</dhEmi><dhSaiEnt>2024-03-01T12:51:02-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>3</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>51784180000180</CNPJ><xNome>KL 4 LTDA</xNome><enderDest><xLgr>RUA DOUTOR MURICI</xLgr><nro>4000</nro><xBairro>COSTEIRA</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83015290</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9102097286</IE></dest><det nItem="1"><prod><cProd>88260</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA THERMICA SOLUX SERIE 3310821173A0327</xProd><NCM>84433299</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>650.0000000000</vUnCom><vProd>650.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>650.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>650.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>650.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>650.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2114 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240301414955000158550010000021141000009739" versao="4.00"><ide><cUF>41</cUF><cNF>00000973</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2114</nNF><dhEmi>2024-03-18T16:09:30-03:00</dhEmi><dhSaiEnt>2024-03-18T16:09:30-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>9</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2115 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240301414955000158550010000021151000009744" versao="4.00"><ide><cUF>41</cUF><cNF>00000974</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2115</nNF><dhEmi>2024-03-18T16:13:41-03:00</dhEmi><dhSaiEnt>2024-03-18T16:13:41-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>4</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>2.0000000000</vUnCom><vProd>2.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>2.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>2.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>2.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>2.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2116 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240301414955000158550010000021161000009750" versao="4.00"><ide><cUF>41</cUF><cNF>00000975</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2116</nNF><dhEmi>2024-03-18T17:09:22-03:00</dhEmi><dhSaiEnt>2024-03-18T17:09:22-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>0</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2116 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240301414955000158550010000021161000009750" versao="4.00"><ide><cUF>41</cUF><cNF>00000975</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2116</nNF><dhEmi>2024-03-18T17:09:22-03:00</dhEmi><dhSaiEnt>2024-03-18T17:09:22-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>0</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>JANO CREMA</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2118 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240701414955000158550010000021181000009775" versao="4.00"><ide><cUF>41</cUF><cNF>00000977</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2118</nNF><dhEmi>2024-07-24T16:58:46-03:00</dhEmi><dhSaiEnt>2024-07-24T16:58:46-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>5</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>NOTA FISCAL EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2118 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240701414955000158550010000021181000009775" versao="4.00"><ide><cUF>41</cUF><cNF>00000977</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2118</nNF><dhEmi>2024-07-29T17:14:59-03:00</dhEmi><dhSaiEnt>2024-07-29T17:14:59-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>5</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>NOTA FISCAL EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>1.0000000000</vUnCom><vProd>1.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>1.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1.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>1.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2119 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41240701414955000158550010000021191000009780" versao="4.00"><ide><cUF>41</cUF><cNF>00000978</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2119</nNF><dhEmi>2024-07-29T17:15:51-03:00</dhEmi><dhSaiEnt>2024-07-29T17:15:51-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>0</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CPF>02163081940</CPF><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>NOTA FISCAL EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>0.0100000000</vUnCom><vProd>0.01</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>0.0100000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>0.01</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>0.01</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>0.01</vPag></detPag><vTroco>0.00</vTroco></pag><infAdic><infCpl>TESTES</infCpl></infAdic><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41241001414955000158550010000021201000009797" versao="4.00"><ide><cUF>41</cUF><cNF>00000979</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2120</nNF><dhEmi>2024-10-07T08:51:34-03:00</dhEmi><dhSaiEnt>2024-10-07T08:51:34-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>49912758000195</CNPJ><xNome>MASTER MEAT COMERCIO DE CARNES LTDA</xNome><enderDest><xLgr>RUA DR. VICENTE MACHADO</xLgr><nro>431</nro><xBairro>CENTRO</xBairro><cMun>4122305</cMun><xMun>RIO NEGRO</xMun><UF>PR</UF><CEP>83880035</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9099302949</IE></dest><det nItem="1"><prod><cProd>800</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA CONCORDIA</xProd><NCM>84439925</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>530.0000000000</vUnCom><vProd>530.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>530.0000000000</vUnTrib><vFrete>20.00</vFrete><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>530.00</vProd><vFrete>20.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>550.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>550.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41241001414955000158550010000021201000009797" versao="4.00"><ide><cUF>41</cUF><cNF>00000979</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2120</nNF><dhEmi>2024-10-07T08:56:17-03:00</dhEmi><dhSaiEnt>2024-10-07T08:56:17-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>49912758000195</CNPJ><xNome>MASTER MEAT COMERCIO DE CARNES LTDA</xNome><enderDest><xLgr>RUA DR. VICENTE MACHADO</xLgr><nro>431</nro><xBairro>CENTRO</xBairro><cMun>4122305</cMun><xMun>RIO NEGRO</xMun><UF>PR</UF><CEP>83880035</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9099302949</IE></dest><det nItem="1"><prod><cProd>800</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA CONCORDIA</xProd><NCM>84439925</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>530.0000000000</vUnCom><vProd>530.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>530.0000000000</vUnTrib><vFrete>20.00</vFrete><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>530.00</vProd><vFrete>20.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>550.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>550.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41241001414955000158550010000021201000009797" versao="4.00"><ide><cUF>41</cUF><cNF>00000979</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2120</nNF><dhEmi>2024-10-07T08:57:27-03:00</dhEmi><dhSaiEnt>2024-10-07T08:57:27-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>49912758000195</CNPJ><xNome>MASTER MEAT COMERCIO DE CARNES LTDA</xNome><enderDest><xLgr>RUA DR. VICENTE MACHADO</xLgr><nro>431</nro><xBairro>CENTRO</xBairro><cMun>4122305</cMun><xMun>RIO NEGRO</xMun><UF>PR</UF><CEP>83880035</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9099302949</IE></dest><det nItem="1"><prod><cProd>800</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA CONCORDIA</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>530.0000000000</vUnCom><vProd>530.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>530.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>530.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>530.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>550.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41241001414955000158550010000021201000009797" versao="4.00"><ide><cUF>41</cUF><cNF>00000979</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2120</nNF><dhEmi>2024-10-07T08:57:27-03:00</dhEmi><dhSaiEnt>2024-10-07T08:57:27-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>49912758000195</CNPJ><xNome>MASTER MEAT COMERCIO DE CARNES LTDA</xNome><enderDest><xLgr>RUA DR. VICENTE MACHADO</xLgr><nro>431</nro><xBairro>CENTRO</xBairro><cMun>4122305</cMun><xMun>RIO NEGRO</xMun><UF>PR</UF><CEP>83880035</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9099302949</IE></dest><det nItem="1"><prod><cProd>800</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA CONCORDIA</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>530.0000000000</vUnCom><vProd>530.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>530.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>530.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>530.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>550.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2120 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41241001414955000158550010000021201000009797" versao="4.00"><ide><cUF>41</cUF><cNF>00000979</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2120</nNF><dhEmi>2024-10-07T08:57:27-03:00</dhEmi><dhSaiEnt>2024-10-07T08:57:27-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>49912758000195</CNPJ><xNome>MASTER MEAT COMERCIO DE CARNES LTDA</xNome><enderDest><xLgr>RUA DR. VICENTE MACHADO</xLgr><nro>431</nro><xBairro>CENTRO</xBairro><cMun>4122305</cMun><xMun>RIO NEGRO</xMun><UF>PR</UF><CEP>83880035</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9099302949</IE></dest><det nItem="1"><prod><cProd>800</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA CONCORDIA</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>550.0000000000</vUnCom><vProd>550.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>550.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>550.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>550.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>550.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2121 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2121 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2121 and np.nf_serie=1teste3 
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2121 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021211000009801" versao="4.00"><ide><cUF>41</cUF><cNF>00000980</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2121</nNF><dhEmi>2025-04-04T10:22:31-03:00</dhEmi><dhSaiEnt>2025-04-04T10:22:31-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</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>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>72433295000109</CNPJ><xNome>KL RESTAURANTE LTDA</xNome><enderDest><xLgr>RUA HARRY FEEKEN</xLgr><nro>1141</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040000</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9068434553</IE></dest><det nItem="1"><prod><cProd>1</cProd><cEAN>SEM GTIN</cEAN><xProd>DIVERSOS</xProd><NCM>00000000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>0.0100000000</vUnCom><vProd>0.01</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>0.0100000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.0000</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>0.01</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>0.01</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>0.01</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T10:34:13-03:00</dhEmi><dhSaiEnt>2025-04-04T10:34:13-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><dVenc>2025-04-09</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><dVenc>2025-05-09</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T10:34:13-03:00</dhEmi><dhSaiEnt>2025-04-04T10:34:13-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><dVenc>2025-04-09</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><dVenc>2025-05-09</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T10:34:13-03:00</dhEmi><dhSaiEnt>2025-04-04T10:34:13-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><dVenc>2025-04-09</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><dVenc>2025-05-09</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T11:46:10-03:00</dhEmi><dhSaiEnt>2025-04-04T11:46:10-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-09</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-09</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T11:46:10-03:00</dhEmi><dhSaiEnt>2025-04-04T11:46:10-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>1</nDup><dVenc>2025-04-09</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>2</nDup><dVenc>2025-05-09</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T13:04:09-03:00</dhEmi><dhSaiEnt>2025-04-04T13:04:09-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-07</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-07</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T13:04:09-03:00</dhEmi><dhSaiEnt>2025-04-04T13:04:09-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-07</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-07</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T13:04:09-03:00</dhEmi><dhSaiEnt>2025-04-04T13:04:09-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-07</dVenc><vDup>450.00</vDup></dup><fat><nFat>2122</nFat><vOrig>900.00</vOrig><vLiq>900.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-07</dVenc><vDup>450.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2122 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021221000009817" versao="4.00"><ide><cUF>41</cUF><cNF>00000981</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2122</nNF><dhEmi>2025-04-04T13:04:09-03:00</dhEmi><dhSaiEnt>2025-04-04T13:04:09-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>53528009000136</CNPJ><xNome>STAR GULA</xNome><enderDest><xLgr>AVENIDA IRAI</xLgr><nro>0</nro><xBairro>WEISSOPOLIS</xBairro><cMun>4119152</cMun><xMun>PINHAIS</xMun><UF>PR</UF><CEP>83321002</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9106750529</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>520.0000000000</vUnCom><vProd>520.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>520.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><det nItem="2"><prod><cProd>38008</cProd><cEAN>SEM GTIN</cEAN><xProd>LEITOR ELGIN IMAGER E1250 1D E 2D COM PEDESTAL</xProd><NCM>84719012</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>380.0000000000</vUnCom><vProd>380.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>380.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>900.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>900.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>900.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2123 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021231000009822" versao="4.00"><ide><cUF>41</cUF><cNF>00000982</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2123</nNF><dhEmi>2025-04-08T11:13:35-03:00</dhEmi><dhSaiEnt>2025-04-08T11:13:35-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>05932142000100</CNPJ><xNome>MERCEARIA REGIMAR LTDA</xNome><enderDest><xLgr>RUA CIDADE JARDIM OLINDA</xLgr><nro>321</nro><xBairro>AUGUSTA</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>81265030</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9029119870</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>2.0000</qCom><vUnCom>555.0000000000</vUnCom><vProd>1110.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>2.0000</qTrib><vUnTrib>555.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1110.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>1110.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-06-10</dVenc><vDup>370.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1110.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2123 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021231000009822" versao="4.00"><ide><cUF>41</cUF><cNF>00000982</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2123</nNF><dhEmi>2025-04-08T11:13:35-03:00</dhEmi><dhSaiEnt>2025-04-08T11:13:35-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>05932142000100</CNPJ><xNome>MERCEARIA REGIMAR LTDA</xNome><enderDest><xLgr>RUA CIDADE JARDIM OLINDA</xLgr><nro>321</nro><xBairro>AUGUSTA</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>81265030</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9029119870</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>2.0000</qCom><vUnCom>555.0000000000</vUnCom><vProd>1110.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>2.0000</qTrib><vUnTrib>555.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1110.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>1110.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-06-10</dVenc><vDup>370.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1110.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2123 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021231000009822" versao="4.00"><ide><cUF>41</cUF><cNF>00000982</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2123</nNF><dhEmi>2025-04-08T11:13:35-03:00</dhEmi><dhSaiEnt>2025-04-08T11:13:35-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>05932142000100</CNPJ><xNome>MERCEARIA REGIMAR LTDA</xNome><enderDest><xLgr>RUA CIDADE JARDIM OLINDA</xLgr><nro>321</nro><xBairro>AUGUSTA</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>81265030</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9029119870</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>2.0000</qCom><vUnCom>555.0000000000</vUnCom><vProd>1110.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>2.0000</qTrib><vUnTrib>555.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1110.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>1110.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>003</nDup><dVenc>2025-06-10</dVenc><vDup>370.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1110.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2123 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021231000009822" versao="4.00"><ide><cUF>41</cUF><cNF>00000982</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2123</nNF><dhEmi>2025-04-08T11:13:35-03:00</dhEmi><dhSaiEnt>2025-04-08T11:13:35-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>05932142000100</CNPJ><xNome>MERCEARIA REGIMAR LTDA</xNome><enderDest><xLgr>RUA CIDADE JARDIM OLINDA</xLgr><nro>321</nro><xBairro>AUGUSTA</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>81265030</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9029119870</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>2.0000</qCom><vUnCom>555.0000000000</vUnCom><vProd>1110.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>2.0000</qTrib><vUnTrib>555.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1110.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>1110.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>002</nDup><dVenc>2025-05-10</dVenc><vDup>370.00</vDup></dup><fat><nFat>2123</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>003</nDup><dVenc>2025-06-10</dVenc><vDup>370.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1110.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2123 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021231000009822" versao="4.00"><ide><cUF>41</cUF><cNF>00000982</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2123</nNF><dhEmi>2025-04-08T11:13:35-03:00</dhEmi><dhSaiEnt>2025-04-08T11:13:35-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>05932142000100</CNPJ><xNome>MERCEARIA REGIMAR LTDA</xNome><enderDest><xLgr>RUA CIDADE JARDIM OLINDA</xLgr><nro>321</nro><xBairro>AUGUSTA</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>81265030</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9029119870</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>2.0000</qCom><vUnCom>555.0000000000</vUnCom><vProd>1110.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>2.0000</qTrib><vUnTrib>555.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1110.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>1110.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1110.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2124 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41250401414955000158550010000021241000009838" versao="4.00"><ide><cUF>41</cUF><cNF>00000983</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2124</nNF><dhEmi>2025-04-08T13:43:59-03:00</dhEmi><dhSaiEnt>2025-04-08T13:43:59-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>8</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>05932142000100</CNPJ><xNome>MERCEARIA REGIMAR LTDA</xNome><enderDest><xLgr>RUA CIDADE JARDIM OLINDA</xLgr><nro>321</nro><xBairro>AUGUSTA</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>81265030</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9029119870</IE></dest><det nItem="1"><prod><cProd>27819</cProd><cEAN>SEM GTIN</cEAN><xProd>IMPRESSORA NAO FISCAL TERMICA DE CUPOM PCFORT XP E200M USB E ETHERNET</xProd><NCM>84433239</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>2.0000</qCom><vUnCom>555.0000000000</vUnCom><vProd>1110.00</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>UN</uTrib><qTrib>2.0000</qTrib><vUnTrib>555.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>0</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISOutr><CST>99</CST><vBC>0.00</vBC><pPIS>0.0000</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>99</CST><vBC>0.00</vBC><pCOFINS>0.0000</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>1110.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>1110.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><fat><nFat>2124</nFat><vOrig>1110.00</vOrig><vLiq>1110.00</vLiq></fat><dup><nDup>001</nDup><dVenc>2025-04-10</dVenc><vDup>370.00</vDup></dup><dup><nDup>002</nDup><dVenc>2025-05-10</dVenc><vDup>370.00</vDup></dup><dup><nDup>003</nDup><dVenc>2025-06-10</dVenc><vDup>370.00</vDup></dup></cobr><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1110.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2150 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41251001414955000158550010000021501000010133" versao="4.00"><ide><cUF>41</cUF><cNF>00001013</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2150</nNF><dhEmi>2025-10-13T-03:00</dhEmi><dhSaiEnt>2025-10-13T-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>3</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>0.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>0.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
select np.codigo_gtin, np.descricao,np.codigo_ncm,np.cfop,np.unidade,np.quantidade,np.preco_unitario,np.total,np.cst_cson, np.bc_icms,np.aliquota_icms,np.val_icms,np.val_ipi,np.aliquota_ipi,pt.cst_ipi,pt.aliquita_pis,pt.cst_pis, pb.preco_venda-pb.preco_compra as lucro,  pt.aliquota_cofins, pt.cst_cofins from nf_prod np inner join produtos p on np.codigo_gtin=p.codigo_gtin inner join produtos_tb pt on p.codigo_interno=pt.codigo_interno inner join produtos_ib pb on p.codigo_interno=pb.codigo_interno  where np.nf_numero=2150 and np.nf_serie=1teste3 
<?xml version="1.0" encoding="UTF-8"?>
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41251001414955000158550010000021501000010133" versao="4.00"><ide><cUF>41</cUF><cNF>00001013</cNF><natOp>VENDA</natOp><mod>55</mod><serie>1</serie><nNF>2150</nNF><dhEmi>2025-10-13T11:03:08-03:00</dhEmi><dhSaiEnt>2025-10-13T11:03:08-03:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4125506</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>3</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>0</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>01414955000158</CNPJ><xNome>JANO CREMA ME</xNome><enderEmit><xLgr>RUA RENATO LEANDRO DE SOUZA</xLgr><nro>436</nro><xBairro>BONECA DO IGUACU</xBairro><cMun>4125506</cMun><xMun>SAO JOSE DOS PINHAIS</xMun><UF>PR</UF><CEP>83040346</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderEmit><IE>9074114196</IE><CRT>1</CRT></emit><dest><CNPJ>49912758000195</CNPJ><xNome>MASTER MEAT COMERCIO DE CARNES LTDA</xNome><enderDest><xLgr>RUA DR. VICENTE MACHADO</xLgr><nro>431</nro><xBairro>CENTRO</xBairro><cMun>4122305</cMun><xMun>RIO NEGRO</xMun><UF>PR</UF><CEP>83880035</CEP><cPais>1058</cPais><xPais>BRASIL</xPais></enderDest><indIEDest>1</indIEDest><IE>9099302949</IE></dest><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</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>0.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>0.00</vNF></ICMSTot></total><transp><modFrete>9</modFrete></transp><pag><detPag><indPag>0</indPag><tPag>01</tPag><vPag>1.00</vPag></detPag><vTroco>0.00</vTroco></pag><infRespTec><CNPJ>01414955000158</CNPJ><xContato>JANO CREMA</xContato><email>jano@gutty.com.br</email><fone>41995075567</fone></infRespTec></infNFe></NFe>
