DELETE FROM t_pbd_esaggtype WHERE FID = 1710955131018801152;
INSERT INTO t_pbd_esaggtype(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FAGGTYPEHANDLER,FNUMBER) VALUES (1710955131018801152,{ts'2023-06-19  00:00:00'},1,'1','1',{ts'2023-06-19  00:00:00'},1710955131018801152,'C',1,'kd.scm.pbd.domain.model.esconfig.agghandler.RangeEsAggHandler','range'); 

DELETE FROM t_pbd_esaggtype_l WHERE FID = 1710955131018801152 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esaggtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1710955131018801152,'3C5/LY1ERNB9','zh_CN','范围聚合'); 
DELETE FROM t_pbd_esaggtype_l WHERE FID = 1710955131018801152 AND FLOCALEID = 'zh_TW';
INSERT INTO t_pbd_esaggtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1710955131018801152,'3C5/LY1ERNB=','zh_TW','範圍聚合'); 

DELETE FROM t_pbd_esaggtype WHERE FID = 1629600738860948480;
INSERT INTO t_pbd_esaggtype(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FAGGTYPEHANDLER,FNUMBER) VALUES (1629600738860948480,{ts'2023-02-27  00:00:00'},1,'1','1',{ts'2023-02-27  00:00:00'},1629600738860948480,'C',1,'kd.scm.pbd.domain.model.esconfig.agghandler.SumEsAggHandler','sum'); 

DELETE FROM t_pbd_esaggtype_l WHERE FID = 1629600738860948480 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esaggtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629600738860948480,'3358WPSYC7LX','zh_CN','合计词条聚合'); 
DELETE FROM t_pbd_esaggtype_l WHERE FID = 1629600738860948480 AND FLOCALEID = 'zh_TW';
INSERT INTO t_pbd_esaggtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1629600738860948480,'3358WPSYC7LY','zh_TW','合計詞條聚合'); 



DELETE FROM t_pbd_esaggs WHERE FID = 1711516339640084480;
INSERT INTO t_pbd_esaggs(FID,FSIZE,FINDEXENTITYID,FFIELDID,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FPATH,FMODIFIERID,FENABLE,FESAGGTYPEID,FISPRESET,FMODIFYTIME,FFILTERS,FCREATORID,FPARAMS) VALUES (1711516339640084480,1000,'mal_order',1710793649282889728,1711516339640084480,'C','entryQtyAgg',{ts'2023-06-20  00:00:00'},' ',1,'1',1629600738860948480,'1',{ts'2023-06-20  00:00:00'},' ',1,' '); 

DELETE FROM t_pbd_esaggs_l WHERE FID = 1711516339640084480 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esaggs_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1711516339640084480,'3C7PG=63MJHH','zh_CN','分录数量合计聚合'); 
DELETE FROM t_pbd_esaggs_l WHERE FID = 1711516339640084480 AND FLOCALEID = 'zh_TW';
INSERT INTO t_pbd_esaggs_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1711516339640084480,'3C7PG=63MJHI','zh_TW','分錄數量合計聚合'); 


DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1710793730216184832;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1598575801408898048,'0',1710793730216184832,3,1710793649282889728); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1711780937903134720;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1598575801408898048,'0',1711780937903134720,4,1711780736475879424); 

DELETE FROM t_pbd_esmappingprop WHERE FID = 1710793649282889728;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1710793649282889728,'double','mal_order','0',1.0000000000,'standard',1710793649282889728,'C','qty',{ts'2023-06-19  00:00:00'},1,'1','1',{ts'2023-06-19  00:00:00'},'entryentity.qty',' ',1); 

DELETE FROM t_pbd_esmappingprop_l WHERE FID = 1710793649282889728 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1710793649282889728,'3C48F14=8QKS','zh_CN','数量'); 


DELETE FROM t_pbd_esmappingprop WHERE FID = 1711780736475879424;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1711780736475879424,'keyword','mal_order','0',1.0000000000,'standard',1711780736475879424,'C','billstatus',{ts'2023-06-20  00:00:00'},1,'1','1',{ts'2023-06-20  00:00:00'},'billstatus',' ',1); 

DELETE FROM t_pbd_esmappingprop_l WHERE FID = 1711780736475879424 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1711780736475879424,'3C8ZVYQX5NI0','zh_CN','单据状态'); 


DELETE FROM t_pbd_esaggs_sub WHERE FPKID = 1711516479737978880;
INSERT INTO t_pbd_esaggs_sub(FID,FBASEDATAID,FPKID) VALUES (1598593684260208640,1711516339640084480,1711516479737978880); 

UPDATE t_pbd_esoutputentry SET FEVALPATH = '$.entryQtyAgg.value' WHERE FENTRYID = 1600788370278408192;
