update ItemNFEProduto
set NaturezaBCPisCofins = (select cfop.NaturezaBCCreditoPisCofins from CFOp where cfop.AutoId = ItemNFEProduto.CFOPItem)
where NaturezaBCPisCofins is null and ValorPIS > 0

update ItemNFEServico
set NaturezaBCPisCofins = (select cfop.NaturezaBCCreditoPisCofins from CFOp where cfop.AutoId = ItemNFEServico.CFOP)
where NaturezaBCPisCofins is null and ValorPIS > 0

update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1102'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1113'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1117'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1118'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1121'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1251'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1403'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='1652'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2102'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2113'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2117'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2118'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2121'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2251'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2403'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='2652'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='3102'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='3251'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='01') where codigo='3652'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1101'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1111'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1116'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1120'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1122'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1126'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1128'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1401'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1407'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1556'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1651'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='1653'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2101'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2111'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2116'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2120'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2122'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2126'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2128'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2401'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2407'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2556'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2651'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='2653'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='3101'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='3126'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='3128'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='3556'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='3651'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='02') where codigo='3653'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='1124'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='1125'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='1302'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='2302'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='1933'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='2124'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='2125'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='03') where codigo='2933'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='1252'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='1253'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='1254'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='1255'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='1256'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='1257'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='2252'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='2253'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='2254'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='2255'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='2256'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='04') where codigo='2257'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1352'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1353'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1354'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1355'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1356'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1360'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='1932'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='2352'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='2353'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='2354'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='2355'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='2356'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='2932'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='3352'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='3353'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='07') where codigo='3356'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1201'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1202'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1203'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1204'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1410'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1411'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1660'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1661'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='1662'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2201'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2202'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2410'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2411'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2660'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2661'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='12') where codigo='2662'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='1922'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='2922'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='1351'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='2351'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='3351'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='1949'
update cfop set NaturezaBCCreditoPisCofins=(select autoid from NaturezaBaseCalculoCreditoPISCOFINS where codigo='13') where codigo='2949'