Cari Hareket Dökümü

sql wiew biliyosan ve bunu excele almayi biliyorsan özet tablo olarak almani öneririm

 

view komutu gönderiyorum

 

SELECT     dbo.TBLCASABIT.CARI_KOD, dbo.TBLCASABIT.CARI_TIP, dbo.TBLCASABIT.CARI_ISIM, dbo.TBLCASABIT.GRUP_KODU,
                      dbo.TBLCASABIT.RAPOR_KODU1, dbo.TBLCASABIT.RAPOR_KODU2, dbo.TBLCASABIT.RAPOR_KODU3, dbo.TBLCASABIT.RAPOR_KODU4,
                      dbo.TBLCASABIT.RAPOR_KODU5, dbo.TBLCASABIT.EMAIL, dbo.TBLCASABIT.WEB, dbo.TBLCASABIT.SUBE_KODU, dbo.TBLCASABIT.ISLETME_KODU,
                      dbo.TBLCASABIT.CARI_IL, dbo.TBLCASABIT.CARI_ILCE, dbo.TBLCASABIT.CARI_ADRES, dbo.TBLCASABIT.CARI_TEL, dbo.TBLCASABIT.POSTAKODU,
                      dbo.TBLCASABIT.ULKE_KODU, dbo.TBLCASABIT.CM_RAP_TARIH, dbo.TBLCASABIT.HESAPTUTMASEKLI, dbo.TBLCASABIT.CM_BORCT,
                      dbo.TBLCASABIT.CM_ALACT, dbo.TBLCASABIT.CM_BORCT + dbo.TBLCASABIT.CM_ALACT AS BTAT,
                      (CASE WHEN TBLCASABIT.CM_BORCT > TBLCASABIT.CM_ALACT THEN TBLCASABIT.CM_BORCT - TBLCASABIT.CM_ALACT ELSE 0 END) AS BORCBAK,
                       (CASE WHEN TBLCASABIT.CM_BORCT < TBLCASABIT.CM_ALACT THEN TBLCASABIT.CM_ALACT - TBLCASABIT.CM_BORCT ELSE 0 END) AS ALACBAK,
                      (CASE WHEN TBLCASABIT.CM_BORCT > TBLCASABIT.CM_ALACT THEN TBLCASABIT.CM_BORCT - TBLCASABIT.CM_ALACT ELSE 0 END)
                      + (CASE WHEN TBLCASABIT.CM_BORCT < TBLCASABIT.CM_ALACT THEN TBLCASABIT.CM_ALACT - TBLCASABIT.CM_BORCT ELSE 0 END) AS BABAK,
                      dbo.TBLCASABIT.PLASIYER_KODU, dbo.TBLCASABIT.KOSULKODU, dbo.TBLCASABIT.ISKONTO_ORANI, dbo.TBLCASABIT.VADE_GUNU,
                      dbo.TBLCASABIT.LISTE_FIATI, dbo.TBLCASABIT.M_KOD, dbo.TBLCASABIT.DOVIZ_TIPI, dbo.TBLCASABITEK.KULL1S, dbo.TBLCASABITEK.KULL2S,
                      dbo.TBLCASABITEK.KULL3S, dbo.TBLCASABITEK.KULL4S, dbo.TBLCASABITEK.KULL5S, dbo.TBLCASABITEK.KULL6S, dbo.TBLCASABITEK.KULL7S,
                      dbo.TBLCASABITEK.KULL8S, dbo.TBLCASABITEK.KULL1N, dbo.TBLCASABITEK.KULL2N, dbo.TBLCASABITEK.KULL3N, dbo.TBLCASABITEK.KULL4N,
                      dbo.TBLCASABITEK.KULL5N, dbo.TBLCASABITEK.KULL6N, dbo.TBLCASABITEK.KULL7N, dbo.TBLCASABITEK.KULL8N, dbo.TBLCASABIT.ACIK1,
                      dbo.TBLCASABIT.ACIK2, dbo.TBLCASABIT.ACIK3, dbo.TBLCASABIT.VERGI_DAIRESI, dbo.TBLCASABIT.VERGI_NUMARASI, dbo.TBLCASABIT.FAX,
                      dbo.TBLCASABIT.NAKLIYE_KATSAYISI, dbo.TBLCASABIT.S_YEDEK1, dbo.TBLCASABIT.S_YEDEK2, dbo.TBLCASABIT.F_YEDEK1,
                      dbo.TBLCASABIT.F_YEDEK2, dbo.TBLCASABIT.C_YEDEK1, dbo.TBLCASABIT.C_YEDEK2, dbo.TBLCASABIT.B_YEDEK1, dbo.TBLCASABIT.I_YEDEK1,
                      dbo.TBLCASABIT.L_YEDEK1, dbo.TBLCASABIT.FIYATGRUBU, dbo.TBLCASABITEK.I_YEDEK1 AS CEI_YEDEK1, dbo.TBLCASABIT.DOVIZLIMI,
                      dbo.TBLMUPLAN.HS_ADI, dbo.TBLCASABIT.ODEMETIPI, dbo.TBLCASABIT.KURFARKIBORC, dbo.TBLCASABIT.KURFARKIALAC,
                      dbo.TBLCASABIT.MUSTERIBAZIKDV, dbo.TBLCASABITEK.S_YEDEK1 AS CES_YEDEK1, dbo.TBLCASABITEK.ODEKOD,
                      dbo.TBLCASABITEK.TCKIMLIKNO
FROM         dbo.TBLCASABIT INNER JOIN
                      dbo.TBLCASABITEK ON dbo.TBLCASABIT.CARI_KOD = dbo.TBLCASABITEK.CARI_KOD LEFT OUTER JOIN
                      dbo.TBLMUPLAN ON dbo.TBLCASABIT.M_KOD = dbo.TBLMUPLAN.HESAP_KODU