Düzenle: CARI_TUM_ISLEM_TOPLAMLARI_SIFIR

İ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.CARI_TUM_ISLEM_TOPLAMLARI_SIFIR
AS
SELECT CLIENTREF, MONTH_, SUM(KKTEK) AS KKTEK, SUM(KKTAK) AS KKTAK, SUM(NAKIT) AS NAKIT, SUM(TOPODM) AS TOPODM, SUM(IADE) AS IADE, SUM(SATIS) AS SATIS, SUM(TOPSAT) AS TOPSAT, SUM(TOPODM)-SUM(TOPSAT) AS DURUM FROM
(
(SELECT CLIENTREF, 0 AS MONTH_, TUTAR AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TEK_CEKIM_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, TUTAR AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TAKSITLI_CEKIM_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, TUTAR AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_NAKIT_ODEME_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, TUTAR AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TOPLAM_ODEME_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, IADE, SATIS, TUTAR AS TOPSAT FROM dbo.CARI_AYLIK_SATISLAR_SIFIR)
)QQ
GROUP BY QQ.CLIENTREF, QQ.MONTH_

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

İptal Nesneyi Sil