您好,欢迎光临青岛用友软件销售公司网站!青岛友鹏源信息科技有限公司

关于我们 产品中心

欢迎来电咨询

18605320425

快速导航

全国服务热线

0532-66730821

客户至上、诚意为先

百科问答

当前位置:首页>>新闻中心>>百科问答

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

2019-10-14 05:34:32 已有142人浏览
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