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


select 
FStockOrgId
,ou.FBILLNO ���ⵥ��
,CONVERT(varchar(230), ou.FDATE, 23) ����
,cu_L.FNAME �ͻ����
,dep_L.FNAME ����
,oue.FSEQ ���
,m.FNUMBER ��ϱ���
,ml.FNAME ������
,ml.FSPECIFICATION ����ͺ�
,oue.FREALQTY ʵ�����
,un_L.Fname ��λ
,ouef.FTAXPRICE ��˰����
,ouef.FTAXPRICE*oue.FREALQTY ��۶�
,ouef.FCOSTPRICE  �ɱ�����
,(ouef.FCOSTPRICE*oue.FREALQTY) ʵ�ʳɱ�
,(ouef.FTAXPRICE-ouef.FCOSTPRICE)*oue.FREALQTY �
,CASE
 WHEN ouef.FTAXPRICE<>0 then (ouef.FTAXPRICE-ouef.FCOSTPRICE)/ouef.FTAXPRICE
else  0 end 
as ���

 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 --��λ

where ou.FDOCUMENTSTATUS='C'
and ou.FCANCELSTATUS='A'
and ou.FDATE between @begdate and @enddate


--select 
--po.FBILLNO ���ⵥ��
--,CONVERT(varchar(230), po.FDATE, 23) ����
--,poe.FSEQ ���
--,m.FNUMBER ��ϱ���
--,ml.FNAME ������
--,ml.FSPECIFICATION ����ͺ�
--,poe.FQTY �ɹ����
--,poef.FTAXPRICE ��˰����
--,poer.FREMAINRECEIVEQTY ʣ��������
----,poe.*
-- from 
--t_PUR_POOrder po 
--left join t_PUR_POOrderEntry poe on po.fid=poe.FID --�ϸ
--left join T_PUR_POORDERENTRY_F poef on poef.FENTRYID=poe.FENTRYID 
--left join T_PUR_POORDERENTRY_R poer on poer.FENTRYID=poe.FENTRYID 
--left join T_BD_MATERIAL_L ml on ml.FMATERIALID=poe.FMATERIALID--���
--left join T_BD_MATERIAL m on poe.FMATERIALID=m.FMATERIALID --��ϱ���

--where po.FDOCUMENTSTATUS='C'
--and po.FCLOSESTATUS='A'
--and po.FCANCELSTATUS='A'
--and poer.FREMAINRECEIVEQTY>0
----����״̬��ȷ��


--and m.FUSEORGID=1