/*  creator：xiaofeng
支付安全专项加固，资金防重调整
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript>
*********************************************************************
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415207998661343232;
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',1415207998661343232,'{"filterRow":[{"id":"2GE5USQ1/CW2","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GE5USQ1/DJB","value":"G"},{"id":"2GE5USQ1/CW3","value":"F"},{"id":"2GE5USQ1/DJC","value":"H"},{"id":"2GE5USQ1/CW4","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【调拨申请】下推【调拨处理】出现超额，请检查','1','【调拨申请 】下推【调拨处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415207998661343232,'cas_paybill','sourceentryid','C','1','cas_transferapply -> cas_paybill',' ',1415200739797515264,',save,submit,',' ','1','1','0','cas_transferapply');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415190156570278912;
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',1415190156570278912,'{"filterRow":[{"id":"2GE5T+XQUFGP","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GE5T+XQUG4Z","value":"H"},{"id":"2GE5T+XQUFGQ","value":"G"},{"id":"2GE5T+XQUG5+","value":"F"},{"id":"2GE5T+XQUFGR","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【付款申请】下推【付款处理】出现超额，请检查','1','【付款申请】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415190156570278912,'cas_paybill','e_sourcebillentryid','C','1','cas_payapplybill -> cas_paybill',' ',1415184354933487616,',save,submit,',' ','1','1','0','cas_payapplybill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415053612379286528;
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',1415053612379286528,'{"filterRow":[{"id":"3ABX74JTZKMO","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3ABX74JTT=KB","value":"G"},{"id":"3ABX74JTZKMP","value":"H"},{"id":"3ABX74JTT=KC","value":"F"},{"id":"3ABX74JTZKMQ","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【付款处理】下推【付款处理】出现超额，请检查','1','【付款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415053612379286528,'cas_paybill','sourcebillid','C','1','cas_paybill -> cas_paybill',' ',1415051859311209472,',save,submit,',' ','1','1','0','cas_paybill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU06FS08JGH';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415190156570278912,'2EU06FS08JGH','zh_CN','【付款申请】下推【付款处理】出现超额，请检查',' ','【付款申请】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU06FS08JGI';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415190156570278912,'2EU06FS08JGI','zh_TW','【付款申請】下推【付款處理】出現超額，請檢查',' ','【付款申請】下推【付款處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU3IGC8=0LT';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415207998661343232,'2EU3IGC8=0LT','zh_CN','【调拨申请】下推【调拨处理】出现超额，请检查',' ','【调拨申请 】下推【调拨处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU3IGC8=0LU';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415207998661343232,'2EU3IGC8=0LU','zh_TW','【調撥申請】下推【調撥處理】出現超額，請檢查',' ','【調撥申請 】下推【調撥處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETCOFYT2444';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415053612379286528,'2ETCOFYT2444','zh_CN','【付款处理】下推【付款处理】出现超额，请检查',' ','【付款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETCOFYT2445';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415053612379286528,'2ETCOFYT2445','zh_TW','【付款處理】下推【付款處理】出現超額，請檢查',' ','【付款處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032194;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415053612379286528,'Head',' ',1696321736209032194,' ','{"expression":"","exprTran":"委托付款组织.编码 为空   and    手续费独立流水 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3ABXCDWR7KR4","leftBracket":"","compareType":"37","fieldName":"entrustorg.number","rightBracket":"","logic":"0","value":[{"id":"3ABXCDWR1=OT","value":""}],"baseDataIds":[]},{"id":"3ABXCDWR7KR5","leftBracket":"","compareType":"105","fieldName":"singlestream","rightBracket":"","logic":"0","value":[{"id":"3ABXCDWR1=OU","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3ABXCDWR7KR4\",\"leftBracket\":\"\",\"compareType\":\"37\",\"fieldName\":\"entrustorg.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABXCDWR1=OT\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"3ABXCDWR7KR5\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"singlestream\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABXCDWR1=OU\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"委托付款组织.编码 为空   and    手续费独立流水 等于 否"},"exprDesc":"委托付款组织.编码 为空   and    手续费独立流水 等于 否"}','委托付款组织.编码 为空   and    手续费独立流水 等于 否','单据头.异币别付款金额','Head','dpamt',3,'dpamt',' ',' ','单据头.异币别付款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415207998787172352;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415207998661343232,'EntrySingle','{"expression":"","exprTran":"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":""},"exprDesc":""}',1415207998787172352,' ',NULL,' ','单据头.付款金额','Head','actpayamt',1,'e_payeeamount',' ',' ','申请明细分录.收款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415190156662553600;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415190156570278912,'EntrySingle',' ',1415190156662553600,' ',NULL,' ','分录.实付金额','EntrySum','e_actamt',1,'entry_payeeamount',' ',' ','付款明细分录.收款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032192;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415053612379286528,'Head',' ',1696321736209032192,' ','{"expression":"","exprTran":"委托付款组织.编码 为空   and    手续费独立流水 等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3ABX=+A+17HE","leftBracket":"","compareType":"37","fieldName":"entrustorg.number","rightBracket":"","logic":"0","value":[{"id":"3ABX=+A+7HJS","value":""}],"baseDataIds":[]},{"id":"3ABX=+A+7HJT","leftBracket":"","compareType":"105","fieldName":"singlestream","rightBracket":"","logic":"0","value":[{"id":"3ABX=+A+17HG","value":"1"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3ABX=+A+17HE\",\"leftBracket\":\"\",\"compareType\":\"37\",\"fieldName\":\"entrustorg.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABX=+A+7HJS\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"3ABX=+A+7HJT\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"singlestream\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABX=+A+17HG\",\"value\":\"1\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"委托付款组织.编码 为空   and    手续费独立流水 等于 是"},"exprDesc":"委托付款组织.编码 为空   and    手续费独立流水 等于 是"}','委托付款组织.编码 为空   and    手续费独立流水 等于 是','单据头.异币别付款金额','Head','dpamt',1,'fee',' ',' ','单据头.手续费');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032193;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415053612379286528,'Head',' ',1696321736209032193,' ','{"expression":"","exprTran":"委托付款组织.编码 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3ABXAJDURJMU","leftBracket":"","compareType":"9","fieldName":"entrustorg.number","rightBracket":"","logic":"0","value":[{"id":"3ABXAJDUL9KH","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3ABXAJDURJMU\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"entrustorg.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABXAJDUL9KH\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"委托付款组织.编码 不为空"},"exprDesc":"委托付款组织.编码 不为空"}','委托付款组织.编码 不为空','单据头.异币别付款金额','Head','dpamt',2,'dpamt',' ',' ','单据头.异币别付款金额');




DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1694278078664046592;
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',1694278078664046592,'{"filterRow":[],"forList":false}',' ','0',' ','【被动付款入账】下推【下拨处理】出现超额，请检查','1','【】下推【】出现重复，请检查',',submit,save,','LargerOrEqual',1694278078664046592,'fca_transdownbill',' ','C','1','bei_intelpay -> fca_transdownbill',' ',1453583504313944064,',save,submit,',' ','1','1','0','bei_intelpay');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1694280880148740096;
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',1694280880148740096,'{"filterRow":[],"forList":false}',' ','0',' ','【收款入账中心】下推【上划处理】出现超额，请检查','1','【】下推【】出现重复，请检查',',submit,save,','LargerOrEqual',1694280880148740096,'fca_transupbill',' ','C','1','bei_intelrec -> fca_transupbill',' ',1453583077971332096,',save,submit,',' ','1','1','0','bei_intelrec');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3A33KCN73UH7';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1694278078664046592,'3A33KCN73UH7','zh_CN','【被动付款入账】下推【下拨处理】出现超额，请检查',' ','【】下推【】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3A33KCN73UH8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1694278078664046592,'3A33KCN73UH8','zh_TW','【被動付款入賬】下推【下撥處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3A342SQDJ5KC';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1694280880148740096,'3A342SQDJ5KC','zh_CN','【收款入账中心】下推【上划处理】出现超额，请检查',' ','【】下推【】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3A342SQDJ5KD';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1694280880148740096,'3A342SQDJ5KD','zh_TW','【收款入賬中心】下推【上劃處理】出現超額，請檢查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1694278079033145344;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1694278078664046592,'Head','{"expression":"","exprTran":"来源业务类型 等于 被动付款入账","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3A33HKV6KZB4","leftBracket":"","compareType":"105","fieldName":"sourcetype","rightBracket":"","logic":"0","value":[{"id":"3A33HKV=5H4P","value":"paypassive"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3A33HKV6KZB4\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"sourcetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3A33HKV=5H4P\",\"value\":\"paypassive\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"来源业务类型 等于 被动付款入账","localeExprTran":{"zh_CN":"来源业务类型 等于 被动付款入账"}}',1694278079033145344,' ',NULL,' ','单据头.下拨总金额','Head','amount',1,'debitamount','来源业务类型 等于 被动付款入账',' ','单据头.付款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1694280880241014784;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1694280880148740096,'Head','{"expression":"","exprTran":"来源业务类型 等于 收款入账中心","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3A342L7X0ZJ0","leftBracket":"","compareType":"105","fieldName":"sourcetype","rightBracket":"","logic":"0","value":[{"id":"3A342L8+MHBL","value":"recinitiative"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3A342L7X0ZJ0\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"sourcetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3A342L8+MHBL\",\"value\":\"recinitiative\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"来源业务类型 等于 收款入账中心","localeExprTran":{"zh_CN":"来源业务类型 等于 收款入账中心"}}',1694280880241014784,' ',NULL,' ','单据头.上划总金额','Head','amount',1,'creditamount','来源业务类型 等于 收款入账中心',' ','单据头.收款金额');



