--1.数据源配置
-- 1.1 采购端:订单执行明细报表
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241728;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','1','采购组织','org','1',1533215850407241728,'A',1); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241729;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','订单编号','billno','1',1533215850407241729,'A',2); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241730;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','业务日期','billdate','1',1533215850407241730,'A',3); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241731;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','供应商','supplier','1',1533215850407241731,'A',4); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241732;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','2','物料编码','material','1',1533215850407241732,'A',5); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241733;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','物料名称','materialnametext','1',1533215850407241733,'A',6); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241734;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','计量单位','unit','1',1533215850407241734,'A',8); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241735;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','数量','qty','1',1533215850407241735,'B',9); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241736;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','确认状态','cfmstatus','1',1533215850407241736,'A',10); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241737;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','行物流状态','rowlogstatus','1',1533215850407241737,'A',11); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241738;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已发货数量','sumoutstockqty','1',1533215850407241738,'A',12); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241739;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已收货数量','sumreceiptqty','1',1533215850407241739,'A',13); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241740;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已入库数量','suminstockqty','1',1533215850407241740,'A',14); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241741;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已退货数量','sumrecretqty','1',1533215850407241741,'A',15); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241742;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已退库数量','suminstockretqty','1',1533215850407241742,'A',16); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241743;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','退货需补数量','sumrefundqty','1',1533215850407241743,'A',17); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241744;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已对账数量','payableqty','1',1533215850407241744,'A',18); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241745;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已开票数量','invoiceqty','1',1533215850407241745,'A',20); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241746;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已对账金额','payableamt','1',1533215850407241746,'A',19); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241747;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','已开票金额','invoiceamt','1',1533215850407241747,'A',21); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241748;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','结算币别','curr','1',1533215850407241748,'A',22); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241749;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','本位币','loccurr','0',1533215850407241749,'D',23); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241750;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','单据状态','billstatus','0',1533215850407241750,'D',24); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241751;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','商务伙伴','bizpartner','0',1533215850407241751,'D',25); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241752;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','单据ID','id','1',1533215850407241752,'A',26); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241753;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','发起方','origin','0',1533215850407241753,'D',27); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533215850407241754;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','规格型号','materialmodel','1',1533215850407241754,'A',7); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1573989391792199680;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1519049745455330304,' ','0','订单行ID','poentryid','1',1573989391792199680,'A',28); 


DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241728;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE5Y', 'zh_CN', '采购组织', 1533215850407241728);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241729;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6/', 'zh_CN', '订单编号', 1533215850407241729);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241730;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE62', 'zh_CN', '业务日期', 1533215850407241730);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241731;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE65', 'zh_CN', '供应商', 1533215850407241731);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241732;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE68', 'zh_CN', '物料编码', 1533215850407241732);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241733;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6A', 'zh_CN', '物料名称', 1533215850407241733);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241734;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6D', 'zh_CN', '计量单位', 1533215850407241734);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241735;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6G', 'zh_CN', '数量', 1533215850407241735);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241736;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6J', 'zh_CN', '确认状态', 1533215850407241736);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241737;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6M', 'zh_CN', '行物流状态', 1533215850407241737);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241738;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6P', 'zh_CN', '已发货数量', 1533215850407241738);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241739;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6S', 'zh_CN', '已收货数量', 1533215850407241739);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241740;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6V', 'zh_CN', '已入库数量', 1533215850407241740);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241741;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE6Y', 'zh_CN', '已退货数量', 1533215850407241741);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241742;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7/', 'zh_CN', '已退库数量', 1533215850407241742);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241743;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE72', 'zh_CN', '退货需补数量', 1533215850407241743);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241744;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE75', 'zh_CN', '已对账数量', 1533215850407241744);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241745;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE78', 'zh_CN', '已开票数量', 1533215850407241745);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241746;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7A', 'zh_CN', '已对账金额', 1533215850407241746);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241747;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7D', 'zh_CN', '已开票金额', 1533215850407241747);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241748;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7G', 'zh_CN', '结算币别', 1533215850407241748);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241749;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7J', 'zh_CN', '本位币', 1533215850407241749);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241750;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7M', 'zh_CN', '单据状态', 1533215850407241750);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241751;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7P', 'zh_CN', '商务伙伴', 1533215850407241751);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241752;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7S', 'zh_CN', '单据ID', 1533215850407241752);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241753;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7V', 'zh_CN', '发起方', 1533215850407241753);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533215850407241754;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TAGSO1WGE7Y', 'zh_CN', '规格型号', 1533215850407241754);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1573989391792199680;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid,flocaleid, fcolname,fentryid)VALUES('2YAU4RYRV0NZ', 'zh_CN', '订单行ID', 1573989391792199680);


DELETE FROM t_scmc_rpt_cf_data WHERE FENTRYID = 1519049745455454215;
INSERT INTO t_scmc_rpt_cf_data(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG) VALUES (1519049745455330304,'1','A',' ','pur_order',1519049745455454215,1520203097853770752,1,'{"expression":"","exprTran":"单据状态 在……中 (已审核,已关闭,已作废,变更中)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2RQQDRYRVSM1","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2RQQDRYVF3BJ","value":"C"},{"id":"2RRWY=T9Y2PA","value":"D"},{"id":"2RRWY=T9W/XJ","value":"Z"},{"id":"2RRWY=T9Y2PB","value":"E"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2RQQDRYRVSM1\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2RQQDRYVF3BJ\",\"value\":\"C\"},{\"id\":\"2RRWY=T9Y2PA\",\"value\":\"D\"},{\"id\":\"2RRWY=T9W/XJ\",\"value\":\"Z\"},{\"id\":\"2RRWY=T9Y2PB\",\"value\":\"E\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 在……中 (已审核,已关闭,已作废,变更中)","localeExprTran":{"zh_CN":"单据状态 在……中 (已审核,已关闭,已作废,变更中)"}}'); 

DELETE FROM t_scmc_rpt_cf_plugin WHERE FENTRYID = 1520206217644070912;
INSERT INTO t_scmc_rpt_cf_plugin(FID,FPLUGINCLASS,FENTRYID,FSEQ,FPLUGINNAME,FPLUGINSTATUS) VALUES (1519049745455330304,'kd.scm.pur.report.execute.PurOrderExecuteHandle',1520206217644070912,1,'订单执行明细报表插件','1'); 

DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1520206217644070912;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2RQ5+P63TQSI', 1520206217644070912, 'zh_CN', '订单执行明细报表插件');
DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_TW' and FENTRYID = 1520206217644070912;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2RQ5+P63TQSJ', 1520206217644070912, 'zh_TW', '訂單執行明細報表插件');

DELETE FROM t_scmc_rpt_cf WHERE FID = 1519049745455330304;
INSERT INTO t_scmc_rpt_cf(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FTIMEOUT,FREPO,FREPORT,FSYSDATA,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1519049745455330304,{ts'2022-10-17  00:00:00'},1,{ts'2022-09-27  00:00:00'},30,'pur_orderexecute_repo','pur_orderexecute_rpt','1',1,'1','pur_orderexecute_conf','订单执行明细报表'); 


DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1519049745455330304 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1519049745455330304,'2RKLXHNFY372','zh_CN','订单执行明细报表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1519049745455330304 AND FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1519049745455330304,'2RKLXHNFY373','zh_TW','訂單執行明細報表'); 

-- 1.2 采购端:到货及时率报表
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533338857037350912;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','发起方','origin','0',1533338857037350912,'D',19); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533338857037350913;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','商务伙伴','bizpartner','0',1533338857037350913,'D',20); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1526988621784385536;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','规格型号','materialmodel','1',1526988621784385536,'A',5); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1527423225229786113;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','准时到货数量','ontimeqty','1',1527423225229786113,'B',8); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1527423225229786114;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','逾期到货数量','delayqty','1',1527423225229786114,'B',9); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1527423225229786112;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','未到货数量','nonarrivalqty','1',1527423225229786112,'B',10); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1527423225229786115;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','到货及时率','deliveryrate','1',1527423225229786115,'A',11); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1527007031272567808;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','单据状态','billstatus','0',1527007031272567808,'D',14); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1528299164180471808;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','订单数量','orderqty','1',1528299164180471808,'B',6); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518875237998021633;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','1','供应商','supplier','1',1518875237998021633,'A',2); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1526996647408929792;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','1','采购组织','org','1',1526996647408929792,'A',1); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1519720448437638146;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','1',' 采购单位','unit','1',1519720448437638146,'A',7); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518883225689525249;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','2','物料编码','material','1',1518883225689525249,'A',3); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518883225689525248;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','物料名称','materialnametext','1',1518883225689525248,'A',4); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1529800858248905728;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','订单编号','billno','0',1529800858248905728,'D',15); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1529800858248905729;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','业务日期','billdate','0',1529800858248905729,'C',17); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1529808523138138112;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','基本数量','basicqty','0',1529808523138138112,'C',18);  
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1526988621784385540;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','基本单位','basicunit','1',1526988621784385540,'A',13); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1529720883248326656;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','订单行ID','poentryid','0',1529720883248326656,'D',16); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1519726541393661952;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','交货日期','entrydelidate','0',1519726541393661952,'C',12); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1554540532305251328;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1518875237998267392,' ','0','物料编码','materialcode','0',1554540532305251328,'D',21); 


DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533338857037350912;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TB1S/M+SWI7', 'zh_CN', '发起方', 1533338857037350912);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533338857037350913;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2TB1S/M+SWI=', 'zh_CN', '商务伙伴', 1533338857037350913);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1526988621784385536;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SJN8ZF7/RGJ', 'zh_CN', '规格型号', 1526988621784385536);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1527423225229786113;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SLQFXDY6L7C', 'zh_CN', '准时到货数量', 1527423225229786113);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1527423225229786114;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SLQFXDY6L7F', 'zh_CN', '逾期到货数量', 1527423225229786114);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1527423225229786112;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SLQFXDY6L7=', 'zh_CN', '未到货数量', 1527423225229786112);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1527423225229786115;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SLQFXDY6L7I', 'zh_CN', '到货及时率', 1527423225229786115);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1527007031272567808;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SJQP39SNWXJ', 'zh_CN', '单据状态', 1527007031272567808);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1528299164180471808;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SPY3VJ5FQHU', 'zh_CN', '订单数量', 1528299164180471808);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518875237998021633;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2RJS=W++3OQV', 'zh_CN', '供应商', 1518875237998021633);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1526996647408929792;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SJORF97PLNJ', 'zh_CN', '采购组织', 1526996647408929792);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1519720448437638146;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2RNU7X=MNF0/', 'zh_CN', '采购单位', 1519720448437638146);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518883225689525249;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2RJTT2/G5GQ2', 'zh_CN', '物料编码', 1518883225689525249);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518883225689525248;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2RJTT2/G5GQ/', 'zh_CN', '物料名称', 1518883225689525248);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1529800858248905728;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SX3POGW7DCK', 'zh_CN', '订单编号', 1529800858248905728);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1529800858248905729;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SX3POGW7DCN', 'zh_CN', '业务日期', 1529800858248905729);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1529808523138138112;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SX54ISOPLZ9', 'zh_CN', '基本数量', 1529808523138138112);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1526988621784385540;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SJN8ZF7/RGV', 'zh_CN', '基本单位', 1526988621784385540);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1529720883248326656;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2SWQRX6W=Z3K', 'zh_CN', '订单行ID', 1529720883248326656);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1519726541393661952;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2RNVC=VY0AVS', 'zh_CN', '交货日期', 1519726541393661952);
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1554540532305251328;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, flocaleid, fcolname, fentryid)VALUES('2VYN7961HLSY', 'zh_CN', '物料编码', 1554540532305251328);

DELETE FROM t_scmc_rpt_cf_data WHERE FENTRYID = 1518875238006410240;
INSERT INTO t_scmc_rpt_cf_data(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG) VALUES (1518875237998267392,'1','A',' ','pur_order',1518875238006410240,1519608377263866880,1,'{"expression":"","exprTran":"单据状态 在……中 (已审核,已关闭,已作废,变更中)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2SJQOZFQX2IQ","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2SJQOZFUIDOP","value":"C"},{"id":"2SJQOZFUIHQ8","value":"D"},{"id":"2SJQOZFUIDOQ","value":"Z"},{"id":"2SJQOZFUIHQ9","value":"E"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2SJQOZFQX2IQ\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2SJQOZFUIDOP\",\"value\":\"C\"},{\"id\":\"2SJQOZFUIHQ8\",\"value\":\"D\"},{\"id\":\"2SJQOZFUIDOQ\",\"value\":\"Z\"},{\"id\":\"2SJQOZFUIHQ9\",\"value\":\"E\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 在……中 (已审核,已关闭,已作废,变更中)"},"exprDesc":"单据状态 在……中 (已审核,已关闭,已作废,变更中)"}'); 

DELETE FROM t_scmc_rpt_cf_plugin WHERE FENTRYID = 1518898553370594304;
INSERT INTO t_scmc_rpt_cf_plugin(FID,FPLUGINCLASS,FENTRYID,FSEQ,FPLUGINNAME,FPLUGINSTATUS) VALUES (1518875237998267392,'kd.scm.pur.report.deliveryrate.PurOrderDeliveryHandle',1518898553370594304,1,'订单交货及时率报表','1'); 

DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518898553370594304;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2RJWNS/UR7Z5', 1518898553370594304, 'zh_CN', '订单交货及时率报表');
DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_TW' and FENTRYID = 1518898553370594304;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2RJWNS/UR7Z6', 1518898553370594304, 'zh_TW', '訂單交貨及時率報表');


DELETE FROM t_scmc_rpt_cf WHERE FID = 1518875237998267392;
INSERT INTO t_scmc_rpt_cf(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FTIMEOUT,FREPO,FREPORT,FSYSDATA,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1518875237998267392,{ts'2022-11-15  00:00:00'},1,{ts'2022-09-27  00:00:00'},30,'pur_orderdelivery_repo','pur_orderdelivery_rpt','1',1,'1','pur_orderdelivery_conf','到货及时率报表'); 

DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1518875237998267392 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1518875237998267392,'2RJS=W++3OR0','zh_CN','到货及时率报表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1518875237998267392 AND FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1518875237998267392,'2RJS=W++3OR1','zh_TW','到貨及時率報表'); 

-- 1.3 供应端:订单执行明细报表
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297621;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','单据状态','billstatus','0',1533211871430297621,'D',25); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297623;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','商务伙伴','bizpartner','0',1533211871430297623,'D',26); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297624;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','单据ID','id','1',1533211871430297624,'A',27); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297625;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','发起方','origin','0',1533211871430297625,'D',28); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297603;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','2','物料编码','material','1',1533211871430297603,'A',5); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1563778096560308224;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','物料编码','materialcode','1',1563778096560308224,'A',4); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297600;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','1','订货客户','org','1',1533211871430297600,'A',1); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297602;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','订单编号','billno','1',1533211871430297602,'A',2); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297612;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已退货数量','sumrecretqty','1',1533211871430297612,'A',15); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297613;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已退库数量','suminstockretqty','1',1533211871430297613,'A',16); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297614;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','退货需补数量','sumrefundqty','1',1533211871430297614,'A',17); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297615;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已对账数量','payableqty','1',1533211871430297615,'A',18); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297616;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已开票数量','invoiceqty','1',1533211871430297616,'A',20); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297617;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已对账金额','payableamt','1',1533211871430297617,'A',19); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297618;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已开票金额','invoiceamt','1',1533211871430297618,'A',21); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297619;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','结算币别','curr','1',1533211871430297619,'A',23); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297622;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','业务日期','billdate','1',1533211871430297622,'A',3); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297626;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','规格型号','materialmodel','1',1533211871430297626,'A',7); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297604;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','物料名称','materialnametext','1',1533211871430297604,'A',6); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297605;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','计量单位','unit','1',1533211871430297605,'A',8); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297606;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','数量','qty','1',1533211871430297606,'B',9); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297607;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','确认状态','cfmstatus','1',1533211871430297607,'A',10); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297608;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','行物流状态','rowlogstatus','1',1533211871430297608,'A',11); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297609;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已发货数量','sumoutstockqty','1',1533211871430297609,'A',12); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297610;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已收货数量','sumreceiptqty','1',1533211871430297610,'A',13); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297611;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','已入库数量','suminstockqty','1',1533211871430297611,'A',14); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297601;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','1','销售公司','supplier','1',1533211871430297601,'A',22); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1533211871430297620;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','本位币','loccurr','0',1533211871430297620,'D',24); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1573990505338091520;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1526375419681756160,' ','0','订单行ID','poentryid','1',1573990505338091520,'A',29); 

DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297625;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KZ', 1533211871430297625, 'zh_CN', '发起方');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297626;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8L0', 1533211871430297626, 'zh_CN', '规格型号');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297602;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8J6', 1533211871430297602, 'zh_CN', '订单编号');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297603;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8J9', 1533211871430297603, 'zh_CN', '物料编码');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297604;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JB', 1533211871430297604, 'zh_CN', '物料名称');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297605;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JE', 1533211871430297605, 'zh_CN', '计量单位');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297606;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JH', 1533211871430297606, 'zh_CN', '数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297607;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JK', 1533211871430297607, 'zh_CN', '确认状态');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297608;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JN', 1533211871430297608, 'zh_CN', '行物流状态');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297609;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JQ', 1533211871430297609, 'zh_CN', '已发货数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297610;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JT', 1533211871430297610, 'zh_CN', '已收货数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297611;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JW', 1533211871430297611, 'zh_CN', '已入库数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297612;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8JZ', 1533211871430297612, 'zh_CN', '已退货数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297613;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8K0', 1533211871430297613, 'zh_CN', '已退库数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297614;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8K3', 1533211871430297614, 'zh_CN', '退货需补数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297615;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8K6', 1533211871430297615, 'zh_CN', '已对账数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297616;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8K9', 1533211871430297616, 'zh_CN', '已开票数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297617;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KB', 1533211871430297617, 'zh_CN', '已对账金额');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297618;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KE', 1533211871430297618, 'zh_CN', '已开票金额');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297619;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KH', 1533211871430297619, 'zh_CN', '结算币别');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297620;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KK', 1533211871430297620, 'zh_CN', '本位币');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297621;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KN', 1533211871430297621, 'zh_CN', '单据状态');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297622;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KQ', 1533211871430297622, 'zh_CN', '业务日期');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297623;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KT', 1533211871430297623, 'zh_CN', '商务伙伴');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297624;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8KW', 1533211871430297624, 'zh_CN', '单据ID');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297600;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8J0', 1533211871430297600, 'zh_CN', '订货客户');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1533211871430297601;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2TAG0O9WS8J3', 1533211871430297601, 'zh_CN', '销售公司');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1563778096560308224;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2X1X783QW1JR', 1563778096560308224, 'zh_CN', '物料编码');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1573990505338091520;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2YAUBWDNLQ70', 1573990505338091520, 'zh_CN', '订单行ID');

DELETE FROM t_scmc_rpt_cf_data WHERE FENTRYID = 1526375419681861658;
INSERT INTO t_scmc_rpt_cf_data(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG) VALUES (1526375419681756160,'1','A',' ','scp_order',1526375419681861658,1526388985847771136,1,'{"expression":"","exprTran":"单据状态 在……中 (已审核,已关闭,已作废,变更中)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2UYUB6GDIKVL","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2UYUB6GDGI1U","value":"C"},{"id":"2UYUB6GDIKVM","value":"D"},{"id":"2UYUB6GDGI1V","value":"Z"},{"id":"2UYUB6GDIKVN","value":"E"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2UYUB6GDIKVL\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2UYUB6GDGI1U\",\"value\":\"C\"},{\"id\":\"2UYUB6GDIKVM\",\"value\":\"D\"},{\"id\":\"2UYUB6GDGI1V\",\"value\":\"Z\"},{\"id\":\"2UYUB6GDIKVN\",\"value\":\"E\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 在……中 (已审核,已关闭,已作废,变更中)","localeExprTran":{"zh_CN":"单据状态 在……中 (已审核,已关闭,已作废,变更中)"}}'); 

DELETE FROM t_scmc_rpt_cf_plugin WHERE FENTRYID = 1526393246514049024;
INSERT INTO t_scmc_rpt_cf_plugin(FID,FPLUGINCLASS,FENTRYID,FSEQ,FPLUGINNAME,FPLUGINSTATUS) VALUES (1526375419681756160,'kd.scm.scp.report.execute.ScpOrderExecuteHandle',1526393246514049024,1,'订单执行明细报表插件','1'); 

DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1526393246514049024;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2SGT/GBT5NAT', 1526393246514049024, 'zh_CN', '订单执行明细报表插件');
DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_TW' and FENTRYID = 1526393246514049024;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2SGT/GBT5NAU', 1526393246514049024, 'zh_TW', '訂單執行明細報表插件');


DELETE FROM t_scmc_rpt_cf WHERE FID = 1526375419681756160;
INSERT INTO t_scmc_rpt_cf(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FTIMEOUT,FREPO,FREPORT,FSYSDATA,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1526375419681756160,{ts'2022-11-28  00:00:00'},1,{ts'2022-10-07  00:00:00'},30,'pur_orderexecute_repo','scp_orderexecute_rpt','1',1,'1','scp_orderexecute_conf','订单执行明细报表'); 

DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1526375419681756160 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1526375419681756160,'2SGPOK32D22L','zh_CN','订单执行明细报表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1526375419681756160 AND FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1526375419681756160,'2SGPOK32D22M','zh_TW','訂單執行明細報表'); 

-- 1.4 供应端:到货及时率报表
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531169990961568768;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','发起方','origin','0',1531169990961568768,'D',20); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531169990961568769;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','商务伙伴','bizpartner','0',1531169990961568769,'D',21); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1546425800386219008;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','物料编码','materialcode','1',1546425800386219008,'A',4); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413376;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','1','订货客户','org','1',1531053212621413376,'A',1); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413377;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','1','销售公司','supplier','1',1531053212621413377,'A',2); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413378;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','2','物料编码','material','1',1531053212621413378,'A',3); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413379;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','物料名称','materialnametext','1',1531053212621413379,'A',5); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413380;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','规格型号','materialmodel','1',1531053212621413380,'A',6); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413381;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','订单数量','orderqty','1',1531053212621413381,'B',7); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413382;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','1','采购单位','unit','1',1531053212621413382,'A',8); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413383;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','准时到货数量','ontimeqty','1',1531053212621413383,'B',9); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413384;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','逾期到货数量','delayqty','1',1531053212621413384,'B',10); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413385;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','未到货数量','nonarrivalqty','1',1531053212621413385,'B',11); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413386;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','到货及时率','deliveryrate','1',1531053212621413386,'A',12); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413387;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','交货日期','entrydelidate','0',1531053212621413387,'C',13); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413388;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','基本单位','basicunit','1',1531053212621413388,'A',14); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413389;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','单据状态','billstatus','0',1531053212621413389,'D',15); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413390;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','订单编号','billno','0',1531053212621413390,'D',16); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413391;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','订单行ID','poentryid','0',1531053212621413391,'C',17); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413392;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','业务日期','billdate','0',1531053212621413392,'C',18); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1531053212621413393;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1531053212621289472,' ','0','基本数量','basicqty','0',1531053212621413393,'C',19); 

DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1546425800386219008;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2UYS/BKPNN9H', 1546425800386219008, 'zh_CN', '物料编码');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413378;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH54', 1531053212621413378, 'zh_CN', '物料编码');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413379;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH57', 1531053212621413379, 'zh_CN', '物料名称');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413380;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5=', 1531053212621413380, 'zh_CN', '规格型号');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413381;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5C', 1531053212621413381, 'zh_CN', '订单数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413382;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5F', 1531053212621413382, 'zh_CN', '采购单位');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413383;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5I', 1531053212621413383, 'zh_CN', '准时到货数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413384;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5L', 1531053212621413384, 'zh_CN', '逾期到货数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413385;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5O', 1531053212621413385, 'zh_CN', '未到货数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413386;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5R', 1531053212621413386, 'zh_CN', '到货及时率');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413387;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5U', 1531053212621413387, 'zh_CN', '交货日期');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413388;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5X', 1531053212621413388, 'zh_CN', '基本单位');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413389;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH6+', 1531053212621413389, 'zh_CN', '单据状态');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413390;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH61', 1531053212621413390, 'zh_CN', '订单编号');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413391;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH64', 1531053212621413391, 'zh_CN', '订单行ID');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413392;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH67', 1531053212621413392, 'zh_CN', '业务日期');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413393;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH6=', 1531053212621413393, 'zh_CN', '基本数量');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413376;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH5/', 1531053212621413376, 'zh_CN', '订货客户');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413377;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T13PK+TXH51', 1531053212621413377, 'zh_CN', '销售公司');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531169990961568768;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T1OIIHO5D6R', 1531169990961568768, 'zh_CN', '发起方');
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531169990961568769;
INSERT INTO t_scmc_rpt_cf_cols_l(fpkid, fentryid, flocaleid, fcolname)VALUES('2T1OIIHO5D6U', 1531169990961568769, 'zh_CN', '商务伙伴');


DELETE FROM t_scmc_rpt_cf_data WHERE FENTRYID = 1531053212621413394;
INSERT INTO t_scmc_rpt_cf_data(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG) VALUES (1531053212621289472,'1','A',' ','scp_order',1531053212621413394,1531048744378906624,1,'{"expression":"","exprTran":"单据状态 在……中 (已审核,已关闭,已作废,变更中)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2SJQOZFQX2IQ","leftBracket":"","compareType":"17","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2SJQOZFUIDOP","value":"C"},{"id":"2SJQOZFUIHQ8","value":"D"},{"id":"2SJQOZFUIDOQ","value":"Z"},{"id":"2SJQOZFUIHQ9","value":"E"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2SJQOZFQX2IQ\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2SJQOZFUIDOP\",\"value\":\"C\"},{\"id\":\"2SJQOZFUIHQ8\",\"value\":\"D\"},{\"id\":\"2SJQOZFUIDOQ\",\"value\":\"Z\"},{\"id\":\"2SJQOZFUIHQ9\",\"value\":\"E\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 在……中 (已审核,已关闭,已作废,变更中)"},"exprDesc":"单据状态 在……中 (已审核,已关闭,已作废,变更中)"}'); 

DELETE FROM t_scmc_rpt_cf_plugin WHERE FENTRYID = 1531053212621413395;
INSERT INTO t_scmc_rpt_cf_plugin(FID,FPLUGINCLASS,FENTRYID,FSEQ,FPLUGINNAME,FPLUGINSTATUS) VALUES (1531053212621289472,'kd.scm.scp.report.deliveryrate.ScpOrderDeliveryHandle',1531053212621413395,1,'订单交货及时率报表','1'); 

DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_TW' and FENTRYID = 1531053212621413395;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2T13PK+TXH6C', 1531053212621413395, 'zh_TW', '訂單交貨及時率報表');
DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1531053212621413395;
INSERT INTO t_scmc_rpt_cf_plugin_l(fpkid, fentryid, flocaleid, fpluginname)VALUES('2T13PK+TXH6D', 1531053212621413395, 'zh_CN', '订单交货及时率报表');


DELETE FROM t_scmc_rpt_cf WHERE FID = 1531053212621289472;
INSERT INTO t_scmc_rpt_cf(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FTIMEOUT,FREPO,FREPORT,FSYSDATA,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1531053212621289472,{ts'2022-11-04  00:00:00'},1,{ts'2022-10-14  00:00:00'},30,'pur_orderdelivery_repo','scp_orderdelivery_rpt','1',1,'1','scp_orderdelivery_conf','到货及时率报表'); 

DELETE FROM t_scmc_rpt_cf_l WHERE FPKID = '2T13PK+TZKMG';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1531053212621289472,'2T13PK+TZKMG','zh_TW','到貨及時率報表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FPKID = '2T13PK+TZKMH';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1531053212621289472,'2T13PK+TZKMH','zh_CN','到货及时率报表'); 


--2.字段映射配置
--2.1 采购端:订单执行明细字段映射
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1520203097853770752;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1520203097853770752,'pur_orderexecute_repo',{ts'2022-12-21  00:00:00'},1,' ','{"repocol":["org","supplier","billno","material","materialnametext","unit","qty","cfmstatus","rowlogstatus","sumoutstockqty","sumreceiptqty","suminstockqty","sumrecretqty","suminstockretqty","sumrefundqty","payableqty","invoiceqty","payableamt","invoiceamt","curr","loccurr","billstatus","billdate","bizpartner","id","origin","materialmodel","poentryid","materialcode"],"fullsrccol":["org","supplier","billno","materialentry.material","materialentry.materialnametext","materialentry.unit","materialentry.qty","cfmstatus","materialentry.rowlogstatus","materialentry.sumoutstockqty","materialentry.sumreceiptqty","materialentry.suminstockqty","materialentry.sumrecretqty","materialentry.suminstockretqty","materialentry.sumrefundqty","","materialentry.invoiceqty","","materialentry.invoiceamt","curr","loccurr","billstatus","billdate","","","","materialentry.material.modelnum","materialentry.poentryid",""],"defval":["","","","","","","","","","","","","","","","0","","0","","","","","","","","","","",""],"remark":["","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["org","supplier","billno","material","materialnametext","unit","qty","cfmstatus","rowlogstatus","sumoutstockqty","sumreceiptqty","suminstockqty","sumrecretqty","suminstockretqty","sumrefundqty","","invoiceqty","","invoiceamt","curr","loccurr","billstatus","billdate","","","","material.modelnum","poentryid",""]}','pur_order',{ts'2022-09-29  00:00:00'},'1',1,'pur_order_execute_colmap','订单执行明细字段映射'); 


DELETE FROM t_scmc_rpt_colmap_l WHERE FID = 1520203097853770752 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1520203097853770752,'2RQ4DZJXZ/=F','zh_CN','订单执行明细字段映射'); 
DELETE FROM t_scmc_rpt_colmap_l WHERE FID = 1520203097853770752 AND FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1520203097853770752,'2RQ4DZJXZ/=G','zh_TW','訂單執行明細字段映射'); 

--2.2 采购端:到货及时率字段映射
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1519608377263866880;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1519608377263866880,'pur_orderdelivery_repo',{ts'2022-10-19  00:00:00'},1,' ','{"repocol":["supplier","material","materialnametext","unit","entrydelidate","materialmodel","basicunit","org","billstatus","deliveryrate","nonarrivalqty","ontimeqty","delayqty","orderqty","poentryid","billdate","billno","basicqty","origin","bizpartner"],"fullsrccol":["supplier","materialentry.material","materialentry.material.name","materialentry.unit","materialentry.entrydelidate","materialentry.material.modelnum","materialentry.basicunit","org","billstatus","","","","","materialentry.basicqty","materialentry.poentryid","","billno","","",""],"defval":["","","","","","","","","","0","0","0","0","","","","","","",""],"remark":["","","","","","","","","","","","","","","","","","","",""],"srccol":["supplier","material","material.name","unit","entrydelidate","material.modelnum","basicunit","org","billstatus","","","","","basicqty","poentryid","","billno","","",""]}','pur_order',{ts'2022-09-28  00:00:00'},'1',1,'pur_order_delivery_colmap','到货及时率字段映射'); 



DELETE FROM t_scmc_rpt_colmap_l WHERE FID = 1519608377263866880 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1519608377263866880,'2RN==8IO2S4W','zh_CN','到货及时率字段映射'); 
DELETE FROM t_scmc_rpt_colmap_l WHERE FID = 1519608377263866880 AND FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1519608377263866880,'2RN==8IO2S4X','zh_TW','到貨及時率字段映射'); 

--2.3 供应端:订单执行明细字段映射
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1526388985847771136;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1526388985847771136,'pur_orderexecute_repo',{ts'2022-11-28  00:00:00'},1,' ','{"repocol":["org","supplier","billno","material","materialnametext","unit","qty","cfmstatus","rowlogstatus","sumoutstockqty","sumreceiptqty","suminstockqty","sumrecretqty","suminstockretqty","sumrefundqty","payableqty","invoiceqty","payableamt","invoiceamt","curr","loccurr","billstatus","billdate","bizpartner","id","origin","materialmodel","materialcode","poentryid"],"fullsrccol":["org","supplier","billno","materialentry.material","materialentry.materialnametext","materialentry.unit","materialentry.qty","cfmstatus","materialentry.rowlogstatus","materialentry.sumoutstockqty","materialentry.sumreceiptqty","materialentry.suminstockqty","materialentry.sumrecretqty","materialentry.suminstockretqty","materialentry.sumrefundqty","","materialentry.invoiceqty","","materialentry.invoiceamt","curr","loccurr","billstatus","billdate","bizpartner","","origin","materialentry.material.modelnum","materialentry.material.number","materialentry.poentryid"],"defval":["","","","","","","","","","","","","","","","0","","0","","","","","","","","","","",""],"remark":["","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["org","supplier","billno","material","materialnametext","unit","qty","cfmstatus","rowlogstatus","sumoutstockqty","sumreceiptqty","suminstockqty","sumrecretqty","suminstockretqty","sumrefundqty","","invoiceqty","","invoiceamt","curr","loccurr","billstatus","billdate","bizpartner","","origin","material.modelnum","material.number","poentryid"]}','scp_order',{ts'2022-10-08  00:00:00'},'1',1,'scp_order_execute_colmap','订单执行明细字段映射'); 


DELETE FROM t_scmc_rpt_colmap_l WHERE  FID = 1526388985847771136 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1526388985847771136,'2SGS7EHPA45K','zh_CN','订单执行明细字段映射'); 
DELETE FROM t_scmc_rpt_colmap_l WHERE  FID = 1526388985847771136 AND FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1526388985847771136,'2SGS7EHPA45L','zh_TW','訂單執行明細字段映射'); 

--2.4 供应端:到货及时率字段映射
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1531048744378906624;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1531048744378906624,'pur_orderdelivery_repo',{ts'2022-12-01  00:00:00'},1,' ','{"repocol":["supplier","material","materialnametext","unit","entrydelidate","materialmodel","basicunit","org","billstatus","deliveryrate","nonarrivalqty","ontimeqty","delayqty","orderqty","poentryid","billdate","billno","basicqty","origin","bizpartner","materialcode"],"fullsrccol":["supplier","materialentry.material","materialentry.material.name","materialentry.unit","materialentry.entrydelidate","materialentry.material.modelnum","materialentry.basicunit","org","billstatus","","","","","materialentry.basicqty","materialentry.poentryid","","billno","","origin","bizpartner","materialentry.material.number"],"defval":["","","","","","","","","","0","0","0","0","","","","","","","",""],"remark":["","","","","","","","","","","","","","","","","","","","",""],"srccol":["supplier","material","material.name","unit","entrydelidate","material.modelnum","basicunit","org","billstatus","","","","","basicqty","poentryid","","billno","","origin","bizpartner","material.number"]}','scp_order',{ts'2022-10-14  00:00:00'},'1',1,'scp_order_delivery_colmap','到货及时率字段映射'); 


DELETE FROM t_scmc_rpt_colmap_l WHERE FID=1531048744378906624 AND  FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1531048744378906624,'2T12W/51+0O0','zh_CN','到货及时率字段映射'); 
DELETE FROM t_scmc_rpt_colmap_l WHERE FID=1531048744378906624 AND  FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1531048744378906624,'2T12W/51+0O1','zh_TW','到貨及時率字段映射'); 
