-- 任务调度参数 账户管理-银行账户调度相关操作参数
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741426905984679936;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741426905984679936,'am_acctbank_schedule',1741426905984679936,'C',' ','tmc_transdetail_schedule','资金交易明细下载周期','downhistorydetail',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741428629382250496;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741428629382250496,'am_acctbank_schedule',1741428629382250496,'C',' ','tmc_receipt_schedule','自动下载回单下载天数','downreceipt',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741429292317163520;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741429292317163520,'am_acctbank_schedule',1741429292317163520,'C',' ','tmc_missing_repair','流水余额完整性缺失补偿','missingrepair',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741429907227295744;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741429907227295744,'am_acctbank_schedule',1741429907227295744,'C',' ','tmc_elec_check','回单匹配完整性校验','eleccheck',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741430533915033600;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741430533915033600,'am_acctbank_schedule',1741430533915033600,'C',' ','tmc_detailgenbanlance_schedule','资金交易明细自动计算历史余额周期','detailsgenhistorybalance',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741431125228011520;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741431125228011520,'am_acctbank_schedule',1741431125228011520,'C',' ','tmc_check_error','流水余额完整性校验','checkerror',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741431754893705216;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741431754893705216,'am_acctbank_schedule',1741431754893705216,'C',' ','tmc_balance_schedule','资金交易余额下载周期','downhistorybalance',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');
DELETE FROM t_fcs_scheduleparam WHERE FID = 1741432390498533376;
INSERT INTO t_fcs_scheduleparam(FID,FBUSSINESS,FMASTERID,FSTATUS,FCLASSNAMEID,FNUMBER,FNAME,FOPERATEKEY,FCREATETIME,FENABLE,FBIZAPP,FMODIFYTIME,FTASKTYPE) VALUES (1741432390498533376,'am_acctbank_schedule',1741432390498533376,'C',' ','cas_downjournal_schedule','下载银行日记账','downloadjournal',{ts'2023-07-31  00:00:00'},'1','/LSWD74E9D/Q',{ts'2023-07-31  00:00:00'},'operation');


DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/42+RV/R/';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741426905984679936,'3FX/42+RV/R/','zh_CN','资金交易明细下载周期','资金交易明细下载周期');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/42+RV/R0';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741426905984679936,'3FX/42+RV/R0','zh_TW','資金交易明細下載周期','資金交易明細下載周期');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/FMKP93PX';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741428629382250496,'3FX/FMKP93PX','zh_CN','结束日期是前一天，实际下载天数要减一天','自动下载回单下载天数');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/FMKP93PY';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741428629382250496,'3FX/FMKP93PY','zh_TW','結束日期是前一天，實際下載天數要減一天','自動下載回單下載天數');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/KG+8KT6K';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741429292317163520,'3FX/KG+8KT6K','zh_CN',' ','流水余额完整性缺失补偿');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/KG+8KT6L';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741429292317163520,'3FX/KG+8KT6L','zh_TW',' ','流水餘額完整性缺失補償');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/OYQHWGUB';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741429907227295744,'3FX/OYQHWGUB','zh_CN',' ','回单匹配完整性校验');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/OYQHWGUC';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741429907227295744,'3FX/OYQHWGUC','zh_TW',' ','回單匹配完整性校驗');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/THUHCYA4';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741430533915033600,'3FX/THUHCYA4','zh_CN','资金交易明细自动计算历史余额周期','资金交易明细自动计算历史余额周期');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/THUHCYA5';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741430533915033600,'3FX/THUHCYA5','zh_TW','資金交易明細自動計算曆史餘額周期','資金交易明細自動計算曆史餘額周期');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/XTWDXHFC';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741431125228011520,'3FX/XTWDXHFC','zh_CN',' ','流水余额完整性校验');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX/XTWDXHFD';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741431125228011520,'3FX/XTWDXHFD','zh_TW',' ','流水餘額完整性校驗');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX00DUA/Y3P';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741431754893705216,'3FX00DUA/Y3P','zh_CN','资金交易余额下载周期','资金交易余额下载周期');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX00DUA/Y3Q';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741431754893705216,'3FX00DUA/Y3Q','zh_TW','資金交易餘額下載周期','資金交易餘額下載周期');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX050FYQX+L';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741432390498533376,'3FX050FYQX+L','zh_CN',' ','下载银行日记账');
DELETE FROM T_FCS_SCHEDULEPARAM_L WHERE FPKID = '3FX050FYQX+M';
INSERT INTO T_FCS_SCHEDULEPARAM_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1741432390498533376,'3FX050FYQX+M','zh_TW',' ','下載銀行日記賬');


DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741426906689323008;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741426905984679936,'0','int','2',1741426906689323008,1,'schedule_cycle');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741428629424193536;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741428629382250496,'1','int','2',1741428629424193536,1,'day');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741428629424193537;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741428629382250496,'1','combo','0',1741428629424193537,2,'includetoday');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741429292350717952;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741429292317163520,'0','int','3',1741429292350717952,1,'try_num');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741429907252461568;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741429907227295744,'1','text','1',1741429907252461568,1,'schedule_cycle');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741430533948588032;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741430533915033600,'1','int','2',1741430533948588032,1,'schedule_cycle');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741431125269954560;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741431125228011520,'1','text','1',1741431125269954560,1,'schedule_cycle');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741431754935648256;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741431754893705216,'0','int','2',1741431754935648256,1,'schedule_cycle');
DELETE FROM T_FCS_SCHPARAMENTRY WHERE FENTRYID = 1741432390532087808;
INSERT INTO T_FCS_SCHPARAMENTRY(FID,FREQUIRE,FPARAMTYPE,FPARAMVAL,FENTRYID,FSEQ,FPARAM) VALUES (1741432390498533376,'1','int','1',1741432390532087808,1,'schedule_cycle');


DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/42+RV/R1';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/42+RV/R1','zh_CN','查询时间周期，指查询几天范围内的交易明细',' ',1741426906689323008,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/42+RV/R2';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/42+RV/R2','zh_TW','查詢時間周期，指查詢幾天範圍內的交易明細',' ',1741426906689323008,'調度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/FMKP93PZ';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/FMKP93PZ','zh_CN','当“是否下载当日回单”=否时，下载结束日期是当前日期的前一天，参数设置为7时，表示下载当前日期的前一天往前7天的所有回单数据（包含前一天）。                                                            当“是否下载当日回单”=是时，下载结束日期是当前日期，参数设置为7时，表示下载当前日期往前7天的所有回单数据（包含当天）。',' ',1741428629424193536,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/FMKP93Q+';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/FMKP93Q+','zh_TW','當“是否下載當日回單”=否時，下載結束日期是當前日期的前一天，參數設置為7時，表示下載當前日期的前一天往前7天的所有回單數據（包含前一天）。                                                            當“是否下載當日回單”=是時，下載結束日期是當前日期，參數設置為7時，表示下載當前日期往前7天的所有回單數據（包含當天）。',' ',1741428629424193536,'調度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/FMKP93Q/';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/FMKP93Q/','zh_CN','是否下载当日回单','{"0":"否","1":"是"}',1741428629424193537,'是否下载当日回单');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/FMKP93Q0';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/FMKP93Q0','zh_TW','是否下載當日回單','{"0":"否","1":"是"}',1741428629424193537,'是否下載當日回單');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/KG+8KT6M';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/KG+8KT6M','zh_CN','缺失补偿次数',' ',1741429292350717952,'缺失补偿次数');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/KG+8KT6N';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/KG+8KT6N','zh_TW','缺失補償次數',' ',1741429292350717952,'缺失補償次數');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/OYQLHX/V';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/OYQLHX/V','zh_CN','调度周期，0为当日，1上日',' ',1741429907252461568,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/OYQLHX/W';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/OYQLHX/W','zh_TW','調度周期，0為當日，1上日',' ',1741429907252461568,'調度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/THUHCYA6';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/THUHCYA6','zh_CN','查询时间周期，指查询几天范围内的交易明细，此参数针对的是交易明细的业务日期，最大设置90天。同时，也是根据此参数乘2来查询历史余额数据',' ',1741430533948588032,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/THUHCYA7';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/THUHCYA7','zh_TW','查詢時間周期，指查詢幾天範圍內的交易明細，此參數針對的是交易明細的業務日期，最大設置90天。同時，也是根據此參數乘2來查詢曆史餘額數據',' ',1741430533948588032,'調度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/XTWDXHFE';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/XTWDXHFE','zh_CN','调度周期，0为当日，1上日',' ',1741431125269954560,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX/XTWDXHFF';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX/XTWDXHFF','zh_TW','調度周期，0為當日，1上日',' ',1741431125269954560,'調度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX00DUA/Y3R';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX00DUA/Y3R','zh_CN','查询时间周期，指查询几天范围内的交易余额',' ',1741431754935648256,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX00DUA/Y3S';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX00DUA/Y3S','zh_TW','查詢時間周期，指查詢幾天範圍內的交易餘額',' ',1741431754935648256,'調度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX050FYQX+N';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX050FYQX+N','zh_CN','查询时间周期，指查询几天范围内的银行日记账',' ',1741432390532087808,'调度周期');
DELETE FROM T_FCS_SCHPARAMENTRY_L WHERE FPKID = '3FX050FYQX+O';
INSERT INTO T_FCS_SCHPARAMENTRY_L(FPKID,FLOCALEID,FPARAMDESC,FCOMBOVAL,FENTRYID,FPARAMNAME) VALUES ('3FX050FYQX+O','zh_TW','查詢時間周期，指查詢幾天範圍內的銀行日記賬',' ',1741432390532087808,'調度周期');
