-- 上划下拨业务单据适用条件日期改为：今天
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 ......',' ');
