【用友U8】用视图合并来料检验单、来料不良品处理单信息（包含多个单据的数据库表名）

–alter view [dbo].View_Checkvoucher as
select q.CCheckCode as [来料检验单号], a.CRejectCode as [来料不良品处理单号],q.dDATE as [检验日期],a.DCheckDate as [不良品处理日期],
v.cVenname as [供应商名称],w.cWhName as [仓库名称],q.CinvCode as [存货编码],i.cInvName AS [存货名称],u.unit_name AS [主计量单位],
q.FQuantity [报检数量],q.FRegQuantity as [合格接收数量],b.FQuantity as [不良品数量],c.cbdefine7 as [不良描述],
concat(convert(decimal(18,2),(case when q.FRegQuantity is not null then q.FRegQuantity else 0 end)/q.FQuantity)*100,‘%’) as [合格率],
concat(Convert(decimal(18,2),(case when b.FQuantity is not null then b.FQuantity else 0 end) /q.FQuantity)*100,‘%’) as [不良率],
q.CPoCode as [采购/委外订单号],h.cCode as [到货单号],p.CInSpectCode as [来料报检单号],
q.DarrivalDate as [到货日期],q.DinspectDate as [报检日期],
q.CinSpectPerson as [报检人],d.cDepName as [检验部门], s.cPersonName as [检验员],
a.FSUMQuantity as [待处理不良品数量],r.cReasonName as [不良品原因],m.CScrapDisName as [不良品处理方式],
case m.IDISPOSEFLOW when 0 then’拒收’ when 1 then ‘报废’ when 2 then’降级’ when 3 then ‘分拣’when 4 then’不处理’ when 5 then ‘工废’ when 6 then’料废’
when 7 then ‘返工’ when 8 then ‘退货’ when 8 then '返工计费’else null end as [不良品处理流程],t.cDepName as [不良品处理部门] --, *
from QMCheckVoucher q --来料检验单
left join QMInspectVoucher p on p.csourceid=q.sourceid --来料报检单
left join PU_ArrivalVouch h on h.id=q.SourceID --到货单
left join Vendor v on v.cVenCode=h.cVenCode–供应商档案
left join QMRejectVoucher a on q.SourceAutoId=a.SourceAutoId --来料不良品处理单表头
left join QMRejectVoucherS b on b.id=a.id --来料不良品处理的表体
left join QMRejectVoucherS_extradefine c on c.AutoId=b.AutoId
left join Inventory i on i.CinvCode=q.CinvCode
left join tc_unit u on u.unit_id=i.cComUnitCode --计量单位档案
left join Warehouse w on w.cWhCode=q.cWhCode --仓库档案
left join Reason r on r.cReasonCode=b.CReasonCode --质量原因码档案(原因码档案)
left join QMScrapDispose m on m.CScrapDisCode=b.CScrapDisCode --不良品处理方式档案(不良品处理方式)
left join Person s on s.cPersonCode=q.CCheckPersonCode
left join Department d on d.cDepCode=q.CDepCode
left join Department t on t.cDepCode=b.CDepCode
where q.CPoCode is not null and q.CinSpectCode=‘WH2303160014’

重点语句：
1、保留小数点后两位；
2、将小数转换为百分数；