You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
391 lines
11 KiB
391 lines
11 KiB
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
|
|
|
|
|