|
| ERP Nedir? Enterprise Resource Planning nasıl çalışır? İş süreçleri ile ilgili tüm soru ve cevapları ERPNe.org'da.
Ülkemizde hızla gelişmekte olan ERP yazılım sektörümüzün, Yerli ve Yabancı ERP işlemlerinin tanıtımı ve kullanıcılarının buluşma noktası olması hedefiyle kurulan sitemize hoş geldiniz. Ülkemizdeki Ne.org konseptinde bir ilk olarak yayın hayatına başlayan ERPNe.org, Kurumsal Kaynak Planlaması yazılımlarını kullananların bilgi kaynağı/Portal olmak amacı ile kurulmuştur. Genellikle yurt dışında büyük üreticiler tarafından geliştirilen SQL, Delphi, ASP, CSharp gibi teknolojilerin anlatıldığı sitelerin kullandıkları (WhatisSQL, WhatisASP) (Ülkemizde Netsis Nedir, Mikro Nedir, SAP Nedir yada Logo Nedir gibi kullanıcı sorularına) Ne ve nedir konseptinde yeni bir açılım olmasını da hedefleyen ERPNe.ORG' un, ülkemizin uluslararası ERP sektörü içinde hak ettiği yeri almasında ve ERP ürünlerini kullananların bir araya gelerek Yerli ERP'nin gelişmesine katkı sağlayacakları önemli bir kilometre taşı olacağı düşüncesindeyiz. |
Yevmiye fişinde hesap ismi çıkmıyor. |
Yanıt Yaz 
|
| Yazar | |
barisb 
Üye 
Kayıt Tarihi: 19 Şubat 2014 Konum: Çorlu Durum: Aktif Değil Puanlar: 209 |
 Mesaj Seçenekleri
 Teşekkürler(0)
 Alıntı Cevapla
 Konu: Yevmiye fişinde hesap ismi çıkmıyor.Gönderim Zamanı: 15 Nisan 2014 Saat 11:06 |
|
iyi günler a?a?ydaki konu ile ilgili yardymlarynyzy bekliyorum.
herkese ?imdiden te?ekkürler. Resimde de görülece?i gibi hesap isimleri çykmyyor. Di?er bir tarafta ise tarih basyyor. Bir türlü çözemedim.  |
|
 |
|
|
rifatgunduz
Üye
Kayıt Tarihi: 29 Mayıs 2009 Konum: Ystanbul Durum: Aktif Değil Puanlar: 44 |
Mesaj Seçenekleri
Yanıt Yaz
Alıntı rifatgunduz
Bu mesaj kurallara aykırıysa buradan yöneticileri bilgilendirebilirsiniz.
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 15 Nisan 2014 Saat 11:10 |
|
Selam,
A?a?ydaki viewy tekrar olu?turmalysynyz. ALTER VIEW MUHFISEKR
AS SELECT
MF.*,
KUR.ISIM CLC_FXNAME,
FIRMAKUR.ISIM CLC_COMPANYFXNAME,
MP.HS_ADI CLC_ACCOUNTNAME,
PR.PROJE_ACIKLAMA CLC_PROJECTDESC,
MR.GRUP_ISIM CLC_REFDESC FROM MUHFIS MF
WITH(NOLOCK) LEFT OUTER JOIN NETSIS..KUR KUR
WITH(NOLOCK) ON MF.DOVIZTIP=KUR.SIRA LEFT OUTER JOIN NETSIS..KUR
FIRMAKUR WITH(NOLOCK) ON MF.FIRMADOVTIP=FIRMAKUR.SIRA LEFT OUTER JOIN TBLMUPLAN MP
WITH(NOLOCK) ON MF.HES_KOD=MP.HESAP_KODU LEFT OUTER JOIN TBLPROJE PR
WITH(NOLOCK) ON MF.PROJE_KODU=PR.PROJE_KODU LEFT OUTER JOIN TBLMUHAREF MR
WITH(NOLOCK) ON MF.REF_KOD=MR.GRUP_KOD Yyi Çaly?malar... |
|
|
Rifat Gündüz
www.netsis.com.tr |
|
|
|
|
barisb
Üye
Kayıt Tarihi: 19 Şubat 2014 Konum: Çorlu Durum: Aktif Değil Puanlar: 209 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 15 Nisan 2014 Saat 11:30 |
|
Çok te?ekkür ederim öncelikle ilginiz için.
Dedi?iniz yaptym. Yevmiye fi? giri?i ve Yevmiye fi? dökümündeki problem düzeldi. Ancak Yevmiye Defteri basymynda hala tarih geliyor.  |
|
|
|
|
rifatgunduz
Üye
Kayıt Tarihi: 29 Mayıs 2009 Konum: Ystanbul Durum: Aktif Değil Puanlar: 44 |
Mesaj Seçenekleri
Yanıt Yaz
Alıntı rifatgunduz
Bu mesaj kurallara aykırıysa buradan yöneticileri bilgilendirebilirsiniz.
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 15 Nisan 2014 Saat 11:49 |
|
Selam,
Bir de ?u viewlary alterlayabilir misiniz? ALTER VIEW [dbo].[MUPLAN] AS SELECT TBLMUPLAN.* FROM TBLMUPLAN WITH(NOLOCK),NETCONTEXT WHERE (((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (SUBE_KODU IN (-1,V$SUBE_KODU)))) AND HESAP_KODU NOT IN ( SELECT KOD FROM TBLKODHARICHAR DENYL WHERE DENYL.TABLENAME = 'TBLMUPLAN' AND DENYL.SUBE_KODU = V$SUBE_KODU) AND ( (V$WORKPLACEVARMI='' OR V$WORKPLACEVARMI IS NULL OR V$WORKPLACEVARMI='H') OR (ONAYTIPI='' OR ONAYTIPI IS NULL OR ONAYTIPI='A') OR ( (ONAYNUM IN (SELECT ONAYNUMARASI FROM TBLWORKFLOWTRA WHERE SUBE_KODU = V$SUBE_KODU AND KULLANICINO = V$NETUSERID AND DURUMU = 'B' AND TBLWORKFLOWTRA.ONAYNUMARASI = ONAYNUM)) AND @@LOCK_TIMEOUT=1000000 AND ONAYTIPI<>'' AND ONAYTIPI IS NOT NULL AND (ONAYTIPI='I' OR ONAYTIPI='U') ) OR (@@LOCK_TIMEOUT<>1000000 AND ONAYTIPI<>'' AND ONAYTIPI IS NOT NULL AND ONAYTIPI = 'U') ) GO ALTER VIEW [dbo].[MUHFIS] AS SELECT TBLMUHFIS.* FROM TBLMUHFIS WITH(NOLOCK), TBLSUBELER WITH(NOLOCK),NETCONTEXT WHERE ( TBLSUBELER.SUBE_KODU = TBLMUHFIS.SUBE_KODU ) AND ( (V$MUHKULTIPI=0) OR ( (V$MUHKULTIPI=1) AND ( (V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU)) ) AND ( (V$MERKEZMI=1) OR (TBLMUHFIS.SUBE_KODU IN (-1,V$SUBE_KODU)) ) ) ) |
|
|
Rifat Gündüz
www.netsis.com.tr |
|
|
|
|
barisb
Üye
Kayıt Tarihi: 19 Şubat 2014 Konum: Çorlu Durum: Aktif Değil Puanlar: 209 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 15 Nisan 2014 Saat 11:54 |
|
Maalesef bir de?i?iklik olmady Ryfat bey.
|
|
|
|
|
Conari
Kidemli Üye 
Kayıt Tarihi: 04 Mayıs 2007 Konum: YSTANBUL Durum: Aktif Değil Puanlar: 3513 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 16 Nisan 2014 Saat 09:16 |
|
...
Düzenleyen Conari - 16 Nisan 2014 Saat 09:17 |
|
|
Netsisden vazgeçemiyorum. Beni engelliyor..
|
|
|
|
|
rhan
Kidemli Üye
Kayıt Tarihi: 05 Temmuz 2008 Durum: Aktif Değil Puanlar: 590 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 16 Nisan 2014 Saat 09:53 |
|
/****** Object: View [dbo].[MUHARES] Script Date: 16.04.2014 09:53:14 ******/
DROP VIEW [dbo].[MUHARES] GO /****** Object: View [dbo].[MUHAREF] Script Date: 16.04.2014 09:53:14 ******/ DROP VIEW [dbo].[MUHAREF] /****** Object: View [dbo].[MUHAREF] Script Date: 16.04.2014 09:53:14 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHAREF] AS SELECT TBLMUHAREF.* FROM TBLMUHAREF WITH(NOLOCK),NETCONTEXT WHERE (((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (SUBE_KODU IN (-1,V$SUBE_KODU)))) AND GRUP_KOD NOT IN ( SELECT KOD FROM TBLKODHARICHAR DENYL WHERE DENYL.TABLENAME = 'TBLMUHAREF' AND DENYL.SUBE_KODU = V$SUBE_KODU ) GO /****** Object: View [dbo].[MUHARES] Script Date: 16.04.2014 09:53:14 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHARES] AS SELECT TBLMUHARES.* FROM TBLMUHARES WITH(NOLOCK), TBLSUBELER WITH(NOLOCK),NETCONTEXT WHERE TBLSUBELER.SUBE_KODU = TBLMUHARES.SUBE_KODU AND ((V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (TBLMUHARES.SUBE_KODU IN (-1,V$SUBE_KODU))) GO |
|
|
İnnova Antalya Proje Danışmanlık
Orhan ÇÖPÜROĞLU 0544 241 45 55 0242 311 45 56 |
|
|
|
|
rhan
Kidemli Üye
Kayıt Tarihi: 05 Temmuz 2008 Durum: Aktif Değil Puanlar: 590 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 16 Nisan 2014 Saat 09:57 |
|
bunlaryn hepsini çaly?tyryp bir dene.
olmazsa ba?lanalym. /****** Object: View [dbo].[MUPLANEK] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANEK] GO /****** Object: View [dbo].[MULTILANGUAGEDESC] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MULTILANGUAGEDESC] GO /****** Object: View [dbo].[MUHTASARODEMETUR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHTASARODEMETUR] GO /****** Object: View [dbo].[MUHTASAR_TABLO3] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHTASAR_TABLO3] GO /****** Object: View [dbo].[MUHTASAR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHTASAR] GO /****** Object: View [dbo].[MUHFISEK] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHFISEK] GO /****** Object: View [dbo].[MUHASEBEKODLAR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHASEBEKODLAR] GO /****** Object: View [dbo].[MUHARES] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHARES] GO /****** Object: View [dbo].[MUHAREF] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHAREF] GO /****** Object: View [dbo].[MUHAPRM] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHAPRM] GO /****** Object: View [dbo].[MUHAGEC] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHAGEC] GO /****** Object: View [dbo].[MUHACIK] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHACIK] GO /****** Object: View [dbo].[MUHMASEKR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHMASEKR] GO /****** Object: View [dbo].[MUHMAS] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHMAS] GO /****** Object: View [dbo].[MUPLANEKR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANEKR] GO /****** Object: View [dbo].[MUHFISEKR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHFISEKR] GO /****** Object: View [dbo].[MUHFIS] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUHFIS] GO /****** Object: View [dbo].[MUPLANSUBETOPLAM] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBETOPLAM] GO /****** Object: View [dbo].[MUPLANSUBEOTR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEOTR] GO /****** Object: View [dbo].[MUPLANSUBEMIZANPROJETOPLAM] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEMIZANPROJETOPLAM] GO /****** Object: View [dbo].[MUPLANSUBERAPOTR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBERAPOTR] GO /****** Object: View [dbo].[MUGRUP] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUGRUP] GO /****** Object: View [dbo].[MUPLANSUBEMIZANTOPLAM] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEMIZANTOPLAM] GO /****** Object: View [dbo].[MUPLANSUBEMIZANOTR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEMIZANOTR] GO /****** Object: View [dbo].[MUPLANSUBE] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBE] GO /****** Object: View [dbo].[MUPLANSUBEPROJEOTR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEPROJEOTR] GO /****** Object: View [dbo].[MUPLANSUBEPROJETOPLAM] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEPROJETOPLAM] GO /****** Object: View [dbo].[MUPLANSUBEMIZANPROJEOTR] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEMIZANPROJEOTR] GO /****** Object: View [dbo].[MUPLANSUBEPROJE] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLANSUBEPROJE] GO /****** Object: View [dbo].[MUPLAN] Script Date: 16.04.2014 09:56:38 ******/ DROP VIEW [dbo].[MUPLAN] GO /****** Object: View [dbo].[MUPLAN] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLAN] AS SELECT TBLMUPLAN.* FROM TBLMUPLAN WITH(NOLOCK),NETCONTEXT WHERE (((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (SUBE_KODU IN (-1,V$SUBE_KODU)))) AND HESAP_KODU NOT IN ( SELECT KOD FROM TBLKODHARICHAR DENYL WHERE DENYL.TABLENAME = 'TBLMUPLAN' AND DENYL.SUBE_KODU = V$SUBE_KODU) AND ( (V$WORKPLACEVARMI='' OR V$WORKPLACEVARMI IS NULL OR V$WORKPLACEVARMI='H') OR (ONAYTIPI='' OR ONAYTIPI IS NULL OR ONAYTIPI='A') OR ( (ONAYNUM IN (SELECT ONAYNUMARASI FROM TBLWORKFLOWTRA WHERE SUBE_KODU = V$SUBE_KODU AND KULLANICINO = V$NETUSERID AND DURUMU = 'B' AND TBLWORKFLOWTRA.ONAYNUMARASI = ONAYNUM)) AND @@LOCK_TIMEOUT=1000000 AND ONAYTIPI<>'' AND ONAYTIPI IS NOT NULL AND (ONAYTIPI='I' OR ONAYTIPI='U') ) OR (@@LOCK_TIMEOUT<>1000000 AND ONAYTIPI<>'' AND ONAYTIPI IS NOT NULL AND ONAYTIPI = 'U') ) GO /****** Object: View [dbo].[MUPLANSUBEPROJE] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEPROJE]( SUBE_KODU, HESAP_KODU, PROJE_KODU, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12) AS SELECT TMP.* FROM ( SELECT TRA.SUBE_KODU, HESAP_KODU, TRA.PROJE_KODU, ISNULL(SUM(CASE WHEN AY_KODU = 1 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT1, ISNULL(SUM(CASE WHEN AY_KODU = 2 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT2, ISNULL(SUM(CASE WHEN AY_KODU = 3 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT3, ISNULL(SUM(CASE WHEN AY_KODU = 4 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT4, ISNULL(SUM(CASE WHEN AY_KODU = 5 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT5, ISNULL(SUM(CASE WHEN AY_KODU = 6 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT6, ISNULL(SUM(CASE WHEN AY_KODU = 7 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT7, ISNULL(SUM(CASE WHEN AY_KODU = 8 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT8, ISNULL(SUM(CASE WHEN AY_KODU = 9 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT9, ISNULL(SUM(CASE WHEN AY_KODU = 10 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT10, ISNULL(SUM(CASE WHEN AY_KODU = 11 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT11, ISNULL(SUM(CASE WHEN AY_KODU = 12 AND BA='2' THEN TUTAR ELSE 0 END),0) ATUT12, ISNULL(SUM(CASE WHEN AY_KODU = 1 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT1, ISNULL(SUM(CASE WHEN AY_KODU = 2 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT2, ISNULL(SUM(CASE WHEN AY_KODU = 3 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT3, ISNULL(SUM(CASE WHEN AY_KODU = 4 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT4, ISNULL(SUM(CASE WHEN AY_KODU = 5 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT5, ISNULL(SUM(CASE WHEN AY_KODU = 6 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT6, ISNULL(SUM(CASE WHEN AY_KODU = 7 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT7, ISNULL(SUM(CASE WHEN AY_KODU = 8 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT8, ISNULL(SUM(CASE WHEN AY_KODU = 9 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT9, ISNULL(SUM(CASE WHEN AY_KODU = 10 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT10, ISNULL(SUM(CASE WHEN AY_KODU = 11 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT11, ISNULL(SUM(CASE WHEN AY_KODU = 12 AND BA='1' THEN TUTAR ELSE 0 END),0) BTUT12, ISNULL(SUM(CASE WHEN AY_KODU = 1 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK1, ISNULL(SUM(CASE WHEN AY_KODU = 2 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK2, ISNULL(SUM(CASE WHEN AY_KODU = 3 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK3, ISNULL(SUM(CASE WHEN AY_KODU = 4 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK4, ISNULL(SUM(CASE WHEN AY_KODU = 5 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK5, ISNULL(SUM(CASE WHEN AY_KODU = 6 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK6, ISNULL(SUM(CASE WHEN AY_KODU = 7 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK7, ISNULL(SUM(CASE WHEN AY_KODU = 8 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK8, ISNULL(SUM(CASE WHEN AY_KODU = 9 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK9, ISNULL(SUM(CASE WHEN AY_KODU = 10 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK10, ISNULL(SUM(CASE WHEN AY_KODU = 11 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK11, ISNULL(SUM(CASE WHEN AY_KODU = 12 AND BA='2' THEN MIKTAR ELSE 0 END),0) AMIK12, ISNULL(SUM(CASE WHEN AY_KODU = 1 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK1, ISNULL(SUM(CASE WHEN AY_KODU = 2 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK2, ISNULL(SUM(CASE WHEN AY_KODU = 3 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK3, ISNULL(SUM(CASE WHEN AY_KODU = 4 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK4, ISNULL(SUM(CASE WHEN AY_KODU = 5 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK5, ISNULL(SUM(CASE WHEN AY_KODU = 6 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK6, ISNULL(SUM(CASE WHEN AY_KODU = 7 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK7, ISNULL(SUM(CASE WHEN AY_KODU = 8 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK8, ISNULL(SUM(CASE WHEN AY_KODU = 9 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK9, ISNULL(SUM(CASE WHEN AY_KODU = 10 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK10, ISNULL(SUM(CASE WHEN AY_KODU = 11 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK11, ISNULL(SUM(CASE WHEN AY_KODU = 12 AND BA='1' THEN MIKTAR ELSE 0 END),0) BMIK12 FROM MUPLAN MAS LEFT OUTER JOIN TBLMUHFIS TRA ON (TRA.HES_KOD=MAS.HESAP_KODU OR TRA.HES_KOD LIKE MAS.HESAP_KODU + '-%') WHERE MIKTAR <> 0 OR TUTAR <> 0 AND TRA.PROJE_KODU IS NOT NULL GROUP BY TRA.SUBE_KODU,HESAP_KODU,TRA.PROJE_KODU ) TMP GO /****** Object: View [dbo].[MUPLANSUBEMIZANPROJEOTR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEMIZANPROJEOTR] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, PROJE_KODU, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, CALIS_TIP, CALIS_BAG, DOVIZLIMI, DOVIZ_TIPI, HESAPLAMATURU, DOVIZKONTROL, UPDATE_KODU, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, SUBE_KODU ) AS SELECT MUPLAN.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, MUPLANSUBE.PROJE_KODU, ISNULL(MUPLANSUBE.ALAY_TUT1,0), ISNULL(MUPLANSUBE.ALAY_TUT2,0), ISNULL(MUPLANSUBE.ALAY_TUT3,0), ISNULL(MUPLANSUBE.ALAY_TUT4,0), ISNULL(MUPLANSUBE.ALAY_TUT5,0), ISNULL(MUPLANSUBE.ALAY_TUT6,0), ISNULL(MUPLANSUBE.ALAY_TUT7,0), ISNULL(MUPLANSUBE.ALAY_TUT8,0), ISNULL(MUPLANSUBE.ALAY_TUT9,0), ISNULL(MUPLANSUBE.ALAY_TUT10,0), ISNULL(MUPLANSUBE.ALAY_TUT11,0), ISNULL(MUPLANSUBE.ALAY_TUT12,0), ISNULL(MUPLANSUBE.BOAY_TUT1,0), ISNULL(MUPLANSUBE.BOAY_TUT2,0), ISNULL(MUPLANSUBE.BOAY_TUT3,0), ISNULL(MUPLANSUBE.BOAY_TUT4,0), ISNULL(MUPLANSUBE.BOAY_TUT5,0), ISNULL(MUPLANSUBE.BOAY_TUT6,0), ISNULL(MUPLANSUBE.BOAY_TUT7,0), ISNULL(MUPLANSUBE.BOAY_TUT8,0), ISNULL(MUPLANSUBE.BOAY_TUT9,0), ISNULL(MUPLANSUBE.BOAY_TUT10,0), ISNULL(MUPLANSUBE.BOAY_TUT11,0), ISNULL(MUPLANSUBE.BOAY_TUT12,0), ISNULL(MUPLANSUBE.ALAY_MIK1,0), ISNULL(MUPLANSUBE.ALAY_MIK2,0), ISNULL(MUPLANSUBE.ALAY_MIK3,0), ISNULL(MUPLANSUBE.ALAY_MIK4,0), ISNULL(MUPLANSUBE.ALAY_MIK5,0), ISNULL(MUPLANSUBE.ALAY_MIK6,0), ISNULL(MUPLANSUBE.ALAY_MIK7,0), ISNULL(MUPLANSUBE.ALAY_MIK8,0), ISNULL(MUPLANSUBE.ALAY_MIK9,0), ISNULL(MUPLANSUBE.ALAY_MIK10,0), ISNULL(MUPLANSUBE.ALAY_MIK11,0), ISNULL(MUPLANSUBE.ALAY_MIK12,0), ISNULL(MUPLANSUBE.BOAY_MIK1,0), ISNULL(MUPLANSUBE.BOAY_MIK2,0), ISNULL(MUPLANSUBE.BOAY_MIK3,0), ISNULL(MUPLANSUBE.BOAY_MIK4,0), ISNULL(MUPLANSUBE.BOAY_MIK5,0), ISNULL(MUPLANSUBE.BOAY_MIK6,0), ISNULL(MUPLANSUBE.BOAY_MIK7,0), ISNULL(MUPLANSUBE.BOAY_MIK8,0), ISNULL(MUPLANSUBE.BOAY_MIK9,0), ISNULL(MUPLANSUBE.BOAY_MIK10,0), ISNULL(MUPLANSUBE.BOAY_MIK11,0), ISNULL(MUPLANSUBE.BOAY_MIK12,0), MUPLAN.CALIS_TIP, MUPLAN.CALIS_BAG, MUPLAN.DOVIZLIMI, MUPLAN.DOVIZ_TIPI, MUPLAN.HESAPLAMATURU, MUPLAN.DOVIZKONTROL, MUPLAN.UPDATE_KODU, MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLANSUBE.SUBE_KODU FROM MUPLANSUBEPROJE MUPLANSUBE RIGHT OUTER JOIN MUPLAN ON (MUPLAN.HESAP_KODU=MUPLANSUBE.HESAP_KODU) GO /****** Object: View [dbo].[MUPLANSUBEPROJETOPLAM] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEPROJETOPLAM] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, CALIS_BAG, PROJE_KODU ) AS SELECT MUPLANSUBE.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, SUM(MUPLANSUBE.ALAY_TUT1), SUM(MUPLANSUBE.ALAY_TUT2), SUM(MUPLANSUBE.ALAY_TUT3), SUM(MUPLANSUBE.ALAY_TUT4), SUM(MUPLANSUBE.ALAY_TUT5), SUM(MUPLANSUBE.ALAY_TUT6), SUM(MUPLANSUBE.ALAY_TUT7), SUM(MUPLANSUBE.ALAY_TUT8), SUM(MUPLANSUBE.ALAY_TUT9), SUM(MUPLANSUBE.ALAY_TUT10), SUM(MUPLANSUBE.ALAY_TUT11), SUM(MUPLANSUBE.ALAY_TUT12), SUM(MUPLANSUBE.BOAY_TUT1), SUM(MUPLANSUBE.BOAY_TUT2), SUM(MUPLANSUBE.BOAY_TUT3), SUM(MUPLANSUBE.BOAY_TUT4), SUM(MUPLANSUBE.BOAY_TUT5), SUM(MUPLANSUBE.BOAY_TUT6), SUM(MUPLANSUBE.BOAY_TUT7), SUM(MUPLANSUBE.BOAY_TUT8), SUM(MUPLANSUBE.BOAY_TUT9), SUM(MUPLANSUBE.BOAY_TUT10), SUM(MUPLANSUBE.BOAY_TUT11), SUM(MUPLANSUBE.BOAY_TUT12), SUM(MUPLANSUBE.ALAY_MIK1), SUM(MUPLANSUBE.ALAY_MIK2), SUM(MUPLANSUBE.ALAY_MIK3), SUM(MUPLANSUBE.ALAY_MIK4), SUM(MUPLANSUBE.ALAY_MIK5), SUM(MUPLANSUBE.ALAY_MIK6), SUM(MUPLANSUBE.ALAY_MIK7), SUM(MUPLANSUBE.ALAY_MIK8), SUM(MUPLANSUBE.ALAY_MIK9), SUM(MUPLANSUBE.ALAY_MIK10), SUM(MUPLANSUBE.ALAY_MIK11), SUM(MUPLANSUBE.ALAY_MIK12), SUM(MUPLANSUBE.BOAY_MIK1), SUM(MUPLANSUBE.BOAY_MIK2), SUM(MUPLANSUBE.BOAY_MIK3), SUM(MUPLANSUBE.BOAY_MIK4), SUM(MUPLANSUBE.BOAY_MIK5), SUM(MUPLANSUBE.BOAY_MIK6), SUM(MUPLANSUBE.BOAY_MIK7), SUM(MUPLANSUBE.BOAY_MIK8), SUM(MUPLANSUBE.BOAY_MIK9), SUM(MUPLANSUBE.BOAY_MIK10), SUM(MUPLANSUBE.BOAY_MIK11), SUM(MUPLANSUBE.BOAY_MIK12), MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLAN.CALIS_BAG, MUPLANSUBE.PROJE_KODU FROM MUPLANSUBEPROJE MUPLANSUBE,TBLMUPLAN MUPLAN WHERE MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU GROUP BY MUPLANSUBE.HESAP_KODU,MUPLAN.AGM,MUPLAN.HS_ADI,MUPLAN.HS_YD_ADI,HS_GRKOD,OLCU_BIRIM, HS_BLKZ,YEDEK1,YEDEK2,YEDEK3,YEDEK4,YEDEK5,YEDEK6,YEDEK7,YEDEK8,YEDEK9,MUPLAN.CALIS_BAG, MUPLANSUBE.PROJE_KODU GO /****** Object: View [dbo].[MUPLANSUBEPROJEOTR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEPROJEOTR] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, CALIS_TIP, CALIS_BAG, DOVIZLIMI, DOVIZ_TIPI, HESAPLAMATURU, DOVIZKONTROL, UPDATE_KODU, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, SUBE_KODU, PROJE_KODU ) AS SELECT MUPLANSUBE.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, MUPLANSUBE.ALAY_TUT1, MUPLANSUBE.ALAY_TUT2, MUPLANSUBE.ALAY_TUT3, MUPLANSUBE.ALAY_TUT4, MUPLANSUBE.ALAY_TUT5, MUPLANSUBE.ALAY_TUT6, MUPLANSUBE.ALAY_TUT7, MUPLANSUBE.ALAY_TUT8, MUPLANSUBE.ALAY_TUT9, MUPLANSUBE.ALAY_TUT10, MUPLANSUBE.ALAY_TUT11, MUPLANSUBE.ALAY_TUT12, MUPLANSUBE.BOAY_TUT1, MUPLANSUBE.BOAY_TUT2, MUPLANSUBE.BOAY_TUT3, MUPLANSUBE.BOAY_TUT4, MUPLANSUBE.BOAY_TUT5, MUPLANSUBE.BOAY_TUT6, MUPLANSUBE.BOAY_TUT7, MUPLANSUBE.BOAY_TUT8, MUPLANSUBE.BOAY_TUT9, MUPLANSUBE.BOAY_TUT10, MUPLANSUBE.BOAY_TUT11, MUPLANSUBE.BOAY_TUT12, MUPLANSUBE.ALAY_MIK1, MUPLANSUBE.ALAY_MIK2, MUPLANSUBE.ALAY_MIK3, MUPLANSUBE.ALAY_MIK4, MUPLANSUBE.ALAY_MIK5, MUPLANSUBE.ALAY_MIK6, MUPLANSUBE.ALAY_MIK7, MUPLANSUBE.ALAY_MIK8, MUPLANSUBE.ALAY_MIK9, MUPLANSUBE.ALAY_MIK10, MUPLANSUBE.ALAY_MIK11, MUPLANSUBE.ALAY_MIK12, MUPLANSUBE.BOAY_MIK1, MUPLANSUBE.BOAY_MIK2, MUPLANSUBE.BOAY_MIK3, MUPLANSUBE.BOAY_MIK4, MUPLANSUBE.BOAY_MIK5, MUPLANSUBE.BOAY_MIK6, MUPLANSUBE.BOAY_MIK7, MUPLANSUBE.BOAY_MIK8, MUPLANSUBE.BOAY_MIK9, MUPLANSUBE.BOAY_MIK10, MUPLANSUBE.BOAY_MIK11, MUPLANSUBE.BOAY_MIK12, MUPLAN.CALIS_TIP, MUPLAN.CALIS_BAG, MUPLAN.DOVIZLIMI, MUPLAN.DOVIZ_TIPI, MUPLAN.HESAPLAMATURU, MUPLAN.DOVIZKONTROL, MUPLAN.UPDATE_KODU, MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLANSUBE.SUBE_KODU, MUPLANSUBE.PROJE_KODU FROM MUPLANSUBEPROJE MUPLANSUBE INNER JOIN MUPLAN ON (MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU) GO /****** Object: View [dbo].[MUPLANSUBE] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBE] AS SELECT TBLMUPLANSUBE.* FROM TBLMUPLANSUBE WITH(NOLOCK), TBLSUBELER WITH(NOLOCK),NETCONTEXT WHERE ( TBLSUBELER.SUBE_KODU = TBLMUPLANSUBE.SUBE_KODU ) AND (TBLMUPLANSUBE.SUBE_KODU > -1 ) AND ( (V$MUHKULTIPI=0) OR ( (V$MUHKULTIPI=1) AND ( (V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU)) ) AND ( (V$MERKEZMI=1) OR (TBLMUPLANSUBE.SUBE_KODU IN (-1,V$SUBE_KODU)) ) ) ) GO /****** Object: View [dbo].[MUPLANSUBEMIZANOTR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEMIZANOTR] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, CALIS_TIP, CALIS_BAG, DOVIZLIMI, DOVIZ_TIPI, HESAPLAMATURU, DOVIZKONTROL, UPDATE_KODU, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, SUBE_KODU ) AS SELECT MUPLAN.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, ISNULL(MUPLANSUBE.ALAY_TUT1,0), ISNULL(MUPLANSUBE.ALAY_TUT2,0), ISNULL(MUPLANSUBE.ALAY_TUT3,0), ISNULL(MUPLANSUBE.ALAY_TUT4,0), ISNULL(MUPLANSUBE.ALAY_TUT5,0), ISNULL(MUPLANSUBE.ALAY_TUT6,0), ISNULL(MUPLANSUBE.ALAY_TUT7,0), ISNULL(MUPLANSUBE.ALAY_TUT8,0), ISNULL(MUPLANSUBE.ALAY_TUT9,0), ISNULL(MUPLANSUBE.ALAY_TUT10,0), ISNULL(MUPLANSUBE.ALAY_TUT11,0), ISNULL(MUPLANSUBE.ALAY_TUT12,0), ISNULL(MUPLANSUBE.BOAY_TUT1,0), ISNULL(MUPLANSUBE.BOAY_TUT2,0), ISNULL(MUPLANSUBE.BOAY_TUT3,0), ISNULL(MUPLANSUBE.BOAY_TUT4,0), ISNULL(MUPLANSUBE.BOAY_TUT5,0), ISNULL(MUPLANSUBE.BOAY_TUT6,0), ISNULL(MUPLANSUBE.BOAY_TUT7,0), ISNULL(MUPLANSUBE.BOAY_TUT8,0), ISNULL(MUPLANSUBE.BOAY_TUT9,0), ISNULL(MUPLANSUBE.BOAY_TUT10,0), ISNULL(MUPLANSUBE.BOAY_TUT11,0), ISNULL(MUPLANSUBE.BOAY_TUT12,0), ISNULL(MUPLANSUBE.ALAY_MIK1,0), ISNULL(MUPLANSUBE.ALAY_MIK2,0), ISNULL(MUPLANSUBE.ALAY_MIK3,0), ISNULL(MUPLANSUBE.ALAY_MIK4,0), ISNULL(MUPLANSUBE.ALAY_MIK5,0), ISNULL(MUPLANSUBE.ALAY_MIK6,0), ISNULL(MUPLANSUBE.ALAY_MIK7,0), ISNULL(MUPLANSUBE.ALAY_MIK8,0), ISNULL(MUPLANSUBE.ALAY_MIK9,0), ISNULL(MUPLANSUBE.ALAY_MIK10,0), ISNULL(MUPLANSUBE.ALAY_MIK11,0), ISNULL(MUPLANSUBE.ALAY_MIK12,0), ISNULL(MUPLANSUBE.BOAY_MIK1,0), ISNULL(MUPLANSUBE.BOAY_MIK2,0), ISNULL(MUPLANSUBE.BOAY_MIK3,0), ISNULL(MUPLANSUBE.BOAY_MIK4,0), ISNULL(MUPLANSUBE.BOAY_MIK5,0), ISNULL(MUPLANSUBE.BOAY_MIK6,0), ISNULL(MUPLANSUBE.BOAY_MIK7,0), ISNULL(MUPLANSUBE.BOAY_MIK8,0), ISNULL(MUPLANSUBE.BOAY_MIK9,0), ISNULL(MUPLANSUBE.BOAY_MIK10,0), ISNULL(MUPLANSUBE.BOAY_MIK11,0), ISNULL(MUPLANSUBE.BOAY_MIK12,0), MUPLAN.CALIS_TIP, MUPLAN.CALIS_BAG, MUPLAN.DOVIZLIMI, MUPLAN.DOVIZ_TIPI, MUPLAN.HESAPLAMATURU, MUPLAN.DOVIZKONTROL, MUPLAN.UPDATE_KODU, MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLANSUBE.SUBE_KODU FROM MUPLANSUBE RIGHT OUTER JOIN MUPLAN ON (MUPLAN.HESAP_KODU=MUPLANSUBE.HESAP_KODU) GO /****** Object: View [dbo].[MUPLANSUBEMIZANTOPLAM] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEMIZANTOPLAM] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, CALIS_BAG ) AS SELECT MUPLAN.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, ISNULL(SUM(MUPLANSUBE.ALAY_TUT1),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT2),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT3),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT4),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT5),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT6),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT7),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT8),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT9),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT10),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT11),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT12),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT1),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT2),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT3),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT4),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT5),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT6),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT7),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT8),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT9),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT10),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT11),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT12),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK1),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK2),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK3),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK4),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK5),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK6),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK7),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK8),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK9),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK10),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK11),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK12),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK1),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK2),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK3),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK4),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK5),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK6),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK7),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK8),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK9),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK10),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK11),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK12),0), MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLAN.CALIS_BAG FROM MUPLANSUBE RIGHT OUTER JOIN MUPLAN ON (MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU) GROUP BY MUPLAN.HESAP_KODU,MUPLAN.AGM,MUPLAN.HS_ADI,MUPLAN.HS_YD_ADI,HS_GRKOD,OLCU_BIRIM, HS_BLKZ,YEDEK1,YEDEK2,YEDEK3,YEDEK4,YEDEK5,YEDEK6,YEDEK7,YEDEK8,YEDEK9,MUPLAN.CALIS_BAG GO /****** Object: View [dbo].[MUGRUP] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUGRUP] AS SELECT TBLMUGRUP.* FROM TBLMUGRUP WITH(NOLOCK),NETCONTEXT WHERE ((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU))) GO /****** Object: View [dbo].[MUPLANSUBERAPOTR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBERAPOTR] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, GRUP_ISIM, OLCU_BIRIM, HS_BLKZ, BOAY_TUT1, ALAY_TUT1, BOAY_MIK1, ALAY_MIK1, BOAY_TUT2, ALAY_TUT2, BOAY_MIK2, ALAY_MIK2, BOAY_TUT3, ALAY_TUT3, BOAY_MIK3, ALAY_MIK3, BOAY_TUT4, ALAY_TUT4, BOAY_MIK4, ALAY_MIK4, BOAY_TUT5, ALAY_TUT5, BOAY_MIK5, ALAY_MIK5, BOAY_TUT6, ALAY_TUT6, BOAY_MIK6, ALAY_MIK6, BOAY_TUT7, ALAY_TUT7, BOAY_MIK7, ALAY_MIK7, BOAY_TUT8, ALAY_TUT8, BOAY_MIK8, ALAY_MIK8, BOAY_TUT9, ALAY_TUT9, BOAY_MIK9, ALAY_MIK9, BOAY_TUT10, ALAY_TUT10, BOAY_MIK10, ALAY_MIK10, BOAY_TUT11, ALAY_TUT11, BOAY_MIK11, ALAY_MIK11, BOAY_TUT12, ALAY_TUT12, BOAY_MIK12, ALAY_MIK12, CALIS_TIP, CALIS_BAG, DOVIZLIMI, DOVIZ_TIPI, HESAPLAMATURU, DOVIZKONTROL, UPDATE_KODU, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, SUBE_KODU ) AS SELECT MUPLAN.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUGRUP.GRUP_ISIM, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, MUPLANSUBE.BOAY_TUT1, MUPLANSUBE.ALAY_TUT1, MUPLANSUBE.BOAY_MIK1, MUPLANSUBE.ALAY_MIK1, MUPLANSUBE.BOAY_TUT2, MUPLANSUBE.ALAY_TUT2, MUPLANSUBE.BOAY_MIK2, MUPLANSUBE.ALAY_MIK2, MUPLANSUBE.BOAY_TUT3, MUPLANSUBE.ALAY_TUT3, MUPLANSUBE.BOAY_MIK3, MUPLANSUBE.ALAY_MIK3, MUPLANSUBE.BOAY_TUT4, MUPLANSUBE.ALAY_TUT4, MUPLANSUBE.BOAY_MIK4, MUPLANSUBE.ALAY_MIK4, MUPLANSUBE.BOAY_TUT5, MUPLANSUBE.ALAY_TUT5, MUPLANSUBE.BOAY_MIK5, MUPLANSUBE.ALAY_MIK5, MUPLANSUBE.BOAY_TUT6, MUPLANSUBE.ALAY_TUT6, MUPLANSUBE.BOAY_MIK6, MUPLANSUBE.ALAY_MIK6, MUPLANSUBE.BOAY_TUT7, MUPLANSUBE.ALAY_TUT7, MUPLANSUBE.BOAY_MIK7, MUPLANSUBE.ALAY_MIK7, MUPLANSUBE.BOAY_TUT8, MUPLANSUBE.ALAY_TUT8, MUPLANSUBE.BOAY_MIK8, MUPLANSUBE.ALAY_MIK8, MUPLANSUBE.BOAY_TUT9, MUPLANSUBE.ALAY_TUT9, MUPLANSUBE.BOAY_MIK9, MUPLANSUBE.ALAY_MIK9, MUPLANSUBE.BOAY_TUT10, MUPLANSUBE.ALAY_TUT10, MUPLANSUBE.BOAY_MIK10, MUPLANSUBE.ALAY_MIK10, MUPLANSUBE.BOAY_TUT11, MUPLANSUBE.ALAY_TUT11, MUPLANSUBE.BOAY_MIK11, MUPLANSUBE.ALAY_MIK11, MUPLANSUBE.BOAY_TUT12, MUPLANSUBE.ALAY_TUT12, MUPLANSUBE.BOAY_MIK12, MUPLANSUBE.ALAY_MIK12, MUPLAN.CALIS_TIP, MUPLAN.CALIS_BAG, MUPLAN.DOVIZLIMI, MUPLAN.DOVIZ_TIPI, MUPLAN.HESAPLAMATURU, MUPLAN.DOVIZKONTROL, MUPLAN.UPDATE_KODU, MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5,--DOVIZLI MUHASEBE PARASAL MUPLAN.YEDEK6,--DOVIZLI MUHASEBE DOVIZLE DEG. MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLANSUBE.SUBE_KODU FROM MUPLAN LEFT OUTER JOIN MUPLANSUBE ON (MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU) LEFT OUTER JOIN MUGRUP ON (MUPLAN.HS_GRKOD=MUGRUP.GRUP_KOD) GO /****** Object: View [dbo].[MUPLANSUBEMIZANPROJETOPLAM] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEMIZANPROJETOPLAM] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, PROJE_KODU, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9) AS SELECT MUPLAN.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, MUPLANSUBE.PROJE_KODU, ISNULL(SUM(MUPLANSUBE.ALAY_TUT1),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT2),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT3),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT4),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT5),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT6),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT7),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT8),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT9),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT10),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT11),0), ISNULL(SUM(MUPLANSUBE.ALAY_TUT12),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT1),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT2),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT3),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT4),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT5),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT6),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT7),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT8),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT9),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT10),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT11),0), ISNULL(SUM(MUPLANSUBE.BOAY_TUT12),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK1),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK2),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK3),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK4),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK5),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK6),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK7),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK8),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK9),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK10),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK11),0), ISNULL(SUM(MUPLANSUBE.ALAY_MIK12),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK1),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK2),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK3),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK4),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK5),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK6),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK7),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK8),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK9),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK10),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK11),0), ISNULL(SUM(MUPLANSUBE.BOAY_MIK12),0), MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9 FROM MUPLANSUBEPROJE MUPLANSUBE RIGHT OUTER JOIN MUPLAN ON (MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU) GROUP BY MUPLAN.HESAP_KODU,MUPLAN.AGM,MUPLAN.HS_ADI,MUPLAN.HS_YD_ADI,HS_GRKOD,OLCU_BIRIM, HS_BLKZ,PROJE_KODU,YEDEK1,YEDEK2,YEDEK3,YEDEK4,YEDEK5,YEDEK6,YEDEK7,YEDEK8,YEDEK9 GO /****** Object: View [dbo].[MUPLANSUBEOTR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBEOTR] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, CALIS_TIP, CALIS_BAG, DOVIZLIMI, DOVIZ_TIPI, HESAPLAMATURU, DOVIZKONTROL, UPDATE_KODU, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, SUBE_KODU ) AS SELECT MUPLANSUBE.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, MUPLANSUBE.ALAY_TUT1, MUPLANSUBE.ALAY_TUT2, MUPLANSUBE.ALAY_TUT3, MUPLANSUBE.ALAY_TUT4, MUPLANSUBE.ALAY_TUT5, MUPLANSUBE.ALAY_TUT6, MUPLANSUBE.ALAY_TUT7, MUPLANSUBE.ALAY_TUT8, MUPLANSUBE.ALAY_TUT9, MUPLANSUBE.ALAY_TUT10, MUPLANSUBE.ALAY_TUT11, MUPLANSUBE.ALAY_TUT12, MUPLANSUBE.BOAY_TUT1, MUPLANSUBE.BOAY_TUT2, MUPLANSUBE.BOAY_TUT3, MUPLANSUBE.BOAY_TUT4, MUPLANSUBE.BOAY_TUT5, MUPLANSUBE.BOAY_TUT6, MUPLANSUBE.BOAY_TUT7, MUPLANSUBE.BOAY_TUT8, MUPLANSUBE.BOAY_TUT9, MUPLANSUBE.BOAY_TUT10, MUPLANSUBE.BOAY_TUT11, MUPLANSUBE.BOAY_TUT12, MUPLANSUBE.ALAY_MIK1, MUPLANSUBE.ALAY_MIK2, MUPLANSUBE.ALAY_MIK3, MUPLANSUBE.ALAY_MIK4, MUPLANSUBE.ALAY_MIK5, MUPLANSUBE.ALAY_MIK6, MUPLANSUBE.ALAY_MIK7, MUPLANSUBE.ALAY_MIK8, MUPLANSUBE.ALAY_MIK9, MUPLANSUBE.ALAY_MIK10, MUPLANSUBE.ALAY_MIK11, MUPLANSUBE.ALAY_MIK12, MUPLANSUBE.BOAY_MIK1, MUPLANSUBE.BOAY_MIK2, MUPLANSUBE.BOAY_MIK3, MUPLANSUBE.BOAY_MIK4, MUPLANSUBE.BOAY_MIK5, MUPLANSUBE.BOAY_MIK6, MUPLANSUBE.BOAY_MIK7, MUPLANSUBE.BOAY_MIK8, MUPLANSUBE.BOAY_MIK9, MUPLANSUBE.BOAY_MIK10, MUPLANSUBE.BOAY_MIK11, MUPLANSUBE.BOAY_MIK12, MUPLAN.CALIS_TIP, MUPLAN.CALIS_BAG, MUPLAN.DOVIZLIMI, MUPLAN.DOVIZ_TIPI, MUPLAN.HESAPLAMATURU, MUPLAN.DOVIZKONTROL, MUPLAN.UPDATE_KODU, MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLANSUBE.SUBE_KODU FROM MUPLANSUBE INNER JOIN MUPLAN ON (MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU) GO /****** Object: View [dbo].[MUPLANSUBETOPLAM] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANSUBETOPLAM] ( HESAP_KODU, AGM, HS_ADI, HS_YD_ADI, HS_GRKOD, OLCU_BIRIM, HS_BLKZ, ALAY_TUT1, ALAY_TUT2, ALAY_TUT3, ALAY_TUT4, ALAY_TUT5, ALAY_TUT6, ALAY_TUT7, ALAY_TUT8, ALAY_TUT9, ALAY_TUT10, ALAY_TUT11, ALAY_TUT12, BOAY_TUT1, BOAY_TUT2, BOAY_TUT3, BOAY_TUT4, BOAY_TUT5, BOAY_TUT6, BOAY_TUT7, BOAY_TUT8, BOAY_TUT9, BOAY_TUT10, BOAY_TUT11, BOAY_TUT12, ALAY_MIK1, ALAY_MIK2, ALAY_MIK3, ALAY_MIK4, ALAY_MIK5, ALAY_MIK6, ALAY_MIK7, ALAY_MIK8, ALAY_MIK9, ALAY_MIK10, ALAY_MIK11, ALAY_MIK12, BOAY_MIK1, BOAY_MIK2, BOAY_MIK3, BOAY_MIK4, BOAY_MIK5, BOAY_MIK6, BOAY_MIK7, BOAY_MIK8, BOAY_MIK9, BOAY_MIK10, BOAY_MIK11, BOAY_MIK12, YEDEK1, YEDEK2, YEDEK3, YEDEK4, YEDEK5, YEDEK6, YEDEK7, YEDEK8, YEDEK9, CALIS_BAG ) AS SELECT MUPLANSUBE.HESAP_KODU, MUPLAN.AGM, MUPLAN.HS_ADI, MUPLAN.HS_YD_ADI, MUPLAN.HS_GRKOD, MUPLAN.OLCU_BIRIM, MUPLAN.HS_BLKZ, SUM(MUPLANSUBE.ALAY_TUT1), SUM(MUPLANSUBE.ALAY_TUT2), SUM(MUPLANSUBE.ALAY_TUT3), SUM(MUPLANSUBE.ALAY_TUT4), SUM(MUPLANSUBE.ALAY_TUT5), SUM(MUPLANSUBE.ALAY_TUT6), SUM(MUPLANSUBE.ALAY_TUT7), SUM(MUPLANSUBE.ALAY_TUT8), SUM(MUPLANSUBE.ALAY_TUT9), SUM(MUPLANSUBE.ALAY_TUT10), SUM(MUPLANSUBE.ALAY_TUT11), SUM(MUPLANSUBE.ALAY_TUT12), SUM(MUPLANSUBE.BOAY_TUT1), SUM(MUPLANSUBE.BOAY_TUT2), SUM(MUPLANSUBE.BOAY_TUT3), SUM(MUPLANSUBE.BOAY_TUT4), SUM(MUPLANSUBE.BOAY_TUT5), SUM(MUPLANSUBE.BOAY_TUT6), SUM(MUPLANSUBE.BOAY_TUT7), SUM(MUPLANSUBE.BOAY_TUT8), SUM(MUPLANSUBE.BOAY_TUT9), SUM(MUPLANSUBE.BOAY_TUT10), SUM(MUPLANSUBE.BOAY_TUT11), SUM(MUPLANSUBE.BOAY_TUT12), SUM(MUPLANSUBE.ALAY_MIK1), SUM(MUPLANSUBE.ALAY_MIK2), SUM(MUPLANSUBE.ALAY_MIK3), SUM(MUPLANSUBE.ALAY_MIK4), SUM(MUPLANSUBE.ALAY_MIK5), SUM(MUPLANSUBE.ALAY_MIK6), SUM(MUPLANSUBE.ALAY_MIK7), SUM(MUPLANSUBE.ALAY_MIK8), SUM(MUPLANSUBE.ALAY_MIK9), SUM(MUPLANSUBE.ALAY_MIK10), SUM(MUPLANSUBE.ALAY_MIK11), SUM(MUPLANSUBE.ALAY_MIK12), SUM(MUPLANSUBE.BOAY_MIK1), SUM(MUPLANSUBE.BOAY_MIK2), SUM(MUPLANSUBE.BOAY_MIK3), SUM(MUPLANSUBE.BOAY_MIK4), SUM(MUPLANSUBE.BOAY_MIK5), SUM(MUPLANSUBE.BOAY_MIK6), SUM(MUPLANSUBE.BOAY_MIK7), SUM(MUPLANSUBE.BOAY_MIK8), SUM(MUPLANSUBE.BOAY_MIK9), SUM(MUPLANSUBE.BOAY_MIK10), SUM(MUPLANSUBE.BOAY_MIK11), SUM(MUPLANSUBE.BOAY_MIK12), MUPLAN.YEDEK1, MUPLAN.YEDEK2, MUPLAN.YEDEK3, MUPLAN.YEDEK4, MUPLAN.YEDEK5, MUPLAN.YEDEK6, MUPLAN.YEDEK7, MUPLAN.YEDEK8, MUPLAN.YEDEK9, MUPLAN.CALIS_BAG FROM MUPLANSUBE,TBLMUPLAN MUPLAN WHERE MUPLANSUBE.HESAP_KODU=MUPLAN.HESAP_KODU GROUP BY MUPLANSUBE.HESAP_KODU,MUPLAN.AGM,MUPLAN.HS_ADI,MUPLAN.HS_YD_ADI,HS_GRKOD,OLCU_BIRIM, HS_BLKZ,YEDEK1,YEDEK2,YEDEK3,YEDEK4,YEDEK5,YEDEK6,YEDEK7,YEDEK8,YEDEK9,MUPLAN.CALIS_BAG GO /****** Object: View [dbo].[MUHFIS] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHFIS] AS SELECT TBLMUHFIS.* FROM TBLMUHFIS WITH(NOLOCK), TBLSUBELER WITH(NOLOCK),NETCONTEXT WHERE ( TBLSUBELER.SUBE_KODU = TBLMUHFIS.SUBE_KODU ) AND ( (V$MUHKULTIPI=0) OR ( (V$MUHKULTIPI=1) AND ( (V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU)) ) AND ( (V$MERKEZMI=1) OR (TBLMUHFIS.SUBE_KODU IN (-1,V$SUBE_KODU)) ) ) ) GO /****** Object: View [dbo].[MUHFISEKR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHFISEKR] AS SELECT MF.*, KUR.ISIM CLC_FXNAME, FIRMAKUR.ISIM CLC_COMPANYFXNAME, MP.HS_ADI CLC_ACCOUNTNAME, PR.PROJE_ACIKLAMA CLC_PROJECTDESC, MR.GRUP_ISIM CLC_REFDESC FROM MUHFIS MF WITH(NOLOCK) LEFT OUTER JOIN NETSIS..KUR KUR WITH(NOLOCK) ON MF.DOVIZTIP=KUR.SIRA LEFT OUTER JOIN NETSIS..KUR FIRMAKUR WITH(NOLOCK) ON MF.FIRMADOVTIP=FIRMAKUR.SIRA LEFT OUTER JOIN TBLMUPLAN MP WITH(NOLOCK) ON MF.HES_KOD=MP.HESAP_KODU LEFT OUTER JOIN TBLPROJE PR WITH(NOLOCK) ON MF.PROJE_KODU=PR.PROJE_KODU LEFT OUTER JOIN TBLMUHAREF MR WITH(NOLOCK) ON MF.REF_KOD=MR.GRUP_KOD GO /****** Object: View [dbo].[MUPLANEKR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANEKR] AS WITH MSUBE(SUBE_KODU,KODU,BORC,ALACAK) AS ( SELECT SUBE_KODU, HESAP_KODU KODU, (BOAY_TUT1+BOAY_TUT2+BOAY_TUT3+BOAY_TUT4+BOAY_TUT5+BOAY_TUT6+BOAY_TUT7+BOAY_TUT8+BOAY_TUT9+BOAY_TUT10+BOAY_TUT11+BOAY_TUT12) BORC, (ALAY_TUT1+ALAY_TUT2+ALAY_TUT3+ALAY_TUT4+ALAY_TUT5+ALAY_TUT6+ALAY_TUT7+ALAY_TUT8+ALAY_TUT9+ALAY_TUT10+ALAY_TUT11+ALAY_TUT12) ALACAK FROM TBLMUPLANSUBE WITH(NOLOCK) ) SELECT MP.*, KUR.ISIM CLC_DOVIZISIM, MG.GRUP_ISIM CLC_HSGRUPISIM, (SELECT TBLMUPLAN.HS_ADI FROM TBLMUPLAN WITH(NOLOCK) WHERE TBLMUPLAN.HESAP_KODU=MP.ENF_FARK_HESKOD) CLC_ENFFARKHESISIM, ISNULL(MSUBE.BORC,0) CLC_DEBIT, ISNULL(MSUBE.ALACAK,0) CLC_CREDIT, ISNULL(MSUBE.BORC-MSUBE.ALACAK,0) CLC_BALANCE FROM MUPLAN MP WITH(NOLOCK) LEFT OUTER JOIN TBLMUHAPRM PRM WITH(NOLOCK) ON (MP.ISLETME_KODU=PRM.ISLETME_KODU) LEFT OUTER JOIN MSUBE ON (MP.HESAP_KODU=MSUBE.KODU AND (CASE WHEN PRM.YEDEK4='E' THEN MP.SUBE_KODU ELSE -1 END)=MSUBE.SUBE_KODU) LEFT OUTER JOIN TBLMUGRUP MG WITH(NOLOCK) ON (MP.HS_GRKOD=MG.GRUP_KOD) LEFT OUTER JOIN NETSIS..KUR KUR WITH(NOLOCK) ON (MP.DOVIZ_TIPI=KUR.SIRA) GO /****** Object: View [dbo].[MUHMAS] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHMAS] AS SELECT TBLMUHMAS.* FROM TBLMUHMAS WITH(NOLOCK), TBLSUBELER WITH(NOLOCK),NETCONTEXT WHERE ( TBLSUBELER.SUBE_KODU = TBLMUHMAS.SUBE_KODU ) AND ( (V$MUHKULTIPI=0) OR ( (V$MUHKULTIPI=1) AND ( (V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU)) ) AND ( (V$MERKEZMI=1) OR (TBLMUHMAS.SUBE_KODU IN (-1,V$SUBE_KODU)) ) ) ) GO /****** Object: View [dbo].[MUHMASEKR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHMASEKR] AS WITH FIS (FISNO,AY_KODU, KALEMSAY, BORC, ALACAK) AS ( SELECT FISNO, AY_KODU, COUNT(*) KALEMSAY, SUM(CASE WHEN FIS.BA='1' THEN FIS.TUTAR ELSE 0 END) BORC, SUM(CASE WHEN FIS.BA='2' THEN FIS.TUTAR ELSE 0 END) ALACAK FROM TBLMUHFIS FIS WITH(NOLOCK) GROUP BY FISNO, AY_KODU ) SELECT MM.*, FIS.BORC CLC_DEBIT, FIS.ALACAK CLC_CREDIT, FIS.BORC - FIS.ALACAK CLC_BALANCE, FIS.KALEMSAY CLC_ITEMCOUNT FROM MUHMAS MM WITH(NOLOCK) LEFT OUTER JOIN FIS ON (FIS.AY_KODU = MM.AY_KODU AND FIS.FISNO = MM.MAS_FISNO) GO /****** Object: View [dbo].[MUHACIK] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHACIK] AS SELECT TBLMUHACIK.* FROM TBLMUHACIK WITH(NOLOCK),NETCONTEXT WHERE ((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU))) GO /****** Object: View [dbo].[MUHAGEC] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHAGEC] AS SELECT MGEC.*,TBLMUPLAN.HS_ADI CLC_HS_ADI FROM TBLMUHAGEC MGEC WITH(NOLOCK) LEFT OUTER JOIN TBLMUPLAN ON (MGEC.KOD = TBLMUPLAN.HESAP_KODU), TBLSUBELER WITH(NOLOCK), NETCONTEXT WHERE TBLSUBELER.SUBE_KODU = MGEC.SUBE_KODU AND ((V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (MGEC.SUBE_KODU IN (-1,V$SUBE_KODU))) AND ( (V$WORKPLACEVARMI='' OR V$WORKPLACEVARMI IS NULL OR V$WORKPLACEVARMI='H') OR (MGEC.ONAYTIPI='' OR MGEC.ONAYTIPI IS NULL OR MGEC.ONAYTIPI='A') OR ( (MGEC.ONAYNUM IN (SELECT ONAYNUMARASI FROM TBLWORKFLOWTRA WHERE SUBE_KODU = V$SUBE_KODU AND KULLANICINO = V$NETUSERID AND DURUMU = 'B' AND TBLWORKFLOWTRA.ONAYNUMARASI = MGEC.ONAYNUM)) AND @@LOCK_TIMEOUT=1000000 AND MGEC.ONAYTIPI<>'' AND MGEC.ONAYTIPI IS NOT NULL AND (MGEC.ONAYTIPI='I' OR MGEC.ONAYTIPI='U') ) OR (@@LOCK_TIMEOUT<>1000000 AND MGEC.ONAYTIPI<>'' AND MGEC.ONAYTIPI IS NOT NULL AND MGEC.ONAYTIPI = 'U') ) GO /****** Object: View [dbo].[MUHAPRM] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHAPRM] AS SELECT TBLMUHAPRM.* FROM TBLMUHAPRM WITH(NOLOCK),NETCONTEXT WHERE ISLETME_KODU=V$ISLETME_KODU GO /****** Object: View [dbo].[MUHAREF] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHAREF] AS SELECT TBLMUHAREF.* FROM TBLMUHAREF WITH(NOLOCK),NETCONTEXT WHERE (((V$HOLDINGMI=1) OR (ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (SUBE_KODU IN (-1,V$SUBE_KODU)))) AND GRUP_KOD NOT IN ( SELECT KOD FROM TBLKODHARICHAR DENYL WHERE DENYL.TABLENAME = 'TBLMUHAREF' AND DENYL.SUBE_KODU = V$SUBE_KODU ) GO /****** Object: View [dbo].[MUHARES] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHARES] AS SELECT TBLMUHARES.* FROM TBLMUHARES WITH(NOLOCK), TBLSUBELER WITH(NOLOCK),NETCONTEXT WHERE TBLSUBELER.SUBE_KODU = TBLMUHARES.SUBE_KODU AND ((V$HOLDINGMI=1) OR (TBLSUBELER.ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND ((V$MERKEZMI=1) OR (TBLMUHARES.SUBE_KODU IN (-1,V$SUBE_KODU))) GO /****** Object: View [dbo].[MUHASEBEKODLAR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHASEBEKODLAR] AS SELECT TBLMUHASEBEKODLAR.* FROM TBLMUHASEBEKODLAR WITH(NOLOCK) GO /****** Object: View [dbo].[MUHFISEK] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHFISEK] AS SELECT TBLMUHFISEK.* FROM TBLMUHFISEK WITH(NOLOCK) INNER JOIN TBLSUBELER WITH (NOLOCK) ON TBLMUHFISEK.SUBE_KODU = TBLSUBELER.SUBE_KODU INNER JOIN NETCONTEXT WITH (NOLOCK) ON NETCONTEXT.V$SUBE_KODU = TBLMUHFISEK.SUBE_KODU OR NETCONTEXT.V$HOLDINGMI = 1 OR ( NETCONTEXT.V$MERKEZMI = 1 AND NETCONTEXT.V$ISLETME_KODU = TBLSUBELER.ISLETME_KODU ) GO /****** Object: View [dbo].[MUHTASAR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHTASAR] AS SELECT TBLMUHTASAR.* FROM TBLMUHTASAR WITH(NOLOCK) GO /****** Object: View [dbo].[MUHTASAR_TABLO3] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHTASAR_TABLO3] AS SELECT TBLMUHTASAR_TABLO3.* FROM TBLMUHTASAR_TABLO3 WITH(NOLOCK) GO /****** Object: View [dbo].[MUHTASARODEMETUR] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUHTASARODEMETUR] AS SELECT * FROM TBLMUSTAHSILTUR WHERE TUR_KODU NOT IN (91,92,93,94,95,96) GO /****** Object: View [dbo].[MULTILANGUAGEDESC] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MULTILANGUAGEDESC] AS SELECT TBLMULTILANGUAGEDESC.* FROM TBLMULTILANGUAGEDESC GO /****** Object: View [dbo].[MUPLANEK] Script Date: 16.04.2014 09:56:38 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[MUPLANEK] AS SELECT TBLMUPLANEK.* FROM TBLMUPLANEK WITH(NOLOCK) GO |
|
|
İnnova Antalya Proje Danışmanlık
Orhan ÇÖPÜROĞLU 0544 241 45 55 0242 311 45 56 |
|
|
|
|
barisb
Üye
Kayıt Tarihi: 19 Şubat 2014 Konum: Çorlu Durum: Aktif Değil Puanlar: 209 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 16 Nisan 2014 Saat 10:00 |
|
Maalesef hala bir de?i?iklik olmady.
Raporlar\Kanuni defter basymy\yevmiye fi?i raporunda hala tarih geliyor.
|
|
|
|
|
rhan
Kidemli Üye
Kayıt Tarihi: 05 Temmuz 2008 Durum: Aktif Değil Puanlar: 590 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 16 Nisan 2014 Saat 10:31 |
|
sen genel kysytlar -1 de "hazyrlyk çaly?tyrylsyn" var, onu i?aretleyip rapor almy?syn sanyrym.
orda "kaynak belge bilgileri basymy " kysmyny basylmasyn yapyp bir dener misin ? |
|
|
İnnova Antalya Proje Danışmanlık
Orhan ÇÖPÜROĞLU 0544 241 45 55 0242 311 45 56 |
|
|
|
|
barisb
Üye
Kayıt Tarihi: 19 Şubat 2014 Konum: Çorlu Durum: Aktif Değil Puanlar: 209 |
Mesaj Seçenekleri
Teşekkürler(0)
Alıntı Cevapla
Gönderim Zamanı: 16 Nisan 2014 Saat 10:40 |
|
Dedi?iniz gibi buradaki seçene?i düzeltince sorun çözüldü.
Hepinize ilgi ve alakanyzdan dolayy çok te?ekkür ederim.
|
|
|
|
|
Yanıt Yaz
|
|
Tweet
|
| Forum Atla | Forum İzinleri Kapalı Foruma Yeni Konu Gönderme Kapalı Forumdaki Konulara Cevap Yazma Kapalı Forumda Cevapları Silme Kapalı Forumdaki Cevapları Düzenleme Kapalı Forumda Anket Açma Kapalı Forumda Anketlerde Oy Kullanma |
Topic Seçenekleri