select 
org.FDESCRIPTION �����֯
,so.FBILLNO ���ݱ��
,CONVERT(varchar(230), so.FDATE, 23) ����
,cu_L.FNAME �ͻ����
,dep_L.FNAME ����
--,(select top 1 Fname from [RedLab_V_Hr2Sales] where FSELLER=so.FSALERID)  ���Ա
--,(select top 1 Fname from [RedLab_V_Hr2Sales] where FSELLER=so.FSALERID and Fname is not null)  ���Ա
,soe.FSeq �к�
,org2.FDESCRIPTION �����֯
,m.FNUMBER ��ϱ���
,ml.FNAME ������
,ml.FSPECIFICATION ����ͺ�
,soe.FQTY ������
,soef.FTAXPRICE ��˰����
,soef.FALLAMOUNT ��˰�ϼ�
,un_L.Fname ��λ


,CASE
 WHEN soe.FMRPCLOSESTATUS='A' then 'δ�ر�'
 WHEN soe.FMRPCLOSESTATUS='B' then 'ҵ��ر�'
else  ' ' end 
as ҵ��ر�

,CASE
 WHEN so.FDocumentStatus='A' then '����'
 WHEN so.FDocumentStatus='B' then '�����'
 WHEN so.FDocumentStatus='C' then '�����'
 WHEN so.FDocumentStatus='D' then '�������'
 WHEN so.FDocumentStatus='Z' then '�ݴ�'
else  ' ' end 
as ����״̬
--,so.FDocumentStatus  ����״̬

,CASE
 WHEN so.FCLOSESTATUS='A' then 'δ�ر�'
 WHEN so.FCLOSESTATUS='B' then 'ҵ��ر�'
else  ' ' end 
as �ر�״̬
--,so.FCLOSESTATUS �ر�״̬
,CASE
 WHEN so.FCANCELSTATUS='A' then '��'
 WHEN so.FCANCELSTATUS='B' then '�����'
else  ' ' end 
as ���״̬
--,so.FCANCELSTATUS ���״̬


from T_SAL_ORDER so --��۶���
left join T_SAL_ORDERENTRY soe on so.fid=soe.FID --��۶����ϸ
left join T_SAL_ORDERENTRY_F soef on soe.FENTRYID=soef.FENTRYID--����
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=soe.FMATERIALID--���
left join T_BD_MATERIAL m on soe.FMATERIALID=m.FMATERIALID --��ϱ���
left join T_BD_CUSTOMER_L cu_L on cu_L.FCUSTID=so.FCUSTID --�ͻ�
left join T_BD_DEPARTMENT_L dep_L on dep_L.FDEPTID=so.FSALEDEPTID --����
left join T_BD_UNIT_L un_L on un_L.FUNITID=soe.FUNITID --��λ
left join T_ORG_ORGANIZATIONS_L org on org.FORGID=so.FSALEORGID and org.FLOCALEID=2052 --��֯
left join T_ORG_ORGANIZATIONS_L org2 on org2.FORGID=soe.FSTOCKORGID and org2.FLOCALEID=2052 --�����֯
--where so.FDATE between '{1}' and '{2}'