14_08_2019_16_47_50-UPDATE OS SET  CALCDIM = 1 ,  TOTBCALCICMS = 0 , TOTBCALCSUBST = 0 ,  TOTICMSSUBST =  0 , TOTVLRICMS = 0 , TOTNF = ( 93.24 - 0 + 0 ), VLRPIS = 0.61, VLRCOFINS = 2.8, TOTPRODNF = 93.24, TOTALIPI = 0,  vTotTrib = 25.1375, vlricmsdeson = 0, ISSUFRAMA = 0, TOTAL = ( 93.24 - 0 + 0 + 0 ),  DESCSUFRAMA = 0,
VLRICMSUFDEST = 0,
VLRICMSUFREMET = 0,
VLRFCP = 0,
VFCP = 0,
DESCONTONF = 0
WHERE OS = 286

14_08_2019_16_47_50-UPDATE OSITENSPRO SET
 BcalcICMS = 0 ,
 BcalcSubst = 0,
 AliqIcms = 0,
 vlrSubst = 0,
 vlrIcms = 0, 
 codCfop = 4,
 basepis = 93.24,
 basecofins = 93.24,
 baseipi = 0,
 vlripi = 0,
 aliqPis = 0.65,
 aliqCofins = 3,
 vlrPis = 0.61,
 vlrCofins = 2.8,
 codcst = 9,
 codcsosn = 1,
 aliqst = 0,
 totprodfrete = 93.24,
 CSTPIS = '01',
 CSTCOFINS = '01',
 CODCALC = 29,
 CSTIPI = '53',
 IPI = 0,
 vTotTrib = 25.137504,
 PCTDIFERIMENTO = 0,
 VLRICMSOP = 0,
 VLRICMSDIFERIDO = 0,
 PREDBC = 0,
 vlricmsdeson = 0,
 DESCSUFRAMA = 0,
 vBCALCICMSUFDEST = 0,
 ALIQICMSUFDest = 0,
 ALIQICMSInter = 0,
 ALIQICMSInterPart = 0,
 VLRICMSUFDest = 0,
 VLRICMSUFRemet = 0,
 VLRCFPUFDEST = 0,
 ALIQCFPUFDEST = 0,
 VFCP = 0,
 PFCP = 0,
 VBCFCP = 0,
 DESCONTONF = 0,
 pST = 18
WHERE CODOS = 2182 AND NUMITEM = 1  

