/*  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":"3M0BP5SVELH5","leftBracket":"","compareType":"106","fieldName":"paidstatus","rightBracket":"","logic":"0","value":[{"id":"3M0BP5SVELH6","value":"C"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,pay,autocommitbe,','【内部结算受理】下推【付款交易处理】出现超额，请检查','1','【内部结算受理】下推【付款交易处理】出现重复，请检查',',submit,save,pay,autocommitbe,','LargerOrEqual',1415272074448000000,'ifm_transhandlebill',' ','C','1','ifm_payacceptancebill -> ifm_transhandlebill',' ',1415270803339005952,',save,submit,pay,autocommitbe,',' ','1','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":"3M0BYO6L1DT3","leftBracket":"","compareType":"106","fieldName":"paidstatus","rightBracket":"","logic":"0","value":[{"id":"3M0BYO6L1DT4","value":"C"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,pay,autocommitbe,','【结算中心扣款】下推【付款交易处理】出现超额，请检查','1','【结算中心扣款】下推【付款交易处理】出现重复，请检查',',submit,save,pay,autocommitbe,','LargerOrEqual',1415279328177999872,'ifm_transhandlebill',' ','C','1','ifm_deduction-> ifm_transhandlebill',' ',1415278790619223040,',save,submit,pay,autocommitbe,',' ','1','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_AMTCTRL WHERE FENTRYID = 1791387346814400512;
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',' ',' ','0','Head','actpayamt',1,'actpayamt',' ',' ','单据头.付款金额',' ',1415272074448000000,' ','0',1791387346814400512,'0',' ',' ','单据头.付款金额',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1791387548317153280;
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 ('EntrySum',' ',' ','0','Head','actpayamt',1,'payamount',' ',' ','扣款明细（支出方）.金额',' ',1415279328177999872,' ','0',1791387548317153280,'0',' ',' ','单据头.付款金额',' ',' ',' ','0',' '); 




