销售订单新增了两个自定义项:
项目编码:关联基础资料
项目名称:关联项目名称
根据《MRP运算-销售订单自定义字段携带.ppt》PPT文档配置了MRP运算数据模型策略,但计算后,出现以下的错误,请问是什么原因?
source:mscorlib
message:parse error. detail message is :
Error: expect token type 'Identifier', but current token type is 'Punctuation', token value is ), at line 1, column 571.
source sql is :
INSERT /*+append*/ INTO T_MRP_DEMANDDATA(FID,FENTRYID,FMATERIALID,FPARENTFORMID,FPARENTINTERID,FPARENTENTRYID,FPARENTBILLNO,FBASEDEMANDQTY,FDEMANDDATE,FSRCFORMID,FSRCINTERID,FSRCENTRYID,FSRCBILLNO,FPRIORITY,FRELATIONFORMID,FRELATIONINTERID,FRELATIONENTRYID,FRELATIONBILLNO,FDEMANDDAYID,FBASEORDERQTY,FMERGEROWID,FBASEGROSSQTY,FPLANSTARTDATE,FPLANFINISHDATE,FCOMPUTEID,FRESERVETYPE,FBASEEXECQTY,FUNITID,FGROSSQTY,FEXECQTY,FDEMANDQTY,FORDERQTY,FORGID,FDATE,FRELATIONENTRYSEQ,FBASEQTY,FQTY,FROWID,FPARENTROWID,FSRCROWID,FBASEUNITID,FBASEPARENTDEMANDQTY,FDATASOURCE,F_PAEZ_PROJECTCODE,) SELECT FID,FENTRYID,FMATERIALID,FPARENTFORMID,FPARENTINTERID,FPARENTENTRYID,FPARENTBILLNO,FBASEDEMANDQTY,FDEMANDDATE,FSRCFORMID,FSRCINTERID,FSRCENTRYID,FSRCBILLNO,FPRIORITY,FRELATIONFORMID,FRELATIONINTERID,FRELATIONENTRYID,FRELATIONBILLNO,FDEMANDDAYID,FBASEORDERQTY,FMERGEROWID,FBASEGROSSQTY,FPLANSTARTDATE,FPLANFINISHDATE,FCOMPUTEID,FRESERVETYPE,FBASEEXECQTY,FUNITID,FGROSSQTY,FEXECQTY,FDEMANDQTY,FORDERQTY,FORGID,FDATE,FRELATIONENTRYSEQ,FBASEQTY,FQTY,FROWID,FPARENTROWID,FSRCROWID,FBASEUNITID,FBASEPARENTDEMANDQTY,FDATASOURCE,F_PAEZ_PROJECTCODE, FROM T_MRP_DEMANDDATA1;
stacktrace:
Server stack trace:
at Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)
at Kingdee.BOS.SQL.TransUtil.Translate(String kSql, Int32 targetDbType, FormatOptions options)
at Kingdee.BOS.SQL.TransUtil.Translate(String ksql, Int32 targetDbType)
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
推荐阅读