Düzenle: 00001_SATIS_IADELER

İ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.[00001_SATIS_IADELER]
AS
SELECT        QQ.STOCKREF, SUM(QQ.I2022) AS AIDE2022, SUM(QQ.I2021) AS IADE2021, SUM(QQ.I2020) AS IADE2020, SUM(QQ.I2022) + SUM(QQ.I2021) AS SONIKI, SUM(QQ.I2022) + SUM(QQ.I2021) + SUM(QQ.I2020) AS TOPLAM
FROM            ((SELECT        STOCKREF, SUM(AMOUNT) AS I2022, 0 AS I2021, 0 AS I2020
                            FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                            WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
                            GROUP BY STOCKREF)
                         UNION ALL
                         (SELECT        STOCKREF, 0 AS I2022, SUM(AMOUNT) AS I2021, 0 AS I2020
                          FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                          WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
                          GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, 0 AS I2022, 0 AS I2021, SUM(AMOUNT) AS I2020
 FROM            [UNIVERSALDB].[dbo].LG_011_06_STLINE
 WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, 0 AS I2022, 0 AS I2021, SUM(AMOUNT) AS I2020
 FROM            [UNIVERSALDB].[dbo].LG_011_05_STLINE
 WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
 GROUP BY STOCKREF)) QQ
GROUP BY QQ.STOCKREF

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

İptal Nesneyi Sil