查询出现异常。无法绑定由多个部分组成的标识符 "flow.FCUS...
INSERT INTO #TM_AR_TraceReport (FSRECEIVEBILLNO, FID, FENTRYID, FCUSTOMERNAME, FSALEDEPTNAME, FSALEGROUPNAME, FSALERNAME, FDATE, FCURRENCYNAME, FCURRENCYID, FMATERIALID, FMATERIALNUMBER, FMATERIALNAME, FPRICEQTY, FALLAMOUNTFOR, FSPECIALQTY, FBUYIVQTY, FIVALLAMOUNTFOR, FUNITID, FBASICUNITID, FAMOUNTDECIMAL, FQTYDECIMAL, FTABLETYPE) SELECT T0.FBILLNO fsreceivebillno, T0.FID, T01.FENTRYID fentryid, T001.FNAME fcustmername, T017.FNAME fsaledeptname, T018.FNAME fsalegroupname, T019.FNAME fsalername, T0.FDATE, T002.FNAME fcurrencyname, T002.FCURRENCYID, CASE WHEN (T010.FMATERIALID IS NOT NULL) THEN T010.FMATERIALID ELSE CASE WHEN (T011.FEXPID IS NOT NULL) THEN T011.FEXPID ELSE T012.FALTERID END END, CASE WHEN (T014.FMATERIALID IS NOT NULL) THEN T014.FNUMBER ELSE CASE WHEN (T015.FEXPID IS NOT NULL) THEN T015.FNUMBER ELSE T016.FNUMBER END END, CASE WHEN (T010.FNAME IS NOT NULL) THEN T010.FNAME ELSE CASE WHEN (T011.FNAME IS NOT NULL) THEN T011.FNAME ELSE T012.FNAME END END, T01.FPRICEQTY, T01.FALLAMOUNTFOR, T01.FSPECIALQTY, T01.FBUYIVQTY, T01.FIVALLAMOUNTFOR, T01.FPRICEUNITID, T01.FBASICUNITID, T003.FAMOUNTDIGITS, T013.FPRECISION, '0' FROM t_AR_receivable T0 INNER JOIN t_AR_receivableEntry T01 ON (T01.FID = T0.FID AND (T0.FALLAMOUNTFOR <> 0)) LEFT OUTER JOIN t_ar_receivableentry_o T02 ON (T02.FID = T0.FID AND T02.FENTRYID = T01.FENTRYID) LEFT OUTER JOIN T_BD_CUSTOMER T004 ON T004.FCUSTID = T0.FCUSTOMERID LEFT OUTER JOIN T_BD_CUSTOMER_L T001 ON (T001.FCUSTID = T0.FCUSTOMERID AND T001.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_DEPARTMENT_L T017 ON (T017.FDEPTID = T0.FSALEDEPTID AND T017.FLOCALEID = 2052) LEFT OUTER JOIN V_BD_OPERATORGROUP_L T018 ON (T018.FENTRYID = T0.FSALEGROUPID AND T018.FLOCALEID = 2052) LEFT OUTER JOIN V_BD_SALESMAN_L T019 ON (T019.FID = T0.FSALEERID AND T019.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_CURRENCY T003 ON T003.FCURRENCYID = T0.FCURRENCYID LEFT OUTER JOIN T_BD_CURRENCY_L T002 ON (T002.FCURRENCYID = T0.FCURRENCYID AND T002.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_MATERIAL T014 ON T014.FMATERIALID = T01.FMATERIALID LEFT OUTER JOIN T_BD_MATERIAL_L T010 ON (T010.FMATERIALID = T01.FMATERIALID AND T010.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_EXPENSE T015 ON T015.FEXPID = T02.FCOSTID LEFT OUTER JOIN T_BD_EXPENSE_L T011 ON (T011.FEXPID = T02.FCOSTID AND T011.FLOCALEID = 2052) LEFT OUTER JOIN T_FA_CARD T016 ON T016.FALTERID = T02.FASSETID LEFT OUTER JOIN T_FA_CARD_L T012 ON (T012.FALTERID = T02.FASSETID AND T012.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_UNIT T013 ON T013.FUNITID = T01.FPRICEUNITID WHERE (1 = 1 AND ((((T0.FSETTLEORGID IN (1) AND (T0.FDOCUMENTSTATUS <> 'Z')) AND T0.FCURRENCYID = 1) AND (T0.FDATE BETWEEN '2016-11-01 00:00:00' AND '2016-11-16 00:00:00')) AND EXISTS (SELECT 1 FROM V1de5f17a7718941d4396ce92e8f77 WHERE V1de5f17a7718941d4396ce92e8f77.FCUSTID = flow.FCUSTOMERID)))
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteWithTime(Context ctx, String strSQL, IEnumerable`1 paramList, Int32 commandTimeout)
在 Kingdee.K3.FIN.AR.App.Report.TraceReport.GetReFlowData(Context ctx)
在 Kingdee.K3.FIN.AR.App.Report.TraceReport.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.