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

分享到:

2021-09-26 14:27:36

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
 
 
声明:此篇为用友服务中心文章,转载请标明出处链接:
  • 相关文章
  • 热门下载
  • 数据修复
  • 热门标签
合作伙伴