DELETE FROM t_pur_calformulaentity WHERE FENTRYID = 1441920690541471744;
INSERT INTO t_pur_calformulaentity(FEVADIMENSIONFILTER,FID,FENTITYCODE,FENTRYID,FORGFIELD,FGROUPBY,FSUPPLIERFIELD,FMATERIALFIELD,FCHILDFORMULA,FAFTERFILTER,FEVALPERIODFIELD,FSEQ,FCHILDFORMULATRAN,FBEFOREFILTER,FAFTERFILTERTRAN,FMETADATAID,FBEFOREFILTERTRAN) VALUES ('A',1441920690491140096,'result1',1441920690541471744,'org',' ','supplier','entryentity.material',' sum( entryentity.timelyreceiptqty  ) ',' ','billdate',1,' sum( 基本及时收货数  ) ','billstatus = ''C''',' ','srm_receipt_sync','单据状态 = ''C'''); 
DELETE FROM t_pur_calformulaentity WHERE FENTRYID = 1442895206801288192;
INSERT INTO t_pur_calformulaentity(FEVADIMENSIONFILTER,FID,FENTITYCODE,FENTRYID,FORGFIELD,FGROUPBY,FSUPPLIERFIELD,FMATERIALFIELD,FCHILDFORMULA,FAFTERFILTER,FEVALPERIODFIELD,FSEQ,FCHILDFORMULATRAN,FBEFOREFILTER,FAFTERFILTERTRAN,FMETADATAID,FBEFOREFILTERTRAN) VALUES ('A',1441920690491140096,'result2',1442895206801288192,'org','entryentity.poentryid','supplier','entryentity.material','max(  entryentity.orderqty  ) ',' ','billdate',2,'max(  基本订单数量  ) ','billstatus = ''C''',' ','srm_receipt_sync','单据状态 = ''C'''); 
DELETE FROM t_pur_calformulaentity WHERE FENTRYID = 1442907054518902784;
INSERT INTO t_pur_calformulaentity(FEVADIMENSIONFILTER,FID,FENTITYCODE,FENTRYID,FORGFIELD,FGROUPBY,FSUPPLIERFIELD,FMATERIALFIELD,FCHILDFORMULA,FAFTERFILTER,FEVALPERIODFIELD,FSEQ,FCHILDFORMULATRAN,FBEFOREFILTER,FAFTERFILTERTRAN,FMETADATAID,FBEFOREFILTERTRAN) VALUES ('A',1442907054493736960,'result1',1442907054518902784,'org',' ','entryentity.supplier','entryentity.materialid','sum(  entryentity.basequaliqty  ) /  sum(  entryentity.baseqty  ) ',' ','inspeenddate',1,'sum(  基本单位合格数  ) /  sum(  基本数量  ) ','billstatus = ''C''',' ','srm_inspectbill_sync','单据状态 = ''C'''); 

DELETE FROM t_pur_calformula WHERE FID = 1441920690491140096;
INSERT INTO t_pur_calformula(FID,FISPREINSDATA,FAUDITORID,FPLUGINNAME,FMASTERID,FSTATUS,FNUMBER,FFORMULAPREVIEW,FAUDITDATE,FCREATETIME,FMODIFIERID,FENABLE,FCALMETHOD,FREMARK,FMODIFYTIME,FCREATORID,FFORMULA) VALUES (1441920690491140096,'1',1271038535109015552,' ',1441920690491140096,'C','Timely_delivery_Rate','( sum( 基本及时收货数  ) )  /  (max(  基本订单数量  ) )  * 100',{ts'2022-07-26  00:00:00'},{ts'2022-06-13  00:00:00'},1271038535109015552,'1','A','计算公式总表达式中，乘以100，表示的是百分制应用，对应的评估指标定量区间也需是在百分制区间进行设置。例如：交货及时率计算结果为70%时，公式计算值是70。在评估指标设置定量的区间时，可设置90--100；60--90；0--60等；',{ts'2022-07-26  00:00:00'},1271038535109015552,'result1  /  result2  * 100'); 
DELETE FROM t_pur_calformula WHERE FID = 1442907054493736960;
INSERT INTO t_pur_calformula(FID,FISPREINSDATA,FAUDITORID,FPLUGINNAME,FMASTERID,FSTATUS,FNUMBER,FFORMULAPREVIEW,FAUDITDATE,FCREATETIME,FMODIFIERID,FENABLE,FCALMETHOD,FREMARK,FMODIFYTIME,FCREATORID,FFORMULA) VALUES (1442907054493736960,'1',1271038535109015552,' ',1442907054493736960,'C','inspectbill_rate','(sum(  基本单位合格数  ) /  sum(  基本数量  ) ) * 100',{ts'2022-07-26  00:00:00'},{ts'2022-06-14  00:00:00'},1271038535109015552,'1','A','计算公式总表达式中，乘以100，表示的是百分制应用，对应的评估指标定量区间也需是在百分制区间进行设置。例如：来料合格率计算结果为60%时，公式计算值是60。在评估指标设置定量的区间时，可设置90--100；70--90；0--70等；',{ts'2022-07-27  00:00:00'},1271038535109015552,'result1 * 100'); 

DELETE FROM t_pur_calformula_l WHERE FPKID = '2I32ODK198XH';
INSERT INTO t_pur_calformula_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1441920690491140096,'2I32ODK198XH','zh_CN','交货及时率'); 
DELETE FROM t_pur_calformula_l WHERE FPKID = '2I32ODK198XI';
INSERT INTO t_pur_calformula_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1441920690491140096,'2I32ODK198XI','zh_TW','交貨及時率'); 
DELETE FROM t_pur_calformula_l WHERE FPKID = '2I7U+/N6BYBK';
INSERT INTO t_pur_calformula_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1442907054493736960,'2I7U+/N6BYBK','zh_CN','来料合格率'); 
DELETE FROM t_pur_calformula_l WHERE FPKID = '2I7U+/N6BYBL';
INSERT INTO t_pur_calformula_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1442907054493736960,'2I7U+/N6BYBL','zh_TW','來料合格率'); 

