/*  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 = 1415190156570278912;
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',1415190156570278912,'{"filterRow":[{"id":"3V64=HKXQMBN","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3V64=HKXP332","value":"H"},{"id":"3V64=HKXQMBO","value":"G"},{"id":"3V64=HKXP333","value":"F"},{"id":"3V64=HKXQMBP","value":"I"}],"baseDataIds":[],"lock":false}],"forList":false}',' ','0',' ','【付款申请】下推【付款处理】出现超额，请检查','1','【付款申请】下推【付款处理】出现重复，请检查',',submit,audit,save,','LargerOrEqual',1415190156570278912,'cas_paybill',' ','C','1','cas_payapplybill -> cas_paybill',' ',1415184354933487616,',audit,save,submit,',' ','1','1','0','cas_payapplybill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3YCSQIMNHEKY';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415190156570278912,'3YCSQIMNHEKY','en_US','^en_US【付款申请】下推【付款处理】出现超额，请检查^',' ','^en_US【付款申请】下推【付款处理】出现重复，请检查^',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU06FS08JGH';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415190156570278912,'2EU06FS08JGH','zh_CN','【付款申请】下推【付款处理】出现超额，请检查',' ','【付款申请】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU06FS08JGI';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415190156570278912,'2EU06FS08JGI','zh_TW','【付款申請】下推【付款處理】出現超額，請檢查',' ','【付款申請】下推【付款處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1896562312224036864;
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 ('EntrySingle','{"expression":"","exprTran":"付款申请支持部分付款 等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3YZ7LMVLN04=","leftBracket":"","compareType":"105","fieldName":"ispartpayment","rightBracket":"","logic":"0","value":[{"id":"3YZ7LMVLN/G0","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3YZ7LMVLN04=\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"ispartpayment\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3YZ7LMVLN/G0\",\"value\":\"1\"}],\"baseDataIds\":[],\"lock\":false}],\"forList\":false}","initialized":false,"exprDesc":"付款申请支持部分付款 等于 是","localeExprTran":{"zh_CN":"付款申请支持部分付款 等于 是"}}',' ','1','EntrySum',' ',1,'entry_payeeamount','单据状态 不在……中 (已退单)',' ','付款明细分录.收款金额',' ',1415190156570278912,'{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3YZ84TOYO5YE","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3YZ84TOYO595","value":"G"}],"baseDataIds":[],"lock":false}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3YZ84TOYO5YE\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3YZ84TOYO595\",\"value\":\"G\"}],\"baseDataIds\":[],\"lock\":false}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"},"exprDesc":"单据状态 不在……中 (已退单)"}','0',1896562312224036864,'0',' ','付款申请支持部分付款 等于 是',' ','[{"F":"entry.e_payableamt","FN":"付款明细.应付金额","CR":"-"},{"F":"entry.e_refundamt","FN":"付款明细.退款金额","CR":"+"}]',' ',' ','0','付款明细.应付金额-付款明细.退款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1896562312224036866;
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',' ',' ','1','EntrySum',' ',3,'payeeamount','付款金额 大于 0   and    单据状态 不等于 已退单',' ','单据头.收款总额',' ',1415190156570278912,' ','0',1896562312224036866,'0',' ',' ',' ','[{"F":"entry.e_payableamt","FN":"付款明细.应付金额","CR":"-"},{"F":"entry.e_refundamt","FN":"付款明细.退款金额","CR":"+"}]',' ',' ','0','付款明细.应付金额-付款明细.退款金额');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1896562312224036865;
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 ('EntrySingle','{"expression":"","exprTran":"付款申请支持部分付款 等于 否","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3YZ88VQMR5KB","leftBracket":"","compareType":"105","fieldName":"ispartpayment","rightBracket":"","logic":"0","value":[{"id":"3YZ88VQMR4X2","value":"0"}],"baseDataIds":[],"lock":false}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3YZ88VQMR5KB\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"ispartpayment\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3YZ88VQMR4X2\",\"value\":\"0\"}],\"baseDataIds\":[],\"lock\":false}],\"forList\":false}","initialized":false,"exprDesc":"付款申请支持部分付款 等于 否","localeExprTran":{"zh_CN":"付款申请支持部分付款 等于 否"}}',' ','1','EntrySum',' ',2,'entry_payeeamount',' ',' ','付款明细分录.收款金额',' ',1415190156570278912,' ','0',1896562312224036865,'0',' ','付款申请支持部分付款 等于 否',' ','[{"F":"entry.e_payableamt","FN":"付款明细.应付金额","CR":"-"},{"F":"entry.e_refundamt","FN":"付款明细.退款金额","CR":"+"}]',' ',' ','0','付款明细.应付金额-付款明细.退款金额');




