CREATE VIEW dbo.CEK_SENET_MUHASEBE
AS
SELECT QQ.Vade, QQ.[Cari Kodu], QQ.[Borçlu/Alacakli], QQ.[Kefil], QQ.[Tutar], QQ.[Hesap], QQ.[Durum] 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(CARIKOD, ' ', CARI) AS [Hesap],
	DURUM AS [Durum],LOGICALREF, STATUS
FROM dbo.CEKLER_SENETLER
WHERE DURUM IN ('PORTFÖYDE', 'TAHSILE VERILDI') AND DOC=2) QQ
WHERE QQ.LOGICALREF NOT IN (SELECT LOGICALREF FROM dbo.CEKLER_SENETLER WHERE DOC=2 AND DURUM='TAHSILE VERILDI' AND STATUS=1)