-- 预置 按银行账号查询电子余额对账 任务调度方案
DELETE FROM t_fcs_scheduleprop WHERE FID = 1824100899857912832;
INSERT INTO t_fcs_scheduleprop(FID,FENABLERID,FSCHEPLANID,FENABLEDATE,FDISABLEDATE,FEXECUTORID,FBUSSINESS,FMASTERID,FSTATUS,FINFORECEIVERID,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPP,FBIZFILTERCONFIG,FMODIFYTIME,FBIZFILTERCONFIG_TAG,FCREATORID,FTASKTYPE,FBIZFILTER,FDISABLERID) VALUES (1824100899857912832,0,'3Q12SM0DWPD4',NULL,NULL,1,' ',1824100899857912832,'C',1,'bei_queryElecBalanceAccTask','按银行账号查询电子余额对账',{ts'2023-11-22  00:00:00'},1,'1',' ',' ',{ts'2023-11-23  00:00:00'},' ',1,'job',' ',0);

DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3Q12SMVZ//TM';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1824100899857912832,'3Q12SMVZ//TM','zh_CN','按银行账号查询电子余额对账');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3Q12SMVZ//TN';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1824100899857912832,'3Q12SMVZ//TN','zh_TW','按銀行賬號查詢電子餘額對賬');

DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1824102901489067008;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1824100899857912832,' ',' ','按银行账号查询电子余额对账',1824102901489067008,1,' ','调度周期=1','{"---monthcycle":"1","---bankaccountnumber":""}','3Q0QMWW6SJP1','银企互联');

DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3Q12SMVZ//TO';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3Q12SMVZ//TO','zh_CN','按银行账号查询电子余额对账',1824102901489067008);


-- 按银行账号查询电子余额对账-参数
DELETE FROM t_fcs_scheduleparam WHERE FID = 1824098447431586816;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1824098447431586816,' ',1824098447431586816,'C','3Q0QMWW6SJP1','QueryElecBalanceAccTask','按银行账号查询电子余额对账',' ',{ts'2023-11-22  00:00:00'},'1',' ',{ts'2023-11-22  00:00:00'},'job');

DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3Q11Z671XUVM';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1824098447431586816,'3Q11Z671XUVM','zh_CN',' ','按银行账号查询电子余额对账');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3Q11Z671XUVN';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1824098447431586816,'3Q11Z671XUVN','zh_TW',' ','按銀行賬號查詢電子餘額對賬');

DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1824098447951680512;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1824098447431586816,'0','text',' ',1824098447951680512,1,'bankaccountnumber');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1824098447951680513;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1824098447431586816,'0','combo','1',1824098447951680513,2,'monthcycle');

DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3Q11Z675J914';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3Q11Z675J914','zh_CN','过滤银行账号，多个银行账号以英文逗号隔开',' ',1824098447951680512,'银行账号');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3Q11Z675J915';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3Q11Z675J915','zh_TW','過濾銀行賬號，多個銀行賬號以英文逗號隔開',' ',1824098447951680512,'銀行賬號');

DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3Q11Z675J916';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3Q11Z675J916','zh_CN','根据调度周期查询上个月往前调度周期个月的电子余额对账单（最大不超过6）','{"1":1,"2":2,"3":3,"4":4,"5":5,"6":6}',1824098447951680513,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3Q11Z675J917';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3Q11Z675J917','zh_TW','根據調度周期查詢上個月往前調度周期個月的電子餘額對賬單（最大不超過6）','{"1":1,"2":2,"3":3,"4":4,"5":5,"6":6}',1824098447951680513,'調度周期');
