/*  creator：齐博旭
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript>
*********************************************************************
*/
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_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_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":"382JF9YG0UQL","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"382JF9YN6HVU","value":"A"}],"baseDataIds":[]},{"id":"382JF9YN=O3M","leftBracket":"","compareType":"105","fieldName":"iscycleloan","rightBracket":"","logic":"0","value":[{"id":"382JF9YN6HVV","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"382JF9YG0UQL\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"382JF9YN6HVU\",\"value\":\"A\"}],\"baseDataIds\":[]},{\"id\":\"382JF9YN=O3M\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"iscycleloan\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"382JF9YN6HVV\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不等于 暂存   and    循环贷款 等于 否","localeExprTran":{"zh_CN":"单据状态 不等于 暂存   and    循环贷款 等于 否"}}',1415055039919041536,'convertdrawamt',1,'amount',' ','单据状态 不等于 暂存   and    循环贷款 等于 否','单据头.借款金额','单据头.折合同币别金额');




