CREATE VIEW dbo.CEKLER_MUHASEBE
AS
SELECT        CAST(Vade AS date) AS [Tarih],[Banka], [Çek No], [Subesi], [Hesap No], CASE WHEN Kefil IS NOT NULL AND Kefil<>'' THEN Kefil ELSE [Borçlu/Alacakli] END [Firma], [Kaside Yeri], Tutar
FROM            (SELECT        DUEDATE AS Vade, dbo.CEK_CARI_KOD(OWING) AS [Cari Kodu], OWING AS [Borçlu/Alacakli], KEFIL AS Kefil, TAHSILAT AS Tutar, CONCAT(CONCAT(CARIKOD, ' '), CARI) AS Hesap, DURUM AS Durum, LOGICALREF,
                                                    STATUS, NEWSERINO AS [Çek No], DEFINITION_ AS [Banka], BNBRANCHNO AS [Subesi], BNACCOUNTNO AS [Hesap No], CITY AS [Kaside Yeri]
                          FROM            dbo.CEKLER_SENETLER
                          WHERE        (DURUM IN ('PORTFÖYDE', 'TAHSILE VERILDI')) AND (DOC = 1)) AS QQ
WHERE        (LOGICALREF NOT IN
                             (SELECT        LOGICALREF
                               FROM            dbo.CEKLER_SENETLER
                               WHERE        (DOC = 1) AND (DURUM = 'TAHSILE VERILDI') AND (STATUS = 1)))