/*  creator：IERP
支付安全专项加固，交易准入、支付防重、疑似防重调整6月迭代二
开证处理 -> 到单处理超额校验脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415309445017124864;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1415309445017124864,'{"filterRow":[],"forList":false}',' ','0',' ','【理财申请】下推【理财申购】出现超额，请检查','1','【理财申请】下推【理财申购】出现重复，请检查',',submit,save,','LargerOrEqual',1415309445017124864,'cim_finsubscribe',' ','C','1','cim_finapply -> cim_finsubscribe',' ',1415304979878564864,',save,submit,',' ','1','1','0','cim_finapply');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EULGPLXEFZ2';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415309445017124864,'2EULGPLXEFZ2','zh_CN','【理财申请】下推【理财申购】出现超额，请检查',' ','【理财申请】下推【理财申购】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EULGPLXEFZ3';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415309445017124864,'2EULGPLXEFZ3','zh_TW','【理財申請】下推【理財申購】出現超額，請檢查',' ','【理財申請】下推【理財申購】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1705805709238693888;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415309445017124864,'Head',' ',1705805709238693888,' ',' ',' ','单据头.理财金额','Head','amount',1,'amount',' ',' ','单据头.理财金额');


/*  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 = 1706458651767622656;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706458651767622656,'tm_forex_swaps',' ','tm_forex_swaps','保存；提交；',1706458651767622656,'C','FCS_021_S','外汇掉期vs外汇掉期',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706449157910187008;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706449157910187008,'tm_forex_forward',' ','tm_forex_forward','保存；提交；',1706449157910187008,'C','FCS_020_S','外汇远期vs外汇远期',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706527664266826752;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706527664266826752,'tm_businessbill',' ','tm_businessbill','保存；提交；',1706527664266826752,'C','FCS_023_S','交易生命周期管理vs交易生命周期管理',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',submit,save,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1705728441904644096;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1705728441904644096,'lc_arrival',' ','lc_arrival','保存；提交；',1705728441904644096,'C','FCS_016_S','到单处理vs到单处理',' ',{ts'2023-06-12  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1705901955378934784;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1705901955378934784,'cfm_interestbill',' ','cfm_interestbill','保存；提交；',1705901955378934784,'C','FCS_017_S','付息处理vs付息处理',' ',{ts'2023-06-12  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',submit,save,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1705904979455341568;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1705904979455341568,'cfm_preinterestbill',' ','cfm_preinterestbill','保存；提交；',1705904979455341568,'C','FCS_018_S','应付利息预提vs应付利息预提',' ',{ts'2023-06-12  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',submit,save,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706445061291635712;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706445061291635712,'tm_forex',' ','tm_forex','保存；提交；',1706445061291635712,'C','FCS_019_S','外汇即期vs外汇即期',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706465868285867008;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706465868285867008,'tm_forex_options',' ','tm_forex_options','保存；提交；',1706465868285867008,'C','FCS_022_S','外汇期权vs外汇期权',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1707420147389578240;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1707420147389578240,'fbd_surety_append',' ','fbd_surety_append','保存；提交；',1707420147389578240,'C','FCS_024_S','保证金追加处理vs保证金追加处理',' ',{ts'2023-06-14  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');


DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BI+0+0LRV6=';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705728441904644096,'3BI+0+0LRV6=','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','到单处理vs到单处理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BITFCDEB2JC';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705901955378934784,'3BITFCDEB2JC','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','付息處理vs付息處理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLDXZWVFAM3';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706445061291635712,'3BLDXZWVFAM3','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙即期vs外彙即期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BI+0+0LRV6A';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705728441904644096,'3BI+0+0LRV6A','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','到單處理vs到單處理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLGG/0SB0NK';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706458651767622656,'3BLGG/0SB0NK','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙掉期vs外彙掉期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLGG/0SB0NL';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706458651767622656,'3BLGG/0SB0NL','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇掉期vs外汇掉期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLEOU7+LMOO';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706449157910187008,'3BLEOU7+LMOO','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙遠期vs外彙遠期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLEOU7+LMOP';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706449157910187008,'3BLEOU7+LMOP','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇远期vs外汇远期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLTBWWTLMFR';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706527664266826752,'3BLTBWWTLMFR','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','交易生命周期管理vs交易生命周期管理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLTBWWTLMFS';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706527664266826752,'3BLTBWWTLMFS','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','交易生命周期管理vs交易生命周期管理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BITFCDEB2JB';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705901955378934784,'3BITFCDEB2JB','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','付息处理vs付息处理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BIU/DUT/XPS';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705904979455341568,'3BIU/DUT/XPS','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','應付利息預提vs應付利息預提');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BIU/DUT/XPR';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705904979455341568,'3BIU/DUT/XPR','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','应付利息预提vs应付利息预提');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLDXZWVFAM2';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706445061291635712,'3BLDXZWVFAM2','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇即期vs外汇即期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BQ23DQG5F=6';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1707420147389578240,'3BQ23DQG5F=6','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','保證金追加處理vs保證金追加處理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BQ23DQG5F=7';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1707420147389578240,'3BQ23DQG5F=7','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','保证金追加处理vs保证金追加处理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLHTKY1F6SK';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706465868285867008,'3BLHTKY1F6SK','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙期權vs外彙期權');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLHTKY1F6SL';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706465868285867008,'3BLHTKY1F6SL','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇期权vs外汇期权');


DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1705728442089193472;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1705728441904644096,'[{"destname":"单据头.到单日期","checkkey":"arrivaldate","shortname":"","destkey":"arrivaldate","checkname":"单据头.到单日期"},{"destname":"信用证号.信用证号.信用证号","checkkey":"lettercredit.number","shortname":"","destkey":"lettercredit.number","checkname":"信用证号.信用证号.信用证号"}]',' ',' ',' ',' ',1705728442089193472,1,' ','单据头.到单日期 等于 单据头.到单日期 and 信用证号.信用证号.信用证号 ......',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1705901956108743683;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1705901955378934784,'[{"destname":"单据头.源单id","checkkey":"sourcebillid","shortname":"","destkey":"sourcebillid","checkname":"单据头.源单id"},{"destname":"单据头.付息日","checkkey":"bizdate","shortname":"","destkey":"bizdate","checkname":"单据头.付息日"}]',' ','{"expression":"","exprTran":"冲销状态 不等于 已冲销","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BITDB3F1AJQ","leftBracket":"","compareType":"106","fieldName":"writeoffstatus","rightBracket":"","logic":"0","value":[{"id":"3BITDB3F1B8+","value":"writeoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BITDB3F1AJQ\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"writeoffstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BITDB3F1B8+\",\"value\":\"writeoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"冲销状态 不等于 已冲销","localeExprTran":{"zh_CN":"冲销状态 不等于 已冲销"}}','{"expression":"","exprTran":"冲销状态 不等于 已冲销","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BITE7NG+P4Q","leftBracket":"","compareType":"106","fieldName":"writeoffstatus","rightBracket":"","logic":"0","value":[{"id":"3BITE7TE18T=","value":"writeoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BITE7NG+P4Q\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"writeoffstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BITE7TE18T=\",\"value\":\"writeoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"冲销状态 不等于 已冲销","localeExprTran":{"zh_CN":"冲销状态 不等于 已冲销"}}','冲销状态 不等于 已冲销',1705901956108743683,1,' ','单据头.源单id 等于 单据头.源单id and 单据头.付息日 等于 单据头.付息日','冲销状态 不等于 已冲销',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1705904980277424128;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1705904979455341568,'[{"destname":"单据头.源单id","checkkey":"sourcebillid","shortname":"","destkey":"sourcebillid","checkname":"单据头.源单id"},{"destname":"单据头.预提日期","checkkey":"prestenddate","shortname":"","destkey":"prestenddate","checkname":"单据头.预提日期"}]',' ','{"expression":"","exprTran":"冲销状态 不在……中 (红字冲销,已冲销)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BITZ7+GSFM=","leftBracket":"","compareType":"34","fieldName":"writeoffstatus","rightBracket":"","logic":"0","value":[{"id":"3BITZ7+GSG=J","value":"red_writeoff"},{"id":"3BITZ7+GSFMA","value":"writeoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BITZ7+GSFM=\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"writeoffstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BITZ7+GSG=J\",\"value\":\"red_writeoff\"},{\"id\":\"3BITZ7+GSFMA\",\"value\":\"writeoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"冲销状态 不在……中 (红字冲销,已冲销)","localeExprTran":{"zh_CN":"冲销状态 不在……中 (红字冲销,已冲销)"}}','{"expression":"","exprTran":"冲销状态 不在……中 (已冲销,红字冲销)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BIU+HK7X2+A","leftBracket":"","compareType":"34","fieldName":"writeoffstatus","rightBracket":"","logic":"0","value":[{"id":"3BIU+HK7X2NK","value":"writeoff"},{"id":"3BIU+HK7X2+B","value":"red_writeoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BIU+HK7X2+A\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"writeoffstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BIU+HK7X2NK\",\"value\":\"writeoff\"},{\"id\":\"3BIU+HK7X2+B\",\"value\":\"red_writeoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"冲销状态 不在……中 (已冲销,红字冲销)","localeExprTran":{"zh_CN":"冲销状态 不在……中 (已冲销,红字冲销)"}}','冲销状态 不在……中 (红字冲销,已冲销)',1705904980277424128,1,' ','单据头.源单id 等于 单据头.源单id and 单据头.预提日期 等于 单据头.预提日期','冲销状态 不在……中 (已冲销,红字冲销)',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706445061887226880;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706445061291635712,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLDWG1WD6P9","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLDWG1WF01F","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLDWG1WD6P9\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLDWG1WF01F\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706445061887226880,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706449158799379456;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706449157910187008,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLE9RZ+1BWM","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLE9RZ+368T","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLE9RZ+1BWM\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLE9RZ+368T\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706449158799379456,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706458651809565696;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706458651767622656,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLGFW08SWJ3","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLGFW08R15Y","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLGFW08SWJ3\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLGFW08R15Y\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706458651809565696,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706465868327810048;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706465868285867008,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLHTFTQ8/S2","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLHTFTQ9V49","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLHTFTQ8/S2\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLHTFTQ9V49\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706465868327810048,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706527664392655872;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706527664266826752,' ',' ','{"expression":"","exprTran":"产品类型.编码 等于 02SWAP","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLTUPL7=ZOP","leftBracket":"","compareType":"67","fieldName":"protecttype.number","rightBracket":"","logic":"0","value":[{"id":"3BLTUPL7=Z/F","value":"02SWAP"}],"baseDataIds":[{"id":"3BLTUPL7=ZOQ","value":"952722152971330560"}]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLTUPL7=ZOP\",\"leftBracket\":\"\",\"compareType\":\"67\",\"fieldName\":\"protecttype.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLTUPL7=Z/F\",\"value\":\"02SWAP\"}],\"baseDataIds\":[{\"id\":\"3BLTUPL7=ZOQ\",\"value\":\"952722152971330560\"}]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"产品类型.编码 等于 02SWAP"},"exprDesc":"产品类型.编码 等于 02SWAP"}',' ','产品类型.编码 等于 02SWAP',1706527664392655872,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 交易号.交易对......',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706528079268041728;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706527664266826752,'[{"destname":"单据头.生命周期","checkkey":"operate","shortname":"","destkey":"operate","checkname":"单据头.生命周期"},{"destname":"交易号.交易号.编码","checkkey":"tradebill.number","shortname":"","destkey":"tradebill.number","checkname":"交易号.交易号.编码"}]',' ',' ',' ','产品类型.编码 在……中 (''01FORWRATEAGREE'',''01STRUCTDEPOSIT'')',1706528079268041728,2,' ','单据头.生命周期 等于 单据头.生命周期 and 交易号.交易号.编码 等于 交易号.交易号.编码',' ',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1707420147431521280;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1707420147389578240,'[{"destname":"单据头.源单id","checkkey":"sourcebillid","shortname":"","destkey":"sourcebillid","checkname":"单据头.源单id"},{"destname":"单据头.追加金额","checkkey":"appendamount","shortname":"","destkey":"appendamount","checkname":"单据头.追加金额"},{"destname":"单据头.起息日","checkkey":"appendintdate","shortname":"","destkey":"appendintdate","checkname":"单据头.起息日"}]',' ',' ',' ',' ',1707420147431521280,1,' ','单据头.源单id 等于 单据头.源单id and 单据头.追加金额 等于 单据头......',' ',' ');



/*  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 = 1706465868285867008;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706465868285867008,'tm_forex_options',' ','tm_forex_options','保存；提交；',1706465868285867008,'C','FCS_022_S','外汇期权vs外汇期权',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706458651767622656;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706458651767622656,'tm_forex_swaps',' ','tm_forex_swaps','保存；提交；',1706458651767622656,'C','FCS_021_S','外汇掉期vs外汇掉期',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1705901955378934784;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1705901955378934784,'cfm_interestbill',' ','cfm_interestbill','保存；提交；',1705901955378934784,'C','FCS_017_S','付息处理vs付息处理',' ',{ts'2023-06-12  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',submit,save,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1705728441904644096;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1705728441904644096,'lc_arrival',' ','lc_arrival','保存；提交；',1705728441904644096,'C','FCS_016_S','到单处理vs到单处理',' ',{ts'2023-06-12  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1705904979455341568;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1705904979455341568,'cfm_preinterestbill',' ','cfm_preinterestbill','保存；提交；',1705904979455341568,'C','FCS_018_S','应付利息预提vs应付利息预提',' ',{ts'2023-06-12  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',submit,save,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706445061291635712;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706445061291635712,'tm_forex',' ','tm_forex','保存；提交；',1706445061291635712,'C','FCS_019_S','外汇即期vs外汇即期',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706449157910187008;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706449157910187008,'tm_forex_forward',' ','tm_forex_forward','保存；提交；',1706449157910187008,'C','FCS_020_S','外汇远期vs外汇远期',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1706527664266826752;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1706527664266826752,'tm_businessbill',' ','tm_businessbill','保存；提交；',1706527664266826752,'C','FCS_023_S','交易生命周期管理vs交易生命周期管理',' ',{ts'2023-06-13  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',submit,save,','landing');
DELETE FROM T_FCS_SUSPECTSET WHERE FID = 1707420147389578240;
INSERT INTO T_FCS_SUSPECTSET(FID,FDESTENTITYID,FCHECKSIGNFIELD,FCHECKENTITYID,FCHECKOPNAME,FMASTERID,FSTATUS,FNUMBER,FNAME,FMESSAGEFIELD,FCREATETIME,FENABLE,FFAILMESSAGE,FLANDINGOPNAME,FLANDINGOP,FCREATORID,FCHECKOP,FCTRLTYPE) VALUES (1707420147389578240,'fbd_surety_append',' ','fbd_surety_append','保存；提交；',1707420147389578240,'C','FCS_024_S','保证金追加处理vs保证金追加处理',' ',{ts'2023-06-14  00:00:00'},'1','存在疑似重复数据，请人工落地确认','审核；',',audit,',13466739,',save,submit,','landing');


DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BI+0+0LRV6=';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705728441904644096,'3BI+0+0LRV6=','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','到单处理vs到单处理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BITFCDEB2JC';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705901955378934784,'3BITFCDEB2JC','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','付息處理vs付息處理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLDXZWVFAM3';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706445061291635712,'3BLDXZWVFAM3','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙即期vs外彙即期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BI+0+0LRV6A';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705728441904644096,'3BI+0+0LRV6A','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','到單處理vs到單處理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLGG/0SB0NK';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706458651767622656,'3BLGG/0SB0NK','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙掉期vs外彙掉期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLGG/0SB0NL';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706458651767622656,'3BLGG/0SB0NL','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇掉期vs外汇掉期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLEOU7+LMOO';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706449157910187008,'3BLEOU7+LMOO','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙遠期vs外彙遠期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLEOU7+LMOP';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706449157910187008,'3BLEOU7+LMOP','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇远期vs外汇远期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLTBWWTLMFR';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706527664266826752,'3BLTBWWTLMFR','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','交易生命周期管理vs交易生命周期管理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLTBWWTLMFS';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706527664266826752,'3BLTBWWTLMFS','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','交易生命周期管理vs交易生命周期管理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BITFCDEB2JB';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705901955378934784,'3BITFCDEB2JB','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','付息处理vs付息处理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BIU/DUT/XPS';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705904979455341568,'3BIU/DUT/XPS','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','應付利息預提vs應付利息預提');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BIU/DUT/XPR';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1705904979455341568,'3BIU/DUT/XPR','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','应付利息预提vs应付利息预提');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLDXZWVFAM2';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706445061291635712,'3BLDXZWVFAM2','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇即期vs外汇即期');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BQ23DQG5F=6';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1707420147389578240,'3BQ23DQG5F=6','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','保證金追加處理vs保證金追加處理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BQ23DQG5F=7';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1707420147389578240,'3BQ23DQG5F=7','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','保证金追加处理vs保证金追加处理');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLHTKY1F6SK';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706465868285867008,'3BLHTKY1F6SK','zh_TW','存在疑似重複數據，請人工落地確認',' ',' ',' ','外彙期權vs外彙期權');
DELETE FROM T_FCS_SUSPECTSET_L WHERE FPKID = '3BLHTKY1F6SL';
INSERT INTO T_FCS_SUSPECTSET_L(FID,FPKID,FLOCALEID,FFAILMESSAGE,FLANDINGOPNAME,FCOMMENT,FCHECKOPNAME,FNAME) VALUES (1706465868285867008,'3BLHTKY1F6SL','zh_CN','存在疑似重复数据，请人工落地确认','审核；',' ','保存；提交；','外汇期权vs外汇期权');


DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1705901956108743683;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1705901955378934784,'[{"destname":"单据头.源单id","checkkey":"sourcebillid","shortname":"","destkey":"sourcebillid","checkname":"单据头.源单id"},{"destname":"单据头.付息日","checkkey":"bizdate","shortname":"","destkey":"bizdate","checkname":"单据头.付息日"}]',' ','{"expression":"","exprTran":"冲销状态 不等于 已冲销","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BITDB3F1AJQ","leftBracket":"","compareType":"106","fieldName":"writeoffstatus","rightBracket":"","logic":"0","value":[{"id":"3BITDB3F1B8+","value":"writeoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BITDB3F1AJQ\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"writeoffstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BITDB3F1B8+\",\"value\":\"writeoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"冲销状态 不等于 已冲销","localeExprTran":{"zh_CN":"冲销状态 不等于 已冲销"}}',' ','冲销状态 不等于 已冲销',1705901956108743683,1,' ','单据头.源单id 等于 单据头.源单id and 单据头.付息日 等于 单据头.付息日','冲销状态 不等于 已冲销   and   ( 业务日期 上月   or    业务日期 本月 )',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706465868327810048;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706465868285867008,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLHTFTQ8/S2","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLHTFTQ9V49","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLHTFTQ8/S2\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLHTFTQ9V49\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706465868327810048,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......','创建日期 上月   or    创建日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706527664392655872;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706527664266826752,' ',' ','{"expression":"","exprTran":"产品类型.编码 等于 02SWAP","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLTUPL7=ZOP","leftBracket":"","compareType":"67","fieldName":"protecttype.number","rightBracket":"","logic":"0","value":[{"id":"3BLTUPL7=Z/F","value":"02SWAP"}],"baseDataIds":[{"id":"3BLTUPL7=ZOQ","value":"952722152971330560"}]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLTUPL7=ZOP\",\"leftBracket\":\"\",\"compareType\":\"67\",\"fieldName\":\"protecttype.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLTUPL7=Z/F\",\"value\":\"02SWAP\"}],\"baseDataIds\":[{\"id\":\"3BLTUPL7=ZOQ\",\"value\":\"952722152971330560\"}]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"产品类型.编码 等于 02SWAP"},"exprDesc":"产品类型.编码 等于 02SWAP"}',' ','产品类型.编码 等于 02SWAP',1706527664392655872,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 交易号.交易对......','交易号.业务日期 上月   or    交易号.业务日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706458651809565696;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706458651767622656,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLGFW08SWJ3","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLGFW08R15Y","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLGFW08SWJ3\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLGFW08R15Y\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706458651809565696,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......','创建日期 上月   or    创建日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1705728442089193472;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1705728441904644096,'[{"destname":"单据头.到单日期","checkkey":"arrivaldate","shortname":"","destkey":"arrivaldate","checkname":"单据头.到单日期"},{"destname":"信用证号.信用证号.信用证号","checkkey":"lettercredit.number","shortname":"","destkey":"lettercredit.number","checkname":"信用证号.信用证号.信用证号"}]',' ',' ',' ',' ',1705728442089193472,1,' ','单据头.到单日期 等于 单据头.到单日期 and 信用证号.信用证号.信用证号 ......','登记日期 上月   or    登记日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1705904980277424128;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1705904979455341568,'[{"destname":"单据头.源单id","checkkey":"sourcebillid","shortname":"","destkey":"sourcebillid","checkname":"单据头.源单id"},{"destname":"单据头.预提日期","checkkey":"prestenddate","shortname":"","destkey":"prestenddate","checkname":"单据头.预提日期"}]',' ','{"expression":"","exprTran":"冲销状态 不在……中 (红字冲销,已冲销)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BITZ7+GSFM=","leftBracket":"","compareType":"34","fieldName":"writeoffstatus","rightBracket":"","logic":"0","value":[{"id":"3BITZ7+GSG=J","value":"red_writeoff"},{"id":"3BITZ7+GSFMA","value":"writeoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BITZ7+GSFM=\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"writeoffstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BITZ7+GSG=J\",\"value\":\"red_writeoff\"},{\"id\":\"3BITZ7+GSFMA\",\"value\":\"writeoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"冲销状态 不在……中 (红字冲销,已冲销)","localeExprTran":{"zh_CN":"冲销状态 不在……中 (红字冲销,已冲销)"}}',' ','冲销状态 不在……中 (红字冲销,已冲销)',1705904980277424128,1,' ','单据头.源单id 等于 单据头.源单id and 单据头.预提日期 等于 单据头.预提日期','冲销状态 不在……中 (已冲销,红字冲销)   and   ( 业务日期 上月 ......',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706449158799379456;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706449157910187008,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLE9RZ+1BWM","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLE9RZ+368T","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLE9RZ+1BWM\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLE9RZ+368T\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706449158799379456,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......','创建日期 上月   or    创建日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1707420147431521280;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1707420147389578240,'[{"destname":"单据头.源单id","checkkey":"sourcebillid","shortname":"","destkey":"sourcebillid","checkname":"单据头.源单id"},{"destname":"单据头.追加金额","checkkey":"appendamount","shortname":"","destkey":"appendamount","checkname":"单据头.追加金额"},{"destname":"单据头.起息日","checkkey":"appendintdate","shortname":"","destkey":"appendintdate","checkname":"单据头.起息日"}]',' ',' ',' ',' ',1707420147431521280,1,' ','单据头.源单id 等于 单据头.源单id and 单据头.追加金额 等于 单据头......','业务日期 上月   or    业务日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706528079268041728;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706527664266826752,'[{"destname":"单据头.生命周期","checkkey":"operate","shortname":"","destkey":"operate","checkname":"单据头.生命周期"},{"destname":"交易号.交易号.编码","checkkey":"tradebill.number","shortname":"","destkey":"tradebill.number","checkname":"交易号.交易号.编码"}]',' ',' ',' ','产品类型.编码 在……中 (''01FORWRATEAGREE'',''01STRUCTDEPOSIT'')',1706528079268041728,2,' ','单据头.生命周期 等于 单据头.生命周期 and 交易号.交易号.编码 等于 交易号.交易号.编码','交易号.业务日期 上月   or    交易号.业务日期 本月',' ');
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1706445061887226880;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1706445061291635712,' ',' ','{"expression":"","exprTran":"申请单号 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BLDWG1WD6P9","leftBracket":"","compareType":"9","fieldName":"reqnoteno","rightBracket":"","logic":"0","value":[{"id":"3BLDWG1WF01F","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BLDWG1WD6P9\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"reqnoteno\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BLDWG1WF01F\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"申请单号 不为空","localeExprTran":{"zh_CN":"申请单号 不为空"}}',' ','申请单号 不为空',1706445061887226880,1,' ','交易主体.交易主体.编码 等于 交易主体.交易主体.编码 and 单据头.交易日......','创建日期 上月   or    创建日期 本月',' ');


/*  creator：IERP
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript>
*********************************************************************
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415104347049614336;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','0',1415104347049614336,'{"filterRow":[],"forList":false}',' ','0',' ','【贷款合同处理】下推【贷款放款处理】出现超额，请检查','1',' ',',submit,','LargerOrEqual',1415104347049614336,'ifm_loanbill',' ','C','1','ifm_loancontractbill -> ifm_loanbill',' ',1415102004681780224,',submit,',' ','1','1','0','ifm_loancontractbill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415179594960485376;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','0',1415179594960485376,'{"filterRow":[],"forList":false}',' ','0',' ','【企业贷款合同】下推【企业放款处理】出现超额，请检查','1',' ',',submit,','LargerOrEqual',1415179594960485376,'cim_invest_loanbill',' ','C','1','cim_invest_contract -> cim_invest_loanbill',' ',1415176488365341696,',submit,',' ','1','1','0','cim_invest_contract');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU+7H7OB9KU';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415179594960485376,'2EU+7H7OB9KU','zh_CN','【企业贷款合同】下推【企业放款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU+7H7OB9KV';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415179594960485376,'2EU+7H7OB9KV','zh_TW','【企業貸款合同】下推【企業放款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETM55CA16M+';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415104347049614336,'2ETM55CA16M+','zh_CN','【贷款合同处理】下推【贷款放款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETM55CA16M/';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415104347049614336,'2ETM55CA16M/','zh_TW','【貸款合同處理】下推【貸款放款處理】出現超額，請檢查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415104347158666240;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415104347049614336,'Head',' ',1415104347158666240,' ',NULL,' ','单据头.折合同币别金额','Head','convertdrawamt',1,'amount','单据状态 不等于 暂存   and    循环贷款 等于 否',' ','单据头.借款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415179594985651200;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415179594960485376,'Head','{"expression":"","exprTran":"循环贷款 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"32IZ6K4TZ9QK","leftBracket":"","compareType":"105","fieldName":"iscycleloan","rightBracket":"","logic":"0","value":[{"id":"32IZ6K4TX6YT","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"32IZ6K4TZ9QK\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"iscycleloan\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"32IZ6K4TX6YT\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"循环贷款 等于 否"},"exprDesc":"循环贷款 等于 否"}',1415179594985651200,' ',NULL,' ','单据头.折合同币别金额','Head','convertdrawamt',1,'amount','循环贷款 等于 否',' ','单据头.贷款金额');


/*  creator：IERP
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript>
*********************************************************************
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1705813342200885248;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','0',1705813342200885248,'{"filterRow":[],"forList":false}',' ','0',' ','【存款业务申请】下推【定期存款处理】出现超额，请检查','1','【】下推【】出现重复，请检查',',submit,save,','LargerOrEqual',1705813342200885248,'cim_deposit',' ','C','1','cim_deposit_apply -> cim_deposit',' ',1705745858072532992,',save,submit,',' ','1','1','0','cim_deposit_apply');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1705824672567881728;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','0',1705824672567881728,'{"filterRow":[],"forList":false}',' ','0',' ','【存款业务申请】下推【通知存款处理】出现超额，请检查','1','【存款业务申请】下推【通知存款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1705824672567881728,'cim_noticedeposit',' ','C','1','cim_deposit_apply -> cim_noticedeposit',' ',1705810824108535808,',save,submit,',' ','1','1','0','cim_deposit_apply');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3BICWN0K7XA9';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1705813342200885248,'3BICWN0K7XA9','zh_CN','【存款业务申请】下推【定期存款处理】出现超额，请检查',' ','【】下推【】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3BICWN0K7XA=';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1705813342200885248,'3BICWN0K7XA=','zh_TW','【存款業務申請】下推【定期存款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3BIF/70PFNF8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1705824672567881728,'3BIF/70PFNF8','zh_CN','【存款业务申请】下推【通知存款处理】出现超额，请检查',' ','【存款业务申请】下推【通知存款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3BIF/70PFNF9';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1705824672567881728,'3BIF/70PFNF9','zh_TW','【存款業務申請】下推【通知存款處理】出現超額，請檢查',' ','【存款業務申請】下推【通知存款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1705813342335102976;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1705813342200885248,'Head','{"expression":"","exprTran":"续存生成 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BW=P/B9DNXJ","leftBracket":"","compareType":"105","fieldName":"isredepositgenerate","rightBracket":"","logic":"0","value":[{"id":"3BW=P/C/DZSD","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BW=P/B9DNXJ\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isredepositgenerate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BW=P/C/DZSD\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"续存生成 等于 否"},"exprDesc":"续存生成 等于 否"}',1705813342335102976,' ',' ',' ','单据头.存款金额','Head','amount',1,'amount','续存生成 等于 否',' ','单据头.存款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1705824672702099456;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1705824672567881728,'Head','{"expression":"","exprTran":"转存生成 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3BW=S6ATMK1K","leftBracket":"","compareType":"105","fieldName":"isredepositgenerate","rightBracket":"","logic":"0","value":[{"id":"3BW=S6AX9+YB","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3BW=S6ATMK1K\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isredepositgenerate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3BW=S6AX9+YB\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"转存生成 等于 否"},"exprDesc":"转存生成 等于 否"}',1705824672702099456,' ',' ',' ','单据头.存款金额','Head','amount',1,'amount','转存生成 等于 否',' ','单据头.存款金额');




