/*  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 = 1415334004864861184;
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',1415334004864861184,'{"filterRow":[],"forList":false}',' ','0',',save,submit,beforecommitbe,','【结构性存款】下推【付款处理】出现超额，请检查','1','【结构性存款】下推【付款处理】出现重复，请检查',',beforecommitbe,submit,save,','LargerOrEqual',1415334004864861184,'cas_paybill',' ','C','1','tm_structdeposit -> cas_paybill',' ',1415330073937985536,',save,submit,beforecommitbe,',' ','1','1','1','tm_structdeposit'); 
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1415334583393600512;
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',1415334583393600512,'{"filterRow":[],"forList":false}',' ','0',',save,submit,beforecommitbe,','【外汇期权】下推【付款处理】出现超额，请检查','1','【外汇期权】下推【付款处理】出现重复，请检查',',beforecommitbe,submit,save,','LargerOrEqual',1415334583393600512,'cas_paybill',' ','C','1','tm_forex_options -> cas_paybill',' ',1415331300134372352,',save,submit,beforecommitbe,',' ','1','1','1','tm_forex_options'); 
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 WHERE FID = 1415333400247550976;
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',1415333400247550976,'{"filterRow":[],"forList":false}',' ','0',',save,submit,beforecommitbe,','【互换交易】下推【付款处理】出现超额，请检查','1','【互换交易】下推【付款处理】出现重复，请检查',',beforecommitbe,submit,save,','LargerOrEqual',1415333400247550976,'cas_paybill',' ','C','1','tm_rateswap -> cas_paybill',' ',1415329807264137216,',save,submit,beforecommitbe,',' ','1','1','1','tm_rateswap'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ1OB/6YW8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334004864861184,'2EUQ1OB/6YW8','zh_CN','【结构性存款】下推【付款处理】出现超额，请检查',' ','【结构性存款】下推【付款处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ1OB/6YW9';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334004864861184,'2EUQ1OB/6YW9','zh_TW','【結構性存款】下推【付款處理】出現超額，請檢查',' ','【結構性存款】下推【付款處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUPZ9HXO3T7';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415333400247550976,'2EUPZ9HXO3T7','zh_CN','【互换交易】下推【付款处理】出现超额，请检查',' ','【互换交易】下推【付款处理】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUPZ9HXO3T8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415333400247550976,'2EUPZ9HXO3T8','zh_TW','【互換交易】下推【付款處理】出現超額，請檢查',' ','【互換交易】下推【付款處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ5WRDXKTZ';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334583393600512,'2EUQ5WRDXKTZ','zh_TW','【外彙期權】下推【付款處理】出現超額，請檢查',' ','【外彙期權】下推【付款處理】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2EUQ5WRDXKU+';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415334583393600512,'2EUQ5WRDXKU+','zh_CN','【外汇期权】下推【付款处理】出现超额，请检查',' ','【外汇期权】下推【付款处理】出现重复，请检查',' '); 
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 = 1693526546737931264;
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,'buysettleamt',' ',' ','单据头.结算金额',' ',1415334004864861184,' ','0',1693526546737931264,'0',' ',' ','单据头.付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1693539727472463872;
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,'buysettleamt',' ',' ','单据头.结算金额',' ',1415333400247550976,' ','0',1693539727472463872,'0',' ',' ','单据头.付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1693527713022877696;
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,'premium',' ',' ','单据头.期权费',' ',1415334583393600512,' ','0',1693527713022877696,'0',' ',' ','单据头.付款金额',NULL,' ',' ','0',' '); 
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 = 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,'settleamount',' ',' ','单据头.结算金额',' ',1696238607628618752,' ','0',1696314856929515520,'1',' ','( 交易号.产品类型.编码 等于 04FOREXOPTION   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,'plamt',' ',' ','单据头.损益',' ',1696238607628618752,' ','0',1696311154801925120,'1',' ','( 交易号.产品类型.编码 等于 01FOREXSPOT   and    生命......','单据头.付款金额',NULL,' ',' ','0',' '); 




