计划订单携带父项物料编码信息------避免踩坑

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

在根据官方知识计划订单携带父项物料编码信息给计划订单和MRP运算单据增加字段时，可以增加基础资料字段，但是不能在MRP运算单据上面加基础资料属性字段，不然MRP运算会报错，慎记慎记！！！！

https://wenku.my7c.com/article/198386631118896640?productLineId=1&isKnowledge=2 计划订单携带父项物料编码信息

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 588.

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_ORA_TEXT,F_ORA_INTEGER,F_ORA_BASE,,,,F_ORA_QTY) 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_ORA_TEXT,F_ORA_INTEGER,F_ORA_BASE,,,,F_ORA_QTY FROM T_MRP_DEMANDDATA1;

stacktrace:

Server stack trace:

在 Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)

在 Kingdee.BOS.SQL.TransUtil.Translate(String kSql, Int32 targetDbType, FormatOptions options)

在 Kingdee.BOS.SQL.TransUtil.Translate(String ksql, Int32 targetDbType)

在 Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)

在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)

Exception rethrown at [0]:

在 System.Runtime.Remoting.Proxies.RealProxy.Handl