
/*------ ATD 261118 ------*/
UPDATE TABTRANFAT SET RTIPORODADO = 37474, RTIPOCARROCERIA = 37467 
WHERE RTIPORODADO <= 7 AND RTIPOCARROCERIA <= 7
go
delete from opcsistcad where nomeopc = 'Transportadoras' and codsis = 'SIS' and codopc = '5.06'
go
if not exists(select 1 from OPCSISTCAD where codsis = 'SIS' and codopc = '3.29')
insert into OPCSISTCAD(codsis,codopc,nomeopc,ativado,numeroativ,mediauso,numdemeses,usoultmes)
values('SIS','3.29','Gerar MDF-e','S',0,0,0,0)
go