/*  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 = 1415046540732455936;
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',1415046540732455936,'{"filterRow":[{"id":"4AJO9I0PIIRR","leftBracket":"","compareType":"105","fieldName":"e_corebilltype","rightBracket":"","logic":"0","value":[{"id":"4AXNW3AQH6S2","value":"cas_paybill"}],"baseDataIds":[],"lock":false},{"id":"4AJO9I0PIIRS","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"4AXNW3AQH62U","value":"G"}],"baseDataIds":[],"lock":false}],"forList":false}',' ','0',' ','【付款处理】下推【收款处理】出现超额，请检查','1','请检查',',submit,save,','LargerOrEqual',1415046540732455936,'cas_recbill','sourcebillid','C','0','cas_paybill -> cas_recbill',' ',1415045958638558208,',save,submit,',' ','1','0','0','cas_paybill'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2ETBBY8=280L';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415046540732455936,'2ETBBY8=280L','zh_CN','【付款处理】下推【收款处理】出现超额，请检查',' ','请检查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 2017470858540509184;
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','actrecamt',1,'dpamt','收款人（公司） =  GetFieldValue(''cas_paybill'', ......',' ','单据头.异币种付款金额',' ',1415046540732455936,'{"expression":"org =  GetFieldValue(''cas_paybill'', ''org'', ''org.id'', org.id) ","exprTran":"收款人（公司） =  GetFieldValue(''cas_paybill'', ''收款人（公司）'', ''收款人（公司）.内码(org.id)'', 收款人（公司）.内码(org.id)) ","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收款人（公司） =  GetFieldValue(''cas_paybill'', ''收款人（公司）'', ''收款人（公司）.内码(org.id)'', 收款人（公司）.内码(org.id)) "},"exprDesc":"收款人（公司） =  GetFieldValue(''cas_paybill'', ''收款人（公司）'', ''收款人（公司）.内码(org.id)'', 收款人（公司）.内码(org.id)) "}','0',2017470858540509184,'0',' ',' ','单据头.收款金额',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 2017470858540509185;
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','actrecamt',2,'actpayamt','收款人（公司）  <>   GetFieldValue(''cas_paybill......',' ','单据头.付款金额',' ',1415046540732455936,'{"expression":"org  <>   GetFieldValue(''cas_paybill'', ''org'', ''org.id'', org.id) ","exprTran":"收款人（公司）  <>   GetFieldValue(''cas_paybill'', ''收款人（公司）'', ''收款人（公司）.内码(org.id)'', 收款人（公司）.内码(org.id)) ","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收款人（公司）  <>   GetFieldValue(''cas_paybill'', ''收款人（公司）'', ''收款人（公司）.内码(org.id)'', 收款人（公司）.内码(org.id)) "},"exprDesc":"收款人（公司）  <>   GetFieldValue(''cas_paybill'', ''收款人（公司）'', ''收款人（公司）.内码(org.id)'', 收款人（公司）.内码(org.id)) "}','0',2017470858540509185,'0',' ',' ','单据头.收款金额',' ',' ',' ','0',' '); 




