开票纳税人未申报占比（负向）.docx

《开票纳税人未申报占比（负向）.docx》由会员分享，可在线阅读，更多相关《开票纳税人未申报占比（负向）.docx（2页珍藏版）》请在优知文库上搜索。

1、开票纳税人未申报占比(负向)一增值税专用发票开票未申报清册SE1.ECT+PARA1.1.E1.(4)*/NSR.NSRDZDAH,-1.VC_YF_DMZB.KPYF_DM,B.KPJEzNSR.NSRSBH,NSR.SHXYDMzNSR.NSRMC,NSR.SWJG_DM,NSR.SSG1.YSWRY_DM,-1.VC_BATCH_ID,SYSDAEFROM(SE1.ECTA.NSRDZDAHFROM(SE1.ECT/*+PARA1.1.E1.(4)*/T.NSRDZDAH,T.YF_DMKPYF_DM,SUM(NV1.(T.ZKYXZYFPJE,0)KPJEFROMSJCK_BZJCZT

2、_FPKJ_NSRKJXXTWHERET.YF_DM=TC1.CHAR(ADD_MONTHS(Tc1.DArE(TC1.CHAR(fxqjq,YYYYMM)zYYYYMM),-3)z,YYYYMM,)-202206201.IJYANDT.YF_DM0-202206201.IJYGROUPBYT.NSRDZDAH)BONA.NSRDZDAH=B.NSRDZDAH1.EFTJOIN(SE1.ECT/*+PARA1.1.E1.(8)*/T.NSRDZDAHFROMSJCK_BZ.SB_SBXXT-20220310WHERENV1.(T.ZFBZ,N,)=NANDT.GZ1.XJDIN(,z,5,)A

3、NDT.ZSXMJD=10101,ANDT.ZSD1.FSJD=OANDT.SBQX=ADD_MONTHS(fxqjq,-2)-202206201.IJYANDT.SBQX450000)AINNERJOIN(SE1.ECT/*+PARA1.1.E1.(4)*/T.NSRDZDAH,T.YF_DMKPYF_DM,SUM(NV1.(T.ZKYXZYFPJE,0)KPJEFROMSJCK_BZJCZT_FPKJ_NSRKJXXTWHERET.YF_DM=TC1.CHAR(ADD_MONTHS(Tc1.DArE(TC1.CHAR(fxqjq,YYYYMM)z,YYYYMM,)z-3)z,YYYYMM,

4、)-202206201.IJYANDT.YF_DMTO_CHAR(fxqjq,YYYYMM,)-202206201.IJYGROUPBYT.NSRDZDAH,T.YF_DM)BONA.NSRDZDAH=B.NSRDZDAHInnerjoin(select/*+parallel(4)*/NSRDZDAH,NSRSBH,SHXYDM,NSRMCzSWJG_DM,DSSWJG_DM,SSG1.YSWRY_DMFROMSJCK_BZ.WD_NSRXXNSRWHERENSR.KQCCSZTDJBZ=NANDKZZTDJ1.X_ID,1140,AndnsrztlxjdisnullANDNSR.YXBZ=,Y,ANDCASEWHENNSR.ZFJG1.XJDIN(,2,z3)THEN0E1.SE1END=1-202208191.IJYANDNSRZT_DMIN(*02*/,03*z,04z05,0613,*/)NSRONA.NSRDZDAH=NSR.NSRDZDAHandnsr.DSSWJG_DM=dsswjg_dm;