K3WISE 15.0,查询固定资产卡片报错
金蝶云社区-mrs_zhang
mrs_zhang
0人赞赏了该文章 1,040次浏览 未经作者许可,禁止转载编辑于2018年05月17日 12:17:59

K3WISE 15.0,查询固定资产报错


跟踪到的语句,手工执行也是报错,有没有大神指导下,哪里出错了,怎么修复
select v.FWorkBookID,v.FAlterID,v.FYear,v.FPeriod,v.FCleared,v.FNew,v.FOtherAlter, v.FDate,v.FAssetID,v.FAssetNumber,v.FAssetName,v.fincometax, v.FDeprPolicyID,v.FPolicyName ,v.FPolicyNumber,v.FAssetDetailID,v.FDeprDetailID,(v.FLifePeriods - bal1.fdeprperiods) as FLifeRemain,v.FAssetAcctName,v.FDeprAcctName ,FWorkCenter=twc.FName,FCostCenter=tcc.FName,space(255) as FAssetDetail,space(255) as FDeprDetail into #TmpCardTable8648 from (select vv.*,bal.forgvalp,bal.fnump,bal.faccumdeprp,i.fincometax,card.FAssetDetailID,card.FDeprDetailID from vw_fa_card vv left join t_fabalance bal on vv.fassetid=bal.fassetid and vv.fyear=bal.fyear and vv.fperiod=bal.fperiod left join t_fabalcard i on bal.Fbalid=i.Fbalid left join t_FACard Card on Card.FAlterID = vv.FAlterID) v left join t_facarditem t1 on v.FAlterID=t1.FAlterID left join vw_fa_expense p on p.FAlterID=v.FAlterID left join (select fdeprperiods,FAssetID from t_fabalance B where FYear=2018 and Fperiod=5) bal1 on bal1.FAssetID = v.FAssetID left join t_WorkCenter twc on twc.FItemID=v.FWorkCenterID left join t_BASE_CostCenter tcc on tcc.FItemID=v.FCostCenterID left join #TempOrderBy151244439359158 newTmp on v.FAlterID=newTmp.FAlterID where FWorkBookID='1' order by v.FAlterID,v.FYear,v.FPeriod,v.FAssetID