/*  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','0','1','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":"( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )  and   ( 划扣保证金 等于 否   and    保证金抵扣 等于 否 )","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3FBXOMIE96YG","leftBracket":"(","compareType":"105","fieldName":"source","rightBracket":"","logic":"1","value":[{"id":"3FBXOMIHWLFQ","value":"cdm-draftallocate"}],"baseDataIds":[]},{"id":"3FBZ0/HDHCZX","leftBracket":"","compareType":"105","fieldName":"tradetype","rightBracket":")","logic":"0","value":[{"id":"3FBZ0/HDHDN5","value":"payinterest"}],"baseDataIds":[]},{"id":"3FBZ0/HDHCZY","leftBracket":"(","compareType":"105","fieldName":"deposit","rightBracket":"","logic":"0","value":[{"id":"3FBZ0/HDHDN6","value":"0"}],"baseDataIds":[]},{"id":"3HD3M2DUCRQE","leftBracket":"","compareType":"105","fieldName":"depositdeduct","rightBracket":")","logic":"0","value":[{"id":"3HD3M2DUCR15","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3FBXOMIE96YG\",\"leftBracket\":\"(\",\"compareType\":\"105\",\"fieldName\":\"source\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"3FBXOMIHWLFQ\",\"value\":\"cdm-draftallocate\"}],\"baseDataIds\":[]},{\"id\":\"3FBZ0/HDHCZX\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"tradetype\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBZ0/HDHDN5\",\"value\":\"payinterest\"}],\"baseDataIds\":[]},{\"id\":\"3FBZ0/HDHCZY\",\"leftBracket\":\"(\",\"compareType\":\"105\",\"fieldName\":\"deposit\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3FBZ0/HDHDN6\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3HD3M2DUCRQE\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"depositdeduct\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"3HD3M2DUCR15\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )  and   ( 划扣保证金 等于 否   and    保证金抵扣 等于 否 )"},"exprDesc":"( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )  and   ( 划扣保证金 等于 否   and    保证金抵扣 等于 否 )"}','( 来源系统 等于 票据调度   or    业务处理 等于 买方付息 )  a......','单据头.付款金额','Head','actpayamt',1,'amount','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ','单据头.合计金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1428213780944310272;



