/*  creator：IERP
支付安全专项加固（交易部分）
【到单处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415235866095269888;
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',1415235866095269888,'{"filterRow":[],"forList":false}',' ','0',' ','【到单处理】下推【付款处理】出现超额，请检查','1',' ',',submit,save,','LargerOrEqual',1415235866095269888,'cas_paybill',' ','C','1','lc_arrival -> cas_paybill',' ',1415222925400751104,',save,submit,',' ','1','1','0','lc_arrival');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU8QJ7N/HJ1';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415235866095269888,'2EU8QJ7N/HJ1','zh_CN','【到单处理】下推【付款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU8QJ7N/HJ2';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415235866095269888,'2EU8QJ7N/HJ2','zh_TW','【到單處理】下推【付款處理】出現超額，請檢查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415235866732804096;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415235866095269888,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQGDPFT+594","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQGDPFT+5YD","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQGDPFT+594\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQGDPFT+5YD\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1415235866732804096,'actpayamt',1,'arrivalamount',' ','单据状态 不等于 已退单','单据头.到单金额','单据头.付款金额');

/*  creator：IERP
【理财申购】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415306582773781504;
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',1415306582773781504,'{"filterRow":[{"id":"3=V5K6=CPFKM","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=V5K6=CRICD","value":"F"},{"id":"3=V5K6=CPFKN","value":"G"},{"id":"3=V5K6=CRICE","value":"H"},{"id":"3=V5K6=CPFKO","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【理财申购】下推【付款处理】出现超额，请检查','1','【理财申购】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415306582773781504,'cas_paybill','sourcebillid','C','1','cim_finsubscribe -> cas_paybill',' ',1415305949064777728,',save,submit,',' ','1','1','1','cim_finsubscribe');


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


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687588570052707328;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415306582773781504,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==1=9ZHERV8","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==1=9ZHER6+","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==1=9ZHERV8\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==1=9ZHER6+\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687588570052707328,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.理财金额','单据头.付款金额');

/*  creator：IERP
【定期存款处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1418871653286302720;
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',1418871653286302720,'{"filterRow":[{"id":"3=XA2Y7GRU02","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=XA2Y7GRTBU","value":"F"},{"id":"3=XA2Y7GRU03","value":"G"},{"id":"3=XA2Y7GRTBV","value":"H"},{"id":"3=XA2Y7GRU04","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【定期存款处理】下推【付款处理】出现超额，请检查','1','【定期存款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1418871653286302720,'cas_paybill','sourcebillid','C','1','cim_deposit -> cas_paybill',' ',1418723139751281664,',save,submit,',' ','1','1','1','cim_deposit');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2F9O1FWQO7S0';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1418871653286302720,'2F9O1FWQO7S0','zh_CN','【定期存款处理】下推【付款处理】出现超额，请检查',' ','【定期存款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2F9O1FWQO7S1';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1418871653286302720,'2F9O1FWQO7S1','zh_TW','【定期存款處理】下推【付款處理】出現超額，請檢查',' ','【定期存款處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687619975826653184;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1418871653286302720,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==7IPICN5R2","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==7IPICN51U","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==7IPICN5R2\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==7IPICN51U\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687619975826653184,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.存款金额','单据头.付款金额');

/*  creator：IERP
【通知存款处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1455913698009866240;
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',1455913698009866240,'{"filterRow":[{"id":"3=XA704+/XHJ","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=XA704+/WU=","value":"F"},{"id":"3=XA704+/XHK","value":"G"},{"id":"3=XA704+/WUA","value":"H"},{"id":"3=XA704+/XHL","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【通知存款处理】下推【付款处理】出现超额，请检查','1','【通知存款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1455913698009866240,'cas_paybill','sourcebillid','C','1','cim_noticedeposit -> cas_paybill',' ',1453710684821933056,',save,submit,',' ','1','1','1','cim_noticedeposit');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2JU47709X7LW';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1455913698009866240,'2JU47709X7LW','zh_CN','【通知存款处理】下推【付款处理】出现超额，请检查',' ','【通知存款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2JU47709X7LX';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1455913698009866240,'2JU47709X7LX','zh_TW','【通知存款處理】下推【付款處理】出現超額，請檢查',' ','【通知存款處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687627891468156928;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1455913698009866240,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==9/GMR+6XK","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==9/GMR+7KU","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==9/GMR+6XK\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==9/GMR+7KU\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687627891468156928,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.存款金额','单据头.付款金额');

/*  creator：IERP
【企业放款处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415183986354829312;
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',1415183986354829312,'{"filterRow":[{"id":"3=V69AA=XXK7","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=V69AA=VUSF","value":"F"},{"id":"3=V69AA=XXK8","value":"G"},{"id":"3=V69AA=VUSG","value":"H"},{"id":"3=V69AA=XXK9","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【企业放款处理】下推【付款处理】出现超额，请检查','1','【企业放款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415183986354829312,'cas_paybill','sourcebillid','C','1','cim_invest_loanbill -> cas_paybill',' ',1415183235364698112,',save,submit,',' ','1','1','1','cim_invest_loanbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU/0HH3CQ0H';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415183986354829312,'2EU/0HH3CQ0H','zh_CN','【企业放款处理】下推【付款处理】出现超额，请检查',' ','【企业放款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU/0HH3CQ0I';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415183986354829312,'2EU/0HH3CQ0I','zh_TW','【企業放款處理】下推【付款處理】出現超額，請檢查',' ','【企業放款處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687695002915868672;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415183986354829312,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==KJFCUCYSM","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==KJFCUCZFW","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==KJFCUCYSM\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==KJFCUCZFW\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687695002915868672,'actpayamt',1,'drawamount',' ','单据状态 不等于 已退单','单据头.放款金额','单据头.付款金额');

/*  creator：IERP
【还款处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415078342910073856;
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',1415078342910073856,'{"filterRow":[{"id":"3A+YBWG=KTKG","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3A+YBWG=KU8Q","value":"G"},{"id":"3A+YBWG=KTKH","value":"F"},{"id":"3A+YBWG=KU8R","value":"H"},{"id":"3A+YBWG=KTKI","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【还款处理】下推【付款处理】出现超额，请检查','1','【还款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415078342910073856,'cas_paybill',' ','C','1','cfm_repaymentbill -> cas_paybill',' ',1415070461787646976,',save,submit,',' ','1','1','1','cfm_repaymentbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETH=O5CTM32';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415078342910073856,'2ETH=O5CTM32','zh_CN','【还款处理】下推【付款处理】出现超额，请检查',' ','【还款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETH=O5CTM33';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415078342910073856,'2ETH=O5CTM33','zh_TW','【還款處理】下推【付款處理】出現超額，請檢查',' ','【還款處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687696375686403072;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415078342910073856,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==KTG+1HFQ5","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==KTG+1HGDE","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==KTG+1HFQ5\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==KTG+1HGDE\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687696375686403072,'actpayamt',1,'needpayamt',' ','单据状态 不等于 已退单','单据头.待付款金额','单据头.付款金额');

/*  creator：IERP
【付息处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415089046681562112;
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',1415089046681562112,'{"filterRow":[{"id":"3=V76K+U0MMX","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=V76K+U2PEO","value":"G"},{"id":"3=V76K+U0MMY","value":"H"},{"id":"3=V76K+U2PEP","value":"F"},{"id":"3=V76K+U0MMZ","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【付息处理】下推【付款处理】出现超额，请检查','1','【付息处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415089046681562112,'cas_paybill','sourcebillid','C','1','cfm_interestbill -> cas_paybill',' ',1415078876224216064,',save,submit,',' ','1','1','1','cfm_interestbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETJ=O3RKN+V';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415089046681562112,'2ETJ=O3RKN+V','zh_CN','【付息处理】下推【付款处理】出现超额，请检查',' ','【付息处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETJ=O3RKN+W';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415089046681562112,'2ETJ=O3RKN+W','zh_TW','【付息處理】下推【付款處理】出現超額，請檢查',' ','【付息處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1428163285156414464;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415089046681562112,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GE65A9XLJH7","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GE65A9XLITZ","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GE65A9XLJH7\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GE65A9XLITZ\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1428163285156414464,'actpayamt',1,'actualinstamt',' ','单据状态 不等于 已退单','单据头.付息金额','单据头.付款金额');

/*  creator：IERP
【开函登记】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1457086447327660032;
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',1457086447327660032,'{"filterRow":[{"id":"3=VDPGHMR9F=","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=VDPGHMTBXA","value":"F"},{"id":"3=VDPGHMR9FA","value":"I"},{"id":"3=VDPGHMTBXB","value":"H"},{"id":"3=VDPGHMR9FB","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【开函登记】下推【付款处理】出现超额，请检查','1','【开函登记】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1457086447327660032,'cas_paybill',' ','C','1','gm_letterofguarantee -> cas_paybill',' ',1457084328147214336,',save,submit,',' ','1','1','1','gm_letterofguarantee');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2JZRB/N2PNI6';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1457086447327660032,'2JZRB/N2PNI6','zh_CN','【开函登记】下推【付款处理】出现超额，请检查',' ','【开函登记】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2JZRB/N2PNI7';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1457086447327660032,'2JZRB/N2PNI7','zh_TW','【開函登記】下推【付款處理】出現超額，請檢查',' ','【開函登記】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687697955982709760;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1457086447327660032,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==L1S62CZT4","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==L1S62D+GD","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==L1S62CZT4\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==L1S62D+GD\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687697955982709760,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.保函金额','单据头.付款金额');

/*  creator：IERP
【保證金存入】下推【付款處理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1480463915128628224;
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',1480463915128628224,'{"filterRow":[{"id":"3=VDTG4I5APS","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=VDTG4I7E5T","value":"F"},{"id":"3=VDTG4I5APT","value":"I"},{"id":"3=VDTG4I7E5U","value":"H"},{"id":"3=VDTG4I5APU","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【保证金存入】下推【付款处理】出现超额，请检查','1','【保证金存入】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1480463915128628224,'cas_paybill',' ','C','1','fbd_suretybill->cas_paybill',' ',1480314550158042112,',save,submit,',' ','1','1','1','fbd_suretybill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2MURA7HUWHVR';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1480463915128628224,'2MURA7HUWHVR','zh_TW','【保證金存入】下推【付款處理】出現超額，請檢查',' ','【保證金存入】下推【付款處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2MURA7HUWHVS';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1480463915128628224,'2MURA7HUWHVS','zh_CN','【保证金存入】下推【付款处理】出现超额，请检查',' ','【保证金存入】下推【付款处理】出现重复，请检查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687698964410830848;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1480463915128628224,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==L=CO/JDJT","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==L=CO/JE81","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==L=CO/JDJT\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==L=CO/JE81\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687698964410830848,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.保证金金额','单据头.付款金额');

/*  creator：IERP
【保證金存出】下推【付款處理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1480464332705145856;
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',1480464332705145856,'{"filterRow":[{"id":"3=VDZHA874Q+","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=VDZHA8986/","value":"F"},{"id":"3=VDZHA874Q/","value":"I"},{"id":"3=VDZHA89860","value":"H"},{"id":"3=VDZHA874Q0","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【保证金存出】下推【付款处理】出现超额，请检查','1','【保证金存出】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1480464332705145856,'cas_paybill',' ','C','1','fbd_suretyreleasebill->cas_paybill',' ',1480336755315230720,',save,submit,',' ','1','1','1','fbd_suretyreleasebill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2MURD95OJWBD';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1480464332705145856,'2MURD95OJWBD','zh_TW','【保證金存出】下推【付款處理】出現超額，請檢查',' ','【保證金存出】下推【付款處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2MURD95OJWBE';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1480464332705145856,'2MURD95OJWBE','zh_CN','【保证金存出】下推【付款处理】出现超额，请检查',' ','【保证金存出】下推【付款处理】出现重复，请检查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687699717355507712;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1480464332705145856,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==LET8JS00M","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==LET8JS0PW","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==LET8JS00M\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==LET8JS0PW\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687699717355507712,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.存出金额','单据头.付款金额');

/*  creator：IERP
【保证金追加处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1579787512422196224;
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',1579787512422196224,'{"filterRow":[{"id":"3=VE3TRQCUWU","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=VE3TRQEYBV","value":"F"},{"id":"3=VE3TRQCUWV","value":"G"},{"id":"3=VE3TRQEYBW","value":"H"},{"id":"3=VE3TRQCUWW","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【保证金追加处理】下推【付款处理】出现超额，请检查','1','【保证金追加处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1579787512422196224,'cas_paybill',' ','C','1','fbd_surety_append -> cas_paybill',' ',1579787092060531712,',save,submit,',' ','1','1','1','fbd_surety_append');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Z0LHKDHMC72';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1579787512422196224,'2Z0LHKDHMC72','zh_CN','【保证金追加处理】下推【付款处理】出现超额，请检查',' ','【保证金追加处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Z0LHKDHMC73';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1579787512422196224,'2Z0LHKDHMC73','zh_TW','【保證金追加處理】下推【付款處理】出現超額，請檢查',' ','【保證金追加處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687700626269573120;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1579787512422196224,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==LLH9DVTTB","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==LLH9DVUGL","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==LLH9DVTTB\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==LLH9DVUGL\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687700626269573120,'actpayamt',1,'appendamount',' ','单据状态 不等于 已退单','单据头.追加金额','单据头.付款金额');

/*  creator：IERP
【供应链融资债权业务处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1507229316566892544;
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',1507229316566892544,'{"filterRow":[{"id":"3=VE7ZQY0AKE","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=VE7ZQY2E0F","value":"F"},{"id":"3=VE7ZQY0AKF","value":"G"},{"id":"3=VE7ZQY2E0G","value":"H"},{"id":"3=VE7ZQY0AKG","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【供应链融资债权业务处理】下推【付款处理】出现超额，请检查','1','【供应链融资债权业务处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1507229316566892544,'cas_paybill',' ','C','1','scf_fincreditbill -> cas_paybill',' ',1507225607753580544,',save,submit,',' ','1','1','1','scf_fincreditbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+A8D3Y4EG';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507229316566892544,'2Q4+A8D3Y4EG','zh_CN','【供应链融资债权业务处理】下推【付款处理】出现超额，请检查',' ','【供应链融资债权业务处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+A8D3Y4EH';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507229316566892544,'2Q4+A8D3Y4EH','zh_TW','【供應鏈融資債權業務處理】下推【付款處理】出現超額，請檢查',' ','【供應鏈融資債權業務處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687701361052913664;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1507229316566892544,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==LQVGF6ALX","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==LQVGF6B=5","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==LQVGF6ALX\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==LQVGF6B=5\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687701361052913664,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.融资金额','单据头.付款金额');

/*  creator：IERP
【供应链融资还款处理】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1687744830534345728;
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',1687744830534345728,'{"filterRow":[{"id":"3=VEF+IFHUVH","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=VEF+IFJYAI","value":"I"},{"id":"3=VEF+IFHUVI","value":"H"},{"id":"3=VEF+IFJYAJ","value":"G"},{"id":"3=VEF+IFHUVJ","value":"F"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【供应链融资还款处理】下推【付款处理】出现超额，请检查','1','【供应链融资还款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1687744830534345728,'cas_paybill','sourcebillid','C','1','scf_finrepaybill -> cas_paybill',' ',1507226116849812480,',save,submit,',' ','1','1','1','scf_finrepaybill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3==TVPI3C/KT';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1687744830534345728,'3==TVPI3C/KT','zh_CN','【供应链融资还款处理】下推【付款处理】出现超额，请检查',' ','【供应链融资还款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3==TVPI3C/KU';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1687744830534345728,'3==TVPI3C/KU','zh_TW','【供應鏈融資還款處理】下推【付款處理】出現超額，請檢查',' ','【供應鏈融資還款處理】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687744830551122944;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1687744830534345728,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==TVLEGG4HJ","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==TVLEGG3U=","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==TVLEGG4HJ\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==TVLEGG3U=\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 已退单"},"exprDesc":"单据状态 不等于 已退单"}',1687744830551122944,'actpayamt',1,'amount',' ','单据状态 不等于 已退单','单据头.还款金额','单据头.付款金额');

/*  creator：IERP
【结构性存款】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415334004864861184;
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',1415334004864861184,'{"filterRow":[{"id":"3AD0JYQEAX0J","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3AD0JYQE9SX9","value":"F"},{"id":"3AD0JYQEAX0K","value":"G"},{"id":"3AD0JYQE9SX=","value":"H"},{"id":"3AD0JYQEAX0L","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【结构性存款】下推【付款处理】出现超额，请检查','1','【结构性存款】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415334004864861184,'cas_paybill',' ','C','1','tm_structdeposit -> cas_paybill',' ',1415330073937985536,',save,submit,',' ','1','1','1','tm_structdeposit');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ1OB/6YW8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334004864861184,'2EUQ1OB/6YW8','zh_CN','【结构性存款】下推【付款处理】出现超额，请检查',' ','【结构性存款】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ1OB/6YW9';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334004864861184,'2EUQ1OB/6YW9','zh_TW','【結構性存款】下推【付款處理】出現超額，請檢查',' ','【結構性存款】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1693526546737931264;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415334004864861184,'Head','Head',' ',1693526546737931264,'actpayamt',1,'buysettleamt',' ',' ','单据头.结算金额','单据头.付款金额');

/*  creator：IERP
【互换交易】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415333400247550976;
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',1415333400247550976,'{"filterRow":[{"id":"3AD0OYIST745","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3AD0OYISR3+W","value":"F"},{"id":"3AD0OYIST746","value":"G"},{"id":"3AD0OYISR3+X","value":"H"},{"id":"3AD0OYIST747","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【互换交易】下推【付款处理】出现超额，请检查','1','【互换交易】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415333400247550976,'cas_paybill',' ','C','1','tm_rateswap -> cas_paybill',' ',1415329807264137216,',save,submit,',' ','1','1','1','tm_rateswap');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUPZ9HXO3T7';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415333400247550976,'2EUPZ9HXO3T7','zh_CN','【互换交易】下推【付款处理】出现超额，请检查',' ','【互换交易】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUPZ9HXO3T8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415333400247550976,'2EUPZ9HXO3T8','zh_TW','【互換交易】下推【付款處理】出現超額，請檢查',' ','【互換交易】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1693539727472463872;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415333400247550976,'Head','Head',' ',1693539727472463872,'actpayamt',1,'buysettleamt',' ',' ','单据头.结算金额','单据头.付款金额');

/*  creator：IERP
【外汇期权】下推【付款处理】支付防重脚本
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415334583393600512;
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',1415334583393600512,'{"filterRow":[{"id":"3AD0TR=80OG2","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3AD0TR=82SLC","value":"F"},{"id":"3AD0TR=80OG3","value":"G"},{"id":"3AD0TR=82SLD","value":"H"},{"id":"3AD0TR=80OG4","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【外汇期权】下推【付款处理】出现超额，请检查','1','【外汇期权】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415334583393600512,'cas_paybill','sourcebillid','C','1','tm_forex_options -> cas_paybill',' ',1415331300134372352,',save,submit,',' ','1','1','1','tm_forex_options');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ5WRDXKTZ';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334583393600512,'2EUQ5WRDXKTZ','zh_TW','【外彙期權】下推【付款處理】出現超額，請檢查',' ','【外彙期權】下推【付款處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ5WRDXKU+';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334583393600512,'2EUQ5WRDXKU+','zh_CN','【外汇期权】下推【付款处理】出现超额，请检查',' ','【外汇期权】下推【付款处理】出现重复，请检查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1693527713022877696;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415334583393600512,'Head','Head',' ',1693527713022877696,'actpayamt',1,'premium',' ',' ','单据头.期权费','单据头.付款金额');










