(FAQ)折旧率小数位修改
816次浏览
编辑于2015年03月02日 00:00:00
【问题】: (FAQ)折旧率小数位修改
版本: 7.5
模块: 固定资产
【答复】:
select * from t_bas_paramitem where fkeyid in(select fid from t_bas_param where fnumber='FA_007') and forgunitid=(select fid from t_org_company where fnumber='公司编码') --改为2位 update t_bas_paramitem set FVALUE_L1=2,FVALUE_L2=2,FVALUE_L3=2,FVALUEALIAS_L1=2,FVALUEALIAS_L2=2,FVALUEALIAS_L3=2 where fkeyid in( select fid from t_bas_param where fnumber like 'FA_007' ) and forgunitid=(select fid from t_org_company where fnumber='公司编码')
版本: 7.5
模块: 固定资产
【答复】:
select * from t_bas_paramitem where fkeyid in(select fid from t_bas_param where fnumber='FA_007') and forgunitid=(select fid from t_org_company where fnumber='公司编码') --改为2位 update t_bas_paramitem set FVALUE_L1=2,FVALUE_L2=2,FVALUE_L3=2,FVALUEALIAS_L1=2,FVALUEALIAS_L2=2,FVALUEALIAS_L3=2 where fkeyid in( select fid from t_bas_param where fnumber like 'FA_007' ) and forgunitid=(select fid from t_org_company where fnumber='公司编码')
推荐阅读