select 
rec.FID as FID
,org.FNAME  �����֯
,rec.FBILLNO ���ݱ���
,CONVERT(varchar(230), rec.FDATE, 23) ����
,m.FNUMBER ��ϱ���
,mg_L.[FNAME] ��Ϸ���
,ml.[FNAME] ������
,ml.F_QZYN_MULLANGTEXT4 ͨ���
,ml.[FSPECIFICATION] ����ͺ�
,sup_L.[FNAME] ��Ӧ��
,rece.FACTRECEIVEQTY �������
,un_L.FNAME ��λ
,CASE
WHEN rec.FDOCUMENTSTATUS='A'  then '����'
WHEN rec.FDOCUMENTSTATUS='B'  then '�����'
WHEN rec.FDOCUMENTSTATUS='C'  then '�����'
WHEN rec.FDOCUMENTSTATUS='D'  then '�������'
else  'δ֪' end
as ����״̬
,rec.FSUPPLIERID
 from
T_PUR_Receive rec--�ɹ����֪ͨ��
left join T_PUR_ReceiveEntry rece on rec.FID=rece.FID--�ɹ����֪ͨ���ϸ
left join T_BD_MATERIAL m on rece.FMATERIALID=m.FMATERIALID --���
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=rece.FMATERIALID--��϶�����
left join T_BD_MATERIALGROUP_L mg_L on m.FMATERIALGROUP=mg_L.FID --��Ϸ���
left join T_BD_UNIT_L un_L on rece.FUNITID=un_L.FUNITID --��λ
left join T_BD_SUPPLIER_L sup_L on sup_L.FSUPPLIERID=rec.FSUPPLIERID --��Ӧ��
left join T_ORG_ORGANIZATIONS_L org on org.FORGID=rec.FSTOCKORGID  and org.FLOCALEID=2052--��֯

where rec.FCANCELSTATUS='A' --��
--and rec.FSUPPLIERID={0}