DELETE FROM t_ap_matchrelation WHERE FID = 1978312450813984768;
INSERT INTO t_ap_matchrelation(FID,FCREATORID,FISPRESET,FMODIFIERID,FISDEFAULT,FMODIFYTIME,FENABLE,FNAME,FCREATETIME,FNUMBER,FSTATUS,FMASTERID) VALUES (1978312450813984768,1,'1',1,'1',{ts'2024-08-08  00:00:00'},'1','发票匹配入库',{ts'2024-08-08  00:00:00'},'PPGX001','C',1978312450813984768);
DELETE FROM t_ap_matchrelation WHERE FID = 1978313209672631296;
INSERT INTO t_ap_matchrelation(FID,FCREATORID,FISPRESET,FMODIFIERID,FISDEFAULT,FMODIFYTIME,FENABLE,FNAME,FCREATETIME,FNUMBER,FSTATUS,FMASTERID) VALUES (1978313209672631296,1,'1',1,'0',{ts'2024-08-08  00:00:00'},'1','发票匹配订单',{ts'2024-08-08  00:00:00'},'PPGX002','C',1978313209672631296);
DELETE FROM t_ap_matchrelation WHERE FID = 2005755815356539904;
INSERT INTO t_ap_matchrelation(FID,FCREATORID,FISPRESET,FMODIFIERID,FISDEFAULT,FMODIFYTIME,FENABLE,FNAME,FCREATETIME,FNUMBER,FSTATUS,FMASTERID) VALUES (2005755815356539904,1,'1',1,'0',{ts'2024-08-08  00:00:00'},'1','发票匹配收货',{ts'2024-08-08  00:00:00'},'PPGX003','C',2005755815356539904);
DELETE FROM t_ap_matchrelation WHERE FID = 2007399945774042112;
INSERT INTO t_ap_matchrelation(FID,FCREATORID,FISPRESET,FMODIFIERID,FISDEFAULT,FMODIFYTIME,FENABLE,FNAME,FCREATETIME,FNUMBER,FSTATUS,FMASTERID) VALUES (2007399945774042112,1,'1',1,'0',{ts'2024-08-08  00:00:00'},'1','发票匹配验收',{ts'2024-08-08  00:00:00'},'PPGX004','C',2007399945774042112);

DELETE FROM t_ap_matchrelation_l WHERE FPKID = '47+X6+IR5CM/';
INSERT INTO t_ap_matchrelation_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (1978312450813984768,'47+X6+IR5CM/','zh_CN','发票匹配入库','物料类采购，发票匹配采购入库单。');
DELETE FROM t_ap_matchrelation_l WHERE FPKID = '47+XAI6JS7E0';
INSERT INTO t_ap_matchrelation_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (1978313209672631296,'47+XAI6JS7E0','zh_CN','发票匹配订单','费用类采购，发票匹配采购订单。');
DELETE FROM t_ap_matchrelation_l WHERE FPKID = '4=CCVENX+4RE';
INSERT INTO t_ap_matchrelation_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (2005755815356539904,'4=CCVENX+4RE','zh_CN','发票匹配收货','资产类采购，发票匹配采购收货单。');
DELETE FROM t_ap_matchrelation_l WHERE FPKID = '4=K911LG08I+';
INSERT INTO t_ap_matchrelation_l(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (2007399945774042112,'4=K911LG08I+','zh_CN','发票匹配验收','金额基准服务类采购，发票匹配采购验收单。');

DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 1978312450847539200;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (1978312450813984768,' ','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )',1978312450847539200,' ',1,'ap_invoice','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )','qty',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 1978312450847539201;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (1978312450813984768,' ','单据状态 等于 已审核   and    冲销 等于 否   and    已被冲销 等于 否   and    物料明细.物流单据 等于 否   and    物料明细.未退库基本数量 不等于 0   and    物料明细.未核销基本数量 不等于 0   and    库存事务.编码 不在……中 (''130'',''1301'',''132'')',1978312450847539201,' ',2,'im_purinbill','单据状态 等于 已审核   and    冲销 等于 否   and    已被冲销 等于 否   and    物料明细.物流单据 等于 否   and    物料明细.未退库基本数量 不等于 0   and    物料明细.未核销基本数量 不等于 0   and    库存事务.编码 不在……中 (''130'',''1301'',''132'')','qty',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 1978313209706185728;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (1978313209672631296,' ','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )',1978313209706185728,' ',1,'ap_invoice','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )','qty',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 1978313209706185729;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (1978313209672631296,' ','单据状态 等于 已审核   and    变更状态 不等于 变更中   and    物料明细.行类型.业务属性.编码 等于 2002 且 数量 >  关联验收应付数量 ',1978313209706185729,' ',2,'pm_purorderbill','单据状态 等于 已审核   and    变更状态 不等于 变更中   and    物料明细.行类型.业务属性.编码 等于 2002 且 数量 >  关联验收应付数量 ','qty',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 2005755830615417856;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (2005755815356539904,' ','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )',2005755830615417856,' ',1,'ap_invoice','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )','qty',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 2005755830615417857;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (2005755815356539904,' ','单据状态 等于 已审核   and    冲销 等于 否   and    已被冲销 等于 否   and    物料明细.物流单据 等于 否   and    业务类型.编码 等于 111   and    物料明细.已入库数量 等于 0   and    物料明细.未核销基本数量 不等于 0',2005755830615417857,' ',2,'im_purreceivebill','单据状态 等于 已审核   and    冲销 等于 否   and    已被冲销 等于 否   and    物料明细.物流单据 等于 否   and    业务类型.编码 等于 111   and    物料明细.已入库数量 等于 0   and    物料明细.未核销基本数量 不等于 0','qty',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 2007399945824373760;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (2007399945774042112,' ','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )',2007399945824373760,' ',1,'ap_invoice','单据状态 等于 已审核   and    已匹配 等于 否   and   ( 发票状态 等于 正常   or    发票状态 为空 )','amt',' ',' ');
DELETE FROM t_ap_matchrelation_e WHERE FENTRYID = 2007399945824373761;
INSERT INTO t_ap_matchrelation_e(FID,FCUSTOMERFILTERDESC_TAG,FPRESETFILTER,FENTRYID,FCUSTOMERFILTERDESC,FSEQ,FMATCHOBJECT,FPRESETFILTERDESC,FBIZTYPE,FPRESETFILTERDESC_TAG,FCUSTOMERFILTER) VALUES (2007399945774042112,' ','单据状态 等于 已审核   and    物料明细.行关闭状态 不等于 已关闭 且 (业务类型.编码 = "112" and  价税合计  >=  关联应付金额 ) or  (  业务类型.编码  =  "1121" and  价税合计  <=  关联应付金额 ) ',2007399945824373761,' ',2,'pm_puracceptbill','单据状态 等于 已审核   and    物料明细.行关闭状态 不等于 已关闭 且 (业务类型.编码 = "112" and  价税合计  >=  关联应付金额 ) or  (  业务类型.编码  =  "1121" and  价税合计  <=  关联应付金额 ) ','amt',' ',' ');
