--支付防重预置脚本
DELETE FROM t_fcs_checkctrl WHERE FID = 1418871653286302720;
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',1418871653286302720,'{"filterRow":[],"forList":false}',' ','0',',save,submit,',' ','1','【存款业处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1418871653286302720,'cas_paybill','sourcebillid','C','0','cim_deposit -> cas_paybill',' ',1418723139751281664,' ',' ','0','1','1','cim_deposit');
DELETE FROM t_fcs_checkctrl WHERE FID = 1418871919901429760;
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',1418871919901429760,'{"filterRow":[],"forList":false}',' ','0',',save,submit,',' ','1','【存款解活处理】下推【收款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1418871919901429760,'cas_recbill','sourcebillid','C','0','cim_release -> cas_recbill',' ',1418725561307530240,' ',' ','0','1','1','cim_release');
DELETE FROM t_fcs_checkctrl WHERE FID = 1415197702576158720;
INSERT INTO t_fcs_checkctrl(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FFILTER,FPAYACCESSID,FCTRLAMTOP,FCTRLRULE,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','0',1415197702576158720,'{"filterRow":[{"id":"2I3XVS7PLMFE","leftBracket":"","compareType":"106","fieldName":"bizstatus","rightBracket":"","logic":"0","value":[{"id":"2I3XVS7WTKFH","value":"chargeback"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,',' ','1','【结算中心代扣申请】下推【结算中心扣款】出现重复，请检查',',submit,save,',1415197702576158720,'ifm_deduction','sourceentryid','C','0','fs_agentdeduction -> ifm_deduction',' ',' ',1415196159256837120,' ','LargerOrEqual','0','1','1','fs_agentdeduction');
--薪资代发单防重添加过滤
DELETE FROM t_fcs_checkctrl WHERE FID = 1423205415092638720;
INSERT INTO t_fcs_checkctrl(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FFILTER,FPAYACCESSID,FCTRLAMTOP,FCTRLRULE,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1423205415092638720,'{"filterRow":[{"id":"2I7M=SL90HV/","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2I7M=SL90II9","value":"F"},{"id":"2I7M=SL90HV0","value":"G"},{"id":"2I7M=SL90II=","value":"H"},{"id":"2I7M=SL90HV1","value":"I"}],"baseDataIds":[]},{"id":"2I7M=SL90IIA","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M=SL90HV2","value":"refund"},{"id":"2I7M=SL90IIB","value":"renote"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【薪资代发单】下推【代发处理】出现超额，请检查','1','【薪资代发单】下推【代发处理】出现重复，请检查',',submit,save,',1423205415092638720,'cas_agentpaybill',' ','C','1','hsas_agencypaybill -> cas_agentpaybill',' ',' ',1423202590648324096,',save,submit,','LargerOrEqual','1','1','1','hsas_agencypaybill');
--支付防重预置脚本（【供应链】简单委外订单 -> 付款处理）
DELETE FROM t_fcs_checkctrl WHERE FID = 1442906656194298880;
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',1442906656194298880,'{"filterRow":[],"forList":false}',' ','0',' ','【简单委外订单】下推【付款处理】出现超额，请检查','1',' ',',submit,save,','LargerOrEqual',1442906656194298880,'cas_paybill',' ','C','1','pm_om_purorderbill -> cas_paybill',' ',1442904144988996608,',save,submit,',' ','1','1','0','pm_om_purorderbill');


--支付防重多语言预置脚本

DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2F9O1FWQO7S0';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1418871653286302720,'2F9O1FWQO7S0','zh_CN',' ',' ','【存款业处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2F9O1FWQO7S1';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1418871653286302720,'2F9O1FWQO7S1','zh_TW',' ',' ','【存款業處理】下推【付款處理】出現重複，請檢查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2F9O3DNO6+TR';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1418871919901429760,'2F9O3DNO6+TR','zh_CN',' ',' ','【存款解活处理】下推【收款处理】出现重复，请检查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2F9O3DNO6+TS';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1418871919901429760,'2F9O3DNO6+TS','zh_TW',' ',' ','【存款解活處理】下推【收款處理】出現重複，請檢查',' ');

--防超额单据体amtctrl预置脚本
--目标单代发处理的超额添加分录字段过滤条件
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1417419502320148480;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1417419502135599104,'EntrySum','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQJ2VE0A7AO","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQJ2VE0A8+Y","value":"F"},{"id":"2FQJ2VE0A7AP","value":"G"},{"id":"2FQJ2VE0A8+Z","value":"H"},{"id":"2FQJ2VE0A7AQ","value":"I"}],"baseDataIds":[]},{"id":"2I7M0UKX5GXY","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M0UKX5HL7","value":"refund"},{"id":"2I7M0UKX5GXZ","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQJ2VE0A7AO\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQJ2VE0A8+Y\",\"value\":\"F\"},{\"id\":\"2FQJ2VE0A7AP\",\"value\":\"G\"},{\"id\":\"2FQJ2VE0A8+Z\",\"value\":\"H\"},{\"id\":\"2FQJ2VE0A7AQ\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7M0UKX5GXY\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7M0UKX5HL7\",\"value\":\"refund\"},{\"id\":\"2I7M0UKX5GXZ\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1417419502320148480,' ',NULL,'分录.付款金额','EntrySum','e_dpamt',1,'payamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','付款计划分录.金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1418117999688208384;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1418117999285555200,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQJ63VKJ+VK","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQJ63VKJ/IU","value":"F"},{"id":"2FQJ63VKJ+VL","value":"G"},{"id":"2FQJ63VKJ/IV","value":"H"},{"id":"2FQJ63VKJ+VM","value":"I"}],"baseDataIds":[]},{"id":"2I7M3QJX46S+","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M3QJX47F9","value":"refund"},{"id":"2I7M3QJX46S/","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQJ63VKJ+VK\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQJ63VKJ/IU\",\"value\":\"F\"},{\"id\":\"2FQJ63VKJ+VL\",\"value\":\"G\"},{\"id\":\"2FQJ63VKJ/IV\",\"value\":\"H\"},{\"id\":\"2FQJ63VKJ+VM\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7M3QJX46S+\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7M3QJX47F9\",\"value\":\"refund\"},{\"id\":\"2I7M3QJX46S/\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1418117999688208384,' ',NULL,'分录.金额','EntrySum','e_amount',1,'orireceiveamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','收款信息.收款金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1418116960691998720;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1418116960591335424,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQJ8GANUE7P","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQJ8GANUDJF","value":"F"},{"id":"2FQJ8GANUE7Q","value":"G"},{"id":"2FQJ8GANUDJG","value":"H"},{"id":"2FQJ8GANUE7R","value":"I"}],"baseDataIds":[]},{"id":"2I7M62PKGBJI","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M62PKGC7T","value":"refund"},{"id":"2I7M62PKGBJJ","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQJ8GANUE7P\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQJ8GANUDJF\",\"value\":\"F\"},{\"id\":\"2FQJ8GANUE7Q\",\"value\":\"G\"},{\"id\":\"2FQJ8GANUDJG\",\"value\":\"H\"},{\"id\":\"2FQJ8GANUE7R\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7M62PKGBJI\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7M62PKGC7T\",\"value\":\"refund\"},{\"id\":\"2I7M62PKGBJJ\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1418116960691998720,' ',NULL,'分录.金额','EntrySum','e_amount',1,'orireceiveamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','收款信息.金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1418115913600782336;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1418115910320837632,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQJ9XOW1WQA","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQJ9XOW1W11","value":"F"},{"id":"2FQJ9XOW1WQB","value":"G"},{"id":"2FQJ9XOW1W12","value":"H"},{"id":"2FQJ9XOW1WQC","value":"I"}],"baseDataIds":[]},{"id":"2I7M7AIK/SAF","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M7AIK/RN7","value":"refund"},{"id":"2I7M7AIK/SAG","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQJ9XOW1WQA\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQJ9XOW1W11\",\"value\":\"F\"},{\"id\":\"2FQJ9XOW1WQB\",\"value\":\"G\"},{\"id\":\"2FQJ9XOW1W12\",\"value\":\"H\"},{\"id\":\"2FQJ9XOW1WQC\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7M7AIK/SAF\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7M7AIK/RN7\",\"value\":\"refund\"},{\"id\":\"2I7M7AIK/SAG\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1418115913600782336,' ',NULL,'分录.金额','EntrySum','e_amount',1,'orireceiveamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','收款信息.收款金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1423205415134581760;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1423205415092638720,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FW+OEK2FJR2","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FW+OEK2FJ1U","value":"F"},{"id":"2FW+OEK2FJR3","value":"G"},{"id":"2FW+OEK2FJ1V","value":"H"},{"id":"2FW+OEK2FJR4","value":"I"}],"baseDataIds":[]},{"id":"2I7MAI+SAB70","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7MAI+SAAIT","value":"refund"},{"id":"2I7MAI+SAB71","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FW+OEK2FJR2\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FW+OEK2FJ1U\",\"value\":\"F\"},{\"id\":\"2FW+OEK2FJR3\",\"value\":\"G\"},{\"id\":\"2FW+OEK2FJ1V\",\"value\":\"H\"},{\"id\":\"2FW+OEK2FJR4\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7MAI+SAB70\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7MAI+SAAIT\",\"value\":\"refund\"},{\"id\":\"2I7MAI+SAB71\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1423205415134581760,' ',NULL,'分录.金额','EntrySum','e_amount',1,'paydetail.payamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','代发分录.发放明细.收款金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1417993845672514560;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1417993845303415808,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQJ4U8M=+O4","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQJ4U8M=++W","value":"F"},{"id":"2FQJ4U8M=+O5","value":"G"},{"id":"2FQJ4U8M=++X","value":"H"},{"id":"2FQJ4U8M=+O6","value":"I"}],"baseDataIds":[]},{"id":"2I7M27YJE3N7","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M27YJE4AH","value":"refund"},{"id":"2I7M27YJE3N8","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQJ4U8M=+O4\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQJ4U8M=++W\",\"value\":\"F\"},{\"id\":\"2FQJ4U8M=+O5\",\"value\":\"G\"},{\"id\":\"2FQJ4U8M=++X\",\"value\":\"H\"},{\"id\":\"2FQJ4U8M=+O6\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7M27YJE3N7\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7M27YJE4AH\",\"value\":\"refund\"},{\"id\":\"2I7M27YJE3N8\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1417993845672514560,' ',NULL,'分录.金额','EntrySum','e_amount',1,'orireceiveamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','收款信息.收款金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1418117461785497600;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1418117461642891264,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQJ7CR7JEY8","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQJ7CR7JE9+","value":"F"},{"id":"2FQJ7CR7JEY9","value":"G"},{"id":"2FQJ7CR7JE9/","value":"H"},{"id":"2FQJ7CR7JEY=","value":"I"}],"baseDataIds":[]},{"id":"2I7M4Z5T7H30","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2I7M4Z5T7HSA","value":"refund"},{"id":"2I7M4Z5T7H31","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQJ7CR7JEY8\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQJ7CR7JE9+\",\"value\":\"F\"},{\"id\":\"2FQJ7CR7JEY9\",\"value\":\"G\"},{\"id\":\"2FQJ7CR7JE9/\",\"value\":\"H\"},{\"id\":\"2FQJ7CR7JEY=\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2I7M4Z5T7H30\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7M4Z5T7HSA\",\"value\":\"refund\"},{\"id\":\"2I7M4Z5T7H31\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}',1418117461785497600,' ',NULL,'分录.金额','EntrySum','e_amount',1,'orireceiveamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......',' ',' ','收款信息.收款金额');

--支付防重多语言预置脚本（【供应链】简单委外订单 -> 付款处理）
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2I7TX3G=4SP/';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FNAME,FCOMMENT,FREPEATMESSAGE) VALUES (1442906656194298880,'2I7TX3G=4SP/','zh_CN','【简单委外订单】下推【付款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2I7TX3G=4SP0';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FNAME,FCOMMENT,FREPEATMESSAGE) VALUES (1442906656194298880,'2I7TX3G=4SP0','zh_TW','【簡單委外訂單】下推【付款處理】出現超額，請檢查',' ',' ',' ');

DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1442906656278184960;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCAMTFIELDNAME,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION) VALUES (1442906656194298880,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2I7TWZZ4K2Q3","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2I7TWZZ4I/YB","value":"F"},{"id":"2I7TWZZ4K2Q4","value":"G"},{"id":"2I7TWZZ4I/YC","value":"H"},{"id":"2I7TWZZ4K2Q5","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2I7TWZZ4K2Q3\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2I7TWZZ4I/YB\",\"value\":\"F\"},{\"id\":\"2I7TWZZ4K2Q4\",\"value\":\"G\"},{\"id\":\"2I7TWZZ4I/YC\",\"value\":\"H\"},{\"id\":\"2I7TWZZ4K2Q5\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}',1442906656278184960,' ','付款计划.付款金额',' ',' ','分录.应付金额','EntrySum','e_payableamt',1,'payamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ');

