{"id":869,"date":"2015-03-30T22:14:53","date_gmt":"2015-03-30T19:14:53","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=869"},"modified":"2015-10-16T17:37:55","modified_gmt":"2015-10-16T14:37:55","slug":"logo-finansal-hatirlatici","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-finansal-hatirlatici\/","title":{"rendered":"Logo Finansal Hat\u0131rlat\u0131c\u0131"},"content":{"rendered":"

SELECT CL.CODE,CL.DEFINITION_,PY.CARDREF,PY.CLOSINGRATE,PY.DATE_,PY.PAYNO,PY.MODULENR,PY.TRCODE,PY.TOTAL,
\nCASE
\nwhen PY.TRCODE =1 and PY.MODULENR=10 then ‘Nakit Tahsilat’
\nwhen PY.TRCODE =2 and PY.MODULENR=10 then ‘Nakit \u00d6deme’
\nwhen PY.TRCODE =11 and PY.MODULENR=10 then ‘Cari Hesap Tahsilat’<\/p>\n


\nwhen PY.TRCODE =12 and PY.MODULENR=10 then ‘Cari Hesap \u00d6deme’
\nwhen PY.TRCODE =21 and PY.MODULENR=10 then ‘Bankaya Yat\u0131r\u0131lan’
\nwhen PY.TRCODE =12 and PY.MODULENR=10 then ‘Bankadan \u00c7ekilen’
\nwhen PY.TRCODE =31 and PY.MODULENR=10 then ‘Sat\u0131nalma Faturas\u0131’
\nwhen PY.TRCODE =32 and PY.MODULENR=10 then ‘Perakende Sat\u0131\u015f \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =33 and PY.MODULENR=10 then ‘Toptan Sat\u0131\u015f \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =34 and PY.MODULENR=10 then ‘Al\u0131nan Hizmet Faturas\u0131’
\nwhen PY.TRCODE =35 and PY.MODULENR=10 then ‘Sat\u0131nalma \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =36 and PY.MODULENR=10 then ‘Perakende Sat\u0131\u015f Faturas\u0131’
\nwhen PY.TRCODE =37 and PY.MODULENR=10 then ‘Toptan Sat\u0131\u015f Faturas\u0131’
\nwhen PY.TRCODE =38 and PY.MODULENR=10 then ‘Verilen Hizmet Faturas\u0131’
\nwhen PY.TRCODE =39 and PY.MODULENR=10 then ‘M\u00fcstahsil Makbuzu’
\nwhen PY.TRCODE =41 and PY.MODULENR=10 then ‘Muh. Tahsil’
\nwhen PY.TRCODE =42 and PY.MODULENR=10 then ‘Muh. Tediye’
\nwhen PY.TRCODE =61 and PY.MODULENR=10 then ‘\u00c7ek Tahsili’
\nwhen PY.TRCODE =62 and PY.MODULENR=10 then ‘Senet Tahsili’
\nwhen PY.TRCODE =63 and PY.MODULENR=10 then ‘\u00c7ek \u00d6demesi’
\nwhen PY.TRCODE =64 and PY.MODULENR=10 then ‘Senet \u00d6demesi’
\nwhen PY.TRCODE =71 and PY.MODULENR=10 then ‘A\u00e7\u0131l\u0131\u015f (Bor\u00e7)’
\nwhen PY.TRCODE =72 and PY.MODULENR=10 then ‘A\u00e7\u0131l\u0131\u015f (Alacak)’
\nwhen PY.TRCODE =73 and PY.MODULENR=10 then ‘Virman (Bor\u00e7)’
\nwhen PY.TRCODE =74 and PY.MODULENR=10 then ‘Virman (Alacak)’
\nwhen PY.TRCODE =75 and PY.MODULENR=10 then ‘Gider Pusulas\u0131’
\nwhen PY.TRCODE =76 and PY.MODULENR=10 then ‘Verilen Serbest Mes’
\nwhen PY.TRCODE =77 and PY.MODULENR=10 then ‘Al\u0131nan Serbest Mes’
\nwhen PY.TRCODE =1 and PY.MODULENR =6 then ‘\u00c7ek Giri\u015fi’
\nwhen PY.TRCODE =2 and PY.MODULENR =6 then ‘Senet Giri\u015fi’
\nwhen PY.TRCODE =3 and PY.MODULENR =6 then ‘\u00c7ek \u00c7\u0131k\u0131\u015f Cari Hesaba’
\nwhen PY.TRCODE =4 and PY.MODULENR =6 then ‘Senet \u00c7\u0131k\u0131\u015f Cari Hesaba’
\nwhen PY.TRCODE =5 and PY.MODULENR =6 then ‘\u00c7ek \u00c7\u0131k\u0131\u015f Banka Tahsil’
\nwhen PY.TRCODE =6 and PY.MODULENR =6 then ‘Senet \u00c7\u0131k\u0131\u015f Banka Tahsil’
\nwhen PY.TRCODE =7 and PY.MODULENR =6 then ‘\u00c7ek \u00c7\u0131k\u0131\u015f Banka Teminat’
\nwhen PY.TRCODE =8 and PY.MODULENR =6 then ‘Senet \u00c7\u0131k\u0131\u015f Banka Teminat’
\nwhen PY.TRCODE =9 and PY.MODULENR =6 then ‘\u0130\u015flem Bordrosu M\u00fc\u015fteri \u00e7eki’
\nwhen PY.TRCODE =10 and PY.MODULENR =6 then ‘\u0130\u015flem Bordrosu M\u00fc\u015fteri Senedi’
\nwhen PY.TRCODE =11 and PY.MODULENR =6 then ‘\u0130\u015flem Bordrosu Kendi \u00c7ekimiz’
\nwhen PY.TRCODE =12 and PY.MODULENR =6 then ‘\u0130\u015flem Bordrosu Kendi Senedimiz’
\nwhen PY.TRCODE =13 and PY.MODULENR =6 then ‘\u0130\u015fyerleri Aras\u0131 \u0130.Bord. M\u00fc\u015fteri \u00c7eki’
\nwhen PY.TRCODE =1 and PY.MODULENR =7 then ‘Banka \u0130\u015flem Fi\u015fi’
\nwhen PY.TRCODE =2 and PY.MODULENR =7 then ‘Banka Virman Fi\u015fi’
\nwhen PY.TRCODE =3 and PY.MODULENR =7 then ‘Gelen Havale \/ Eft’
\nwhen PY.TRCODE =4 and PY.MODULENR =7 then ‘G\u00f6nderilen Havale \/ Eft’
\nwhen PY.TRCODE =5 and PY.MODULENR =7 then ‘Banka A\u00e7\u0131l\u0131\u015f Fi\u015fi’
\nwhen PY.TRCODE =6 and PY.MODULENR =7 then ‘Banka Kur Fark\u0131 Fi\u015fi’
\nwhen PY.TRCODE =7 and PY.MODULENR =7 then ‘D\u00f6viz Al\u0131\u015f Belgesi’
\nwhen PY.TRCODE =8 and PY.MODULENR =7 then ‘D\u00f6viz Sat\u0131\u015f Belgesi’
\nwhen PY.TRCODE =16 and PY.MODULENR =7 then ‘Banka Al\u0131nan Hizmet Faturas\u0131’
\nwhen PY.TRCODE =17 and PY.MODULENR =7 then ‘Banka Verilen Hizmet Faturas\u0131’
\nwhen PY.TRCODE =18 and PY.MODULENR =7 then ‘Bankadan \u00c7ek \u00d6demesi’
\nwhen PY.TRCODE =19 and PY.MODULENR =7 then ‘Bankadan Senet \u00d6demesi’
\nwhen PY.TRCODE =1 and PY.MODULENR =5 then ‘Nakit Tahsilat’
\nwhen PY.TRCODE =2 and PY.MODULENR =5 then ‘Nakit \u00d6deme’
\nwhen PY.TRCODE =3 and PY.MODULENR =5 then ‘Bor\u00e7 Dekontu’
\nwhen PY.TRCODE =4 and PY.MODULENR =5 then ‘Alacak Dekontu’
\nwhen PY.TRCODE =5 and PY.MODULENR =5 then ‘Virman I\u015flemi’
\nwhen PY.TRCODE =6 and PY.MODULENR =5 then ‘Kur Fark\u0131 \u0130\u015flemi’
\nwhen PY.TRCODE =12 and PY.MODULENR =5 then ‘\u00d6zel \u0130\u015flem’
\nwhen PY.TRCODE =20 and PY.MODULENR =5 then ‘Gelen Havaleler’
\nwhen PY.TRCODE =21 and PY.MODULENR =5 then ‘G\u00f6nderilen Havaleler’
\nwhen PY.TRCODE =31 and PY.MODULENR =5 then ‘Mal Al\u0131m Faturas\u0131’
\nwhen PY.TRCODE =32 and PY.MODULENR =5 then ‘Perakende Sat\u0131\u015f \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =24 and PY.MODULENR =5 then ‘D\u00f6viz Al\u0131\u015f Belgesi’
\nwhen PY.TRCODE =25 and PY.MODULENR =5 then ‘D\u00f6viz Sat\u0131\u015f Belgesi’
\nwhen PY.TRCODE =33 and PY.MODULENR =5 then ‘Toptan Sat\u0131\u015f \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =34 and PY.MODULENR =5 then ‘Al\u0131nan Hizmet Faturas\u0131’
\nwhen PY.TRCODE =35 and PY.MODULENR =5 then ‘Al\u0131nan Proforma Faturas\u0131’
\nwhen PY.TRCODE =36 and PY.MODULENR =5 then ‘Al\u0131m \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =37 and PY.MODULENR =5 then ‘Perakende Sat\u0131\u015f Faturas\u0131’
\nwhen PY.TRCODE =38 and PY.MODULENR =5 then ‘Toptan Sat\u0131\u015f Faturas\u0131’
\nwhen PY.TRCODE =39 and PY.MODULENR =5 then ‘Verilen Hizmet Faturas\u0131’
\nwhen PY.TRCODE =40 and PY.MODULENR =5 then ‘Verilen Proforma Faturas\u0131’
\nwhen PY.TRCODE =41 and PY.MODULENR =5 then ‘Verilen Vade Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =42 and PY.MODULENR =5 then ‘Al\u0131nan Vade Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =43 and PY.MODULENR =5 then ‘Al\u0131nan Fiyat Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =44 and PY.MODULENR =5 then ‘Verilen Fiyat Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =46 and PY.MODULENR =5 then ‘Al\u0131nan Ser. Mes. Makbuzu’
\nwhen PY.TRCODE =28 and PY.MODULENR =5 then ‘Banka Al\u0131nan Hizmet Fat.’
\nwhen PY.TRCODE =56 and PY.MODULENR =5 then ‘M\u00fcsthsil Makbuzu’
\nwhen PY.TRCODE =61 and PY.MODULENR =5 then ‘\u00c7ek Giri\u015fi’
\nwhen PY.TRCODE =62 and PY.MODULENR =5 then ‘Senet Giri\u015fi’
\nwhen PY.TRCODE =63 and PY.MODULENR =5 then ‘\u00c7ek \u00c7\u0131k\u0131\u015f Cari Hesaba’
\nwhen PY.TRCODE =64 and PY.MODULENR =5 then ‘Senet \u00c7\u0131k\u0131\u015f Cari Hesaba’
\nwhen PY.TRCODE =70 and PY.MODULENR =5 then ‘Kredi Kart\u0131 Fi\u015fi’
\nwhen PY.TRCODE =72 and PY.MODULENR =5 then ‘Firma Kredi Kart\u0131 Fi\u015fi’
\nwhen PY.TRCODE =71 and PY.MODULENR =5 then ‘Kredi Kart\u0131 \u0130ade Fi\u015fi’
\nwhen PY.TRCODE =14 and PY.MODULENR =5 then ‘A\u00e7\u0131l\u0131\u015f Fi\u015fi’
\nwhen PY.TRCODE =2 and PY.MODULENR =4 then ‘Perakende Sat\u0131\u015f \u0130ade’
\nwhen PY.TRCODE =3 and PY.MODULENR =4 then ‘Toptan Sat\u0131\u015f \u0130ade’
\nwhen PY.TRCODE =7 and PY.MODULENR =4 then ‘Perakede Sat\u0131\u015f Faturas\u0131’
\nwhen PY.TRCODE =8 and PY.MODULENR =4 then ‘Toptan Sat\u0131\u015f Faturas\u0131’
\nwhen PY.TRCODE =9 and PY.MODULENR =4 then ‘Verilen Hizmet Faturas\u0131’
\nwhen PY.TRCODE =10 and PY.MODULENR =4 then ‘Verilen Proforma Faturas\u0131’
\nwhen PY.TRCODE =14 and PY.MODULENR =4 then ‘Verilen Fiyat Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =1 and PY.MODULENR =4 then ‘Mal Al\u0131m Faturas\u0131’
\nwhen PY.TRCODE =4 and PY.MODULENR =4 then ‘Al\u0131nan Hizmet Faturas\u0131’
\nwhen PY.TRCODE =5 and PY.MODULENR =4 then ‘Al\u0131nan Proforma Faturas\u0131’
\nwhen PY.TRCODE =6 and PY.MODULENR =4 then ‘Al\u0131m \u0130ade Faturas\u0131’
\nwhen PY.TRCODE =13 and PY.MODULENR =4 then ‘Al\u0131nan Fiyat Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =41 and PY.MODULENR =4 then ‘Verilen Vade Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =42 and PY.MODULENR =4 then ‘Al\u0131nan Vade Fark\u0131 Faturas\u0131’
\nwhen PY.TRCODE =26 and PY.MODULENR =4 then ‘M\u00fcstahsil Makbuzu’
\nwhen PY.TRCODE =1 and PY.MODULENR =3 then ‘\u00d6demeli Sat\u0131\u015f Sipari\u015fi’
\nwhen PY.TRCODE =2 and PY.MODULENR =3 then ‘\u00d6demeli Sat\u0131nalma Sipari\u015fi’
\nwhen PY.TRCODE =3 and PY.MODULENR =61 then ‘Bor\u00e7 Dekontu’
\nwhen PY.TRCODE =4 and PY.MODULENR =61 then ‘Alacak Dekontu’
\nEND AS ‘FIS TURU’,<\/p>\n

CASE
\nwhen PY.TRCODE =1 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =2 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =11 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =12 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =21 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =12 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =31 and PY.MODULENR=10 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =32 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =33 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =34 and PY.MODULENR=10 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =35 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =36 and PY.MODULENR=10 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =37 and PY.MODULENR=10 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =38 and PY.MODULENR=10 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =39 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =41 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =42 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =61 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =62 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =63 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =64 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =71 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =72 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =73 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =74 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =75 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =76 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =77 and PY.MODULENR=10 then ‘BOS’
\nwhen PY.TRCODE =1 and PY.MODULENR =6 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =2 and PY.MODULENR =6 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =3 and PY.MODULENR =6 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =4 and PY.MODULENR =6 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =5 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =6 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =7 and PY.MODULENR =6 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =8 and PY.MODULENR =6 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =9 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =10 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =11 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =12 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =13 and PY.MODULENR =6 then ‘BOS’
\nwhen PY.TRCODE =1 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =2 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =3 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =4 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =5 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =6 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =7 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =8 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =16 and PY.MODULENR =7 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =17 and PY.MODULENR =7 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =18 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =19 and PY.MODULENR =7 then ‘BOS’
\nwhen PY.TRCODE =1 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =2 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =3 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =4 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =5 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =6 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =12 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =20 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =21 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =31 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =32 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =24 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =25 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =33 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =34 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =35 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =36 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =37 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =38 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =39 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =40 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =41 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =42 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =43 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =44 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =46 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =28 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =56 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =61 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =62 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =63 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =64 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =70 and PY.MODULENR =5 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =72 and PY.MODULENR =5 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =71 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =14 and PY.MODULENR =5 then ‘BOS’
\nwhen PY.TRCODE =2 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =3 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =7 and PY.MODULENR =4 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =8 and PY.MODULENR =4 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =9 and PY.MODULENR =4 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =10 and PY.MODULENR =4 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =14 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =1 and PY.MODULENR =4 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =4 and PY.MODULENR =4 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =5 and PY.MODULENR =4 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =6 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =13 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =41 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =42 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =26 and PY.MODULENR =4 then ‘BOS’
\nwhen PY.TRCODE =1 and PY.MODULENR =3 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =2 and PY.MODULENR =3 then ‘\u00d6DEMELER’
\nwhen PY.TRCODE =3 and PY.MODULENR =61 then ‘TAHS\u0130LATLAR’
\nwhen PY.TRCODE =4 and PY.MODULENR =61 then ‘\u00d6DEMELER’
\nEND AS ‘TURU’,
\nCase When Crossref=0 then ‘Kapanmam\u0131\u015f’ When Crossref<>0 then ‘kapanm\u0131\u015f’ end as KapanmaDurumu<\/p>\n

FROM LG_001_01_PAYTRANS PY INNER JOIN LG_001_CLCARD CL ON PY.CARDREF=CL.LOGICALREF<\/p>\n

–where PY.PAID NOT BETWEEN PY.TOTAL-1 AND PY.TOTAL+1<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT CL.CODE,CL.DEFINITION_,PY.CARDREF,PY.CLOSINGRATE,PY.DATE_,PY.PAYNO,PY.MODULENR,PY.TRCODE,PY.TOTAL, CASE when PY.TRCODE =1 and PY.MODULENR=10 then ‘Nakit Tahsilat’ when PY.TRCODE =2 and PY.MODULENR=10 then ‘Nakit \u00d6deme’ when PY.TRCODE =11 and PY.MODULENR=10 then ‘Cari Hesap Tahsilat’<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-869","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=869"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/869\/revisions"}],"predecessor-version":[{"id":870,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/869\/revisions\/870"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}