create or replace view vw_sf_byjk00_mzcf00_qt as
select
   to_char(to_date(a.SRRQ00,'YYYYMMDD'),'YYYY-MM-DD')||' '||a.SRSJ00 as Presc_date,     --处方时间
   a.CFLSH0 as Presc_no,              --处方编号
   to_char(a.YFBMBH) as Dispensary,   --发药药局编号
   (select ICKH00 from IC_YHXX00 where BRID00=a.BRID00 and ZT0000='1' and rownum=1) as Patient_id,     --就诊卡号
   a.BRXM00 as Patient_name,   --患者姓名
   null as Invoice_no,     --发票编号
   null as Patient_type,   --患者类型, ‘00’ 普通 ‘01’ 特需
   to_char(to_date(a.CSRQ00,'YYYYMMDD'),'YYYY-MM-DD')||' 00:00:00' as Date_of_birth,  --患者出生日期
   a.XB0000 as Sex,        --患者性别(男/女)
   null as Presc_identity, --患者身份
   null as Charge_type,    --医保类型
   null as Presc_attr,     --处方属性, 手工处方，临时处方等
   null as Presc_info,     --处方类型
   to_char((select wm_concat(ZDMC00) from YS_BRZDXX where GHID00=a.GHID00 /*and ZZDBZ0='3'*/)) as Rcpt_info,      --诊断信息
   null as Rcpt_remark,    --处方备注信息
   0 as Repetition,        --剂数
   a.CFZJE0 as Costs,        --费用
   a.CFZJE0 as Payments,     --实付费用
   null as Ordered_by,     --开单科室编号
   null as Ordered_by_name,--开单科室名称
   null as Prescribed_by,  --开方医生
   null as Entered_by,     --录方人
   0 as Dispense_pri,      --配药优先级（付费处到药房距离）数字从小到大表示优先级从高到低
   a.YFBMBH                --药房部门编号
from YF_MZCF00 a
;