SentezVogue Sipariş Listesi (Gelen) SQL Sorgusu
Select isnull(C.ADI,S.CKOD) as [Cari Adı],S.TARIH as [Sipariş Tarihi],S.FISNO as [Sip.No],S.TERMIN as [Termin]
,isnull(M.ADI,S.MKOD) as [Stok Açıklama],S.VRNT1 as [Varyant1],S.VRNT2 as [Varyant2]
,S.MIKTAR as [Sip.Miktar],isnull(M.BRM1,'') as [Birim],S.FIYAT as [Birim Fiyat],(S.MIKTAR*S.FIYAT) as [Tutar]
,isnull(SS.TARIH,-1) as [Gelen Tarih],isnull(SS.FISNO,0) as [Gelen No],isnull(SS.MIKTAR,0) as [Gelen Miktar]
,(S.MIKTAR-isnull(SS.MIKTAR,0)) as [Kalan Miktar]
,S.FIYAT*(S.MIKTAR-isnull(SS.MIKTAR,0)) as [Kalan Tutar],S.TIP as [Hareket Tipi]
from SIPFD S left join MUSTERI C on (C.KOD=S.CKOD) left join MAL M on (M.KOD=S.MKOD)
left join SFISD SS on (SS.STIP=S.TIP and SS.SIPARIS=S.FISNO and SS.SSATIR=S.SATIR)
order by C.ADI,S.TARIH