/****** Object:  Table [dbo].[szall_szlef_import]    Script Date: 07/13/2012 17:33:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[szall_szlef_import]') AND type in (N'U'))
DROP TABLE [dbo].[szall_szlef_import]
GO

/****** Object:  Table [dbo].[szall_szlef_import]    Script Date: 07/13/2012 17:33:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[szall_szlef_import](
	[bizszam] [dbo].[bizonylat_szam] NOT NULL,
	[belepes_datum] [dbo].[datum] NOT NULL,
	[vamkez_datum] [dbo].[datum] NOT NULL,
	[vamokmany_sz] [char](15) NOT NULL,
 CONSTRAINT [PK_szal_szlef_import] 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]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[jov_ado]    Script Date: 07/13/2012 17:33:56 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[jov_ado]') AND type in (N'U'))
DROP TABLE [dbo].[jov_ado]
GO

/****** Object:  Table [dbo].[jov_ado]    Script Date: 07/13/2012 17:33:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[jov_ado](
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[ado] [numeric](18, 2) NOT NULL,
 CONSTRAINT [PK_jov_ado] PRIMARY KEY CLUSTERED 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[vevo_szlat_nyomt]    Script Date: 07/13/2012 17:37:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlat_nyomt]') AND type in (N'U'))
DROP TABLE [dbo].[vevo_szlat_nyomt]
GO

/****** Object:  Table [dbo].[vevo_szlat_nyomt]    Script Date: 07/13/2012 17:37:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[vevo_szlat_nyomt](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[TETEL] [dbo].[bizonylat_tetel] NOT NULL,
	[VTSZ] [varchar](10) NOT NULL,
	[CIKK_SZAM] [dbo].[cikk_szam] NOT NULL,
	[CIKK_NEV] [dbo].[cikk_nev] NOT NULL,
	[CIKK_NEV_ANG] [dbo].[cikk_nev] NOT NULL,
	[AFA_KULCS] [dbo].[afa_kulcs] NOT NULL,
	[MENNY_EGYS] [dbo].[menny_egyseg] NOT NULL,
	[MENNY_EGYS_ANG] [dbo].[menny_egyseg] NOT NULL,
	[szorzo] [int] 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) NOT NULL,
 CONSTRAINT [PK_vevo_szlat_nyomt] 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]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Index [IX_vevo_szlat_nyomt]    Script Date: 07/13/2012 17:37:46 ******/
CREATE NONCLUSTERED INDEX [IX_vevo_szlat_nyomt] ON [dbo].[vevo_szlat_nyomt] 
(
	[BIZSZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


/****** Object:  Index [IX_vevo_szlat_nyomt_1]    Script Date: 07/13/2012 17:37:46 ******/
CREATE NONCLUSTERED INDEX [IX_vevo_szlat_nyomt_1] ON [dbo].[vevo_szlat_nyomt] 
(
	[CIKK_SZAM] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


/****** Object:  Table [dbo].[raktarak_cimek]    Script Date: 07/13/2012 17:38:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[raktarak_cimek]') AND type in (N'U'))
DROP TABLE [dbo].[raktarak_cimek]
GO

/****** Object:  Table [dbo].[raktarak_cimek]    Script Date: 07/13/2012 17:38:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[raktarak_cimek](
	[raktar_kod] [dbo].[kulcs] NOT NULL,
	[email] [varchar](150) NOT NULL,
 CONSTRAINT [PK_raktarak_cimek] PRIMARY KEY CLUSTERED 
(
	[raktar_kod] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[cikkek_osszevonas]    Script Date: 07/13/2012 17:40:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cikkek_osszevonas]') AND type in (N'U'))
DROP TABLE [dbo].[cikkek_osszevonas]
GO

/****** Object:  Table [dbo].[cikkek_osszevonas]    Script Date: 07/13/2012 17:40:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[cikkek_osszevonas](
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[cikk_nev] [dbo].[cikk_nev] NOT NULL,
	[menny_egys] [dbo].[menny_egyseg] NOT NULL,
	[cikk_nev_en] [dbo].[cikk_nev] NOT NULL,
	[menny_egys_en] [dbo].[menny_egyseg] NOT NULL,
	[megjegyzes] [dbo].[megjegyzes] NOT NULL,
 CONSTRAINT [PK_cikkek_osszevonas] PRIMARY KEY CLUSTERED 
(
	[cikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO