/*  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 = 1415254609793961984;
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',1415254609793961984,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','【到单处理】下推【融资申请】出现超额，请检查','1','【到单处理】下推【融资申请】出现重复，请检查',',submit,save,','LargerOrEqual',1415254609793961984,'cfm_loan_apply',' ','C','1','lc_arrival -> cfm_loan_apply',' ',1415253793121031168,',save,submit,',' ','1','1','1','lc_arrival'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUB83VK/H3T';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415254609793961984,'2EUB83VK/H3T','zh_CN','【到单处理】下推【融资申请】出现超额，请检查',' ','【到单处理】下推【融资申请】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUB83VK/H3U';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415254609793961984,'2EUB83VK/H3U','zh_TW','【到單處理】下推【融資申請】出現超額，請檢查',' ','【到單處理】下推【融資申請】出現重複，請檢查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1784107447108239360;
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',' ',' ','0','Head','amount',1,'arrivalamount',' ',' ','单据头.到单金额',' ',1415254609793961984,' ','0',1784107447108239360,'0',' ',' ','单据头.借款金额',' ',' ',' ','0',' '); 


/*  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 = 1415183986354829312;
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',1415183986354829312,'{"filterRow":[{"id":"3L4H+BLA4BHD","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3L4H+BLA4C5N","value":"F"},{"id":"3L4H+BLA4BHE","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,beforecommitbe,','【企业放款处理】下推【付款处理】出现超额，请检查','1','【企业放款处理】下推【付款处理】出现重复，请检查',',beforecommitbe,submit,save,','LargerOrEqual',1415183986354829312,'cas_paybill','sourcebillid','C','1','cim_invest_loanbill -> cas_paybill',' ',1415183235364698112,',save,submit,beforecommitbe,',' ','1','1','1','cim_invest_loanbill'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU/0HH3CQ0H';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415183986354829312,'2EU/0HH3CQ0H','zh_CN','【企业放款处理】下推【付款处理】出现超额，请检查',' ','【企业放款处理】下推【付款处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EU/0HH3CQ0I';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415183986354829312,'2EU/0HH3CQ0I','zh_TW','【企業放款處理】下推【付款處理】出現超額，請檢查',' ','【企業放款處理】下推【付款處理】出現重複，請檢查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1687695002915868672;
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,'0','Head','actpayamt',1,'drawamount','单据状态 不在……中 (已退单,银行退票)',' ','单据头.放款金额',' ',1415183986354829312,'{"expression":"","exprTran":"单据状态 不在……中 (已退单,银行退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3==KJFCUCYSM","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3==KJFCUCZFW","value":"G"},{"id":"3JWALLZ31XCI","value":"F"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3==KJFCUCYSM\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3==KJFCUCZFW\",\"value\":\"G\"},{\"id\":\"3JWALLZ31XCI\",\"value\":\"F\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单,银行退票)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单,银行退票)"}}','0',1687695002915868672,'0',' ',' ','单据头.付款金额',NULL,' ',' ','0',' '); 




