日志
用友模块屏蔽sql脚本语句
热度 1 ||
进入查询分析器中，执行下面脚本即可（注意替换修改“账套号”和“会计年度”）。
--屏蔽工资系统
update UFDATA_账套号_会计年度..gl_mend set bflag_WA=0
update UFDATA_账套号_会计年度..Accinformation set cvalue='' where cname='dStartDate' and cSysID='WA'
update UFDATA_账套号_会计年度..Accinformation set cvalue='' where cname='dWAStartDate' and cSysID='WA'
update UFDATA_账套号_会计年度..Accinformation set cvalue='' where cname='dWAFirstDate' and cSysID='WA'
del
--屏蔽工资系统
update UFDATA_账套号_会计年度..gl_mend set bflag_WA=0
update UFDATA_账套号_会计年度..Accinformation set cvalue='' where cname='dStartDate' and cSysID='WA'
update UFDATA_账套号_会计年度..Accinformation set cvalue='' where cname='dWAStartDate' and cSysID='WA'
update UFDATA_账套号_会计年度..Accinformation set cvalue='' where cname='dWAFirstDate' and cSysID='WA'
del
51072502110008