-- 新增有息负债趋势分析 轻分析报表 普通报表
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1687600182738461696;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1687600182738461696,0,'3=0DQWEUP8MT',NULL,NULL,1687600182738461696,'qing','C','tda_findebttrendqingrpt','有息负债趋势分析',{ts'2023-05-18  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-18  00:00:00'},'kd.tmc.tda.report.finance.qing.data.FinDebtTrendDataPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1687600413173523456;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1687600413173523456,0,'3=6LQKNGT+8T',NULL,NULL,1687600413173523456,'common','C','tda_findebttrendrpt','有息负债趋势分析报表',{ts'2023-05-18  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-18  00:00:00'},'kd.tmc.tda.report.finance.data.FinDebtTrendDataListPlugin',0,0,' '); 

DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3==3UNQ3SELI';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1687600182738461696,'3==3UNQ3SELI','zh_CN',' ','有息负债趋势分析');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3==3WB717F46';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1687600413173523456,'3==3WB717F46','zh_CN',' ','有息负债趋势分析报表');

-- 新增投资理财轻分析报表 普通报表
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1679027127468737536;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1679027127468737536,0,'3980P2B2LM/2',NULL,NULL,1679027127468737536,'qing','C','tda_investbalanceqingrpt','投资理财余额',{ts'2023-05-06  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-06  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestByBalanceDataPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1679045486331301888;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1679045486331301888,0,'3820T2T81KDO',NULL,NULL,1679045486331301888,'qing','C','tda_investrateqingrpt','投资理财收益率分析',{ts'2023-05-06  00:00:00'},1500700436678845440,'1',' ',' ',{ts'2023-05-06  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestRateTrendQingAnlsPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1681257893040647168;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1681257893040647168,0,'390MJ=55UV=T',NULL,NULL,1681257893040647168,'qing','C','tda_investamtsumrate','投资理财金额及收益',{ts'2023-05-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-09  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestAmtSumQingDataPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1681258411733569536;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1681258411733569536,0,'3980+ETDBP3L',NULL,NULL,1681258411733569536,'common','C','tda_investamtsumrpt','投资理财总额及收益分布汇总表',{ts'2023-05-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-09  00:00:00'},'kd.tmc.tda.report.invest.data.InvestAmtSumDataListPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1681291253100200960;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1681291253100200960,0,'38IDL=IBBSQC',NULL,NULL,1681291253100200960,'qing','C','tda_investcurrencybalance','投资理财币种余额分布',{ts'2023-05-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-09  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestCurrencyBalanceQingAnlsPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1681987103199802368;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1681987103199802368,0,'39E9QZ4P4JLU',NULL,NULL,1681987103199802368,'qing','C','tda_investamtbankqingrpt','投资理财金额机构分布',{ts'2023-05-10  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-10  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestAmtBankQingAnlsPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1682635379901107200;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1682635379901107200,0,'39NVSFHU9WPR',NULL,NULL,1682635379901107200,'qing','C','tda_investamtbytypeqrpt','投资理财金额按类型分布',{ts'2023-05-11  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-11  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestAmtByTypeQingDataPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1683422428715800576;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1683422428715800576,0,'39R8YR4SG=R7',NULL,NULL,1683422428715800576,'qing','C','tda_investbalancebytype','投资理财余额按类型分布',{ts'2023-05-12  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-12  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestBalanceByTypeQingDataPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1686351714581625856;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1686351714581625856,0,'39R5=BM44VI1',NULL,NULL,1686351714581625856,'qing','C','tda_invorgbalanceqingrpt','投资理财单位分布余额',{ts'2023-05-16  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-16  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestOrgBalanceQingAnlsPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1687599078185403392;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1687599078185403392,0,'3=0F=UCT5LKM',NULL,NULL,1687599078185403392,'qing','C','tda_investtermbalqingrpt','投资理财期限余额分布',{ts'2023-05-18  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-18  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestTermBalQingAnlsPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1692827897142150144;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1692827897142150144,0,'394R1XOJ=4DX',NULL,NULL,1692827897142150144,'common','C','tda_investraterpt','投资理财收益率分析',{ts'2023-05-25  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-25  00:00:00'},'kd.tmc.tda.report.invest.data.InvestRateTrendDataListPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1692828251258601472;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1692828251258601472,0,'39I1P9/0/3MM',NULL,NULL,1692828251258601472,'common','C','tda_investamtbankrpt','投资理财金额机构分布',{ts'2023-05-25  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-05-25  00:00:00'},'kd.tmc.tda.report.invest.data.InvestAmtBankDataListPlugin',0,0,' ');
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1683426458452019200;
INSERT INTO T_FCS_SNAPSCHEDULE(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1683426458452019200,0,'394L7/O=TW3E',NULL,NULL,1683426458452019200,'qing','C','tda_investbankbalance','投资理财银行投资余额',{ts'2023-05-12  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-05-12  00:00:00'},'kd.tmc.tda.report.invest.qing.data.InvestBankBalanceQingAnlsPlugin',0,0,' ');

DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3981+Z9=6OX9';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1679027127468737536,'3981+Z9=6OX9','zh_CN',' ','投资理财余额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3984EQKQQHKX';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1679045486331301888,'3984EQKQQHKX','zh_CN',' ','投资理财收益率分析');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39HQTI0U5KQ0';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1681257893040647168,'39HQTI0U5KQ0','zh_CN',' ','投资理财金额及收益');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39HX0L=PVX4D';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1681291253100200960,'39HX0L=PVX4D','zh_CN',' ','投资理财币种余额分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39L818T2YIAN';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1681987103199802368,'39L818T2YIAN','zh_CN',' ','投资理财金额机构分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39OB67WW3WUE';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1682635379901107200,'39OB67WW3WUE','zh_CN',' ','投资理财金额按类型分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39S38FGA29C8';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1683422428715800576,'39S38FGA29C8','zh_CN',' ','投资理财余额按类型分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3=44K2SJ55=/';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1686351714581625856,'3=44K2SJ55=/','zh_CN',' ','投资理财单位分布余额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3==3MLXPOPWO';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1687599078185403392,'3==3MLXPOPWO','zh_CN',' ','投资理财期限余额分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3=Y5LY3F/LSQ';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1692827897142150144,'3=Y5LY3F/LSQ','zh_CN',' ','投资理财收益率分析');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3=Y5OHQ5VVOK';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1692828251258601472,'3=Y5OHQ5VVOK','zh_CN',' ','投资理财金额机构分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39HQX=/QXA=D';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1681258411733569536,'39HQX=/QXA=D','zh_CN',' ','投资理财总额及收益分布汇总表');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '39S4+T9MECHO';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1683426458452019200,'39S4+T9MECHO','zh_CN',' ','投资理财银行投资余额');