/*  creator：沈定洁
请注意：若修改配置时有删除分录行，请自行添加删除旧行语句，本脚本不会生成。
请注意数据库属于资金库：dbkey="tmc"示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript>
*********************************************************************
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1798058248730304512;
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',1798058248730304512,'{"filterRow":[{"id":"3MVAEG3VOBZI","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3MVAEG3VOAM/","value":"G"}],"baseDataIds":[],"lock":false}],"forList":false}',' ','0',',save,submit,','【售后租回回款】下推【收款处理】出现超额，请检查','1','【售后租回回款】下推【收款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1798058248730304512,'cas_recbill',' ','C','1','fl_receiptbill -> cas_recbill',' ',1798055721435650048,',save,submit,',' ','1','1','1','fl_receiptbill');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3MVAFP9S8FH+';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1798058248730304512,'3MVAFP9S8FH+','zh_CN','【售后租回回款】下推【收款处理】出现超额，请检查',' ','【售后租回回款】下推【收款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 2022569823464099840;
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','Head',' ',1,'drawamount',' ',' ','单据头.本次回款金额',' ',1798058248730304512,' ','0',2022569823464099840,'0',' ',' ',' ','[{"F":"actrecamt","FN":"单据头.收款金额","CR":"+"},{"F":"fee","FN":"单据头.手续费","CR":"+"}]',' ',' ','0','单据头.收款金额+单据头.手续费');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415249209132634112;
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',1415249209132634112,'{"filterRow":[{"id":"2FQIMEP1UTOK","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"4BEZRQ1BLCF2","value":"G"}],"baseDataIds":[],"lock":false}],"forList":false}',' ','0',',save,submit,','【福费廷】下推【收款处理】出现超额，请检查','1','【福费廷】下推【收款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1415249209132634112,'cas_recbill','sourcebillid','C','1','lc_forfaiting -> cas_recbill',' ',1415247731982652416,',save,submit,',' ','1','1','1','lc_forfaiting');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415237944045747200;
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',1415237944045747200,'{"filterRow":[],"forList":false}',' ','0',' ','【交单处理】下推【收款处理】出现超额，请检查','1',' ',',submit,save,','LargerOrEqual',1415237944045747200,'cas_recbill',' ','C','1','lc_present -> cas_recbill',' ',1415237417660595200,',save,submit,',' ','1','1','0','lc_present');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU93OPUT5CB';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415237944045747200,'2EU93OPUT5CB','zh_CN','【交单处理】下推【收款处理】出现超额，请检查',' ',' ',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUA7S0I2IFC';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415249209132634112,'2EUA7S0I2IFC','zh_CN','【福费廷】下推【收款处理】出现超额，请检查',' ','【福费廷】下推【收款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 2022578831210145792;
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','Head',' ',1,'recnetamount',' ',' ','单据头.融资到款净额',' ',1415249209132634112,' ','0',2022578831210145792,'0',' ',' ',' ','[{"F":"actrecamt","FN":"单据头.收款金额","CR":"+"},{"F":"fee","FN":"单据头.手续费","CR":"+"}]',' ',' ','0','单据头.收款金额+单据头.手续费');
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415237944523897856;
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',NULL,NULL,'1','Head',' ',1,'arrivalamount','单据状态 不在……中 (已退单)',' ','单据头.交单金额',' ',1415237944045747200,'{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQIL3ZNIVK9","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQIL3ZNIW8I","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQIL3ZNIVK9\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQIL3ZNIW8I\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"}}','0',1415237944523897856,'0',' ',' ',' ','[{"F":"actrecamt","FN":"单据头.收款金额","CR":"+"},{"F":"fee","FN":"单据头.手续费","CR":"+"}]',' ',' ','0','单据头.收款金额+单据头.手续费');

