通过SQL脚本反启用用友U8+模块（用友U8+反启用模块SQL脚本语句）

[全站通告] 想快速节省您的时间并可接受付费的朋友，可扫右边二维码加博主微信-非诚勿扰！

这篇文章没啥可值得介绍的，主要用下面的SQL语句反启用用友U8+模块；操作之前一定要做好备份，好有后悔的余地！

--固定资产模块反启用：
update accinformation
set cvalue=''
where csysid='FA' and ctype='ddate';
--可省 and (cid='601'or cid='05'or cid='603'OR CID='602' OR CID='03'OR CID='06')
update gl_mend
set bflag_FA=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'FA');

--工资模块反启用：
update accinformation
set cvalue=''
where csysid='wa' and ctype='ddate';
--可省 and (cid='601'or cid='05'or cid='603')
update gl_mend
set bflag_Wa=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'Wa');

--采购模块反启用：
update accinformation
set cvalue=''
where csysid='PU' and ctype='ddate';
--可省 and (cid='602'or cid='122'or cid='167')
update gl_mend
set bflag_PU=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'PU');

--销售模块反启用：
update accinformation
set cvalue=''
where csysid='SA' and ctype='ddate';
--可省 and (cid='602'or cid='143'or cid='215')
update gl_mend
set bflag_SA=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'SA');

--库存模块反启用：
update accinformation
set cvalue=''
where csysid='st' and ctype='ddate';
--可省 and (cid='602'or cid='143')
update gl_mend
set bflag_st=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'st');

--存货模块反启用：
update accinformation
set cvalue=''
where csysid='IA' and ctype='ddate';
--可省 and (cid='602'or cid='104')
update gl_mend
set bflag_IA=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'IA');

--应收模块反启用：
update accinformation
set cvalue=''
where csysid='AR' and ctype='ddate';
--可省 and (cid='29'or cid='11')
update gl_mend
set bflag_AR=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'AR');

--应付模块反启用：
update accinformation
set cvalue=''
where csysid='AP' and ctype='ddate'
--可省 and (cid='24'or cid='09')
update gl_mend
set bflag_AP=0;
delete ufsystem..ua_account_sub
where (cacc_id='001') and (cSub_Id = 'AP');

--GSP质量管理模块反启用
update accinformation
set cvalue=''
where csysid='GS' and ctype='ddate';
update gl_mend
set bflag_GS=0 ;
delete from ufsystem..ua_account_sub
where cacc_id='001' and csub_id='GS'

根据自己的需要来进行操作即可！用友U8+反启用模块SQL语句

问题未解决？付费解决问题加Q或微信 2589053300 (即Q号又微信号)右上方扫一扫可加博主微信

所写所说，是心之所感，思之所悟，行之所得；文当无敷衍，落笔求简洁。 以所舍，求所获；有所依，方所成！