/*  creator：IERP
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_suspectset.sql</SqlScript> 
********************************************************************* 
*/ 
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1469693853895232512;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1469693853895232512,'fca_transupbill',' ','fca_transupbill','审核；保存；提交；',1469693853895232512,'C','FCS_007_S','上划处理vs上划处理',' ',{ts'2018-08-08  00:00:00'},'1','存在疑似重复数据，请人工落地确认','自动提交银企；确认已付款；提交银企；',',autocommitbei,commitbei,barpayconfirm,',1,',audit,submit,save,','landing'); 
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1472350769704393728;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1472350769704393728,'fca_transdownbill',' ','fca_transdownbill','审核；保存；提交；',1472350769704393728,'C','FCS_010_S','下拨处理vs下拨处理',' ',{ts'2018-08-08  00:00:00'},'1','存在疑似重复数据，请人工落地确认','自动提交银企；付款-银企互联；确认已付款；提交银企；',',autocommitbei,barpaybei,barpayconfirm,commitbei,',1,',audit,submit,save,','landing'); 
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1469672561469087744;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1469672561469087744,'bei_bankpaybill',' ','bei_bankpaybill','保存；',1469672561469087744,'C','FCS_003_S','银行付款单vs银行付款单',' ',{ts'2018-08-08  00:00:00'},'1','存在疑似重复数据，请人工落地确认','提交银企；',',commitbe,',1,',save,','landing'); 


DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '2LI4ZZOCMJWA';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1469693853895232512,'2LI4ZZOCMJWA','zh_CN','存在疑似重复数据，请人工落地确认','自动提交银企；确认已付款；提交银企；',' ','审核；保存；提交；','上划处理vs上划处理'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '2LI1+TIR5X8O';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1469672561469087744,'2LI1+TIR5X8O','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','銀行付款單vs銀行付款單'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '2LI4ZZOCMJWB';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1469693853895232512,'2LI4ZZOCMJWB','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','上劃處理vs上劃處理'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '2LI1+TIR5X8N';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1469672561469087744,'2LI1+TIR5X8N','zh_CN','存在疑似重复数据，请人工落地确认','提交银企；',' ','保存；','银行付款单vs银行付款单'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '2LUWDVSA8RBY';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1472350769704393728,'2LUWDVSA8RBY','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','下撥處理vs下撥處理'); 
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '2LUWDVSA8RBX';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1472350769704393728,'2LUWDVSA8RBX','zh_CN','存在疑似重复数据，请人工落地确认','自动提交银企；付款-银企互联；确认已付款；提交银企；',' ','审核；保存；提交；','下拨处理vs下拨处理'); 


DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1469672561511030784;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1469672561469087744,'[{"destname":"付款账号.付款账号.银行账号","checkkey":"accountbank.bankaccountnumber","destkey":"accountbank.bankaccountnumber","checkname":"付款账号.付款账号.银行账号"},{"destname":"单据头.收款账号","checkkey":"payeeacct","destkey":"payeeacct","checkname":"单据头.收款账号"},{"destname":"币别.币别.货币代码","checkkey":"currency.number","destkey":"currency.number","checkname":"币别.币别.货币代码"},{"destname":"单据头.付款金额","checkkey":"amount","destkey":"amount","checkname":"单据头.付款金额"},{"destname":"单据头.附言","checkkey":"usage","destkey":"usage","checkname":"单据头.附言"},{"destname":"单据头.描述","checkkey":"description","destkey":"description","checkname":"单据头.描述"}]',' ',' ','{"expression":"","exprTran":"( 业务日期 本周   or    业务日期 上周 )  and    单据状态 不在……中 (已失败重付,已打回)   and    付款状态 不在……中 (交易失败)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2LI1+I59/ECH","leftBracket":"(","compareType":"10","fieldName":"bizdate","rightBracket":"","logic":"1","value":[{"id":"2LI1+I5906+S","value":""}],"baseDataIds":[]},{"id":"2LI1+I59/ECI","leftBracket":"","compareType":"61","fieldName":"bizdate","rightBracket":")","logic":"0","value":[{"id":"2LI1+I5906+T","value":""}],"baseDataIds":[]},{"id":"2LNXIR0ZN8FU","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2LNXIR0ZN942","value":"F"},{"id":"2LNXLIFMWMHK","value":"T"}],"baseDataIds":[]},{"id":"2LNXIR0ZN8FV","leftBracket":"","compareType":"34","fieldName":"bankpaystate","rightBracket":"","logic":"0","value":[{"id":"2LNXIR0ZN943","value":"TF"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2LI1+I59/ECH\",\"leftBracket\":\"(\",\"compareType\":\"10\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"2LI1+I5906+S\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LI1+I59/ECI\",\"leftBracket\":\"\",\"compareType\":\"61\",\"fieldName\":\"bizdate\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"2LI1+I5906+T\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LNXIR0ZN8FU\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LNXIR0ZN942\",\"value\":\"F\"},{\"id\":\"2LNXLIFMWMHK\",\"value\":\"T\"}],\"baseDataIds\":[]},{\"id\":\"2LNXIR0ZN8FV\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"bankpaystate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LNXIR0ZN943\",\"value\":\"TF\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"( 业务日期 本周   or    业务日期 上周 )  and    单据状态 不在……中 (已失败重付,已打回)   and    付款状态 不在……中 (交易失败)"},"exprDesc":"( 业务日期 本周   or    业务日期 上周 )  and    单据状态 不在……中 (已失败重付,已打回)   and    付款状态 不在……中 (交易失败)"}',' ',1469672561511030784,1,' ','付款账号.付款账号.银行账号 等于 付款账号.付款账号.银行账号 and 单据头......','( 业务日期 本周   or    业务日期 上周 )  and    单据状态......',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1469693853937175552;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1469693853895232512,'[{"destname":"母账户银行账号.母账户银行账号.银行账号","checkkey":"accountbank.bankaccountnumber","destkey":"accountbank.bankaccountnumber","checkname":"母账户银行账号.母账户银行账号.银行账号"},{"destname":"币别.币别.货币代码","checkkey":"currency.number","destkey":"currency.number","checkname":"币别.币别.货币代码"},{"destname":"子账户银行账号.子账户银行账号.银行账号","checkkey":"entrys.subacct.bankaccountnumber","destkey":"entrys.subacct.bankaccountnumber","checkname":"子账户银行账号.子账户银行账号.银行账号"},{"destname":"划拨明细.上划金额","checkkey":"entrys.transamt","destkey":"entrys.transamt","checkname":"划拨明细.上划金额"},{"destname":"划拨明细.备注","checkkey":"entrys.remark","destkey":"entrys.remark","checkname":"划拨明细.备注"}]',' ',' ','{"expression":"","exprTran":"上划日期 今天   and    单据状态 不在……中 (已作废)   and    划拨明细.付款状态 不在……中 (交易失败)   and    划拨明细.明细状态 不在……中 (已作废,打回,删除)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2LI4ZRHUV2XD","leftBracket":"","compareType":"13","fieldName":"transbilldate","rightBracket":"","logic":"0","value":[{"id":"2LI4ZRHUV3KN","value":""}],"baseDataIds":[]},{"id":"2LI4ZRHUV2XE","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2LI4ZRHUV3KO","value":"S"}],"baseDataIds":[]},{"id":"2N72YA8Q7EB2","leftBracket":"","compareType":"34","fieldName":"paystatus","rightBracket":"","logic":"0","value":[{"id":"2N72YA8Q85=3","value":"payfail"}],"baseDataIds":[]},{"id":"2N72YA8Q7EB3","leftBracket":"","compareType":"34","fieldName":"state","rightBracket":"","logic":"0","value":[{"id":"2N72YA8Q85=4","value":"discard"},{"id":"2OJA7K8WXJX7","value":"back"},{"id":"2OJA7K8WXIJP","value":"delete"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2LI4ZRHUV2XD\",\"leftBracket\":\"\",\"compareType\":\"13\",\"fieldName\":\"transbilldate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LI4ZRHUV3KN\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LI4ZRHUV2XE\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LI4ZRHUV3KO\",\"value\":\"S\"}],\"baseDataIds\":[]},{\"id\":\"2N72YA8Q7EB2\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"paystatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N72YA8Q85=3\",\"value\":\"payfail\"}],\"baseDataIds\":[]},{\"id\":\"2N72YA8Q7EB3\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"state\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N72YA8Q85=4\",\"value\":\"discard\"},{\"id\":\"2OJA7K8WXJX7\",\"value\":\"back\"},{\"id\":\"2OJA7K8WXIJP\",\"value\":\"delete\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"上划日期 今天   and    单据状态 不在……中 (已作废)   and    划拨明细.付款状态 不在……中 (交易失败)   and    划拨明细.明细状态 不在……中 (已作废,打回,删除)","localeExprTran":{"zh_CN":"上划日期 今天   and    单据状态 不在……中 (已作废)   and    划拨明细.付款状态 不在……中 (交易失败)   and    划拨明细.明细状态 不在……中 (已作废,打回,删除)"}}',' ',1469693853937175552,1,' ','母账户银行账号.母账户银行账号.银行账号 等于 母账户银行账号.母账户银行账号.......','上划日期 今天   and    单据状态 不在……中 (已作废)   and ......',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1472350769737948160;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1472350769704393728,'[{"destname":"母账户银行账号.母账户银行账号.银行账号","checkkey":"accountbank.bankaccountnumber","destkey":"accountbank.bankaccountnumber","checkname":"母账户银行账号.母账户银行账号.银行账号"},{"destname":"子账户银行账号.子账户银行账号.银行账号","checkkey":"entrys.subacct.bankaccountnumber","destkey":"entrys.subacct.bankaccountnumber","checkname":"子账户银行账号.子账户银行账号.银行账号"},{"destname":"币别.币别.货币代码","checkkey":"currency.number","destkey":"currency.number","checkname":"币别.币别.货币代码"},{"destname":"下拨明细.下拨金额","checkkey":"entrys.transamt","destkey":"entrys.transamt","checkname":"下拨明细.下拨金额"},{"destname":"下拨明细.备注","checkkey":"entrys.remark","destkey":"entrys.remark","checkname":"下拨明细.备注"}]',' ',' ','{"expression":"","exprTran":"下拨日期 今天   and    单据状态 不在……中 (已作废)   and    下拨明细.付款状态 不在……中 (交易失败)   and    下拨明细.明细状态 不在……中 (已作废,打回,删除)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2LUWDS/E3R+N","leftBracket":"","compareType":"13","fieldName":"transbilldate","rightBracket":"","logic":"0","value":[{"id":"2LUWDS/HRXTF","value":""}],"baseDataIds":[]},{"id":"2LUWDS/HR565","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2LUWDS/HRXTG","value":"S"}],"baseDataIds":[]},{"id":"2N744QOWOBKH","leftBracket":"","compareType":"34","fieldName":"paystatus","rightBracket":"","logic":"0","value":[{"id":"2N744QOWNLMG","value":"payfail"}],"baseDataIds":[]},{"id":"2N744QOWOBKI","leftBracket":"","compareType":"34","fieldName":"state","rightBracket":"","logic":"0","value":[{"id":"2N744QOWNLMH","value":"discard"},{"id":"2OJAB=QVXX9B","value":"back"},{"id":"2OJAB=QVXVXU","value":"delete"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2LUWDS/E3R+N\",\"leftBracket\":\"\",\"compareType\":\"13\",\"fieldName\":\"transbilldate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LUWDS/HRXTF\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LUWDS/HR565\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LUWDS/HRXTG\",\"value\":\"S\"}],\"baseDataIds\":[]},{\"id\":\"2N744QOWOBKH\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"paystatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N744QOWNLMG\",\"value\":\"payfail\"}],\"baseDataIds\":[]},{\"id\":\"2N744QOWOBKI\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"state\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N744QOWNLMH\",\"value\":\"discard\"},{\"id\":\"2OJAB=QVXX9B\",\"value\":\"back\"},{\"id\":\"2OJAB=QVXVXU\",\"value\":\"delete\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"下拨日期 今天   and    单据状态 不在……中 (已作废)   and    下拨明细.付款状态 不在……中 (交易失败)   and    下拨明细.明细状态 不在……中 (已作废,打回,删除)","localeExprTran":{"zh_CN":"下拨日期 今天   and    单据状态 不在……中 (已作废)   and    下拨明细.付款状态 不在……中 (交易失败)   and    下拨明细.明细状态 不在……中 (已作废,打回,删除)"}}',' ',1472350769737948160,1,' ','母账户银行账号.母账户银行账号.银行账号 等于 母账户银行账号.母账户银行账号.......','下拨日期 今天   and    单据状态 不在……中 (已作废)   and ......',' '); 


