Blog

Aşağıdaki Sorgu ile Logo Banka Hesapları Listesini alabiliriz. CREATE VIEW [dbo].[Umt_039_BankaHesaplari]AS SELECT‘039’ AS FIRMA,BNK.LOGICALREF,BNK.CODE AS BANKAKODU,BNK.DEFINITION_ AS BANKAADI,BNKHS.CODE AS HESAPKODU,BNKHS.DEFINITION_ AS HESAPADI,BNKHS.CURRENCY,CASE WHEN CL.CURCODE IS NULL THEN ‘TL’ ELSE CL.CURCODE END AS DOVIZTIPI, BNFLINE.DATE_ AS TARIH,BNFLINE.LINEEXP AS ACIKLAMA, BNFLINE.SIGN, BNFLINE.TRCODE, BNFLINE.TRCURR, BNFLINE.AMOUNT, BNFLINE.TRRATE,BNFLINE.TRNET, BNFLINE.REPORTRATE, BNFLINE.REPORTNET, BNFLINE.TRANSTYPE,(SELECT EMH.CODEFROM GOPLUS.DBO.LG_039_CRDACREF AS CRD INNER JOINGOPLUS.DBO.LG_039_EMUHACC AS EMH ON…
Devamı

SELECT BNC.CODE + ‘ – ‘ + BNC.DEFINITION_ AS [Banka Kodu – Adı],BNL.DATE_ AS Tarih, BNL.TRANNO AS [İşlem No.],CASE bnl.TRCODEWHEN 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…
Devamı

SELECTT.[CARI_HESAP_KODU],T.ACIKLAMA,T.TARIH,T.FIS_NO,T.FIS_TURU,T.BELGE_NO,T.SATIR_ACIKLAMASI,T.BORC,T.ALACAK,ROUND((SUM(T.Tutar) OVER (ORDER BY NR)),2) AS BAKIYE,T.ISLEM_DOVIZI,T.ISLEM_DOVIZ_TUTARIFROM (SELECT TOP 100 PERCENTROW_NUMBER() OVER (ORDER BY (SELECT 100)) AS NR,CLNTC.CODE [CARI_HESAP_KODU],CLNTC.DEFINITION_ [ACIKLAMA],CTRNS.DATE_ TARIH,CTRNS.TRANNO [FIS_NO],CASE ((CTRNS.MODULENR100)+CTRNS.TRCODE) WHEN 381 THEN ‘Satış Siparişi’ WHEN 382 THEN ‘Satınalma Siparişi’ WHEN 431 THEN ‘Satın Alma Faturası’ WHEN 432 THEN ‘Perakende Satış İade Faturası’ WHEN 433 THEN ‘Toptan Satış İade Faturası’ WHEN 434…
Devamı