--���鵥
select 
jy.FID
,jy.FBILLNO ���ݱ��
,CONVERT(varchar(230),jy.FDATE, 23)  ��������
,org.FNAME �ʼ���֯
,sup_L.FNAME ��Ӧ��
,m.FNUMBER ��ϱ���
,ml.[FNAME] ������
,ml.[FSPECIFICATION] ����ͺ�

,FINSPECTQTY �������
,FQUALIFIEDQTY �ϸ��
,FUNQUALIFIEDQTY ���ϸ��
,FINSPECTRESULT  �����
,un_L.FNAME ��λ
,FQCSTATUS �ʼ�״̬
,sup_L.[FNAME] ��Ӧ��
,FSTOCKID �ֿ�
,FLOT ��� 

,CASE
WHEN jy.FDOCUMENTSTATUS='A'  then '����'
WHEN jy.FDOCUMENTSTATUS='B'  then '�����'
WHEN jy.FDOCUMENTSTATUS='C'  then '�����'
WHEN jy.FDOCUMENTSTATUS='D'  then '�������'
else  'δ֪' end
as ����״̬

--,jyea.* 
from 
T_QM_INSPECTBILL  jy
left join T_QM_INSPECTBILLENTRY_A jyea on jy.FID=jyea.FID
left join T_QM_INSPECTBILLENTRY jye on jye.FENTRYID=jyea.FENTRYID
left join T_BD_MATERIAL m on jyea.FMATERIALID=m.FMATERIALID --���
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=jyea.FMATERIALID--��϶�����

left join T_BD_UNIT_L un_L on jye.FUNITID=un_L.FUNITID --��λ
left join T_BD_SUPPLIER_L sup_L on sup_L.FSUPPLIERID=jye.FSUPPLIERID --��Ӧ��
left join T_ORG_ORGANIZATIONS_L org on org.FORGID=jy.FINSPECTORGID  and org.FLOCALEID=2052--��֯
where  jy.FCANCELSTATUS='A' --��
--and jy.FDATE between '{1}' and '{2}'
--and jye.FSUPPLIERID ='{0}'