/*  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 = 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 = '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 = 1415104347158666240;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415104347049614336,'Head',' ',1415104347158666240,' ',' ','同步放款 等于 否   or   ( 同步放款 等于 是   and    数据......','单据头.折合同币别金额','Head','convertdrawamt',1,'amount','单据状态 不等于 暂存   and    循环贷款 等于 否',' ','单据头.借款金额');



DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415066436304382976;
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',1415066436304382976,'{"filterRow":[],"forList":false}',' ','0',' ','【提款处理】下推【还款处理】出现超额，请检查','1',' ',',submit,audit,','LargerOrEqual',1415066436304382976,'cfm_repaymentbill',' ','C','1','cfm_loanbill -> cfm_repaymentbill',' ',1415059964199754752,',submit,audit,',' ','1','1','0','cfm_loanbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETF1XDHOKU8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415066436304382976,'2ETF1XDHOKU8','zh_TW','【提款處理】下推【還款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETF1XDHOKU7';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415066436304382976,'2ETF1XDHOKU7','zh_CN','【提款处理】下推【还款处理】出现超额，请检查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415066436321160192;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415066436304382976,'Head','{"expression":"","exprTran":"单据状态 不等于 暂存","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2WMN2LF5I794","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2WMN2LF96R96","value":"A"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2WMN2LF5I794\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2WMN2LF96R96\",\"value\":\"A\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 暂存"},"exprDesc":"单据状态 不等于 暂存"}',1415066436321160192,' ',NULL,' ','提款信息.还款金额','EntrySum','e_repayamount',1,'drawamount','单据状态 不等于 暂存',' ','单据头.提款金额');

DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415188097225734144;
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',1415188097225734144,'{"filterRow":[],"forList":false}',' ','0',' ','【企业放款处理】下推【企业贷款收回】出现超额，请检查','1',' ',',submit,audit,','LargerOrEqual',1415188097225734144,'cim_invest_repaybill',' ','C','1','cim_invest_loanbill -> cim_invest_repaybill',' ',1415186133586819072,',submit,audit,',' ','1','1','0','cim_invest_loanbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU/TFP910PC';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415188097225734144,'2EU/TFP910PC','zh_CN','【企业放款处理】下推【企业贷款收回】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU/TFP910PD';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415188097225734144,'2EU/TFP910PD','zh_TW','【企業放款處理】下推【企業貸款收回】出現超額，請檢查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415188097947154432;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415188097225734144,'Head','{"expression":"","exprTran":"单据状态 不等于 暂存","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3C7K2EHYQCRR","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3C7K2EHYQDF/","value":"A"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3C7K2EHYQCRR\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3C7K2EHYQDF/\",\"value\":\"A\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 暂存"},"exprDesc":"单据状态 不等于 暂存"}',1415188097947154432,' ',NULL,' ','放款信息.收回金额','EntrySum','e_repayamount',1,'drawamount','单据状态 不等于 暂存',' ','单据头.放款金额');


DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415110202767760384;
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',1415110202767760384,'{"filterRow":[],"forList":false}',' ','0',' ','【贷款放款处理】下推【贷款收回处理】出现超额，请检查','1',' ',',submit,audit,','LargerOrEqual',1415110202767760384,'ifm_repaymentbill',' ','C','1','ifm_loanbill -> ifm_repaymentbill',' ',1415109112500378624,',audit,submit,',' ','1','1','0','ifm_loanbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETN8UHLRMGB';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415110202767760384,'2ETN8UHLRMGB','zh_CN','【贷款放款处理】下推【贷款收回处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETN8UHLRMGC';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415110202767760384,'2ETN8UHLRMGC','zh_TW','【貸款放款處理】下推【貸款收回處理】出現超額，請檢查',' ',' ',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415110202826480640;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415110202767760384,'Head','{"expression":"","exprTran":"单据状态 不等于 暂存","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2X915F5KVG26","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2X915F5KVK3Q","value":"A"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2X915F5KVG26\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2X915F5KVK3Q\",\"value\":\"A\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不等于 暂存"},"exprDesc":"单据状态 不等于 暂存"}',1415110202826480640,' ',NULL,' ','放款信息.收回金额','EntrySum','e_repayamount',1,'drawamount','单据状态 不等于 暂存',' ','单据头.放款金额');

