/*  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":"3F+=TLU=KA=0","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3F+=TLU=EE0B","value":"F"},{"id":"3F+=TLU=KA=1","value":"G"},{"id":"3F+=TLU=EE0C","value":"H"},{"id":"3F+=TLU=KA=2","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 = 1733975869531134976;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1418871653286302720,'Head','{"expression":"","exprTran":"单据状态 不等于 已退单","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3F+=Y4HL21CN","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3F+=Y4HKY53Z","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3F+=Y4HL21CN\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3F+=Y4HKY53Z\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不等于 已退单","localeExprTran":{"zh_CN":"单据状态 不等于 已退单"}}',1733975869531134976,' ','{"expression":"","exprTran":"受让 等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3F+=WK842IM5","leftBracket":"","compareType":"105","fieldName":"accepttransfer","rightBracket":"","logic":"0","value":[{"id":"3F+=WK83YMCG","value":"1"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3F+=WK842IM5\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"accepttransfer\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3F+=WK83YMCG\",\"value\":\"1\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"受让 等于 是","localeExprTran":{"zh_CN":"受让 等于 是"}}','受让 等于 是','单据头.付款金额','Head','actpayamt',2,'transferamount','单据状态 不等于 已退单','单据头.转让金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687619975826653184;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1418871653286302720,'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,' ','{"expression":"","exprTran":"受让 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3F+=UKG2Q/EY","leftBracket":"","compareType":"105","fieldName":"accepttransfer","rightBracket":"","logic":"0","value":[{"id":"3F+=UKG2K368","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3F+=UKG2Q/EY\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"accepttransfer\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3F+=UKG2K368\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"受让 等于 否","localeExprTran":{"zh_CN":"受让 等于 否"}}','受让 等于 否','单据头.付款金额','Head','actpayamt',1,'amount','单据状态 不等于 已退单','单据头.存款金额');
