-- 决策分析 应收应付票据发生额
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1698435119410315264;
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 (1698435119410315264,0,'3ABV2=D+ZNYA',NULL,NULL,1698435119410315264,'qing','C','tda_receivebillamountrpt','应收票据发生额',{ts'2023-06-02  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-06-02  00:00:00'},'kd.tmc.tda.report.note.qing.ReceiveBillAmountDataPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1698435124401539072;
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 (1698435124401539072,0,'3A=6GC1OKU+B',NULL,NULL,1698435124401539072,'qing','C','tda_paybillamountrpt','应付票据发生额',{ts'2023-06-02  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-06-02  00:00:00'},'kd.tmc.tda.report.note.qing.PayBillAmountDataPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1700628544931231744;
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 (1700628544931231744,0,'3AWIYI0TZ8SG',NULL,NULL,1700628544931231744,'qing','C','tda_recsecaccurdqingrpt','应收票据二级发生额轻分析',{ts'2023-06-05  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-06-05  00:00:00'},'kd.tmc.tda.report.note.qing.DraftBillRecSecAccurdPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1700731852593346560;
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 (1700731852593346560,0,'3AX0=HHEFCIQ',NULL,NULL,1700731852593346560,'qing','C','tda_paysecaccurdqingrpt','应付票据二级单位发生额',{ts'2023-06-05  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-06-05  00:00:00'},'kd.tmc.tda.report.note.qing.DraftBillPaySecAccurdPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1702293364256558080;
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 (1702293364256558080,0,'3ACV4+FR5SZY',NULL,NULL,1702293364256558080,'common','C','tda_receivebillamountsumr','应收票据发生额分布汇总',{ts'2023-06-07  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-06-07  00:00:00'},'kd.tmc.tda.report.note.data.DraftBillAmountDataListPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1703532506026099712;
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 (1703532506026099712,0,'3B+OCTYUIVO3',NULL,NULL,1703532506026099712,'qing','C','tda_recebillamtorgqrpt','应收票据发生额承兑机构分布',{ts'2023-06-09  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-06-09  00:00:00'},'kd.tmc.tda.report.note.qing.ReceiveBillAmtAccepterBankPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1703635250065711104;
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 (1703635250065711104,0,'3ACUZ01QM+K6',NULL,NULL,1703635250065711104,'common','C','tda_paybillamountsumrpt','应付票据发生额分布汇总',{ts'2023-06-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-06-09  00:00:00'},'kd.tmc.tda.report.note.data.DraftBillAmountDataListPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1703695166059184128;
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 (1703695166059184128,0,'3B61LYXB80C=',NULL,NULL,1703695166059184128,'qing','C','tda_recbillamtcustqrpt','应收票据收票客户排行--累计发生额',{ts'2023-06-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-06-09  00:00:00'},'kd.tmc.tda.report.note.qing.ReceiveBillAmountCustRankQingAnlsPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1703695179984274432;
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 (1703695179984274432,0,'3B8DJQX52JDQ',NULL,NULL,1703695179984274432,'qing','C','tda_paybillamtcustqrpt','应付票据开票供应商排名--累计发生额',{ts'2023-06-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-06-09  00:00:00'},'kd.tmc.tda.report.note.qing.PayBillAmountCustRankQingAnlsPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1705813728068391936;
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 (1705813728068391936,0,'3B8EM6OZPE/F',NULL,NULL,1705813728068391936,'common','C','tda_draftbillamtbankrpt','应收应付票据发生额承兑机构分布报表',{ts'2023-06-12  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-07-03  00:00:00'},'kd.tmc.tda.report.note.data.DraftBillAmtAccepterBankDataListPlugin',0,0,' '); 
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1705831072832464896;
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 (1705831072832464896,0,'3B+OIJBXCIDK',NULL,NULL,1705831072832464896,'qing','C','tda_paybillamtorgqrpt','应付票据发生额承兑机构分布',{ts'2023-06-12  00:00:00'},1468728001675123712,'1',' ',' ',{ts'2023-06-12  00:00:00'},'kd.tmc.tda.report.note.qing.PayBillAmtAccepterBankPlugin',0,0,' '); 

DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3AM0=NTTGMI+';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1698435119410315264,'3AM0=NTTGMI+','zh_CN',' ','应收票据发生额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3AM0=P440SHJ';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1698435124401539072,'3AM0=P440SHJ','zh_CN',' ','应付票据发生额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3AWJ43HR/U2L';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1700628544931231744,'3AWJ43HR/U2L','zh_CN',' ','应收票据二级发生额轻分析');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3AX0EXNLGY3=';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1700731852593346560,'3AX0EXNLGY3=','zh_CN',' ','应付票据二级单位发生额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3B2I6MJTX98J';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1702293364256558080,'3B2I6MJTX98J','zh_CN',' ','应收票据发生额分布汇总');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3B8FQBV72XNE';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1703532506026099712,'3B8FQBV72XNE','zh_CN',' ','应收票据发生额承兑机构分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3B8YXY1/S219';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1703635250065711104,'3B8YXY1/S219','zh_CN',' ','应付票据发生额分布汇总');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3B983IWHK4M/';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1703695166059184128,'3B983IWHK4M/','zh_CN',' ','应收票据收票客户排行--累计发生额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3B983MJ3X0FE';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1703695179984274432,'3B983MJ3X0FE','zh_CN',' ','应付票据开票供应商排名--累计发生额');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3BIG7+GNEZ5A';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1705831072832464896,'3BIG7+GNEZ5A','zh_CN',' ','应付票据发生额承兑机构分布');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3BICZJZ6U+95';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1705813728068391936,'3BICZJZ6U+95','zh_CN',' ','应收应付票据发生额承兑机构分布报表');

-- 有息负债到期期限分布
DELETE FROM T_FCS_SNAPSCHEDULE WHERE FID = 1550193226856987648;
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 (1550193226856987648,0,'2VD0JBTS/EMV',NULL,NULL,1550193226856987648,'common','C','tda_intbearliadeadlinerpt','有息负债到期期限分布表',{ts'2022-10-01  00:00:00'},1499987774416564224,'1',' ',' ',{ts'2022-10-01  00:00:00'},'kd.tmc.tda.report.finance.data.FinanceInterestBearLiaDisDataListPlugin',0,0,' ');

DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '2VDTYIDDIBUV';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1550193226856987648,'2VDTYIDDIBUV','zh_CN',' ','有息负债到期期限分布表');
