/*  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 = 1771960435206472704;
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',1771960435206472704,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','【互换交易】下推【外币兑换单】出现超额，请检查','1','【互换交易】下推【外币兑换单】出现重复，请检查',',submit,save,','LargerOrEqual',1771960435206472704,'cas_exchangebill',' ','C','1','tm_rateswap -> cas_exchangebill',' ',1771952814139192320,',save,submit,',' ','1','1','1','tm_rateswap'); 
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1773985598118736896;
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',1773985598118736896,'{"filterRow":[],"forList":false}',' ','0',',save,submit,','【】下推【】出现超额，请检查','1','【交易生命周期】下推【外币兑换单】出现重复，请检查',',submit,save,','LargerOrEqual',1773985598118736896,'cas_exchangebill',' ','C','1','tm_businessbill -> cas_exchangebill',' ',1771953133460079616,' ',' ','0','1','1','tm_businessbill'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3JN=6CQ0Q/GT';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1771960435206472704,'3JN=6CQ0Q/GT','zh_CN','【互换交易】下推【外币兑换单】出现超额，请检查',' ','【互换交易】下推【外币兑换单】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3JN=6CQ0Q/GU';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1771960435206472704,'3JN=6CQ0Q/GU','zh_TW','【互換交易】下推【外幣兌換單】出現超額，請檢查',' ','【互換交易】下推【外幣兌換單】出現重複，請檢查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3JX+KPILO+NT';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1773985598118736896,'3JX+KPILO+NT','zh_CN','【】下推【】出现超额，请检查',' ','【交易生命周期】下推【外币兑换单】出现重复，请检查',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3JX+KPILO+NU';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1773985598118736896,'3JX+KPILO+NU','zh_TW',' ',' ','【交易生命周期】下推【外幣兌換單】出現重複，請檢查',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1773376841894109184;
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','buyamount',1,'initexamount',' ',' ','单据头.期初本金交换金额',' ',1771960435206472704,' ','0',1773376841894109184,'1',' ',' ','单据头.买入金额',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1773376841894109185;
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','sellamount',2,'recinitexamount',' ',' ','单据头.期初本金交换金额',' ',1771960435206472704,' ','0',1773376841894109185,'1',' ',' ','单据头.卖出金额',' ',' ',' ','0',' '); 




