通过后台数据库反启用用友erp各模块
本文来源 : 洪慧 发布时间:2012年11月15日 阅读:次
通过后台数据库反启用用友erp各模块
(一)固定资产模块反启用:
* accinformation set cvalue=**where csysid=*FA* * ctype=*ddate*
* gl_mend set bflag_FA=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *FA*)
(二)工资模块反启用:
* accinformation set cvalue=**where csysid=*wa* * ctype=*ddate*
* gl_mend set bflag_Wa=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *Wa*)
(三)采购模块反启用:
* accinformation set cvalue=**where csysid=*PU* * ctype=*ddate*
* gl_mend set bflag_PU=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *PU*)
(四)销售模块反启用:
* accinformation set cvalue=**where csysid=*SA* * ctype=*ddate*
* gl_mend set bflag_SA=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *SA*)
(五)库存模块反启用:
* accinformation set cvalue=**where csysid=*st* * ctype=*ddate*
* gl_mend set bflag_st=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *st*)
(六)存货模块反启用:
* accinformation set cvalue=**where csysid=*IA* * ctype=*ddate*
* gl_mend set bflag_IA=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *IA*)
(七)应收模块反启用:
* accinformation set cvalue=**where csysid=*AR* * ctype=*ddate*
* gl_mend set bflag_AR=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *AR*)
* accinformation set cvalue=**where csysid=*AP* * ctype=*ddate*
* gl_mend set bflag_AP=0
* ua_ac*_sub where (cacc_id=*001*) * (cSub_Id = *AP*)