/*  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 = 1696271561520343040;
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',1696271561520343040,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','【收票登记】下推【业务处理】出现超额，请检查','1','【收票登记】下推【业务处理】出现重复，请检查',',submit,save,','LargerOrEqual',1696271561520343040,'cdm_drafttradebill',' ','C','1','cdm_receivablebill -> cdm_drafttradebill',' ',1415300030759228416,',save,submit,',' ','1','1','0','cdm_receivablebill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABO0V3YAUJY';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696271561520343040,'3ABO0V3YAUJY','zh_CN','【收票登记】下推【业务处理】出现超额，请检查',' ','【收票登记】下推【业务处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABO0V3YAUJZ';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696271561520343040,'3ABO0V3YAUJZ','zh_TW','【收票登記】下推【業務處理】出現超額，請檢查',' ','【收票登記】下推【業務處理】出現重複，請檢查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696271561662949376;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1696271561520343040,'Head','{"expression":"","exprTran":"业务处理 不在……中 (买方付息,票据质押,质押解除,托管取回,票据托管,票据退票,背书转让)   and    失败重付生成 等于 否   and    是否失败重付 等于 否   and    拒收退票生成 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3EPZ2BIYMX8K","leftBracket":"","compareType":"34","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMXXU","value":"payinterest"},{"id":"3EPZ2BIYMX8L","value":"pledge"},{"id":"3EPZ2BIYMXXV","value":"rlspledge"},{"id":"3EPZ2BIYMX8M","value":"retrieve"},{"id":"3EPZA5F5ADWA","value":"trusteeship"},{"id":"3FC8MHVT/3FT","value":"refund"},{"id":"3FC98B/VFP5V","value":"endorse"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXW","leftBracket":"","compareType":"105","fieldName":"isrepaygen","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8N","value":"0"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXX","leftBracket":"","compareType":"105","fieldName":"isrepay","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8O","value":"0"}],"baseDataIds":[]},{"id":"3EPZ2BIYMXXY","leftBracket":"","compareType":"105","fieldName":"isrejectrefundgen","rightBracket":"","logic":"0","value":[{"id":"3EPZ2BIYMX8P","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3EPZ2BIYMX8K\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMXXU\",\"value\":\"payinterest\"},{\"id\":\"3EPZ2BIYMX8L\",\"value\":\"pledge\"},{\"id\":\"3EPZ2BIYMXXV\",\"value\":\"rlspledge\"},{\"id\":\"3EPZ2BIYMX8M\",\"value\":\"retrieve\"},{\"id\":\"3EPZA5F5ADWA\",\"value\":\"trusteeship\"},{\"id\":\"3FC8MHVT/3FT\",\"value\":\"refund\"},{\"id\":\"3FC98B/VFP5V\",\"value\":\"endorse\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXW\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrepaygen\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8N\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXX\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrepay\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8O\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ2BIYMXXY\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrejectrefundgen\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ2BIYMX8P\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"业务处理 不在……中 (买方付息,票据质押,质押解除,托管取回,票据托管,票据退票,背书转让)   and    失败重付生成 等于 否   and    是否失败重付 等于 否   and    拒收退票生成 等于 否","localeExprTran":{"zh_CN":"业务处理 不在……中 (买方付息,票据质押,质押解除,托管取回,票据托管,票据退票,背书转让)   and    失败重付生成 等于 否   and    是否失败重付 等于 否   and    拒收退票生成 等于 否"}}',1696271561662949376,' ','{"expression":"","exprTran":"发生退票 等于 否   or    质押到期日期 为空","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3EPZ6TKS9311","leftBracket":"","compareType":"105","fieldName":"isrefund","rightBracket":"","logic":"1","value":[{"id":"3EPZ6TKS93QA","value":"0"}],"baseDataIds":[]},{"id":"3EPZ6TKS9312","leftBracket":"","compareType":"37","fieldName":"pledgeenddate","rightBracket":"","logic":"0","value":[{"id":"3EPZ6TKS93QB","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3EPZ6TKS9311\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isrefund\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"3EPZ6TKS93QA\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"3EPZ6TKS9312\",\"leftBracket\":\"\",\"compareType\":\"37\",\"fieldName\":\"pledgeenddate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3EPZ6TKS93QB\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"发生退票 等于 否   or    质押到期日期 为空"},"exprDesc":"发生退票 等于 否   or    质押到期日期 为空"}','发生退票 等于 否   or    质押到期日期 为空','单据体.票面金额(子票包金额)','EntrySum','billamt',1,'originalsubbillamount','业务处理 不在……中 (买方付息,票据质押,质押解除,托管取回,票据托管,票据退......',' ','单据头.原始子票包金额');




