8.5利润中心科目余额初始化结束报错

利润中心总账科目余额结束初始化报错

具体报错日志如下

execute sql error: 列名 'fmonthpnlfor' 无效。
sql:UPDATE T_PCA_PCAccountBalance_1F SET fbeginbalancefor = beginbalancefor * fdc, fendbalancefor = ((beginbalancefor * fdc) + fdebitfor) - fcreditfor, fyeardebitfor = fyeardebitfor + yeardebitfor, fyearcreditfor = fyearcreditfor + yearcreditfor, fyearpnlfor = t.fmonthpnlfor, fbeginbalancelocal = beginbalancelocal * fdc, fendbalancelocal = ((beginbalancelocal * fdc) + fdebitlocal) - fcreditlocal, fyeardebitlocal = fyeardebitlocal + yeardebitlocal, fyearcreditlocal = fyearcreditlocal + yearcreditlocal, fyearpnllocal = t.fmonthpnllocal, fbeginbalancerpt = beginbalancerpt * fdc, fendbalancerpt = ((beginbalancerpt * fdc) + fdebitrpt) - fcreditrpt, fyeardebitrpt = fyeardebitrpt + yeardebitrpt, fyearcreditrpt = fyearcreditrpt + yearcreditrpt, fyearpnlrpt = t.fmonthpnlrpt, fyeardebitqty = fyeardebitqty + yeardebitqty, fyearcreditqty = fyearcreditqty + yearcreditqty, fbeginqty = beginqty * fdc, fendqty = ((beginqty * fdc) + fdebitqty) - fcreditqty, fyearpnlqty = ISNULL(fmonthpnlqty, 0) FROM (SELECT ab.fprofitcenterid PROFITCENTERID, ab.forgunitid ORGUNITID, ab.faccountid ACCOUNTID, ab.fcurrencyid CURRENCYID, ab.fbeginbalancefor BEGINBALANCEFOR, ab.fbeginbalancelocal BEGINBALANCELOCAL, ab.fbeginbalancerpt BEGINBALANCERPT, ab.fbeginqty BEGINQTY, av.fdc, ab.fyeardebitfor YEARDEBITFOR, ab.fyearcreditfor YEARCREDITFOR, ab.fyeardebitlocal YEARDEBITLOCAL, ab.fyearcreditlocal YEARCREDITLOCAL, ab.fyeardebitrpt YEARDEBITRPT, ab.fyearcreditrpt YEARCREDITRPT, ab.fyearpnlfor YEARPNLFOR, ab.fyearpnllocal YEARPNLLOCAL, ab.fyearpnlrpt YEARPNLRPT, ab.fyeardebitqty YEARDEBITQTY, ab.fyearcreditqty YEARCREDITQTY FROM t_pca_initpcaccountbalance ab INNER JOIN t_bd_accountview av ON ab.faccountid = av.fid WHERE (((ab.fprofitcenterid = ? AND ab.forgunitid = ?) AND (ab.fcurrencyid <> '11111111-1111-1111-1111-111111111111DEB58FDC')) AND (ab.fcurrencyid <> '22222222-2222-2222-2222-222222222222DEB58FDC'))) t WHERE (((profitcenterid = fprofitcenterid AND orgunitid = forgunitid) AND accountid = faccountid) AND currencyid = fcurrencyid) AND ((fprofitcenterid = ? AND forgunitid = ?) AND fperiod = ?)
ksql:update T_PCA_PCAccountBalance_1F set (
fbeginbalancefor, fendbalancefor,
fyeardebitfor, fyearcreditfor, fyearpnlfor,
fbeginbalancelocal, fendbalancelocal,
fyeardebitlocal, fyearcreditlocal, fyearpnllocal,
fbeginbalancerpt, fendbalancerpt,
fyeardebitrpt, fyearcreditrpt, fyearpnlrpt,
fyeardebitqty, fyearcreditqty,
fbeginqty, fendqty, fyearpnlqty) = ( select
beginbalancefor * fdc, b