/*银企互联-调度作业预制*/

/*银行收付生成付款单*/
DELETE FROM T_SCH_JOB WHERE FID = '0KWTORM7UWWH';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0KWTORM7UWWH','kd.tmc.bei.business.task.DetailPayTask','0HLG8R3044VP',1,'BIZ','1','{}','bei_DetailPayJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWTORMAE7M+';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWTORM7UWWH','0KWTORMAE7M+','zh_CN','银行收付生成付款单'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWTORMAE7M/';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWTORM7UWWH','0KWTORMAE7M/','zh_TW','銀行收付生成付款單'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0KWTORMAGA2/';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0KWTORM7UWWH','0KWTORMAGA2/',1,' ','bankaccountnumber'); 

/*银行收付生成收款单*/
DELETE FROM T_SCH_JOB WHERE FID = '0KWU4+7MD9T6';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0KWU4+7MD9T6','kd.tmc.bei.business.task.DetailRecTask','0HLG=XYXYJLG',1,'BIZ','1','{}','bei_DetailRecJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWU4+7MFC97';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWU4+7MD9T6','0KWU4+7MFC97','zh_CN','银行收付生成收款单'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWU4+7MFC98';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWU4+7MD9T6','0KWU4+7MFC98','zh_TW','銀行收付生成收款單');
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0KWU4+7MD9T7';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0KWU4+7MD9T6','0KWU4+7MD9T7',1,' ','bankaccountnumber'); 

/*下载银行对账单*/
DELETE FROM T_SCH_JOB WHERE FID = '0KWUAY8RVB1+';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0KWUAY8RVB1+','kd.tmc.bei.business.task.BankStatementDownTask','0HLG47LT6ZE1',1,'BIZ','1','{}','bei_BankStatementDownJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUAY8RT8KZ';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUAY8RVB1+','0KWUAY8RT8KZ','zh_CN','下载银行对账单'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUAY8RT8L+';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUAY8RVB1+','0KWUAY8RT8L+','zh_TW','下載銀行對賬單'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0KWUAY8RVB1/';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0KWUAY8RVB1+','0KWUAY8RVB1/',1,' ','bankaccountnumber'); 

/*自动对账*/
DELETE FROM T_SCH_JOB WHERE FID = '0KWUF=FTWK1=';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0KWUF=FTWK1=','kd.tmc.bei.business.task.BankVCCheckTask','0HLG6ASUQL+/',1,'BIZ','1','{}','bei_BankVCCheck_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUF=FTYNIA';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUF=FTWK1=','0KWUF=FTYNIA','zh_CN','自动对账'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUF=FTYNIB';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUF=FTWK1=','0KWUF=FTYNIB','zh_TW','自動對賬');
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0KWUF=FTWK1A';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0KWUF=FTWK1=','0KWUF=FTWK1A',1,' ','bankaccountnumber'); 

/*下载电子回单*/
DELETE FROM T_SCH_JOB WHERE FID = '0KWUMJRT5P0W';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0KWUMJRT5P0W','kd.tmc.bei.business.task.ReceiptDownTask','0HLGBXRMKJ8Y',1,'BIZ','1','{}','bei_ReceiptDownJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUMJRT3LKV';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUMJRT5P0W','0KWUMJRT3LKV','zh_CN','下载电子回单'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUMJRT3LKW';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUMJRT5P0W','0KWUMJRT3LKW','zh_TW','下載電子回單'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0KWUMJRT5P0X';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0KWUMJRT5P0W','0KWUMJRT5P0X',1,' ','bankaccountnumber');

/*电子回单匹配交易明细*/
DELETE FROM T_SCH_JOB WHERE FID = '0KWUUTGPAVOG';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0KWUUTGPAVOG','kd.tmc.bei.business.task.ReceiptMatchTask','0HLGL3+MPBZE',1,'BIZ','1','{}','bei_ReceiptMatchJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUUTGPCZ4H';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUUTGPAVOG','0KWUUTGPCZ4H','zh_CN','电子回单匹配交易明细'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0KWUUTGPCZ4I';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0KWUUTGPAVOG','0KWUUTGPCZ4I','zh_TW','電子回單匹配交易明細'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0KWUUTGPAVOH';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0KWUUTGPAVOG','0KWUUTGPAVOH',1,' ','bankaccountnumber');

