您好,欢迎光临青岛用友软件销售公司网站! 企业邮箱:lupeng@yonyou-qdypy.com

百科问答

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

  • 作者:网络
  • 发布时间:2019-10-14 05:34:32
  • 点击:309
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