


CREATE or alter  view V_StokHarLog_Goster 
as
SELECT        Id, NoId, EklemeTarihi, IslemNo,IslemNo3, FisTuru,  IslemTuru, CariNo,MUSKOD,MUSADI CARIADI, StokNo, SL.StokKodu, Miktar, Birim, BirimFiyat,SonTutar, SonTutarDov, Iskonto, SiparisNo, SiparisTarihi, Kdv, FaturaNo, FaturaTarihi, Satici, DovizTut, DovizKodu, SL.Depo,SL.KULNO, AltIskYuzde, 
                         SL.Departman,  SatMasrafTutari
FROM            StokHarLog SL LEFT JOIN  AMUSTERI A ON A.MUSNO=SL.CariNo
 