---���Ա�������ͳ��
declare @begdate date,@enddate date
set @begdate='2023-01-01'
set @enddate='2023-6-30'


select 
org.FDESCRIPTION ������֯
,ou.FBILLNO ���ⵥ��
,CONVERT(varchar(230), ou.FDATE, 23) ����
,cu_L.FNAME �ͻ����
--,dep_L.FNAME ����
--,sal.FNAME ���Ա
--,(select top 1 Fname from [RedLab_V_Hr2Sales] where FSELLER=ou.FSALESMANID)  ���Ա
--,oue.FSEQ ���
,m.FNUMBER ��ϱ���
,ml.FNAME ������
,ml.FSPECIFICATION ����ͺ�
,sto.FNAME �ֿ�
,oue.FREALQTY ʵ�����
,un_L.Fname ��λ
,un_L.FUNITID

 from T_SAL_OUTSTOCK ou
left join T_SAL_OUTSTOCKENTRY oue on ou.fid=oue.FID --�����ϸ
left join T_SAL_OUTSTOCKENTRY_F ouef on oue.FENTRYID=ouef.FENTRYID--����
left join T_BD_MATERIAL_L ml on ml.FMATERIALID=oue.FMATERIALID--���
left join T_BD_MATERIAL m on oue.FMATERIALID=m.FMATERIALID --��ϱ���
left join T_BD_CUSTOMER_L cu_L on cu_L.FCUSTID=ou.FCUSTOMERID --�ͻ�
left join T_BD_DEPARTMENT_L dep_L on dep_L.FDEPTID=ou.FDeliveryDeptID --����
left join T_BD_UNIT_L un_L on un_L.FUNITID=ouef.FPRICEUNITID --��λ
left join T_BD_STOCK_L sto on sto.FSTOCKID=oue.FStockID --�ֿ�
left join T_ORG_ORGANIZATIONS_L org on org.FORGID=ou.FStockOrgId and org.FLOCALEID=2052 --��֯



where ou.FDOCUMENTSTATUS='C'
and ou.FCANCELSTATUS='A'
and ou.FDATE between @begdate and @enddate
and ouef.FPRICEUNITID<>10101
--and un_L.Fname='pcs'