Banka Hesap Listesi
Logo Yazılım dan Sql Managent tarafından Banka Hesap Listesi için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT BNC.CODE+'–'+BNC.DEFINITION_ AS [Banka Kodu - Adı], (SELECT CODE FROM LG_001_BANKACC WHERE LOGICALREF=BNL.BNACCREF) AS [Hesap Kodu], (SELECT DEFINITION_ FROM LG_001_BANKACC WHERE LOGICALREF=BNL.BNACCREF) AS [Hesap Adı], CONVERT(nvarchar(50),(BNL.DATE_),103) AS Tarih, BNL.TRANNO AS [İşlem No], CASE bnl.TRCODE WHEN 1 THEN 'Banka İşlem Fişi' WHEN 2 THEN 'Banka Virman Fişi' WHEN 3 THEN 'Gelen Havale-EFT' WHEN 4 THEN 'Gönderilen EFT/Havale' WHEN 5 THEN 'Banka Açılış Fişi' WHEN 6 THEN 'Banka Kur Farkı Fişi' WHEN 16 THEN 'Banka Alınan Hizmet Faturası' WHEN 17 THEN 'Banka Verilen Hizmet Faturası' WHEN 18 THEN 'Bankadan Çek Ödemesi' WHEN 19 THEN 'Bankadan Senet Ödemesi' END AS [İşlem Türü], BNL.LINEEXP AS [İşlem Açıklaması], ISNULL(CASE WHEN BNL.SIGN = 0 AND BNL.TRCURR = 0 THEN BNL.TRNET END, 0) AS [Borç TL], ISNULL(CASE WHEN BNL.SIGN = 1 AND BNL.TRCURR = 0 THEN BNL.TRNET END, 0) AS [Alacak TL], ISNULL(CASE WHEN BNL.SIGN = 0 AND BNL.TRCURR = 1 THEN BNL.TRNET END, 0) AS [Borç $], ISNULL(CASE WHEN BNL.SIGN = 1 AND BNL.TRCURR = 1 THEN BNL.TRNET END, 0) AS [Alacak $], ISNULL(CASE WHEN BNL.SIGN = 0 AND BNL.TRCURR = 20 THEN BNL.TRNET END, 0) AS [Borç €], ISNULL(CASE WHEN BNL.SIGN = 1 AND BNL.TRCURR = 20 THEN BNL.TRNET END, 0) AS [Alacak €] FROM LG_001_BNCARD AS BNC LEFT OUTER JOIN LG_001_01_BNFLINE AS BNL ON BNC.LOGICALREF = BNL.BANKREF LEFT OUTER JOIN LG_001_01_BNFICHE AS BNF ON BNF.LOGICALREF = BNL.SOURCEFREF WHERE (BNL.TRCODE IN (1, 2, 3, 4, 5, 6, 16, 17, 18, 19)) AND (BNL.TRANSTYPE NOT IN (3,2)) AND CONVERT(nvarchar(50),(BNL.DATE_),103) Between '1.01.2016' And '31.12.2100' Order By BNL.DATE_ |
Paylaş:
