/****** Object:  Table [dbo].[nb_vevo_szlat]    Script Date: 06/19/2008 14:52:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlat]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_szlat]
GO
/****** Object:  Table [dbo].[nb_vevo_szlef]    Script Date: 06/19/2008 14:52:49 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlef]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_szlef]
GO
/****** Object:  Table [dbo].[nb_vevo_szlet]    Script Date: 06/19/2008 14:52:55 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlet]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_szlet]
GO
/****** Object:  Table [dbo].[nb_vevo_szlaf]    Script Date: 06/19/2008 14:52:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlaf]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_szlaf]
GO
/****** Object:  Table [dbo].[nb_vevo_rent]    Script Date: 06/19/2008 14:52:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_rent]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_rent]
GO
/****** Object:  Table [dbo].[nb_vevo_renf]    Script Date: 06/19/2008 14:52:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_renf]') AND type in (N'U'))
DROP TABLE [dbo].[nb_vevo_renf]
GO
/****** Object:  Table [dbo].[nb_vevo_szlat]    Script Date: 06/19/2008 14:52:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlat]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_szlat](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[TETEL] [dbo].[bizonylat_tetel] NOT NULL,
	[CIKK_SZAM] [dbo].[cikk_szam] NOT NULL,
	[CIKK_NEV] [dbo].[nev] NULL,
	[AFA_KULCS] [varchar](2) NOT NULL,
	[MENNY_EGYS] [dbo].[menny_egyseg] NOT NULL,
	[SZORZO] [dbo].[szorzo] NOT NULL,
	[edarab] [dbo].[mennyiseg] NOT NULL,
	[darab] [dbo].[mennyiseg] NOT NULL,
	[EGYSEG_AR] [dbo].[egyseg_ar] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[megjegyzes] [dbo].[megjegyzes] NOT NULL,
	[akcio] [char](1) NULL,
 CONSTRAINT [PK_nb_VEVO_SZLAT] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] ASC,
	[TETEL] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_szlef]    Script Date: 06/19/2008 14:52:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlef]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_szlef](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[HIVSZAM] [dbo].[bizonylat_szam] NULL,
	[RENDSZAM] [dbo].[bizonylat_tetel] NOT NULL,
	[SZLASZAM] [dbo].[bizonylat_szam] NOT NULL,
	[VEVO] [dbo].[kulcs] NOT NULL,
	[VEVO_NEV] [dbo].[nev] NULL,
	[TELEP_KOD] [char](4) NOT NULL,
	[TELJ_DATUM] [dbo].[datum] NOT NULL,
	[RAKTAR_KOD] [dbo].[kulcs] NOT NULL,
	[penznem] [dbo].[penznem] NOT NULL,
	[kurzus] [dbo].[kurzus] NOT NULL,
	[afamentes] [bit] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[akciocsoport] [dbo].[kulcs] NOT NULL,
	[arcsoport] [dbo].[kulcs] NOT NULL,
	[MEGJEGYZES] [dbo].[megjegyzes] NOT NULL,
	[TIPUS] [dbo].[kulcs] NOT NULL,
	[UZLETKOTO] [dbo].[kulcs] NOT NULL,
	[TOROLT] [char](1) NOT NULL,
	[TORLO] [char](1) NOT NULL,
	[TOR_SSZ] [dbo].[bizonylat_szam] NOT NULL,
	[VISSZARU] [char](1) NOT NULL,
	[KICSODA] [dbo].[kicsoda] NOT NULL,
	[MODOSITVA] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_nb_VEVO_SZLEF] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_szlet]    Script Date: 06/19/2008 14:52:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlet]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_szlet](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[TETEL] [dbo].[bizonylat_tetel] NOT NULL,
	[CIKK_SZAM] [dbo].[cikk_szam] NOT NULL,
	[CIKK_NEV] [dbo].[nev] NULL,
	[AFA_KULCS] [varchar](2) NOT NULL,
	[MENNY_EGYS] [dbo].[menny_egyseg] NOT NULL,
	[SZORZO] [dbo].[szorzo] NOT NULL,
	[edarab] [dbo].[mennyiseg] NOT NULL,
	[darab] [dbo].[mennyiseg] NOT NULL,
	[EGYSEG_AR] [dbo].[egyseg_ar] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[megjegyzes] [dbo].[megjegyzes] NOT NULL,
	[akcio] [char](1) NULL,
	[rendel_bsz] [dbo].[bizonylat_szam] NOT NULL,
	[rendel_tet] [dbo].[bizonylat_tetel] NOT NULL,
 CONSTRAINT [PK_nb_VEVO_SZLET] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] ASC,
	[TETEL] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_rent]    Script Date: 06/19/2008 14:52:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_rent]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_rent](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[TETEL] [dbo].[bizonylat_tetel] NOT NULL,
	[CIKK_SZAM] [dbo].[cikk_szam] NOT NULL,
	[afa_kulcs] [varchar](2) NOT NULL,
	[MENNY_EGYS] [dbo].[menny_egyseg] NOT NULL,
	[SZORZO] [int] NOT NULL,
	[EDARAB] [dbo].[mennyiseg] NOT NULL,
	[DARAB] [dbo].[mennyiseg] NOT NULL,
	[EGYSEG_AR] [dbo].[egyseg_ar] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[visszaig_dat] [dbo].[datum] NOT NULL,
	[AKCIO] [char](1) NOT NULL,
 CONSTRAINT [PK_nb_vevo_rent] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] ASC,
	[TETEL] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_renf]    Script Date: 06/19/2008 14:52:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_renf]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_renf](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[VEVO] [dbo].[kulcs] NOT NULL,
	[szallcim] [char](4) NULL,
	[REND_DAT] [dbo].[datum] NOT NULL,
	[SZALL_DAT] [dbo].[datum] NOT NULL,
	[visszaig_dat] [dbo].[datum] NOT NULL,
	[UZLETKOTO] [dbo].[kulcs] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[penznem] [dbo].[penznem] NOT NULL,
	[afamentes] [bit] NOT NULL,
	[AKCIOCSOPORT] [dbo].[kulcs] NULL,
	[ARCSOPORT] [dbo].[kulcs] NULL,
	[MEGJEGYZES] [dbo].[megjegyzes] NOT NULL,
	[BIZTIPUS] [int] NOT NULL,
	[ALLAPOT] [char](15) NOT NULL,
	[KICSODA] [dbo].[kicsoda] NOT NULL,
	[MODOSITVA] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_nb_vevo_renf] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[nb_vevo_szlaf]    Script Date: 06/19/2008 14:52:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nb_vevo_szlaf]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nb_vevo_szlaf](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[VEVO] [dbo].[kulcs] NOT NULL,
	[VEVO_NEV] [dbo].[nev] NULL,
	[TELJ_DATUM] [dbo].[datum] NOT NULL,
	[SZLA_DATUM] [dbo].[datum] NOT NULL,
	[FIZ_MODJA] [char](1) NOT NULL,
	[FIZ_ESED] [dbo].[datum] NOT NULL,
	[penznem] [dbo].[penznem] NOT NULL,
	[kurzus] [dbo].[kurzus] NOT NULL,
	[afamentes] [bit] NOT NULL,
	[kedvezmeny] [dbo].[kedvezmeny] NOT NULL,
	[TIPUS] [dbo].[kulcs] NOT NULL,
	[UZLETKOTO] [dbo].[kulcs] NOT NULL,
	[MEGJEGYZES] [dbo].[megjegyzes] NOT NULL,
	[TOROLT] [char](1) NOT NULL,
	[TORLO] [char](1) NOT NULL,
	[TOR_SSZ] [dbo].[bizonylat_szam] NOT NULL,
	[VISSZARU] [char](1) NOT NULL,
	[penzugyi] [char](1) NOT NULL,
	[KOTEG_SZ] [int] NOT NULL,
	[KICSODA] [dbo].[kicsoda] NOT NULL,
	[MODOSITVA] [dbo].[datum_ora] NOT NULL,
	[peldany] [int] NULL,
 CONSTRAINT [PK_nb_VEVO_SZLAF] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO