Düzenle: GUNLUK_SATIS_LISTESI

İlgili Uygulama

Nesne Türü

Nesne Adı

Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)

Genel Kullanım Amacı ve Notlar

Tam SQL Kodu

CREATE VIEW dbo.GUNLUK_SATIS_LISTESI
AS
SELECT   ITM.CODE AS ICODE, ITM.NAME AS INAME, ITM.SPECODE4 AS MARKA, ITM.SPECODE AS RAF, ISNULL(ESK.ONHAND, 0) AS OSTOCK, ISNULL(BSS.ONHAND, 0) AS BSTOCK, 
                         ISNULL(GNT.ONHAND, 0) AS STOK, SUM(STL.AMOUNT) AS SAT, ISNULL(SKV.SECIM, 0) AS SECIM, ITM.LOGICALREF AS REF, ITM.SPECODE5 AS BLOK, ISNULL(SKV.HATA, 0) AS HATA, 
                         ISNULL(SKV.DUZELTME, '') AS DUZELTME, ISNULL(SKV.REF, 0) AS SKVREF
FROM         dbo.LG_011_08_STLINE AS STL LEFT OUTER JOIN
                         dbo.LG_011_08_STFICHE AS STF ON STF.LOGICALREF = STL.STFICHEREF LEFT OUTER JOIN
                         dbo.LG_011_ITEMS AS ITM ON ITM.LOGICALREF = STL.STOCKREF LEFT OUTER JOIN
                         dbo.LV_011_08_GNTOTST AS GNT ON GNT.STOCKREF = STL.STOCKREF AND GNT.INVENNO = - 1 LEFT OUTER JOIN
                         dbo.STOK_KONTROL AS SKV ON SKV.ITEMREF = STL.STOCKREF AND SKV.DATE_ = CAST(GETDATE() AS DATE) LEFT OUTER JOIN
                         dbo.ESKI_STOK AS ESK ON ESK.STOCKREF = STL.STOCKREF LEFT OUTER JOIN
                         dbo.BU_SABAH_STOK AS BSS ON BSS.STOCKREF = STL.STOCKREF
WHERE     (STL.LINETYPE = 0) AND (STL.CANCELLED = 0) AND (STL.TRCODE = 8) AND (STF.DATE_ = DATEADD(DAY, - 1, CAST(GETDATE() AS DATE)))
GROUP BY ITM.CODE, ITM.NAME, ITM.SPECODE, ITM.SPECODE4, GNT.ONHAND, SKV.SECIM, ITM.LOGICALREF, ESK.ONHAND, BSS.ONHAND, ITM.SPECODE5, SKV.HATA, SKV.DUZELTME, 
                         SKV.REF

Oluşturulma: 23.12.2025 07:15 Son Güncelleme: 23.12.2025 17:28

İptal Nesneyi Sil