select * from gl_accvouch where iyear=2021 and iperiod=9 and ino_id in (223,70)
select coutsign,* from gl_accvouch where iyear=2021 and iperiod=9 and coutsign is not NULL
select coutsign,* from gl_accvouch where iyear=2021 and iperiod=9 and coutsign = NULL
select coutsysname,* from gl_accvouch where iyear=2021 and iperiod=9 and ino_id in (223,70) and coutsysname is not NULL
select coutsysname,* from gl_accvouch where iyear=2021 and iperiod=7 and ino_id in (283)
select coutsysname,* from gl_accvouch where iyear=2021 and coutsysname is not NULL
select coutsysname,* from gl_accvouch where iyear=2021 and iperiod=9 and ino_id in (223,70) and coutsysname is not NULL
update gl_accvouch set coutsysname=NULL where coutsysname is not NULL
select * from code where iyear=2021 and ccode in (122103,122104)
select cother,* from code where iyear=2021 and ccode in (112201)
update code set cother=NULL where iyear=2021 and ccode in (112201)
update code set cother=NULL where iyear=2021 and ccode in (112201)
select cother,* from code where cother is not NULL
update code set cother=NULL where cother is not NULL