用友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”)