SentezVogue Sipariş Listesi SQL Sorgusu
Select S.TARIH as [Sipariş Tarihi],S.FISNO as [Sipariş Fiş No]
,S.CKOD as [Cari Kodu],isnull(C.ADI,'') as [Cari Adı],S.MIKTAR as [Verilen Sipariş Adeti]
,(S.MIKTAR*S.FIYAT) as [Net Tutar]
,isnull
((select sum(SS.MIKTAR) from SFISD SS where SS.STIP=S.TIP and SS.SIPARIS=S.FISNO and SS.SSATIR=S.SATIR),0) as [Teslim Edilen]
,S.FIYAT*isnull
((select sum(SS.MIKTAR) from SFISD SS where SS.STIP=S.TIP and SS.SIPARIS=S.FISNO and SS.SSATIR=S.SATIR),0)
as [Teslim Edilen Tutar],S.MIKTAR-isnull
((select sum(SS.MIKTAR) from SFISD SS where SS.STIP=S.TIP and SS.SIPARIS=S.FISNO and SS.SSATIR=S.SATIR),0)
as [Kalan Sipariş Adeti] ,S.FIYAT*(S.MIKTAR-isnull
((select sum(SS.MIKTAR) from SFISD SS where SS.STIP=S.TIP and SS.SIPARIS=S.FISNO and SS.SSATIR=S.SATIR),0))
as [Kalan Sipariş Tutarı]
from SIPFD S left join MUSTERI C on (C.KOD=S.CKOD)
where S.TIP=1
order by S.TARIH