--��ʷ������Ϣ

SELECT B.FDIMENSIONID FORGID
--,L.FNAME ��֯���
,M.FMATERIALID,M.FNUMBER,ST.FSTOCKID
,O.FYEAR,O.FPERIOD
,SUM(CASE WHEN B.FENDINITKEY=0 THEN B.FQTY ELSE 0 END) AS �ڳ��
,SUM(CASE WHEN B.FENDINITKEY=0 THEN B.FAMOUNT ELSE 0 END) AS �ڳ����
,SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FCURRENTINQTY ELSE 0 END) AS ����
,SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FCURRENTINAMOUNT ELSE 0 END) AS �����
,SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FOUTSTOCKQTY ELSE 0 END) AS �����
,SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FCURRENTOUTAMOUNT ELSE 0 END) AS ������
,SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FQTY ELSE 0 END) AS ��ĩ�
,SUM(CASE WHEN B.FENDINITKEY=1 THEN B.FAMOUNT ELSE 0 END) AS ��ĩ���
into #t1
FROM T_HS_BALANCE_H B  --��ʷ������Ϣ

LEFT JOIN T_HS_OUTACCTG O ON B.FID=O.FID --��������--ȡ����
LEFT JOIN T_HS_STOCKDIMENSION S ON B.FDIMEENTRYID=S.FENTRYID  --���
LEFT JOIN T_BD_MATERIAL M ON S.FMASTERID=M.FMASTERID AND B.FDIMENSIONID=M.FUSEORGID
LEFT JOIN T_BD_STOCK AS ST ON ST.FSTOCKID =S.FSTOCKID
--LEFT JOIN T_ORG_ORGANIZATIONS_L L ON L.FORGID=C.FFINORGID AND L.FLOCALEID=2052 --��֯���
--LEFT JOIN T_HS_CALDIMENSIONS C ON B.FDIMENSIONID=C.FDIMENSIONID --������֯

where O.FYEAR=2023
and O.FPERIOD=08
and B.FDIMENSIONID=1
--and M.FNUMBER='SIE01010101'

GROUP BY B.FDIMENSIONID,M.FMATERIALID,O.FYEAR,O.FPERIOD,M.FNUMBER ,ST.FSTOCKID

--select * from #t1
select sum(��ĩ���) from #t1
where ��ĩ���<>0

drop table #t1


--select * from T_HS_STOCKDIMENSION
--select * from T_HS_OUTACCTG
--select * from T_ORG_ORGANIZATIONS_L
--select * from T_HS_BALANCE_H B  --��ʷ������Ϣ

--LEFT JOIN T_HS_OUTACCTG O ON B.FID=O.FID --����


--select * from  T_HS_OUTACCTG --��������