航天开票系统数据导出软件(税盘版)

select * from (SELECT case when a.[FPZL]='c' then '普通发票' else '增值税发票' end as '发票类别' ,a.[FPDM] as '发票代码' ,a.[FPHM] as '发票号码' ,a.[KPJH] as '开票机号' ,a.[GFMC] as '客户名称' ,a.[GFSH] as '客户税号' ,a.[GFDZDH] as '客户地址电话' ,a.[GFYHZH] as '客户银行账号' ,a.[KPRQ] as '开票日期' ,a.[HJJE] as '含税总金额' ,a.[HJSE] as '含税总税额' ,a.[KPR] as '开票人' ,a.[SKR] as '审核人' ,a.[FHR] as '复核人' ,b.[FPMXXH] as '明细序号' ,b.[SPMC] as '产品名称' ,b.[GGXH] as '规格型号' ,b.[SL] as '数量' ,b.[DJ] as '单价' ,case when b.[HSJBZ]='1' then '是' else '否' end as '单价含税标志' ,b.[JLDW] as '计量单位' ,b.[JE] as '不含税金额' ,b.[SLV] as '税率' ,b.[SE] as '税额' FROM [XXFP] a , XXFP_MX b where a.FPHM=B.FPHM and b.[FPHXZ] =0 and a.[ZFBZ]='0' union all SELECT case when a.[FPZL]='c' then '普通发票' else '增值税发票' end as '发票类别' ,a.[FPDM] as '发票代码' ,a.[FPHM] as '发票号码' ,a.[KPJH] as '开票机号' ,a.[GFMC] as '客户名称' ,a.[GFSH] as '客户税号' ,a.[GFDZDH] as '客户地址电话' ,a.[GFYHZH] as '客户银行账号' ,a.[KPRQ] as '开票日期' ,a.[HJJE] as '含税总金额' ,a.[HJSE] as '含税总税额' ,a.[KPR] as '开票人' ,a.[SKR] as '审核人' ,a.[FHR] as '复核人' ,c.[FPMXXH] as '明细序号' ,c.[SPMC] as '产品名称' ,c.[GGXH] as '规格型号' ,c.[SL] as '数量' ,c.[DJ] as '单价' ,case when c.[HSJBZ]='1' then '是' else '否' end as '单价含税标志' ,c.[JLDW] as '计量单位' ,c.[JE] as '不含税金额' ,c.[SLV] as '税率' ,C.[SE] as '税额' FROM [XXFP] a , XXFP_MX b, XXFP_XHQD c where a.FPHM=B.FPHM and a.FPHM=c.FPHM and b.[FPHXZ] = 1 and a.[ZFBZ]='0' ) where 1=1 and 开票日期>='2015-07-01' and 开票日期<='2016-06-01'