--工程变更影响范围，实体字段映射、资源注册模型、数据源等数据预置数据

--删除之前预置错了的历史数据：实体字段映射
DELETE FROM t_mrp_billtranferentry WHERE FID IN(1807325811670269952,1807328500797991936,1807335125726325760,1807333779967110144,1807363251369948160,1807361488738857984,1807339722490571776,1814015864777851904);
DELETE FROM t_mrp_bftransfer WHERE FID IN(1807325811670269952,1807328500797991936,1807335125726325760,1807333779967110144,1807363251369948160,1807361488738857984,1807339722490571776,1814015864777851904);
DELETE FROM t_mrp_bftransfer_l WHERE FID IN(1807325811670269952,1807328500797991936,1807335125726325760,1807333779967110144,1807363251369948160,1807361488738857984,1807339722490571776,1814015864777851904);

--删除之前预置错了的历史数据:数据源配置
DELETE FROM t_mrp_rsdataconfig  WHERE FID IN ( 1807376678352074752,1807374672854005760,1807374672854005761,1807374672854005762,1807374672854005763,1807374672854005764);
DELETE FROM t_mrp_rsdataconfig_l  WHERE FID IN ( 1807376678352074752,1807374672854005760,1807374672854005761,1807374672854005762,1807374672854005763,1807374672854005764);

--删除之前预置错了的历史数据 资源注册模型
DELETE FROM t_mrp_rsregister WHERE FID IN ( 1807376677941032960,1807374671822206976);
DELETE FROM t_mrp_rsregister_l WHERE FID IN ( 1807376677941032960,1807374671822206976);



--新预置数据的插入：
--1，工程变更影响范围子项物料_工程变更维护
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509824;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.material',1808043232194509824,' ',' ','pentry.ecobomdata.entry.entrymaterialid','{"expression":"pentry.ecobomdata.entry.entrymaterialid","exprTran":"pentry.ecobomdata.entry.entrymaterialid","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrymaterialid"},"exprDesc":"pentry.ecobomdata.entry.entrymaterialid"}',' ','pentry.ecobomdata.entry.entrymaterialid',1,'单据体.物料','entryentity.material','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509825;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billid',1808043232194509825,' ',' ','id','{"expression":"id","exprTran":"工程变更维护.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护.内码"},"exprDesc":"工程变更维护.内码"}',' ','工程变更维护.内码',2,'单据体.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509826;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billdate',1808043232194509826,' ',' ','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',3,'单据体.实施时间','entryentity.billdate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509827;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.productionorgunit',1808043232194509827,'org','org',' ',' ','单据头.创建组织',' ',4,'单据体.需求组织','entryentity.productionorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509828;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billnumber',1808043232194509828,'billno','billno',' ',' ','单据头.工程变更编号',' ',5,'单据体.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509829;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.demandqty',1808043232194509829,' ',' ','pentry.ecobomdata.entry.tranqty','{"expression":"pentry.ecobomdata.entry.tranqty","exprTran":"pentry.ecobomdata.entry.tranqty","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.tranqty"},"exprDesc":"pentry.ecobomdata.entry.tranqty"}',' ','pentry.ecobomdata.entry.tranqty',6,'单据体.需求基本数量','entryentity.demandqty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509830;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.baseunit',1808043232194509830,' ',' ','pentry.ecobomdata.entry.entryunit','{"expression":"pentry.ecobomdata.entry.entryunit","exprTran":"pentry.ecobomdata.entry.entryunit","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryunit"},"exprDesc":"pentry.ecobomdata.entry.entryunit"}',' ','pentry.ecobomdata.entry.entryunit',7,'单据体.基本计量单位','entryentity.baseunit','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509831;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.materialattr',1808043232194509831,' ',' ','pentry.ecobomdata.entry.entrymaterialattr','{"expression":"pentry.ecobomdata.entry.entrymaterialattr","exprTran":"pentry.ecobomdata.entry.entrymaterialattr","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrymaterialattr"},"exprDesc":"pentry.ecobomdata.entry.entrymaterialattr"}',' ','pentry.ecobomdata.entry.entrymaterialattr',8,'单据体.物料属性','entryentity.materialattr','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509832;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billtype',1808043232194509832,' ',' ','1631966120074281984','{"expression":"1631966120074281984","exprTran":"工程变更维护","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护"},"exprDesc":"工程变更维护"}',' ','工程变更维护',9,'单据体.单据类型','entryentity.billtype','3'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509833;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billstatusfield',1808043232194509833,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',10,'单据体.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509834;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billentryid',1808043232194509834,' ',' ','pentry.id','{"expression":"pentry.id","exprTran":"产品.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"产品.内码"},"exprDesc":"产品.内码"}',' ','产品.内码',11,'单据体.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509835;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.billentryseq',1808043232194509835,' ',' ','pentry.ecobomdata.entry.entryseq','{"expression":"pentry.ecobomdata.entry.entryseq","exprTran":"pentry.ecobomdata.entry.entryseq","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryseq"},"exprDesc":"pentry.ecobomdata.entry.entryseq"}',' ','pentry.ecobomdata.entry.entryseq',12,'单据体.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509836;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.bomnumber',1808043232194509836,' ',' ','pentry.pentrybom.number','{"expression":"pentry.pentrybom.number","exprTran":"BOM编码","description":{"zh_CN":""},"exprDesc":"BOM编码","localeExprTran":{"zh_CN":"BOM编码"}}',' ','BOM编码',13,'单据体.BOM编码','entryentity.bomnumber','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509837;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.configuredcode',1808043232194509837,' ',' ','pentry.ecobomdata.entry.entryconfiguredcode','{"expression":"pentry.ecobomdata.entry.entryconfiguredcode","exprTran":"pentry.ecobomdata.entry.entryconfiguredcode","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryconfiguredcode"},"exprDesc":"pentry.ecobomdata.entry.entryconfiguredcode"}',' ','pentry.ecobomdata.entry.entryconfiguredcode',14,'单据体.配置号','entryentity.configuredcode','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509838;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.materialflexprops',1808043232194509838,' ',' ','pentry.ecobomdata.entry.entryauxproperty','{"expression":"pentry.ecobomdata.entry.entryauxproperty","exprTran":"pentry.ecobomdata.entry.entryauxproperty","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryauxproperty"},"exprDesc":"pentry.ecobomdata.entry.entryauxproperty"}',' ','pentry.ecobomdata.entry.entryauxproperty',15,'单据体.物料辅助属性','entryentity.materialflexprops','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509839;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.bomreversion',1808043232194509839,' ',' ','pentry.ecobomdata.entry.entryversion','{"expression":"pentry.ecobomdata.entry.entryversion","exprTran":"pentry.ecobomdata.entry.entryversion","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entryversion"},"exprDesc":"pentry.ecobomdata.entry.entryversion"}',' ','pentry.ecobomdata.entry.entryversion',16,'单据体.BOM子项版本','entryentity.bomreversion','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509840;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.ecotypeid',1808043232194509840,' ',' ','pentry.ecotype.id','{"expression":"pentry.ecotype.id","exprTran":"pentry.ecotype.id","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecotype.id"},"exprDesc":"pentry.ecotype.id"}',' ','pentry.ecotype.id',17,'单据体.工程变更类型ID','entryentity.ecotypeid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509841;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.ecobomentryid',1808043232194509841,' ',' ','pentry.ecobomdata.entry.id','{"expression":"pentry.ecobomdata.entry.id","exprTran":"pentry.ecobomdata.entry.id","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.id"},"exprDesc":"pentry.ecobomdata.entry.id"}',' ','pentry.ecobomdata.entry.id',18,'单据体.ecoBom分录ID','entryentity.ecobomentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509842;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.ecobomid',1808043232194509842,'pentry.ecobomid','pentry.ecobomid',' ',' ','产品.变更BOMID',' ',19,'单据体.ecobomid','entryentity.ecobomid','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509843;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.entrymode',1808043232194509843,' ',' ','pentry.ecobomdata.entry.entrymode','{"expression":"pentry.ecobomdata.entry.entrymode","exprTran":"pentry.ecobomdata.entry.entrymode","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrymode"},"exprDesc":"pentry.ecobomdata.entry.entrymode"}',' ','pentry.ecobomdata.entry.entrymode',20,'单据体.行标识','entryentity.entrymode','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509844;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.featuretype',1808043232194509844,' ',' ','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 = 1808043232194509845;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.entryvaliddate',1808043232194509845,' ',' ','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',22,'单据体.生效日期','entryentity.entryvaliddate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509846;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.entryinvaliddate',1808043232194509846,' ',' ','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',23,'单据体.失效日期','entryentity.entryinvaliddate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808043232194509847;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808043232127400960,'entryentity.bomentryid',1808043232194509847,' ',' ','pentry.ecobomdata.entry.entrybomentryid','{"expression":"pentry.ecobomdata.entry.entrybomentryid","exprTran":"pentry.ecobomdata.entry.entrybomentryid","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.entry.entrybomentryid"},"exprDesc":"pentry.ecobomdata.entry.entrybomentryid"}',' ','pentry.ecobomdata.entry.entrybomentryid',24,'单据体.BOM分录的ID','entryentity.bomentryid','1'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808043232127400960;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808043232127400960) 
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 (1808043232127400960,0,' ',' ',100000,0,1808043232127400960,100000,'pdm','C','5','ys_ecoeffectrange_c_pdm_eco','pdm_bom_eco','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_demand_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808043232127400960 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808043232127400960,'3O2533+88K2X','zh_CN','工程变更影响范围子项物料_工程变更维护'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808043232127400960 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808043232127400960,'3O2533+88K2Y','zh_TW','工程變更影響範圍子項物料_工程變更維護'); 






--2，工程变更影响范围父项物料_工程变更维护
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402624;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.material',1837786940133402624,' ',' ','pentry.proentrymaterialid ','{"expression":"pentry.proentrymaterialid ","exprTran":"产品编码 ","description":{"zh_CN":""},"exprDesc":"产品编码 ","localeExprTran":{"zh_CN":"产品编码 "}}',' ','产品编码 ',1,'单据体.物料','entryentity.material','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402625;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billid',1837786940133402625,' ',' ','id','{"expression":"id","exprTran":"工程变更维护.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护.内码"},"exprDesc":"工程变更维护.内码"}',' ','工程变更维护.内码',2,'单据体.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402626;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billdate',1837786940133402626,' ',' ',' pentry.pentryvaliddate ','{"expression":" pentry.pentryvaliddate ","exprTran":" 生效时间 ","description":{"zh_CN":""},"exprDesc":" 生效时间 ","localeExprTran":{"zh_CN":" 生效时间 "}}',' ',' 生效时间 ',3,'单据体.需求日期','entryentity.billdate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402627;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.productionorgunit',1837786940133402627,'org','org',' ',' ','单据头.创建组织',' ',4,'单据体.需求组织','entryentity.productionorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402628;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billnumber',1837786940133402628,'billno','billno',' ',' ','单据头.工程变更编号',' ',5,'单据体.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402629;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.demandqty',1837786940133402629,' ',' ','0','{"expression":"0","exprTran":"0","description":{"zh_CN":""},"exprDesc":"0","localeExprTran":{"zh_CN":"0"}}',' ','0',6,'单据体.需求基本数量','entryentity.demandqty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402630;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.baseunit',1837786940133402630,' ',' ','pentry.proentrymaterialid.baseunit ','{"expression":"pentry.proentrymaterialid.baseunit ","exprTran":"基本单位 ","description":{"zh_CN":""},"exprDesc":"基本单位 ","localeExprTran":{"zh_CN":"基本单位 "}}',' ','基本单位 ',7,'单据体.基本计量单位','entryentity.baseunit','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402631;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.materialattr',1837786940133402631,' ',' ','pentry.proentrymaterial.materialattr','{"expression":"pentry.proentrymaterial.materialattr","exprTran":"物料属性","description":{"zh_CN":""},"exprDesc":"物料属性","localeExprTran":{"zh_CN":"物料属性"}}',' ','物料属性',8,'单据体.物料属性','entryentity.materialattr','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402632;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billtype',1837786940133402632,' ',' ','1631966120074281984','{"expression":"1631966120074281984","exprTran":"工程变更维护","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护"},"exprDesc":"工程变更维护"}',' ','工程变更维护',9,'单据体.单据类型','entryentity.billtype','3'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402633;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billstatusfield',1837786940133402633,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',10,'单据体.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402634;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billentryid',1837786940133402634,' ',' ','pentry.id','{"expression":"pentry.id","exprTran":"产品.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"产品.内码"},"exprDesc":"产品.内码"}',' ','产品.内码',11,'单据体.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402635;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.billentryseq',1837786940133402635,' ',' ','pentry.seq','{"expression":"pentry.seq","exprTran":"产品.序号","description":{"zh_CN":""},"exprDesc":"产品.序号","localeExprTran":{"zh_CN":"产品.序号"}}',' ','产品.序号',12,'单据体.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402637;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.materialflexprops',1837786940133402637,' ',' ','pentry.bomauxproperty','{"expression":"pentry.bomauxproperty","exprTran":"辅助属性","description":{"zh_CN":""},"exprDesc":"辅助属性","localeExprTran":{"zh_CN":"辅助属性"}}',' ','辅助属性',13,'单据体.物料辅助属性','entryentity.materialflexprops','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1837786940133402638;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.ecotypeid',1837786940133402638,' ',' ','pentry.ecotype.id','{"expression":"pentry.ecotype.id","exprTran":"pentry.ecotype.id","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecotype.id"},"exprDesc":"pentry.ecotype.id"}',' ','pentry.ecotype.id',14,'单据体.工程变更类型ID','entryentity.ecotypeid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1874561620550627328;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1837786940099848192,'entryentity.bomnumber',1874561620550627328,' ',' ','pentry.pentrybom.number','{"expression":"pentry.pentrybom.number","exprTran":"BOM编码","description":{"zh_CN":""},"exprDesc":"BOM编码","localeExprTran":{"zh_CN":"BOM编码"}}',' ','BOM编码',15,'单据体.BOM编码','entryentity.bomnumber','1'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1837786940099848192) 
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 (1837786940099848192,0,' ',' ',100000,0,1837786940099848192,100000,'pdm','C','5','ys_ecoeffectrange_p_pdm_eco','pdm_bom_eco','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_demand_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1837786940099848192 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1837786940099848192,'3RQNL+QZZQHB','zh_CN','工程变更影响范围父项物料_工程变更维护'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1837786940099848192 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1837786940099848192,'3RQNL+QZZQHC','zh_TW','工程變更影響範圍父項物料_工程變更維護'); 






--3，程变更影响范围_即时库存
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338944;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.material',1808047290544338944,'material','material',' ',' ','单据头.物料',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338945;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.supplyorgunit',1808047290544338945,'org','org',' ',' ','单据头.库存组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338946;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.billid',1808047290544338946,' ',' ','id','{"expression":"id","exprTran":"即时库存余额表.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"即时库存余额表.内码"},"exprDesc":"即时库存余额表.内码"}',' ','即时库存余额表.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338947;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.qty',1808047290544338947,'baseqty','baseqty',' ',' ','单据头.库存量（基本单位）',' ',4,'供应数据.预计入库基本数量','entryentity.qty','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338948;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.baseunit',1808047290544338948,'baseunit','baseunit',' ',' ','单据头.基本单位',' ',5,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338949;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.projectnumber',1808047290544338949,'project','project',' ',' ','单据头.项目',' ',6,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338950;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.tracknumber',1808047290544338950,'tracknumber','tracknumber',' ',' ','单据头.跟踪号',' ',7,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338951;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.istock',1808047290544338951,' ',' ','''1''','{"expression":"''1''","exprTran":"''1''","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"''1''"},"exprDesc":"''1''"}',' ','''1''',8,'供应数据.是否库存数据','entryentity.istock','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338952;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.stock',1808047290544338952,'warehouse','warehouse',' ',' ','单据头.仓库',' ',9,'供应数据.仓库','entryentity.stock','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338953;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.stockindex',1808047290544338953,'location','location',' ',' ','单据头.仓位',' ',10,'供应数据.仓位','entryentity.stockindex','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338954;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.stocktype',1808047290544338954,'invtype','invtype',' ',' ','单据头.库存类型',' ',11,'供应数据.库存类型','entryentity.stocktype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338955;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.stockstatus',1808047290544338955,'invstatus','invstatus',' ',' ','单据头.库存状态',' ',12,'供应数据.库存状态','entryentity.stockstatus','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338956;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.materialflexprops',1808047290544338956,'auxpty','auxpty',' ',' ','单据头.辅助属性',' ',13,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338957;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.configuredcode',1808047290544338957,'configuredcode','configuredcode',' ',' ','单据头.配置号',' ',14,'供应数据.配置号','entryentity.configuredcode','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808047290544338958;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.owner',1808047290544338958,'owner','owner',' ',' ','单据头.货主',' ',15,'供应数据.货主','entryentity.owner','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808770736924452864;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808047290527561728,'entryentity.billnumber',1808770736924452864,' ',' ','''即时库存''','{"expression":"''即时库存''","exprTran":"''即时库存''","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"''即时库存''"},"exprDesc":"''即时库存''"}',' ','''即时库存''',16,'供应数据.单据编码','entryentity.billnumber','1'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808047290527561728;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808047290527561728) 
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 (1808047290527561728,0,' ',' ',100000,0,1808047290527561728,100000,'pdm','C','5','ys_ecoeffectrange_inv_realbala','im_inv_realbalance','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808047290527561728 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808047290527561728,'3O25VOAZHDY4','zh_CN','工程变更影响范围_即时库存'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808047290527561728 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808047290527561728,'3O25VOAZHDY5','zh_TW','工程變更影響範圍_即時庫存'); 






--4，程变更影响范围_生产工单
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870912;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.material',1808051444104870912,'treeentryentity.materielmasterid','treeentryentity.materielmasterid',' ',' ','分录.物料(主数据)',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870913;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.supplyorgunit',1808051444104870913,'org','org',' ',' ','单据头.生产组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870914;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billid',1808051444104870914,' ',' ','id','{"expression":"id","exprTran":"生产工单.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"生产工单.内码"},"exprDesc":"生产工单.内码"}',' ','生产工单.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870915;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billdate',1808051444104870915,'treeentryentity.planendtime','treeentryentity.planendtime',' ',' ','分录.计划完工时间',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870917;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billnumber',1808051444104870917,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870918;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.baseunit',1808051444104870918,'treeentryentity.baseunit','treeentryentity.baseunit',' ',' ','分录.基本单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870919;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billtype',1808051444104870919,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870920;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billstatusfield',1808051444104870920,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870921;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billentryid',1808051444104870921,' ',' ','treeentryentity.id ','{"expression":"treeentryentity.id ","exprTran":"分录.内码 ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"分录.内码 "},"exprDesc":"分录.内码 "}',' ','分录.内码 ',10,'供应数据.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870922;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.billentryseq',1808051444104870922,' ',' ','treeentryentity.seq','{"expression":"treeentryentity.seq","exprTran":"分录.序号","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"分录.序号"},"exprDesc":"分录.序号"}',' ','分录.序号',11,'供应数据.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870923;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.projectnumber',1808051444104870923,'treeentryentity.bdproject','treeentryentity.bdproject',' ',' ','分录.项目号',' ',12,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870924;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.tracknumber',1808051444104870924,'treeentryentity.tracknumber','treeentryentity.tracknumber',' ',' ','分录.跟踪号',' ',13,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870925;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.materialflexprops',1808051444104870925,'treeentryentity.auxproperty','treeentryentity.auxproperty',' ',' ','分录.辅助属性',' ',14,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870926;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.yield',1808051444104870926,'treeentryentity.yieldrate','treeentryentity.yieldrate',' ',' ','分录.成品率',' ',15,'供应数据.成品率（%）','entryentity.yield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870927;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.configuredcode',1808051444104870927,'treeentryentity.configuredcode','treeentryentity.configuredcode',' ',' ','分录.配置号',' ',16,'供应数据.配置号','entryentity.configuredcode','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808051444104870916;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.qty',1808051444104870916,' ',' ',' treeentryentity.baseqty  -  treeentryentity.quainwaqty -  treeentryentity.unquainwaqty  -  treeentryentity.scrinwaqty  ','{"expression":" treeentryentity.baseqty  -  treeentryentity.quainwaqty -  treeentryentity.unquainwaqty  -  treeentryentity.scrinwaqty  ","exprTran":" 基本数量  -  合格品入库基本数量 -  不合格品入库基本数量  -  报废品入库基本数量  ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":" 基本数量  -  合格品入库基本数量 -  不合格品入库基本数量  -  报废品入库基本数量  "},"exprDesc":" 基本数量  -  合格品入库基本数量 -  不合格品入库基本数量  -  报废品入库基本数量  "}',' ',' 基本数量  -  合格品入库基本数量 -  不合格品入库基本数量  -  报废品入库基本数量  ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1813916400885031936;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808051444079705088,'entryentity.stock',1813916400885031936,'treeentryentity.warehouse','treeentryentity.warehouse',' ',' ','分录.仓库',' ',17,'供应数据.仓库','entryentity.stock','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808051444079705088;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808051444079705088) 
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 (1808051444079705088,0,' ',' ',100000,0,1808051444079705088,100000,'pdm','C','5','ys_ecoeffectrange_pom_mftorder','pom_mftorder','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808051444079705088 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808051444079705088,'3O26MYQZ6OUC','zh_CN','工程变更影响范围_生产工单'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808051444079705088 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808051444079705088,'3O26MYQZ6OUD','zh_TW','工程變更影響範圍_生產工單'); 



--5 工程变更影响范围_委外工单
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483392;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.material',1808053511351483392,'treeentryentity.materielmasterid','treeentryentity.materielmasterid',' ',' ','分录.物料(主数据)',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483393;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.supplyorgunit',1808053511351483393,'org','org',' ',' ','单据头.生产组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483394;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billid',1808053511351483394,' ',' ','id','{"expression":"id","exprTran":"委外工单.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"委外工单.内码"},"exprDesc":"委外工单.内码"}',' ','委外工单.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483395;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billdate',1808053511351483395,'treeentryentity.planendtime','treeentryentity.planendtime',' ',' ','分录.计划完工时间',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483397;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billnumber',1808053511351483397,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483398;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.baseunit',1808053511351483398,'treeentryentity.baseunit','treeentryentity.baseunit',' ',' ','分录.基本单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483399;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billtype',1808053511351483399,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483400;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billstatusfield',1808053511351483400,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483401;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billentryid',1808053511351483401,' ',' ','treeentryentity.id','{"expression":"treeentryentity.id","exprTran":"分录.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"分录.内码"},"exprDesc":"分录.内码"}',' ','分录.内码',10,'供应数据.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483402;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.billentryseq',1808053511351483402,' ',' ','treeentryentity.seq','{"expression":"treeentryentity.seq","exprTran":"分录.序号","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"分录.序号"},"exprDesc":"分录.序号"}',' ','分录.序号',11,'供应数据.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483403;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.projectnumber',1808053511351483403,'treeentryentity.bdproject','treeentryentity.bdproject',' ',' ','分录.项目号',' ',12,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483404;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.tracknumber',1808053511351483404,'treeentryentity.tracknumber','treeentryentity.tracknumber',' ',' ','分录.跟踪号',' ',13,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483405;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.materialflexprops',1808053511351483405,'treeentryentity.auxproperty','treeentryentity.auxproperty',' ',' ','分录.辅助属性',' ',14,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483406;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.yield',1808053511351483406,'treeentryentity.yieldrate','treeentryentity.yieldrate',' ',' ','分录.成品率',' ',15,'供应数据.成品率（%）','entryentity.yield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483407;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.configuredcode',1808053511351483407,'treeentryentity.configuredcode','treeentryentity.configuredcode',' ',' ','分录.配置号',' ',16,'供应数据.配置号','entryentity.configuredcode','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808053511351483396;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.qty',1808053511351483396,' ',' ','treeentryentity.baseqty  -  treeentryentity.quainwaqty -  treeentryentity.unquainwaqty -  treeentryentity.scrinwaqty  ','{"expression":"treeentryentity.baseqty  -  treeentryentity.quainwaqty -  treeentryentity.unquainwaqty -  treeentryentity.scrinwaqty  ","exprTran":"基本数量  -  合格品入库基本数量 -  不合格品入库基本数量 -  报废品入库基本数量  ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"基本数量  -  合格品入库基本数量 -  不合格品入库基本数量 -  报废品入库基本数量  "},"exprDesc":"基本数量  -  合格品入库基本数量 -  不合格品入库基本数量 -  报废品入库基本数量  "}',' ','基本数量  -  合格品入库基本数量 -  不合格品入库基本数量 -  报废品入库基本数量  ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1813922479773705216;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808053511334706176,'entryentity.stock',1813922479773705216,'treeentryentity.warehouse','treeentryentity.warehouse',' ',' ','分录.仓库',' ',17,'供应数据.仓库','entryentity.stock','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808053511334706176;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808053511334706176) 
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 (1808053511334706176,0,' ',' ',100000,0,1808053511334706176,100000,'pdm','C','5','ys_ecoeffectrange_om_mftorder','om_mftorder','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808053511334706176 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808053511334706176,'3O270/8=1G6=','zh_CN','工程变更影响范围_委外工单'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808053511334706176 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808053511334706176,'3O270/8=1G6A','zh_TW','工程變更影響範圍_委外工單'); 



--6，工程变更影响范围_采购申请单
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424448;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.material',1808056511176424448,'billentry.material.masterid','billentry.material.masterid',' ',' ','物料明细.物料编码.物料编码',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424449;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.supplyorgunit',1808056511176424449,'billentry.entryrecorg','billentry.entryrecorg',' ',' ','物料明细.收货组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424450;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billid',1808056511176424450,' ',' ','id','{"expression":"id","exprTran":"采购申请单.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"采购申请单.内码"},"exprDesc":"采购申请单.内码"}',' ','采购申请单.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424451;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billdate',1808056511176424451,'billentry.reqdate','billentry.reqdate',' ',' ','物料明细.需求日期',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424452;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.qty',1808056511176424452,' ',' ','billentry.baseqty -  billentry.orderbaseqty ','{"expression":"billentry.baseqty -  billentry.orderbaseqty ","exprTran":"基本数量 -  已订货基本数量 ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"基本数量 -  已订货基本数量 "},"exprDesc":"基本数量 -  已订货基本数量 "}',' ','基本数量 -  已订货基本数量 ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424453;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billnumber',1808056511176424453,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424454;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.baseunit',1808056511176424454,'billentry.baseunit','billentry.baseunit',' ',' ','物料明细.基本单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424455;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billtype',1808056511176424455,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424456;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billstatusfield',1808056511176424456,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424457;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billentryid',1808056511176424457,' ',' ','billentry.id','{"expression":"billentry.id","exprTran":"物料明细.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"物料明细.内码"},"exprDesc":"物料明细.内码"}',' ','物料明细.内码',10,'供应数据.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424458;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.billentryseq',1808056511176424458,' ',' ','billentry.seq','{"expression":"billentry.seq","exprTran":"物料明细.序号","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"物料明细.序号"},"exprDesc":"物料明细.序号"}',' ','物料明细.序号',11,'供应数据.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424459;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.projectnumber',1808056511176424459,'billentry.project','billentry.project',' ',' ','物料明细.项目',' ',12,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424460;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.tracknumber',1808056511176424460,'billentry.tracknumber','billentry.tracknumber',' ',' ','物料明细.跟踪号',' ',13,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424461;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.materialflexprops',1808056511176424461,'billentry.auxpty','billentry.auxpty',' ',' ','物料明细.辅助属性',' ',14,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424462;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.stock',1808056511176424462,'billentry.warehouse','billentry.warehouse',' ',' ','物料明细.收货仓库',' ',15,'供应数据.仓库','entryentity.stock','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808056511176424463;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808056511168035840,'entryentity.configuredcode',1808056511176424463,'billentry.configuredcode','billentry.configuredcode',' ',' ','物料明细.配置号',' ',16,'供应数据.配置号','entryentity.configuredcode','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808056511168035840;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808056511168035840) 
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 (1808056511168035840,0,' ',' ',100000,0,1808056511168035840,100000,'pdm','C','5','ys_ecoeffectrange_pm_purapply','pm_purapplybill','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808056511168035840 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808056511168035840,'3O27KVRV/DAH','zh_CN','工程变更影响范围_采购申请单'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808056511168035840 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808056511168035840,'3O27KVRV/DAI','zh_TW','工程變更影響範圍_采購申請單'); 



--7，工程变更影响范围_采购订单
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109824;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.material',1808058934620109824,'billentry.material.masterid','billentry.material.masterid',' ',' ','物料明细.物料编码.物料编码',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109825;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.supplyorgunit',1808058934620109825,'billentry.entryrecorg','billentry.entryrecorg',' ',' ','物料明细.收货组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109826;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billid',1808058934620109826,' ',' ','id','{"expression":"id","exprTran":"采购订单.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"采购订单.内码"},"exprDesc":"采购订单.内码"}',' ','采购订单.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109827;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billdate',1808058934620109827,'billentry.deliverdate','billentry.deliverdate',' ',' ','交货计划.收货日期',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109828;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.qty',1808058934620109828,' ',' ','billentry.baseqty  -  billentry.receivebaseqty  ','{"expression":"billentry.baseqty  -  billentry.receivebaseqty  ","exprTran":"基本数量  -  已收货基本数量  ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"基本数量  -  已收货基本数量  "},"exprDesc":"基本数量  -  已收货基本数量  "}',' ','基本数量  -  已收货基本数量  ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109829;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billnumber',1808058934620109829,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109830;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.baseunit',1808058934620109830,'billentry.baseunit','billentry.baseunit',' ',' ','物料明细.基本单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109831;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billtype',1808058934620109831,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109832;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billstatusfield',1808058934620109832,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109833;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billentryid',1808058934620109833,' ',' ','billentry.id','{"expression":"billentry.id","exprTran":"物料明细.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"物料明细.内码"},"exprDesc":"物料明细.内码"}',' ','物料明细.内码',10,'供应数据.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109834;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.billentryseq',1808058934620109834,' ',' ','billentry.seq','{"expression":"billentry.seq","exprTran":"物料明细.序号","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"物料明细.序号"},"exprDesc":"物料明细.序号"}',' ','物料明细.序号',11,'供应数据.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109835;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.projectnumber',1808058934620109835,'billentry.project','billentry.project',' ',' ','物料明细.项目',' ',12,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109836;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.tracknumber',1808058934620109836,'billentry.tracknumber','billentry.tracknumber',' ',' ','物料明细.跟踪号',' ',13,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109837;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.materialflexprops',1808058934620109837,'billentry.auxpty','billentry.auxpty',' ',' ','物料明细.辅助属性',' ',14,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109838;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.stock',1808058934620109838,'billentry.warehouse','billentry.warehouse',' ',' ','物料明细.收货仓库',' ',15,'供应数据.仓库','entryentity.stock','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808058934620109839;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808058934611721216,'entryentity.configuredcode',1808058934620109839,'billentry.configuredcode','billentry.configuredcode',' ',' ','物料明细.配置号',' ',16,'供应数据.配置号','entryentity.configuredcode','0');

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808058934611721216;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808058934611721216) 
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 (1808058934611721216,0,' ',' ',100000,0,1808058934611721216,100000,'pdm','C','5','ys_ecoeffectrange_pm_purorder','pm_purorderbill','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808058934611721216 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808058934611721216,'3O280IH2D7DT','zh_CN','工程变更影响范围_采购订单'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808058934611721216 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808058934611721216,'3O280IH2D7DU','zh_TW','工程變更影響範圍_采購訂單'); 



--8，工程变更影响范围供需字段关系映射
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808059996433332224;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808059996399777792,'entryentity.material',1808059996433332224,'entryentity.material','entryentity.material',' ',' ','单据体.物料',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808059996433332225;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808059996399777792,'entryentity.supplyorgunit',1808059996433332225,'entryentity.productionorgunit','entryentity.productionorgunit',' ',' ','单据体.需求组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814020763490042880;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808059996399777792,'entryentity.materialflexprops',1814020763490042880,'entryentity.materialflexprops','entryentity.materialflexprops',' ',' ','单据体.物料辅助属性',' ',3,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808059996399777792;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808059996399777792) 
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 (1808059996399777792,0,' ',' ',100000,0,1808059996399777792,100000,'pdm','C','5','ys_ecoeffectrange_s_r','pdm_effectrange_demand_m','1',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808059996399777792 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808059996399777792,'3O28898P2WLV','zh_CN','工程变更影响范围_供需字段关系映射'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808059996399777792 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808059996399777792,'3O28898P2WLW','zh_TW','工程變更影響範圍_供需字段關係映射'); 


--9,工程变更影响范围_委外订单
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239296;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.material',1808151287389239296,'billentry.material.masterid','billentry.material.masterid',' ',' ','物料明细.物料编码.物料编码',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239297;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.supplyorgunit',1808151287389239297,'billentry.entryrecorg','billentry.entryrecorg',' ',' ','物料明细.收货组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239298;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billid',1808151287389239298,' ',' ','id','{"expression":"id","exprTran":"委外订单.内码","description":{"zh_CN":""},"exprDesc":"委外订单.内码","localeExprTran":{"zh_CN":"委外订单.内码"}}',' ','委外订单.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239299;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billdate',1808151287389239299,'billentry.deliverdate','billentry.deliverdate',' ',' ','交货计划.交货日期',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239300;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.qty',1808151287389239300,' ',' ',' billentry.baseqty  -  billentry.receivebaseqty ','{"expression":" billentry.baseqty  -  billentry.receivebaseqty ","exprTran":" 基本数量  -  已收货基本数量 ","description":{"zh_CN":""},"exprDesc":" 基本数量  -  已收货基本数量 ","localeExprTran":{"zh_CN":" 基本数量  -  已收货基本数量 "}}',' ',' 基本数量  -  已收货基本数量 ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239301;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billnumber',1808151287389239301,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239302;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.baseunit',1808151287389239302,'billentry.baseunit','billentry.baseunit',' ',' ','物料明细.基本单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239303;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billtype',1808151287389239303,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239304;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billstatusfield',1808151287389239304,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239305;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billentryid',1808151287389239305,' ',' ','billentry.id','{"expression":"billentry.id","exprTran":"物料明细.内码","description":{"zh_CN":""},"exprDesc":"物料明细.内码","localeExprTran":{"zh_CN":"物料明细.内码"}}',' ','物料明细.内码',10,'供应数据.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239306;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.billentryseq',1808151287389239306,' ',' ','billentry.seq','{"expression":"billentry.seq","exprTran":"物料明细.序号","description":{"zh_CN":""},"exprDesc":"物料明细.序号","localeExprTran":{"zh_CN":"物料明细.序号"}}',' ','物料明细.序号',11,'供应数据.单据分录行号','entryentity.billentryseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239307;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.projectnumber',1808151287389239307,'billentry.project','billentry.project',' ',' ','物料明细.项目',' ',12,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239308;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.tracknumber',1808151287389239308,'billentry.tracknumber','billentry.tracknumber',' ',' ','物料明细.跟踪号',' ',13,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239309;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.materialflexprops',1808151287389239309,'billentry.auxpty','billentry.auxpty',' ',' ','物料明细.辅助属性',' ',14,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239310;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.stock',1808151287389239310,'billentry.warehouse','billentry.warehouse',' ',' ','物料明细.收货仓库',' ',15,'供应数据.仓库','entryentity.stock','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1808151287389239311;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1808151254556227584,'entryentity.configuredcode',1808151287389239311,'billentry.configuredcode','billentry.configuredcode',' ',' ','物料明细.配置号',' ',16,'供应数据.配置号','entryentity.configuredcode','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1808151254556227584;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1808151254556227584) 
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 (1808151254556227584,0,' ',' ',100000,0,1808151254556227584,100000,'pdm','C','5','ys_ecoeffectrange_om_purorder','pm_om_purorderbill','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808151254556227584 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808151254556227584,'3O2O=HF2R4XA','zh_CN','工程变更影响范围_委外订单'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1808151254556227584 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808151254556227584,'3O2O=HF2R4XB','zh_TW','工程變更影響範圍_委外訂單'); 



--1.10 工程变更影响范围_计划建议（联副产品）
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687168;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.material',1814012159831687168,'copentry.copentrymaterial','copentry.copentrymaterial',' ',' ','联副产品.产品编码',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687169;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.supplyorgunit',1814012159831687169,'proorpurorg','proorpurorg',' ',' ','单据头.供应组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687170;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.billid',1814012159831687170,' ',' ','id','{"expression":"id","exprTran":"计划建议.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"计划建议.内码"},"exprDesc":"计划建议.内码"}',' ','计划建议.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687171;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.billdate',1814012159831687171,'availabledate','availabledate',' ',' ','单据头.可用日期',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687172;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.qty',1814012159831687172,' ',' ','orderqty -  dropqty ','{"expression":"orderqty -  dropqty ","exprTran":"订单数量 -  投放数量 ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"订单数量 -  投放数量 "},"exprDesc":"订单数量 -  投放数量 "}',' ','订单数量 -  投放数量 ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687173;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.billnumber',1814012159831687173,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687174;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.baseunit',1814012159831687174,'copentry.copentryunit','copentry.copentryunit',' ',' ','联副产品.产品计量单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687175;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.billtype',1814012159831687175,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687176;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.billstatusfield',1814012159831687176,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687177;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.projectnumber',1814012159831687177,'project','project',' ',' ','单据头.项目号',' ',10,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687178;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.tracknumber',1814012159831687178,'tracknumber','tracknumber',' ',' ','单据头.跟踪号',' ',11,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687179;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.materialflexprops',1814012159831687179,'copentry.copentryauxproperty','copentry.copentryauxproperty',' ',' ','联副产品.辅助属性',' ',12,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814012159831687180;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814012159772966912,'entryentity.stock',1814012159831687180,'inwarehouse','inwarehouse',' ',' ','单据头.入库仓库',' ',13,'供应数据.仓库','entryentity.stock','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1814012159772966912;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1814012159772966912) 
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 (1814012159772966912,0,' ',' ',100000,0,1814012159772966912,100000,'pdm','C','5','ys_ecoeffectrange_mrp_planord','mrp_planorder','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 


DELETE FROM t_mrp_bftransfer_l WHERE FID = 1814012159772966912 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814012159772966912,'3OTRCKFON4Y=','zh_CN','工程变更影响范围_计划建议（联副产品）'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1814012159772966912 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814012159772966912,'3OTRCKFON4YA','zh_TW','工程變更影響範圍_計劃建議（聯副產品）'); 




--1.11 工程变更影响范围_计划建议
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659968;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.material',1814009111176659968,'material','material',' ',' ','单据头.物料编码',' ',1,'供应数据.物料','entryentity.material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659969;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.supplyorgunit',1814009111176659969,'proorpurorg','proorpurorg',' ',' ','单据头.供应组织',' ',2,'供应数据.供应组织','entryentity.supplyorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659970;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.billid',1814009111176659970,' ',' ','id','{"expression":"id","exprTran":"计划建议.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"计划建议.内码"},"exprDesc":"计划建议.内码"}',' ','计划建议.内码',3,'供应数据.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659971;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.billdate',1814009111176659971,'availabledate','availabledate',' ',' ','单据头.可用日期',' ',4,'供应数据.供应日期','entryentity.billdate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659972;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.qty',1814009111176659972,' ',' ','orderqty -  dropqty ','{"expression":"orderqty -  dropqty ","exprTran":"订单数量 -  投放数量 ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"订单数量 -  投放数量 "},"exprDesc":"订单数量 -  投放数量 "}',' ','订单数量 -  投放数量 ',5,'供应数据.预计入库基本数量','entryentity.qty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659973;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.billnumber',1814009111176659973,'billno','billno',' ',' ','单据头.单据编号',' ',6,'供应数据.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814009111176659974;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.baseunit',1814009111176659974,'unit','unit',' ',' ','单据头.计量单位',' ',7,'供应数据.基本计量单位','entryentity.baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814010548774354944;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.billtype',1814010548774354944,'billtype','billtype',' ',' ','单据头.单据类型',' ',8,'供应数据.单据类型','entryentity.billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814010548774354945;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.billstatusfield',1814010548774354945,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',9,'供应数据.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814010548774354946;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.projectnumber',1814010548774354946,'project','project',' ',' ','单据头.项目号',' ',10,'供应数据.项目号','entryentity.projectnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814010548774354947;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.tracknumber',1814010548774354947,'tracknumber','tracknumber',' ',' ','单据头.跟踪号',' ',11,'供应数据.跟踪号','entryentity.tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814010548774354948;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.materialflexprops',1814010548774354948,'auxproperty','auxproperty',' ',' ','单据头.辅助属性',' ',12,'供应数据.物料辅助属性','entryentity.materialflexprops','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1814010548774354949;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1814009110975333376,'entryentity.stock',1814010548774354949,'inwarehouse','inwarehouse',' ',' ','单据头.入库仓库',' ',13,'供应数据.仓库','entryentity.stock','0'); 

--DELETE FROM t_mrp_bftransfer WHERE FID =  1814009110975333376;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1814009110975333376) 
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 (1814009110975333376,0,' ',' ',100000,0,1814009110975333376,100000,'pdm','C','5','ys_ecoeffectrange_mrp_planorde','mrp_planorder','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_supply_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1814009110975333376 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814009110975333376,'3OTQTC0XKBSP','zh_CN','工程变更影响范围_计划建议'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1814009110975333376 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814009110975333376,'3OTQTC0XKBSQ','zh_TW','工程變更影響範圍_計劃建議'); 


--1.12 工程变更影响范围联副产品物料_工程变更维护
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479552;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.material',1871875228003479552,' ',' ','pentry.ecobomdata.copentry.copentrymaterialid','{"expression":"pentry.ecobomdata.copentry.copentrymaterialid","exprTran":"pentry.ecobomdata.copentry.copentrymaterialid","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentrymaterialid"},"exprDesc":"pentry.ecobomdata.copentry.copentrymaterialid"}',' ','pentry.ecobomdata.copentry.copentrymaterialid',1,'单据体.物料','entryentity.material','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479553;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billid',1871875228003479553,' ',' ','id','{"expression":"id","exprTran":"工程变更维护.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护.内码"},"exprDesc":"工程变更维护.内码"}',' ','工程变更维护.内码',2,'单据体.单据ID','entryentity.billid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479554;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billdate',1871875228003479554,' ',' ','pentry.ecobomdata.copentry.copacttime','{"expression":"pentry.ecobomdata.copentry.copacttime","exprTran":"pentry.ecobomdata.copentry.copacttime","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copacttime"},"exprDesc":"pentry.ecobomdata.copentry.copacttime"}',' ','pentry.ecobomdata.copentry.copacttime',3,'单据体.实施时间','entryentity.billdate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479555;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.productionorgunit',1871875228003479555,'org','org',' ',' ','单据头.创建组织',' ',4,'单据体.需求组织','entryentity.productionorgunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479556;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billnumber',1871875228003479556,'billno','billno',' ',' ','单据头.工程变更编号',' ',5,'单据体.单据编码','entryentity.billnumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479557;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.demandqty',1871875228003479557,' ',' ','pentry.ecobomdata.copentry.copentryqty','{"expression":"pentry.ecobomdata.copentry.copentryqty","exprTran":"pentry.ecobomdata.copentry.copentryqty","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryqty"},"exprDesc":"pentry.ecobomdata.copentry.copentryqty"}',' ','pentry.ecobomdata.copentry.copentryqty',6,'单据体.需求基本数量','entryentity.demandqty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479558;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.baseunit',1871875228003479558,' ',' ','pentry.ecobomdata.copentry.copentryunit','{"expression":"pentry.ecobomdata.copentry.copentryunit","exprTran":"pentry.ecobomdata.copentry.copentryunit","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryunit"},"exprDesc":"pentry.ecobomdata.copentry.copentryunit"}',' ','pentry.ecobomdata.copentry.copentryunit',7,'单据体.基本计量单位','entryentity.baseunit','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479559;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.materialattr',1871875228003479559,' ',' ','pentry.ecobomdata.copentry.copentrymaterial.materialattr','{"expression":"pentry.ecobomdata.copentry.copentrymaterial.materialattr","exprTran":"pentry.ecobomdata.copentry.copentrymaterial.materialattr","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentrymaterial.materialattr"},"exprDesc":"pentry.ecobomdata.copentry.copentrymaterial.materialattr"}',' ','pentry.ecobomdata.copentry.copentrymaterial.materialattr',8,'单据体.物料属性','entryentity.materialattr','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479560;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billtype',1871875228003479560,' ',' ','1631966120074281984','{"expression":"1631966120074281984","exprTran":"工程变更维护","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"工程变更维护"},"exprDesc":"工程变更维护"}',' ','工程变更维护',9,'单据体.单据类型','entryentity.billtype','3'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479561;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billstatusfield',1871875228003479561,'billstatus','billstatus',' ',' ','单据头.单据状态',' ',10,'单据体.单据状态','entryentity.billstatusfield','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479562;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billentryid',1871875228003479562,' ',' ','pentry.id','{"expression":"pentry.id","exprTran":"产品.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"产品.内码"},"exprDesc":"产品.内码"}',' ','产品.内码',11,'单据体.单据分录ID','entryentity.billentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479564;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.bomnumber',1871875228003479564,' ',' ','pentry.pentrybom.number','{"expression":"pentry.pentrybom.number","exprTran":"BOM编码","description":{"zh_CN":""},"exprDesc":"BOM编码","localeExprTran":{"zh_CN":"BOM编码"}}',' ','BOM编码',13,'单据体.BOM编码','entryentity.bomnumber','1'); 

DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479565;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.materialflexprops',1871875228003479565,' ',' ','pentry.ecobomdata.copentry.copentryauxproperty','{"expression":"pentry.ecobomdata.copentry.copentryauxproperty","exprTran":"pentry.ecobomdata.copentry.copentryauxproperty","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryauxproperty"},"exprDesc":"pentry.ecobomdata.copentry.copentryauxproperty"}',' ','pentry.ecobomdata.copentry.copentryauxproperty',14,'单据体.物料辅助属性','entryentity.materialflexprops','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479566;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.bomreversion',1871875228003479566,' ',' ','pentry.ecobomdata.copentry.copentryversion','{"expression":"pentry.ecobomdata.copentry.copentryversion","exprTran":"pentry.ecobomdata.copentry.copentryversion","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryversion"},"exprDesc":"pentry.ecobomdata.copentry.copentryversion"}',' ','pentry.ecobomdata.copentry.copentryversion',15,'单据体.BOM子项版本','entryentity.bomreversion','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479567;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.ecotypeid',1871875228003479567,' ',' ','pentry.ecotype.id','{"expression":"pentry.ecotype.id","exprTran":"pentry.ecotype.id","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecotype.id"},"exprDesc":"pentry.ecotype.id"}',' ','pentry.ecotype.id',16,'单据体.工程变更类型ID','entryentity.ecotypeid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479568;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.ecobomentryid',1871875228003479568,' ',' ','pentry.ecobomdata.copentry.id','{"expression":"pentry.ecobomdata.copentry.id","exprTran":"pentry.ecobomdata.copentry.id","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.id"},"exprDesc":"pentry.ecobomdata.copentry.id"}',' ','pentry.ecobomdata.copentry.id',17,'单据体.ecoBom分录ID','entryentity.ecobomentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479569;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.ecobomid',1871875228003479569,'pentry.ecobomid','pentry.ecobomid',' ',' ','产品.变更BOMID',' ',18,'单据体.ecobomid','entryentity.ecobomid','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479570;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.entrymode',1871875228003479570,' ',' ','pentry.ecobomdata.copentry.copentrymode','{"expression":"pentry.ecobomdata.copentry.copentrymode","exprTran":"pentry.ecobomdata.copentry.copentrymode","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentrymode"},"exprDesc":"pentry.ecobomdata.copentry.copentrymode"}',' ','pentry.ecobomdata.copentry.copentrymode',19,'单据体.行标识','entryentity.entrymode','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479571;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.entryvaliddate',1871875228003479571,' ',' ','pentry.ecobomdata.copentry.copentryvaliddate','{"expression":"pentry.ecobomdata.copentry.copentryvaliddate","exprTran":"pentry.ecobomdata.copentry.copentryvaliddate","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryvaliddate"},"exprDesc":"pentry.ecobomdata.copentry.copentryvaliddate"}',' ','pentry.ecobomdata.copentry.copentryvaliddate',20,'单据体.生效日期','entryentity.entryvaliddate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479572;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.entryinvaliddate',1871875228003479572,' ',' ','pentry.ecobomdata.copentry.copentryinvaliddate','{"expression":"pentry.ecobomdata.copentry.copentryinvaliddate","exprTran":"pentry.ecobomdata.copentry.copentryinvaliddate","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryinvaliddate"},"exprDesc":"pentry.ecobomdata.copentry.copentryinvaliddate"}',' ','pentry.ecobomdata.copentry.copentryinvaliddate',21,'单据体.失效日期','entryentity.entryinvaliddate','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1871875228003479563;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1871875227936370688,'entryentity.billentryseq',1871875228003479563,' ',' ','pentry.ecobomdata.copentry.copentryseq','{"expression":"pentry.ecobomdata.copentry.copentryseq","exprTran":"pentry.ecobomdata.copentry.copentryseq","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"pentry.ecobomdata.copentry.copentryseq"},"exprDesc":"pentry.ecobomdata.copentry.copentryseq"}',' ','pentry.ecobomdata.copentry.copentryseq',12,'单据体.单据分录行号','entryentity.billentryseq','1'); 

--DELETE FROM t_mrp_bftransfer WHERE FID = 1871875227936370688;
IF NOT EXISTS (SELECT 1 FROM t_mrp_bftransfer WHERE FID =  1871875227936370688) 
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 (1871875227936370688,0,' ',' ',100000,0,1871875227936370688,100000,'pdm','C','5','er_cop_pdm_eco_S','pdm_bom_eco','0',{ts'2018-08-08  08:08:08'},0,'0',1,'1',{ts'2018-08-08  08:08:08'},'pdm_effectrange_demand_m',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FID = 1871875227936370688 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1871875227936370688,'3VXZURTQHTK8','zh_CN','工程变更影响范围联副产品物料_工程变更维护'); 
DELETE FROM t_mrp_bftransfer_l WHERE FID = 1871875227936370688 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1871875227936370688,'3VXZURTQHTK9','zh_TW','工程變更影響範圍聯副產品物料_工程變更維護'); 






--插入U表
insert into t_mrp_bftransfer_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_bftransfer a
where fid in(1808043232127400960,1837786940099848192,1808047290527561728,1808051444079705088,1808053511334706176,1808056511168035840,1808058934611721216,1808059996399777792,1808151254556227584,1814012159772966912,1814009110975333376,1871875227936370688)
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
);



--数据源配置
--2.1 即时库存余额表
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938688;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938688) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808066500397938688,' ',0,'C','DS-ys-01-ecoeffectrange-init',1808047290527561728,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTB/2GJM7GU","leftBracket":"","compareType":"21","fieldName":"baseqty","rightBracket":"","logic":"0","value":[{"id":"3OTB/2GJM6TK","value":"0"}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808066500397938688 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066500397938688,'3O29FNMDAX+I','zh_CN','即时库存余额表'); 


--2.2 生产工单
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938689;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938689) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808066500397938689,' ',0,'C','DS-ys-02-ecoeffectrange-init',1808051444079705088,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTSJHRG1YQ9","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSJHRG1ZDI","value":"B"},{"id":"3OTSJHRG1YQ=","value":"C"},{"id":"3OTSJHRG1ZDJ","value":"A"}],"baseDataIds":[]},{"id":"3OTSJHRG1YQA","leftBracket":"","compareType":"17","fieldName":"taskstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSJHRG1ZDK","value":"A"},{"id":"3OTSJHRG1YQB","value":"B"},{"id":"3OTSJHRG1ZDL","value":"D"}],"baseDataIds":[]},{"id":"3OTSJHRG1YQC","leftBracket":"","compareType":"17","fieldName":"bizstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSJHRG1ZDM","value":"A"}],"baseDataIds":[]},{"id":"3OTSJHRG1YQD","leftBracket":"","compareType":"9","fieldName":"materielmasterid.number","rightBracket":"","logic":"0","value":[{"id":"3OTSJHRG1ZDN","value":""}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808066500397938689 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066500397938689,'3O29FNMDAX+J','zh_CN','生产工单'); 



--2.3委外工单
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938690;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938690) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808066500397938690,' ',0,'C','DS-ys-03-ecoeffectrange-init',1808053511334706176,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTSKGKI1/X5","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSKGKI10KE","value":"B"},{"id":"3OTSKGKI1/X6","value":"C"},{"id":"3OTSKGKI10KF","value":"A"}],"baseDataIds":[]},{"id":"3OTSKGKI1/X7","leftBracket":"","compareType":"17","fieldName":"taskstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSKGKI10KG","value":"A"},{"id":"3OTSKGKI1/X8","value":"B"},{"id":"3OTSKGKI10KH","value":"D"}],"baseDataIds":[]},{"id":"3OTSKGKI1/X9","leftBracket":"","compareType":"9","fieldName":"materielmasterid.number","rightBracket":"","logic":"0","value":[{"id":"3OTSKGKI10KI","value":""}],"baseDataIds":[]},{"id":"3OTSKGKI1/X=","leftBracket":"","compareType":"105","fieldName":"bizstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSKGKI10KJ","value":"A"}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808066500397938690 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066500397938690,'3O29FNMDAX+K','zh_CN','委外工单'); 


--2.4采购申请单
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938691;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938691) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808066500397938691,' ',0,'C','DS-ys-04-ecoeffectrange-init',1808056511168035840,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTS8N8FH86Q","leftBracket":"","compareType":"105","fieldName":"rowclosestatus","rightBracket":"","logic":"0","value":[{"id":"3OTS8N8FH7IG","value":"A"}],"baseDataIds":[]},{"id":"3OTS8N8FH86R","leftBracket":"","compareType":"105","fieldName":"rowterminatestatus","rightBracket":"","logic":"0","value":[{"id":"3OTS8N8FH7IH","value":"A"}],"baseDataIds":[]},{"id":"3OTS8N8FH86S","leftBracket":"","compareType":"105","fieldName":"closestatus","rightBracket":"","logic":"0","value":[{"id":"3OTS8N8FH7II","value":"A"}],"baseDataIds":[]},{"id":"3OTS8N8FH86T","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTS8N8FH7IJ","value":"A"},{"id":"3OTS8N8FH86U","value":"B"},{"id":"3OTS8N8FH7IK","value":"C"}],"baseDataIds":[]},{"id":"3OTS8N8FH86V","leftBracket":"","compareType":"17","fieldName":"billtype.number","rightBracket":"","logic":"0","value":[{"id":"3OTS8N8FH7IL","value":"pm_purapplybill_EMS_BT_S"},{"id":"3OTS8N8FH86W","value":"pm_PurApplyBill_STD_BT_S"}],"baseDataIds":[{"id":"3OTS8N8FH7IM","value":"1002796011481277440"},{"id":"3OTS8N8FH86X","value":"539008374826629120"}]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808066500397938691 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066500397938691,'3O29FNMDAX+L','zh_CN','采购申请单'); 


--2.5采购订单
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938692;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808066500397938692) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808066500397938692,' ',0,'C','DS-ys-05-ecoeffectrange-init',1808058934611721216,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3PE1FDJSW5XL","leftBracket":"","compareType":"105","fieldName":"closestatus","rightBracket":"","logic":"0","value":[{"id":"3PE1FDJSWL1R","value":"A"}],"baseDataIds":[]},{"id":"3PE1FDJSW5XM","leftBracket":"","compareType":"105","fieldName":"rowterminatestatus","rightBracket":"","logic":"0","value":[{"id":"3PE1FDJSWL1S","value":"A"}],"baseDataIds":[]},{"id":"3PE1FDJSW5XN","leftBracket":"","compareType":"105","fieldName":"rowclosestatus","rightBracket":"","logic":"0","value":[{"id":"3PE1FDJSWL1T","value":"A"}],"baseDataIds":[]},{"id":"3PE1FDJSW5XO","leftBracket":"","compareType":"17","fieldName":"billtype.number","rightBracket":"","logic":"0","value":[{"id":"3PE1FDJSWL1U","value":"pm_PurOrderBill_EMS_BT_S"},{"id":"3PE1FDJSW5XP","value":"pm_PurOrderBill_STD_BT_S"}],"baseDataIds":[{"id":"3PE1FDJSWL1V","value":"1005695800258488320"},{"id":"3PE1FDJSW5XQ","value":"539008795674673152"}]},{"id":"3PE1FDJSWL1W","leftBracket":"((","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PE1FDJSW5XR","value":"A"},{"id":"3PE1FDJSWL1X","value":"B"}],"baseDataIds":[]},{"id":"3PE1FDJSW5XS","leftBracket":"","compareType":"83","fieldName":"srcbillentity","rightBracket":")","logic":"1","value":[{"id":"3PE1FDJSWL1Y","value":"pm_purapplybill"}],"baseDataIds":[]},{"id":"3PE1FDJSW5XT","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":")","logic":"0","value":[{"id":"3PE1FDJSWL1Z","value":"C"}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808066500397938692 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066500397938692,'3O29FNMDAX+M','zh_CN','采购订单'); 


--2.6工程变更维护-子项
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808068769155693568;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808068769155693568) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808068769155693568,' ',0,'C','DS-ys-06-ecoeffectrange-init',1808043232127400960,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808068768551712768,'0','pdm',1,'{"filterRow":[{"id":"3W31CDQ6I4C4","leftBracket":"","compareType":"105","fieldName":"changetype","rightBracket":"","logic":"0","value":[{"id":"3W31CDQ6IX+E","value":"A"}],"baseDataIds":[]},{"id":"3W31CDQ6I4C5","leftBracket":"","compareType":"17","fieldName":"ecobomdata.entrymode","rightBracket":"","logic":"0","value":[{"id":"3W31CDQ6IX+F","value":"A"},{"id":"3W31CDQ6I4C6","value":"E"},{"id":"3W31CDQ6IX+G","value":"B"}],"baseDataIds":[]}],"forList":false}'); 



DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808068769155693568 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808068769155693568,'3O29W6D5PH65','zh_CN','工程变更维护-子项'); 


--2.6工程变更维护-父项
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1837800773283494912;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1837800773283494912)  
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1837800773283494912,' ',0,'C','DS-ys-16-ecoeffectrange-init',1837786940099848192,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808068768551712768,'0','pdm',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1837800773283494912 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1837800773283494912,'3RQQ5T/PKZLX','zh_CN','工程变更维护-父项'); 


--2.7委外订单
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1808155567751967744;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1808155567751967744) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1808155567751967744,' ',0,'C','DS-ys-07-ecoeffectrange-init',1808151254556227584,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTD907C2JQ6","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTD907C2KDF","value":"B"},{"id":"3OTD907C2JQ7","value":"C"},{"id":"3OTD907C2KDG","value":"A"}],"baseDataIds":[]},{"id":"3OTD907C2JQ8","leftBracket":"","compareType":"105","fieldName":"closestatus","rightBracket":"","logic":"0","value":[{"id":"3OTD907C2KDH","value":"A"}],"baseDataIds":[]},{"id":"3OTD907C2JQ9","leftBracket":"","compareType":"105","fieldName":"rowclosestatus","rightBracket":"","logic":"0","value":[{"id":"3OTD907C2KDI","value":"A"}],"baseDataIds":[]},{"id":"3OTD907C2JQ=","leftBracket":"","compareType":"105","fieldName":"rowterminatestatus","rightBracket":"","logic":"0","value":[{"id":"3OTD907C2KDJ","value":"A"}],"baseDataIds":[]},{"id":"3OTD907C2JQA","leftBracket":"","compareType":"17","fieldName":"billtype.number","rightBracket":"","logic":"0","value":[{"id":"3OTD907C2KDK","value":"pm_om_purorderbill_BT_S"}],"baseDataIds":[{"id":"3OTD907C2JQB","value":"970978758402036736"}]}],"forList":false}'); 


DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1808155567751967744 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808155567751967744,'3O2P2OWHIK0V','zh_CN','委外订单'); 


--2.8计划建议
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1814018675146080256;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1814018675146080256) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1814018675146080256,' ',0,'C','DS-ys-08-ecoeffectrange-init',1814009110975333376,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTSCP74S4/G","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSCP74S3B7","value":"C"}],"baseDataIds":[]}],"forList":false}'); 


DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1814018675146080256 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814018675146080256,'3OTSL115WXYT','zh_CN','计划建议'); 

--2.9计划建议（联副产品）
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1814018675146080257;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1814018675146080257) 
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1814018675146080257,' ',0,'C','DS-ys-09-ecoeffectrange-init',1814012159772966912,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTSGRS6Z05F","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSGRS6Z0UP","value":"C"}],"baseDataIds":[]},{"id":"3OTSGRS6Z05G","leftBracket":"","compareType":"17","fieldName":"copentrytype","rightBracket":"","logic":"0","value":[{"id":"3OTSGRS6Z0UQ","value":"10720"},{"id":"3OTSGRS6Z05H","value":"10730"}],"baseDataIds":[]}],"forList":false}'); 
DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1814018675146080257 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814018675146080257,'3OTSL115WXYU','zh_CN','计划建议（联副产品）'); 


--2.10 协同计划单
DELETE FROM t_mrp_rsdataconfig WHERE FID =  1814018675146080258;
--IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1814018675146080258) 
--INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1814018675146080258,' ',0,'C','DS-ys-10-ecoeffectrange-init',1814015864777851904,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808066499752015872,'0','pdm',1,'{"filterRow":[{"id":"3OTSDLYNQ28M","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OTSDLYNQ1KC","value":"C"}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1814018675146080258 and FLOCALEID = 'zh_CN';
--INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1814018675146080258,'3OTSL115WXYV','zh_CN','协同计划单'); 


--2.11工程变更维护-联副产品
--DELETE FROM t_mrp_rsdataconfig WHERE FID =  1871878660831588352;
IF NOT EXISTS (SELECT 1 FROM t_mrp_rsdataconfig WHERE FID =  1871878660831588352)  
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1871878660831588352,' ',0,'C','DS_er_cop_pdm_eco_S',1871875227936370688,{ts'2018-08-08  08:08:08'},1,'1',{ts'2018-08-08  08:08:08'},1808068768551712768,'0','pdm',1,'{"filterRow":[{"id":"3W3/JCK=0/BC","leftBracket":"","compareType":"105","fieldName":"changetype","rightBracket":"","logic":"0","value":[{"id":"3W3/JCK=0RZN","value":"A"}],"baseDataIds":[]},{"id":"3W3/JCK=0/BD","leftBracket":"","compareType":"17","fieldName":"ecobomdata.copentrymode","rightBracket":"","logic":"0","value":[{"id":"3W3/JCK=0RZO","value":"A"},{"id":"3W3/JCK=0/BE","value":"B"},{"id":"3W3/JCK=0RZP","value":"E"}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FID = 1871878660831588352 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1871878660831588352,'3VY+GSDGXA77','zh_CN','工程变更维护-联副产品'); 




--供应资源注册模型
--1，工程变更影响范围_需求模型
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593792;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'number',' ',1808068768786593792,'文本型',1,'编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593793;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'name',' ',1808068768786593793,'多语言文本型',2,'名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593794;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'status',' ',1808068768786593794,'下拉列表',3,'数据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593795;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'creator','bos_user',1808068768786593795,'创建人',4,'创建人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593796;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'modifier','bos_user',1808068768786593796,'修改人',5,'修改人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593797;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'enable',' ',1808068768786593797,'下拉列表',6,'使用状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593798;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'createtime',' ',1808068768786593798,'日期型',7,'创建时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593799;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'modifytime',' ',1808068768786593799,'日期型',8,'修改时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593800;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1808068768551712768,'entryentity.productionorgunit',' ',1808068768786593800,'组织',9,'需求组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593801;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1808068768551712768,'entryentity.supplyorgunit',' ',1808068768786593801,'组织',10,'供应组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593802;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.material','bd_material',1808068768786593802,'物料',11,'物料',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593803;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.materialattr',' ',1808068768786593803,'下拉列表',12,'物料属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593804;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.planstrategy','mpdm_manustrategy',1808068768786593804,'基础资料',13,'制造策略',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593805;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.isolatedrule',' ',1808068768786593805,'下拉列表',14,'隔离规则',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593806;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.billid',' ',1808068768786593806,'文本型',15,'单据ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593807;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.billdate',' ',1808068768786593807,'日期型',16,'需求日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593808;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.billtype','bos_billtype',1808068768786593808,'基础资料',17,'单据类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593809;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.biztype','bd_biztype',1808068768786593809,'基础资料',18,'业务类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593810;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.demandqty',' ',1808068768786593810,'数量型',19,'需求基本数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593811;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.computingperiod',' ',1808068768786593811,'整数',20,'计算期间','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593812;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.billnumber',' ',1808068768786593812,'文本型',21,'单据编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593813;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.billstatusfield',' ',1808068768786593813,'下拉列表',22,'单据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593814;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.produnit','bd_measureunits',1808068768786593814,'基础资料',23,'计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593815;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.baseunit','bd_measureunits',1808068768786593815,'基础资料',24,'基本计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593816;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.projectnumber','bd_project',1808068768786593816,'基础资料',25,'项目号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593817;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.tracknumber','bd_tracknumber',1808068768786593817,'基础资料',26,'跟踪号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593818;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.billentryid',' ',1808068768786593818,'文本型',27,'单据分录ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593819;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.billentryseq',' ',1808068768786593819,'整数',28,'单据分录行号','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593820;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.istock',' ',1808068768786593820,'布尔型',29,'是否库存数据','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593821;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.isdemand',' ',1808068768786593821,'布尔型',30,'是否预测需求','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593822;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.ecnversion','pdm_ecnversion',1808068768786593822,'基础资料',31,'ECN版本',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593823;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.demandsourcetype',' ',1808068768786593823,'下拉列表',32,'来源号.需求类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593824;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.materialname',' ',1808068768786593824,'文本型',33,'来源号.物料名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593825;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.materialnumber',' ',1808068768786593825,'文本型',34,'来源号.物料编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593826;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.productorgname',' ',1808068768786593826,'文本型',35,'来源号.生产组织名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593827;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.productorgnumber',' ',1808068768786593827,'文本型',36,'来源号.生产组织编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593828;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.mdsdemandtype','mds_dmtp',1808068768786593828,'基础资料',37,'需求类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593829;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.invaliddate',' ',1808068768786593829,'日期型',38,'失效时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593830;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.safeinvdays',' ',1808068768786593830,'整数',39,'安全库存展望期','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593831;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.safeinvtype',' ',1808068768786593831,'下拉列表',40,'安全库存类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593832;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.bomnumber','pdm_mftbom',1808068768786593832,'基础资料',41,'BOM编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593833;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.configuredcode','bd_configuredcode',1808068768786593833,'基础资料',42,'配置号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593834;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.configproperties',' ',1808068768786593834,'下拉列表',43,'配置属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593835;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.recqty',' ',1808068768786593835,'数量型',44,'领料数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593836;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.supplybillid',' ',1808068768786593836,'文本型',45,'供应单据ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593837;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1808068768551712768,'entryentity.owner',' ',1808068768786593837,'组织',46,'货主',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593838;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.materialflexprops',' ',1808068768786593838,'弹性域',47,'物料辅助属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593839;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.flexmetricid',' ',1808068768786593839,'文本型',48,'弹性维度ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593840;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808068768551712768,'entryentity.flexmetricvalue',' ',1808068768786593840,'文本型',49,'弹性维度值',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593841;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.isdependentreq',' ',1808068768786593841,'下拉列表',50,'启用独立需求替代',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593842;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.is_null_supply_match',' ',1808068768786593842,'下拉列表',51,'供应字段值为空允许匹配需求',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593843;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808068768551712768,'entryentity.bomreversion','bd_bomversion_new',1808068768786593843,'基础资料',52,'BOM子项版本',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593844;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.ecotypeid',' ',1808068768786593844,'长整数',53,'工程变更类型ID','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593845;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.ecobomentryid',' ',1808068768786593845,'长整数',54,'ecoBom分录ID','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593846;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.ecobomid',' ',1808068768786593846,'长整数',55,'ecobomid','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593847;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.entrymode',' ',1808068768786593847,'长整数',56,'行标识','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593848;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.featuretype',' ',1808068768786593848,'长整数',57,'特征类','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593849;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.entryvaliddate',' ',1808068768786593849,'日期型',58,'生效日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593850;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.entryinvaliddate',' ',1808068768786593850,'日期型',59,'失效日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808068768786593851;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808068768551712768,'entryentity.bomentryid',' ',1808068768786593851,'长整数',60,'BOM分录的ID','0'); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_rsregister WHERE FID =  1808068768551712768) 
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,1808068768551712768,'5','pdm_effectrange_demand_m',{ts'2018-08-08  08:08:08'},0,'1',' ',1808068768551712768,' ',0,'11',0,100000,'pdm','C','ys_eco_effectrange_demand',0,0,0,1,{ts'2018-08-08  08:08:08'},0,1); 

DELETE FROM t_mrp_rsregister_l WHERE FID = 1808068768551712768 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808068768551712768,'3O29W6=258CV','zh_CN','工程变更影响范围_需求模型'); 
DELETE FROM t_mrp_rsregister_l WHERE FID = 1808068768551712768 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808068768551712768,'3O29W6=258CW','zh_TW','工程變更影響範圍_需求模型'); 





--2，工程变更影响范围_供应模型
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570304;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'number',' ',1808066499785570304,'文本型',1,'编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570305;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'name',' ',1808066499785570305,'多语言文本型',2,'名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570306;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'status',' ',1808066499785570306,'下拉列表',3,'数据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570307;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'creator','bos_user',1808066499785570307,'创建人',4,'创建人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570308;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'modifier','bos_user',1808066499785570308,'修改人',5,'修改人',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570309;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'enable',' ',1808066499785570309,'下拉列表',6,'使用状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570310;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'createtime',' ',1808066499785570310,'日期型',7,'创建时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570311;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'modifytime',' ',1808066499785570311,'日期型',8,'修改时间',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570312;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1808066499752015872,'entryentity.supplyorgunit',' ',1808066499785570312,'组织',9,'供应组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570313;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.material','bd_material',1808066499785570313,'物料',10,'物料',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570314;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.materialattr',' ',1808066499785570314,'下拉列表',11,'物料属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570315;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.planstrategy','mpdm_manustrategy',1808066499785570315,'基础资料',12,'制造策略',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570316;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.isolatedrule',' ',1808066499785570316,'下拉列表',13,'隔离规则',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570317;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.billdate',' ',1808066499785570317,'日期型',14,'供应日期',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570318;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.billtype','bos_billtype',1808066499785570318,'基础资料',15,'单据类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570319;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.biztype','bd_biztype',1808066499785570319,'基础资料',16,'业务类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570320;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.usablestoqty',' ',1808066499785570320,'数量型',17,'可用库存量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570321;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.qty',' ',1808066499785570321,'数量型',18,'预计入库基本数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570322;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.computingperiod',' ',1808066499785570322,'整数',19,'计算期间','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570323;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.billnumber',' ',1808066499785570323,'文本型',20,'单据编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570324;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.billstatusfield',' ',1808066499785570324,'下拉列表',21,'单据状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570325;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.produnit','bd_measureunits',1808066499785570325,'基础资料',22,'计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570326;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.baseunit','bd_measureunits',1808066499785570326,'基础资料',23,'基本计量单位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570327;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.projectnumber','bd_project',1808066499785570327,'基础资料',24,'项目号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570328;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.tracknumber','bd_tracknumber',1808066499785570328,'基础资料',25,'跟踪号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570329;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.billid',' ',1808066499785570329,'文本型',26,'单据ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570330;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.billentryid',' ',1808066499785570330,'文本型',27,'单据分录ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570331;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.billentryseq',' ',1808066499785570331,'整数',28,'单据分录行号','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570332;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.istock',' ',1808066499785570332,'布尔型',29,'是否库存数据','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570333;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.yield',' ',1808066499785570333,'数量型',30,'成品率（%）','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570334;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.stock','bd_warehouse',1808066499785570334,'基础资料',31,'仓库',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570335;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.stockindex','bd_location',1808066499785570335,'基础资料',32,'仓位',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570336;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.stocktype','bd_invtype',1808066499785570336,'基础资料',33,'库存类型',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570337;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.stockstatus','bd_invstatus',1808066499785570337,'基础资料',34,'库存状态',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570338;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.supplyorgname',' ',1808066499785570338,'文本型',35,'供应明细.库存组织名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570339;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.warehousename',' ',1808066499785570339,'文本型',36,'供应明细.仓库名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570340;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.locationname',' ',1808066499785570340,'文本型',37,'供应明细.仓位名称',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570341;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.warehousenumber',' ',1808066499785570341,'文本型',38,'供应明细.仓库编码',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570342;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.configuredcode','bd_configuredcode',1808066499785570342,'基础资料',39,'配置号',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570343;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.isonwork',' ',1808066499785570343,'布尔型',40,'是否在制产品','false'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570344;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES (' ',' ',1808066499752015872,'entryentity.finishqty',' ',1808066499785570344,'数量型',41,'完工数量','0'); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570345;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1808066499752015872,'entryentity.owner',' ',1808066499785570345,'组织',42,'货主',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570346;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('主业务组织',' ',1808066499752015872,'entryentity.stockorg',' ',1808066499785570346,'组织',43,'库存组织',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570347;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.materialflexprops',' ',1808066499785570347,'弹性域',44,'物料辅助属性',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570348;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.flexmetricid',' ',1808066499785570348,'文本型',45,'弹性维度ID',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570349;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('辅助信息',' ',1808066499752015872,'entryentity.flexmetricvalue',' ',1808066499785570349,'文本型',46,'弹性维度值',' '); 
DELETE FROM t_mrp_rsregisterentry WHERE FENTRYID = 1808066499785570350;
INSERT INTO t_mrp_rsregisterentry(FBIZDATATYPE,FFORMULADESC,FID,FSIGNID,FSRCTYPE,FENTRYID,FDATATYPE,FSEQ,FSIGNNAME,FDEFAULTVALUE) VALUES ('普通维度',' ',1808066499752015872,'entryentity.bomreversion','bd_bomversion_new',1808066499785570350,'基础资料',47,'BOM子项版本',' '); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_rsregister WHERE FID =  1808066499752015872) 
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,1808066499752015872,'5','pdm_effectrange_supply_m',{ts'2018-08-08  08:08:08'},0,'1',' ',1808066499752015872,' ',0,'11',0,100000,'pdm','C','ys_eco_effectrange_supply',0,0,0,1,{ts'2018-08-08  08:08:08'},0,1); 


DELETE FROM t_mrp_rsregister_l WHERE FID = 1808066499752015872 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066499752015872,'3O29FNFLMKY2','zh_CN','工程变更影响范围_供应模型'); 
DELETE FROM t_mrp_rsregister_l WHERE FID = 1808066499752015872 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_rsregister_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808066499752015872,'3O29FNFLMKY3','zh_TW','工程變更影響範圍_供應模型'); 


--插入U表
insert into t_mrp_rsregister_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_rsregister a
where fid in(1808066499752015872,1808068768551712768)
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
);




--算法注册配置
IF NOT EXISTS (SELECT 1 FROM t_mrp_algoregister WHERE FID =  1808817551380073472) 
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 (1808817551380073472,0,' ',100000,0,1808817551380073472,100000,'pdm','C','5','ys_ecoeffectrange_getrequire','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEffectRangeGetRequireData',{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 =  1808816999384501248) 
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 (1808816999384501248,0,' ',100000,0,1808816999384501248,100000,'pdm','C','5','ys_ecoeffectrange_getsupply','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEffectRangeGetSupplyData',{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 =  1808818924997856256) 
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 (1808818924997856256,0,' ',100000,0,1808818924997856256,100000,'pdm','C','5','ys_ecoeffectrange_srmatch','kd.mmc.pdm.business.ecoplatform.estimate.step.EcoEffectRangeSRMatch',{ts'2018-08-08  08:08:08'},0,1,'1','1',{ts'2018-08-08  08:08:08'},'064+RMU5W7LE',1); 


DELETE FROM t_mrp_algoregister_l WHERE FID = 1808817551380073472 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1808817551380073472,'3O5VSJJWS8XX','zh_TW','工程變更影響範圍分析時依據需求模型獲取對應的需求數據','影響範圍_獲取需求數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FID = 1808817551380073472 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1808817551380073472,'3O5VSJJWS8XY','zh_CN','工程变更影响范围分析时依据需求模型获取对应的需求数据','影响范围_获取需求数据'); 
DELETE FROM t_mrp_algoregister_l WHERE FID = 1808816999384501248 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1808816999384501248,'3O5VOIT3W7QC','zh_CN','工程变更影响范围分析时依据供应模型获取对应的供应数据','影响范围_获取供应数据'); 
DELETE FROM t_mrp_algoregister_l WHERE FID = 1808816999384501248 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1808816999384501248,'3O5VOIT3W7QD','zh_TW','工程變更影響範圍分析時依據供應模型獲取對應的供應數據','影響範圍_獲取供應數據'); 
DELETE FROM t_mrp_algoregister_l WHERE FID = 1808818924997856256 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1808818924997856256,'3O5W0JYD0QR8','zh_TW','工程變更影響範圍分析時對需求數據與供應數據依據匹配維度進行匹配計算後，寫入影響範圍結果表。','影響範圍_供應與需求匹配並寫入結果表'); 
DELETE FROM t_mrp_algoregister_l WHERE FID = 1808818924997856256 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_algoregister_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1808818924997856256,'3O5W0JYD0QR9','zh_CN','工程变更影响范围分析时对需求数据与供应数据依据匹配维度进行匹配计算后，写入影响范围结果表。','影响范围_供应与需求匹配并写入结果表'); 


--业务方案
IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1808845716559252480) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1808845690730708992,1808845716559252480,1,1808817551380073472);

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1808845716559252481) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1808845690730708992,1808845716559252481,2,1686906763229540352); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1808845716559252482) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1808845690730708992,1808845716559252482,3,1808816999384501248); 

IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplanentry WHERE FENTRYID = 1808845716559252483) 
INSERT INTO t_mrp_businessplanentry(FID,FENTRYID,FSEQ,FALGOMODEL) VALUES (1808845690730708992,1808845716559252483,4,1808818924997856256); 


IF NOT EXISTS (SELECT 1 FROM t_mrp_businessplan WHERE FID = 1808845690730708992) 
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 (1808845690730708992,0,'{"bb97e721c0c14ef6b0b6dba54130d01a":{"selectname":"影响范围_获取需求数据","algomodel":"1808817551380073472"},"e21443ac73c24b41bf6dff1f7ffd84cb":{"selectname":"清除历史数据","algomodel":"1686906763229540352"},"3339ba886d014ac09116d6947401c28b":{"selectname":"影响范围_获取供应数据","algomodel":"1808816999384501248"},"ed9c3d0d98124f5dbdd1cb5ab3d2ddc7":{"selectname":"影响范围_供应与需求匹配并写入结果表","algomodel":"1808818924997856256"}}',' ',100000,0,1808845690730708992,100000,'pdm','C','5','ys_eco_effectrange_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="bb97e721c0c14ef6b0b6dba54130d01a" value="影响范围_获取需求数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" vertex="1" parent="1">
      <mxGeometry x="430" y="10" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="3339ba886d014ac09116d6947401c28b" value="影响范围_获取供应数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" vertex="1" parent="1">
      <mxGeometry x="430" y="110" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="ed9c3d0d98124f5dbdd1cb5ab3d2ddc7" value="影响范围_供应与需求匹配并写入结果表" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" vertex="1" parent="1">
      <mxGeometry x="420" y="210" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="e21443ac73c24b41bf6dff1f7ffd84cb" value="清除历史数据" style="editable=0;resizable=0;fillColor=#FFFFFF;strokeColor=#979797;arcSize=50;rounded=1;" vertex="1" parent="1">
      <mxGeometry x="430" y="310" width="100" height="40" as="geometry"/>
    </mxCell>
    <mxCell id="2" edge="1" parent="1" source="bb97e721c0c14ef6b0b6dba54130d01a" target="3339ba886d014ac09116d6947401c28b">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
    <mxCell id="3" edge="1" parent="1" source="3339ba886d014ac09116d6947401c28b" target="ed9c3d0d98124f5dbdd1cb5ab3d2ddc7">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
    <mxCell id="4" edge="1" parent="1" source="ed9c3d0d98124f5dbdd1cb5ab3d2ddc7" target="e21443ac73c24b41bf6dff1f7ffd84cb">
      <mxGeometry relative="1" as="geometry"/>
    </mxCell>
  </root>',1,' '); 


DELETE FROM t_mrp_businessplan_l WHERE FID = 1808845690730708992 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_businessplan_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808845690730708992,'3O6/0LKF+VAG','zh_CN','工程变更影响范围方案配置'); 
DELETE FROM t_mrp_businessplan_l WHERE FID = 1808845690730708992 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_businessplan_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808845690730708992,'3O6/0LKF+VAH','zh_TW','工程變更影響範圍方案配置'); 


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


insert into t_mrp_algoregister_u(fdataid,fuseorgid)
select fid,fcreateorgid 
from t_mrp_algoregister a
where fid in(1808817551380073472,1808816999384501248,1808818924997856256)
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
);



--计算方案配置
IF NOT EXISTS (SELECT 1 FROM t_mrp_calplanconfigentry WHERE FENTRYID = 1808870093518556160) 
INSERT INTO t_mrp_calplanconfigentry(FRUNTYPE,FID,FENTRYID,FSEQ,FBIZPLAN) VALUES ('pdm_ecoeffectrange_exec',1808870093409504256,1808870093518556160,1,1808845690730708992); 

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

DELETE FROM t_mrp_calplanconfig_l WHERE FID = 1808870093409504256 and FLOCALEID = 'zh_CN';
INSERT INTO t_mrp_calplanconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808870093409504256,'3O63LEMJFXWT','zh_CN','工程变更影响范围方案'); 
DELETE FROM t_mrp_calplanconfig_l WHERE FID = 1808870093409504256 and FLOCALEID = 'zh_TW';
INSERT INTO t_mrp_calplanconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808870093409504256,'3O63LEMJFXWU','zh_TW','工程變更影響範圍方案'); 


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




--工程变更评估预置数据文本修改调整
update t_mrp_bftransfer set  fnumber = 'ys_ecoestimate_om_stock' WHERE FID = 1629584990415105024;
update t_mrp_bftransfer set  fnumber = 'ys_ecoestimate_pdm_eco' WHERE FID = 1630316068482345984;
update t_mrp_bftransfer set  fnumber = 'ys_ecoestimate_pom_stock' WHERE FID = 1629615712911787008;
update t_mrp_bftransfer set  fnumber = 'ys_ecoestimate_s_r' WHERE FID = 1634625735563949056;
update t_mrp_bftransfer_l set FNAME = '工程变更供需平衡字段关系映射' WHERE FPKID = '33SASS1P=9S/';
update t_mrp_bftransfer_l set FNAME = '工程變更供需平衡字段關係映射' WHERE FPKID = '33SASS1P=9S0';
update t_mrp_bftransfer_l set FNAME = '工程变更评估_委外组件清单需求' WHERE FPKID = '3355YYXDIPZW';
update t_mrp_bftransfer_l set FNAME = '工程變更評估_委外組件清單需求' WHERE FPKID = '3355YYXDIPZX';
update t_mrp_bftransfer_l set FNAME = '工程变更评估_工程变更维护' WHERE FPKID = '338OJ=OPDR/W';
update t_mrp_bftransfer_l set FNAME = '工程變更評估_工程變更維護' WHERE FPKID = '338OJ=OPDR/X';
update t_mrp_bftransfer_l set FNAME = '工程变更评估_生产组件清单需求' WHERE FPKID = '335AOTYIFAJT';
update t_mrp_bftransfer_l set FNAME = '工程變更評估_生產組件清單需求' WHERE FPKID = '335AOTYIFAJU';

update t_mrp_rsregister set  fnumber = 'ys_eco_estimate_require' WHERE FID = 1629731533172519936;
update t_mrp_rsregister set  fnumber = 'ys_eco_estimate_sypply' WHERE FID = 1630325143907625984;
update t_mrp_rsregister_l set FNAME = '工程变更评估需求模型' WHERE FPKID = '335WAT8/EKA7';
update t_mrp_rsregister_l set FNAME = '工程變更評估需求模型' WHERE FPKID = '335WAT8/EKA8';
update t_mrp_rsregister_l set FNAME = '工程变更评估供应模型' WHERE FPKID = '338Q8ESZ=QY9';
update t_mrp_rsregister_l set FNAME = '工程變更評估供應模型' WHERE FPKID = '338Q8ESZ=QY=';

update t_mrp_calplanconfig set  fnumber = 'ys_ecoestimate' WHERE FID = 1631882136384474112;
update t_mrp_calplanconfig_l set FNAME = '工程变更评估计算方案' WHERE FPKID = '33F6573QAJCB';
update t_mrp_calplanconfig_l set FNAME = '工程變更評估計算方案' WHERE FPKID = '33F6573QAJCC';


update t_mrp_rsdataconfig set  fnumber = 'DS-ys-01-ecoinit' WHERE FID = 1630325144368998400;
update t_mrp_rsdataconfig set  fnumber = 'DS-ys-03-ecoinit' WHERE FID = 1629731538146964480;
update t_mrp_rsdataconfig set  fnumber = 'DS-ys-02-ecoinit' WHERE FID = 1629731538146964481;
update t_mrp_rsdataconfig_l set  FNAME = '生产组件清单' WHERE FPKID = '335WAUKMRKBG';
update t_mrp_rsdataconfig_l set  FNAME = '委外组件清单' WHERE FPKID = '335WAUKMRKBH';
update t_mrp_rsdataconfig_l set  FNAME = '工程变更单及ECOBOM供应数据源' WHERE FPKID = '338Q8EXSVBM6';

update t_mrp_businessplan set  fnumber = 'ys_eco_eatimate_bizset' WHERE FID = 1629741014287661056;
update t_mrp_businessplan_l set  FNAME = '工程变更评估业务方案配置' WHERE FPKID = '335Y2WMU0PCD';
update t_mrp_businessplan_l set  FNAME = '工程變更評估業務方案配置' WHERE FPKID = '335Y2WMU0PCE';


update t_mrp_algoregister set  fnumber = 'ys_ecoestimate_getsupply' WHERE FID = 1629736859787606016;
update t_mrp_algoregister set  fnumber = 'ys_ecoestimate_getrequire' WHERE FID = 1629738413718540288;
update t_mrp_algoregister set  fnumber = 'ys_ecoestimate_srbalance' WHERE FID = 1629739468762134528;
update t_mrp_algoregister set  fnumber = 'ys_ecoestimate_writedata' WHERE FID = 1642081874765440000;
update t_mrp_algoregister set  fnumber = 'ys_ecoestimate_clearhisdata' WHERE FID = 1686906763229540352;
update t_mrp_algoregister set  fnumber = 'ys_ecoestimate_effectorder' WHERE FID = 1701645100439842816;
update t_mrp_algoregister_l set  FNAME = '評估運算_獲取工程變更需求數據' WHERE FPKID = '335XLYK44DCP';
update t_mrp_algoregister_l set  FNAME = '评估运算_获取工程变更需求数据' WHERE FPKID = '335XLYK44DCQ';
update t_mrp_algoregister_l set  FNAME = '评估运算_对需求与供应数据进行断点评估' WHERE FPKID = '335XTMDPNC9=';
update t_mrp_algoregister_l set  FNAME = '評估運算_對需求與供應數據進行斷點評估' WHERE FPKID = '335XTMDPNC9A';
update t_mrp_algoregister_l set  FNAME = '评估运算_获取工程变更供应数据' WHERE FPKID = '335XAM/G/0FR';
update t_mrp_algoregister_l set  FNAME = '評估運算_獲取工程變更供應數據' WHERE FPKID = '335XAM/G/0FS';
update t_mrp_algoregister_l set  FNAME = '评估运算_回写工程变更单及更新相关数据' WHERE FPKID = '34P0YIKCXQ0V';
update t_mrp_algoregister_l set  FNAME = '評估運算_回寫工程變更單及更新相關數據' WHERE FPKID = '34P0YIKCXQ0W';
update t_mrp_algoregister_l set  FNAME = '清除历史数据' WHERE FPKID = '3=6T9Q=9PPIA';
update t_mrp_algoregister_l set  FNAME = '清除曆史數據' WHERE FPKID = '3=6T9Q=9PPIB';
update t_mrp_algoregister_l set  FNAME = '評估運算_影響訂單數據' WHERE FPKID = '3B/E1QNQ2=OQ';
update t_mrp_algoregister_l set  FNAME = '评估运算_影响订单数据' WHERE FPKID = '3B/E1QNQ2=OR';


--调整工程变更评估的数据源，加上变更类型的过滤条件（DS-ys-01-ecoinit）
update t_mrp_rsdataconfig set FLARGETEXTFIELD_TAG = 
'{"filterRow":[{"id":"3RQPXNJM3MA6","leftBracket":"","compareType":"105","fieldName":"ecobomdata.entrymode","rightBracket":"","logic":"0","value":[{"id":"3RQPXNJM2WC5","value":"E"}],"baseDataIds":[]},{"id":"3RQPXNJM3MA7","leftBracket":"","compareType":"106","fieldName":"ecobomdata.estimatestatus","rightBracket":"","logic":"0","value":[{"id":"3RQPXNJM2WC6","value":"C"}],"baseDataIds":[]},{"id":"3RQPXNJM3MA8","leftBracket":"","compareType":"105","fieldName":"ecotype.statustype","rightBracket":"","logic":"0","value":[{"id":"3RQPXNJM2WC7","value":"B"}],"baseDataIds":[]},{"id":"3RQPXNJM3MA9","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3RQPXNJM2WC8","value":"C"}],"baseDataIds":[]},{"id":"3RQPXNJM3MA=","leftBracket":"","compareType":"105","fieldName":"changetype","rightBracket":"","logic":"0","value":[{"id":"3RQPXNJM2WC9","value":"A"}],"baseDataIds":[]}],"forList":false}'
where FID = 1630325144368998400 and FMODIFIERID = 1;


--调整工程变更影响范围（子项）的过滤
update t_mrp_rsdataconfig set FLARGETEXTFIELD_TAG = '{"filterRow":[{"id":"3W31CDQ6I4C4","leftBracket":"","compareType":"105","fieldName":"changetype","rightBracket":"","logic":"0","value":[{"id":"3W31CDQ6IX+E","value":"A"}],"baseDataIds":[]},{"id":"3W31CDQ6I4C5","leftBracket":"","compareType":"17","fieldName":"ecobomdata.entrymode","rightBracket":"","logic":"0","value":[{"id":"3W31CDQ6IX+F","value":"A"},{"id":"3W31CDQ6I4C6","value":"E"},{"id":"3W31CDQ6IX+G","value":"B"}],"baseDataIds":[]}],"forList":false}'
where FID =  1808068769155693568;



