/*  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 = 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 = '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 = 1737027977394293760;
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,'Head','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3FBXRY1MUJ7H","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3FBXRY1MUJWS","value":"F"},{"id":"3FBXRY1MUJ7I","value":"G"},{"id":"3FBXRY1MUJWT","value":"H"},{"id":"3FBXRY1MUJ7J","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3FBXRY1MUJ7H\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBXRY1MUJWS\",\"value\":\"F\"},{\"id\":\"3FBXRY1MUJ7I\",\"value\":\"G\"},{\"id\":\"3FBXRY1MUJWT\",\"value\":\"H\"},{\"id\":\"3FBXRY1MUJ7J\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}}',1737027977394293760,' ','{"expression":"","exprTran":"划扣保证金 等于 否   and   ( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3FBXOMIE96YG","leftBracket":"","compareType":"105","fieldName":"deposit","rightBracket":"","logic":"0","value":[{"id":"3FBXOMIHWLFQ","value":"0"}],"baseDataIds":[]},{"id":"3FBZ0/HDHCZX","leftBracket":"(","compareType":"105","fieldName":"source","rightBracket":"","logic":"1","value":[{"id":"3FBZ0/HDHDN5","value":"cdm-draftallocate"}],"baseDataIds":[]},{"id":"3FBZ0/HDHCZY","leftBracket":"","compareType":"105","fieldName":"tradetype","rightBracket":")","logic":"0","value":[{"id":"3FBZ0/HDHDN6","value":"payinterest"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3FBXOMIE96YG\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"deposit\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBXOMIHWLFQ\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3FBZ0/HDHCZX\",\"leftBracket\":\"(\",\"compareType\":\"105\",\"fieldName\":\"source\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"3FBZ0/HDHDN5\",\"value\":\"cdm-draftallocate\"}],\"baseDataIds\":[]},{\"id\":\"3FBZ0/HDHCZY\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"tradetype\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBZ0/HDHDN6\",\"value\":\"payinterest\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"划扣保证金 等于 否   and   ( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )","localeExprTran":{"zh_CN":"划扣保证金 等于 否   and   ( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )"}}','划扣保证金 等于 否   and   ( 来源系统 等于 票据调度   or  ......','单据头.付款金额','Head','actpayamt',2,'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,' ','{"expression":"","exprTran":"划扣保证金 等于 是   or   ( 来源系统 不等于 票据调度   and    业务处理 不等于 买方付息 )","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3FBXM1O8L3W8","leftBracket":"","compareType":"105","fieldName":"deposit","rightBracket":"","logic":"1","value":[{"id":"3FBXM1O8L4JH","value":"1"}],"baseDataIds":[]},{"id":"3FBZ49X8OX11","leftBracket":"(","compareType":"106","fieldName":"source","rightBracket":"","logic":"0","value":[{"id":"3FBZ49X8OWCT","value":"cdm-draftallocate"}],"baseDataIds":[]},{"id":"3FBZ49X8OX12","leftBracket":"","compareType":"106","fieldName":"tradetype","rightBracket":")","logic":"0","value":[{"id":"3FBZ49X8OWCU","value":"payinterest"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3FBXM1O8L3W8\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"deposit\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"3FBXM1O8L4JH\",\"value\":\"1\"}],\"baseDataIds\":[]},{\"id\":\"3FBZ49X8OX11\",\"leftBracket\":\"(\",\"compareType\":\"106\",\"fieldName\":\"source\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBZ49X8OWCT\",\"value\":\"cdm-draftallocate\"}],\"baseDataIds\":[]},{\"id\":\"3FBZ49X8OX12\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"tradetype\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBZ49X8OWCU\",\"value\":\"payinterest\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"划扣保证金 等于 是   or   ( 来源系统 不等于 票据调度   and    业务处理 不等于 买方付息 )","localeExprTran":{"zh_CN":"划扣保证金 等于 是   or   ( 来源系统 不等于 票据调度   and    业务处理 不等于 买方付息 )"}}','划扣保证金 等于 是   or   ( 来源系统 不等于 票据调度   and ......','单据头.付款金额','Head','actpayamt',1,'billamt','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ','单据体.票面金额(子票包金额)');




