通過SQL腳本反啟用用友U8+模塊（用友U8+反啟用模塊SQL腳本語句）

[重要通告]如您遇疑難雜癥,本站支持知識付費業(yè)務(wù),掃右邊二維碼加博主微信,可節(jié)省您寶貴時間哦!

這篇文章沒啥可值得介紹的，主要用下面的SQL語句反啟用用友U8+模塊；操作之前一定要做好備份，好有后悔的余地！

--固定資產(chǎn)模塊反啟用：
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');

--應(yīng)收模塊反啟用：
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');

--應(yīng)付模塊反啟用：
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質(zhì)量管理模塊反啟用
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'

根據(jù)自己的需要來進行操作即可！用友U8+反啟用模塊SQL語句

問題未解決？付費解決問題加Q或微信 2589053300 (即Q號又微信號)右上方掃一掃可加博主微信

所寫所說，是心之所感，思之所悟，行之所得；文當(dāng)無敷衍，落筆求簡潔。 以所舍，求所獲；有所依，方所成！