--支付防重预置脚本（建筑项目云）
DELETE FROM t_fcs_checkctrl WHERE FID = 1424606424004058112;
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',1424606424004058112,'{"filterRow":[],"forList":false}',' ','0',' ','【付款申请】下推生成的【付款处理】出现超额，请检查','1',' ',',submit,save,','LargerOrEqual',1424606424004058112,'cas_paybill',' ','C','1','recon_payreqbill -> cas_paybill',' ',1424603548255017984,',save,submit,',' ','1','1','0','recon_payreqbill');
DELETE FROM t_fcs_checkctrl WHERE FID = 1424679296982611968;
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',1424679296982611968,'{"filterRow":[],"forList":false}',' ','0',' ','已下推金额大于【付款申请单】应付金额，请检查','1',' ',',submit,save,','LargerOrEqual',1424679296982611968,'cas_paybill',' ','C','1','ec_paymentapply -> cas_paybill',' ',1424676970251189248,',save,submit,',' ','1','1','0','ec_paymentapply');
DELETE FROM t_fcs_checkctrl WHERE FID = 1424682298770488320;
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',1424682298770488320,'{"filterRow":[{"id":"2G+Q7ZCCDYGA","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2G+Q7ZCCDXT1","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','已下推金额大于【请款单】应收金额，请检查','1','【请款单】下推生成的【收款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1424682298770488320,'cas_recbill',' ','C','1','ec_incomeapply -> cas_recbill',' ',1424681307421571072,',save,submit,',' ','1','1','0','ec_incomeapply');
DELETE FROM t_fcs_checkctrl WHERE FID = 1424673891061627904;
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',1424673891061627904,'{"filterRow":[],"forList":false}',' ','0',' ','【付款申请】下推生成的【付款处理】出现超额，请检查','1',' ',',submit,save,','LargerOrEqual',1424673891061627904,'cas_paybill',' ','C','1','npecon_payreqbill -> cas_paybill',' ',1424608336178862080,',submit,save,',' ','1','1','0','npecon_payreqbill');
DELETE FROM t_fcs_checkctrl WHERE FID = 1427428857853537280;
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',1427428857853537280,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','已下推金额大于【付款申请单】应付金额，请检查','1','【付款申请单】下推【财务应付单】出现重复，请检查',',submit,save,','LargerOrEqual',1427428857853537280,'ap_finapbill',' ','C','1','ec_paymentapply -> ap_finapbill',' ',1427424071674522624,',save,submit,',' ','1','1','1','ec_paymentapply');
DELETE FROM t_fcs_checkctrl WHERE FID = 1427433239441598464;
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',1427433239441598464,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','已下推金额大于【请款单】应收金额，请检查','1','【请款单】下推【财务应收单】出现重复，请检查',',submit,save,','LargerOrEqual',1427433239441598464,'ar_finarbill',' ','C','1','ec_incomeapply -> ar_finarbill',' ',1427431249605060608,',save,submit,',' ','1','1','1','ec_incomeapply');
DELETE FROM t_fcs_checkctrl WHERE FID = 1457818249826690048;
INSERT INTO t_fcs_checkctrl(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FSRCENTITYID,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT) VALUES ('0','0',1457818249826690048,'{"filterRow":[],"forList":false}',' ','0',' ','【付款申请（劳务）】下推【代发处理】出现超额，请检查','ecpf_laborpaymentapply','1',' ',',submit,save,','LargerOrEqual',1457818249826690048,'cas_agentpaybill',' ','C','1','ecpf_laborpaymentapply -> cas_agentpaybill',' ',1457816405255675904,',save,submit,',' ','1','1','0');


--支付防重多语言预置脚本（建筑项目云）
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+4KMSCVQPN';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424606424004058112,'2G+4KMSCVQPN','zh_CN','【付款申请】下推生成的【付款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+4KMSCVQPO';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424606424004058112,'2G+4KMSCVQPO','zh_TW','【付款申請】下推生成的【付款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+G69D75I=6';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424673891061627904,'2G+G69D75I=6','zh_CN','【付款申请】下推生成的【付款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+G69D75I=7';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424673891061627904,'2G+G69D75I=7','zh_TW','【付款申請】下推生成的【付款處理】出現超額，請檢查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+H6NPN88LY';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424679296982611968,'2G+H6NPN88LY','zh_CN','已下推金额大于【付款申请单】应付金额，请检查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+H6NPN88LZ';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424679296982611968,'2G+H6NPN88LZ','zh_TW','已下推金額大於【付款申請單】應付金額，請檢查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+HRISW0WZC';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424682298770488320,'2G+HRISW0WZC','zh_CN','已下推金额大于【请款单】应收金额，请检查',' ','【请款单】下推生成的【收款处理】出现重复，请检查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2G+HRISW0WZD';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1424682298770488320,'2G+HRISW0WZD','zh_TW','已下推金額大於【請款單】應收金額，請檢查',' ','【請款單】下推生成的【收款處理】出現重複，請檢查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2GANYNV8IBQ9';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1427428857853537280,'2GANYNV8IBQ9','zh_CN','已下推金额大于【付款申请单】应付金额，请检查',' ','【付款申请单】下推【财务应付单】出现重复，请检查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2GANYNV8IBQ=';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1427428857853537280,'2GANYNV8IBQ=','zh_TW','已下推金額大於【付款申請單】應付金額，請檢查',' ','【付款申請單】下推【財務應付單】出現重複，請檢查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2GAORL0Y801E';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1427433239441598464,'2GAORL0Y801E','zh_CN','已下推金额大于【请款单】应收金额，请检查',' ','【请款单】下推【财务应收单】出现重复，请检查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2GAORL0Y801F';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1427433239441598464,'2GAORL0Y801F','zh_TW','已下推金額大於【請款單】應收金額，請檢查',' ','【請款單】下推【財務應收單】出現重複，請檢查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2K191N29ME6S';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FNAME,FCOMMENT,FREPEATMESSAGE) VALUES (1457818249826690048,'2K191N29ME6S','zh_CN','【付款申请（劳务）】下推【代发处理】出现超额，请检查',' ',' ',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2K191N29ME6T';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FNAME,FCOMMENT,FREPEATMESSAGE) VALUES (1457818249826690048,'2K191N29ME6T','zh_TW','【付款申請（勞務）】下推【代發處理】出現超額，請檢查',' ',' ',' ');



--防超额单据体amtctrl预置脚本（建筑项目云）
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1424606424079555584;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1424606424004058112,'Head','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2G+4K3Q9P3Y1","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2G+4K3Q9P38T","value":"F"},{"id":"2G+4K3Q9P3Y2","value":"G"},{"id":"2G+4K3Q9P38U","value":"H"},{"id":"2G+4K3Q9P3Y3","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2G+4K3Q9P3Y1\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2G+4K3Q9P38T\",\"value\":\"F\"},{\"id\":\"2G+4K3Q9P3Y2\",\"value\":\"G\"},{\"id\":\"2G+4K3Q9P38U\",\"value\":\"H\"},{\"id\":\"2G+4K3Q9P3Y3\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}}',1424606424079555584,' ',NULL,' ','单据头.付款金额','Head','actpayamt',1,'curactualoriamt','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ','单据头.本期实际申请（原币）');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1424673891103570944;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1424673891061627904,'Head','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2G+G64YTM6P0","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2G+G64YTM6/S","value":"F"},{"id":"2G+G64YTM6P1","value":"G"},{"id":"2G+G64YTM6/T","value":"H"},{"id":"2G+G64YTM6P2","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2G+G64YTM6P0\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2G+G64YTM6/S\",\"value\":\"F\"},{\"id\":\"2G+G64YTM6P1\",\"value\":\"G\"},{\"id\":\"2G+G64YTM6/T\",\"value\":\"H\"},{\"id\":\"2G+G64YTM6P2\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}}',1424673891103570944,' ',NULL,' ','单据头.付款金额','Head','actpayamt',1,'curactualamt','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ','单据头.本期实际申请（D=A-B）');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1424727550126487552;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1424682298770488320,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2G+Q5OYN12/9","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2G+Q5OYN11B/","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2G+Q5OYN12/9\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2G+Q5OYN11B/\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"}}',1424727550126487552,' ',NULL,' ','收款明细.实收金额','EntrySingle','e_actamt',1,'applyoftaxamount','单据状态 不在……中 (已退单)',' ','合同请款分录.本次应收金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1424679297016166400;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1424679296982611968,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2G+H6JQUWY6U","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2G+H6JQUWYW2","value":"F"},{"id":"2G+H6JQUWY6V","value":"G"},{"id":"2G+H6JQUWYW3","value":"H"},{"id":"2G+H6JQUWY6W","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2G+H6JQUWY6U\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2G+H6JQUWYW2\",\"value\":\"F\"},{\"id\":\"2G+H6JQUWY6V\",\"value\":\"G\"},{\"id\":\"2G+H6JQUWYW3\",\"value\":\"H\"},{\"id\":\"2G+H6JQUWY6W\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}}',1424679297016166400,' ',NULL,' ','分录.实付金额','EntrySum','e_actamt',1,'applyoftaxamount','单据状态 不在……中 (银行退票,已退单,已作废,退款)',' ','单据体.本次应付金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1427402770993932288;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1424679296982611968,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (已退单,银行退票,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GAJ1ELLBFAO","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GAJ1ELLBG+Y","value":"G"},{"id":"2GAJ1ELLBFAP","value":"F"},{"id":"2GAJ1ELLBG+Z","value":"H"},{"id":"2GAJ1ELLBFAQ","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GAJ1ELLBFAO\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GAJ1ELLBG+Y\",\"value\":\"G\"},{\"id\":\"2GAJ1ELLBFAP\",\"value\":\"F\"},{\"id\":\"2GAJ1ELLBG+Z\",\"value\":\"H\"},{\"id\":\"2GAJ1ELLBFAQ\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单,银行退票,已作废,退款)"},"exprDesc":"单据状态 不在……中 (已退单,银行退票,已作废,退款)"}',1427402770993932288,' ',' ',' ','分录.实付金额','EntrySingle','e_actamt',2,'applyoftaxamount','单据状态 不在……中 (已退单,银行退票,已作废,退款)',' ','单据体.本次应付金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1427428857970977792;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1427428857853537280,'EntrySingle',' ',1427428857970977792,' ',' ',' ','明细.应付金额','EntrySingle','e_pricetaxtotal',1,'applyoftaxamount',' ',' ','单据体.本次应付金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1427433239500318720;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1427433239441598464,'EntrySingle',' ',1427433239500318720,' ',' ',' ','明细.应收金额','EntrySingle','e_recamount',1,'applyoftaxamount',' ',' ','合同请款分录.本次应收金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1427514712714668032;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1427428857853537280,'EntrySingle',' ',1427514712714668032,' ',' ',' ','明细.应付金额','EntrySum','e_pricetaxtotal',2,'applyoftaxamount',' ',' ','单据体.本次应付金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1427558461964551168;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1424682298770488320,'EntrySingle','{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GB=22ZDJNMJ","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GB=22ZDJMZ=","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GB=22ZDJNMJ\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GB=22ZDJMZ=\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"}}',1427558461964551168,' ',' ',' ','收款明细.实收金额','EntrySum','e_actamt',2,'applyoftaxamount','单据状态 不在……中 (已退单)',' ','合同请款分录.本次应收金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1427576430522269696;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1427433239441598464,'EntrySingle',' ',1427576430522269696,' ',' ',' ','明细.应收金额','EntrySum','e_recamount',2,'applyoftaxamount',' ',' ','合同请款分录.本次应收金额⑭');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1457818250002850816;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1457818249826690048,'EntrySingle','EntrySum',' ',1457818250002850816,'e_amount',1,'laborapplyoftax',' ','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......','劳务人员付款分录.本次申请金额','分录.金额');


--防超额子单据体subamt预置脚本（建筑项目云）
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1424725839462823936;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ',' ',1424725839462823936,' ','ap_finapbill',1424679297016166400,1,'e_pricetaxtotal','明细.应付金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1424727550126488576;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ',' ',1424727550126488576,' ','ar_finarbill',1424727550126487552,1,'e_recamount','明细.应收金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1424729669030149120;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ',' ',1424729669030149120,' ','recon_payregister',1424673891103570944,1,'totalpayamt','单据头.实付含税金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1424723277179288576;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ',' ',1424723277179288576,' ','recon_payregister',1424606424079555584,1,'totalpayamt','单据头.实付含税金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1427428857970976770;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GANYF11UWCP","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GANYF15G9WZ","value":"F"},{"id":"2GANYF15G=K7","value":"G"},{"id":"2GANYF15G9X+","value":"H"},{"id":"2GANYF15G=K8","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GANYF11UWCP\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GANYF15G9WZ\",\"value\":\"F\"},{\"id\":\"2GANYF15G=K7\",\"value\":\"G\"},{\"id\":\"2GANYF15G9X+\",\"value\":\"H\"},{\"id\":\"2GANYF15G=K8\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}',1427428857970976770,'单据状态 不在……中 (银行退票,已退单,已作废,退款)','cas_paybill',1427428857970977792,1,'e_actamt','分录.实付金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1427433239500319746;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ','{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GAOR1GFZGE9","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GAOR1GFZFR/","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GAOR1GFZGE9\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GAOR1GFZFR/\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"},"exprDesc":"单据状态 不在……中 (已退单)"}',1427433239500319746,'单据状态 不在……中 (已退单)','cas_recbill',1427433239500318720,1,'e_actamt','收款明细.实收金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1427512915656731648;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ',' ',1427512915656731648,' ','ap_finapbill',1427402770993932288,1,'e_pricetaxtotal','明细.应付金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1427514712714669056;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GB2+6FD185Y","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GB2+6FD18V6","value":"F"},{"id":"2GB2+6FD185Z","value":"G"},{"id":"2GB2+6FD18V7","value":"H"},{"id":"2GB2+6FD186+","value":"I"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GB2+6FD185Y\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GB2+6FD18V6\",\"value\":\"F\"},{\"id\":\"2GB2+6FD185Z\",\"value\":\"G\"},{\"id\":\"2GB2+6FD18V7\",\"value\":\"H\"},{\"id\":\"2GB2+6FD186+\",\"value\":\"I\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"},"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)"}',1427514712714669056,'单据状态 不在……中 (银行退票,已退单,已作废,退款)','cas_paybill',1427514712714668032,1,'e_actamt','分录.实付金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1427558461964550144;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ',' ',1427558461964550144,' ','ar_finarbill',1427558461964551168,1,'e_recamount','明细.应收金额');
DELETE FROM t_fcs_checkctrl_subamt WHERE FDETAILID = 1427576430522270720;
INSERT INTO t_fcs_checkctrl_subamt(FOTHERCONDITION,FOTHERCONDITION_TAG,FDETAILID,FOTHERCONDITIONDESC,FOTHERTARGETENTITY,FENTRYID,FSEQ,FOTHERTARGETAMTFIELD,FOTHERTARGETAMTFIELDNAME) VALUES (' ','{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GBCHY=E9LW+","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2GBCHY=E9L6Q","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GBCHY=E9LW+\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GBCHY=E9L6Q\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"}}',1427576430522270720,'单据状态 不在……中 (已退单)','cas_recbill',1427576430522269696,1,'e_actamt','收款明细.实收金额');
