ERP Nedir? | Türkiye'nin ERP Forum Platformu : Raporu Almak http://www.erpne.org/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 17 Apr 2026 19:01:53 +0000 Fri, 11 Oct 2013 23:07:34 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.10 360 www.erpne.org/RSS_post_feed.asp?TID=3617 <![CDATA[ERP Nedir? | Türkiye'nin ERP Forum Platformu]]> http://www.erpne.org/forum_images/logotype.png http://www.erpne.org/ <![CDATA[Raporu Almak : Raporumun Son HaliSELECT TOP...]]> http://www.erpne.org/raporu-almak_topic3617_post19401.html#19401 Yazar: social
Konu: 3617
Gönderim Zamanı: 11 Ekim 2013 Saat 23:07

Raporumun Son Hali


SELECT     TOP (100) PERCENT dbo.TBLCARIPLASIYER.PLASIYER_ACIKLAMA, STSABIT.STOK_ADI, CASABIT.CARI_ISIM, STHAR.STHAR_TARIH, 
                      STHAR.FISNO AS STHAR_FISNO, (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * STHAR.STHAR_BF AS BRUTCIKISTUT, 
                      (STHAR.STHAR_BF - STHAR.STHAR_NF * (CASE WHEN FATUIRS.KDV_DAHILMI = 'E' THEN (1 + STHAR.STHAR_KDV / 100) ELSE 1 END)) 
                      * STHAR.STHAR_GCMIK AS ISKONTOTUT, (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * STHAR.STHAR_NF AS NETCIKISTUT, STHAR.STHAR_GCMIK * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS KDV_TUT, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS SATIS_TOPLAM, MONTH(STHAR.STHAR_TARIH) AS AY
FROM         dbo.TBLSTHAR AS STHAR INNER JOIN
                      dbo.TBLSTSABIT AS STSABIT ON STHAR.STOK_KODU = STSABIT.STOK_KODU INNER JOIN
                      dbo.TBLSTOKPARAM AS STOKPARAM WITH (NOLOCK) ON STOKPARAM.ISLETME_KODU = STSABIT.ISLETME_KODU LEFT OUTER JOIN
                      dbo.TBLSTGRUP AS STGRUP ON STSABIT.GRUP_KODU = STGRUP.GRUP_KOD LEFT OUTER JOIN
                      dbo.TBLCASABIT AS CASABIT ON STHAR.STHAR_ACIKLAMA = CASABIT.CARI_KOD INNER JOIN
                      dbo.TBLSTSABITEK AS STSABITEK ON STSABIT.STOK_KODU = STSABITEK.STOK_KODU INNER JOIN
                      dbo.TBLCARIPLASIYER ON STHAR.PLASIYER_KODU = dbo.TBLCARIPLASIYER.PLASIYER_KODU RIGHT OUTER JOIN
                      dbo.TBLFATUIRS AS FATUIRS ON dbo.TBLCARIPLASIYER.PLASIYER_KODU = FATUIRS.PLA_KODU AND 
                      FATUIRS.CARI_KODU = STHAR.STHAR_ACIKLAMA AND STHAR.STHAR_FTIRSIP = FATUIRS.FTIRSIP AND 
                      STHAR.FISNO = FATUIRS.FATIRS_NO LEFT OUTER JOIN
                      dbo.TBLSTOKKOD1 AS STOKKOD1 ON STSABIT.KOD_1 = STOKKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.TBLCARIKOD1 AS CARIKOD1 ON CASABIT.RAPOR_KODU1 = CARIKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.TBLCARIKOD2 AS CARIKOD2 ON CASABIT.RAPOR_KODU2 = CARIKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.TBLSTOKKOD2 AS STOKKOD2 ON STSABIT.KOD_2 = STOKKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.TBLPROJE AS PROJE ON STHAR.PROJE_KODU = PROJE.PROJE_KODU LEFT OUTER JOIN
                      dbo.TBLISKONTIP AS ISKONTIP1 ON STHAR.SATISK1TIP = ISKONTIP1.ISKONTOTIP LEFT OUTER JOIN
                      dbo.TBLISKONTIP AS ISKONTIP2 ON STHAR.SATISK2TIP = ISKONTIP2.ISKONTOTIP LEFT OUTER JOIN
                      dbo.TBLISKONTIP AS ISKONTIP3 ON STHAR.SATISK3TIP = ISKONTIP3.ISKONTOTIP LEFT OUTER JOIN
                      dbo.TBLESNYAPMAS AS ESNYAPMAS WITH (NOLOCK) ON ESNYAPMAS.YAPKOD = STHAR.YAPKOD
WHERE     (STSABIT.GRUP_KODU = 'ISCILIK') AND (STSABIT.KOD_4 IS NULL) AND (dbo.TBLCARIPLASIYER.GRUPKODU = 'KAPORTA')
ORDER BY dbo.TBLCARIPLASIYER.PLASIYER_ACIKLAMA


Düzenleyen social - 12 Ekim 2013 Saat 09:26]]> Fri, 11 Oct 2013 23:07:34 +0000 http://www.erpne.org/raporu-almak_topic3617_post19401.html#19401 <![CDATA[Raporu Almak : ben su sekilde duzenlemi?timplasyyer...]]> http://www.erpne.org/raporu-almak_topic3617_post19400.html#19400 Yazar: social
Konu: 3617
Gönderim Zamanı: 11 Ekim 2013 Saat 23:01

ben su sekilde duzenlemi?tim

plasyyer ady   ---- stok ady----fatura no---tarih---brut çyky? tut.------iskonto tutary----net saty? tutaty---kdv tutar-- toplam tutar(net+kdv)


ahmet mutlu -----50x20 kyrmyzy bayrak-----00000015878-----01.10.2013-------100tl------10tl-------90tl-----18 tl-----108tl

ahmet mutlu -----50x20 turuncu bayrak-----00000015879-----01.10.2013-------118tl------18tl-----100tl-----21,24 tl-----121.24tl

ahmet mutlu----------------------------------218-----28-----190-----39,40------------229.24

erdal ekol------stok ad----......


hocam bu formatda olsun ystyyorum ayryca aratoplamlary farkly renkte kalyn fontda falan alabylyrmyyym

]]> Fri, 11 Oct 2013 23:01:50 +0000 http://www.erpne.org/raporu-almak_topic3617_post19400.html#19400 <![CDATA[Raporu Almak : net saty? tutary+kdv tutary hocam...]]> http://www.erpne.org/raporu-almak_topic3617_post19399.html#19399 Yazar: social
Konu: 3617
Gönderim Zamanı: 11 Ekim 2013 Saat 22:53

net saty? tutary+kdv tutary hocam]]> Fri, 11 Oct 2013 22:53:47 +0000 http://www.erpne.org/raporu-almak_topic3617_post19399.html#19399 <![CDATA[Raporu Almak : siz a?a?ydaki sorugyu bir view...]]> http://www.erpne.org/raporu-almak_topic3617_post19398.html#19398 Yazar: mbaykan
Konu: 3617
Gönderim Zamanı: 11 Ekim 2013 Saat 22:38

siz a?a?ydaki sorugyu bir view yaptyysanyz

SELECT PLASIYER_ACIKLAMA,SUM(BRUTCIKISTUT) BRUT_SATIS,SUM(NETCIKISTUT) NET_SATIS,
SUM(KDV_TUT) KDV
FROM (viewynyz)
WHERE CIKISM>0
GROUP BY PLASIYER_ACIKLAMA
UNION ALL
SELECT 'TOPLAM: ',SUM(BRUTCIKISTUT) BRUT_SATIS,SUM(NETCIKISTUT) NET_SATIS,
SUM(KDV_TUT) KDV
FROM (viewynyz)
WHERE CIKISM>0
GROUP BY PLASIYER_ACIKLAMA


Toplam Saty? neyi ifade ediyor (Plasiyer bazynda)???

]]> Fri, 11 Oct 2013 22:38:53 +0000 http://www.erpne.org/raporu-almak_topic3617_post19398.html#19398 <![CDATA[Raporu Almak : Cok tesekkur ederim,guzel oldu.Bir...]]> http://www.erpne.org/raporu-almak_topic3617_post19397.html#19397 Yazar: social
Konu: 3617
Gönderim Zamanı: 11 Ekim 2013 Saat 20:13

Cok tesekkur ederim,guzel oldu.Bir istegim daha olacak.plasiyer isimlerinin kirilimlarinda bos bir satira brut satis-net satis-kdv ve toplam satis tutarlari gibi toplam aldirarak en sonada butun plssiyerlerin toplamini aldirabiliyim,boyle birsey mumkunmu scaba]]> Fri, 11 Oct 2013 20:13:53 +0000 http://www.erpne.org/raporu-almak_topic3617_post19397.html#19397 <![CDATA[Raporu Almak : CASABIT&#039;in soluna TBLSTSABIT...]]> http://www.erpne.org/raporu-almak_topic3617_post19378.html#19378 Yazar: mbaykan
Konu: 3617
Gönderim Zamanı: 09 Ekim 2013 Saat 22:43

CASABIT'in soluna TBLSTSABIT yazmy?ym do?rusu a?a?yda...

SELECT  THAR.SUBE_KODU, STHAR.STOK_KODU, STSABIT.STOK_ADI, STSABIT.GRUP_KODU AS SGRUP_KODU, 
 STGRUP.GRUP_ISIM AS SGRUP_ISIM, STSABIT.KOD_1 AS SKOD_1, STOKKOD1.GRUP_ISIM AS SKOD1_ISIM, 
 STSABIT.KOD_2 AS SKOD_2, STOKKOD2.GRUP_ISIM AS SKOD2_ISIM, STSABIT.SATICI_KODU, STHAR.STHAR_ACIKLAMA, 
 CASABIT.CARI_ISIM, CASABIT.CARI_TIP, CASABIT.GRUP_KODU AS CGRUP_KODU, CASABIT.RAPOR_KODU1 AS CKOD_1, 
 CARIKOD1.GRUP_ISIM AS CKOD1_ISIM, CASABIT.RAPOR_KODU2 AS CKOD_2, CASABIT.CARI_IL, CASABIT.CARI_ILCE, 
 STHAR.STHAR_HTUR, STHAR.STHAR_KOD1, STHAR.STHAR_KOD2, STHAR.STHAR_TARIH, STHAR.FISNO AS STHAR_FISNO, 
 STHAR.AMBAR_KABULNO, STHAR.IRSALIYE_NO, STHAR.STHAR_ODEGUN, STHAR.STHAR_BF, STHAR.STHAR_NF, 
 STHAR.STHAR_IAF, 
 (STHAR.STHAR_BF - STHAR.STHAR_NF * (CASE WHEN FATUIRS.KDV_DAHILMI = 'E' THEN (1 + STHAR.STHAR_KDV / 100) ELSE 1 END)) 
 * STHAR.STHAR_GCMIK AS ISKONTOTUT, 
 CASE WHEN STHAR.STHAR_SATISK < 0.00100 THEN STHAR.STHAR_SATISK * 100000 ELSE STHAR.STHAR_SATISK END AS STHAR_SATISK, 
 STHAR.STHAR_MALFISK, STSABIT.OLCU_BR1, STSABIT.OLCU_BR2, STSABIT.OLCU_BR3, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS GIRISM, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS GRISIM2, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS GIRISM3, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_NF AS NETGIRISTUT, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_BF AS BRUTGIRISTUT,
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_IAF AS IADEGIRISTUT, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS CIKISM, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS CIKISM2, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS CIKISM3, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_NF AS NETCIKISTUT, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_BF AS BRUTCIKISTUT,
 STHAR.STHAR_KDV, STHAR.STHAR_GCMIK * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS KDV_TUT, 
 STHAR.STHAR_SIPNUM, STHAR.STHAR_DOVTIP, STHAR.STHAR_DOVFIAT, 
 STHAR.STHAR_GCMIK * STHAR.STHAR_DOVFIAT AS DOVIZ_TUTARI, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_GIRIS_MIKTAR, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_CIKIS_MIKTAR, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS ALIS_TOPLAM, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS SATIS_TOPLAM, STHAR.CEVRIM, 
 (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN (STHAR.CEVRIM * STHAR.STHAR_GCMIK * STHAR.STHAR_NF) ELSE 0 END) AS BEKLEME_ADATI, 
 STSABITEK.TUR, STSABITEK.MGRUP AS MRUP, STSABITEK.INGISIM, STSABITEK.KULL1N, STSABITEK.KULL2N, 
 STSABITEK.KULL1S, STSABITEK.KULL2S, STHAR.DEPO_KODU, STHAR.PROMASYON_KODU, STHAR.BAGLANTI_NO, 
 STHAR.VADE_TARIHI, STHAR.LISTE_NO, STHAR.LISTE_FIAT, CARIKOD2.GRUP_ISIM AS CKOD2_ISIM, 
 STHAR.PLASIYER_KODU AS PLAS_KOD, STHAR.PROJE_KODU, STHAR.EKALAN_NEDEN, STHAR.EKALAN, 
 STHAR.EKALAN1 AS EKALAN2, STHAR.MUH_KODU AS MUHKODU, PROJE.PROJE_ACIKLAMA, 
 ISKONTIP1.ACIKLAMA AS ISKONTO1_ACIKLAMA, ISKONTIP2.ACIKLAMA AS ISKONTO2_ACIKLAMA, ISKONTIP3.ACIKLAMA AS ISKONTO3_ACIKLAMA, 
 (CASE WHEN (STSABIT.B_YEDEK7 = 1) OR 
 (STSABIT.B_YEDEK7 = 2) THEN 'E' ELSE 'H' END) AS KITSTOGU, 
 (CASE WHEN STHAR.L_YEDEK9 = - 1 THEN 'K' ELSE (CASE WHEN STHAR.L_YEDEK9 > 0 THEN 'B' ELSE 'N' END) END) AS KITHAREKETI, 
 STSABIT.KOD_3 AS KOD3, STSABIT.KOD_4 AS KOD4, STSABIT.KOD_5 AS KOD5, CASABIT.RAPOR_KODU3 AS CKOD_3, 
 CASABIT.RAPOR_KODU4 AS CKOD_4, CASABIT.RAPOR_KODU5 AS CKOD_5, STHAR.YAPKOD, 
 CASE WHEN STSABIT.YAPILANDIR = 'E' THEN NSF_YAPACIK(STHAR.YAPKOD, STOKPARAM.C_YEDEK8, ESNYAPMAS.YAPACIK) ELSE NULL 
 END AS YAPACIK, TBLCARIPLASIYER.PLASIYER_ACIKLAMA, TBLCARIPLASIYER.ISIM, TBLCARIPLASIYER.GRUPKODU, 
 FATUIRS.CARI_KODU, (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
 * STHAR.STHAR_NF + STHAR.STHAR_GCMIK * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS TOPLAM

FROM   TBLSTHAR  STHAR INNER JOIN
TBLSTSABIT STSABIT ON STHAR.STOK_KODU = STSABIT.STOK_KODU INNER JOIN
-- NETCONTEXT ON 1 = 1 INNER JOIN
TBLSTOKPARAM AS STOKPARAM WITH (NOLOCK) ON STOKPARAM.ISLETME_KODU = STSABIT.ISLETME_KODU LEFT OUTER JOIN
TBLSTGRUP STGRUP ON STSABIT.GRUP_KODU = STGRUP.GRUP_KOD LEFT OUTER JOIN
TBLCASABIT CASABIT ON STHAR.STHAR_ACIKLAMA = CASABIT.CARI_KOD INNER JOIN
TBLSTSABITEK STSABITEK ON STSABIT.STOK_KODU = STSABITEK.STOK_KODU INNER JOIN
TBLCARIPLASIYER ON STHAR.PLASIYER_KODU = TBLCARIPLASIYER.PLASIYER_KODU RIGHT OUTER JOIN
TBLFATUIRS FATUIRS ON TBLCARIPLASIYER.PLASIYER_KODU = FATUIRS.PLA_KODU AND 
FATUIRS.CARI_KODU = STHAR.STHAR_ACIKLAMA AND STHAR.STHAR_FTIRSIP = FATUIRS.FTIRSIP AND STHAR.FISNO = FATUIRS.FATIRS_NO LEFT OUTER JOIN
TBLSTOKKOD1 STOKKOD1 ON STSABIT.KOD_1 = STOKKOD1.GRUP_KOD LEFT OUTER JOIN
TBLCARIKOD1 CARIKOD1 ON CASABIT.RAPOR_KODU1 = CARIKOD1.GRUP_KOD LEFT OUTER JOIN
TBLCARIKOD2 CARIKOD2 ON CASABIT.RAPOR_KODU2 = CARIKOD2.GRUP_KOD LEFT OUTER JOIN
TBLSTOKKOD2 STOKKOD2 ON STSABIT.KOD_2 = STOKKOD2.GRUP_KOD LEFT OUTER JOIN
TBLPROJE PROJE ON STHAR.PROJE_KODU = PROJE.PROJE_KODU LEFT OUTER JOIN
TBLISKONTIP AS ISKONTIP1 ON STHAR.SATISK1TIP = ISKONTIP1.ISKONTOTIP LEFT OUTER JOIN
TBLISKONTIP AS ISKONTIP2 ON STHAR.SATISK2TIP = ISKONTIP2.ISKONTOTIP LEFT OUTER JOIN
TBLISKONTIP AS ISKONTIP3 ON STHAR.SATISK3TIP = ISKONTIP3.ISKONTOTIP LEFT OUTER JOIN
TBLESNYAPMAS AS ESNYAPMAS WITH (NOLOCK) ON ESNYAPMAS.YAPKOD = STHAR.YAPKOD
]]> Wed, 09 Oct 2013 22:43:39 +0000 http://www.erpne.org/raporu-almak_topic3617_post19378.html#19378 <![CDATA[Raporu Almak : hocam olmady invalid column name...]]> http://www.erpne.org/raporu-almak_topic3617_post19366.html#19366 Yazar: social
Konu: 3617
Gönderim Zamanı: 08 Ekim 2013 Saat 16:46

hocam olmady invalid column name hatasy verdy carynyn butun alanlarynda]]> Tue, 08 Oct 2013 16:46:54 +0000 http://www.erpne.org/raporu-almak_topic3617_post19366.html#19366 <![CDATA[Raporu Almak : SELECT STHAR.SUBE_KODU, STHAR.STOK_KODU,...]]> http://www.erpne.org/raporu-almak_topic3617_post19364.html#19364 Yazar: mbaykan
Konu: 3617
Gönderim Zamanı: 08 Ekim 2013 Saat 13:23

SELECT     STHAR.SUBE_KODU, STHAR.STOK_KODU, STSABIT.STOK_ADI, STSABIT.GRUP_KODU AS SGRUP_KODU,
                      STGRUP.GRUP_ISIM AS SGRUP_ISIM, STSABIT.KOD_1 AS SKOD_1, STOKKOD1.GRUP_ISIM AS SKOD1_ISIM,
                      STSABIT.KOD_2 AS SKOD_2, STOKKOD2.GRUP_ISIM AS SKOD2_ISIM, STSABIT.SATICI_KODU, STHAR.STHAR_ACIKLAMA,
                      CASABIT.CARI_ISIM, CASABIT.CARI_TIP, CASABIT.GRUP_KODU AS CGRUP_KODU, CASABIT.RAPOR_KODU1 AS CKOD_1,
                      CARIKOD1.GRUP_ISIM AS CKOD1_ISIM, CASABIT.RAPOR_KODU2 AS CKOD_2, CASABIT.CARI_IL, CASABIT.CARI_ILCE,
                      STHAR.STHAR_HTUR, STHAR.STHAR_KOD1, STHAR.STHAR_KOD2, STHAR.STHAR_TARIH, STHAR.FISNO AS STHAR_FISNO,
                      STHAR.AMBAR_KABULNO, STHAR.IRSALIYE_NO, STHAR.STHAR_ODEGUN, STHAR.STHAR_BF, STHAR.STHAR_NF,
                      STHAR.STHAR_IAF,
                      (STHAR.STHAR_BF - STHAR.STHAR_NF * (CASE WHEN FATUIRS.KDV_DAHILMI = 'E' THEN (1 + STHAR.STHAR_KDV / 100) ELSE 1 END))
                      * STHAR.STHAR_GCMIK AS ISKONTOTUT,
                      CASE WHEN STHAR.STHAR_SATISK < 0.00100 THEN STHAR.STHAR_SATISK * 100000 ELSE STHAR.STHAR_SATISK END AS STHAR_SATISK,
                      STHAR.STHAR_MALFISK, STSABIT.OLCU_BR1, STSABIT.OLCU_BR2, STSABIT.OLCU_BR3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS GIRISM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS GRISIM2,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS GIRISM3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_NF AS NETGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_BF AS BRUTGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_IAF AS IADEGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS CIKISM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS CIKISM2,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS CIKISM3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_NF AS NETCIKISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * STHAR.STHAR_BF AS BRUTCIKISTUT,
                      STHAR.STHAR_KDV, STHAR.STHAR_GCMIK * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS KDV_TUT,
                      STHAR.STHAR_SIPNUM, STHAR.STHAR_DOVTIP, STHAR.STHAR_DOVFIAT,
                      STHAR.STHAR_GCMIK * STHAR.STHAR_DOVFIAT AS DOVIZ_TUTARI,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_GIRIS_MIKTAR,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_CIKIS_MIKTAR,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS ALIS_TOPLAM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS SATIS_TOPLAM, STHAR.CEVRIM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN (STHAR.CEVRIM * STHAR.STHAR_GCMIK * STHAR.STHAR_NF) ELSE 0 END) AS BEKLEME_ADATI,
                      STSABITEK.TUR, STSABITEK.MGRUP AS MRUP, STSABITEK.INGISIM, STSABITEK.KULL1N, STSABITEK.KULL2N,
                      STSABITEK.KULL1S, STSABITEK.KULL2S, STHAR.DEPO_KODU, STHAR.PROMASYON_KODU, STHAR.BAGLANTI_NO,
                      STHAR.VADE_TARIHI, STHAR.LISTE_NO, STHAR.LISTE_FIAT, CARIKOD2.GRUP_ISIM AS CKOD2_ISIM,
                      STHAR.PLASIYER_KODU AS PLAS_KOD, STHAR.PROJE_KODU, STHAR.EKALAN_NEDEN, STHAR.EKALAN,
                      STHAR.EKALAN1 AS EKALAN2, STHAR.MUH_KODU AS MUHKODU, PROJE.PROJE_ACIKLAMA,
                      ISKONTIP1.ACIKLAMA AS ISKONTO1_ACIKLAMA, ISKONTIP2.ACIKLAMA AS ISKONTO2_ACIKLAMA, ISKONTIP3.ACIKLAMA AS ISKONTO3_ACIKLAMA,
                      (CASE WHEN (STSABIT.B_YEDEK7 = 1) OR
                      (STSABIT.B_YEDEK7 = 2) THEN 'E' ELSE 'H' END) AS KITSTOGU,
                      (CASE WHEN STHAR.L_YEDEK9 = - 1 THEN 'K' ELSE (CASE WHEN STHAR.L_YEDEK9 > 0 THEN 'B' ELSE 'N' END) END) AS KITHAREKETI,
                      STSABIT.KOD_3 AS KOD3, STSABIT.KOD_4 AS KOD4, STSABIT.KOD_5 AS KOD5, CASABIT.RAPOR_KODU3 AS CKOD_3,
                      CASABIT.RAPOR_KODU4 AS CKOD_4, CASABIT.RAPOR_KODU5 AS CKOD_5, STHAR.YAPKOD,
                      CASE WHEN STSABIT.YAPILANDIR = 'E' THEN NSF_YAPACIK(STHAR.YAPKOD, STOKPARAM.C_YEDEK8, ESNYAPMAS.YAPACIK) ELSE NULL
                      END AS YAPACIK, TBLCARIPLASIYER.PLASIYER_ACIKLAMA, TBLCARIPLASIYER.ISIM, TBLCARIPLASIYER.GRUPKODU,
                      FATUIRS.CARI_KODU, (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * STHAR.STHAR_NF + STHAR.STHAR_GCMIK * STHAR.STHAR_NF * STHAR.STHAR_KDV / 100 AS TOPLAM

FROM   TBLSTHAR  STHAR INNER JOIN
TBLSTSABIT STSABIT ON STHAR.STOK_KODU = STSABIT.STOK_KODU INNER JOIN
--                      NETCONTEXT ON 1 = 1 INNER JOIN
                     TBLSTOKPARAM AS STOKPARAM WITH (NOLOCK) ON STOKPARAM.ISLETME_KODU = STSABIT.ISLETME_KODU LEFT OUTER JOIN
                 TBLSTGRUP STGRUP ON STSABIT.GRUP_KODU = STGRUP.GRUP_KOD LEFT OUTER JOIN
                    TBLSTSABIT CASABIT ON STHAR.STHAR_ACIKLAMA = CASABIT.CARI_KOD INNER JOIN
                      TBLSTSABITEK STSABITEK ON STSABIT.STOK_KODU = STSABITEK.STOK_KODU INNER JOIN
                      TBLCARIPLASIYER ON STHAR.PLASIYER_KODU = TBLCARIPLASIYER.PLASIYER_KODU RIGHT OUTER JOIN
                      TBLFATUIRS FATUIRS ON TBLCARIPLASIYER.PLASIYER_KODU = FATUIRS.PLA_KODU AND
                      FATUIRS.CARI_KODU = STHAR.STHAR_ACIKLAMA AND STHAR.STHAR_FTIRSIP = FATUIRS.FTIRSIP AND STHAR.FISNO = FATUIRS.FATIRS_NO LEFT OUTER JOIN
                     TBLSTOKKOD1 STOKKOD1 ON STSABIT.KOD_1 = STOKKOD1.GRUP_KOD LEFT OUTER JOIN
                     TBLCARIKOD1 CARIKOD1 ON CASABIT.RAPOR_KODU1 = CARIKOD1.GRUP_KOD LEFT OUTER JOIN
                     TBLCARIKOD2 CARIKOD2 ON CASABIT.RAPOR_KODU2 = CARIKOD2.GRUP_KOD LEFT OUTER JOIN
                     TBLSTOKKOD2 STOKKOD2 ON STSABIT.KOD_2 = STOKKOD2.GRUP_KOD LEFT OUTER JOIN
                     TBLPROJE PROJE ON STHAR.PROJE_KODU = PROJE.PROJE_KODU LEFT OUTER JOIN
                     TBLISKONTIP AS ISKONTIP1 ON STHAR.SATISK1TIP = ISKONTIP1.ISKONTOTIP LEFT OUTER JOIN
                      TBLISKONTIP AS ISKONTIP2 ON STHAR.SATISK2TIP = ISKONTIP2.ISKONTOTIP LEFT OUTER JOIN
                      TBLISKONTIP AS ISKONTIP3 ON STHAR.SATISK3TIP = ISKONTIP3.ISKONTOTIP LEFT OUTER JOIN
                      TBLESNYAPMAS AS ESNYAPMAS WITH (NOLOCK) ON ESNYAPMAS.YAPKOD = STHAR.YAPKOD

]]> Tue, 08 Oct 2013 13:23:11 +0000 http://www.erpne.org/raporu-almak_topic3617_post19364.html#19364 <![CDATA[Raporu Almak : SELECT dbo.STHAR.SUBE_KODU,...]]> http://www.erpne.org/raporu-almak_topic3617_post19362.html#19362 Yazar: social
Konu: 3617
Gönderim Zamanı: 08 Ekim 2013 Saat 08:26

SELECT     dbo.STHAR.SUBE_KODU, dbo.STHAR.STOK_KODU, dbo.STSABIT.STOK_ADI, dbo.STSABIT.GRUP_KODU AS SGRUP_KODU, 
                      dbo.STGRUP.GRUP_ISIM AS SGRUP_ISIM, dbo.STSABIT.KOD_1 AS SKOD_1, dbo.STOKKOD1.GRUP_ISIM AS SKOD1_ISIM, 
                      dbo.STSABIT.KOD_2 AS SKOD_2, dbo.STOKKOD2.GRUP_ISIM AS SKOD2_ISIM, dbo.STSABIT.SATICI_KODU, dbo.STHAR.STHAR_ACIKLAMA, 
                      dbo.CASABIT.CARI_ISIM, dbo.CASABIT.CARI_TIP, dbo.CASABIT.GRUP_KODU AS CGRUP_KODU, dbo.CASABIT.RAPOR_KODU1 AS CKOD_1, 
                      dbo.CARIKOD1.GRUP_ISIM AS CKOD1_ISIM, dbo.CASABIT.RAPOR_KODU2 AS CKOD_2, dbo.CASABIT.CARI_IL, dbo.CASABIT.CARI_ILCE, 
                      dbo.STHAR.STHAR_HTUR, dbo.STHAR.STHAR_KOD1, dbo.STHAR.STHAR_KOD2, dbo.STHAR.STHAR_TARIH, dbo.STHAR.FISNO AS STHAR_FISNO, 
                      dbo.STHAR.AMBAR_KABULNO, dbo.STHAR.IRSALIYE_NO, dbo.STHAR.STHAR_ODEGUN, dbo.STHAR.STHAR_BF, dbo.STHAR.STHAR_NF, 
                      dbo.STHAR.STHAR_IAF, 
                      (dbo.STHAR.STHAR_BF - dbo.STHAR.STHAR_NF * (CASE WHEN FATUIRS.KDV_DAHILMI = 'E' THEN (1 + STHAR.STHAR_KDV / 100) ELSE 1 END)) 
                      * dbo.STHAR.STHAR_GCMIK AS ISKONTOTUT, 
                      CASE WHEN STHAR.STHAR_SATISK < 0.00100 THEN STHAR.STHAR_SATISK * 100000 ELSE STHAR.STHAR_SATISK END AS STHAR_SATISK, 
                      dbo.STHAR.STHAR_MALFISK, dbo.STSABIT.OLCU_BR1, dbo.STSABIT.OLCU_BR2, dbo.STSABIT.OLCU_BR3, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS GIRISM, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS GRISIM2, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS GIRISM3, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_NF AS NETGIRISTUT, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_BF AS BRUTGIRISTUT, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_IAF AS IADEGIRISTUT, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS CIKISM, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS CIKISM2, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS CIKISM3, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_NF AS NETCIKISTUT, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_BF AS BRUTCIKISTUT, 
                      dbo.STHAR.STHAR_KDV, dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS KDV_TUT, 
                      dbo.STHAR.STHAR_SIPNUM, dbo.STHAR.STHAR_DOVTIP, dbo.STHAR.STHAR_DOVFIAT, 
                      dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_DOVFIAT AS DOVIZ_TUTARI, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_GIRIS_MIKTAR, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_CIKIS_MIKTAR, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * dbo.STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS ALIS_TOPLAM, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * dbo.STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS SATIS_TOPLAM, dbo.STHAR.CEVRIM, 
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN (STHAR.CEVRIM * STHAR.STHAR_GCMIK * STHAR.STHAR_NF) ELSE 0 END) AS BEKLEME_ADATI, 
                      dbo.STSABITEK.TUR, dbo.STSABITEK.MGRUP AS MRUP, dbo.STSABITEK.INGISIM, dbo.STSABITEK.KULL1N, dbo.STSABITEK.KULL2N, 
                      dbo.STSABITEK.KULL1S, dbo.STSABITEK.KULL2S, dbo.STHAR.DEPO_KODU, dbo.STHAR.PROMASYON_KODU, dbo.STHAR.BAGLANTI_NO, 
                      dbo.STHAR.VADE_TARIHI, dbo.STHAR.LISTE_NO, dbo.STHAR.LISTE_FIAT, dbo.CARIKOD2.GRUP_ISIM AS CKOD2_ISIM, 
                      dbo.STHAR.PLASIYER_KODU AS PLAS_KOD, dbo.STHAR.PROJE_KODU, dbo.STHAR.EKALAN_NEDEN, dbo.STHAR.EKALAN, 
                      dbo.STHAR.EKALAN1 AS EKALAN2, dbo.STHAR.MUH_KODU AS MUHKODU, dbo.PROJE.PROJE_ACIKLAMA, 
                      ISKONTIP1.ACIKLAMA AS ISKONTO1_ACIKLAMA, ISKONTIP2.ACIKLAMA AS ISKONTO2_ACIKLAMA, ISKONTIP3.ACIKLAMA AS ISKONTO3_ACIKLAMA, 
                      (CASE WHEN (STSABIT.B_YEDEK7 = 1) OR
                      (STSABIT.B_YEDEK7 = 2) THEN 'E' ELSE 'H' END) AS KITSTOGU, 
                      (CASE WHEN STHAR.L_YEDEK9 = - 1 THEN 'K' ELSE (CASE WHEN STHAR.L_YEDEK9 > 0 THEN 'B' ELSE 'N' END) END) AS KITHAREKETI, 
                      dbo.STSABIT.KOD_3 AS KOD3, dbo.STSABIT.KOD_4 AS KOD4, dbo.STSABIT.KOD_5 AS KOD5, dbo.CASABIT.RAPOR_KODU3 AS CKOD_3, 
                      dbo.CASABIT.RAPOR_KODU4 AS CKOD_4, dbo.CASABIT.RAPOR_KODU5 AS CKOD_5, dbo.STHAR.YAPKOD, 
                      CASE WHEN STSABIT.YAPILANDIR = 'E' THEN DBO.NSF_YAPACIK(STHAR.YAPKOD, STOKPARAM.C_YEDEK8, ESNYAPMAS.YAPACIK) ELSE NULL 
                      END AS YAPACIK, dbo.TBLCARIPLASIYER.PLASIYER_ACIKLAMA, dbo.TBLCARIPLASIYER.ISIM, dbo.TBLCARIPLASIYER.GRUPKODU, 
                      dbo.FATUIRS.CARI_KODU, (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) 
                      * dbo.STHAR.STHAR_NF + dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS TOPLAM
FROM         dbo.STHAR INNER JOIN
                      dbo.STSABIT ON dbo.STHAR.STOK_KODU = dbo.STSABIT.STOK_KODU INNER JOIN
                      dbo.NETCONTEXT ON 1 = 1 INNER JOIN
                      dbo.TBLSTOKPARAM AS STOKPARAM WITH (NOLOCK) ON STOKPARAM.ISLETME_KODU = dbo.NETCONTEXT.V$ISLETME_KODU LEFT OUTER JOIN
                      dbo.STGRUP ON dbo.STSABIT.GRUP_KODU = dbo.STGRUP.GRUP_KOD LEFT OUTER JOIN
                      dbo.CASABIT ON dbo.STHAR.STHAR_ACIKLAMA = dbo.CASABIT.CARI_KOD INNER JOIN
                      dbo.STSABITEK ON dbo.STSABIT.STOK_KODU = dbo.STSABITEK.STOK_KODU INNER JOIN
                      dbo.TBLCARIPLASIYER ON dbo.STHAR.PLASIYER_KODU = dbo.TBLCARIPLASIYER.PLASIYER_KODU RIGHT OUTER JOIN
                      dbo.FATUIRS ON dbo.TBLCARIPLASIYER.PLASIYER_KODU = dbo.FATUIRS.PLA_KODU AND 
                      dbo.FATUIRS.CARI_KODU = dbo.STHAR.STHAR_ACIKLAMA AND dbo.STHAR.STHAR_FTIRSIP = dbo.FATUIRS.FTIRSIP AND 
                      dbo.STHAR.FISNO = dbo.FATUIRS.FATIRS_NO LEFT OUTER JOIN
                      dbo.STOKKOD1 ON dbo.STSABIT.KOD_1 = dbo.STOKKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.CARIKOD1 ON dbo.CASABIT.RAPOR_KODU1 = dbo.CARIKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.CARIKOD2 ON dbo.CASABIT.RAPOR_KODU2 = dbo.CARIKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.STOKKOD2 ON dbo.STSABIT.KOD_2 = dbo.STOKKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.PROJE ON dbo.STHAR.PROJE_KODU = dbo.PROJE.PROJE_KODU LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP1 ON dbo.STHAR.SATISK1TIP = ISKONTIP1.ISKONTOTIP LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP2 ON dbo.STHAR.SATISK2TIP = ISKONTIP2.ISKONTOTIP LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP3 ON dbo.STHAR.SATISK3TIP = ISKONTIP3.ISKONTOTIP LEFT OUTER JOIN
                      dbo.TBLESNYAPMAS AS ESNYAPMAS WITH (NOLOCK) ON ESNYAPMAS.YAPKOD = dbo.STHAR.YAPKOD
]]> Tue, 08 Oct 2013 08:26:52 +0000 http://www.erpne.org/raporu-almak_topic3617_post19362.html#19362 <![CDATA[Raporu Almak : from ile ba?layan, join ile devam...]]> http://www.erpne.org/raporu-almak_topic3617_post19361.html#19361 Yazar: mbaykan
Konu: 3617
Gönderim Zamanı: 07 Ekim 2013 Saat 19:28

from ile ba?layan, join ile devam eden kysmy (sonuna kadar)
bana mesaj olarak atar mysynyz?. ?u am ki bilgisayarymda Netsis kurulu de?il



Düzenleyen mbaykan - 07 Ekim 2013 Saat 19:29]]> Mon, 07 Oct 2013 19:28:33 +0000 http://www.erpne.org/raporu-almak_topic3617_post19361.html#19361