--�ɹ�����
select 
poe.FENTRYID  
,poe.FID
,org.FNAME �ɹ���֯
,PO.FBILLNO ���ݱ��
,bt.FNAME �������
,CONVERT(varchar(230),PO.FDATE, 23) as �ɹ�����
,po.FCREATEDATE ��������
,u.FNAME ������
,ua.FNAME �����
,po.FAPPROVEDATE �������

,sup_L.FNAME ��Ӧ��
,m.FNUMBER ��ϱ���
,ml.[FNAME] ������

,ml.[FSPECIFICATION] ����ͺ�
,cast(poe.FQTY as decimal(23,2)) �ɹ����
,poer.FRECEIVEQTY as �ۼ�������
,poer.FREMAINRECEIVEQTY as ʣ��������
,poer.FSTOCKINQTY as �ۼ�������
,poer.FREMAINSTOCKINQTY as ʣ��������
,poef.FTAXPRICE ��˰����
,poef.FALLAMOUNT ��˰�ϼ�
,FDELIVERYDATE ��������
,po.FSUPPLIERID
,poe.FENTRYID
,poe.FSEQ �к�
,CASE
WHEN po.FDOCUMENTSTATUS='A'  then '����'
WHEN po.FDOCUMENTSTATUS='B'  then '�����'
WHEN po.FDOCUMENTSTATUS='C'  then '�����'
WHEN po.FDOCUMENTSTATUS='D'  then '�������'
else  'δ֪' end
as ����״̬
 from 
t_PUR_POOrder po --�ɹ�����
left join t_PUR_POOrderEntry poe on poe.FID=po.FID --�ɹ������ϸ
left join T_PUR_POORDERENTRY_R poer on poe.FENTRYID=poer.FENTRYID--�����ϵ��
left join T_PUR_POORDERENTRY_F poef on poe.FENTRYID=poef.FENTRYID--����
left join T_PUR_POORDERENTRY_D poed on poe.FENTRYID=poed.FENTRYID--����
left join T_BD_MATERIAL m on poe.FMATERIALID=m.FMATERIALID --���
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=poe.FMATERIALID--��϶�����
left join T_SEC_USER u on u.FUSERID=po.FCREATORID  --�û�
left join T_SEC_USER ua on ua.FUSERID=po.FAPPROVERID  --����û�
left join T_ORG_ORGANIZATIONS_L org on org.FORGID=po.FPURCHASEORGID and org.FLOCALEID=2052--ʹ����֯
left join T_BD_SUPPLIER_L sup_L on po.FSUPPLIERID=sup_L.FSUPPLIERID --��Ӧ��
left join T_BAS_BILLTYPE_L bt on bt.FBILLTYPEID=po.FBillTypeID --�������

where po.FDOCUMENTSTATUS='C'--�����
and po.FCANCELSTATUS='A' --��
and po.FCLOSESTATUS='A' --δ�ر�
--and PO.FDATE between '{1}' and '{2}'
--and po.FSUPPLIERID={0}