/*  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 = 1415209747811941376;
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',1415209747811941376,'{"filterRow":[{"id":"3AC=5YL6+CV6","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3AC=5YL5U2SV","value":"F"},{"id":"3AC=5YL6+CV7","value":"G"},{"id":"3AC=5YL5U2SW","value":"H"},{"id":"3AC=5YL6+CV8","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【费用明细】下推【付款处理】出现超额，请检查','1','【费用明细】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415209747811941376,'cas_paybill','sourcebillid','C','1','cfm_feebill -> cas_paybill',' ',1415208603152824320,',save,submit,',' ','1','1','1','cfm_feebill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU3V9T56WHD';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415209747811941376,'2EU3V9T56WHD','zh_CN','【费用明细】下推【付款处理】出现超额，请检查',' ','【费用明细】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU3V9T56WHE';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415209747811941376,'2EU3V9T56WHE','zh_TW','【費用明細】下推【付款處理】出現超額，請檢查',' ','【費用明細】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696399308083127296;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1415209747811941376,'Head','Head','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3AC9W7FMOTLF","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3AC9W7FMV2NS","value":"F"},{"id":"3AC9W7FMOTLG","value":"G"},{"id":"3AC9W7FMV2NT","value":"H"},{"id":"3AC9W7FMOTLH","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3AC9W7FMOTLF\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3AC9W7FMV2NS\",\"value\":\"F\"},{\"id\":\"3AC9W7FMOTLG\",\"value\":\"G\"},{\"id\":\"3AC9W7FMV2NT\",\"value\":\"H\"},{\"id\":\"3AC9W7FMOTLH\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}',1696399308083127296,'actpayamt',1,'payamt',' ','单据状态 不在……中 (银行退票,已退单,已作废,退款)','单据头.费用金额','单据头.付款金额');










