/*  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 = 1696238607628618752;
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',1696238607628618752,'{"filterRow":[],"forList":false}',' ','0',' ','【交易生命周期管理】下推【付款处理】出现超额，请检查','1',' ',',beforecommitbe,submit,save,','LargerOrEqual',1696238607628618752,'cas_paybill','sourcebillid','C','1','tm_businessbill -> cas_paybill',' ',1415331721074721792,',save,submit,beforecommitbe,',' ','1','1','0','tm_businessbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABHWQ06Z=W5';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696238607628618752,'3ABHWQ06Z=W5','zh_CN','【交易生命周期管理】下推【付款处理】出现超额，请检查',' ',' ',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3ABHWQ06Z=W6';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1696238607628618752,'3ABHWQ06Z=W6','zh_TW','【交易生命周期管理】下推【付款處理】出現超額，請檢查',' ',' ',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696279928963713024;
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,'0','Head','actpayamt',1,'paybizamt2',' ',' ','单据头.第二行交割金额（支付防超额用）',' ',1696238607628618752,' ','0',1696279928963713024,'0',' ','( 交易号.产品类型.编码 等于 01FOREXSPOT   and    生命......','单据头.付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696295859467175936;
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,'0','Head','actpayamt',2,'paybizamt1',' ',' ','单据头.第一行交割金额（支付防超额用）',' ',1696238607628618752,' ','0',1696295859467175936,'0',' ','( 交易号.产品类型.编码 在……中 (''01FOREXSPOT'')   and......','单据头.付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696311154801925120;
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,'0','Head','actpayamt',3,'plpayamt',' ',' ','单据头.损益付款金额（支付防超额用）',' ',1696238607628618752,' ','0',1696311154801925120,'0',' ','( 交易号.产品类型.编码 等于 01FOREXSPOT   and    生命......','单据头.付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696314856929515520;
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,'0','Head','actpayamt',4,'abssettleamt',' ',' ','单据头.ABS（结算金额）（支付防超额用）',' ',1696238607628618752,' ','0',1696314856929515520,'0',' ','( 交易号.产品类型.编码 等于 04FOREXOPTION   and   (......','单据头.付款金额',NULL,' ',' ','0',' '); 




