/*  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 = 1415053612379286528;
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',1415053612379286528,'{"filterRow":[{"id":"3ABX74JTZKMO","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3ABX74JTT=KB","value":"G"},{"id":"3ABX74JTZKMP","value":"H"},{"id":"3ABX74JTT=KC","value":"F"},{"id":"3ABX74JTZKMQ","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【付款处理】下推【付款处理】出现超额，请检查','1','【付款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415053612379286528,'cas_paybill','sourcebillid','C','1','cas_paybill -> cas_paybill',' ',1415051859311209472,',save,submit,',' ','1','1','0','cas_paybill');


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


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032192;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415053612379286528,'Head',' ',1696321736209032192,' ','{"expression":"","exprTran":"委托付款组织.编码 为空   and    手续费独立流水 等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3ABX=+A+17HE","leftBracket":"","compareType":"37","fieldName":"entrustorg.number","rightBracket":"","logic":"0","value":[{"id":"3ABX=+A+7HJS","value":""}],"baseDataIds":[]},{"id":"3ABX=+A+7HJT","leftBracket":"","compareType":"105","fieldName":"singlestream","rightBracket":"","logic":"0","value":[{"id":"3ABX=+A+17HG","value":"1"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3ABX=+A+17HE\",\"leftBracket\":\"\",\"compareType\":\"37\",\"fieldName\":\"entrustorg.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABX=+A+7HJS\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"3ABX=+A+7HJT\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"singlestream\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABX=+A+17HG\",\"value\":\"1\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"委托付款组织.编码 为空   and    手续费独立流水 等于 是"},"exprDesc":"委托付款组织.编码 为空   and    手续费独立流水 等于 是"}','委托付款组织.编码 为空   and    手续费独立流水 等于 是','单据头.异币别付款金额','Head','dpamt',1,'fee',' ',' ','单据头.手续费');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032193;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415053612379286528,'Head',' ',1696321736209032193,' ','{"expression":"","exprTran":"委托付款组织.编码 不为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3ABXAJDURJMU","leftBracket":"","compareType":"9","fieldName":"entrustorg.number","rightBracket":"","logic":"0","value":[{"id":"3ABXAJDUL9KH","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3ABXAJDURJMU\",\"leftBracket\":\"\",\"compareType\":\"9\",\"fieldName\":\"entrustorg.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3ABXAJDUL9KH\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"委托付款组织.编码 不为空"},"exprDesc":"委托付款组织.编码 不为空"}','委托付款组织.编码 不为空','单据头.付款金额','Head','actpayamt',2,'dpamt',' ',' ','单据头.异币别付款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032194;



