/*  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 = 1415272074448000000;
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',1415272074448000000,'{"filterRow":[{"id":"3LZDQ9F0O5IB","leftBracket":"","compareType":"106","fieldName":"paidstatus","rightBracket":"","logic":"0","value":[{"id":"3LZDQ9F0O5IC","value":"C"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,pay,autocommitbe,',' ','1','【内部结算受理】下推【付款交易处理】出现重复，请检查',',submit,save,pay,autocommitbe,','LargerOrEqual',1415272074448000000,'ifm_transhandlebill',' ','C','0','ifm_payacceptancebill -> ifm_transhandlebill',' ',1415270803339005952,' ',' ','0','1','1','ifm_payacceptancebill'); 
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415279328177999872;
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',1415279328177999872,'{"filterRow":[{"id":"3LZE+X5Y7SGQ","leftBracket":"","compareType":"106","fieldName":"paidstatus","rightBracket":"","logic":"0","value":[{"id":"3LZE+X5Y7SGR","value":"C"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,pay,autocommitbe,',' ','1','【结算中心扣款】下推【付款交易处理】出现重复，请检查',',submit,save,pay,autocommitbe,','LargerOrEqual',1415279328177999872,'ifm_transhandlebill',' ','C','0','ifm_deduction-> ifm_transhandlebill',' ',1415278790619223040,' ',' ','0','1','1','ifm_deduction'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUEHD72TISB';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415272074448000000,'2EUEHD72TISB','zh_CN',' ',' ','【内部结算受理】下推【付款交易处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUEHD72TISC';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415272074448000000,'2EUEHD72TISC','zh_TW',' ',' ','【內部結算受理】下推【付款交易處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUFV8N20/YJ';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415279328177999872,'2EUFV8N20/YJ','zh_CN',' ',' ','【结算中心扣款】下推【付款交易处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUFV8N20/YK';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415279328177999872,'2EUFV8N20/YK','zh_TW',' ',' ','【結算中心扣款】下推【付款交易處理】出現重複，請檢查',' '); 


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_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_AMTCTRL WHERE FENTRYID = 1415179594985651200;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',NULL,NULL,'0','Head','convertdrawamt',1,'amount','循环贷款 等于 否   and    单据状态 不等于 暂存',' ','单据头.贷款金额',' ',1415179594960485376,' ','0',1415179594985651200,'0',' ',' ','单据头.折合同币别金额',NULL,' ',' ','0',' '); 



