Hesap plani aktarimi

Selamlar,

Örnek: X2008 ve Y2008 firmalarinin görünmemesini istiyorsak.Kisitlayacagimiz kisinin makinasinda;

[HKEY_LOCAL_MACHINE\Software\Netsis\4.0\Ticari]

"SirketKisit"="sirket not in ('X2008', 'Y2008')"  

KONUYLA ALAKASI YOK AMA.

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE VIEW [dbo].[PNV_SERI_BAK] AS

SELECT

A.SERI_NO,

A.STOK_KODU,

A.STOK_ADI,

C.STHAR_TARIH AS GIRIS_TARIHI,

C.FISNO AS ALIS_FAT,

(CASE WHEN C.STHAR_DOVTIP = '1' THEN 'EURO_1'

WHEN C.STHAR_DOVTIP = '2' THEN 'USD MERKEZ'

WHEN C.STHAR_DOVTIP = '3' THEN 'USD_1'

WHEN C.STHAR_DOVTIP = '4' THEN 'EURO SERBEST'

WHEN C.STHAR_DOVTIP = '5' THEN 'USD YW MERKEZ'

WHEN C.STHAR_DOVTIP = '6' THEN 'EURO_2'

WHEN C.STHAR_DOVTIP = '7' THEN 'USD_2'

WHEN C.STHAR_DOVTIP = '8' THEN 'JAPON YENI/USD'

WHEN C.STHAR_DOVTIP = '9' THEN 'EURO_3'

WHEN C.STHAR_DOVTIP = '10'THEN 'YTL_1' ELSE 'YTL' END)AS DOVIZTIP,

A.GIRIS_MIKTARI,

A.CIKIS_MIKTARI,

A.BAKIYE,

ROUND(D.EFF_SATIS,4) AS KUR,

ROUND(C.STHAR_DOVFIAT,4) AS DOVIZ_FIAT,

ROUND(C.STHAR_NF,4) AS NET_FIAT,

ROUND(C.STHAR_BF,4) AS BRUT_FIAT,

E.CARI_KOD,

E.CARI_ISIM,

A.GRUP_KODU,

A.KOD_1

FROM PNV_SERI_BAK_HZ A

LEFT OUTER JOIN TBLSERITRA B ON (A.SERI_NO = B.SERI_NO AND A.STOK_KODU = B.STOK_KODU AND B.GCKOD='G' AND B.BELGETIP='J')

LEFT OUTER JOIN TBLSTHAR C ON (B.STOK_KODU = C.STOK_KODU AND B.STRA_INC = C.INCKEYNO)

LEFT OUTER JOIN NETSIS..DOVIZ D ON (D.SIRA = C.STHAR_DOVTIP) AND (C.STHAR_TARIH = D.TARIH)

LEFT OUTER JOIN TBLCASABIT E ON (C.STHAR_ACIKLAMA = E.CARI_KOD)

WHERE A.BAKIYE > 0

AND B.SUBE_KODU NOT IN ('20','30')