博主 用友U8 通过后台数据库反启用各模块，数据库语句反启用。
[全站通告] 想快速节省您的时间并可接受付费的朋友，可扫右边二维码加博主微信-非诚勿扰！
用友U8 通过后台数据库反启用各模块，数据库语句反启用。
注意：操作前一定要备份数据， 执行语句时不要选错 数据库了。
通过后台数据库反启用用友erp各模块
（一）固定资产模块反启用：
updateaccinformation 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″)
updategl_mend set bflag_FA=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “FA”)
（二）工资模块反启用：
updateaccinformation set cvalue=”” where csysid=”wa” and ctype=”ddate”
可省 and (cid=”601″or cid=”05″or cid=”603″)
updategl_mend set bflag_Wa=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “Wa”)
（三）采购模块反启用：
updateaccinformation set cvalue=”” where csysid=”PU” and ctype=”ddate”
可省 and (cid=”602″or cid=”122″or cid=”167″)
updategl_mend set bflag_PU=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “PU”)
（四）销售模块反启用：
updateaccinformation set cvalue=”” where csysid=”SA” and ctype=”ddate”
可省 and (cid=”602″or cid=”143″or cid=”215″)
updategl_mend set bflag_SA=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “SA”)
（五）库存模块反启用：
updateaccinformation set cvalue=”” where csysid=”st” and ctype=”ddate”
可省 and (cid=”602″or cid=”143″)
updategl_mend set bflag_st=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “st”)
（六）存货模块反启用：
updateaccinformation set cvalue=””
where csysid=”IA” and ctype=”ddate”
可省 and (cid=”602″or cid=”104″)
updategl_mend set bflag_IA=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “IA”)
（七）应收模块反启用：
updateaccinformation set cvalue=””
where csysid=”AR” and ctype=”ddate”
可省 and (cid=”29″or cid=”11″)
updategl_mend set bflag_AR=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “AR”)
（八）应付模块反启用：
updateaccinformation set cvalue=””
where csysid=”AP” and ctype=”ddate”
可省 and (cid=”24″or cid=”09″)
updategl_mend set bflag_AP=0
deleteua_account_sub where (cacc_id=”001″) and (cSub_Id = “AP”)
