CREATE VIEW dbo.CEK_LISTESI
AS
SELECT        DUEDATE AS TARIH, BANKNAME AS [BANKA ADI], PORTFOYNO AS [ÇEK NO], BNBRANCHNO AS SUBESI, BNACCOUNTNO AS [HESAP NO], MUHABIR AS [ÇEK SAHIBI], OWING AS FIRMA, CITY AS [KASIDE YERI], 
                         AMOUNT AS TUTAR, CASE WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 1 THEN 'Portföyde' WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 2 THEN 'Ciro Edildi' WHEN CSCARD.DOC IN (1, 2) AND 
                         CSCARD.CURRSTAT = 3 THEN 'Teminata Verildi' WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 4 THEN 'Tahsile Verildi' WHEN CSCARD.DOC IN (1, 2) AND 
                         CSCARD.CURRSTAT = 5 THEN 'Tahsile Verildi(Protestolu)' WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 6 THEN 'Iade Edildi' WHEN CSCARD.DOC IN (1, 2) AND 
                         CSCARD.CURRSTAT = 7 THEN 'Protesto Edildi' WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 8 THEN 'Tahsil Edildi' WHEN CSCARD.DOC IN (1, 2) AND 
                         CSCARD.CURRSTAT = 11 THEN 'Karsiligi Yok' WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 12 THEN 'Tahsil Edilemiyor' WHEN CSCARD.DOC IN (1, 2) AND 
                         CSCARD.CURRSTAT = 13 THEN 'Portföyde Karsiliksiz' WHEN CSCARD.DOC IN (1, 2) AND CSCARD.CURRSTAT = 14 THEN 'Portföyde Protestolu' WHEN CSCARD.DOC IN (3, 4) AND 
                         CSCARD.CURRSTAT = 6 THEN 'Iade Edildi' WHEN CSCARD.DOC IN (3, 4) AND CSCARD.CURRSTAT = 7 THEN 'Protesto Edildi' WHEN CSCARD.DOC IN (3, 4) AND 
                         CSCARD.CURRSTAT = 8 THEN 'Tahsil Edildi' WHEN CSCARD.DOC IN (3, 4) AND CSCARD.CURRSTAT = 9 THEN 'Kendi Çekimiz' WHEN CSCARD.DOC IN (3, 4) AND 
                         CSCARD.CURRSTAT = 10 THEN 'Borç Senedimiz' WHEN CSCARD.DOC IN (3, 4) AND CSCARD.CURRSTAT = 12 THEN 'Tahsil Edilemiyor' ELSE '' END AS DURUM
FROM            dbo.LG_011_07_CSCARD AS CSCARD
WHERE        (DOC = 1)