/*  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 = 1415179594960485376;
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',1415179594960485376,'{"filterRow":[],"forList":false}',' ','0',' ','【企业贷款合同】下推【企业放款处理】出现超额，请检查','1',' ',',submit,','LargerOrEqual',1415179594960485376,'cim_invest_loanbill',' ','C','1','cim_invest_contract -> cim_invest_loanbill',' ',1415176488365341696,',submit,',' ','1','1','0','cim_invest_contract');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415055039885487104;
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',1415055039885487104,'{"filterRow":[],"forList":false}',' ','0',' ','【借款合同】下推【提款处理】出现超额，请检查','1',' ',',submit,','LargerOrEqual',1415055039885487104,'cfm_loanbill',' ','C','1','cfm_loancontractbill -> cfm_loanbill',' ',1415053207293406208,',submit,',' ','1','1','0','cfm_loancontractbill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415104347049614336;
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',1415104347049614336,'{"filterRow":[],"forList":false}',' ','0',' ','【贷款合同处理】下推【贷款放款处理】出现超额，请检查','1',' ',',submit,','LargerOrEqual',1415104347049614336,'ifm_loanbill',' ','C','1','ifm_loancontractbill -> ifm_loanbill',' ',1415102004681780224,',submit,',' ','1','1','0','ifm_loancontractbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETCYVMGBE9B';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415055039885487104,'2ETCYVMGBE9B','zh_TW','【借款合同】下推【提款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETCYVMGBE9A';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415055039885487104,'2ETCYVMGBE9A','zh_CN','【借款合同】下推【提款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU+7H7OB9KU';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415179594960485376,'2EU+7H7OB9KU','zh_CN','【企业贷款合同】下推【企业放款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU+7H7OB9KV';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415179594960485376,'2EU+7H7OB9KV','zh_TW','【企業貸款合同】下推【企業放款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETM55CA16M+';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415104347049614336,'2ETM55CA16M+','zh_CN','【贷款合同处理】下推【贷款放款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETM55CA16M/';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415104347049614336,'2ETM55CA16M/','zh_TW','【貸款合同處理】下推【貸款放款處理】出現超額，請檢查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415055039919041536;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415055039885487104,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 暂存   and    循环贷款 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2X82OXSCASFY","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2X82OXSG1BX8","value":"A"}],"baseDataIds":[]},{"id":"2ZMU5TAZY53T","leftBracket":"","compareType":"105","fieldName":"iscycleloan","rightBracket":"","logic":"0","value":[{"id":"2ZMU5TAZY74K","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2X82OXSCASFY\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2X82OXSG1BX8\",\"value\":\"A\"}],\"baseDataIds\":[]},{\"id\":\"2ZMU5TAZY53T\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"iscycleloan\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2ZMU5TAZY74K\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 暂存   and    循环贷款 等于 否"},"exprDesc":"单据状态 不等于 暂存   and    循环贷款 等于 否"}',1415055039919041536,'drawamount',1,'amount',' ','单据状态 不等于 暂存   and    循环贷款 等于 否','单据头.借款金额','单据头.提款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415179594985651200;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415179594960485376,'Head','Head','{"expression":"","exprTran":"循环贷款 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"32IZ6K4TZ9QK","leftBracket":"","compareType":"105","fieldName":"iscycleloan","rightBracket":"","logic":"0","value":[{"id":"32IZ6K4TX6YT","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"32IZ6K4TZ9QK\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"iscycleloan\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"32IZ6K4TX6YT\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"循环贷款 等于 否"},"exprDesc":"循环贷款 等于 否"}',1415179594985651200,'drawamount',1,'amount',' ','循环贷款 等于 否','单据头.贷款金额','单据头.放款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415104347158666240;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415104347049614336,'Head','Head','{"expression":"","exprTran":"单据状态 不等于 暂存   and    循环贷款 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2X917L45NRS9","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2X917L45NNQQ","value":"A"}],"baseDataIds":[]},{"id":"32=PAGDJZM1R","leftBracket":"","compareType":"105","fieldName":"iscycleloan","rightBracket":"","logic":"0","value":[{"id":"32=PAGDK/OVI","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2X917L45NRS9\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2X917L45NNQQ\",\"value\":\"A\"}],\"baseDataIds\":[]},{\"id\":\"32=PAGDJZM1R\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"iscycleloan\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"32=PAGDK/OVI\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不等于 暂存   and    循环贷款 等于 否","localeExprTran":{"zh_CN":"单据状态 不等于 暂存   and    循环贷款 等于 否"}}',1415104347158666240,'drawamount',1,'amount',' ','单据状态 不等于 暂存   and    循环贷款 等于 否','单据头.借款金额','单据头.放款金额');




