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

在根据官方知识计划订单携带父项物料编码信息给计划订单和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,FPLANSTAR
计划订单携带父项物料编码信息------避免踩坑
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



