create or replace view vw_sf_skhz00 as
select 
  a.JKDH00,
  a.ZFFSMC,        --支付方式名称  
  a.ZFFSMC_EX,
  sum(a.JFJE00) as JFJE00,
  decode(a.ZFFS00,1,'01',2,'02',24,'03',25,'04',8,'05',29,'05','09') as PXFS00,    --排序方式 直接按 现金、转账、微信、支付宝、云闪付、银行卡排序 
  (select sum(JFJE00) from VW_SF_SKMX00 t where t.ZFFS00  not in('1') and a.jkdh00=t.jkdh00 ) fxjhj0 -- 非现金合计 2022-1-11
from VW_SF_SKMX00 a 
group by a.JKDH00,decode(a.ZFFS00,1,'01',2,'02',24,'03',25,'04',8,'05',29,'05','09'),a.ZFFSMC,a.ZFFSMC_EX;