-- 预置 任务调度方案
DELETE FROM t_fcs_scheduleprop WHERE FID = 1858779177159859200;
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 (1858779177159859200,0,'3UA80TQTVIQT',NULL,NULL,1,'am_acctbank_schedule',1858779177159859200,'A',0,'FCS_0015_TS_S','查询余额对账单（按银行账号对账）',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1894992383808948224;
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 (1894992383808948224,0,'3YRQA+D+AU=R',NULL,NULL,1,'bei_elecbalancestate_acc',1894992383808948224,'A',0,'FCS_0016_TS_S','同步银行接收状态（按银行账号对账）',{ts'2018-08-08  00:00:00'},1,'0','/LSWHQ7US+Q6',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1894993837672155136;
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 (1894993837672155136,0,'3YRQITWBWOJM',NULL,NULL,1,'am_acctbank_schedule',1894993837672155136,'A',0,'FCS_0017_TS_S','下载电子对账单',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855973353047994368;
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 (1855973353047994368,0,'3TZSP4RNMAEO',NULL,NULL,1,'am_acctbank_schedule',1855973353047994368,'A',0,'FCS_0008_TS_S','离线明细自动计算历史余额',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1857921540935490560;
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 (1857921540935490560,0,'3U73QKSLF=A+',NULL,NULL,1,'bei_bankagentpay',1857921540935490560,'A',0,'FCS_0011_TS_S','银行代发单同步状态',{ts'2018-08-08  00:00:00'},1,'0','/LSWHQ7US+Q6',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1857932842395257856;
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 (1857932842395257856,0,'3U75TM3RCI42',NULL,NULL,1,'bei_bankpaybill',1857932842395257856,'A',0,'FCS_0012_TS_S','银行付款单同步状态',{ts'2018-08-08  00:00:00'},1,'0','/LSWHQ7US+Q6',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855971079223396352;
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 (1855971079223396352,0,'3TZS=7O0123=',NULL,NULL,1,'am_acctbank_schedule',1855971079223396352,'A',0,'FCS_0003_TS_S','回单匹配完整性校验',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855971580920875008;
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 (1855971580920875008,0,'3TZSC0NINNQ1',NULL,NULL,1,'am_acctbank_schedule',1855971580920875008,'A',0,'FCS_0004_TS_S','下载历史交易余额',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855971912203907072;
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 (1855971912203907072,0,'3TZSEMCBWXPD',NULL,NULL,1,'am_acctbank_schedule',1855971912203907072,'A',0,'FCS_0005_TS_S','下载历史交易明细',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855972264995080192;
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 (1855972264995080192,0,'3TZSH4+ZSIW7',NULL,NULL,1,'am_acctbank_schedule',1855972264995080192,'A',0,'FCS_0006_TS_S','流水余额完整性校验',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855972643715690496;
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 (1855972643715690496,0,'3TZSJU315KP5',NULL,NULL,1,'am_acctbank_schedule',1855972643715690496,'A',0,'FCS_0007_TS_S','流水余额完整性缺失补偿',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855973676000888832;
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 (1855973676000888832,0,'3TZSRA=QY+PA',NULL,NULL,1,'am_acctbank_schedule',1855973676000888832,'A',0,'FCS_0009_TS_S','自动下载回单',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855974229749680128;
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 (1855974229749680128,0,'3TZSVKSCUURA',NULL,NULL,1,'am_acctbank_schedule',1855974229749680128,'A',0,'FCS_0010_TS_S','回单匹配交易明细',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1857933189180312576;
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 (1857933189180312576,0,'3U75WNYMSAOL',NULL,NULL,1,'bei_banktransdownbill',1857933189180312576,'A',0,'FCS_0013_TS_S','银行下拨单同步状态',{ts'2018-08-08  00:00:00'},1,'0','/LSWHQ7US+Q6',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1857933541610986496;
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 (1857933541610986496,0,'3U75YM2+=+C/',NULL,NULL,1,'bei_banktransupbill',1857933541610986496,'A',0,'FCS_0014_TS_S','银行上划单同步状态',{ts'2018-08-08  00:00:00'},1,'0','/LSWHQ7US+Q6',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855946703673503744;
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 (1855946703673503744,0,'3TZNS+I34RW9',NULL,NULL,1,'am_acctbank_schedule',1855946703673503744,'A',0,'FCS_0001_TS_S','下载当日交易余额',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);
DELETE FROM t_fcs_scheduleprop WHERE FID = 1855962338637793280;
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 (1855962338637793280,0,'3TZQMRG3G6XZ',NULL,NULL,1,'am_acctbank_schedule',1855962338637793280,'A',0,'FCS_0002_TS_S','下载当日交易明细',{ts'2018-08-08  00:00:00'},1,'0','/LSWD74E9D/Q',' ',{ts'2018-08-08  00:00:00'},' ',1,'operation',' ',0);


DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3YRQA+WW=OIH';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1894992383808948224,'3YRQA+WW=OIH','zh_CN','同步银行接收状态（按银行账号对账）');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3YRQA+WW=OII';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1894992383808948224,'3YRQA+WW=OII','zh_TW','同步銀行接收狀態（按銀行賬號對賬）');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3YRQIU=1OV3=';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1894993837672155136,'3YRQIU=1OV3=','zh_CN','下载电子对账单');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3YRQIU=1OV3A';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1894993837672155136,'3YRQIU=1OV3A','zh_TW','下載電子對賬單');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZNS8PVA++3';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855946703673503744,'3TZNS8PVA++3','zh_CN','下载当日交易余额');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZNS8PVA++4';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855946703673503744,'3TZNS8PVA++4','zh_TW','下載當日交易餘額');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZQMRUB8QDE';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855962338637793280,'3TZQMRUB8QDE','zh_CN','下载当日交易明细');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZQMRUB8QDF';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855962338637793280,'3TZQMRUB8QDF','zh_TW','下載當日交易明細');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZS=80IPV5=';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855971079223396352,'3TZS=80IPV5=','zh_CN','回单匹配完整性校验');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZS=80IPV5A';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855971079223396352,'3TZS=80IPV5A','zh_TW','回單匹配完整性校驗');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSC15EMHYT';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855971580920875008,'3TZSC15EMHYT','zh_CN','下载历史交易余额');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSC15EMHYU';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855971580920875008,'3TZSC15EMHYU','zh_TW','下載曆史交易餘額');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSEMMDHRHS';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855971912203907072,'3TZSEMMDHRHS','zh_CN','下载历史交易明细');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSEMMDHRHT';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855971912203907072,'3TZSEMMDHRHT','zh_TW','下載曆史交易明細');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSH4CUYZP9';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855972264995080192,'3TZSH4CUYZP9','zh_CN','流水余额完整性校验');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSH4CUYZP=';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855972264995080192,'3TZSH4CUYZP=','zh_TW','流水餘額完整性校驗');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSJUH=UO=9';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855972643715690496,'3TZSJUH=UO=9','zh_CN','流水余额完整性缺失补偿');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSJUH=UO==';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855972643715690496,'3TZSJUH=UO==','zh_TW','流水餘額完整性缺失補償');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSP512MD3R';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855973353047994368,'3TZSP512MD3R','zh_CN','离线明细自动计算历史余额');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSP512MD3S';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855973353047994368,'3TZSP512MD3S','zh_TW','離線明細自動計算曆史餘額');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSRALXYCYH';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855973676000888832,'3TZSRALXYCYH','zh_CN','自动下载回单');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSRALXYCYI';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855973676000888832,'3TZSRALXYCYI','zh_TW','自動下載回單');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSVL30+=Z1';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855974229749680128,'3TZSVL30+=Z1','zh_CN','回单匹配交易明细');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3TZSVL30+=Z2';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855974229749680128,'3TZSVL30+=Z2','zh_TW','回單匹配交易明細');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U73QL=7IWZ6';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857921540935490560,'3U73QL=7IWZ6','zh_CN','银行代发单同步状态');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U73QL=7IWZ7';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857921540935490560,'3U73QL=7IWZ7','zh_TW','銀行代發單同步狀態');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U75TMMCG3S=';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857932842395257856,'3U75TMMCG3S=','zh_CN','银行付款单同步状态');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U75TMMCG3SA';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857932842395257856,'3U75TMMCG3SA','zh_TW','銀行付款單同步狀態');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U75WO=OA/S0';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857933189180312576,'3U75WO=OA/S0','zh_CN','银行下拨单同步状态');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U75WO=OA/S1';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857933189180312576,'3U75WO=OA/S1','zh_TW','銀行下撥單同步狀態');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U75YMCSSPU4';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857933541610986496,'3U75YMCSSPU4','zh_CN','银行上划单同步状态');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3U75YMCSSPU5';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1857933541610986496,'3U75YMCSSPU5','zh_TW','銀行上劃單同步狀態');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3UA80U08X1+E';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1858779177159859200,'3UA80U08X1+E','zh_CN','查询余额对账单（按银行账号对账）');
DELETE FROM t_fcs_scheduleprop_l WHERE FPKID = '3UA80U08X1+F';
INSERT INTO t_fcs_scheduleprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1858779177159859200,'3UA80U08X1+F','zh_TW','查詢餘額對賬單（按銀行賬號對賬）');

DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1894993058110425088;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1894992383808948224,'syncstatus','同步银行接收状态','同步银行接收状态',1894993058110425088,1,' ',' ',' ',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1894994269928737792;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1894993837672155136,'downelecstatement','下载电子对账单','下载电子对账单',1894994269928737792,1,' ','调度周期=1;','{"/LSWD74E9D/Q-am_acctbank_schedule-downelecstatement-month":"1"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855947303257524224;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855946703673503744,'downcurrentbalance','下载当日交易余额','下载当日交易余额',1855947303257524224,1,' ',' ',' ',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855962606679109632;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855962338637793280,'downcurrentdetail','下载当日交易明细','下载当日交易明细',1855962606679109632,1,' ',' ','{"/LSWD74E9D/Q-am_acctbank_schedule-downcurrentdetail-bankaccountnumber":""}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1858779966997548032;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1858779177159859200,'queryelecbalanceacc','查询余额对账单（按银行账号）','查询余额对账单（按银行账号）',1858779966997548032,1,' ','调度周期=1;','{"/LSWD74E9D/Q-am_acctbank_schedule-queryelecbalanceacc-monthcycle":"1"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855971453539987456;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855971079223396352,'eleccheck','回单匹配完整性校验','回单匹配完整性校验',1855971453539987456,1,' ','调度周期=1;','{"/LSWD74E9D/Q-am_acctbank_schedule-eleccheck-schedule_cycle":"1"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855971841043220480;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855971580920875008,'downhistorybalance','下载历史交易余额','下载历史交易余额',1855971841043220480,1,' ','调度周期=2;','{"/LSWD74E9D/Q-am_acctbank_schedule-downhistorybalance-schedule_cycle":"2"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855972194539286528;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855971912203907072,'downhistorydetail','下载历史交易明细','下载历史交易明细',1855972194539286528,1,' ','调度周期=2;','{"/LSWD74E9D/Q-am_acctbank_schedule-downhistorydetail-schedule_cycle":"2"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855972538514032640;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855972264995080192,'checkerror','流水余额完整性校验','流水余额完整性校验',1855972538514032640,1,' ','调度周期=1;','{"/LSWD74E9D/Q-am_acctbank_schedule-checkerror-schedule_cycle":"1"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855972908384661504;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855972643715690496,'missingrepair','流水余额完整性缺失补偿','流水余额完整性缺失补偿',1855972908384661504,1,' ','缺失补偿次数=3;','{"/LSWD74E9D/Q-am_acctbank_schedule-missingrepair-try_num":"3"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855973638730303488;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855973353047994368,'detailsgenhistorybalance','离线明细自动计算历史余额','离线明细自动计算历史余额',1855973638730303488,1,' ','调度周期=2;','{"/LSWD74E9D/Q-am_acctbank_schedule-detailsgenhistorybalance-schedule_cycle":"2"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855973936274229248;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855973676000888832,'downreceipt','自动下载回单','自动下载回单',1855973936274229248,1,' ','是否下载当日回单=否;调度周期=2;','{"/LSWD74E9D/Q-am_acctbank_schedule-downreceipt-includetoday":"0","/LSWD74E9D/Q-am_acctbank_schedule-downreceipt-day":"2"}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1855974522109571072;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1855974229749680128,'receiptmatch','回单匹配交易明细','回单匹配交易明细',1855974522109571072,1,' ',' ','{"/LSWD74E9D/Q-am_acctbank_schedule-receiptmatch-bankaccountnumber":""}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1857921967974358016;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1857921540935490560,'syncstatus','同步状态','同步状态',1857921967974358016,1,' ',' ','{"/LSWHQ7US+Q6-bei_bankagentpay-syncstatus-bankaccountnumber":""}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1857933088391273472;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1857932842395257856,'syncstatus','同步状态','同步状态',1857933088391273472,1,' ',' ','{"/LSWHQ7US+Q6-bei_bankpaybill-syncstatus-bankaccountnumber":""}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1857933505976093696;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1857933189180312576,'syncstatus','同步状态','同步状态',1857933505976093696,1,' ',' ','{"/LSWHQ7US+Q6-bei_banktransdownbill-syncstatus-bankaccountnumber":""}',' ',' ');
DELETE FROM t_fcs_schetaskentry WHERE FENTRYID = 1857933773681826816;
INSERT INTO t_fcs_schetaskentry(FID,FOPERATEKEY,FOPERATENAME,FTASKNAME,FENTRYID,FSEQ,FPARAMCONTENT_TAG,FPARAMSETTING,FPARAMCONTENT,FSCHEJOBID,FSCHEAPPNAME) VALUES (1857933541610986496,'syncstatus','同步状态','同步状态',1857933773681826816,1,' ',' ','{"/LSWHQ7US+Q6-bei_banktransupbill-syncstatus-bankaccountnumber":""}',' ',' ');

DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3YRQA+WW=OIJ';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3YRQA+WW=OIJ','zh_CN','同步银行接收状态',1894993058110425088);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3YRQIU=1OV3B';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3YRQIU=1OV3B','zh_CN','下载电子对账单',1894994269928737792);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZNS8PYYD5M';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZNS8PYYD5M','zh_CN','下载当日交易余额',1855947303257524224);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZQMRUB8QDG';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZQMRUB8QDG','zh_CN','下载当日交易明细',1855962606679109632);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZS=80IPV5B';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZS=80IPV5B','zh_CN','回单匹配完整性校验',1855971453539987456);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSC15EMHYV';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSC15EMHYV','zh_CN','下载历史交易余额',1855971841043220480);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSEMMDHRHU';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSEMMDHRHU','zh_CN','下载历史交易明细',1855972194539286528);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSH4CUYZPA';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSH4CUYZPA','zh_CN','流水余额完整性校验',1855972538514032640);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSJUH=UO=A';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSJUH=UO=A','zh_CN','流水余额完整性缺失补偿',1855972908384661504);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSP512MD3T';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSP512MD3T','zh_CN','离线明细自动计算历史余额',1855973638730303488);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSRALXYCYJ';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSRALXYCYJ','zh_CN','自动下载回单',1855973936274229248);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3TZSVL30+=Z3';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3TZSVL30+=Z3','zh_CN','回单匹配交易明细',1855974522109571072);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3U73QL=7IWZ8';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3U73QL=7IWZ8','zh_CN','同步状态',1857921967974358016);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3U75TMMCG3SB';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3U75TMMCG3SB','zh_CN','同步状态',1857933088391273472);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3U75WO=OA/S2';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3U75WO=OA/S2','zh_CN','同步状态',1857933505976093696);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3U75YMCSSPU6';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3U75YMCSSPU6','zh_CN','同步状态',1857933773681826816);
DELETE FROM t_fcs_schetaskentry_l WHERE FPKID = '3UA80U08X1+G';
INSERT INTO t_fcs_schetaskentry_l(FPKID,FLOCALEID,FTASKNAME,FENTRYID) VALUES ('3UA80U08X1+G','zh_CN','查询余额对账单（按银行账号）',1858779966997548032);


update t_fcs_scheduleprop set fcreatetime = {ts'2018-08-08 18:08:08'} , fmodifytime = {ts'2018-08-08 18:08:08'}
where fid in (1855946703673503744,1858779177159859200,1855962338637793280,1894992383808948224,1894993837672155136,
1855973353047994368,1857921540935490560,1857932842395257856,1855971079223396352,1855971580920875008,1855971912203907072,
1855972264995080192,1855972643715690496,1855973676000888832,1855974229749680128,1857933189180312576,1857933541610986496);