如何通过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
推荐阅读