SQL_Çek Senet Son Durum Kolon Anlamları_DOC_CURRSTAT(CSCARD)
"Son Durum"=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 'İade 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 'Karşılığı 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 Karşılıksız' 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 'İade 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,
0 Yorum