/*  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 = 1797334081466729472;
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',1797334081466729472,'{"filterRow":[{"id":"3NBT=KYQFQ2C","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3NBT=KYQFOQV","value":"F"},{"id":"3NBT=KYQFQ2D","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,beforecommitbe,','【租金支付】下推【付款处理】出现超额，请检查','1','【租金支付】下推【付款处理】出现重复，请检查',',beforecommitbe,submit,save,','LargerOrEqual',1797334081466729472,'cas_paybill',' ','C','1','fl_rentpaybill -> cas_paybill',' ',1797331139338634240,',save,submit,beforecommitbe,',' ','1','1','1','fl_rentpaybill'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3MRV4PGTMDGE';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1797334081466729472,'3MRV4PGTMDGE','zh_TW','【租金支付】下推【付款處理】出現超額，請檢查',' ','【租金支付】下推【付款處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3MRV4PGTMDGF';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1797334081466729472,'3MRV4PGTMDGF','en_US','【】下推【】出现超额，请检查',' ','【】下推【】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3MRV4PGTMDGG';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1797334081466729472,'3MRV4PGTMDGG','zh_CN','【租金支付】下推【付款处理】出现超额，请检查',' ','【租金支付】下推【付款处理】出现重复，请检查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1797334081592558592;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1797334081466729472,'Head','{"expression":"","exprTran":"单据状态 不在……中 (已退单,银行退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3NBTACEP475T","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3NBTACEP48IA","value":"G"},{"id":"3NBTACEP475U","value":"F"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3NBTACEP475T\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3NBTACEP48IA\",\"value\":\"G\"},{\"id\":\"3NBTACEP475U\",\"value\":\"F\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单,银行退票)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单,银行退票)"}}',1797334081592558592,' ',' ',' ','单据头.付款金额','Head','actpayamt',1,'needpayamt','单据状态 不在……中 (已退单,银行退票)',' ','单据头.支付金额'); 




