Mikro Cari Hesap Hareket Föyü Toplu

Aşağıdaki sql sorguları ile mikroda bulunan tüm carilere ait cari hareket föyü listesini alabilirsiniz.

Declare @cari varchar(25)
Create Table #CARILIST (cari_kod varchar(25))
Insert Into #CARILIST Select cari_kod From CARI_HESAPLAR
--Cari Föy bilgilerini taşıyacak geçici tabloyu oluşturma
Create Table #CARIFOY_TOPLU
(
[msg_S_0088] int,[#msg_S_0720] int,[#msg_S_0998] int,[#msg_S_0200] varchar(25),[#msg_S_0201] varchar(50),[#msg_S_0879] varchar(50),
[msg_S_0089] datetime,[msg_S_0090] varchar(6),[msg_S_0091] int,[#msg_S_0092] datetime,[#msg_S_0093] varchar(20),[msg_S_0094] varchar(100),
[msg_S_0003] varchar(100),[#msg_S_0158] int,[#msg_S_0096] varchar(50),[#msg_S_1712] int,[msg_S_0118] varchar(25),[msg_S_0119] varchar(50),
[msg_S_0097] varchar(15),[#msg_S_0085] varchar(40),[msg_S_1129] varchar(25),[msg_S_1130] varchar(50),[msg_S_0098] datetime,[msg_S_0099] int,
[#msg_S_0159] int,[#msg_S_0165] float,[msg_S_0100] varchar(25),[msg_S_0101\T] float,[msg_S_0102\T] float,[#msg_S_0103\T] float,[msg_S_1706] float,
[msg_S_1707] float,[#msg_S_0957] float,[msg_S_0104] float,[msg_S_0105\T] float,[msg_S_0106\T] float,[#msg_S_0107\T] float,[msg_S_1708] float,
[msg_S_1709] float,[#msg_S_1714] float,[msg_S_0108] float,[msg_S_0109\T] float,[msg_S_0110\T] float,[#msg_S_0111\T] float,[msg_S_1710] float,
[msg_S_1711] float,[#msg_S_1715] float,[msg_S_0112] varchar(10),[msg_S_0113] varchar(50),[msg_S_0114] varchar(25),[msg_S_0115] varchar(50),[#msg_S_1115] varchar(50),
[msg_S_1420] varchar(25),[msg_S_1116] varchar(50),[#msg_S_0116] varchar(50),[#msg_S_0117] varchar(50),[#msg_S_0298] varchar(50),[#msg_S_0120] varchar(15),
[#msg_S_0161] varchar(25),[#msg_S_0162] int,[#msg_S_1998] varchar(25),[#msg_S_1999] varchar(50)
)
While (Select COUNT(*) From #CARILIST) > 0
Begin
Select TOP 1 @cari = cari_kod From #CARILIST
Delete #CARILIST Where cari_kod = @cari
--Cari Föy bilgilerini taşıyacak geçici tabloya Standart cari föyden gelen değerleri ekleme işlemleri
INSERT INTO #CARIFOY_TOPLU
Select
[msg_S_0088], [#msg_S_0720], [#msg_S_0998], [#msg_S_0200], [#msg_S_0201], [#msg_S_0879],
--KAYIT NO DBCNO DATABASE NO CARİ KODU CARİ İSMİ FİRMA UNVANI
[msg_S_0089], [msg_S_0090], [msg_S_0091], [#msg_S_0092], [#msg_S_0093], [msg_S_0094],
--TARİH SERİ SIRA BELGE TARİHİ BELGE NO EVRAK TİPİ
[msg_S_0003], [#msg_S_0158], [#msg_S_0096], [#msg_S_1712], [msg_S_0118], [msg_S_0119],
--CİNSİ HAREKET CİNSİ GRUBU CARİ HESAP GRUP NO SRM.MRK.KODU SRM.MRK.İSMİ
[msg_S_0097], [#msg_S_0085], [msg_S_1129], [msg_S_1130], [msg_S_0098], [msg_S_0099],
--N/İ AÇIKLAMA SORUMLU KODU SORUMLU İSMİ VADE TARİH VADE GÜN
[#msg_S_0159], [#msg_S_0165], [msg_S_0100], [msg_S_0101\T], [msg_S_0102\T], [#msg_S_0103\T],
--DEPO MİKTAR B/A ANA DÖVİZ BORÇ ANA DÖVİZ ALACAK ANA DÖVİZ TUTAR
[msg_S_1706], [msg_S_1707], [#msg_S_0957], [msg_S_0104], [msg_S_0105\T], [msg_S_0106\T],
--ANA DÖV.BORÇ ANA DÖV. ALACAK ANA DÖVİZ BAKİYE ALT.DOVİZ KUR ALT. DÖVİZ BORÇ ALT. DÖVİZ ALACAK
[#msg_S_0107\T],[msg_S_1708], [msg_S_1709], [#msg_S_1714], [msg_S_0108], [msg_S_0109\T],
-- ALT.DÖV.TUT. Alt.Döv.BORÇ Alt.DÖV. ALACAK Alt. DÖVİZ BAKİYE ORJ.DOVİZ KUR ORJ. DÖVİZ BORÇ
[msg_S_0110\T], [#msg_S_0111\T], [msg_S_1710], [msg_S_1711], [#msg_S_1715], [msg_S_0112],
--ORJ.DÖV. ALC. ORJ. DÖVİZ TUTAR ORJ.DÖV.BORÇ ORJ.DÖV.ALACAK ORJ.DÖVİZ BAKİYE ORJ.DOVİZ
[msg_S_0113], [msg_S_0114], [msg_S_0115], [#msg_S_1115], [msg_S_1420], [msg_S_1116],
--KARŞI H.CİNSİ KARŞI HESAP KODU KARŞI HESAP İSMİ GRUBU SRM.MRK.KODU SRM.MRK.İSMİ
[#msg_S_0116], [#msg_S_0117], [#msg_S_0298], [#msg_S_0120], [#msg_S_0161], [#msg_S_0162],
--PROJE KODU PROJE ADI REFERANS NO KİLİTLİ PARTİ LOT
[#msg_S_1998], [#msg_S_1999] --CİRO CARİ KOD Ciro Cari Ünvan
From dbo.fn_CariFoy (N'0',0,@cari,NULL,'20151231','20160101','20171231',0,N'')
End
Select * From #CARIFOY_TOPLU
--DROP TABLE #CARIFOY_TOPLU
--DROP TABLE #CARILIST