Mikro Cari Hesap Hareket Föyü Toplu

Want create site? Find Free WordPress Themes and plugins.

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

Did you find apk for android? You can find new Free Android Games and apps.
Metin Oktay POLAT

Author Metin Oktay POLAT

More posts by Metin Oktay POLAT

Join the discussion 5 Comments

Leave a Reply to Şenol Cancel Reply