Düzenle: 0001_alis_satis_fiyatlari

İ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.[0001_alis_satis_fiyatlari]
AS
SELECT        TOP (100) PERCENT ITM.CODE AS [MALZEME KODU], ITM.NAME AS [MALZEME AÇIKLAMASI], GN.ONHAND - GN.RESERVED - GN.TEMPIN AS [STOK MIKTARI], ISNULL
                             ((SELECT        TOP (1) PRICE
                                 FROM            dbo.LG_011_PRCLIST
                                 WHERE        (PTYPE = 2) AND (ACTIVE = 0) AND (CARDREF = ITM.LOGICALREF)
                                 ORDER BY BEGDATE DESC), 0) AS [SATIS FIYATI], ISNULL
                             ((SELECT        TOP (1) CASE WHEN CAST(CURRENCY AS VARCHAR(5)) = 1 THEN 'USD' WHEN CAST(CURRENCY AS VARCHAR(5)) = 20 THEN 'EURO' WHEN CAST(CURRENCY AS VARCHAR(5)) = 160 OR
                                                          CAST(CURRENCY AS VARCHAR(5)) = 0 THEN 'TL' ELSE 'YOK' END AS Expr1
                                 FROM            dbo.LG_011_PRCLIST AS LG_011_PRCLIST_5
                                 WHERE        (PTYPE = 2) AND (ACTIVE = 0) AND (CARDREF = ITM.LOGICALREF)
                                 ORDER BY BEGDATE DESC), '') AS [SATIS KURU], ISNULL
                             ((SELECT        TOP (1) PRICE
                                 FROM            dbo.LG_011_PRCLIST AS LG_011_PRCLIST_4
                                 WHERE        (PTYPE = 1) AND (ACTIVE = 0) AND (CARDREF = ITM.LOGICALREF)
                                 ORDER BY BEGDATE DESC), 0) AS [ALIS FIYATI], ISNULL
                             ((SELECT        TOP (1) CASE WHEN CAST(CURRENCY AS VARCHAR(5)) = 1 THEN 'USD' WHEN CAST(CURRENCY AS VARCHAR(5)) = 20 THEN 'EURO' WHEN CAST(CURRENCY AS VARCHAR(5)) = 160 OR
                                                          CAST(CURRENCY AS VARCHAR(5)) = 0 THEN 'TL' ELSE 'YOK' END AS Expr1
                                 FROM            dbo.LG_011_PRCLIST AS LG_011_PRCLIST_3
                                 WHERE        (PTYPE = 1) AND (ACTIVE = 0) AND (CARDREF = ITM.LOGICALREF)
                                 ORDER BY BEGDATE DESC), '') AS [ALIS KURU], ISNULL
                             ((SELECT        TOP (1) LOGICALREF
                                 FROM            dbo.LG_011_PRCLIST AS LG_011_PRCLIST_2
                                 WHERE        (PTYPE = 2) AND (ACTIVE = 0) AND (CARDREF = ITM.LOGICALREF)
                                 ORDER BY BEGDATE DESC), 0) AS [SATIS DURUM], ISNULL
                             ((SELECT        TOP (1) LOGICALREF
                                 FROM            dbo.LG_011_PRCLIST AS LG_011_PRCLIST_1
                                 WHERE        (PTYPE = 1) AND (ACTIVE = 0) AND (CARDREF = ITM.LOGICALREF)
                                 ORDER BY BEGDATE DESC), 0) AS [ALIS DURUM], ITM.LOGICALREF, ITM.UNITSETREF
FROM            dbo.LG_011_ITEMS AS ITM LEFT OUTER JOIN
                         dbo.LV_011_07_GNTOTST AS GN ON GN.STOCKREF = ITM.LOGICALREF AND GN.INVENNO = - 1
WHERE        (ITM.ACTIVE = 0) AND (ITM.NAME <> '')
ORDER BY 'MALZEME AÇIKLAMASI'

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

İptal Nesneyi Sil