资产管理-固定资产-折旧明细表查询报错
金蝶云社区-云社区用户RO579973
云社区用户RO579973
0人赞赏了该文章 792次浏览 未经作者许可,禁止转载编辑于2015年04月11日 14:52:29

折旧明细表查询报错,请总部老师火速帮忙解决。qq:1982192062
CREATE TABLE TMPFC33BA04E01611E484D36EAE8B2 AS SELECT * FROM (SELECT ROW_NUMBER() OVER( ORDER BY C.FNUMBER ASC) FIDENTITYID, cl.FNAME FASSETNAME, C.FNumber FASSETID, CASE WHEN fa.FDEPRMETHOD = '4' THEN wle.FPredictWorkLoad ELSE fa.FLifePeriods END FLIFEPERIODS, CASE WHEN fa.FDEPRMETHOD = '4' THEN b.FDeprWorkLoad ELSE b.FDeprPeriods END FDEPRPERIODS, CASE WHEN ((fa.FDEPRMETHOD = '4' AND (NVL(b.FDeprWorkLoad, 0) > 0)) AND (NVL(FWORKLOADUNITID, 0) <> 0)) THEN (SELECT FPrecision FROM T_BD_UNIT WHERE FUNITID = fa.FWORKLOADUNITID) ELSE 0 END FPRECISION, st_l.fname FASSETSTATUS, stg_l.fname FASSETSTATUSGROUP, ty_l.fname FASSETTYPE, tyg_l.fname FASSETTYPEGROUP, at_l.fname FALTERMODE, C.FNUMBER, cy.FAMOUNTDIGITS, CASE WHEN b.FDEPR = 0 THEN 0 ELSE (b.FDEPRRATE * 100) END FDEPRRATE, b.forgvalp, b.FPERIOD, b.faccumdeprp, (b.forgvalp - b.faccumdeprp) FNETVALUEP, b.FDECPREP, ((b.forgvalp - b.faccumdeprp) - b.fdecprep) FKHSNETVALUEP, b.forgvalinc, b.forgvaldec, b.fdecpreinc, b.fdecpredec, b.fdepr