--AYLARA GÖRE CARİ - İŞLEMTÜRÜ ANALİZİ
--BU RAPORU CARİ KARTLARA GİRERKEN GELECEL BUTONLAR ALTINA KOYALIM.
 --sp_SN_Cari_IslemTuru_Analizi 1
ALTER PROC sp_SN_Cari_IslemTuru_Analizi @MUSNO INT
AS 

SELECT        AMUSTERI.MUSNO, AMUSTERI.MUSKOD, AMUSTERI.MUSADI, AMUSTERI.YETKILI, AMUSTERI.MUSTEL TEL_1,AMUSTERI.MUSCEP CEP_TEL, ACARI.BAACIKLA AS İşlemTürü, YEAR(ACARI.TARIH) AS YIL, MONTH(ACARI.TARIH) AS AY, 
                         SUM(ACARI.BORC + ACARI.ALACAK) AS TUTAR, AMUSTERI.MUSBAKIYE AS BAKİYESİ ,AMUSTERI.RISK AS RISK_LIMITI,  AMUSTERI.SaticiKodu, AMUSTERI.SaticiAdi, AMUSTERI.MUSIL, AMUSTERI.MUSILCE, AMUSTERI.Mah_Koyu, AMUSTERI.OZELKOD1, AMUSTERI.OZELKOD2, 
                         AMUSTERI.OZELKOD3, AMUSTERI.OZELKOD4, AMUSTERI.Tipi
FROM            ACARI INNER JOIN
                         AMUSTERI ON ACARI.MUSNO = AMUSTERI.MUSNO  WHERE AMUSTERI.MUSNO=@MUSNO 
GROUP BY AMUSTERI.MUSNO, ACARI.BAACIKLA, ACARI.MUSNO, YEAR(ACARI.TARIH), MONTH(ACARI.TARIH), AMUSTERI.MUSKOD, AMUSTERI.MUSADI, AMUSTERI.YETKILI, AMUSTERI.MUSTEL, AMUSTERI.MUSCEP, AMUSTERI.MUSIL, 
                         AMUSTERI.MUSILCE,  AMUSTERI.OZELKOD1, AMUSTERI.OZELKOD2, AMUSTERI.OZELKOD3, AMUSTERI.OZELKOD4, AMUSTERI.Tipi, AMUSTERI.Mah_Koyu, AMUSTERI.SaticiKodu, 
                         AMUSTERI.SaticiAdi,AMUSTERI.RISK, AMUSTERI.MUSBAKIYE
ORDER BY AMUSTERI.MUSNO, YIL, AY, İşlemTürü