DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788224;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salbillid',1579908438148788224,' ',' ','id','{"expression":"id","exprTran":"销售订单.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"销售订单.内码"},"exprDesc":"销售订单.内码"}',' ','销售订单.内码',1,'单据头.销售订单','salbillid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788225;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salorg',1579908438148788225,'org','org',' ',' ','单据头.销售组织',' ',2,'单据头.订单组织','salorg','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788227;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'operator',1579908438148788227,'operator','operator',' ',' ','单据头.销售员',' ',4,'单据头.销售员','operator','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788228;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salbillseq',1579908438148788228,' ',' ','billentry.seq','{"expression":"billentry.seq","exprTran":"物料明细.序号","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"物料明细.序号"},"exprDesc":"物料明细.序号"}',' ','物料明细.序号',5,'单据头.销售订单行号','salbillseq','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788229;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salbillentryid',1579908438148788229,' ',' ','billentry.id','{"expression":"billentry.id","exprTran":"物料明细.内码","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"物料明细.内码"},"exprDesc":"物料明细.内码"}',' ','物料明细.内码',6,'单据头.销售订单行ID','salbillentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788230;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'billtype',1579908438148788230,'billtype','billtype',' ',' ','单据头.单据类型',' ',7,'单据头.订单类型','billtype','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788233;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'baseunit',1579908438148788233,'billentry.baseunit','billentry.baseunit',' ',' ','物料明细.基本单位',' ',10,'单据头.基本单位','baseunit','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788235;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'deliverydate',1579908438148788235,'billentry.deliverydate','billentry.deliverydate',' ',' ','物料明细.发货日期',' ',12,'单据头.需求日期','deliverydate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788236;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'tracknumber',1579908438148788236,'billentry.tracknumber','billentry.tracknumber',' ',' ','物料明细.跟踪号',' ',13,'单据头.跟踪号','tracknumber','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788237;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'closestatus',1579908438148788237,'closestatus','closestatus',' ',' ','单据头.关闭状态',' ',14,'单据头.关闭状态','closestatus','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788238;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'rowclosestatus',1579908438148788238,'billentry.rowclosestatus','billentry.rowclosestatus',' ',' ','物料明细.行关闭状态',' ',15,'单据头.行关闭状态','rowclosestatus','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788239;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'proorg',1579908438148788239,'billentry.e_stockorg','billentry.e_stockorg',' ',' ','物料明细.发货组织',' ',16,'单据头.生产组织','proorg','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1584924303500000256;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salbillstatus',1584924303500000256,' ',' ','C','{"expression":"C","exprTran":"已审核","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"已审核"},"exprDesc":"已审核"}',' ','已审核',17,'单据头.单据状态','salbillstatus','3'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1586879557238000640;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'customer',1586879557238000640,'customer','customer',' ',' ','单据头.订货客户',' ',18,'单据头.订货客户','customer','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1586879557238000641;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'saldept',1586879557238000641,'dept','dept',' ',' ','单据头.销售部门',' ',19,'单据头.订单部门','saldept','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1587089850966740992;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'auxpty',1587089850966740992,'billentry.auxpty','billentry.auxpty',' ',' ','物料明细.辅助属性',' ',21,'单据头.辅助属性','auxpty','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1590646939987220480;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salorderlineremark',1590646939987220480,'billentry.remark','billentry.remark',' ',' ','物料明细.备注',' ',20,'单据头.销售订单行备注','salorderlineremark','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1619474725312956417;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'project',1619474725312956417,'billentry.project','billentry.project',' ',' ','物料明细.项目',' ',22,'单据头.项目','project','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1631084700795696128;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'expectedprodeliverydate',1631084700795696128,'billentry.deliverydate','billentry.deliverydate',' ',' ','物料明细.发货日期',' ',23,'单据头.期望生产交期','expectedprodeliverydate','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788231;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'material',1579908438148788231,'billentry.materialmasterid','billentry.materialmasterid',' ',' ','物料明细.物料',' ',8,'单据头.物料编码','material','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788232;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'configuredcode',1579908438148788232,'billentry.configuredcode','billentry.configuredcode',' ',' ','物料明细.配置号',' ',9,'单据头.配置号','configuredcode','0'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1587838571299996672;
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1587838571299996673;
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788234;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'reqqty',1579908438148788234,' ',' ','billentry.baseqty- billentry.invbaseqty ','{"expression":"billentry.baseqty- billentry.invbaseqty ","exprTran":"基本数量- 已出库基本数量 ","description":{"zh_CN":""},"localeExprTran":{"zh_CN":"基本数量- 已出库基本数量 "},"exprDesc":"基本数量- 已出库基本数量 "}',' ','基本数量- 已出库基本数量 ',11,'单据头.需求基本数量','reqqty','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1579908438148788226;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1579908438090067968,'salbillno',1579908438148788226,'billno','billno',' ',' ','单据头.单据编号',' ',3,'单据头.销售订单号','salbillno','0'); 

DELETE FROM t_mrp_bftransfer WHERE FID = 1579908438090067968;
INSERT INTO t_mrp_bftransfer(FID,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1579908438090067968,' ',' ',100000,1579908438090067968,100000,'A','C','5','orderpoolpreset','sm_salorder','0',{ts'2018-08-08  18:08:08'},'0',1,'1',{ts'2018-08-08  18:08:08'},'mds_orderpooldata',1,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '2Z162RIWVCF4';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1579908438090067968,'2Z162RIWVCF4','zh_CN','订单池预置数据源'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '2Z162RIWVCF5';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1579908438090067968,'2Z162RIWVCF5','zh_TW','訂單池預置數據源'); 


DELETE FROM t_mrp_rsdataconfig WHERE FID = 1584141270387786752;
INSERT INTO t_mrp_rsdataconfig(FID,FLARGETEXTFIELD,FMASTERID,FSTATUS,FNUMBER,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCGNUMBER,FISSYSTEMDESIGN,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1584141270387786752,' ',1584141270387786752,'C','orderpool_preset',1579908438090067968,{ts'2018-08-08  18:08:08'},1,'1',{ts'2018-08-08  18:08:08'},0,'0','mds',1,'{"filterRow":[{"id":"2ZKG3F21/AEO","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2ZKG3F21/B2Y","value":"C"}],"baseDataIds":[]},{"id":"2ZKG3F21/AEP","leftBracket":"","compareType":"105","fieldName":"isvirtualbill","rightBracket":"","logic":"0","value":[{"id":"2ZKG3F21/B2Z","value":"0"}],"baseDataIds":[]}],"forList":false}'); 

DELETE FROM t_mrp_rsdataconfig_l WHERE FPKID = '2ZKG+B/IU1RX';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1584141270387786752,'2ZKG+B/IU1RX','zh_CN','订单池预置数据源'); 
DELETE FROM t_mrp_rsdataconfig_l WHERE FPKID = '2ZKG+B/IU1RY';
INSERT INTO t_mrp_rsdataconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1584141270387786752,'2ZKG+B/IU1RY','zh_TW','訂單池預置數據源'); 
