---实体字段映射
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374656;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.material',1629584990658374656,'stockentry.materielmasterid','stockentry.materielmasterid',' ',' ','组件明细.物料(主数据)',' ',1,'单据体.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374657;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.billid',1629584990658374657,' ',' ','id','{"expression":"id","exprTran":"委外组件清单.内码","description":{"zh_CN":""},"exprDesc":"委外组件清单.内码","localeExprTran":{"zh_CN":"委外组件清单.内码"}}',' ','委外组件清单.内码',2,'单据体.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374658;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.billdate',1629584990658374658,'stockentry.demanddate','stockentry.demanddate',' ',' ','组件明细.需求时间',' ',3,'单据体.需求日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374659;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.productionorgunit',1629584990658374659,'org','org',' ',' ','单据头.生产组织',' ',4,'单据体.需求组织','entryentity.productionorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374660;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.billnumber',1629584990658374660,'billno','billno',' ',' ','单据头.单据编号',' ',5,'单据体.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374661;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.demandqty',1629584990658374661,' ',' ','stockentry.demandqty','{"items":[{"id":"371UGOFJ=QL/","seq":1,"ifconstant":0,"selectType":"ByCondition","condition":{"expression":"","exprTran":"组件明细.需求基本数量 字段大于等于 组件明细.实发基本数量","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"371UFSZV/RH2","leftBracket":"","compareType":"-3","fieldName":"demandqty","rightBracket":"","logic":"0","value":[{"id":"371UFSZV/QTU","value":"actissueqty"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"371UFSZV/RH2\",\"leftBracket\":\"\",\"compareType\":\"-3\",\"fieldName\":\"demandqty\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"371UFSZV/QTU\",\"value\":\"actissueqty\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"组件明细.需求基本数量 字段大于等于 组件明细.实发基本数量"},"exprDesc":"组件明细.需求基本数量 字段大于等于 组件明细.实发基本数量"},"formula":{"expression":"stockentry.demandqty","exprTran":"需求基本数量","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"需求基本数量"},"exprDesc":"需求基本数量"},"select":"ByCondition"},{"id":"371UIVL8LV3N","seq":2,"ifconstant":0,"selectType":"ByCondition","condition":{"expression":"","exprTran":"组件明细.需求基本数量 字段小于 组件明细.实发基本数量","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"371UI2YJ5DIN","leftBracket":"","compareType":"-6","fieldName":"demandqty","rightBracket":"","logic":"0","value":[{"id":"371UI2YJ5E6X","value":"actissueqty"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"371UI2YJ5DIN\",\"leftBracket\":\"\",\"compareType\":\"-6\",\"fieldName\":\"demandqty\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"371UI2YJ5E6X\",\"value\":\"actissueqty\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"组件明细.需求基本数量 字段小于 组件明细.实发基本数量"},"exprDesc":"组件明细.需求基本数量 字段小于 组件明细.实发基本数量"},"formula":{"expression":"stockentry.actissueqty","exprTran":"实发基本数量","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"实发基本数量"},"exprDesc":"实发基本数量"},"select":"ByCondition"}],"description":"需求基本数量\\实发基本数量"}',' ','需求基本数量\实发基本数量',6,'单据体.需求基本数量','entryentity.demandqty','2'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629584990658374662;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.baseunit',1629584990658374662,'stockentry.materialunitid','stockentry.materialunitid',' ',' ','组件明细.基本单位',' ',7,'单据体.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629613206748038144;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.bomreversion',1629613206748038144,'stockentry.bomreversion','stockentry.bomreversion',' ',' ','组件明细.BOM版本',' ',8,'单据体.BOM子项版本','entryentity.bomreversion','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629613206748038145;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.billtype',1629613206748038145,'billtype','billtype',' ',' ','单据头.单据类型',' ',9,'单据体.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629613206748038146;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.billentryid',1629613206748038146,' ',' ','stockentry.id','{"expression":"stockentry.id","exprTran":"组件明细.内码","description":{"zh_CN":""},"exprDesc":"组件明细.内码","localeExprTran":{"zh_CN":"组件明细.内码"}}',' ','组件明细.内码',10,'单据体.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629613206748038147;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.billentryseq',1629613206748038147,' ',' ','stockentry.seq','{"expression":"stockentry.seq","exprTran":"组件明细.序号","description":{"zh_CN":""},"exprDesc":"组件明细.序号","localeExprTran":{"zh_CN":"组件明细.序号"}}',' ','组件明细.序号',11,'单据体.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629613206748038148;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.materialflexprops',1629613206748038148,'stockentry.childauxpropertyid','stockentry.childauxpropertyid',' ',' ','组件明细.辅助属性',' ',12,'单据体.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629613206748038149;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629584990415105024,'entryentity.recqty',1629613206748038149,'stockentry.actissueqty','stockentry.actissueqty',' ',' ','组件明细.实发基本数量',' ',13,'单据体.领料数量','entryentity.recqty','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787009;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.material',1629615712911787009,'stockentry.materielmasterid','stockentry.materielmasterid',' ',' ','组件明细.物料(主数据)',' ',1,'单据体.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787010;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.billid',1629615712911787010,' ',' ','id','{"expression":"id","exprTran":"生产组件清单.内码","description":{"zh_CN":""},"exprDesc":"生产组件清单.内码","localeExprTran":{"zh_CN":"生产组件清单.内码"}}',' ','生产组件清单.内码',2,'单据体.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787011;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.billdate',1629615712911787011,'stockentry.demanddate','stockentry.demanddate',' ',' ','组件明细.需求时间',' ',3,'单据体.需求日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787012;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.productionorgunit',1629615712911787012,'org','org',' ',' ','单据头.生产组织',' ',4,'单据体.需求组织','entryentity.productionorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787013;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.billnumber',1629615712911787013,'billno','billno',' ',' ','单据头.单据编号',' ',5,'单据体.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787014;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.demandqty',1629615712911787014,' ',' ','stockentry.demandqty','{"items":[{"id":"371SCYBI+PFU","seq":1,"ifconstant":0,"selectType":"ByCondition","condition":{"expression":"","exprTran":"组件明细.需求基本数量 字段大于等于 组件明细.实发基本数量","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"371S5VQ=V2AM","leftBracket":"","compareType":"-3","fieldName":"demandqty","rightBracket":"","logic":"0","value":[{"id":"371S5VQH2X0D","value":"actissueqty"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"371S5VQ=V2AM\",\"leftBracket\":\"\",\"compareType\":\"-3\",\"fieldName\":\"demandqty\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"371S5VQH2X0D\",\"value\":\"actissueqty\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"组件明细.需求基本数量 字段大于等于 组件明细.实发基本数量"},"exprDesc":"组件明细.需求基本数量 字段大于等于 组件明细.实发基本数量"},"formula":{"expression":"stockentry.demandqty","exprTran":"需求基本数量","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"需求基本数量"},"exprDesc":"需求基本数量"},"select":"ByCondition"},{"id":"371SCYBI+Q42","seq":2,"ifconstant":0,"selectType":"ByCondition","condition":{"expression":"","exprTran":"组件明细.需求基本数量 字段小于 组件明细.实发基本数量","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"371SA9ZY1+BX","leftBracket":"","compareType":"-6","fieldName":"demandqty","rightBracket":"","logic":"0","value":[{"id":"371SA9ZY1/05","value":"actissueqty"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"371SA9ZY1+BX\",\"leftBracket\":\"\",\"compareType\":\"-6\",\"fieldName\":\"demandqty\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"371SA9ZY1/05\",\"value\":\"actissueqty\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"组件明细.需求基本数量 字段小于 组件明细.实发基本数量"},"exprDesc":"组件明细.需求基本数量 字段小于 组件明细.实发基本数量"},"formula":{"expression":"stockentry.actissueqty","exprTran":"实发基本数量","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"实发基本数量"},"exprDesc":"实发基本数量"},"select":"ByCondition"}],"description":"需求基本数量\\实发基本数量"}',' ','需求基本数量\实发基本数量',6,'单据体.需求基本数量','entryentity.demandqty','2'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787015;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.baseunit',1629615712911787015,'stockentry.materialunitid','stockentry.materialunitid',' ',' ','组件明细.基本单位',' ',7,'单据体.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787016;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.bomreversion',1629615712911787016,'stockentry.bomreversion','stockentry.bomreversion',' ',' ','组件明细.BOM版本',' ',8,'单据体.BOM子项版本','entryentity.bomreversion','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787017;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.billtype',1629615712911787017,'billtype','billtype',' ',' ','单据头.单据类型',' ',9,'单据体.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787018;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.billentryid',1629615712911787018,' ',' ','stockentry.id','{"expression":"stockentry.id","exprTran":"组件明细.内码","description":{"zh_CN":""},"exprDesc":"组件明细.内码","localeExprTran":{"zh_CN":"组件明细.内码"}}',' ','组件明细.内码',10,'单据体.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787019;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.billentryseq',1629615712911787019,' ',' ','stockentry.seq','{"expression":"stockentry.seq","exprTran":"组件明细.序号","description":{"zh_CN":""},"exprDesc":"组件明细.序号","localeExprTran":{"zh_CN":"组件明细.序号"}}',' ','组件明细.序号',11,'单据体.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787020;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.materialflexprops',1629615712911787020,'stockentry.childauxpropertyid','stockentry.childauxpropertyid',' ',' ','组件明细.辅助属性',' ',12,'单据体.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1629615712911787021;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1629615712911787008,'entryentity.recqty',1629615712911787021,'stockentry.actissueqty','stockentry.actissueqty',' ',' ','组件明细.实发基本数量',' ',13,'单据体.领料数量','entryentity.recqty','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838400;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.material',1630316068708838400,' ',' ','pentry.ecobomdata.entry.entrymaterialid','{"expression":"pentry.ecobomdata.entry.entrymaterialid","exprTran":"pentry.ecobomdata.entry.entrymaterialid","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entrymaterialid","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrymaterialid"}}',' ','pentry.ecobomdata.entry.entrymaterialid',1,'供应数据.物料','entryentity.material','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838401;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.supplyorgunit',1630316068708838401,'org','org',' ',' ','单据头.创建组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838402;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.billid',1630316068708838402,' ',' ','id','{"expression":"id","exprTran":"工程变更维护.内码","description":{"zh_CN":""},"exprDesc":"工程变更维护.内码","localeExprTran":{"zh_CN":"工程变更维护.内码"}}',' ','工程变更维护.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838403;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.billdate',1630316068708838403,' ',' ','pentry.ecobomdata.entry.transtartdate','{"expression":"pentry.ecobomdata.entry.transtartdate","exprTran":"pentry.ecobomdata.entry.transtartdate","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.transtartdate","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.transtartdate"}}',' ','pentry.ecobomdata.entry.transtartdate',4,'供应数据.供应日期','entryentity.billdate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838404;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.qty',1630316068708838404,' ',' ','pentry.ecobomdata.entry.tranqty','{"expression":"pentry.ecobomdata.entry.tranqty","exprTran":"pentry.ecobomdata.entry.tranqty","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.tranqty","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.tranqty"}}',' ','pentry.ecobomdata.entry.tranqty',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838405;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.billnumber',1630316068708838405,'billno','billno',' ',' ','单据头.工程变更编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838406;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.baseunit',1630316068708838406,' ',' ','pentry.ecobomdata.entry.entryunit','{"expression":"pentry.ecobomdata.entry.entryunit","exprTran":"pentry.ecobomdata.entry.entryunit","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entryunit","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryunit"}}',' ','pentry.ecobomdata.entry.entryunit',7,'供应数据.基本计量单位','entryentity.baseunit','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838407;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.bomreversion',1630316068708838407,' ',' ','pentry.ecobomdata.entry.entryversion','{"expression":"pentry.ecobomdata.entry.entryversion","exprTran":"pentry.ecobomdata.entry.entryversion","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entryversion","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryversion"}}',' ','pentry.ecobomdata.entry.entryversion',8,'供应数据.BOM子项版本','entryentity.bomreversion','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630316068708838408;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.materialflexprops',1630316068708838408,' ',' ','pentry.ecobomdata.entry.entryauxproperty','{"expression":"pentry.ecobomdata.entry.entryauxproperty","exprTran":"pentry.ecobomdata.entry.entryauxproperty","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entryauxproperty","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryauxproperty"}}',' ','pentry.ecobomdata.entry.entryauxproperty',9,'供应数据.物料辅助属性','entryentity.materialflexprops','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630321628770495488;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.entrymode',1630321628770495488,' ',' ','pentry.ecobomdata.entry.entrymode','{"expression":"pentry.ecobomdata.entry.entrymode","exprTran":"pentry.ecobomdata.entry.entrymode","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entrymode","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrymode"}}',' ','pentry.ecobomdata.entry.entrymode',10,'供应数据.行标识','entryentity.entrymode','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630321628770495489;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.ecobomentryid',1630321628770495489,' ',' ','pentry.ecobomdata.entry.id','{"expression":"pentry.ecobomdata.entry.id","exprTran":"pentry.ecobomdata.entry.id","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.id","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.id"}}',' ','pentry.ecobomdata.entry.id',11,'供应数据.ecoBom分录ID','entryentity.ecobomentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630321628770495490;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.ecobomid',1630321628770495490,'pentry.ecobomid','pentry.ecobomid',' ',' ','产品.变更BOMID',' ',12,'供应数据.ecobomid','entryentity.ecobomid','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630321628770495491;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.ecotypeid',1630321628770495491,' ',' ','pentry.ecotype.id','{"expression":"pentry.ecotype.id","exprTran":"pentry.ecotype.id","description":{"zh_CN":""},"exprDesc":"pentry.ecotype.id","localeExprTran":{"zh_CN":"pentry.ecotype.id"}}',' ','pentry.ecotype.id',13,'供应数据.工程变更类型ID','entryentity.ecotypeid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630321628770495492;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.billentryid',1630321628770495492,' ',' ','pentry.id','{"expression":"pentry.id","exprTran":"产品.内码","description":{"zh_CN":""},"exprDesc":"产品.内码","localeExprTran":{"zh_CN":"产品.内码"}}',' ','产品.内码',14,'供应数据.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1630321628770495493;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.billentryseq',1630321628770495493,' ',' ','pentry.ecobomdata.entry.entryseq','{"expression":"pentry.ecobomdata.entry.entryseq","exprTran":"pentry.ecobomdata.entry.entryseq","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entryseq","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryseq"}}',' ','pentry.ecobomdata.entry.entryseq',15,'供应数据.单据分录行号','entryentity.billentryseq','1'); 

DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631786974429844480;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.estimatestatus',1631786974429844480,' ',' ','pentry.ecobomdata.entry.estimatestatus','{"expression":"pentry.ecobomdata.entry.estimatestatus","exprTran":"pentry.ecobomdata.entry.estimatestatus","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.estimatestatus"},"exprDesc":"pentry.ecobomdata.entry.estimatestatus"}',' ','pentry.ecobomdata.entry.estimatestatus',16,'供应数据.评估状态','entryentity.estimatestatus','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631786974429844481;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.refkey',1631786974429844481,' ',' ','pentry.ecobomdata.entry.refkey','{"expression":"pentry.ecobomdata.entry.refkey","exprTran":"pentry.ecobomdata.entry.refkey","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.refkey"},"exprDesc":"pentry.ecobomdata.entry.refkey"}',' ','pentry.ecobomdata.entry.refkey',17,'供应数据.关联关键主键行','entryentity.refkey','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631786974429844482;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.groupkey',1631786974429844482,' ',' ','pentry.ecobomdata.entry.groupkey','{"expression":"pentry.ecobomdata.entry.groupkey","exprTran":"pentry.ecobomdata.entry.groupkey","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.groupkey"},"exprDesc":"pentry.ecobomdata.entry.groupkey"}',' ','pentry.ecobomdata.entry.groupkey',18,'供应数据.成组关键主键行','entryentity.groupkey','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631786974429844483;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.entryrefno',1631786974429844483,' ',' ','pentry.ecobomdata.entry.entryrefno','{"expression":"pentry.ecobomdata.entry.entryrefno","exprTran":"pentry.ecobomdata.entry.entryrefno","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryrefno"},"exprDesc":"pentry.ecobomdata.entry.entryrefno"}',' ','pentry.ecobomdata.entry.entryrefno',19,'供应数据.关联实施号','entryentity.entryrefno','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631786974429844484;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.entrygroupno',1631786974429844484,' ',' ','pentry.ecobomdata.entry.entrygroupno','{"expression":"pentry.ecobomdata.entry.entrygroupno","exprTran":"pentry.ecobomdata.entry.entrygroupno","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrygroupno"},"exprDesc":"pentry.ecobomdata.entry.entrygroupno"}',' ','pentry.ecobomdata.entry.entrygroupno',20,'供应数据.成组号','entryentity.entrygroupno','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1632513077977050112;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.materialattr',1632513077977050112,' ',' ','pentry.ecobomdata.entry.entrymaterialattr','{"expression":"pentry.ecobomdata.entry.entrymaterialattr","exprTran":"pentry.ecobomdata.entry.entrymaterialattr","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entrymaterialattr","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrymaterialattr"}}',' ','pentry.ecobomdata.entry.entrymaterialattr',23,'供应数据.物料属性','entryentity.materialattr','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1632519154458191872;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.bomid',1632519154458191872,' ',' ','pentry.pentrybom.id','{"expression":"pentry.pentrybom.id","exprTran":"pentry.pentrybom.id","description":{"zh_CN":""},"exprDesc":"pentry.pentrybom.id","localeExprTran":{"zh_CN":"pentry.pentrybom.id"}}',' ','pentry.pentrybom.id',24,'供应数据.BOM的ID','entryentity.bomid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1632519154458191873;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.bomnumber',1632519154458191873,' ',' ','pentry.pentrybom.number','{"expression":"pentry.pentrybom.number","exprTran":"BOM编码","description":{"zh_CN":""},"exprDesc":"BOM编码","localeExprTran":{"zh_CN":"BOM编码"}}',' ','BOM编码',25,'供应数据.BOM编码','entryentity.bomnumber','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631943566689304576;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.featuretype',1631943566689304576,' ',' ','pentry.ecobomdata.entry.featuretype','{"expression":"pentry.ecobomdata.entry.featuretype","exprTran":"pentry.ecobomdata.entry.featuretype","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.featuretype"},"exprDesc":"pentry.ecobomdata.entry.featuretype"}',' ','pentry.ecobomdata.entry.featuretype',21,'供应数据.特征类','entryentity.featuretype','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631967546473186304;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.billtype',1631967546473186304,' ',' ','1631966120074281984','{"expression":"1631966120074281984","exprTran":"工程变更维护","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护"},"exprDesc":"工程变更维护"}',' ','工程变更维护',22,'供应数据.单据类型','entryentity.billtype','3'); 

DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1637190883851926528;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.entryvaliddate',1637190883851926528,' ',' ','pentry.ecobomdata.entry.entryvaliddate','{"expression":"pentry.ecobomdata.entry.entryvaliddate","exprTran":"pentry.ecobomdata.entry.entryvaliddate","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryvaliddate"},"exprDesc":"pentry.ecobomdata.entry.entryvaliddate"}',' ','pentry.ecobomdata.entry.entryvaliddate',26,'供应数据.生效日期','entryentity.entryvaliddate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1637190883851926529;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.entryinvaliddate',1637190883851926529,' ',' ','pentry.ecobomdata.entry.entryinvaliddate','{"expression":"pentry.ecobomdata.entry.entryinvaliddate","exprTran":"pentry.ecobomdata.entry.entryinvaliddate","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryinvaliddate"},"exprDesc":"pentry.ecobomdata.entry.entryinvaliddate"}',' ','pentry.ecobomdata.entry.entryinvaliddate',27,'供应数据.失效日期','entryentity.entryinvaliddate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1637243457892280320;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.initacttime',1637243457892280320,' ',' ','pentry.ecobomdata.entry.acttime','{"expression":"pentry.ecobomdata.entry.acttime","exprTran":"pentry.ecobomdata.entry.acttime","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.acttime"},"exprDesc":"pentry.ecobomdata.entry.acttime"}',' ','pentry.ecobomdata.entry.acttime',28,'供应数据.初始实施时间','entryentity.initacttime','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1673956595479896064;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.iscanestimate',1673956595479896064,' ',' ','pentry.ecobomdata.entry.iscanestimate','{"expression":"pentry.ecobomdata.entry.iscanestimate","exprTran":"pentry.ecobomdata.entry.iscanestimate","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.iscanestimate"},"exprDesc":"pentry.ecobomdata.entry.iscanestimate"}',' ','pentry.ecobomdata.entry.iscanestimate',29,'供应数据.连续可评估','entryentity.iscanestimate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1673956595479896065;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.continuouspoint',1673956595479896065,' ',' ','pentry.ecobomdata.entry.continuouspoint','{"expression":"pentry.ecobomdata.entry.continuouspoint","exprTran":"pentry.ecobomdata.entry.continuouspoint","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.continuouspoint"},"exprDesc":"pentry.ecobomdata.entry.continuouspoint"}',' ','pentry.ecobomdata.entry.continuouspoint',30,'供应数据.连续断点','entryentity.continuouspoint','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1680663173859911680;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1630316068482345984,'entryentity.bomentryid',1680663173859911680,' ',' ','pentry.ecobomdata.entry.entrybomentryid','{"expression":"pentry.ecobomdata.entry.entrybomentryid","exprTran":"pentry.ecobomdata.entry.entrybomentryid","description":{"zh_CN":""},"exprDesc":"pentry.ecobomdata.entry.entrybomentryid","localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrybomentryid"}}',' ','pentry.ecobomdata.entry.entrybomentryid',31,'供应数据.BOM分录的ID','entryentity.bomentryid','1'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID = 1629584990415105024) 
INSERT INTO t_mrp_bftransfer(FID,FBITINDEX,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FSOURCEBITINDEX,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1629584990415105024,0,' ',' ',100000,0,1629584990415105024,100000,'B','C','5','ecoestimate_om_stock','om_mftstock','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'mrp_demandbill_model_eco',1,'{"filterRow":[],"forList":false}'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID = 1630316068482345984) 
INSERT INTO t_mrp_bftransfer(FID,FBITINDEX,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FSOURCEBITINDEX,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1630316068482345984,0,' ',' ',100000,0,1630316068482345984,100000,'D','C','5','ecoestimate_pdm_eco','pdm_bom_eco','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'mrp_supply_model_eco',1,'{"filterRow":[],"forList":false}'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID = 1629615712911787008) 
INSERT INTO t_mrp_bftransfer(FID,FBITINDEX,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FSOURCEBITINDEX,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1629615712911787008,0,' ',' ',100000,0,1629615712911787008,100000,'B','C','5','ecoestimate_pom_stock','pom_mftstock','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'mrp_demandbill_model_eco',1,'{"filterRow":[],"forList":false}'); 

update t_mrp_bftransfer set  ffieldtype = 'pdm' WHERE FID = 1629584990415105024;
update t_mrp_bftransfer set  ffieldtype = 'pdm' WHERE FID = 1630316068482345984;
update t_mrp_bftransfer set  ffieldtype = 'pdm' WHERE FID = 1629615712911787008;


DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1634625735933047808;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1634625735563949056,'entryentity.material',1634625735933047808,'entryentity.material','entryentity.material',' ',' ','单据体.物料',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1634625735933047809;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1634625735563949056,'entryentity.supplyorgunit',1634625735933047809,'entryentity.productionorgunit','entryentity.productionorgunit',' ',' ','单据体.需求组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1634625735933047810;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1634625735563949056,'entryentity.bomreversion',1634625735933047810,'entryentity.bomreversion','entryentity.bomreversion',' ',' ','单据体.BOM子项版本',' ',3,'供应数据.BOM子项版本','entryentity.bomreversion','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1634625735933047811;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1634625735563949056,'entryentity.materialflexprops',1634625735933047811,'entryentity.materialflexprops','entryentity.materialflexprops',' ',' ','单据体.物料辅助属性',' ',4,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID = 1634625735563949056) 
INSERT INTO t_mrp_bftransfer(FID,FBITINDEX,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FSOURCEBITINDEX,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1634625735563949056,0,' ',' ',100000,0,1634625735563949056,100000,'D','C','5','ecoestimate_supply_require_r','mrp_demandbill_model_eco','1',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'mrp_supply_model_eco',1,'{"filterRow":[],"forList":false}'); 

update t_mrp_bftransfer set  ffieldtype = 'pdm' WHERE FID = 1634625735563949056;

DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '33SASS1P=9S/';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1634625735563949056,'33SASS1P=9S/','zh_CN','工程变更供需平衡字段关系映射'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '33SASS1P=9S0';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1634625735563949056,'33SASS1P=9S0','zh_TW','工程變更供需平衡字段關係映射'); 



--插入U表
insert into t_mrp_bftransfer_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_bftransfer a
where fid in(1629615712911787008,1630316068482345984,1629584990415105024,1634625735563949056)
and a.fctrlstrategy = '5'
and not exists(select 1 from t_mrp_bftransfer_u b
where b.fdataid = a.fid  and b.fuseorgid = a.fcreateorgid
);


DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '3355YYXDIPZW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629584990415105024,'3355YYXDIPZW','zh_CN','工程变更评估_委外组件清单需求'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '3355YYXDIPZX';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629584990415105024,'3355YYXDIPZX','zh_TW','工程變更評估_委外組件清單需求'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '338OJ=OPDR/W';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1630316068482345984,'338OJ=OPDR/W','zh_CN','工程变更评估_工程变更维护'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '338OJ=OPDR/X';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1630316068482345984,'338OJ=OPDR/X','zh_TW','工程變更評估_工程變更維護'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '335AOTYIFAJT';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629615712911787008,'335AOTYIFAJT','zh_CN','工程变更评估_生产组件清单需求'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '335AOTYIFAJU';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629615712911787008,'335AOTYIFAJU','zh_TW','工程變更評估_生產組件清單需求'); 




--资源注册模型
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352768;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'number',' ',1642080404024352768,'文本型',1,'编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352769;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'name',' ',1642080404024352769,'多语言文本型',2,'名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352770;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'status',' ',1642080404024352770,'下拉列表',3,'数据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352771;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'creator','bos_user',1642080404024352771,'创建人',4,'创建人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352772;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'modifier','bos_user',1642080404024352772,'修改人',5,'修改人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352773;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'enable',' ',1642080404024352773,'下拉列表',6,'使用状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352774;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'createtime',' ',1642080404024352774,'日期型',7,'创建时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352775;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'modifytime',' ',1642080404024352775,'日期型',8,'修改时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352776;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1630325143907625984,'entryentity.supplyorgunit',' ',1642080404024352776,'组织',9,'供应组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352777;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.material','bd_material',1642080404024352777,'物料',10,'物料',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352778;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.materialattr',' ',1642080404024352778,'下拉列表',11,'物料属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352779;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.planstrategy','mpdm_manustrategy',1642080404024352779,'基础资料',12,'制造策略',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352780;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.isolatedrule',' ',1642080404024352780,'下拉列表',13,'隔离规则',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352781;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.billdate',' ',1642080404024352781,'日期型',14,'供应日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352782;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.billtype','bos_billtype',1642080404024352782,'基础资料',15,'单据类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352783;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.biztype','bd_biztype',1642080404024352783,'基础资料',16,'业务类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352784;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.usablestoqty',' ',1642080404024352784,'数量型',17,'可用库存量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352785;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.qty',' ',1642080404024352785,'数量型',18,'预计入库基本数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352786;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.computingperiod',' ',1642080404024352786,'整数',19,'计算期间','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352787;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.billnumber',' ',1642080404024352787,'文本型',20,'单据编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352788;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.billstatusfield',' ',1642080404024352788,'下拉列表',21,'单据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352789;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.produnit','bd_measureunits',1642080404024352789,'基础资料',22,'计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352790;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.baseunit','bd_measureunits',1642080404024352790,'基础资料',23,'基本计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352791;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.projectnumber','bd_project',1642080404024352791,'基础资料',24,'项目号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352792;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.tracknumber','bd_tracknumber',1642080404024352792,'基础资料',25,'跟踪号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352793;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.billid',' ',1642080404024352793,'文本型',26,'单据ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352794;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.billentryid',' ',1642080404024352794,'文本型',27,'单据分录ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352795;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.billentryseq',' ',1642080404024352795,'整数',28,'单据分录行号','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352796;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.istock',' ',1642080404024352796,'布尔型',29,'是否库存数据','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352797;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.yield',' ',1642080404024352797,'数量型',30,'成品率（%）','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352798;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.stock','bd_warehouse',1642080404024352798,'基础资料',31,'仓库',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352799;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.stockindex','bd_location',1642080404024352799,'基础资料',32,'仓位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352800;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.stocktype','bd_invtype',1642080404024352800,'基础资料',33,'库存类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352801;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.stockstatus','bd_invstatus',1642080404024352801,'基础资料',34,'库存状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352802;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.supplyorgname',' ',1642080404024352802,'文本型',35,'供应明细.库存组织名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352803;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.warehousename',' ',1642080404024352803,'文本型',36,'供应明细.仓库名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352804;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.locationname',' ',1642080404024352804,'文本型',37,'供应明细.仓位名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352805;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.warehousenumber',' ',1642080404024352805,'文本型',38,'供应明细.仓库编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352806;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.configuredcode','bd_configuredcode',1642080404024352806,'基础资料',39,'配置号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352807;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.isonwork',' ',1642080404024352807,'布尔型',40,'是否在制产品','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352808;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.finishqty',' ',1642080404024352808,'数量型',41,'完工数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352809;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1630325143907625984,'entryentity.owner',' ',1642080404024352809,'组织',42,'货主',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352810;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1630325143907625984,'entryentity.stockorg',' ',1642080404024352810,'组织',43,'库存组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352811;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.materialflexprops',' ',1642080404024352811,'弹性域',44,'物料辅助属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352812;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.flexmetricid',' ',1642080404024352812,'文本型',45,'弹性维度ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352813;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.flexmetricvalue',' ',1642080404024352813,'文本型',46,'弹性维度值',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352814;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1630325143907625984,'entryentity.bomreversion','bd_bomversion_new',1642080404024352814,'基础资料',47,'BOM子项版本',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352815;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.ecotypeid',' ',1642080404024352815,'长整数',48,'工程变更类型ID','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352816;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.ecobomentryid',' ',1642080404024352816,'长整数',49,'ecoBom分录ID','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352817;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.ecobomid',' ',1642080404024352817,'长整数',50,'ecobomid','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352818;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.entrymode',' ',1642080404024352818,'长整数',51,'行标识','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352819;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.groupkey',' ',1642080404024352819,'布尔型',52,'成组关键主键行','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352820;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.refkey',' ',1642080404024352820,'布尔型',53,'关联关键主键行','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352821;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.estimatestatus',' ',1642080404024352821,'下拉列表',54,'评估状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352822;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.featuretype',' ',1642080404024352822,'长整数',55,'特征类','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352823;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.bomid',' ',1642080404024352823,'长整数',56,'BOM的ID','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352824;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.bomnumber',' ',1642080404024352824,'文本型',57,'BOM编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352825;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.entryvaliddate',' ',1642080404024352825,'日期型',58,'生效日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352826;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.entryinvaliddate',' ',1642080404024352826,'日期型',59,'失效日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352827;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1630325143907625984,'entryentity.initacttime',' ',1642080404024352827,'日期型',60,'初始实施时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352828;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.entrygroupno',' ',1642080404024352828,'文本型',61,'成组号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1642080404024352829;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1630325143907625984,'entryentity.entryrefno',' ',1642080404024352829,'文本型',62,'关联实施号',' '); 



DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012352;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'number',' ',1629731533399012352,'文本型',1,'编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012353;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'name',' ',1629731533399012353,'多语言文本型',2,'名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012354;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'status',' ',1629731533399012354,'下拉列表',3,'数据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012355;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'creator','bos_user',1629731533399012355,'创建人',4,'创建人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012356;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'modifier','bos_user',1629731533399012356,'修改人',5,'修改人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012357;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'enable',' ',1629731533399012357,'下拉列表',6,'使用状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012358;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'createtime',' ',1629731533399012358,'日期型',7,'创建时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012359;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'modifytime',' ',1629731533399012359,'日期型',8,'修改时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012360;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1629731533172519936,'entryentity.productionorgunit',' ',1629731533399012360,'组织',9,'需求组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012361;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1629731533172519936,'entryentity.supplyorgunit',' ',1629731533399012361,'组织',10,'供应组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012362;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.material','bd_material',1629731533399012362,'物料',11,'物料',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012363;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.materialattr',' ',1629731533399012363,'下拉列表',12,'物料属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012364;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.planstrategy','mpdm_manustrategy',1629731533399012364,'基础资料',13,'制造策略',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012365;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.isolatedrule',' ',1629731533399012365,'下拉列表',14,'隔离规则',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012366;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.billid',' ',1629731533399012366,'文本型',15,'单据ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012367;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.billdate',' ',1629731533399012367,'日期型',16,'需求日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012368;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.billtype','bos_billtype',1629731533399012368,'基础资料',17,'单据类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012369;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.biztype','bd_biztype',1629731533399012369,'基础资料',18,'业务类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012370;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.demandqty',' ',1629731533399012370,'数量型',19,'需求基本数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012371;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.computingperiod',' ',1629731533399012371,'整数',20,'计算期间','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012372;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.billnumber',' ',1629731533399012372,'文本型',21,'单据编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012373;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.billstatusfield',' ',1629731533399012373,'下拉列表',22,'单据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012374;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.produnit','bd_measureunits',1629731533399012374,'基础资料',23,'计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012375;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.baseunit','bd_measureunits',1629731533399012375,'基础资料',24,'基本计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012376;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.projectnumber','bd_project',1629731533399012376,'基础资料',25,'项目号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012377;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.tracknumber','bd_tracknumber',1629731533399012377,'基础资料',26,'跟踪号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012378;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.billentryid',' ',1629731533399012378,'文本型',27,'单据分录ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012379;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.billentryseq',' ',1629731533399012379,'整数',28,'单据分录行号','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012380;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.istock',' ',1629731533399012380,'布尔型',29,'是否库存数据','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012381;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.isdemand',' ',1629731533399012381,'布尔型',30,'是否预测需求','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012382;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.ecnversion','pdm_ecnversion',1629731533399012382,'基础资料',31,'ECN版本',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012383;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.demandsourcetype',' ',1629731533399012383,'下拉列表',32,'来源号.需求类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012384;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.materialname',' ',1629731533399012384,'文本型',33,'来源号.物料名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012385;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.materialnumber',' ',1629731533399012385,'文本型',34,'来源号.物料编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012386;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.productorgname',' ',1629731533399012386,'文本型',35,'来源号.生产组织名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012387;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.productorgnumber',' ',1629731533399012387,'文本型',36,'来源号.生产组织编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012388;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.mdsdemandtype','mds_dmtp',1629731533399012388,'基础资料',37,'需求类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012389;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.invaliddate',' ',1629731533399012389,'日期型',38,'失效时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012390;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.safeinvdays',' ',1629731533399012390,'整数',39,'安全库存展望期','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012391;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.safeinvtype',' ',1629731533399012391,'下拉列表',40,'安全库存类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012392;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.bomnumber','pdm_mftbom',1629731533399012392,'基础资料',41,'BOM编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012393;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.configuredcode','bd_configuredcode',1629731533399012393,'基础资料',42,'配置号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012394;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.configproperties',' ',1629731533399012394,'下拉列表',43,'配置属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012395;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.recqty',' ',1629731533399012395,'数量型',44,'领料数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012396;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.supplybillid',' ',1629731533399012396,'文本型',45,'供应单据ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012397;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1629731533172519936,'entryentity.owner',' ',1629731533399012397,'组织',46,'货主',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012398;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.materialflexprops',' ',1629731533399012398,'弹性域',47,'物料辅助属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012399;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.flexmetricid',' ',1629731533399012399,'文本型',48,'弹性维度ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012400;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1629731533172519936,'entryentity.flexmetricvalue',' ',1629731533399012400,'文本型',49,'弹性维度值',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012401;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.isdependentreq',' ',1629731533399012401,'下拉列表',50,'启用独立需求替代',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012402;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1629731533172519936,'entryentity.is_null_supply_match',' ',1629731533399012402,'下拉列表',51,'供应字段值为空允许匹配需求',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1629731533399012403;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1629731533172519936,'entryentity.bomreversion','bd_bomversion_new',1629731533399012403,'基础资料',52,'BOM子项版本',' '); 




IF NOT EXISTS (SELECT 1 FROM t_mrp_rsregister WHERE FID = 1629731533172519936) 
INSERT INTO t_mrp_rsregister(FBITINDEX,FTYPE,FDATABASENTITY,FCREATEORGID,FDATARESOLVERID,FMASTERID,FCTRLSTRATEGY,FBUSINESSENTITY,FCREATETIME,FMATCHRESOLVERID,FENABLE,FOUTPUTTYPE,FID,FVERSION,FOUTPUTMAPPING,FBUSINESSTYPE,FSOURCEDATAID,FORGID,FFIELDTYPE,FSTATUS,FNUMBER,FOUTTOSUPPLY,FSOURCEBITINDEX,FRELATIVETRANSFER,FMODIFIERID,FMODIFYTIME,FRELATIVERESOURCE,FCREATORID) VALUES (0,'02',' ',100000,0,1629731533172519936,'5','mrp_demandbill_model_eco',{ts'2018-08-08  08:08:08'},0,'1',' ',1629731533172519936,' ',0,'09',0,100000,'1','C','eco_estimate_require',0,0,0,1,{ts'2018-08-08  08:08:08'},0,1); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_rsregister WHERE FID = 1630325143907625984) 
INSERT INTO t_mrp_rsregister(FBITINDEX,FTYPE,FDATABASENTITY,FCREATEORGID,FDATARESOLVERID,FMASTERID,FCTRLSTRATEGY,FBUSINESSENTITY,FCREATETIME,FMATCHRESOLVERID,FENABLE,FOUTPUTTYPE,FID,FVERSION,FOUTPUTMAPPING,FBUSINESSTYPE,FSOURCEDATAID,FORGID,FFIELDTYPE,FSTATUS,FNUMBER,FOUTTOSUPPLY,FSOURCEBITINDEX,FRELATIVETRANSFER,FMODIFIERID,FMODIFYTIME,FRELATIVERESOURCE,FCREATORID) VALUES (0,'01',' ',100000,0,1630325143907625984,'5','mrp_supply_model_eco',{ts'2018-08-08  08:08:08'},0,'1',' ',1630325143907625984,' ',0,'09',0,100000,'1','C','eco_estimate_sypply',0,0,0,1,{ts'2018-08-08  08:08:08'},0,1); 

--插入U表
insert into t_mrp_rsregister_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_rsregister a
where fid in(1630325143907625984,1629731533172519936)
and a.fctrlstrategy = '5'
and not exists(select 1 from t_mrp_rsregister_u b
where b.fdataid = a.fid  and b.fuseorgid = a.fcreateorgid
);

update t_mrp_rsregister set  ffieldtype = 'pdm' WHERE FID = 1629731533172519936;
update t_mrp_rsregister set  ffieldtype = 'pdm' WHERE FID = 1630325143907625984;

DELETE FROM t_mrp_rsregister_l WHERE FPKID = '335WAT8/EKA7';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629731533172519936,'335WAT8/EKA7','zh_CN','工程变更评估需求模型'); 
DELETE FROM t_mrp_rsregister_l WHERE FPKID = '335WAT8/EKA8';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629731533172519936,'335WAT8/EKA8','zh_TW','工程變更評估需求模型'); 
DELETE FROM t_mrp_rsregister_l WHERE FPKID = '338Q8ESZ=QY9';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1630325143907625984,'338Q8ESZ=QY9','zh_CN','工程变更评估供应模型'); 
DELETE FROM t_mrp_rsregister_l WHERE FPKID = '338Q8ESZ=QY=';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1630325143907625984,'338Q8ESZ=QY=','zh_TW','工程變更評估供應模型'); 






--算法注册配置
IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID = 1629736859787606016) 
INSERT INTO t_mrp_algoregister(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FALGOIMPLETCALSS,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FALGOTYPE,FMODIFYTIME,FAPPID,FCREATORID) VALUES (1629736859787606016,0,' ',100000,0,1629736859787606016,100000,'1','C','5','ecoestimate_getsupply','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEstimateGetSupplyData',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID = 1629738413718540288) 
INSERT INTO t_mrp_algoregister(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FALGOIMPLETCALSS,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FALGOTYPE,FMODIFYTIME,FAPPID,FCREATORID) VALUES (1629738413718540288,0,' ',100000,0,1629738413718540288,100000,'1','C','5','ecoestimate_getrequire','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEstimateGetRequireData',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID = 1629739468762134528) 
INSERT INTO t_mrp_algoregister(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FALGOIMPLETCALSS,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FALGOTYPE,FMODIFYTIME,FAPPID,FCREATORID) VALUES (1629739468762134528,0,' ',100000,0,1629739468762134528,100000,'1','C','5','ecoestimate_srbalance','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEstimateSRBalance',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID = 1642081874765440000) 
INSERT INTO t_mrp_algoregister(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FALGOIMPLETCALSS,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FALGOTYPE,FMODIFYTIME,FAPPID,FCREATORID) VALUES (1642081874765440000,0,' ',100000,0,1642081874765440000,100000,'1','C','5','ecoestimate_writedata','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEstimateWriteData',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID = 1686906763229540352) 
INSERT INTO t_mrp_algoregister(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FALGOIMPLETCALSS,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FALGOTYPE,FMODIFYTIME,FAPPID,FCREATORID) VALUES (1686906763229540352,0,' ',100000,0,1686906763229540352,100000,'1','C','5','ecoestimate_clearhisdata','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEstimateClearData',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID = 1701645100439842816) 
INSERT INTO t_mrp_algoregister(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FALGOIMPLETCALSS,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FALGOTYPE,FMODIFYTIME,FAPPID,FCREATORID) VALUES (1701645100439842816,0,' ',100000,0,1701645100439842816,100000,'1','C','5','ecoestimate_effectorder','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEstimateUpdateOrder',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 


update t_mrp_algoregister set  ffieldtype = 'pdm' WHERE FID = 1629736859787606016;
update t_mrp_algoregister set  ffieldtype = 'pdm' WHERE FID = 1629738413718540288;
update t_mrp_algoregister set  ffieldtype = 'pdm' WHERE FID = 1629739468762134528;
update t_mrp_algoregister set  ffieldtype = 'pdm' WHERE FID = 1642081874765440000;
update t_mrp_algoregister set  ffieldtype = 'pdm' WHERE FID = 1686906763229540352;
update t_mrp_algoregister set  ffieldtype = 'pdm' WHERE FID = 1701645100439842816;

--插入U表
insert into t_mrp_algoregister_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_algoregister a
where fid in(1629739468762134528,1629738413718540288,1629736859787606016,1642081874765440000,1686906763229540352,1701645100439842816)
and a.fctrlstrategy = '5'
and not exists(select 1 from t_mrp_algoregister_u b
where b.fdataid = a.fid  and b.fuseorgid = a.fcreateorgid
);

DELETE FROM t_mrp_algoregister_l WHERE FPKID = '335XLYK44DCP';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1629738413718540288,'335XLYK44DCP','zh_TW','依據工程變更需求模型的配置，結合評估方案的展望期及需求參數，獲取對應的需求數據.','獲取工程變更需求數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '335XLYK44DCQ';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1629738413718540288,'335XLYK44DCQ','zh_CN','依据工程变更需求模型的配置，结合评估方案的展望期及需求参数，获取对应的需求数据.','获取工程变更需求数据'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '335XTMDPNC9=';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1629739468762134528,'335XTMDPNC9=','zh_CN','依据工程变更的供应与需求数据进行供需供货运算后获取断点时间，存入评估结果表.','对需求与供应数据进行断点评估'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '335XTMDPNC9A';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1629739468762134528,'335XTMDPNC9A','zh_TW','依據工程變更的供應與需求數據進行供需供貨運算後獲取斷點時間，存入評估結果表.','對需求與供應數據進行斷點評估'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '335XAM/G/0FR';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1629736859787606016,'335XAM/G/0FR','zh_CN','获取工程变更维护及工程变更BOM等数据作为评估运算的供应数据.','获取工程变更供应数据'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '335XAM/G/0FS';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1629736859787606016,'335XAM/G/0FS','zh_TW','獲取工程變更維護及工程變更BOM等數據作為評估運算的供應數據.','獲取工程變更供應數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '34P0YIKCXQ0V';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1642081874765440000,'34P0YIKCXQ0V','zh_CN','供需平衡匹配评估运算完毕后将评估结果回写ECN并更新制造BOM.','回写工程变更单及更新相关数据'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '34P0YIKCXQ0W';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1642081874765440000,'34P0YIKCXQ0W','zh_TW','供需平衡匹配評估運算完畢後將評估結果回寫ECN並更新製造BOM.','回寫工程變更單及更新相關數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '3=6T9Q=9PPIA';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1686906763229540352,'3=6T9Q=9PPIA','zh_CN','清除若干天前的历史运算日志及评估运算数据，参数由产品数据管理参数ECNLogSaveDays确定.','清除历史数据'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '3=6T9Q=9PPIB';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1686906763229540352,'3=6T9Q=9PPIB','zh_TW','清除若幹天前的曆史運算日誌及評估運算數據，參數由產品數據管理參數ECNLogSaveDays確定.','清除曆史數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '3B/E1QNQ2=OQ';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1701645100439842816,'3B/E1QNQ2=OQ','zh_TW','評估運算完畢後更新訂單相關數據','影響訂單數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FPKID = '3B/E1QNQ2=OR';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1701645100439842816,'3B/E1QNQ2=OR','zh_CN','评估运算完毕后更新订单相关数据','影响订单数据'); 


--业务方案配置
delete from t_mrp_businessplanentry WHERE FENTRYID in( 1629741027055122432,1629741027055122433,1629741027055122434,1642082429839630339);

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1701646331744889856) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1629741014287661056,1701646331744889856,1,1629738413718540288); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1701646331744889857) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1629741014287661056,1701646331744889857,2,1629739468762134528); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1701646331744889858) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1629741014287661056,1701646331744889858,3,1629736859787606016); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1701646331744889859) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1629741014287661056,1701646331744889859,4,1701645100439842816); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1701646331744889860) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1629741014287661056,1701646331744889860,5,1642081874765440000); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1701646331744889861) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1629741014287661056,1701646331744889861,6,1686906763229540352); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplan WHERE FID = 1629741014287661056) 
INSERT INTO t_mrp_businessplan(FID,FBITINDEX,FCELLSDATA_TAG,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FXML,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FXML_TAG,FCREATORID,FCELLSDATA) VALUES (1629741014287661056,0,'{"2":{"selectname":"","algomodel":""},"44458560bea5495cbc2be8f519f2b573":{"selectname":"获取工程变更需求数据","algomodel":"1629738413718540288"},"6":{"selectname":"","algomodel":""},"c2c34dca3cbd4a89911daf59bd42ecf2":{"selectname":"对需求与供应数据进行断点评估","algomodel":"1629739468762134528"},"7":{"selectname":"","algomodel":""},"17113bb3d5da40f589eee7fdd1dd23d4":{"selectname":"获取工程变更供应数据","algomodel":"1629736859787606016"},"146da5c462e44810a56bb8edab362172":{"selectname":"影响订单数据","algomodel":"1701645100439842816"},"46b337e799e74cfa861939859699371e":{"selectname":"回写工程变更单及更新相关数据","algomodel":"1642081874765440000"},"6dced10d6fab42ca98f988314548b007":{"selectname":"清除历史数据","algomodel":"1686906763229540352"}}',' ',100000,0,1629741014287661056,100000,'1','C','7','eco_eatimate_bizset',' ',{ts'2018-08-08  08:08:08'},0,1,'1',{ts'2018-08-08  08:08:08'},'<?xml version="1.0" encoding="UTF-8"?>
<root>
    
    
    <mxCell id="17113bb3d5da40f589eee7fdd1dd23d4" value="获取工程变更供应数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" parent="1" vertex="1">
      <mxGeometry x="430" y="10" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="44458560bea5495cbc2be8f519f2b573" value="获取工程变更需求数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" parent="1" vertex="1">
      <mxGeometry x="430" y="140" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="c2c34dca3cbd4a89911daf59bd42ecf2" value="对需求与供应数据进行断点评估" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" parent="1" vertex="1">
      <mxGeometry x="430" y="260" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="2" parent="1" source="17113bb3d5da40f589eee7fdd1dd23d4" target="44458560bea5495cbc2be8f519f2b573" edge="1">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
    <mxCell id="3" parent="1" source="44458560bea5495cbc2be8f519f2b573" target="c2c34dca3cbd4a89911daf59bd42ecf2" edge="1">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
    <mxCell id="46b337e799e74cfa861939859699371e" value="回写工程变更单及更新相关数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" parent="1" vertex="1">
      <mxGeometry x="430" y="380" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="4" parent="1" source="c2c34dca3cbd4a89911daf59bd42ecf2" target="46b337e799e74cfa861939859699371e" edge="1">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
    <mxCell id="6dced10d6fab42ca98f988314548b007" value="清除历史数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" parent="1" vertex="1">
      <mxGeometry x="420" y="550" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="146da5c462e44810a56bb8edab362172" value="影响订单数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" vertex="1" parent="1">
      <mxGeometry x="420" y="480" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="6" edge="1" parent="1" source="146da5c462e44810a56bb8edab362172" target="6dced10d6fab42ca98f988314548b007">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
    <mxCell id="7" edge="1" parent="1" source="46b337e799e74cfa861939859699371e" target="146da5c462e44810a56bb8edab362172">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
  </root>',1,' '); 


--插入U表
insert into t_mrp_businessplan_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_businessplan a
where fid in(1629741014287661056)
and not exists(select 1 from t_mrp_businessplan_u b
where b.fdataid = a.fid  and b.fuseorgid = a.fcreateorgid
);

DELETE FROM t_mrp_businessplan_l WHERE FPKID = '335Y2WMU0PCD';
INSERT INTO t_mrp_businessplan_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629741014287661056,'335Y2WMU0PCD','zh_CN','工程变更评估业务方案配置'); 
DELETE FROM t_mrp_businessplan_l WHERE FPKID = '335Y2WMU0PCE';
INSERT INTO t_mrp_businessplan_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629741014287661056,'335Y2WMU0PCE','zh_TW','工程變更評估業務方案配置'); 

update t_mrp_businessplan set  ffieldtype = 'pdm' WHERE FID = 1629741014287661056;



--计算方案配置
IF NOT EXISTS (SELECT 1 FROM t_mrp_calplanconfigentry WHERE FENTRYID = 1631882136418028544) 
INSERT INTO t_mrp_calplanconfigentry(FRUNTYPE,FID,FENTRYID,FSEQ,FBIZPLAN) VALUES ('pdm_ecoestimate_exec',1631882136384474112,1631882136418028544,1,1629741014287661056); 


IF NOT EXISTS (SELECT 1 FROM t_mrp_calplanconfig WHERE FID = 1631882136384474112) 
INSERT INTO t_mrp_calplanconfig(FID,FBITINDEX,FVERSION,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID) VALUES (1631882136384474112,0,' ',100000,0,1631882136384474112,100000,'1','C','5','ecoestimate',{ts'2018-08-08  08:08:08'},0,1,'1',{ts'2018-08-08  08:08:08'},1); 

--插入U表
insert into t_mrp_calplanconfig_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_calplanconfig a
where fid in(1631882136384474112)
and not exists(select 1 from t_mrp_calplanconfig_u b
where b.fdataid = a.fid  and b.fuseorgid = a.fcreateorgid
);

IF NOT EXISTS (SELECT 1 FROM t_mrp_calplanconfig_l WHERE FPKID = '33F6573QAJCB') 
INSERT INTO t_mrp_calplanconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1631882136384474112,'33F6573QAJCB','zh_CN','工程变更评估计算方案'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_calplanconfig_l WHERE FPKID = '33F6573QAJCC') 
INSERT INTO t_mrp_calplanconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1631882136384474112,'33F6573QAJCC','zh_TW','工程變更評估計算方案'); 

update t_mrp_calplanconfig set  ffieldtype = 'pdm' WHERE FID = 1631882136384474112;





--数据源配置
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID = 1630325144368998400) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1630325144368998400,' ',0,'C','DS-01-ecoinit',1630316068482345984,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1630325143907625984,'0','mrp',1,'{"filterRow":[{"id":"3JX2MUB=CTBR","leftBracket":"","compareType":"105","fieldName":"ecobomdata.entrymode","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87I","value":"E"}],"baseDataIds":[]},{"id":"3JX2MUBD/7J9","leftBracket":"","compareType":"106","fieldName":"ecobomdata.estimatestatus","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87J","value":"C"}],"baseDataIds":[]},{"id":"3JX2MUBD/7J=","leftBracket":"","compareType":"105","fieldName":"ecotype.statustype","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87K","value":"B"}],"baseDataIds":[]},{"id":"3JX2MUBD/7JA","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87L","value":"C"}],"baseDataIds":[]}],"forList":false}'); 

--更新数据
update t_mrp_rsdataconfig set FLARGETEXTFIELD_TAG = '{"filterRow":[{"id":"3JX2MUB=CTBR","leftBracket":"","compareType":"105","fieldName":"ecobomdata.entrymode","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87I","value":"E"}],"baseDataIds":[]},{"id":"3JX2MUBD/7J9","leftBracket":"","compareType":"106","fieldName":"ecobomdata.estimatestatus","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87J","value":"C"}],"baseDataIds":[]},{"id":"3JX2MUBD/7J=","leftBracket":"","compareType":"105","fieldName":"ecotype.statustype","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87K","value":"B"}],"baseDataIds":[]},{"id":"3JX2MUBD/7JA","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3JX2MUBD/87L","value":"C"}],"baseDataIds":[]}],"forList":false}'
where FID = 1630325144368998400 and FMODIFIERID = 1;



IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID = 1629731538146964480) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1629731538146964480,' ',0,'C','DS-03-ecoinit',1629615712911787008,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1629731533172519936,'0','mrp',1,'{"filterRow":[{"id":"3JX2QH8OSPYS","leftBracket":"","compareType":"105","fieldName":"iscannegative","rightBracket":"","logic":"0","value":[{"id":"3JX2QH8OSQM0","value":"0"}],"baseDataIds":[]},{"id":"3JX2QH8OSPYT","leftBracket":"","compareType":"106","fieldName":"issuemode","rightBracket":"","logic":"0","value":[{"id":"3JX2QH8OSQM1","value":"C"}],"baseDataIds":[]},{"id":"3JX2QH8OSPYU","leftBracket":"","compareType":"105","fieldName":"orderentryid.planstatus","rightBracket":"","logic":"0","value":[{"id":"3JX2QH8OSQM2","value":"C"}],"baseDataIds":[]},{"id":"3JX2QH8OSPYV","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3JX2QH8OSQM3","value":"C"}],"baseDataIds":[]}],"forList":false}'); 

--更新数据
update t_mrp_rsdataconfig set FLARGETEXTFIELD_TAG = 
'{"filterRow":[{"id":"3KIU=QPH83GM","leftBracket":"","compareType":"105","fieldName":"iscannegative","rightBracket":"","logic":"0","value":[{"id":"3KIU=QPH82TC","value":"0"}],"baseDataIds":[]},{"id":"3KIU=QPH83GN","leftBracket":"","compareType":"105","fieldName":"orderentryid.planstatus","rightBracket":"","logic":"0","value":[{"id":"3KIU=QPH82TD","value":"C"}],"baseDataIds":[]},{"id":"3KIU=QPH83GO","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3KIU=QPH82TE","value":"C"}],"baseDataIds":[]}],"forList":false}'
where FID = 1629731538146964480 and FMODIFIERID = 1;





IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID = 1629731538146964481) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1629731538146964481,' ',0,'C','DS-02-ecoinit',1629584990415105024,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1629731533172519936,'0','mrp',1,'{"filterRow":[{"id":"3JX2P654ANJI","leftBracket":"","compareType":"105","fieldName":"iscannegative","rightBracket":"","logic":"0","value":[{"id":"3JX2P657Z2E=","value":"0"}],"baseDataIds":[]},{"id":"3JX2P657Z1R0","leftBracket":"","compareType":"106","fieldName":"issuemode","rightBracket":"","logic":"0","value":[{"id":"3JX2P657Z2EA","value":"C"}],"baseDataIds":[]},{"id":"3JX2P657Z1R1","leftBracket":"","compareType":"105","fieldName":"orderentryid.planstatus","rightBracket":"","logic":"0","value":[{"id":"3JX2P657Z2EB","value":"C"}],"baseDataIds":[]},{"id":"3JX2P657Z1R2","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3JX2P657Z2EC","value":"C"}],"baseDataIds":[]}],"forList":false}'); 

--更新数据
update t_mrp_rsdataconfig set FLARGETEXTFIELD_TAG = 
'{"filterRow":[{"id":"3K+EN1BCZS2Z","leftBracket":"","compareType":"105","fieldName":"iscannegative","rightBracket":"","logic":"0","value":[{"id":"3K+EN1BCZSS7","value":"0"}],"baseDataIds":[]},{"id":"3K+EN1BCZS3+","leftBracket":"","compareType":"105","fieldName":"orderentryid.planstatus","rightBracket":"","logic":"0","value":[{"id":"3K+EN1BCZSS8","value":"C"}],"baseDataIds":[]},{"id":"3K+EN1BCZS3/","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3K+EN1BCZSS9","value":"C"}],"baseDataIds":[]}],"forList":false}'
where FID = 1629731538146964481 and FMODIFIERID = 1;

DELETE FROM t_mrp_rsdataconfig_l WHERE FPKID = '335WAUKMRKBG';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629731538146964480,'335WAUKMRKBG','zh_CN','生产组件清单'); 
DELETE FROM t_mrp_rsdataconfig_l WHERE FPKID = '335WAUKMRKBH';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629731538146964481,'335WAUKMRKBH','zh_CN','委外组件清单'); 
DELETE FROM t_mrp_rsdataconfig_l WHERE FPKID = '338Q8EXSVBM6';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1630325144368998400,'338Q8EXSVBM6','zh_CN','工程变更单及ECOBOM供应数据源'); 




