CREATE VIEW dbo.CEKLER_SENETLER
AS
SELECT        CSC.DUEDATE, CSC.SETDATE, UPPER(CASE WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 1 THEN 'Portföyde' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 2 THEN 'Ciro Edildi' WHEN CSC.DOC IN (1, 2) AND 
                         CSC.CURRSTAT = 3 THEN 'Teminata Verildi' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 4 THEN 'Tahsile Verildi' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 5 THEN 'Tahsile Verildi(Protestolu)' WHEN CSC.DOC IN (1, 2)
                          AND CSC.CURRSTAT = 6 THEN 'Ýade Edildi' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 7 THEN 'Protesto Edildi' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 8 THEN 'Tahsil Edildi' WHEN CSC.DOC IN (1, 2) AND 
                         CSC.CURRSTAT = 11 THEN 'Karþýlýðý Yok' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 12 THEN 'Tahsil Edilemiyor' WHEN CSC.DOC IN (1, 2) AND CSC.CURRSTAT = 13 THEN 'Portföyde Karþýlýksýz' WHEN CSC.DOC IN (1, 2) 
                         AND CSC.CURRSTAT = 14 THEN 'Portföyde Protestolu' WHEN CSC.DOC IN (3, 4) AND CSC.CURRSTAT = 6 THEN 'Ýade Edildi' WHEN CSC.DOC IN (3, 4) AND CSC.CURRSTAT = 7 THEN 'Protesto Edildi' WHEN CSC.DOC IN (3, 4) AND
                          CSC.CURRSTAT = 8 THEN 'Tahsil Edildi' WHEN CSC.DOC IN (3, 4) AND CSC.CURRSTAT = 9 THEN 'Kendi Çekimiz' WHEN CSC.DOC IN (3, 4) AND CSC.CURRSTAT = 10 THEN 'Borç Senedimiz' WHEN CSC.DOC IN (3, 4) AND 
                         CSC.CURRSTAT = 12 THEN 'Tahsil Edilemiyor' ELSE '' END) AS DURUM, CSC.PORTFOYNO, CSR.ROLLNO, CSR.GENEXP1, UPPER(dbo.fn_trcode('Csroll', CSR.TRCODE, NULL, NULL)) AS ISLEM, CSC.DOC, 
                         ACC.DEFINITION_ AS CARI, ACC.CODE AS CARIKOD, CSC.AMOUNT AS TAHSILAT, CSR.TRCODE, CSC.KEFIL, CSC.OWING, CST.STATUS, CST.CARDMD, CST.LOGICALREF, CSC.CITY, ACC.ACCOUNTNO, BNC.DEFINITION_, 
                         CSC.BNBRANCHNO, CSC.BNACCOUNTNO, CSC.NEWSERINO
FROM            dbo.LG_011_07_CSTRANS AS CST LEFT OUTER JOIN
                         dbo.LG_011_07_CSCARD AS CSC ON CSC.LOGICALREF = CST.CSREF LEFT OUTER JOIN
                         dbo.LG_011_07_CSROLL AS CSR ON CSR.LOGICALREF = CST.ROLLREF LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CLC ON CLC.LOGICALREF = CST.CARDREF LEFT OUTER JOIN
                         dbo.LG_011_BANKACC AS ACC ON ACC.LOGICALREF = CST.CARDREF LEFT OUTER JOIN
                         dbo.LG_011_BNCARD AS BNC ON ACC.BANKREF = BNC.LOGICALREF