create or replace view vw_zy_zffpxh as
select
  HSJKID JKDH00,  --缴款单号
  PJXH00,         --票据序号
  HTFPDM,         --航天发票代码
  HTFPXH,          --航天发票序号
  a.wbpjxh zffpxh  --作废发票序号
from ZY_PJSYQK A
where substrb(PJXH00,1,1)<>'-'
  and PJZT00='3'
  and PLBH00 in (3,10)