/*  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 = 1415334004864861184;
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',1415334004864861184,'{"filterRow":[{"id":"3KE1WFAV4EIN","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3KE1WFAV6I+O","value":"F"},{"id":"3KE1WFAV4EIO","value":"G"},{"id":"3KE1WFAV6I+P","value":"H"},{"id":"3KE1WFAV4EIP","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,beforecommitbe,','【结构性存款】下推【付款处理】出现超额，请检查','1','【结构性存款】下推【付款处理】出现重复，请检查',',beforecommitbe,submit,save,','LargerOrEqual',1415334004864861184,'cas_paybill',' ','C','1','tm_structdeposit -> cas_paybill',' ',1415330073937985536,',save,submit,',' ','1','1','1','tm_structdeposit');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ1OB/6YW8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334004864861184,'2EUQ1OB/6YW8','zh_CN','【结构性存款】下推【付款处理】出现超额，请检查',' ','【结构性存款】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ1OB/6YW9';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334004864861184,'2EUQ1OB/6YW9','zh_TW','【結構性存款】下推【付款處理】出現超額，請檢查',' ','【結構性存款】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1693526546737931264;
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','actpayamt',1,'buysettleamt',' ',' ','单据头.结算金额',' ',1415334004864861184,' ','0',1693526546737931264,'0',' ',' ','单据头.付款金额',NULL,' ',' ','0',' ');




