select
purive.FENTRYID FID
,puriv.FBILLNO ���ݱ��
,CONVERT(varchar(230), puriv.FDATE, 23) ����
,sup_L.[FNAME] ��Ӧ��
,purive.FSEQ  �ϸ�к�
,puriv.FINVOICENO ��Ʊ��
,CONVERT(varchar(230), puriv.FINVOICEDATE, 23) ��Ʊ����
,m.FNUMBER ��ϱ���
,mg_L.[FNAME] ��Ϸ���
,ml.[FNAME] ������
--,ml.F_QZYN_MULLANGTEXT4 ͨ���
,ml.[FSPECIFICATION] ����ͺ�
,purive.FPRICEQTY �Ƽ����
,un_L.FNAME ������λ

from 
T_IV_PURCHASEIC puriv  --�ɹ���Ʊ
left join T_IV_PURCHASEICENTRY purive on puriv.FID=purive.FID --�ɹ���Ʊ�ϸ
left join T_BD_SUPPLIER_L sup_L on sup_L.FSUPPLIERID=puriv.FSUPPLIERID --��Ӧ��
left join T_BD_MATERIAL m on purive.FMATERIALID=m.FMATERIALID --���
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=purive.FMATERIALID--��϶�����
left join T_BD_MATERIALGROUP_L mg_L on m.FMATERIALGROUP=mg_L.FID --��Ϸ���
left join T_BD_UNIT_L un_L on purive.FBASICUNITID=un_L.FUNITID --��λ

where puriv.FDOCUMENTSTATUS='C'--�����
and puriv.FCANCELSTATUS='A' --��
--and puriv.FCREATEDATE between @begdate and @enddate
--and puriv.FCREATEDATE between {1} and {2}
--and puriv.FSUPPLIERID={0}