/*  creator：嘟嘟
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_suspectset.sql</SqlScript> 
********************************************************************* 
*/ 
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1714414398686127104;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1714414398686127104,'ap_finapbill',' ','ap_finapbill','审核；提交；',1714414398686127104,'C','FCS_025_S','财务应付VS财务应付',' ',{ts'2023-06-24  00:00:00'},'0','财务应付疑似重复，有重复付款风险，请检查。',' ',' ',1031142881265452032,',submit,audit,','warning');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1714418785936498688;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1714418785936498688,'ar_finarbill',' ','ar_finarbill','审核；提交；',1714418785936498688,'C','FCS_026_S','财务应收VS财务应收',' ',{ts'2023-06-24  00:00:00'},'0','财务应收疑似重复，有重复支付风险，请检查。',' ',' ',1031142881265452032,',submit,audit,','warning');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1714421093399289856;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1714421093399289856,'ap_payapply',' ','ap_payapply','审核；提交；',1714421093399289856,'C','FCS_027_S','付款申请VS付款申请',' ',{ts'2023-06-24  00:00:00'},'0','付款申请疑似重复，有重复支付风险，请检查。',' ',' ',1031142881265452032,',submit,audit,','warning');


DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3CKKZDHE1DXB';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1714414398686127104,'3CKKZDHE1DXB','zh_CN','财务应付疑似重复，有重复付款风险，请检查。',' ',' ','审核；提交；','财务应付VS财务应付'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3CKKZDHE1DXC';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1714414398686127104,'3CKKZDHE1DXC','zh_TW','財務應付疑似重複，有重複付款風險，請檢查。',' ',' ',' ','財務應付VS財務應付'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3CKLSC4MDICA';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1714418785936498688,'3CKLSC4MDICA','zh_CN','财务应收疑似重复，有重复支付风险，请检查。',' ',' ','审核；提交；','财务应收VS财务应收'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3CKLSC4MDIC=';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1714418785936498688,'3CKLSC4MDIC=','zh_TW','財務應收疑似重複，有重複支付風險，請檢查。',' ',' ',' ','財務應收VS財務應收'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3CKM75XGX98V';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1714421093399289856,'3CKM75XGX98V','zh_CN','付款申请疑似重复，有重复支付风险，请检查。',' ',' ','审核；提交；','付款申请VS付款申请'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3CKM75XGX98W';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1714421093399289856,'3CKM75XGX98W','zh_TW','付款申請疑似重複，有重複支付風險，請檢查。',' ',' ',' ','付款申請VS付款申請'); 


DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1714414399332049920;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1714414398686127104,'[{"destname":"结算组织","checkkey":"org","destkey":"org","checkname":"结算组织"},{"destname":"往来户","checkkey":"asstact","destkey":"asstact","checkname":"往来户"},{"destname":"结算币别","checkkey":"currency","destkey":"currency","checkname":"结算币别"},{"destname":"单据头.应付金额","checkkey":"pricetaxtotal","destkey":"pricetaxtotal","checkname":"单据头.应付金额"},{"destname":"明细.应付金额","checkkey":"detailentry.e_pricetaxtotal","destkey":"detailentry.e_pricetaxtotal","checkname":"明细.应付金额"}]',' ','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKKWH30XMU=","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKKWH30XM50","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKKWH30XMU=\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKKWH30XM50\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKKXXW39QC7","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKKXXW39POZ","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKKXXW39QC7\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKKXXW39POZ\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','单据日期 本月',1714414399332049920,1,' ','结算组织 等于 结算组织 and 往来户 等于 往来户 and 结算币别 等于 ......','单据日期 本月',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1714418785961664512;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1714418785936498688,'[{"destname":"结算组织","checkkey":"org","destkey":"org","checkname":"结算组织"},{"destname":"往来户","checkkey":"asstact","destkey":"asstact","checkname":"往来户"},{"destname":"结算币别","checkkey":"currency","destkey":"currency","checkname":"结算币别"},{"destname":"单据头.应收金额","checkkey":"recamount","destkey":"recamount","checkname":"单据头.应收金额"},{"destname":"明细.应收金额","checkkey":"entry.e_recamount","destkey":"entry.e_recamount","checkname":"明细.应收金额"}]',' ','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKLRNLKH606","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKLRNLKH5BY","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKLRNLKH606\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKLRNLKH5BY\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKLS=F/7VIQ","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKLS=F/7UVG","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKLS=F/7VIQ\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKLS=F/7UVG\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','单据日期 本月',1714418785961664512,1,' ','结算组织 等于 结算组织 and 往来户 等于 往来户 and 结算币别 等于 ......','单据日期 本月',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1714421093432844288;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1714421093399289856,'[{"destname":"结算组织","checkkey":"settleorg","destkey":"settleorg","checkname":"结算组织"},{"destname":"结算币别","checkkey":"settlecurrency","destkey":"settlecurrency","checkname":"结算币别"},{"destname":"往来户","checkkey":"entry.e_asstact","destkey":"entry.e_asstact","checkname":"往来户"},{"destname":"单据头.申请金额","checkkey":"applyamount","destkey":"applyamount","checkname":"单据头.申请金额"},{"destname":"明细.申请金额","checkkey":"entry.e_applyamount","destkey":"entry.e_applyamount","checkname":"明细.申请金额"}]',' ','{"expression":"","exprTran":"申请日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKM562HD/BL","leftBracket":"","compareType":"63","fieldName":"applydate","rightBracket":"","logic":"0","value":[{"id":"3CKM562HD0/V","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKM562HD/BL\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"applydate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKM562HD0/V\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"申请日期 本月"},"exprDesc":"申请日期 本月"}','{"expression":"","exprTran":"申请日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKM72EQX2/4","leftBracket":"","compareType":"63","fieldName":"applydate","rightBracket":"","logic":"0","value":[{"id":"3CKM72EQX1AW","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKM72EQX2/4\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"applydate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKM72EQX1AW\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"申请日期 本月"},"exprDesc":"申请日期 本月"}','申请日期 本月',1714421093432844288,1,' ','结算组织 等于 结算组织 and 结算币别 等于 结算币别 and 往来户 等于......','申请日期 本月',' '); 


