如何通过sql查看每期的余额和收发明细

如何通过sql查看每期的余额和收发明细原创

蒋斌

6人赞赏了该文章 130次浏览未经作者许可，禁止转载编辑于2024年06月17日 16:24:16

select FQTY,a.FOUTSTOCKQTY,a.FCURRENTINQTY,a.FCURRENTINAMOUNT,a.FCURRENTOUTAMOUNT,FYEAR,FPERIOD

from T_HS_BALANCE_H a

inner join T_HS_StockDimension b on a.FDIMEENTRYID=b.FENTRYID

inner join T_BD_MATERIAL c on b.FMASTERID=c.FMASTERID

inner join T_HS_OUTACCTG d on a.FID=d.FID

inner join T_HS_CALDIMENSIONS f on a.FDIMENSIONID=f.FDIMENSIONID

and f.FACCTSYSTEMID='1' and f.FFINORGID='100014' where c.FUSEORGID='100014'

and fnumber='PBL0215' and FENDINITKEY=0

赞 6