{"id":738,"date":"2015-02-13T17:13:42","date_gmt":"2015-02-13T15:13:42","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=738"},"modified":"2015-10-16T17:38:49","modified_gmt":"2015-10-16T14:38:49","slug":"logo-banka-hesap-hareketleri-rapor-sorgusu","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-banka-hesap-hareketleri-rapor-sorgusu\/","title":{"rendered":"LOGO Banka Hesap Hareketleri Rapor Sorgusu"},"content":{"rendered":"


\nSELECT\u00a0BNC<\/span>.<\/span>CODE\u00a0<\/span>+<\/span>\u00a0<\/span>‘\u00a0–\u00a0‘<\/span>\u00a0<\/span>+<\/span>\u00a0BNC<\/span>.<\/span>DEFINITION_\u00a0AS\u00a0<\/span>[<\/span>Banka\u00a0Kodu\u00a0<\/span>–<\/span>\u00a0Ad\u0131<\/span>],<\/span>
\nBNL<\/span>.<\/span>DATE_\u00a0AS\u00a0Tarih<\/span>,<\/span>\u00a0BNL<\/span>.<\/span>TRANNO\u00a0AS\u00a0<\/span>[<\/span>\u0130\u015flem\u00a0No<\/span>.],<\/span>
\nCASE\u00a0bnl<\/span>.<\/span>TRCODE
\nWHEN\u00a01\u00a0THEN\u00a0<\/span>‘Banka\u00a0\u0130\u015flem\u00a0Fi\u015fi’<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a02\u00a0THEN\u00a0<\/span>‘Banka\u00a0Virman\u00a0Fi\u015fi’<\/span>
\nWHEN\u00a03\u00a0THEN\u00a0<\/span>‘Gelen\u00a0Havale-EFT’<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a04\u00a0THEN\u00a0<\/span>‘G\u00f6nderilen\u00a0EFT\/Havale’<\/span>
\nWHEN\u00a05\u00a0THEN\u00a0<\/span>‘Banka\u00a0A\u00e7\u0131l\u0131\u015f\u00a0Fi\u015fi’<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a06\u00a0THEN\u00a0<\/span>‘Banka\u00a0Kur\u00a0Fark\u0131\u00a0Fi\u015fi’<\/span>
\nWHEN\u00a016\u00a0THEN\u00a0<\/span>‘Banka\u00a0Al\u0131nan\u00a0Hizmet\u00a0Faturas\u0131’<\/span>\u00a0\u00a0\u00a0WHEN\u00a017\u00a0THEN\u00a0<\/span>‘Banka\u00a0Verilen\u00a0Hizmet\u00a0Faturas\u0131’<\/span>
\nWHEN\u00a018\u00a0THEN\u00a0<\/span>‘Bankadan\u00a0\u00c7ek\u00a0\u00d6demesi’<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a019\u00a0THEN\u00a0<\/span>‘Bankadan\u00a0Senet\u00a0\u00d6demesi’<\/span>
\nEND\u00a0AS\u00a0<\/span>[<\/span>\u0130\u015flem\u00a0T\u00fcr\u00fc<\/span>],<\/span>
\n<\/span>(<\/span>SELECT\u00a0CODE\u00a0FROM\u00a0LG_223_BANKACC\u00a0WHERE\u00a0LOGICALREF<\/span>=<\/span>BNL<\/span>.<\/span>BNACCREF<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Hesap\u00a0Kodu<\/span>],<\/span>
\nBNL<\/span>.<\/span>LINEEXP\u00a0AS\u00a0<\/span>[<\/span>\u0130\u015flem\u00a0A\u00e7\u0131klamas\u0131<\/span>],<\/span>
\nISNULL<\/span>(<\/span>CASE\u00a0WHEN\u00a0BNL<\/span>.<\/span>SIGN\u00a0<\/span>=<\/span>\u00a00\u00a0AND\u00a0BNL<\/span>.<\/span>TRCURR\u00a0<\/span>=<\/span>\u00a00\u00a0THEN\u00a0BNL<\/span>.<\/span>TRNET\u00a0END<\/span>,<\/span>\u00a00<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Bor\u00e7\u00a0TL<\/span>],<\/span>
\nISNULL<\/span>(<\/span>CASE\u00a0WHEN\u00a0BNL<\/span>.<\/span>SIGN\u00a0<\/span>=<\/span>\u00a01\u00a0AND\u00a0BNL<\/span>.<\/span>TRCURR\u00a0<\/span>=<\/span>\u00a00\u00a0THEN\u00a0BNL<\/span>.<\/span>TRNET\u00a0END<\/span>,<\/span>\u00a00<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Alacak\u00a0TL<\/span>],<\/span>
\nISNULL<\/span>(<\/span>CASE\u00a0WHEN\u00a0BNL<\/span>.<\/span>SIGN\u00a0<\/span>=<\/span>\u00a00\u00a0AND\u00a0BNL<\/span>.<\/span>TRCURR\u00a0<\/span>=<\/span>\u00a01\u00a0THEN\u00a0BNL<\/span>.<\/span>TRNET\u00a0END<\/span>,<\/span>\u00a00<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Bor\u00e7\u00a0<\/span>$],<\/span>
\nISNULL<\/span>(<\/span>CASE\u00a0WHEN\u00a0BNL<\/span>.<\/span>SIGN\u00a0<\/span>=<\/span>\u00a01\u00a0AND\u00a0BNL<\/span>.<\/span>TRCURR\u00a0<\/span>=<\/span>\u00a01\u00a0THEN\u00a0BNL<\/span>.<\/span>TRNET\u00a0END<\/span>,<\/span>\u00a00<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Alacak\u00a0<\/span>$],<\/span>
\nISNULL<\/span>(<\/span>CASE\u00a0WHEN\u00a0BNL<\/span>.<\/span>SIGN\u00a0<\/span>=<\/span>\u00a00\u00a0AND\u00a0BNL<\/span>.<\/span>TRCURR\u00a0<\/span>=<\/span>\u00a020\u00a0THEN\u00a0BNL<\/span>.<\/span>TRNET\u00a0END<\/span>,<\/span>\u00a00<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Bor\u00e7\u00a0\u20ac<\/span>],<\/span>
\nISNULL<\/span>(<\/span>CASE\u00a0WHEN\u00a0BNL<\/span>.<\/span>SIGN\u00a0<\/span>=<\/span>\u00a01\u00a0AND\u00a0BNL<\/span>.<\/span>TRCURR\u00a0<\/span>=<\/span>\u00a020\u00a0THEN\u00a0BNL<\/span>.<\/span>TRNET\u00a0END<\/span>,<\/span>\u00a00<\/span>)<\/span>\u00a0AS\u00a0<\/span>[<\/span>Alacak\u00a0\u20ac<\/span>]
\n<\/span>FROM\u00a0LG_223_BNCARD\u00a0AS\u00a0BNC
\nLEFT\u00a0OUTER\u00a0JOIN\u00a0LG_223_01_BNFLINE\u00a0AS\u00a0BNL\u00a0ON\u00a0BNC<\/span>.<\/span>LOGICALREF\u00a0<\/span>=<\/span>\u00a0BNL<\/span>.<\/span>BANKREF
\nLEFT\u00a0OUTER\u00a0JOIN\u00a0LG_223_01_BNFICHE\u00a0AS\u00a0BNF\u00a0ON\u00a0BNF<\/span>.<\/span>LOGICALREF\u00a0<\/span>=<\/span>\u00a0BNL<\/span>.<\/span>SOURCEFREF
\nWHERE\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>(<\/span>BNL<\/span>.<\/span>TRCODE\u00a0IN\u00a0<\/span>(<\/span>1<\/span>,<\/span>\u00a02<\/span>,<\/span>\u00a03<\/span>,<\/span>\u00a04<\/span>,<\/span>\u00a05<\/span>,<\/span>\u00a06<\/span>,<\/span>\u00a016<\/span>,<\/span>\u00a017<\/span>,<\/span>\u00a018<\/span>,<\/span>\u00a019<\/span>))<\/span>\u00a0AND\u00a0<\/span>(<\/span>BNL<\/span>.<\/span>TRANSTYPE\u00a0NOT\u00a0IN\u00a0<\/span>(<\/span>3<\/span>,<\/span>2<\/span>))<\/span>\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT\u00a0BNC.CODE\u00a0+\u00a0‘\u00a0–\u00a0‘\u00a0+\u00a0BNC.DEFINITION_\u00a0AS\u00a0[Banka\u00a0Kodu\u00a0–\u00a0Ad\u0131], BNL.DATE_\u00a0AS\u00a0Tarih,\u00a0BNL.TRANNO\u00a0AS\u00a0[\u0130\u015flem\u00a0No.], CASE\u00a0bnl.TRCODE WHEN\u00a01\u00a0THEN\u00a0‘Banka\u00a0\u0130\u015flem\u00a0Fi\u015fi’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a02\u00a0THEN\u00a0‘Banka\u00a0Virman\u00a0Fi\u015fi’ WHEN\u00a03\u00a0THEN\u00a0‘Gelen\u00a0Havale-EFT’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a04\u00a0THEN\u00a0‘G\u00f6nderilen\u00a0EFT\/Havale’ WHEN\u00a05\u00a0THEN\u00a0‘Banka\u00a0A\u00e7\u0131l\u0131\u015f\u00a0Fi\u015fi’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a06\u00a0THEN\u00a0‘Banka\u00a0Kur\u00a0Fark\u0131\u00a0Fi\u015fi’ WHEN\u00a016\u00a0THEN\u00a0‘Banka\u00a0Al\u0131nan\u00a0Hizmet\u00a0Faturas\u0131’\u00a0\u00a0\u00a0WHEN\u00a017\u00a0THEN\u00a0‘Banka\u00a0Verilen\u00a0Hizmet\u00a0Faturas\u0131’ WHEN\u00a018\u00a0THEN\u00a0‘Bankadan\u00a0\u00c7ek\u00a0\u00d6demesi’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN\u00a019\u00a0THEN\u00a0‘Bankadan\u00a0Senet\u00a0\u00d6demesi’ END\u00a0AS\u00a0[\u0130\u015flem\u00a0T\u00fcr\u00fc], (SELECT\u00a0CODE\u00a0FROM\u00a0LG_223_BANKACC\u00a0WHERE\u00a0LOGICALREF=BNL.BNACCREF)\u00a0AS\u00a0[Hesap\u00a0Kodu], BNL.LINEEXP\u00a0AS\u00a0[\u0130\u015flem\u00a0A\u00e7\u0131klamas\u0131], ISNULL(CASE\u00a0WHEN\u00a0BNL.SIGN\u00a0=\u00a00\u00a0AND\u00a0BNL.TRCURR\u00a0=\u00a00\u00a0THEN\u00a0BNL.TRNET\u00a0END,\u00a00)\u00a0AS\u00a0[Bor\u00e7\u00a0TL], ISNULL(CASE\u00a0WHEN\u00a0BNL.SIGN\u00a0=\u00a01\u00a0AND\u00a0BNL.TRCURR\u00a0=\u00a00\u00a0THEN\u00a0BNL.TRNET\u00a0END,\u00a00)\u00a0AS\u00a0[Alacak\u00a0TL], ISNULL(CASE\u00a0WHEN\u00a0BNL.SIGN\u00a0=\u00a00\u00a0AND\u00a0BNL.TRCURR\u00a0=\u00a01\u00a0THEN\u00a0BNL.TRNET\u00a0END,\u00a00)\u00a0AS\u00a0[Bor\u00e7\u00a0$], ISNULL(CASE\u00a0WHEN\u00a0BNL.SIGN\u00a0=\u00a01\u00a0AND\u00a0BNL.TRCURR\u00a0=\u00a01\u00a0THEN\u00a0BNL.TRNET\u00a0END,\u00a00)\u00a0AS\u00a0[Alacak\u00a0$], ISNULL(CASE\u00a0WHEN\u00a0BNL.SIGN\u00a0=\u00a00\u00a0AND\u00a0BNL.TRCURR\u00a0=\u00a020\u00a0THEN\u00a0BNL.TRNET\u00a0END,\u00a00)\u00a0AS\u00a0[Bor\u00e7\u00a0\u20ac], ISNULL(CASE\u00a0WHEN\u00a0BNL.SIGN\u00a0=\u00a01\u00a0AND\u00a0BNL.TRCURR\u00a0=\u00a020\u00a0THEN\u00a0BNL.TRNET\u00a0END,\u00a00)\u00a0AS\u00a0[Alacak\u00a0\u20ac] FROM\u00a0LG_223_BNCARD\u00a0AS\u00a0BNC LEFT\u00a0OUTER\u00a0JOIN\u00a0LG_223_01_BNFLINE\u00a0AS\u00a0BNL\u00a0ON\u00a0BNC.LOGICALREF\u00a0=\u00a0BNL.BANKREF LEFT\u00a0OUTER\u00a0JOIN\u00a0LG_223_01_BNFICHE\u00a0AS\u00a0BNF\u00a0ON\u00a0BNF.LOGICALREF\u00a0=\u00a0BNL.SOURCEFREF WHERE\u00a0\u00a0\u00a0\u00a0\u00a0(BNL.TRCODE\u00a0IN\u00a0(1,\u00a02,\u00a03,\u00a04,\u00a05,\u00a06,\u00a016,\u00a017,\u00a018,\u00a019))\u00a0AND\u00a0(BNL.TRANSTYPE\u00a0NOT\u00a0IN\u00a0(3,2))\u00a0<\/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-738","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/738","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=738"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"predecessor-version":[{"id":3632,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/738\/revisions\/3632"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}