
--修改产品编码(物料生产信息)为非必录
update T_BAS_IMPORTTEMPLATEENTRY set FMUSTINPUT = '0' where FENTRYID = 998564973431129114;
--修改组件编码(物料生产信息)为非必录
update T_BAS_IMPORTTEMPLATEENTRY set FMUSTINPUT = '0' where FENTRYID = 998564973515143172;

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1580507508835879943;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (998572837038097408,'1','1','number',998564973422868480,1580507508835879943,'materialid',18,'1',' ','number',NULL); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1580507509397916678;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (998572837038097408,'0','1','number',998564973473200128,1580507509397916678,'copentrymaterialid',48,'0',' ','number',NULL); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1580507509674739716;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (998572837038097408,'1','1','number',998564973515143168,1580507509674739716,'entrymaterialid',84,'1',' ','number',NULL); 