USE [Vertragsverwaltung]
GO

/****** Object:  Table [dbo].[Honoris_JOURNAL]    Script Date: 23.04.2013 08:07:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Honoris_JOURNAL](
	[JOURNAL_NR] [int] NOT NULL,
	[MITARBEITER_NR] [int] NOT NULL,
	[PROJEKT_NR] [decimal](10, 0) NOT NULL,
	[POSTYP_SCNR] [smallint] NOT NULL,
	[SPESEN_NR] [int] NULL,
	[DATUM] [datetime] NOT NULL,
	[FAK_NR] [decimal](10, 0) NULL,
	[MWST_NR] [smallint] NOT NULL,
	[LEISTUNG_NR] [int] NULL,
	[SPESENGRUPPE_NR] [smallint] NULL,
	[POSSTATUS_SCNR] [smallint] NULL,
	[ANZAHLEXT] [decimal](10, 2) NULL,
	[ANZAHLINT] [decimal](10, 2) NULL,
	[ANSATZEXT] [decimal](10, 2) NULL,
	[ANSATZINT] [decimal](10, 2) NULL,
	[TOTALEXT] [decimal](10, 2) NULL,
	[BETRAGNETTOEXT] [decimal](10, 2) NULL,
	[TOTALINT] [decimal](10, 2) NULL,
	[ABRECHTYP_SCNR] [smallint] NULL,
	[IMPORTDATUM] [datetime] NULL,
	[BETRAGNETTOINT] [decimal](10, 2) NULL,
	[TEXTEXT] [nvarchar](max) NULL,
	[TEXTEXT2] [nvarchar](max) NULL,
	[TEXTINT] [nvarchar](max) NULL,
	[TEXTINT2] [nvarchar](max) NULL,
	[MITSPEABRECH] [datetime] NULL,
	[ERFDATUM] [datetime] NULL,
	[PROFIRMANR] [smallint] NOT NULL,
	[MITFIRMANR] [smallint] NOT NULL,
	[FIBUJOURNAL_NR] [smallint] NULL,
	[KST] [nvarchar](max) NULL,
	[FAKSWITCH] [decimal](10, 0) NULL,
	[FIBUDATUM] [datetime] NULL,
	[LOHNDATUM] [datetime] NULL,
	[ANSATZSTATUS_SCNR] [smallint] NULL,
	[PROSTRUKTUR_NR] [int] NULL,
	[MITSTRUKTUR_NR] [int] NULL,
	[VISSTATUS_SCNR] [smallint] NULL,
	[VISDATUM] [datetime] NULL,
	[VISMIT_NR] [int] NULL,
	[MITABTNR] [int] NULL,
	[PROABTNR] [int] NULL,
	[VST_NR] [smallint] NULL,
	[JOURNAL_ID] [int] NOT NULL,
	[ROWVERSION] [binary](8) NOT NULL,
	[FW_ANZAHLEXT] [decimal](15, 4) NULL,
	[FW_ANSATZEXT] [decimal](15, 4) NULL,
	[FW_BETRAGNETTOEXT] [decimal](15, 4) NULL,
	[FW_TOTALEXT] [decimal](15, 4) NULL,
	[WAEHRUNG_NR] [smallint] NULL,
	[TAGESKURS] [decimal](10, 4) NULL,
	[FW_ANZAHLINT] [decimal](15, 4) NULL,
	[FW_ANSATZINT] [decimal](15, 4) NULL,
	[FW_BETRAGNETTOINT] [decimal](15, 4) NULL,
	[FW_TOTALINT] [decimal](15, 4) NULL,
	[WAEHRUNG_NR_INT] [smallint] NULL,
	[TAGESKURS_INT] [decimal](10, 4) NULL,
	[UR_FW_ANZAHLEXT] [decimal](15, 4) NULL,
	[UR_FW_ANSATZEXT] [decimal](15, 4) NULL,
	[UR_FW_BETRAGNETTOEXT] [decimal](15, 4) NULL,
	[UR_FW_TOTALEXT] [decimal](15, 4) NULL,
	[UR_WAEHRUNG_NR] [smallint] NULL,
	[UR_TAGESKURS] [decimal](10, 4) NULL,
	[KSPUNENTGELD] [smallint] NULL,
	[PROVFAK_NR] [decimal](10, 0) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[Honoris_mitarbeiter]    Script Date: 23.04.2013 08:07:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Honoris_mitarbeiter](
	[MITARBEITER_NR] [int] NOT NULL,
	[FIRMA_NR] [smallint] NULL,
	[MITARBEITER_ID] [nvarchar](max) NOT NULL,
	[NAME] [nvarchar](max) NULL,
	[PERSONAL_NR] [decimal](10, 0) NOT NULL,
	[VORNAME] [nvarchar](max) NULL,
	[TITEL] [nvarchar](max) NULL,
	[ADR1] [nvarchar](max) NULL,
	[ADR2] [nvarchar](max) NULL,
	[ADR3] [nvarchar](max) NULL,
	[LAND_ID] [nvarchar](max) NULL,
	[PLZ] [nvarchar](max) NULL,
	[ORT] [nvarchar](max) NULL,
	[TELEFON1] [nvarchar](max) NULL,
	[TELEFON2] [nvarchar](max) NULL,
	[EMAIL] [nvarchar](max) NULL,
	[TELEFONINTERN] [nvarchar](max) NULL,
	[TELEFAX] [nvarchar](max) NULL,
	[ANREDE_NR] [smallint] NULL,
	[AHVNR] [nvarchar](max) NULL,
	[STDSATZ] [decimal](10, 2) NULL,
	[STDSATZINTERN] [decimal](10, 2) NULL,
	[PRODUKTIVPROZ] [decimal](6, 2) NULL,
	[MUTMIT_NR] [smallint] NULL,
	[STDSATZMUTIEREN] [smallint] NULL,
	[INTEXT_SCNR] [smallint] NOT NULL,
	[MONATAZ] [decimal](8, 2) NULL,
	[STATISTIK] [smallint] NULL,
	[KST] [nvarchar](max) NULL,
	[GEBDATUM] [datetime] NULL,
	[PASSWORT] [nvarchar](max) NULL,
	[EINTRITTSDATUM] [datetime] NULL,
	[AUSTRITTSDATUM] [datetime] NULL,
	[ANZAUSTRITTE] [smallint] NULL,
	[SYSSPRACHE_NR] [smallint] NOT NULL,
	[LV] [smallint] NULL,
	[DATENSPRACHE_NR] [smallint] NOT NULL,
	[SYSTEMADMIN] [smallint] NULL,
	[USERGROUP_NR] [smallint] NOT NULL,
	[LOHNSCHNITT] [nvarchar](10) NULL,
	[MITWECHSEL] [smallint] NULL,
	[MITZEITMUST] [smallint] NULL,
	[JOURNALZEITMUST] [smallint] NULL,
	[JOURNALZEITSAVE] [smallint] NULL,
	[TEXT1] [nvarchar](max) NULL,
	[TEXT2] [nvarchar](max) NULL,
	[TEXT3] [nvarchar](max) NULL,
	[TEXT4] [nvarchar](max) NULL,
	[TEXT5] [nvarchar](max) NULL,
	[TEXT6] [nvarchar](max) NULL,
	[TEXT7] [nvarchar](max) NULL,
	[TEXT8] [nvarchar](max) NULL,
	[TEXT9] [nvarchar](max) NULL,
	[TEXT10] [nvarchar](max) NULL,
	[DATUM1] [datetime] NULL,
	[DATUM2] [datetime] NULL,
	[DATUM3] [datetime] NULL,
	[DATUM4] [datetime] NULL,
	[DATUM5] [datetime] NULL,
	[DATUM6] [datetime] NULL,
	[NUMMER1] [decimal](12, 2) NULL,
	[NUMMER2] [decimal](12, 2) NULL,
	[NUMMER3] [decimal](12, 2) NULL,
	[NUMMER4] [decimal](12, 2) NULL,
	[NUMMER5] [decimal](12, 2) NULL,
	[NUMMER6] [decimal](12, 2) NULL,
	[NUMMER7] [decimal](12, 2) NULL,
	[NUMMER8] [decimal](12, 2) NULL,
	[NUMMER9] [decimal](12, 2) NULL,
	[BOOL1] [smallint] NULL,
	[BOOL2] [smallint] NULL,
	[BOOL3] [smallint] NULL,
	[BOOL4] [smallint] NULL,
	[BOOL5] [smallint] NULL,
	[BOOL6] [smallint] NULL,
	[BOOL7] [smallint] NULL,
	[BOOL8] [smallint] NULL,
	[BOOL9] [smallint] NULL,
	[BOOL10] [smallint] NULL,
	[BOOL11] [smallint] NULL,
	[BOOL12] [smallint] NULL,
	[BOOL13] [smallint] NULL,
	[BOOL14] [smallint] NULL,
	[BOOL15] [smallint] NULL,
	[MITSTRUKTUR_NR] [int] NULL,
	[MITPROZUORD] [smallint] NULL,
	[ABT_UCNR] [int] NULL,
	[MITFIBU] [smallint] NULL,
	[WEBSETTINGS] [nvarchar](max) NULL,
	[WEBSETTINGS2] [nvarchar](max) NULL,
	[WEBSETTINGS3] [nvarchar](max) NULL,
	[ROWVERSION] [binary](8) NOT NULL,
	[MITLEISTZUORD] [smallint] NOT NULL,
	[PROINERFLEIST] [smallint] NULL,
	[LEIINERFLEIST] [smallint] NULL,
	[TXTINERFLEIST] [smallint] NULL,
	[STDTAG] [decimal](10, 2) NULL,
	[PROZENTAZ] [decimal](10, 2) NULL,
	[FVB_BERECHTIGUNG] [smallint] NULL,
	[SPESENMUTIEREN] [smallint] NULL,
	[LISTBOX1] [int] NULL,
	[LISTBOX2] [int] NULL,
	[LISTBOX3] [int] NULL,
	[LISTBOX4] [int] NULL,
	[LISTBOX5] [int] NULL,
	[LISTBOX6] [int] NULL,
	[LISTBOX7] [int] NULL,
	[LISTBOX8] [int] NULL,
	[LISTBOX9] [int] NULL,
	[LISTBOX10] [int] NULL,
	[MITABTLEISTGRPZUORD] [smallint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[Honoris_PROJEKT]    Script Date: 23.04.2013 08:07:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Honoris_PROJEKT](
	[PROJEKT_NR] [decimal](10, 0) NOT NULL,
	[KUNDE_NR] [decimal](10, 0) NOT NULL,
	[VESR_NR] [int] NULL,
	[FIRMA_NR] [smallint] NOT NULL,
	[KNOTEN_NR] [int] NOT NULL,
	[KURZNAME] [nvarchar](max) NOT NULL,
	[BEZEICHNUNG] [nvarchar](max) NULL,
	[KOMMENTAR] [nvarchar](max) NULL,
	[PROBEGINN] [datetime] NULL,
	[PROENDE] [datetime] NULL,
	[MUTMIT_NR] [smallint] NULL,
	[GESPERRT] [smallint] NULL,
	[KST] [nvarchar](max) NULL,
	[FAKVORSCHLAG] [int] NULL,
	[PREISFIND_SCNR] [smallint] NOT NULL,
	[FAKSWITCH] [smallint] NULL,
	[INTEXT_SCNR] [smallint] NOT NULL,
	[FAKDRUCKVARIANTE] [int] NULL,
	[PROTYP_NR] [smallint] NULL,
	[DIENSTTEXT] [nvarchar](max) NULL,
	[SPESENTEXT] [nvarchar](max) NULL,
	[LV] [smallint] NULL,
	[MITARBEITER_NR] [int] NULL,
	[TEXT1] [nvarchar](max) NULL,
	[TEXT2] [nvarchar](max) NULL,
	[TEXT3] [nvarchar](max) NULL,
	[TEXT4] [nvarchar](max) NULL,
	[TEXT5] [nvarchar](max) NULL,
	[TEXT6] [nvarchar](max) NULL,
	[TEXT7] [nvarchar](max) NULL,
	[TEXT8] [nvarchar](max) NULL,
	[TEXT9] [nvarchar](max) NULL,
	[TEXT10] [nvarchar](max) NULL,
	[DATUM1] [datetime] NULL,
	[DATUM2] [datetime] NULL,
	[DATUM3] [datetime] NULL,
	[DATUM4] [datetime] NULL,
	[DATUM5] [datetime] NULL,
	[DATUM6] [datetime] NULL,
	[NUMMER1] [decimal](10, 0) NULL,
	[NUMMER2] [decimal](10, 0) NULL,
	[NUMMER3] [decimal](10, 0) NULL,
	[NUMMER4] [decimal](12, 2) NULL,
	[NUMMER5] [decimal](12, 2) NULL,
	[NUMMER6] [decimal](12, 2) NULL,
	[NUMMER7] [decimal](12, 2) NULL,
	[NUMMER8] [decimal](12, 2) NULL,
	[NUMMER9] [decimal](12, 2) NULL,
	[BOOL1] [smallint] NULL,
	[BOOL2] [smallint] NULL,
	[BOOL3] [smallint] NULL,
	[BOOL4] [smallint] NULL,
	[BOOL5] [smallint] NULL,
	[BOOL6] [smallint] NULL,
	[BOOL7] [smallint] NULL,
	[BOOL8] [smallint] NULL,
	[BOOL9] [smallint] NULL,
	[BOOL10] [smallint] NULL,
	[BOOL11] [smallint] NULL,
	[BOOL12] [smallint] NULL,
	[BOOL13] [smallint] NULL,
	[BOOL14] [smallint] NULL,
	[BOOL15] [smallint] NULL,
	[STDSATZ] [decimal](10, 2) NULL,
	[FVMIT_NR] [int] NULL,
	[SORTINDEX] [smallint] NOT NULL,
	[PROSTRUKTUR_NR] [int] NULL,
	[ABT_UCNR] [int] NULL,
	[PROGRUPPE_UCNR] [int] NULL,
	[FAKADRESSE_NR] [decimal](10, 0) NULL,
	[FAKKONTAKT_NR] [decimal](10, 0) NULL,
	[WAEHRUNG_NR] [smallint] NULL,
	[ROWVERSION] [binary](8) NOT NULL,
	[PROLEISTZUORD] [smallint] NOT NULL,
	[RUNDWERTANZEXT] [decimal](8, 2) NULL,
	[RUNDREGELANZEXT] [smallint] NULL,
	[WORDFAKPARAMETER] [nvarchar](max) NULL,
	[POSTADRESSE_NR] [decimal](10, 0) NULL,
	[POSTKONTAKT_NR] [decimal](10, 0) NULL,
	[MUTATIONSCODE] [smallint] NULL,
	[KSPAKTIV] [smallint] NULL,
	[FAKDRUCKPARAMETER] [nvarchar](max) NULL,
	[LISTBOX1] [int] NULL,
	[LISTBOX2] [int] NULL,
	[LISTBOX3] [int] NULL,
	[LISTBOX4] [int] NULL,
	[LISTBOX5] [int] NULL,
	[LISTBOX6] [int] NULL,
	[LISTBOX7] [int] NULL,
	[LISTBOX8] [int] NULL,
	[LISTBOX9] [int] NULL,
	[LISTBOX10] [int] NULL,
	[PROABTLEISTGRPZUORD] [smallint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[TXP_LVer_IN_AU]    Script Date: 23.04.2013 08:07:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TXP_LVer_IN_AU](
	[Id] [float] NULL,
	[Ticket_ID] [nvarchar](255) NULL,
	[CreatedDateTime] [datetime] NULL,
	[Besitzer] [nvarchar](255) NULL,
	[Status] [nvarchar](255) NULL,
	[Produkt] [nvarchar](255) NULL,
	[Betreff] [nvarchar](255) NULL,
	[Verantwortlicher] [nvarchar](255) NULL,
	[Klassifizierung] [nvarchar](255) NULL,
	[RfC_Thema] [nvarchar](255) NULL,
	[RfcBoard] [nvarchar](255) NULL,
	[Statusdatum] [datetime] NULL,
	[Prioritaet] [nvarchar](255) NULL,
	[TicketLink] [nvarchar](255) NULL,
	[User] [nvarchar](255) NULL,
	[CreateDateTime] [datetime] NULL,
	[ExecutedDateTime] [datetime] NULL,
	[CalculatedValue] [float] NULL,
	[Title] [nvarchar](255) NULL,
	[ForUserID] [nvarchar](255) NULL
) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[TXP_Ticket_Data]    Script Date: 23.04.2013 08:07:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TXP_Ticket_Data](
	[Statusid] [varchar](255) NOT NULL,
	[Id] [int] NOT NULL,
	[TicketID] [varchar](255) NULL,
	[Erstellungsdatum] [datetime] NULL,
	[Status_Alt] [varchar](255) NOT NULL,
	[Status_Neu] [varchar](255) NOT NULL,
	[TGNummer] [varchar](255) NULL,
	[Status_Changedate] [datetime] NULL,
	[Besitzergruppe] [varchar](255) NULL,
	[Produkt] [varchar](255) NULL,
	[Kategorie] [varchar](255) NULL,
	[Stoerungstyp] [varchar](255) NULL,
	[Prioritaet] [varchar](255) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO