市南用友U8软件取消供应链模块

发布时间：2024-11-18　

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)

select cother,* from code where cother is not NULL

update code set cother=NULL where cother is not NULL