Yevmiye fişinde hesap ismi çıkmıyor.
Nereden Yazdırıldığı: ERP Nedir? | Türkiye'nin ERP Forum Platformu
Kategori: ERP Temel Paketler
Forum Adı: ERP Muhasebe Modülü
Forum Tanımlaması: Muhasebe Modülü İle İlgili Bilgiler ve Sorular İçin...
URL: http://www.erpne.org/forum_posts.asp?TID=3753
Tarih: 22 Kasım 2024 Saat 10:39
Program Versiyonu: Web Wiz Forums 11.10 - http://www.webwizforums.com
Konu: Yevmiye fişinde hesap ismi çıkmıyor.
Mesajı Yazan: barisb
Konu: Yevmiye fişinde hesap ismi çıkmıyor.
Mesaj Tarihi: 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.  |
Cevaplar:
Mesajı Yazan: rifatgunduz
Mesaj Tarihi: 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 |
Mesajı Yazan: barisb
Mesaj Tarihi: 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.  |
Mesajı Yazan: rifatgunduz
Mesaj Tarihi: 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 |
Mesajı Yazan: barisb
Mesaj Tarihi: 15 Nisan 2014 Saat 11:54
|
Maalesef bir de?i?iklik olmady Ryfat bey.
|
Mesajı Yazan: Conari
Mesaj Tarihi: 16 Nisan 2014 Saat 09:16
|
... ------------- Netsisden vazgeçemiyorum. Beni engelliyor.. |
Mesajı Yazan: rhan
Mesaj Tarihi: 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 |
Mesajı Yazan: rhan
Mesaj Tarihi: 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 |
Mesajı Yazan: barisb
Mesaj Tarihi: 16 Nisan 2014 Saat 10:00
|
Maalesef hala bir de?i?iklik olmady. Raporlar\Kanuni defter basymy\yevmiye fi?i raporunda hala tarih geliyor.
|
Mesajı Yazan: rhan
Mesaj Tarihi: 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 |
Mesajı Yazan: barisb
Mesaj Tarihi: 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.
|