where kısmı neresi
SELECT CSC.DUEDATE AS [Vade],
YEAR(csc.duedate) AS [Yıl],
CASE MONTH(CSC.DUEDATE)
WHEN 1 THEN 'Ocak'
WHEN 2 THEN 'Şubat'
WHEN 3 THEN 'Mart'
WHEN 4 THEN 'Nisan'
WHEN 5 THEN 'Mayıs'
WHEN 6 THEN 'Haziran'
WHEN 7 THEN 'Temmuz'
WHEN 8 THEN 'Ağustos'
WHEN 9 THEN 'Eylül'
WHEN 10 THEN 'Ekim'
WHEN 11 THEN 'Kasım'
WHEN 12 THEN 'Aralık'
END AS [Aylar],
CSR.DATE_ AS [İşlem Tarihi],
CSC.PORTFOYNO AS [Pört No],
CSC.NEWSERINO AS [Seri No],
CSC.AMOUNT AS [Tutar],
CASE DOC
WHEN 1 THEN 'Çek Girişi'
WHEN 2 THEN 'Senet Girişi'
WHEN 3 THEN 'Çek Çıkış (Cari Hesaba)'
WHEN 4 THEN 'Senet Çıkış (Cari Hesaba)'
WHEN 5 THEN 'Çek Çıkış (Banka Tahsil)'
WHEN 6 THEN 'Senet Çıkış (Banka Tahsil)'
WHEN 7 THEN 'Çek Çıkış (Banka Teminat)'
WHEN 8 THEN 'Senet Çıkış (Banka Teminat)'
WHEN 9 THEN 'İşlem Bordrosu(Müşteri Çeki)'
WHEN 10 THEN 'İşlem bordrosu (Müşteri Senedi)'
WHEN 11 THEN 'İşlem Bordrosu (Kendi Çekimiz)'
WHEN 12 THEN 'İşlem Bordrosu (Borç Senedimiz)'
ELSE 'Ne Oldugu Belirsiz' END 'İŞLEM TÜRÜ',
CASE CURRSTAT
WHEN 1 THEN 'Portföyde'
WHEN 2 THEN 'Ciro Edildi'
WHEN 3 THEN 'Teminata Verildi'
WHEN 4 THEN 'Tahsile Verildi'
WHEN 5 THEN 'Protestolu Tahsile Verildi'
WHEN 6 THEN 'İade Edildi'
WHEN 7 THEN 'Protesto Edildi'
WHEN 8 THEN 'Tahsil Edildi'
WHEN 9 THEN 'Kendi Çekimiz'
WHEN 10 THEN 'Borç Senedimiz'
WHEN 11 THEN 'Karşılığı Yok'
WHEN 12 THEN 'Tahsil Edilemiyor'
ELSE 'Ne Oldugu Belirsiz' END 'DURUMU',
CSC.OWING AS [Borçlu],
CASE WHEN ISNULL(CLC.CODE, '') <> '' THEN CLC.DEFINITION_ ELSE (SELECT CLC1.DEFINITION_ FROM LG_015_CLCARD CLC1 WHERE CLC1.LOGICALREF =(SELECT TOP 1 CTS1.CARDREF FROM LG_015_01_CSTRANS CTS1 WHERE CTS1.STATUS = 1 AND CTS1.CSREF = CST.CSREF ORDER BY CTS1.LOGICALREF ASC)) END AS [CH Adı],
CSC.BANKNAME AS [Çekin Bankası],
ISNULL(ISNULL(BNK.DEFINITION_, BNK1.DEFINITION_), CSC.BANKNAME) AS [Banka Adı],
CASE WHEN ISNULL(CLC.CODE, '') <> '' THEN CLC.CITY ELSE (SELECT CLC1.CITY FROM LG_015_CLCARD CLC1 WHERE CLC1.LOGICALREF =(SELECT TOP 1 CTS1.CARDREF FROM LG_015_01_CSTRANS CTS1 WHERE CTS1.STATUS = 1 AND CTS1.CSREF = CST.CSREF ORDER BY CTS1.LOGICALREF ASC)) END AS "Şehir"
FROM LG_015_01_CSTRANS AS CST
LEFT OUTER JOIN LG_015_01_CSCARD AS CSC
ON CSC.LOGICALREF = CST.CSREF
LEFT OUTER JOIN LG_015_01_CSROLL AS CSR
ON CSR.LOGICALREF = CST.ROLLREF
LEFT OUTER JOIN LG_015_CLCARD AS CLC
ON CLC.LOGICALREF = CST.CARDREF
AND CST.CARDMD = 5
LEFT OUTER JOIN LG_015_BANKACC AS BNC
ON BNC.LOGICALREF = CSC.OURBANKREF
LEFT OUTER JOIN LG_015_BNCARD AS BNK
ON BNK.LOGICALREF = BNC.BANKREF
LEFT OUTER JOIN LG_015_BANKACC AS BNC1
ON BNC1.LOGICALREF = CST.CARDREF
AND CST.CARDMD = 7
LEFT OUTER JOIN LG_015_BNCARD AS BNK1
ON BNK1.LOGICALREF = BNC1.BANKREF
(ISNULL(CSC.AMOUNT, 0) <> 0)
AND csc.doc = 1
AND csc.duedate >= CONVERT(VARCHAR, GETDATE(), 112)
AND CSc.CURRSTAT IN (1,2,3,4,5,6,7,8,9,10,11,12)
AND cst.statno = 1
ORDER BY
CSc.dueDATE
