/*  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 = 1696271561520343040;
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',1696271561520343040,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','【收票登记】下推【业务处理】出现超额，请检查','1','【收票登记】下推【业务处理】出现重复，请检查',',submit,save,','LargerOrEqual',1696271561520343040,'cdm_drafttradebill',' ','C','1','cdm_receivablebill -> cdm_drafttradebill',' ',1415300030759228416,',save,submit,',' ','1','1','0','cdm_receivablebill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1696268115681503232;
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',1696268115681503232,'{"filterRow":[{"id":"3EPTV6KHKOUN","leftBracket":"","compareType":"34","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3EPTV6KOUHJE","value":"refund"},{"id":"3EPTV6KOUI7O","value":"payinterest"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【开票登记】下推【业务处理】出现超额，请检查','1','【开票登记】下推【业务处理】出现重复，请检查',',submit,save,','LargerOrEqual',1696268115681503232,'cdm_drafttradebill',' ','C','1','cdm_payablebill -> cdm_drafttradebill',' ',1415229531370829824,',save,submit,',' ','1','1','1','cdm_payablebill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415240455519483904;
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',1415240455519483904,'{"filterRow":[{"id":"2GEE==IM7Z11","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GEE==IM7ZQA","value":"F"},{"id":"2GEE==IM7Z12","value":"G"},{"id":"2GEE==IM7ZQB","value":"H"},{"id":"2GEE==IM7Z13","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【开票业务处理】下推【付款处理】出现超额，请检查','1','【开票业务处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415240455519483904,'cas_paybill',' ','C','1','cdm_drafttradebill -> cas_paybill',' ',1415236516992530432,',save,submit,',' ','1','1','0','cdm_drafttradebill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABO0V3YAUJY';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696271561520343040,'3ABO0V3YAUJY','zh_CN','【收票登记】下推【业务处理】出现超额，请检查',' ','【收票登记】下推【业务处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABO0V3YAUJZ';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696271561520343040,'3ABO0V3YAUJZ','zh_TW','【收票登記】下推【業務處理】出現超額，請檢查',' ','【收票登記】下推【業務處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABNDQTRTZMX';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696268115681503232,'3ABNDQTRTZMX','zh_CN','【开票登记】下推【业务处理】出现超额，请检查',' ','【开票登记】下推【业务处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABNDQTRTZMY';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696268115681503232,'3ABNDQTRTZMY','zh_TW','【開票登記】下推【業務處理】出現超額，請檢查',' ','【開票登記】下推【業務處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU9L+CSPSH0';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415240455519483904,'2EU9L+CSPSH0','zh_CN','【开票业务处理】下推【付款处理】出现超额，请检查',' ','【开票业务处理】下推【付款处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU9L+CSPSH1';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415240455519483904,'2EU9L+CSPSH1','zh_TW','【開票業務處理】下推【付款處理】出現超額，請檢查',' ','【開票業務處理】下推【付款處理】出現重複，請檢查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696268115715057664;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1696268115681503232,'Head','{"expression":"","exprTran":"业务处理 不在……中 (票据退票,买方付息)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3EPTL4EUJ=OS","leftBracket":"","compareType":"34","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3EPTL4EUJ=/I","value":"refund"},{"id":"3EPTL4EUJ=OT","value":"payinterest"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3EPTL4EUJ=OS\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPTL4EUJ=/I\",\"value\":\"refund\"},{\"id\":\"3EPTL4EUJ=OT\",\"value\":\"payinterest\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"业务处理 不在……中 (票据退票,买方付息)"},"exprDesc":"业务处理 不在……中 (票据退票,买方付息)"}',1696268115715057664,' ','{"expression":"","exprTran":"发生退票 不等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3EPTO2K8Z+S7","leftBracket":"","compareType":"106","fieldName":"isrefund","rightBracket":"","logic":"0","value":[{"id":"3EPTO2K8Z/FG","value":"1"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3EPTO2K8Z+S7\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"isrefund\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPTO2K8Z/FG\",\"value\":\"1\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"发生退票 不等于 是"},"exprDesc":"发生退票 不等于 是"}','发生退票 不等于 是','单据体.票面金额(子票包金额)','EntrySum','billamt',1,'amount','业务处理 不在……中 (票据退票,买方付息)',' ','单据头.票面金额(子票包金额)'); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696271561662949376;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1696271561520343040,'Head','{"expression":"","exprTran":"业务处理 不在……中 (票据退票,买方付息,票据质押,质押解除,托管取回,票据托管)   and    失败重付生成 等于 否   and    是否失败重付 等于 否   and    是否拒收退票 等于 否   and    拒收退票生成 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3EPZ2BIYMX8K","leftBracket":"","compareType":"34","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMXXU","value":"refund"},{"id":"3EPZ2BIYMX8L","value":"payinterest"},{"id":"3EPZ2BIYMXXV","value":"pledge"},{"id":"3EPZ2BIYMX8M","value":"rlspledge"},{"id":"3EPZA5F5ADWA","value":"retrieve"},{"id":"3EPZA5F5AD72","value":"trusteeship"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXW","leftBracket":"","compareType":"105","fieldName":"isrepaygen","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8N","value":"0"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXX","leftBracket":"","compareType":"105","fieldName":"isrepay","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8O","value":"0"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXY","leftBracket":"","compareType":"105","fieldName":"isrejectrefund","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8P","value":"0"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXZ","leftBracket":"","compareType":"105","fieldName":"isrejectrefundgen","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8Q","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3EPZ2BIYMX8K\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMXXU\",\"value\":\"refund\"},{\"id\":\"3EPZ2BIYMX8L\",\"value\":\"payinterest\"},{\"id\":\"3EPZ2BIYMXXV\",\"value\":\"pledge\"},{\"id\":\"3EPZ2BIYMX8M\",\"value\":\"rlspledge\"},{\"id\":\"3EPZA5F5ADWA\",\"value\":\"retrieve\"},{\"id\":\"3EPZA5F5AD72\",\"value\":\"trusteeship\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXW\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrepaygen\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8N\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXX\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrepay\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8O\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXY\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrejectrefund\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8P\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXZ\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrejectrefundgen\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8Q\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"业务处理 不在……中 (票据退票,买方付息,票据质押,质押解除,托管取回,票据托管)   and    失败重付生成 等于 否   and    是否失败重付 等于 否   and    是否拒收退票 等于 否   and    拒收退票生成 等于 否"},"exprDesc":"业务处理 不在……中 (票据退票,买方付息,票据质押,质押解除,托管取回,票据托管)   and    失败重付生成 等于 否   and    是否失败重付 等于 否   and    是否拒收退票 等于 否   and    拒收退票生成 等于 否"}',1696271561662949376,' ','{"expression":"","exprTran":"发生退票 等于 否   or    质押到期日期 为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3EPZ6TKS9311","leftBracket":"","compareType":"105","fieldName":"isrefund","rightBracket":"","logic":"1","value":[{"id":"3EPZ6TKS93QA","value":"0"}],"baseDataIds":[]},{"id":"3EPZ6TKS9312","leftBracket":"","compareType":"37","fieldName":"pledgeenddate","rightBracket":"","logic":"0","value":[{"id":"3EPZ6TKS93QB","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3EPZ6TKS9311\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrefund\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"3EPZ6TKS93QA\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ6TKS9312\",\"leftBracket\":\"\",\"compareType\":\"37\",\"fieldName\":\"pledgeenddate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ6TKS93QB\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"发生退票 等于 否   or    质押到期日期 为空"},"exprDesc":"发生退票 等于 否   or    质押到期日期 为空"}','发生退票 等于 否   or    质押到期日期 为空','单据体.票面金额(子票包金额)','EntrySum','billamt',1,'amount','业务处理 不在……中 (票据退票,买方付息,票据质押,质押解除,托管取回,票据托......',' ','单据头.票面金额(子票包金额)');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1428213780944310272;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415240455519483904,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GEEL2HIG1X6","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GEEL2HIG2KF","value":"F"},{"id":"2GEEL2HIG1X7","value":"G"},{"id":"2GEEL2HIG2KG","value":"H"},{"id":"2GEEL2HIG1X8","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GEEL2HIG1X6\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GEEL2HIG2KF\",\"value\":\"F\"},{\"id\":\"2GEEL2HIG1X7\",\"value\":\"G\"},{\"id\":\"2GEEL2HIG2KG\",\"value\":\"H\"},{\"id\":\"2GEEL2HIG1X8\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}',1428213780944310272,' ',' ',' ','单据头.付款金额','Head','actpayamt',1,'billamt','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ','单据体.票面金额(子票包金额)');




