SQL

/* SELECT *
  FROM siscop.eventoslancadosconta
 WHERE exercicio=2019 and entidade=1 and conta like '21111' ;

update siscop.eventoslancadosconta
   set idcontacorrente=4634
 WHERE exercicio=2019 and entidade=1 and conta like '211410106' ; ;


 select * from siscop.tipocontacorrente ; */
/*
SELECT * FROM SISCOP.plano
 WHERE entidade=1 and exercicio=2019 and
       conta in ('1132101','1132102','1132103','1132104','1132105','1132106','1132107','1132108','1132109',
                 '1132111'); */

UPDATE SISCOP.plano
   SET idtipocontacorrente=1
 WHERE exercicio=2019 and
       conta in ('1132101','1132102','1132103','1132104','1132105','1132106','1132107','1132108','1132109',
                 '1132111','1132113','1132114','1132199','1132201','1132204','1132205','1132206','1132210',
                 '1132211','1132213','1132214','1132299','1157101','121210201','121210202','121210203',
                 '121210204','121210205','121210206','121210207','121210208','121210209','121210210',
                 '121210211','121210213','121210214','12121029901','211110104','2112101','2113101',
                 '211410103','211410104','211410402','211410404','2114109','21142040101','2114298',
                 '2132101','2132102','2141101','2141102','2141109','2141110','214111101','2141199',
                 '2141201','2141202','2141209','2141210','2141211','2141299','2141301','2141302','2141309',
                 '2141310','2141311','2141399','2141499','2141599','2142102','2142105','2142106','2142107',
                 '2142108','2142199','2142201','2142201','2142202','2142205','2142206','2142201','2142206',
                 '2142207','2142208','2142299','2143101','2143102','2143106','2143107','2143108','2143199',
                 '2143201','2143202','2143207','2143208','2143299','2150399','2150499','2150599','2182101',
                 '2183101','2184101','2184102','2184196','2184197','2184198','2185102','218910102','218910103',
                 '218910104','218914201','218923701','218929801','2211101','2213101','2282101','2283101','2283101',
                 '218923702','2283102','228910101','228910102','228910103','228910104','228910104','228910301',
                 '228910302','228910501','228910502','228910701','228911101','228911102','228919901','228919902',
                 '228910702','211110101','211110102','211110103','211110201','211410101','211410401','2131101',
                 '218910101','2189102','2189103');


UPDATE SISCOP.plano
   SET idtipocontacorrente=14
 WHERE exercicio=2019 and
       conta in ('522110102','522110201','522110209','522120101','522120102','522120103','522120201','522120202',
                 '522120203','522120301','522120302','522120303','5221301','5221302','5221303','5221304','5221305',
                 '5221309','5221322','5221323','5221399','5221801','522190101','522190109','522190201','522190209',
                 '522190301','522190309','5221904','5222101','522102','522210301','522220101','522220109','5222102',
                 '522220201','522220209','522220301','5222901','5222902','622120101','6221202','6221299','6221301',
                 '6221302','6221303','6221304','6221305','6221306','6221307','6221399','6222101','6222102',
                 '62210901','622210909','622220101','622220201','622220901','622210901','622220909','62229','62231',
                 '7531','85311','8531201','8531202','8531203','8531204','8531205','8531301','8531302','8531303','8531304',
                 '8531305','8531306','8531307','8531308','8531401','8531402','8531403','8531404','8531405');

UPDATE SISCOP.plano
   SET idtipocontacorrente=13
 WHERE exercicio=2019 and
       conta in ('6221301','6221304','6221303');