ERP Nedir? | Türkiye'nin ERP Forum Platformu : Yevmiye fişinde hesap ismi çıkmıyor. http://www.erpne.org/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 18 Apr 2026 18:47:56 +0000 Wed, 16 Apr 2014 10:40:33 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.10 360 www.erpne.org/RSS_post_feed.asp?TID=3753 <![CDATA[ERP Nedir? | Türkiye'nin ERP Forum Platformu]]> http://www.erpne.org/forum_images/logotype.png http://www.erpne.org/ <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : Dedi?iniz gibi buradaki seçene?i...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20087.html#20087 Yazar: barisb
Konu: 3753
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.
]]> Wed, 16 Apr 2014 10:40:33 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20087.html#20087 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : sen genel kysytlar -1 de &#034;hazyrlyk...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20086.html#20086 Yazar: rhan
Konu: 3753
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 ?
]]> Wed, 16 Apr 2014 10:31:24 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20086.html#20086 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : Maalesef hala bir de?i?iklik olmady.Raporlar\Kanuni...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20085.html#20085 Yazar: barisb
Konu: 3753
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. CryCry
]]> Wed, 16 Apr 2014 10:00:55 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20085.html#20085 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : bunlaryn hepsini çaly?tyryp bir...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20084.html#20084 Yazar: rhan
Konu: 3753
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


]]> Wed, 16 Apr 2014 09:57:33 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20084.html#20084 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : /****** Object: View . Script...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20083.html#20083 Yazar: rhan
Konu: 3753
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
]]> Wed, 16 Apr 2014 09:53:58 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20083.html#20083 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : ...Düzenleyen Conari - 16Nisan2014...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20082.html#20082 Yazar: Conari
Konu: 3753
Gönderim Zamanı: 16 Nisan 2014 Saat 09:16

...


Düzenleyen Conari - 16 Nisan 2014 Saat 09:17]]> Wed, 16 Apr 2014 09:16:38 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20082.html#20082 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : Maalesef bir de?i?iklik olmady...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20081.html#20081 Yazar: barisb
Konu: 3753
Gönderim Zamanı: 15 Nisan 2014 Saat 11:54

Maalesef bir de?i?iklik olmady Ryfat bey. Cry]]> Tue, 15 Apr 2014 11:54:50 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20081.html#20081 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : Selam,Bir de ?u viewlary alterlayabilir...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20080.html#20080 Yazar: rifatgunduz
Konu: 3753
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))  
  )
 )  
)

]]> Tue, 15 Apr 2014 11:49:03 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20080.html#20080 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : Çok te?ekkür ederim öncelikle...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20079.html#20079 Yazar: barisb
Konu: 3753
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. Cry

]]> Tue, 15 Apr 2014 11:30:48 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20079.html#20079 <![CDATA[Yevmiye fişinde hesap ismi çıkmıyor. : Selam,A?a?ydaki viewy tekrar olu?turmalysynyz.ALTER...]]> http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20078.html#20078 Yazar: rifatgunduz
Konu: 3753
Gönderim Zamanı: 15 Nisan 2014 Saat 11:10

Selam,
A?a?ydaki viewy tekrar olu?turmalysynyz.

ALTER VIEW MUHFISEKRAS       

SELECTMF.*,       

               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 MFWITH(NOLOCK)       

LEFT OUTER JOIN NETSIS..KUR KURWITH(NOLOCK) ON MF.DOVIZTIP=KUR.SIRA       

LEFT OUTER JOIN NETSIS..KURFIRMAKUR WITH(NOLOCK) ON MF.FIRMADOVTIP=FIRMAKUR.SIRA   

LEFT OUTER JOIN TBLMUPLAN MPWITH(NOLOCK) ON MF.HES_KOD=MP.HESAP_KODU

LEFT OUTER JOIN TBLPROJE PRWITH(NOLOCK) ON MF.PROJE_KODU=PR.PROJE_KODU

LEFT OUTER JOIN TBLMUHAREF MRWITH(NOLOCK) ON MF.REF_KOD=MR.GRUP_KOD


Yyi Çaly?malar...

]]> Tue, 15 Apr 2014 11:10:23 +0000 http://www.erpne.org/yevmiye-fisinde-hesap-ismi-cikmiyor_topic3753_post20078.html#20078