/*银企互联-调度作业预制*/
/*银行代发单同步状态作业*/
DELETE FROM T_SCH_JOB WHERE FID = '0H170U/S6TVI';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0H170U/S6TVI','kd.tmc.bei.business.task.BankAgentPayBillSyncTask','0H12HL2WQGUQ',1,'BIZ','1','{}','bei_BankAgentPayBillSyncJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H170U/S4IAE';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H170U/S6TVI','0H170U/S4IAE','zh_CN','银行代发单同步状态作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H170U/S4IAF';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H170U/S6TVI','0H170U/S4IAF','zh_TW','銀行代發單同步狀態作業'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0H1JO1KI5RVD';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0H170U/S6TVI','0H1JO1KI5RVD',1,' ','bankaccountnumber'); 

/*银行付款单同步状态作业*/
DELETE FROM T_SCH_JOB WHERE FID = '0H17REAQB0V1';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0H17REAQB0V1','kd.tmc.bei.business.task.BankPayBillSyncTask','0H12L8/87/IC',1,'BIZ','1','{}','bei_BankPayBillSyncJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H17REAQDBD5';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H17REAQB0V1','0H17REAQDBD5','zh_CN','银行付款单同步状态作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H17REAQDBD6';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H17REAQB0V1','0H17REAQDBD6','zh_TW','銀行付款單同步狀態作業');
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0H4PYBF+BWP+';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0H17REAQB0V1','0H4PYBF+BWP+',1,' ','bankaccountnumber');
/*下载当日交易明细作业*/

DELETE FROM T_SCH_JOB WHERE FID = '0H4Q6W=47X9F';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0H4Q6W=47X9F','kd.tmc.bei.business.task.DownCurrentDetailTask','0H12PGNEP1GO',1,'BIZ','1','{}','bei_DownCurrentDetaiJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H4Q6W=4=6TJ';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H4Q6W=47X9F','0H4Q6W=4=6TJ','zh_CN','下载当日交易明细作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H4Q6W=4=6TK';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H4Q6W=47X9F','0H4Q6W=4=6TK','zh_TW','下載當日交易明細作業');
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0H4Q6W=47X9G';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0H4Q6W=47X9F','0H4Q6W=47X9G',1,' ','bankaccountnumber');  
/*下载历史交易明细作业*/

DELETE FROM T_SCH_JOB WHERE FID = '0H4QDBR63ATC';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0H4QDBR63ATC','kd.tmc.bei.business.task.DownHistoryDetailTask','0H12R4WW9QC0',1,'BIZ','1','{"schedule_cycle":"7"}','bei_DownHistoryDetailJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H4QDBR65MBG';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H4QDBR63ATC','0H4QDBR65MBG','zh_CN','下载历史交易明细作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0H4QDBR65MBH';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0H4QDBR63ATC','0H4QDBR65MBH','zh_TW','下載曆史交易明細作業'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0H4QDBR63ATD';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0H4QDBR63ATC','0H4QDBR63ATD',1,' ','bankaccountnumber'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0H4QDBR63ATE';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0H4QDBR63ATC','0H4QDBR63ATE',2,'7','schedule_cycle'); 
