电子专票和纸质专票初次核定份数合计超过25份的户数占比.docx

《电子专票和纸质专票初次核定份数合计超过25份的户数占比.docx》由会员分享，可在线阅读，更多相关《电子专票和纸质专票初次核定份数合计超过25份的户数占比.docx（2页珍藏版）》请在优知文库上搜索。

1、电子专票和纸质专票初次核定份数合计超过25份的户数占比SE1.ECTNSRMCas纳税人名称，nvl(SHXYDM,NSRSBH)as社会信用代码，nsrdzdahas纳税人电子档案号，Swjgmcas主管税务机关，swryas税收管理员，fpzmcas发票种类，Myzggpslas每月最高购票数量，YXQQas有效期起，YXQZas有效期止，Irrqas录入日期，dsswjgmcas地市级税务机关，qswjgmcas区县级税务机关FROM(SE1.ECTHDQCXH,A.NSRDZDAHzSHXYDM,NSRSBH,NSRMC,B.FPZ1.mc,Aqffpzgkpxejd,a.dffpzg

2、kpxeMYZGGPS1.,MCZGGPS1.zYXQQ,YXQZ,NSR.SWJG_DM,NSR.SSG1.YSWRY_DM,nsr.ssglyswrymcswry,nsr.swjgme,nsr.dsswjg_dm,nsr.dsswjgmc,nsr.qxswjgmc,A.1.RRQ,B.ZPPZJD,SM(MYZGGPS1.)OVER(PARTITIONBYA.NSRDZDAH,1.RRQ)MYZGGPS1._HZ,RANK()OVER(PARTITIONBYA.NSRDZDAHORDERBYA.1.RRQ)ASRID,-202203231.IJYMIN(YXQQ)OVER(PARTITIO

3、NBYA.NSRDZDAH,1.RRQ)M_YXQQ-202203231.IJYFROMSJCK_BZ.FP_PZHDXXAINNERJOINSJCK_BZ.WD_FPZ1.BONA.FPZ1._ID=B.FPZ1._IDINNERJOIN(SE1.ECTNSR.NSRDZDAH,NSR.SWJGJD,NSR.SWJG_DM,NSR.SSGIYSWRY_DM,NSR.swjgmc,nsr.dsswjg_dmznsr.dsswjgmc,nsr.ssglyswrymc,nsr.qxswjgmcFROMSJCK_BZ.WD_NSRXXNSRwhereNSR.kqccsztdjBZ=,n,ANDNSR

4、.KZZTDJ1.XJD=(selectCASEWHENCOUNT(I)=1THENDAE,2018-10-01,E1.SEDAE,2018-08-01,ENDDATE_1.RRQfromWD_SWJGwherejGJCJD=OANDSWJGCC1.X_BJ=,1,ANDSWJGJDIN(,16300000000,z,15400000000,16500000000)NSRONA.NSRDZDAH=NSR.NSRDZDAHWHEREB.ZPPZ_IDIN(,1,9)ANDA.YXQZA.YXQQ)TWHERET.RID=1ANDT.1.RRQ=(selectCASEWHENCOUNT(I)=1THENDAE2018-10-01E1.SEDAE,2018-08-01ENDDArE_1.RRQfromWD_SWJGWherejGJCJD=1OlANDSWJGCC1.X_BJ=TANDSWJG_IDIN(16300000000,15400000000,16500000000,)-20220318/XYIMAND*T.YXQQ*M-YXQQ=fxqjq-202203231.IJYAND*T.YXQQ*M-YXQQ25andt.dsswjg_dm=dsswjg_dm;