USE [master] GO /****** Object: Database [Reisekosten] Script Date: 08.12.2024 12:53:07 ******/ CREATE DATABASE [Reisekosten] GO ALTER DATABASE [Reisekosten] SET COMPATIBILITY_LEVEL = 100 GO ALTER DATABASE [Reisekosten] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [Reisekosten] SET ANSI_NULLS OFF GO ALTER DATABASE [Reisekosten] SET ANSI_PADDING OFF GO ALTER DATABASE [Reisekosten] SET ANSI_WARNINGS OFF GO ALTER DATABASE [Reisekosten] SET ARITHABORT OFF GO ALTER DATABASE [Reisekosten] SET AUTO_CLOSE ON GO ALTER DATABASE [Reisekosten] SET AUTO_SHRINK OFF GO ALTER DATABASE [Reisekosten] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [Reisekosten] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [Reisekosten] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [Reisekosten] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [Reisekosten] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [Reisekosten] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [Reisekosten] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [Reisekosten] SET ENABLE_BROKER GO ALTER DATABASE [Reisekosten] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [Reisekosten] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [Reisekosten] SET TRUSTWORTHY OFF GO ALTER DATABASE [Reisekosten] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [Reisekosten] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [Reisekosten] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [Reisekosten] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [Reisekosten] SET RECOVERY SIMPLE GO ALTER DATABASE [Reisekosten] SET MULTI_USER GO ALTER DATABASE [Reisekosten] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [Reisekosten] SET DB_CHAINING OFF GO ALTER DATABASE [Reisekosten] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [Reisekosten] SET TARGET_RECOVERY_TIME = 0 SECONDS GO ALTER DATABASE [Reisekosten] SET DELAYED_DURABILITY = DISABLED GO USE [Reisekosten] GO /****** Object: User [rk] Script Date: 19.05.2019 19:56:32 ******/ CREATE LOGIN [rk] WITH PASSWORD=N'rk', DEFAULT_DATABASE=[Reisekosten], DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO CREATE USER [rk] FOR LOGIN [rk] WITH DEFAULT_SCHEMA=[dbo] GO EXEC sp_addrolemember N'db_owner', N'rk' GO /****** Object: Table [dbo].[A1FORM] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[A1FORM]( [LNR] [int] IDENTITY(1,1) NOT NULL, [FELDNR] [numeric](3, 0) NULL, [FELD] [char](10) NULL, [FELDBEZ] [char](30) NULL, [ZEILE] [numeric](2, 0) NULL, [SPALTE] [numeric](2, 0) NULL, CONSTRAINT [PK_A1FORM] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[ABWES] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ABWES]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_ABWES] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_ABWES] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[AKTZ] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AKTZ]( [LNR] [int] IDENTITY(1,1) NOT NULL, [BEZ] [char](20) NULL, [SUM_AUSZ] [numeric](6, 0) NULL, [A_TOTAL] [decimal](9, 2) NULL, [TIMESTAMP] [char](24) NULL, [SPERRE] [bit] NULL, CONSTRAINT [PK_AKTZ] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_AKTZ] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[AUGRUND] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AUGRUND]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_AUGRUND] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_AUGRUND] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[BAHNCARD] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BAHNCARD]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [EMPFNR] [int] NULL, [TYP] [varchar](20) NULL, [KLASSE] [char](1) NULL, [DATVON] [smalldatetime] NULL, [DATBIS] [smalldatetime] NULL, [BETRAG] [numeric](7, 2) NULL, [SUMERST] [numeric](7, 2) NULL, [BCNR] [varchar](20) NULL, [GKA] [numeric](5, 2) NULL, [NAME1] [varchar](50) NULL, [NAME2] [varchar](50) NULL, CONSTRAINT [PK_BAHNCARD] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[BATCH0] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BATCH0]( [LNR] [int] IDENTITY(1,1) NOT NULL, [LAND] [char](2) NULL, [QUELLE] [char](8) NULL, [USERNAME] [char](8) NULL, [ORGE] [char](8) NULL, [STAPEL] [numeric](5, 0) NULL, [STAPDAT] [smalldatetime] NULL, [COUNTER] [numeric](5, 0) NULL, [DATNAME1] [char](40) NULL, [DATNAME2] [char](40) NULL, [DBEZ] [char](8) NULL, [TRENNZ] [char](1) NULL, [BGZETTEL] [bit] NULL, [ZAHLART] [bit] NULL, [BANK] [bit] NULL, [PROFIS] [bit] NULL, [KAP] [char](8) NULL, [TITEL] [char](8) NULL, [UTEIL] [char](10) NULL, [AKTZ] [char](20) NULL, [KLR] [bit] NULL, [KLRCOUNTER] [numeric](5, 0) NULL, [TZWECK] [char](54) NULL, [TBETRAG] [numeric](8, 2) NULL, [MSN] [char](5) NULL, [LIFNR] [char](3) NULL, [KASSENR] [char](3) NULL, [BVNR] [char](3) NULL, [NSI] [bit] NULL, [RESSORT] [char](3) NULL, [DST] [char](4) NULL, [BUCHKR] [char](4) NULL, [RECHNER] [char](4) NULL, [TRANSCODE] [char](4) NULL, [SUFFIX] [char](2) NULL, [NUMKR] [char](1) NULL, [NSISTART] [datetime] NULL, [KLR_KA] [char](20) NULL, [KLR_KS] [char](27) NULL, [KLR_KT] [char](20) NULL, [CPD] [char](12) NULL, [NSIUTEIL] [bit] NULL, [FI] [bit] NULL, [USERSEL] [bit] NULL, [KOMMSAP] [bit] NULL, [SEPA] [bit] NULL, [KSPFLICHT] [bit] NULL, [TITGR] [char](4) NULL, [HIS] [bit] NULL, [ZUSAMM] [bit] NULL, [KLR_AN] [varchar](20) NULL, [AZ] [bit] NULL, [PH2] [smalldatetime] NULL, [MAHN] [varchar](2) NULL, CONSTRAINT [PK_BATCH0] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[BATCH1] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BATCH1]( [LNR] [int] IDENTITY(1,1) NOT NULL, [NR] [int] NULL, [DATNAME] [char](70) NULL, [DATUM] [smalldatetime] NULL, [ZEIT] [char](5) NULL, [ANZAHL] [smallint] NULL, [SUMME] [numeric](8, 2) NULL, [AUSGABE] [smalldatetime] NULL, [SBLZ] [numeric](16, 0) NULL, [SKONTO] [numeric](16, 0) NULL, [SKAP] [numeric](16, 0) NULL, [STITEL] [numeric](16, 0) NULL, [BEM] [char](40) NULL, CONSTRAINT [PK_BATCH1] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[BATCHLK0] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BATCHLK0]( [LNR] [int] IDENTITY(1,1) NOT NULL, [LAND] [char](2) NULL, [QUELLE] [char](8) NULL, [USERNAME] [char](8) NULL, [ORGE] [char](8) NULL, [STAPEL] [numeric](5, 0) NULL, [STAPDAT] [smalldatetime] NULL, [COUNTER] [numeric](5, 0) NULL, [DATNAME1] [char](40) NULL, [DATNAME2] [char](40) NULL, [DBEZ] [char](8) NULL, [TRENNZ] [char](1) NULL, [BGZETTEL] [bit] NULL, [ZAHLART] [bit] NULL, [BANK] [bit] NULL, [PROFIS] [bit] NULL, [KAP] [char](8) NULL, [TITEL] [char](8) NULL, [UTEIL] [char](10) NULL, [AKTZ] [char](20) NULL, [KLR] [bit] NULL, [KLRCOUNTER] [numeric](5, 0) NULL, [TZWECK] [char](54) NULL, [TBETRAG] [numeric](8, 2) NULL, [MSN] [char](5) NULL, [LIFNR] [char](3) NULL, [KASSENR] [char](3) NULL, [BVNR] [char](3) NULL, [NSI] [bit] NULL, [RESSORT] [char](3) NULL, [DST] [char](4) NULL, [BUCHKR] [char](4) NULL, [RECHNER] [char](4) NULL, [TRANSCODE] [char](4) NULL, [SUFFIX] [char](2) NULL, [NUMKR] [char](1) NULL, [NSISTART] [datetime] NULL, [KLR_KA] [char](20) NULL, [KLR_KS] [char](27) NULL, [KLR_KT] [char](20) NULL, [CPD] [char](12) NULL, [NSIUTEIL] [bit] NULL, [FI] [bit] NULL, [USERSEL] [bit] NULL, [KOMMSAP] [bit] NULL, [SEPA] [bit] NULL, [KSPFLICHT] [bit] NULL, [TITGR] [char](4) NULL, [HIS] [bit] NULL, [ZUSAMM] [bit] NULL, [KLR_AN] [varchar](20) NULL, [AZ] [bit] NULL, CONSTRAINT [PK_BATCHLK0] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[BATCHLK1] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BATCHLK1]( [LNR] [int] IDENTITY(1,1) NOT NULL, [NR] [int] NULL, [DATNAME] [char](70) NULL, [DATUM] [smalldatetime] NULL, [ZEIT] [char](5) NULL, [ANZAHL] [smallint] NULL, [SUMME] [numeric](8, 2) NULL, [AUSGABE] [smalldatetime] NULL, [SBLZ] [numeric](16, 0) NULL, [SKONTO] [numeric](16, 0) NULL, [SKAP] [numeric](16, 0) NULL, [STITEL] [numeric](16, 0) NULL, [BEM] [char](40) NULL, CONSTRAINT [PK_BATCHLK1] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[BENUTZER] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BENUTZER]( [LNR] [int] IDENTITY(1,1) NOT NULL, [USERNAME] [char](20) NULL, [BEARB] [char](30) NULL, [UNTERZ] [char](30) NULL, [KBEZ] [char](8) NULL, [AZ] [char](20) NULL, [TEL] [char](20) NULL, [DRUVO] [bit] NULL, [DRUVO1] [bit] NULL, [DRUAUSW] [bit] NULL, [APPMODE] [bit] NULL, [SELEKTIV] [bit] NULL, [RKPRINT] [bit] NULL, [NOEMPF] [bit] NULL, [JAHR] [bit] NULL, [OEH] [char](30) NULL, [DIENST] [int] NULL, [MAILADR] [char](60) NULL, [EMPFSORT] [bit] NULL, CONSTRAINT [PK_BENUTZER] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[BFBEGR] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BFBEGR]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_BFBEGR] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_BFBEGR] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[BLZ] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BLZ]( [LNR] [int] IDENTITY(1,1) NOT NULL, [BLZ] [char](10) NULL, [BANKNAME] [char](35) NULL, [DATUM] [smalldatetime] NULL, CONSTRAINT [PK_BLZ] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_BLZ] UNIQUE NONCLUSTERED ( [BLZ] 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 /****** Object: Table [dbo].[BUDGET] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BUDGET]( [LNR] [int] IDENTITY(1,1) NOT NULL, [JAHR] [char](2) NULL, [BEZ] [char](20) NULL, [ANSATZ] [numeric](18, 2) NULL, [SUM_AUSZ] [numeric](6, 0) NULL, [A_TOTAL] [numeric](12, 2) NULL, [REST] [numeric](12, 2) NULL, CONSTRAINT [PK_BUDGET] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_BUDGET] UNIQUE NONCLUSTERED ( [BEZ] ASC, [JAHR] 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 /****** Object: Table [dbo].[DAGANACHT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DAGANACHT]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ANR] [int] NOT NULL, [TAG] [smalldatetime] NOT NULL, [AU] [bit] NOT NULL, [GRUND] [char](1) NOT NULL, [UEBKOST1] [numeric](7, 2) NOT NULL, [ABZUG1] [char](1) NOT NULL, [MBUMST1] [char](2) NOT NULL, [LAND] [char](20) NULL, [GRENZUEB] [char](5) NULL, [FRSTKOST1] [numeric](7, 2) NULL, [WG1] [char](3) NULL, CONSTRAINT [PK_DAGANACHT] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[DAGATAGE] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DAGATAGE]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ANR] [int] NOT NULL, [TAG] [smalldatetime] NOT NULL, [FS] [bit] NOT NULL, [ME] [bit] NOT NULL, [AE] [bit] NOT NULL, [LAND] [varchar](40) NULL, [GRENZUEB] [char](5) NULL, [WG1] [char](3) NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, CONSTRAINT [PK_DAGATAGE] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[DIENSTSTELLE] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DIENSTSTELLE]( [LNR] [int] IDENTITY(1,1) NOT NULL, [NAME1] [char](40) NULL, [NAME2] [char](40) NULL, [ORT] [char](25) NULL, [ABSENDER] [char](100) NULL, [LOGO] [char](40) NULL, CONSTRAINT [PK_DIENSTSTELLE] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[DIRKO] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DIRKO]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [BEZ] [char](30) NULL, [BETRAG] [numeric](7, 2) NULL, CONSTRAINT [PK_DIRKO] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[DRANTRAG] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DRANTRAG]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ZIEL] [varchar](2000) NULL, [DAT1] [smalldatetime] NULL, [UHR1] [char](5) NULL, [DAT2] [smalldatetime] NULL, [UHR2] [char](5) NULL, [XDAT1] [smalldatetime] NULL, [XUHR1] [char](5) NULL, [XDAT2] [smalldatetime] NULL, [XUHR2] [char](5) NULL, [ORT1] [varchar](50) NULL, [ORT2] [varchar](50) NULL, [ORTBEGR] [varchar](2000) NULL, [BF_OVM] [bit] NULL, [BF_DW] [bit] NULL, [BF_DWS] [bit] NULL, [BF_FLUG] [bit] NULL, [BF_MITF] [bit] NULL, [BF_BEGR] [char](1) NULL, [BF_BEGRTXT] [varchar](200) NULL, [RS_DW] [bit] NULL, [RS_DWTXT] [varchar](200) NULL, [RS_FLUG] [bit] NULL, [RS_FLUGTXT] [varchar](200) NULL, [RS_HOTEL] [bit] NULL, [RS_HOTELTXT] [varchar](200) NULL, [RS_BAHN] [bit] NULL, [RS_BAHNTXT] [varchar](200) NULL, [KOSTERSATZ] [varchar](50) NULL, [DR_STATUS] [char](1) NULL, [GEN_ID] [int] NULL, [GEN_NAME] [varchar](50) NULL, [GEN_DATUM] [smalldatetime] NULL, [RK_LNR] [int] NULL, [A_DATUM] [smalldatetime] NULL, [EMPFID] [int] NULL, [EMPFNAME] [varchar](50) NULL, [GEN_STATUS] [char](1) NULL, [RZWECK] [varchar](2000) NULL, [DR_ART] [char](1) NULL, [BF_PKW] [bit] NULL, [RS_DWS] [bit] NULL, [RS_DWSTXT] [varchar](200) NULL, [RS_STATUS] [char](1) NULL, [RS_DATUM] [smalldatetime] NULL, [RSE_BAHN] [bit] NULL, [RSE_BAHNTXT] [varchar](200) NULL, [RSE_DW] [bit] NULL, [RSE_DWTXT] [varchar](200) NULL, [RSE_DWS] [bit] NULL, [RSE_DWSTXT] [varchar](200) NULL, [RSE_FLUG] [bit] NULL, [RSE_FLUGTXT] [varchar](200) NULL, [RSE_HOTEL] [bit] NULL, [RSE_HOTELTXT] [varchar](200) NULL, [GEN2_ID] [int] NULL, [RSE_STATUS] [char](1) NULL, [RSE_TXT] [varchar](200) NULL, [HH_STATUS] [char](1) NULL, [HH_TXT] [varchar](200) NULL, [HH_DATUM] [smalldatetime] NULL, [GEN_TXT] [varchar](2000) NULL, [LAND] [varchar](40) NULL, [WLAND] [int] NULL, [PAUSCH] [bit] NULL, [RS_ID] [int] NULL, [KOSTEN] [numeric](7, 2) NULL, [VERZICHT] [bit] NULL, [ORT1LIST] [varchar](30) NULL, [ORT2LIST] [varchar](30) NULL, [GENTXT2] [varchar](2000) NULL, [SGEN_ID] [int] NULL, [WLG_NAME] [varchar](50) NULL, [GEN_TXTS] [varchar](2000) NULL, [BF_KEIN] [bit] NULL, [WG] [char](3) NULL, [KLR_KS1B] [numeric](8, 2) NULL, [KLR_KS2B] [numeric](8, 2) NULL, [KLR_KS3B] [numeric](8, 2) NULL, [KLR_KS4B] [numeric](8, 2) NULL, [KLR_KT1B] [numeric](8, 2) NULL, [KLR_KT2B] [numeric](8, 2) NULL, [KLR_KT3B] [numeric](8, 2) NULL, [KLR_KT4B] [numeric](8, 2) NULL, [KLR_KS1W] [char](3) NULL, [KLR_KS2W] [char](3) NULL, [KLR_KS3W] [char](3) NULL, [KLR_KS4W] [char](3) NULL, [KLR_KT1W] [char](3) NULL, [KLR_KT2W] [char](3) NULL, [KLR_KT3W] [char](3) NULL, [KLR_KT4W] [char](3) NULL, [VORLAGE] [varchar](60) NULL, [ORT_BEG1] [char](1) NULL, [ORT_BEG2] [char](1) NULL, [HINWEIS] [varchar](2000) NULL, [ABW_LIST] [char](1) NULL, [ABW_TXT] [varchar](2000) NULL, [VORSCHUSS] [bit] NULL, [VBETRAG] [numeric](8, 2) NULL, [GENTXT3] [varchar](2000) NULL, [ANLAGE1] [varchar](200) NULL, [ANLAGE2] [varchar](200) NULL, [ANLAGE3] [varchar](200) NULL, [BCINFO] [char](30) NULL, [OEH] [char](8) NULL, [ZUSTHH] [char](20) NULL, [KSCHANGED] [char](30) NULL, [KTCHANGED] [char](30) NULL, [GSTUFEN] [int] NULL, [SGEN_NAME] [varchar](50) NULL, [GENTXTS2] [varchar](2000) NULL, [GENTXTS3] [varchar](2000) NULL, [BF_TAXI] [bit] NULL, [KOSTERSATZOG] [numeric](8, 2) NULL, [ERSTATTOG] [numeric](8, 2) NULL, [KLRCHGNAME] [varchar](50) NULL, [KLRCHGDAT] [smalldatetime] NULL, [ZGENNAME] [varchar](50) NULL, [ZGENDAT] [smalldatetime] NULL, [TGVERZICHT] [bit] NULL, [KOSTERSATZMM] [bit] NULL, [MITREIS] [varchar](2000) NULL, [KOSTENTXT] [varchar](2000) NULL, [BF_PKWZ] [bit] NULL, [BF_RAD] [bit] NULL, [BF_MIETW] [bit] NULL, [MITFBEI] [varchar](50) NULL, [MITNPERS] [varchar](50) NULL, [KLR_AN1B] [numeric](8, 2) NULL, [KLR_AN2B] [numeric](8, 2) NULL, [KLR_AN3B] [numeric](8, 2) NULL, [KLR_AN4B] [numeric](8, 2) NULL, [HHBEST] [bit] NULL, [PRIVAT] [bit] NULL, [REISERL] [bit] NULL, [BEGR] [bit] NULL, [TAGRUECK] [bit] NULL, [KOSTEN1] [numeric](7, 2) NULL, [KOSTEN2] [numeric](7, 2) NULL, [KOSTEN3] [numeric](7, 2) NULL, [KOSTEN4] [numeric](7, 2) NULL, [PRIVERL] [varchar](2000) NULL, [BF_PKW_BEGR] [char](1) NULL, [BF_PKWZ_BEGR] [char](1) NULL, [BF_DW_BEGR] [char](1) NULL, [BF_DWS_BEGR] [char](1) NULL, [BF_MIETW_BEGR] [char](1) NULL, [BF_TAXI_BEGR] [char](1) NULL, [BF_FLUG_BEGR] [char](1) NULL, [FKVERZICHT] [bit] NULL, [UKVERZICHT] [bit] NULL, [VERZICHTERL] [varchar](2000) NULL, [BF_PKW_BEGRTXT] [varchar](100) NULL, [BF_PKWZ_BEGRTXT] [varchar](100) NULL, [BF_DW_BEGRTXT] [varchar](100) NULL, [BF_DWS_BEGRTXT] [varchar](100) NULL, [BF_MIETW_BEGRTXT] [varchar](100) NULL, [BF_TAXI_BEGRTXT] [varchar](100) NULL, [BF_FLUG_BEGRTXT] [varchar](100) NULL, [SEMBEZ] [varchar](200) NULL, [SEMNR] [varchar](50) NULL, [SEMART] [char](1) NULL, [SEMTG] [char](1) NULL, [SEMERL] [varchar](200) NULL, [SEMVERM] [varchar](200) NULL, [BEGRX] [varchar](1) NULL, [SGEN_MM] [bit] NULL, [KLR_KS1] [varchar](27) NULL, [KLR_KS2] [varchar](27) NULL, [KLR_KS3] [varchar](27) NULL, [KLR_KS4] [varchar](27) NULL, [KLR_KT1] [varchar](20) NULL, [KLR_KT2] [varchar](20) NULL, [KLR_KT3] [varchar](20) NULL, [KLR_KT4] [varchar](20) NULL, [KLR_AN1] [varchar](20) NULL, [KLR_AN2] [varchar](20) NULL, [KLR_AN3] [varchar](20) NULL, [KLR_AN4] [varchar](20) NULL, [KLR_KS1P] [smallint] NULL, [KLR_KS2P] [smallint] NULL, [KLR_KS3P] [smallint] NULL, [KLR_KS4P] [smallint] NULL, [KLR_KT1P] [smallint] NULL, [KLR_KT2P] [smallint] NULL, [KLR_KT3P] [smallint] NULL, [KLR_KT4P] [smallint] NULL, [KLR_AN1P] [smallint] NULL, [KLR_AN2P] [smallint] NULL, [KLR_AN3P] [smallint] NULL, [KLR_AN4P] [smallint] NULL, CONSTRAINT [PK_DRANTRAG] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[DRART] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DRART]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](30) NULL, [KSV] [char](20) NULL, CONSTRAINT [PK_DRART] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DRART] UNIQUE NONCLUSTERED ( [SCHL] 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 /****** Object: Table [dbo].[DRARTON] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DRARTON]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, [BF] [bit] NULL, [KLR_KA] [varchar](30) NULL, [KSV] [char](20) NULL, CONSTRAINT [PK_DRARTON] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DRARTON] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[DRSTAT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DRSTAT]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_DRSTAT] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DRSTAT] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[EMPF] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[EMPF]( [LNR] [int] IDENTITY(1,1) NOT NULL, [NAME1] [char](25) NULL, [NAME2] [char](25) NULL, [PERSNR] [char](14) NULL, [GES] [char](1) NULL, [TEL] [varchar](16) NULL, [FAX] [varchar](16) NULL, [STRASSE] [varchar](30) NULL, [PLZ] [varchar](6) NULL, [ORT] [char](25) NULL, [BLZ] [char](8) NULL, [KONTO] [char](10) NULL, [BANK] [varchar](35) NULL, [KFZ] [bit] NULL, [KFZVON] [smalldatetime] NULL, [KFZBIS] [smalldatetime] NULL, [K600] [bit] NULL, [DIENSTORT] [varchar](35) NULL, [BC] [bit] NULL, [BCKLASSE] [char](30) NULL, [BCDATUM] [smalldatetime] NULL, [TGGRU] [char](1) NULL, [TGBUCH] [char](1) NULL, [TGAB] [smalldatetime] NULL, [TGBIS] [smalldatetime] NULL, [TGUMZ] [bit] NULL, [TGUMDAT] [smalldatetime] NULL, [TGHEIM] [numeric](5, 2) NULL, [TGPEND] [bit] NULL, [TGPKOST] [numeric](6, 2) NULL, [TGPKM] [numeric](3, 0) NULL, [TGPKMA] [numeric](3, 0) NULL, [TGVERP] [bit] NULL, [TGKUERZ] [bit] NULL, [TGZIELV] [bit] NULL, [TGBEGR] [bit] NULL, [TGOEFF] [bit] NULL, [TGPVERG] [numeric](7, 2) NULL, [TGREIS] [numeric](2, 0) NULL, [TGBEFRIST] [bit] NULL, [SUM_AUSZ] [numeric](5, 0) NULL, [AKTZ] [char](20) NULL, [ZWECK] [char](20) NULL, [VSZU] [numeric](9, 2) NULL, [VSAB] [numeric](9, 2) NULL, [VSSALDO] [numeric](9, 2) NULL, [KUERZ] [bit] NULL, [ART] [char](1) NULL, [TITEL] [varchar](15) NULL, [OEH] [char](8) NULL, [KLR_KA] [char](20) NULL, [KLR_KS] [char](27) NULL, [KLR_KT] [char](20) NULL, [DSTADR1] [varchar](30) NULL, [DSTADR2] [varchar](30) NULL, [EMAIL] [varchar](60) NULL, [TIMESTAMP] [char](24) NULL, [LNRIMPORT] [int] NULL, [KLR_AN] [char](20) NULL, [ZA] [char](1) NULL, [TGSTFR03] [smalldatetime] NULL, [TGSTFR24] [smalldatetime] NULL, [TGMANFR] [bit] NULL, [INS_DATUM] [smalldatetime] NULL, [INS_USER] [char](20) NULL, [SAPLAND] [char](3) NULL, [USERID] [char](30) NULL, [BEM] [varchar](600) NULL, [BIC] [varchar](11) NULL, [IBAN] [varchar](34) NULL, [VERTR1_ID] [int] NULL, [VERTR2_ID] [int] NULL, [GEN] [bit] NULL, [GEN_ID] [int] NULL, [GEN_NAME] [char](30) NULL, [VERTR1_NAME] [char](30) NULL, [VERTR2_NAME] [char](30) NULL, [GEN2_ID] [int] NULL, [GEN2_NAME] [char](30) NULL, [RSTELLE] [bit] NULL, [KLR_FP] [char](26) NULL, [HHSTELLE] [bit] NULL, [RS_ID] [int] NULL, [RS_NAME] [char](30) NULL, [PW] [varchar](20) NULL, [MAN] [char](4) NULL, [KAP] [char](8) NULL, [HHTITEL] [char](8) NULL, [UTEIL] [char](10) NULL, [TGPKMM] [numeric](3, 0) NULL, [SGEN_NAME] [char](30) NULL, [SGEN_ID] [int] NULL, [KVERGL] [bit] NULL, [ERLAUBNIS] [bit] NULL, [ENDE] [smalldatetime] NULL, [BCCHECK] [bit] NULL, [TITGR] [char](4) NULL, [KSV] [char](20) NULL, [TGSTEU] [bit] NULL, [TGBEGRU] [bit] NULL, [BSTELLE] [char](10) NULL, [ASSIST] [bit] NULL, [BCNR] [varchar](20) NULL, [DIENSTADR] [bit] NULL, [OEH2] [char](8) NULL, [OEH3] [char](8) NULL, [KREDITOR] [varchar](40) NULL, [SAMMEL] [bit] NULL, [GESAMT] [bit] NULL, [PW_CRYPT] [varbinary](512) NULL, [PW_SAVE] [varchar](20) NULL, [OEH4] [char](8) NULL, [OEH5] [char](8) NULL, [OEH6] [char](8) NULL, [TGAKM] [numeric](4, 0) NULL, [LK] [bit] NULL, [TGUEBKOST] [numeric](7, 2) NULL, [OEH7] [char](8) NULL, [OEH8] [char](8) NULL, [OEH9] [char](8) NULL, [OEH10] [char](8) NULL, [VSBEGINN] [smalldatetime] NULL, [TGSGRU] [varchar](5) NULL, [FAHRRAD] [bit] NULL, CONSTRAINT [PK_EMPF] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[FAHRKO] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FAHRKO]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [BEZ] [char](30) NULL, [BETRAG] [numeric](7, 2) NULL, [WG] [char](3) NULL, [WGBETRAG] [numeric](7, 2) NULL, [KURS] [numeric](10, 5) NULL, [ABW_KURS] [numeric](10, 5) NULL, [SB] [bit] NULL, [BETRAG1] [numeric](6, 2) NULL, [STEUER1] [numeric](6, 2) NULL, [BETRAG2] [numeric](6, 2) NULL, [STEUER2] [numeric](6, 2) NULL, [BETRAG3] [numeric](6, 2) NULL, [BC] [bit] NULL, [NETTO] [numeric](7, 2) NULL, [STEUSATZ1] [smallint] NULL, [STEUSATZ2] [smallint] NULL, [DIREKT] [bit] NULL, [FBETRAG] [numeric](7, 2) NULL, CONSTRAINT [PK_FAHRKO] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[GRENZUEB] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[GRENZUEB]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](5) NULL, [ANR] [int] NULL, [TAG] [smalldatetime] NULL, [LAND] [char](40) NULL, [UHRZEIT] [char](5) NULL, [GUNR] [char](1) NULL, [GUTEXT] [char](40) NULL, [ZIELLAND] [bit] NULL, CONSTRAINT [PK_GRENZUEB] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[HUEL] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[HUEL]( [LNR] [int] IDENTITY(1,1) NOT NULL, [HHST] [char](40) NULL, [ART] [char](1) NULL, [NR] [int] NULL, [ZAHLDAT] [smalldatetime] NULL, [NAME1] [char](25) NULL, [NAME2] [char](25) NULL, [EMPFNR] [int] NULL, [BETRAG] [numeric](9, 2) NULL, [DMBETRAG] [numeric](7, 2) NULL, [ZWECK] [char](60) NULL, [ZBEGR] [char](320) NULL, [AZ] [char](20) NULL, [AOTYP] [char](2) NULL, [TYP] [char](1) NULL, [ANLG] [numeric](2, 0) NULL, [FAELLIG] [smalldatetime] NULL, [RKVS] [char](1) NULL, [VSBETRAG] [numeric](9, 2) NULL, [A_DATUM] [smalldatetime] NULL, [DR_ART] [char](1) NULL, [GLORT] [char](1) NULL, [GLTAG] [numeric](3, 0) NULL, [DAT1] [smalldatetime] NULL, [DAT2] [smalldatetime] NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, [DAU1] [char](5) NULL, [DAU2] [char](5) NULL, [ZIEL] [char](50) NULL, [AMTU_JN] [char](1) NULL, [AMT_U] [numeric](3, 0) NULL, [AMT_JN] [char](1) NULL, [AMT_F] [numeric](3, 0) NULL, [AMT_M] [numeric](3, 0) NULL, [AMT_A] [numeric](3, 0) NULL, [TAG3] [numeric](3, 0) NULL, [BEGR] [char](1) NULL, [KM4] [smallint] NULL, [KM5] [smallint] NULL, [BETR3] [numeric](5, 2) NULL, [BETR4] [numeric](5, 2) NULL, [BETR5] [numeric](5, 2) NULL, [PERS5] [numeric](2, 0) NULL, [FBEZ] [char](50) NULL, [NBEZ] [char](50) NULL, [FABEZ] [char](50) NULL, [TAGKOST] [numeric](7, 2) NULL, [UEBKOST] [numeric](7, 2) NULL, [MBUMST] [char](2) NULL, [ABZUG] [char](1) NULL, [SUM2] [numeric](7, 2) NULL, [SUM3] [numeric](7, 2) NULL, [SUM4] [numeric](7, 2) NULL, [SUM5] [numeric](7, 2) NULL, [SUM6] [numeric](7, 2) NULL, [SUM7] [numeric](7, 2) NULL, [SUM8] [numeric](7, 2) NULL, [SUM9] [numeric](7, 2) NULL, [SUM10] [numeric](9, 2) NULL, [KM52] [smallint] NULL, [KM52BIS] [numeric](7, 0) NULL, [ASMERK] [bit] NULL, [ASNR] [numeric](4, 0) NULL, [ASBETR] [numeric](7, 2) NULL, [HINW] [varchar](2000) NULL, [AUSLAND] [char](1) NULL, [AUS_D] [smalldatetime] NULL, [AUS_Z] [char](5) NULL, [EIN_D] [smalldatetime] NULL, [EIN_Z] [char](5) NULL, [LAND] [char](8) NULL, [KZG] [char](1) NULL, [DG_AUSLAG] [numeric](5, 2) NULL, [DG_ERSP] [numeric](5, 2) NULL, [DG_ZUS] [char](1) NULL, [BATNR] [numeric](9, 0) NULL, [BATNRS] [numeric](5, 0) NULL, [DRUDAT] [smalldatetime] NULL, [TGGRU] [char](1) NULL, [TGMON] [char](7) NULL, [TGDAT1] [smalldatetime] NULL, [TGDAT2] [smalldatetime] NULL, [TGREDU] [char](80) NULL, [TGOHNE] [char](80) NULL, [TGRUECK] [char](1) NULL, [TGPKOST] [numeric](7, 2) NULL, [TGPKOSTF] [numeric](7, 2) NULL, [TGPKOSTA] [numeric](7, 2) NULL, [TGPKOSTS] [numeric](7, 2) NULL, [TGPKOSTV] [numeric](7, 2) NULL, [TGPKM] [numeric](3, 0) NULL, [TGPKMA] [numeric](3, 0) NULL, [TGPTAGE] [numeric](2, 0) NULL, [TGPTAGE0] [numeric](2, 0) NULL, [TGPTAGEX] [numeric](3, 0) NULL, [TGPTAGEA] [numeric](3, 0) NULL, [TGVTAGE] [numeric](3, 0) NULL, [TGHEIM] [numeric](2, 0) NULL, [TGMEHR] [numeric](7, 2) NULL, [TGHSUMM] [numeric](7, 2) NULL, [TGSUMM1] [numeric](7, 2) NULL, [TGVERP] [numeric](7, 2) NULL, [TGKMANRE] [numeric](7, 2) NULL, [TGL1] [char](31) NULL, [TGL2] [char](31) NULL, [STBETRAG] [numeric](7, 2) NULL, [DMSTEUER] [numeric](7, 2) NULL, [STSONST] [numeric](7, 2) NULL, [STPAUSCH] [numeric](7, 2) NULL, [STFREI] [numeric](7, 2) NULL, [STKM] [numeric](4, 0) NULL, [STFAKOST] [numeric](7, 2) NULL, [KMSTFREI] [numeric](7, 2) NULL, [STSACHBEZ] [numeric](7, 2) NULL, [STDATUM] [smalldatetime] NULL, [STEU_F] [numeric](3, 0) NULL, [STEU_M] [numeric](3, 0) NULL, [STEU_A] [numeric](3, 0) NULL, [STMELD] [char](1) NULL, [STRFREI] [numeric](7, 2) NULL, [STTAG] [numeric](7, 2) NULL, [STUEB] [numeric](7, 2) NULL, [ZA] [char](1) NULL, [FELDAUF] [numeric](7, 2) NULL, [KEINTG] [numeric](3, 0) NULL, [EINTAG] [bit] NULL, [ZUSCHUSS] [numeric](7, 2) NULL, [STNEBVOLL] [numeric](7, 2) NULL, [NEB_CNT] [smallint] NULL, [MIT_CNT] [smallint] NULL, [FAHR_CNT] [smallint] NULL, [SUMTG] [numeric](7, 2) NULL, [SUMABZ] [numeric](7, 2) NULL, [PENSION] [numeric](7, 2) NULL, [PENS_F] [numeric](3, 0) NULL, [PENS_M] [numeric](3, 0) NULL, [PENS_A] [numeric](3, 0) NULL, [ZUSAMM] [bit] NULL, [OEH] [char](8) NULL, [ABZUG_FS] [numeric](7, 2) NULL, [MB_BELEG] [numeric](7, 2) NULL, [MB_NERST] [numeric](7, 2) NULL, [SOZVERS] [numeric](7, 2) NULL, [KLRSUM] [numeric](7, 2) NULL, [Z_BETRAG] [numeric](7, 2) NULL, [Z_PROZ] [numeric](3, 0) NULL, [Z_MAX] [numeric](7, 2) NULL, [STAP0] [int] NULL, [STAP1] [int] NULL, [WG] [char](3) NULL, [TIMESTAMP] [char](24) NULL, [LNRIMPORT] [int] NULL, [KLR_KA] [char](20) NULL, [KLR_KS] [char](27) NULL, [KLR_KT] [char](20) NULL, [KASSENZ] [char](16) NULL, [AUV_VERP] [char](2) NULL, [AUV_UEB] [numeric](7, 2) NULL, [AUV_ERSTU] [numeric](7, 2) NULL, [PERSNR] [char](14) NULL, [KLR_AN] [char](20) NULL, [USER1] [char](20) NULL, [D1] [datetime] NULL, [USER2] [char](20) NULL, [D2] [datetime] NULL, [USER3] [char](20) NULL, [D3] [datetime] NULL, [LBVUV] [numeric](7, 2) NULL, [LBVP1] [numeric](7, 2) NULL, [LBVP2] [numeric](7, 2) NULL, [LBVH1] [numeric](7, 2) NULL, [LBVH2] [numeric](7, 2) NULL, [STAPELID] [char](30) NULL, [GRENZKM] [numeric](6, 0) NULL, [TGFAKOZU] [numeric](7, 2) NULL, [BUCHNR] [char](18) NULL, [BELEGNR] [char](21) NULL, [UEBDAT] [datetime] NULL, [PROTOK] [char](160) NULL, [KM4T] [smallint] NULL, [AKZG] [bit] NULL, [SUMABZFS] [numeric](7, 2) NULL, [UEBTAGE] [smallint] NULL, [UEBTAGEV] [smallint] NULL, [UEBTAGEK] [smallint] NULL, [STUNTER] [numeric](7, 2) NULL, [STOEVUEB] [numeric](7, 2) NULL, [KLR_KS2] [char](27) NULL, [KLR_KT2] [char](20) NULL, [MAILDAT] [smalldatetime] NULL, [KMF] [numeric](5, 0) NULL, [TGPKMM] [numeric](3, 0) NULL, [TGKMMIT] [numeric](7, 2) NULL, [TGPTAGEM] [numeric](3, 0) NULL, [TGPKOSTM] [numeric](7, 2) NULL, [TGHKOST] [numeric](7, 2) NULL, [TGFAKO] [numeric](7, 2) NULL, [ZUSCHART] [char](1) NULL, [DIRKO] [numeric](8, 2) NULL, [SUM12] [numeric](8, 2) NULL, [SWZ] [smallint] NULL, [UEBSTEUER] [numeric](7, 2) NULL, [SUMSTEUER] [numeric](7, 2) NULL, [NEBKOSTEU] [numeric](7, 2) NULL, [FAKOSTEU1] [numeric](7, 2) NULL, [FAKOSTEU2] [numeric](7, 2) NULL, [NEBKOSTEU1] [numeric](7, 2) NULL, [NEBKOSTEU2] [numeric](7, 2) NULL, [SUMSTEUER1] [numeric](7, 2) NULL, [SUMSTEUER2] [numeric](7, 2) NULL, [UEBSTEUER1] [numeric](7, 2) NULL, [UEBSTEUER2] [numeric](7, 2) NULL, [FAKOSTEU] [numeric](7, 2) NULL, [FRSTKOST] [numeric](7, 2) NULL, [RZWECK] [varchar](100) NULL, [KVERGL] [bit] NULL, [UEBKOST1] [numeric](7, 2) NULL, [STEUTG] [numeric](7, 2) NULL, [STRFREIWE] [numeric](7, 2) NULL, [STRFREIFK] [numeric](7, 2) NULL, [STRFREINK] [numeric](7, 2) NULL, [VERPP] [numeric](7, 2) NULL, [STBETRAGE] [numeric](7, 2) NULL, [STBETRAGP] [numeric](7, 2) NULL, [STDATUME] [smalldatetime] NULL, [STDATUMP] [smalldatetime] NULL, [BCERSP] [numeric](7, 2) NULL, [DIREKT] [bit] NULL, [FRSTANT] [numeric](7, 2) NULL, [BIC] [varchar](11) NULL, [IBAN] [varchar](34) NULL, [KTOINHABER] [varchar](30) NULL, [UEBDATLK] [smalldatetime] NULL, [BATNRLK] [int] NULL, [BATNRSLK] [int] NULL, [RF_LNR] [int] NULL, [KDATUM] [smalldatetime] NULL, [KVERLAUF] [varchar](200) NULL, [HFOEFF] [bit] NULL, [RF_BETRAG] [numeric](7, 2) NULL, [RF_STBETR] [numeric](7, 2) NULL, [RF_SUM12] [numeric](7, 2) NULL, [RF_LKV] [numeric](7, 2) NULL, [RF_LKVF] [numeric](7, 2) NULL, [RF_LKVS] [numeric](7, 2) NULL, [RF_LKVP] [numeric](7, 2) NULL, [RF_LKUF] [numeric](7, 2) NULL, [RF_LKUS] [numeric](7, 2) NULL, [RF_LKUP] [numeric](7, 2) NULL, [RF_LKF] [numeric](7, 2) NULL, [RF_LKFF] [numeric](7, 2) NULL, [RF_LKFS] [numeric](7, 2) NULL, [RF_LKFP] [numeric](7, 2) NULL, [RF_LKE] [numeric](7, 2) NULL, [RF_LKEF] [numeric](7, 2) NULL, [RF_LKES] [numeric](7, 2) NULL, [RF_LKEP] [numeric](7, 2) NULL, [RF_LKN] [numeric](7, 2) NULL, [RF_LKNF] [numeric](7, 2) NULL, [RF_LKNS] [numeric](7, 2) NULL, [RF_LKNP] [numeric](7, 2) NULL, [RF_LKS] [numeric](7, 2) NULL, [STPFLTG] [numeric](7, 2) NULL, [STPFLFK] [numeric](7, 2) NULL, [STPFLUK] [numeric](7, 2) NULL, [LKV] [numeric](7, 2) NULL, [LKVF] [numeric](7, 2) NULL, [LKVS] [numeric](7, 2) NULL, [LKVP] [numeric](7, 2) NULL, [LKUF] [numeric](7, 2) NULL, [LKUS] [numeric](7, 2) NULL, [LKUP] [numeric](7, 2) NULL, [LKF] [numeric](7, 2) NULL, [LKFF] [numeric](7, 2) NULL, [LKFS] [numeric](7, 2) NULL, [LKFP] [numeric](7, 2) NULL, [LKE] [numeric](7, 2) NULL, [LKEF] [numeric](7, 2) NULL, [LKES] [numeric](7, 2) NULL, [LKEP] [numeric](7, 2) NULL, [LKN] [numeric](7, 2) NULL, [LKNF] [numeric](7, 2) NULL, [LKNS] [numeric](7, 2) NULL, [LKNP] [numeric](7, 2) NULL, [LKS] [numeric](7, 2) NULL, [LKU] [numeric](7, 2) NULL, [RF_LKU] [numeric](7, 2) NULL, [SACHBEZ] [numeric](7, 2) NULL, [TGMEHRV] [numeric](7, 2) NULL, [TGMEHRN] [numeric](7, 2) NULL, [KVERWEIS] [int] NULL, [RF_LNRX] [int] NULL, [TGPFAKO] [numeric](7, 2) NULL, [LKSACHBEZ] [numeric](7, 2) NULL, [RF_LKSACHB] [numeric](7, 2) NULL, [TGAKM] [numeric](4, 0) NULL, [SUM10A] [numeric](9, 2) NULL, [VSERL] [bit] NULL, [VSABR] [numeric](9, 2) NULL, [HFANZAHL] [numeric](2, 0) NULL, [HFKM] [numeric](4, 0) NULL, [HFKOSTEN] [numeric](7, 2) NULL, [SACHUKS] [numeric](7, 2) NULL, [SACHUKF] [numeric](7, 2) NULL, [UZTK] [varchar](1) NULL, [UZFS] [varchar](1) NULL, [UZWG] [varchar](1) NULL, [UZHZ] [varchar](1) NULL, [UZPE] [numeric](2, 0) NULL, [UZSUM0] [numeric](7, 2) NULL, [UZSUM1] [numeric](7, 2) NULL, [UZBA] [numeric](7, 2) NULL, [UZKZG] [varchar](1) NULL, [UZSUM2] [numeric](7, 2) NULL, [UZME] [numeric](7, 2) NULL, [UZMG] [numeric](7, 2) NULL, [MIETKO] [numeric](8, 2) NULL, [TGAB] [smalldatetime] NULL, [BCERST] [numeric](7, 2) NULL, [RF_SUMSTEUER] [numeric](7, 2) NULL, CONSTRAINT [PK_HUEL] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[KLR_AN] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KLR_AN]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](20) NULL, [BEZ] [char](30) NULL, CONSTRAINT [PK_KLR_AN] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[KLR_KA] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KLR_KA]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](20) NULL, [BEZ] [char](30) NULL, CONSTRAINT [PK_KLR_KA] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_KLR_KA] UNIQUE NONCLUSTERED ( [SCHL] 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 /****** Object: Table [dbo].[KLR_KS] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KLR_KS]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [varchar](27) NULL, [BEZ] [char](30) NULL, [VON] [smalldatetime] NULL, [BIS] [smalldatetime] NULL, [KSV] [varchar](20) NULL, [USERID] [varchar](30) NULL, [PERSON] [varchar](30) NULL, CONSTRAINT [PK_KLR_KS] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[KLR_KT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KLR_KT]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](20) NULL, [BEZ] [char](30) NULL, [KTV] [varchar](20) NULL, [USERID] [varchar](30) NULL, [PERSON] [varchar](30) NULL, [VON] [smalldatetime] NULL, [BIS] [smalldatetime] NULL, CONSTRAINT [PK_KLR_KT] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[KMKONTO] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KMKONTO]( [LNR] [int] IDENTITY(1,1) NOT NULL, [EMPFNR] [int] NULL, [JAHR] [char](4) NULL, [KM] [int] NULL, [GRENZKM] [int] NULL, [GRENZKMK] [int] NULL, [KBUCHUNG] [int] NULL, [KORRERL] [char](400) NULL, CONSTRAINT [PK_KMKONTO] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_KMKONTO] UNIQUE NONCLUSTERED ( [EMPFNR] ASC, [JAHR] 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 /****** Object: Table [dbo].[KONFIG] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KONFIG]( [ID] [int] IDENTITY(1,1) NOT NULL, [RS] [bit] NULL, [KT] [bit] NULL, [KOPPLUNG] [bit] NULL, [STEUER] [bit] NULL, [EMAIL] [bit] NULL, [MAILTEST] [bit] NULL, [MAILKOPIE] [bit] NULL, [ONDRAURL] [char](100) NULL, [HHIMMER] [bit] NULL, [RSIMMER] [bit] NULL, [POPUP] [bit] NULL, [COMMIT] [bit] NULL, [RS_BAHN] [bit] NULL, [RS_DW] [bit] NULL, [RS_DWS] [bit] NULL, [RS_FLUG] [bit] NULL, [RS_HOTEL] [bit] NULL, [KLR] [bit] NULL, [WORKFLOW] [bit] NULL, [KTBEZ] [char](20) NULL, [KLRHH] [bit] NULL, [KLRGEN] [bit] NULL, [KLRGENS] [bit] NULL, [KLRRK] [bit] NULL, [VORSCHUSS] [bit] NULL, [TGVERZICHT] [bit] NULL, [FRIST] [int] NULL, [ABWES] [bit] NULL, [PDF] [bit] NULL, [BF_OWM] [bit] NULL, [BF_PKW] [bit] NULL, [BF_DW] [bit] NULL, [BF_DWS] [bit] NULL, [BF_MITF] [bit] NULL, [BF_FLUG] [bit] NULL, [BF_TAXI] [bit] NULL, [BF_KEIN] [bit] NULL, [DGESCH] [bit] NULL, [DRITTE] [bit] NULL, [WLGMAIL] [bit] NULL, [KOSTEN] [bit] NULL, [BF_PKWZ] [bit] NULL, [BF_RAD] [bit] NULL, [BF_MIETW] [bit] NULL, [BF_PKW_BEGR] [bit] NULL, [BF_PKWZ_BEGR] [bit] NULL, [BF_TAXI_BEGR] [bit] NULL, [BF_MIETW_BEGR] [bit] NULL, [BF_FLUG_BEGR] [bit] NULL, [GEN1_REQ] [bit] NULL, [GEN2_REQ] [bit] NULL, [HAUSHALT] [bit] NULL, [KVM_FORTB] [bit] NULL, [GENERL_REQ] [bit] NULL, [GENLABEL1] [varchar](50) NULL, [GENLABEL2] [varchar](50) NULL, [GENLABEL3] [varchar](50) NULL, [SGENLABEL1] [varchar](50) NULL, [SGENLABEL2] [varchar](50) NULL, [SGENLABEL3] [varchar](50) NULL, [SAMMEL] [bit] NULL, [ASSIST] [bit] NULL, [DOCPATH] [varchar](200) NULL, [PDFDOWNLOAD] [bit] NULL, [KS_LABEL] [varchar](30) NULL, [KT_LABEL] [varchar](30) NULL, [AN_LABEL] [varchar](30) NULL, [PROJEKT] [bit] NULL, [KLR_BEZ] [bit] NULL, [HINWEIS_REQ] [bit] NULL, [REISERL_REQ] [bit] NULL, [DRARTCHG] [bit] NULL, [GESCHKOSTEN] [bit] NULL, [SRZIEL] [bit] NULL, [KSPFLICHT] [bit] NULL, [KSPRPFLICHT] [bit] NULL, [MBUMST] [bit] NULL, [NEBKO] [bit] NULL, [POPUPRK] [bit] NULL, [OG1] [numeric](8, 2) NULL, [OG2] [numeric](8, 2) NULL, [GGANGLABEL] [varchar](100) NULL, [VERZICHTEXT] [bit] NULL, [KOSTERSATZ] [bit] NULL, [KSKT] [bit] NULL, [BEGENDEALT] [bit] NULL, [BF_PKW_BEGR_A] [bit] NULL, [BF_PKWZ_BEGR_A] [bit] NULL, [BF_DW_BEGR_A] [bit] NULL, [BF_DWS_BEGR_A] [bit] NULL, [BF_MIETW_BEGR_A] [bit] NULL, [BF_TAXI_BEGR_A] [bit] NULL, [BF_FLUG_BEGR_A] [bit] NULL, [REISERL] [varchar](100) NULL, [VERPLABEL] [varchar](100) NULL, [BANK] [bit] NULL, [BELEGHINW] [varchar](2000) NULL, [KSPRPFLICHTA] [bit] NULL, [PROFIL] [bit] NULL, [SEMINAR] [bit] NULL, [SEMHEADER] [varchar](50) NULL, [KLRFREITEXT] [bit] NULL, [KLROEH] [bit] NULL, [NOGENTXT2] [bit] NULL, [RSNACHGEN] [bit] NULL, [NOUEBKOST] [bit] NULL, [MAXKLRE] [smallint] NULL, [MAXKLRS] [smallint] NULL, [ZIELTXT] [varchar](60) NULL, [FAHRTXT] [varchar](60) NULL, [NOKFZBEGR] [bit] NULL, [MAXKLRKTE] [smallint] NULL, [MAXKLRKTS] [smallint] NULL, [NOGENTXT1] [bit] NULL, [PWMINLEN] [smallint] NULL, [SRVERPFL] [bit] NULL, [SRDIENSTG] [bit] NULL, [DOCANZ] [bit] NULL, [NORKMAIL] [bit] NULL, [GGANGDR] [varchar](120) NULL, [GGANGRK] [varchar](120) NULL, [ZWECKTXT] [varchar](60) NULL, [BESTTEXT] [varchar](2000) NULL, [KOSTPFLICHT] [bit] NULL, [TEXTDRA] [varchar](2000) NULL, [TEXTDRG] [varchar](2000) NULL, [TEXTDRH] [varchar](2000) NULL, [TEXTDRR] [varchar](2000) NULL, [TEXTDRS] [varchar](2000) NULL, [TEXTDRW] [varchar](2000) NULL, [TEXTHHA] [varchar](2000) NULL, [TEXTHHE] [varchar](2000) NULL, [TEXTHHS] [varchar](2000) NULL, [TEXTRKA] [varchar](2000) NULL, [TEXTRKG] [varchar](2000) NULL, [TEXTRKR] [varchar](2000) NULL, [TEXTRMA] [varchar](2000) NULL, [TEXTRME] [varchar](2000) NULL, [TEXTRMS] [varchar](2000) NULL, [TEXTSRA] [varchar](2000) NULL, [TEXTSRG] [varchar](2000) NULL, [TEXTSRR] [varchar](2000) NULL, [TEXTSRS] [varchar](2000) NULL, [TEXTPWV] [varchar](2000) NULL, [MAILEDIT] [bit] NULL, CONSTRAINT [PK_KONFIG] PRIMARY KEY NONCLUSTERED ( [ID] 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 /****** Object: Table [dbo].[KOSTRECH] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KOSTRECH]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [KLR_KA] [char](20) NULL, [KLR_KS] [char](27) NULL, [KLR_KT] [char](20) NULL, [KLR_AN] [char](20) NULL, [BETRAG] [numeric](9, 2) NULL, [PROZ] [smallint] NULL, CONSTRAINT [PK_KOSTRECH] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_KOSTRECH] UNIQUE NONCLUSTERED ( [ABRNR] ASC, [LNR] 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 /****** Object: Table [dbo].[KSV] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[KSV]( [LNR] [int] IDENTITY(1,1) NOT NULL, [KSV] [char](20) NULL, CONSTRAINT [PK_KSV] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_KSV] UNIQUE NONCLUSTERED ( [KSV] 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 /****** Object: Table [dbo].[LAENDER] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LAENDER]( [LNR] [int] IDENTITY(1,1) NOT NULL, [KBEZ] [char](8) NULL, [GILTAB] [datetime] NULL, [LAND] [varchar](40) NULL, [BETR2] [decimal](5, 2) NULL, [UEBERN] [decimal](5, 2) NULL, [WG] [char](3) NULL, [TIMESTAMP] [char](24) NULL, [FW] [bit] NULL, [KURS] [decimal](8, 4) NULL, [MAN] [char](4) NULL, [BETR3] [decimal](5, 2) NULL, [OG] [numeric](7, 2) NULL, [MERKA1] [bit] NULL, CONSTRAINT [PK_LAENDER] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_LAENDER] UNIQUE NONCLUSTERED ( [KBEZ] ASC, [GILTAB] 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 /****** Object: Table [dbo].[MBUMST] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MBUMST]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](2) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_MBUMST] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_MBUMST] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[MITKO] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MITKO]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [ANZAHL] [smallint] NULL, [BEZ] [char](30) NULL, [ART] [char](1) NULL, [KM] [smallint] NULL, [BETRAG] [numeric](7, 2) NULL, CONSTRAINT [PK_MITKO] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[NEBKO] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NEBKO]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [BEZ] [char](30) NULL, [BETRAG] [numeric](7, 2) NULL, [STEUPFL] [char](1) NULL, [WG] [char](3) NULL, [WGBETRAG] [numeric](7, 2) NULL, [KURS] [numeric](10, 5) NULL, [ABW_KURS] [numeric](10, 5) NULL, [STEUER1] [numeric](6, 2) NULL, [STEUER2] [numeric](6, 2) NULL, [BC] [bit] NULL, [NETTO] [numeric](7, 2) NULL, [STEUSATZ1] [smallint] NULL, [STEUSATZ2] [smallint] NULL, [DIREKT] [bit] NULL, CONSTRAINT [PK_NEBKO] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[OEH] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[OEH]( [LNR] [int] IDENTITY(1,1) NOT NULL, [BEZ] [char](8) NULL, [BESCHR] [char](30) NULL, [TIMESTAMP] [char](24) NULL, [GEN_NAME] [char](30) NULL, [GEN_ID] [int] NULL, [GEN2_NAME] [char](30) NULL, [GEN2_ID] [int] NULL, [SGEN_NAME] [char](30) NULL, [SGEN_ID] [int] NULL, [RS_NAME] [char](30) NULL, [RS_ID] [int] NULL, [SB_NAME] [char](30) NULL, [SB_ID] [int] NULL, [SB2_NAME] [char](30) NULL, [SB2_ID] [int] NULL, [SGEN2_ID] [int] NULL, [SGEN2_NAME] [char](30) NULL, [KSV] [char](20) NULL, [KLR_KSN] [varchar](8000) NULL, [KLR_KTN] [varchar](8000) NULL, [KLR_ANN] [varchar](8000) NULL, [SGEN_MM] [bit] NULL, CONSTRAINT [PK_OEH] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_OEH] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[ONFAHR] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ONFAHR]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ANR] [int] NULL, [BEZ] [varchar](30) NULL, [BETRAG] [numeric](7, 2) NULL, [BEGR] [varchar](100) NULL, [BC] [bit] NULL, [FNR] [int] NULL, [SB] [bit] NULL, [WG] [char](3) NULL, CONSTRAINT [PK_ONFAHR] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[ONGRENZ] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ONGRENZ]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](5) NULL, [ANR] [int] NULL, [TAG] [smalldatetime] NULL, [LAND] [char](40) NULL, [UHRZEIT] [char](5) NULL, [GUNR] [char](1) NULL, [GUTEXT] [char](40) NULL, CONSTRAINT [PK_ONGRENZ] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[ONMIT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ONMIT]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ANR] [int] NULL, [BEZ] [varchar](30) NULL, [KM] [numeric](5, 0) NULL, [FNR] [int] NULL, CONSTRAINT [PK_ONMIT] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[ONNEB] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ONNEB]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ANR] [int] NULL, [BEZ] [varchar](30) NULL, [BETRAG] [numeric](7, 2) NULL, [FNR] [int] NULL, [WG] [char](3) NULL, CONSTRAINT [PK_ONNEB] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[ORT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ORT]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_ORT] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_ORT] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[ORTBEGR] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ORTBEGR]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_ORTBEGR] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_ORTBEGR] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[PAUSCH] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PAUSCH]( [LNR] [int] IDENTITY(1,1) NOT NULL, [GILTAB] [smalldatetime] NULL, [TG8] [numeric](5, 2) NULL, [TG14] [numeric](5, 2) NULL, [TG24] [numeric](5, 2) NULL, [UG] [numeric](5, 2) NULL, [ABZUG] [numeric](5, 2) NULL, [TGT1] [numeric](5, 2) NULL, [TGT2] [numeric](5, 2) NULL, [TGT3] [numeric](5, 2) NULL, [TGVERP] [numeric](5, 2) NULL, [UGTRG] [numeric](5, 2) NULL, [STFUEB] [numeric](5, 2) NULL, [FELDAUF] [numeric](5, 2) NULL, [WG] [char](3) NULL, [STFUEB4] [numeric](5, 2) NULL, [OG1] [numeric](5, 2) NULL, [OG1A] [numeric](5, 2) NULL, [OG2] [numeric](5, 2) NULL, [OG2A] [numeric](5, 2) NULL, [TGHR] [numeric](5, 2) NULL, [SV8] [numeric](7, 2) NULL, [SV14] [numeric](7, 2) NULL, [SV24] [numeric](7, 2) NULL, [SVHR] [numeric](7, 2) NULL, [SVF] [numeric](5, 2) NULL, [SVM] [numeric](5, 2) NULL, [SVA] [numeric](5, 2) NULL, [F] [numeric](5, 2) NULL, [M] [numeric](5, 2) NULL, [A] [numeric](5, 2) NULL, [OGSTRFRUK] [numeric](6, 2) NULL, [TGT4] [numeric](5, 2) NULL, [TGT5] [numeric](5, 2) NULL, [TGT6] [numeric](5, 2) NULL, [TGT7] [numeric](5, 2) NULL, [TGT8] [numeric](5, 2) NULL, [TGT9] [numeric](5, 2) NULL, [UZ1] [numeric](7, 2) NULL, [UZ2] [numeric](7, 2) NULL, [UZ3] [numeric](7, 2) NULL, [UZ4] [numeric](7, 2) NULL, [UZERH] [numeric](7, 2) NULL, [UZKZGL] [numeric](3, 0) NULL, [UZKZG1] [numeric](3, 0) NULL, [UZKZG2] [numeric](3, 0) NULL, [UZHZ] [numeric](3, 0) NULL, [TGSABEZ] [varchar](5) NULL, [TGSBBEZ] [varchar](5) NULL, [TGSA1U] [numeric](5, 2) NULL, [TGSA2U] [numeric](5, 2) NULL, [TGSA3U] [numeric](5, 2) NULL, [TGSA1UR] [numeric](5, 2) NULL, [TGSA2UR] [numeric](5, 2) NULL, [TGSA3UR] [numeric](5, 2) NULL, [TGSA1A] [numeric](5, 2) NULL, [TGSA2A] [numeric](5, 2) NULL, [TGSA3A] [numeric](5, 2) NULL, [TGSA1AR] [numeric](5, 2) NULL, [TGSA2AR] [numeric](5, 2) NULL, [TGSA3AR] [numeric](5, 2) NULL, [TGSB1U] [numeric](5, 2) NULL, [TGSB2U] [numeric](5, 2) NULL, [TGSB3U] [numeric](5, 2) NULL, [TGSB1UR] [numeric](5, 2) NULL, [TGSB2UR] [numeric](5, 2) NULL, [TGSB3UR] [numeric](5, 2) NULL, [TGSB1A] [numeric](5, 2) NULL, [TGSB2A] [numeric](5, 2) NULL, [TGSB3A] [numeric](5, 2) NULL, [TGSB1AR] [numeric](5, 2) NULL, [TGSB2AR] [numeric](5, 2) NULL, [TGSB3AR] [numeric](5, 2) NULL, [TGSCBEZ] [varchar](5) NULL, [TGSC1U] [numeric](5, 2) NULL, [TGSC2U] [numeric](5, 2) NULL, [TGSC3U] [numeric](5, 2) NULL, [TGSC1UR] [numeric](5, 2) NULL, [TGSC2UR] [numeric](5, 2) NULL, [TGSC3UR] [numeric](5, 2) NULL, [TGSC1A] [numeric](5, 2) NULL, [TGSC2A] [numeric](5, 2) NULL, [TGSC3A] [numeric](5, 2) NULL, [TGSC1AR] [numeric](5, 2) NULL, [TGSC2AR] [numeric](5, 2) NULL, [TGSC3AR] [numeric](5, 2) NULL, [PENDLOG] [numeric](7, 2) NULL, CONSTRAINT [PK_PAUSCH] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_PAUSCH] UNIQUE NONCLUSTERED ( [GILTAB] 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 /****** Object: Table [dbo].[PLZ] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PLZ]( [LNR] [int] IDENTITY(1,1) NOT NULL, [PLZ] [char](6) NULL, [ORT] [char](25) NULL, [DATUM] [smalldatetime] NULL, CONSTRAINT [PK_PLZ] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[RECHTE] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RECHTE]( [LNR] [int] IDENTITY(1,1) NOT NULL, [USERID] [char](20) NULL, [GRANT_RK] [bit] NULL, [GRANT_TG] [bit] NULL, [GRANT_AO] [bit] NULL, [GRANT_EMPF] [bit] NULL, [GRANT_GRUND] [bit] NULL, [GRANT_DTA] [bit] NULL, [GRANT_ADMIN] [bit] NULL, [ONDRA] [char](1) NULL, [DOMAIN] [varchar](30) NULL, [GRANT_LOGON] [bit] NULL, [GRANT_PRUEF] [bit] NULL, CONSTRAINT [PK_RECHTE] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[RKANTRAG] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RKANTRAG]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [A_DATUM] [datetime] NULL, [ZIEL] [varchar](2000) NULL, [EMPFID] [int] NULL, [EMPFNAME] [char](40) NULL, [DAT1] [datetime] NULL, [UHR1] [char](5) NULL, [DAT2] [datetime] NULL, [UHR2] [char](5) NULL, [AMT_JN] [bit] NULL, [AMTU_JN] [bit] NULL, [KM4] [numeric](5, 0) NULL, [BEGR] [bit] NULL, [PERS5] [numeric](2, 0) NULL, [KM5] [numeric](5, 0) NULL, [UEBKOST] [numeric](7, 2) NULL, [ABZUG] [char](1) NULL, [MBUMST] [char](2) NULL, [SUM6] [numeric](7, 2) NULL, [SUM7] [numeric](7, 2) NULL, [ZUSCHUSS] [numeric](7, 2) NULL, [SUM10] [numeric](7, 2) NULL, [DR_ART] [char](1) NULL, [RK_STATUS] [char](1) NULL, [AUSLG4] [bit] NULL, [AUSLG5] [bit] NULL, [AUSLG6] [bit] NULL, [AUSLG7] [bit] NULL, [AUSLG9M] [bit] NULL, [KM51NAME] [char](30) NULL, [KM51] [numeric](5, 0) NULL, [KM52NAME] [char](30) NULL, [KM52] [numeric](5, 0) NULL, [KM53NAME] [char](30) NULL, [KM53] [numeric](5, 0) NULL, [KM54NAME] [char](30) NULL, [KM54] [numeric](5, 0) NULL, [FAHR1BEZ] [char](30) NULL, [FAHR1] [numeric](7, 2) NULL, [FAHR2BEZ] [char](30) NULL, [FAHR2] [numeric](7, 2) NULL, [FAHR3BEZ] [char](30) NULL, [FAHR3] [numeric](7, 2) NULL, [FAHR4BEZ] [char](30) NULL, [FAHR4] [numeric](7, 2) NULL, [NEB1BEZ] [char](30) NULL, [NEB1] [numeric](7, 2) NULL, [NEB2BEZ] [char](30) NULL, [NEB2] [numeric](7, 2) NULL, [NEB3BEZ] [char](30) NULL, [NEB3] [numeric](7, 2) NULL, [NEB4BEZ] [char](30) NULL, [NEB4] [numeric](7, 2) NULL, [BEGRTXT] [char](40) NULL, [UEBDAT] [smalldatetime] NULL, [RKLNR] [int] NULL, [AUSLG9P] [bit] NULL, [PENSION] [numeric](7, 2) NULL, [PENS_F] [smallint] NULL, [PENS_M] [smallint] NULL, [PENS_A] [smallint] NULL, [LAND] [varchar](40) NULL, [GEN_ID] [int] NULL, [GEN2_ID] [int] NULL, [GEN_NAME] [varchar](50) NULL, [GEN_DATUM] [smalldatetime] NULL, [GEN_STATUS] [char](1) NULL, [GEN_TXT] [varchar](200) NULL, [WLAND] [int] NULL, [FAHR1BC] [bit] NULL, [FAHR2BC] [bit] NULL, [FAHR3BC] [bit] NULL, [FAHR4BC] [bit] NULL, [ESTUFE] [smallint] NULL, [DRLNR] [int] NULL, [BF_BEGR] [char](1) NULL, [BF_BEGRTXT] [varchar](200) NULL, [BF_BEGR1] [char](1) NULL, [BF_BEGR2] [char](1) NULL, [BF_BEGR3] [char](1) NULL, [BF_BEGR4] [char](1) NULL, [DOCNAME] [varchar](200) NULL, [G_ZIEL] [varchar](80) NULL, [G_LAND] [varchar](50) NULL, [G_DAT1] [smalldatetime] NULL, [G_UHR1] [char](5) NULL, [G_DAT2] [smalldatetime] NULL, [G_UHR2] [char](5) NULL, [G_DR_ART] [char](1) NULL, [FAHR1SB] [bit] NULL, [FAHR2SB] [bit] NULL, [FAHR3SB] [bit] NULL, [FAHR4SB] [bit] NULL, [FRSTKOST] [numeric](7, 2) NULL, [RZWECK] [varchar](2000) NULL, [FAHR1WG] [char](3) NULL, [FAHR2WG] [char](3) NULL, [FAHR3WG] [char](3) NULL, [FAHR4WG] [char](3) NULL, [NEB1WG] [char](3) NULL, [NEB2WG] [char](3) NULL, [NEB3WG] [char](3) NULL, [NEB4WG] [char](3) NULL, [KLR_KS1B] [numeric](8, 2) NULL, [KLR_KS2B] [numeric](8, 2) NULL, [KLR_KS3B] [numeric](8, 2) NULL, [KLR_KS4B] [numeric](8, 2) NULL, [KLR_KT1B] [numeric](8, 2) NULL, [KLR_KT2B] [numeric](8, 2) NULL, [KLR_KT3B] [numeric](8, 2) NULL, [KLR_KT4B] [numeric](8, 2) NULL, [KLR_KS1W] [char](3) NULL, [KLR_KS2W] [char](3) NULL, [KLR_KS3W] [char](3) NULL, [KLR_KS4W] [char](3) NULL, [KLR_KT1W] [char](3) NULL, [KLR_KT2W] [char](3) NULL, [KLR_KT3W] [char](3) NULL, [KLR_KT4W] [char](3) NULL, [WG] [char](3) NULL, [SB] [char](20) NULL, [ERL1] [varchar](60) NULL, [TGENAU] [bit] NULL, [ANLAGE1] [varchar](200) NULL, [ANLAGE2] [varchar](200) NULL, [ANLAGE3] [varchar](200) NULL, [BELEGE] [char](30) NULL, [OEH] [char](8) NULL, [ZUSTHH] [char](20) NULL, [KMF] [numeric](5, 0) NULL, [AUSLG4F] [bit] NULL, [KLR_AN1B] [numeric](8, 2) NULL, [KLR_AN2B] [numeric](8, 2) NULL, [KLR_AN3B] [numeric](8, 2) NULL, [KLR_AN4B] [numeric](8, 2) NULL, [HHBEST] [bit] NULL, [PRIVAT] [bit] NULL, [TAGRUECK] [bit] NULL, [BF_PKW_BEGR] [char](1) NULL, [BF_PKWZ_BEGR] [char](1) NULL, [BF_DW_BEGR] [char](1) NULL, [BF_DWS_BEGR] [char](1) NULL, [BF_MIETW_BEGR] [char](1) NULL, [BF_TAXI_BEGR] [char](1) NULL, [BF_FLUG_BEGR] [char](1) NULL, [UEBKO_BEGR] [varchar](200) NULL, [BF_BEGR_TXT] [varchar](200) NULL, [BIC] [varchar](11) NULL, [IBAN] [varchar](34) NULL, [KTOINHABER] [varchar](30) NULL, [VERZICHT] [bit] NULL, [FKVERZICHT] [bit] NULL, [UKVERZICHT] [bit] NULL, [BF_BEGR1_TXT] [varchar](100) NULL, [BF_BEGR2_TXT] [varchar](100) NULL, [BF_BEGR3_TXT] [varchar](100) NULL, [BF_BEGR4_TXT] [varchar](100) NULL, [TGVERZICHTDR] [bit] NULL, [FKVERZICHTDR] [bit] NULL, [UKVERZICHTDR] [bit] NULL, [TGVERZICHT] [bit] NULL, [RKINF] [varchar](120) NULL, [KLR_KS1] [varchar](27) NULL, [KLR_KS2] [varchar](27) NULL, [KLR_KS3] [varchar](27) NULL, [KLR_KS4] [varchar](27) NULL, [KLR_KT1] [varchar](20) NULL, [KLR_KT2] [varchar](20) NULL, [KLR_KT3] [varchar](20) NULL, [KLR_KT4] [varchar](20) NULL, [KLR_AN1] [varchar](20) NULL, [KLR_AN2] [varchar](20) NULL, [KLR_AN3] [varchar](20) NULL, [KLR_AN4] [varchar](20) NULL, [KLR_KS1P] [smallint] NULL, [KLR_KS2P] [smallint] NULL, [KLR_KS3P] [smallint] NULL, [KLR_KS4P] [smallint] NULL, [KLR_KT1P] [smallint] NULL, [KLR_KT2P] [smallint] NULL, [KLR_KT3P] [smallint] NULL, [KLR_KT4P] [smallint] NULL, [KLR_AN1P] [smallint] NULL, [KLR_AN2P] [smallint] NULL, [KLR_AN3P] [smallint] NULL, [KLR_AN4P] [smallint] NULL, [HINWEIS] [varchar](2000) NULL, CONSTRAINT [PK_RKANTRAG] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[RKSTAT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RKSTAT]( [ID] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [char](80) NULL, CONSTRAINT [PK_RKSTAT] PRIMARY KEY NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_RKSTAT] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[SACHBEZ] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SACHBEZ]( [LNR] [int] IDENTITY(1,1) NOT NULL, [GILTAB] [smalldatetime] NULL, [SB_F] [numeric](5, 2) NULL, [SB_M] [numeric](5, 2) NULL, [SB_A] [numeric](5, 2) NULL, [WG] [char](3) NULL, [SB_UK] [numeric](7, 2) NULL, CONSTRAINT [PK_SACHBEZ] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SACHBEZ] UNIQUE NONCLUSTERED ( [GILTAB] 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 /****** Object: Table [dbo].[SEMART] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SEMART]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [varchar](50) NULL, CONSTRAINT [PK_SEMART] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SEMART] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[SEMTR] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SEMTR]( [LNR] [int] IDENTITY(1,1) NOT NULL, [SCHL] [char](1) NULL, [BEZ] [varchar](50) NULL, CONSTRAINT [PK_SEMTR] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SEMTR] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[SESSIONS] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SESSIONS]( [LNR] [numeric](18, 0) IDENTITY(1,1) NOT NULL, [USERID] [char](30) NULL, [USERNAME] [char](30) NULL, [PASSWORD] [char](30) NULL, [CONNSTRING] [char](500) NULL, [CONNDATUM] [char](8) NULL, [CONNZEIT] [char](10) NULL, [MAN] [char](4) NULL, CONSTRAINT [PK_SESSION] PRIMARY KEY CLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SESSION] UNIQUE NONCLUSTERED ( [USERNAME] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SESSION_1] UNIQUE NONCLUSTERED ( [USERID] 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 /****** Object: Table [dbo].[SRABR] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SRABR]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [DATUM] [smalldatetime] NULL, [TAG] [char](2) NULL, [KM] [numeric](4, 0) NULL, [BEGR] [bit] NULL, [MITKM] [numeric](4, 0) NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, [DAUER] [char](5) NULL, [DAU8] [bit] NULL, [DAU14] [bit] NULL, [DAU24] [bit] NULL, [FS] [bit] NULL, [ME] [bit] NULL, [AE] [bit] NULL, [FAHRKO] [numeric](7, 2) NULL, [NEBKO] [numeric](7, 2) NULL, [FELDAUF] [bit] NULL, [FELDAUF5] [bit] NULL, [FELDAUF7] [bit] NULL, [BETRAG] [numeric](7, 2) NULL, [STEUPFL] [numeric](7, 2) NULL, [TG] [numeric](5, 2) NULL, [ABZ] [numeric](5, 2) NULL, [WEGENT] [numeric](7, 2) NULL, [MITENT] [numeric](7, 2) NULL, [FELDBETR] [numeric](5, 2) NULL, [KMZ] [numeric](4, 0) NULL, [KMT] [numeric](4, 0) NULL, [ZIEL] [varchar](120) NULL, [EMPFNR] [int] NULL, [KT] [bit] NULL, [SWZKM] [numeric](4, 0) NULL, [VERPP1] [numeric](7, 2) NULL, [VERPP2] [numeric](7, 2) NULL, [STEUTG] [numeric](7, 2) NULL, [STSACHBEZ] [numeric](7, 2) NULL, [STVERRECH] [numeric](7, 2) NULL, [DAU8X] [bit] NULL, [BEGRSA] [char](1) NULL, [KMF] [numeric](4, 0) NULL, [UNTERBR] [varchar](5) NULL, [AUSLAGEN] [numeric](7, 2) NULL, [DRART] [varchar](1) NULL, [KSB] [bit] NULL, [ART] [varchar](20) NULL, [GEPKM] [numeric](4, 0) NULL, [GEPENT] [numeric](7, 2) NULL, [VERPKOST] [numeric](7, 2) NULL, [ZWECK] [varchar](120) NULL, [FTYP] [varchar](1) NULL, CONSTRAINT [PK_SRABR] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[SRANTRAG] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SRANTRAG]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [A_DATUM] [datetime] NULL, [ZIEL] [varchar](120) NULL, [EMPFID] [int] NULL, [EMPFNAME] [char](40) NULL, [DAT1] [datetime] NULL, [DAT2] [datetime] NULL, [AMT_JN] [bit] NULL, [KM4] [numeric](5, 0) NULL, [BEGR] [bit] NULL, [KM5] [numeric](5, 0) NULL, [SUM6] [numeric](7, 2) NULL, [SUM7] [numeric](7, 2) NULL, [ZUSCHUSS] [numeric](7, 2) NULL, [SUM10] [numeric](7, 2) NULL, [RK_STATUS] [char](1) NULL, [UEBDAT] [smalldatetime] NULL, [RKLNR] [int] NULL, [GEN_ID] [int] NULL, [GEN2_ID] [int] NULL, [GEN_NAME] [varchar](50) NULL, [GEN_DATUM] [smalldatetime] NULL, [GEN_STATUS] [char](1) NULL, [GEN_TXT] [varchar](200) NULL, [WLAND] [int] NULL, [KLR_KS1] [varchar](27) NULL, [KLR_KS2] [varchar](27) NULL, [KLR_KT1] [varchar](20) NULL, [KLR_KT2] [varchar](20) NULL, [ESTUFE] [smallint] NULL, [DRLNR] [int] NULL, [DOCNAME] [varchar](200) NULL, [KLR_KS3] [varchar](27) NULL, [KLR_KS4] [varchar](27) NULL, [KLR_KT3] [varchar](20) NULL, [KLR_KT4] [varchar](20) NULL, [RZWECK] [varchar](100) NULL, [KLR_KS1B] [numeric](8, 2) NULL, [KLR_KS2B] [numeric](8, 2) NULL, [KLR_KS3B] [numeric](8, 2) NULL, [KLR_KS4B] [numeric](8, 2) NULL, [KLR_KT1B] [numeric](8, 2) NULL, [KLR_KT2B] [numeric](8, 2) NULL, [KLR_KT3B] [numeric](8, 2) NULL, [KLR_KT4B] [numeric](8, 2) NULL, [KLR_KS1W] [char](3) NULL, [KLR_KS2W] [char](3) NULL, [KLR_KS3W] [char](3) NULL, [KLR_KS4W] [char](3) NULL, [KLR_KT1W] [char](3) NULL, [KLR_KT2W] [char](3) NULL, [KLR_KT3W] [char](3) NULL, [KLR_KT4W] [char](3) NULL, [WG] [char](3) NULL, [SB] [char](20) NULL, [ERL1] [varchar](60) NULL, [TGENAU] [bit] NULL, [ANLAGE1] [varchar](200) NULL, [ANLAGE2] [varchar](200) NULL, [ANLAGE3] [varchar](200) NULL, [WLG_NAME] [char](50) NULL, [OEH] [char](8) NULL, [ZUSTHH] [char](20) NULL, [KLR_AN1] [varchar](20) NULL, [KLR_AN1B] [numeric](8, 2) NULL, [KLR_AN2] [varchar](20) NULL, [KLR_AN2B] [numeric](8, 2) NULL, [KLR_AN3] [varchar](20) NULL, [KLR_AN3B] [numeric](8, 2) NULL, [KLR_AN4] [varchar](20) NULL, [KLR_AN4B] [numeric](8, 2) NULL, [KLR_KS5] [varchar](27) NULL, [KLR_KS5B] [numeric](8, 2) NULL, [KLR_KS5W] [char](3) NULL, [KLR_KT5] [varchar](27) NULL, [KLR_KT5B] [numeric](8, 2) NULL, [KLR_KT5W] [char](3) NULL, [KLR_KS6] [varchar](27) NULL, [KLR_KS6B] [numeric](8, 2) NULL, [KLR_KS6W] [char](3) NULL, [KLR_KT6] [varchar](27) NULL, [KLR_KT6B] [numeric](8, 2) NULL, [KLR_KT6W] [char](3) NULL, [RKINF] [varchar](120) NULL, [KLR_KS1P] [smallint] NULL, [KLR_KS2P] [smallint] NULL, [KLR_KS3P] [smallint] NULL, [KLR_KS4P] [smallint] NULL, [KLR_KT1P] [smallint] NULL, [KLR_KT2P] [smallint] NULL, [KLR_KT3P] [smallint] NULL, [KLR_KT4P] [smallint] NULL, [KLR_AN1P] [smallint] NULL, [KLR_AN2P] [smallint] NULL, [KLR_AN3P] [smallint] NULL, [KLR_AN4P] [smallint] NULL, [KLR_KS5P] [smallint] NULL, [KLR_KS6P] [smallint] NULL, [KLR_KT5P] [smallint] NULL, [KLR_KT6P] [smallint] NULL, CONSTRAINT [SR_RKANTRAG] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[SRANTRAGT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SRANTRAGT]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [DATUM] [smalldatetime] NULL, [TAG] [char](2) NULL, [KM] [numeric](4, 0) NULL, [BEGR] [bit] NULL, [MITKM] [numeric](4, 0) NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, [DAUER] [char](5) NULL, [DAU8] [bit] NULL, [DAU14] [bit] NULL, [DAU24] [bit] NOT NULL, [FS] [char](1) NULL, [ME] [char](1) NULL, [AE] [char](1) NULL, [FAHRKO] [numeric](7, 2) NULL, [NEBKO] [numeric](7, 2) NULL, [FELDAUF] [bit] NULL, [FELDAUF5] [bit] NULL, [FELDAUF7] [bit] NULL, [BETRAG] [numeric](7, 2) NULL, [STEUPFL] [numeric](7, 2) NULL, [TG] [numeric](5, 2) NULL, [ABZ] [numeric](5, 2) NULL, [WEGENT] [numeric](7, 2) NULL, [MITENT] [numeric](7, 2) NULL, [FELDBETR] [numeric](5, 2) NULL, [KMZ] [numeric](4, 0) NULL, [KMT] [numeric](4, 0) NULL, [ZIEL] [varchar](120) NULL, [EMPFNR] [int] NULL, [KT] [bit] NULL, [SWZKM] [numeric](4, 0) NULL, [VERPP1] [numeric](7, 2) NULL, [VERPP2] [numeric](7, 2) NULL, [STEUTG] [numeric](7, 2) NULL, [STSACHBEZ] [numeric](7, 2) NULL, [STVERRECH] [numeric](7, 2) NULL, [DAU8X] [bit] NULL, [UNTERBR] [varchar](5) NULL, [FMA] [varchar](3) NULL, [KTC] [char](1) NULL, [VERPKOST] [numeric](7, 2) NULL, [FTYP] [varchar](1) NULL, [ZWECK] [varchar](120) NULL, CONSTRAINT [PK_SRANTRAGT] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[STAMM] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[STAMM]( [LNR] [int] IDENTITY(1,1) NOT NULL, [NAME1] [char](40) NULL, [NAME2] [char](40) NULL, [KBEZ] [char](6) NULL, [DSTNR] [char](8) NULL, [AZ] [char](15) NULL, [BEARB] [char](25) NULL, [TEL] [char](20) NULL, [ORT] [char](25) NULL, [KASSE] [char](25) NULL, [F] [numeric](3, 2) NULL, [M] [numeric](3, 2) NULL, [A] [numeric](3, 2) NULL, [FT] [numeric](3, 2) NULL, [MT] [numeric](3, 2) NULL, [AT] [numeric](3, 2) NULL, [FAELLIG] [char](10) NULL, [FRIST] [numeric](3, 0) NULL, [TGREDU] [numeric](2, 0) NULL, [VS] [bit] NULL, [GRENZKM] [numeric](5, 0) NULL, [GRENZB] [bit] NULL, [MINDABW] [numeric](2, 0) NULL, [RUECK] [char](5) NULL, [ANSPTAGE] [numeric](2, 0) NULL, [PRIVANS] [bit] NULL, [AKTUAL] [bit] NULL, [NRHOCH] [bit] NULL, [LAND] [char](2) NULL, [HHST] [bit] NULL, [STEUZUS] [bit] NULL, [KONTPAGE] [bit] NULL, [DAUER] [numeric](3, 0) NULL, [BZ_ADR1] [char](30) NULL, [BZ_ADR2] [char](30) NULL, [BZ_ADR3] [char](30) NULL, [SPECIAL] [bit] NULL, [MAX38] [bit] NULL, [FELDAUF] [bit] NULL, [UNTERZ] [char](10) NULL, [AVPROZ] [numeric](3, 0) NULL, [ZA] [char](1) NULL, [ABZUG] [numeric](5, 2) NULL, [SELBSTDEF] [bit] NULL, [DRUVO] [bit] NULL, [DRUVO1] [bit] NULL, [KPANSCHR] [numeric](2, 0) NULL, [KPBELEG] [numeric](2, 0) NULL, [KPAO] [numeric](2, 0) NULL, [KPSTEU] [numeric](2, 0) NULL, [DRUAUSW] [bit] NULL, [DRUBANK] [bit] NULL, [ANTRDAT] [bit] NULL, [DRART] [bit] NULL, [RKPRINT] [bit] NULL, [APPMODE] [bit] NULL, [LBVDST1] [char](8) NULL, [LBVDST2] [char](4) NULL, [LBVRL] [numeric](5, 2) NULL, [LBVRO] [numeric](5, 2) NULL, [LBVDST2UG] [char](2) NULL, [RKLNOAZ] [bit] NULL, [MAXUGBA] [numeric](5, 2) NULL, [SRUHR] [bit] NULL, [FT_3K] [bit] NULL, [FT_FF] [bit] NULL, [FT_MH] [bit] NULL, [FT_RF] [bit] NULL, [FT_AH] [bit] NULL, [FT_FL] [bit] NULL, [FT_BB] [bit] NULL, [HHJAHR] [char](4) NULL, [VERSION] [char](12) NULL, [BANKDATEN] [char](1) NULL, [SAPCO] [bit] NULL, [MAN] [char](4) NULL, [RKMAILADR] [char](40) NULL, [RMMAILADR] [char](40) NULL, [HHMAILADR] [char](40) NULL, [MAILTEXT1] [varchar](1000) NULL, [MAILTEXT2] [varchar](1000) NULL, [MAILTEXT3] [varchar](1000) NULL, [MAILTEXT4] [varchar](1000) NULL, [MAILTEXT5] [varchar](1000) NULL, [MAILTEXT6] [varchar](1000) NULL, [MAILTEXT7] [varchar](1000) NULL, [MAILFRIST1] [smallint] NULL, [MAILFRIST2] [smallint] NULL, [MAILFRIST3] [smallint] NULL, [MAILFRIST4] [smallint] NULL, [MAILFRIST5] [smallint] NULL, [MAILFRIST6] [smallint] NULL, [MAILFRIST7] [smallint] NULL, [SMTPHOST] [varchar](50) NULL, [MAILUSERNAME] [varchar](50) NULL, [MAILPASSWORD] [varchar](50) NULL, [MAHNDAT1] [smalldatetime] NULL, [MAHNDAT2] [smalldatetime] NULL, [MAILTEXT8] [varchar](1000) NULL, [MAILFRIST8] [smallint] NULL, [INTERVALL] [smallint] NULL, [STEUSATZ] [char](4) NULL, [STEUSATZ1] [smallint] NULL, [STEUSATZ2] [smallint] NULL, [MAILTEXT] [varchar](500) NULL, [TEXT1] [varchar](40) NULL, [BUCHMITT] [bit] NULL, [ZUSGEZ] [bit] NULL, [ZUSBANK] [bit] NULL, [STEUSATZU] [smallint] NULL, [STEUSATZF] [smallint] NULL, [ABSZEILE] [varchar](60) NULL, [PLZ] [varchar](6) NULL, [ARTIKEL] [char](3) NULL, [TGKUV] [bit] NULL, [PAUSCH] [bit] NULL, [SD_LABEL] [bit] NULL, [AOSTELLE] [varchar](30) NULL, [PERSON] [bit] NULL, [NOMAILANLG] [bit] NULL, [MAILTEXTX] [varchar](1000) NULL, [MAILFRISTX] [smallint] NULL, [KLR] [bit] NULL, [PERSNRLEN] [smallint] NULL, [PERSNRNUM] [bit] NULL, [PERSNRVON] [varchar](14) NULL, [PERSNRBIS] [varchar](14) NULL, [PERSNRLK] [bit] NULL, [VSBEGINN] [smalldatetime] NULL, [IBAN] [bit] NULL, [MAILSYS] [varchar](1) NULL, CONSTRAINT [PK_STAMM] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[STDTEXT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[STDTEXT]( [LNR] [numeric](6, 0) IDENTITY(1,1) NOT NULL, [BEZ] [char](30) NULL, [TYP] [char](1) NULL, [HINWTEXT] [varchar](2000) NULL, [MAN] [char](4) NULL, [KONTO] [varchar](20) NULL, [STEUSATZ] [smallint] NULL, [RKSTEU] [bit] NULL, [BEGR_FLD] [varchar](20) NULL, [RK] [bit] NULL, [TG] [bit] NULL, [UZ] [bit] NULL, CONSTRAINT [PK_STDTEXT] PRIMARY KEY CLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_STDTEXT] UNIQUE NONCLUSTERED ( [BEZ] 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 /****** Object: Table [dbo].[STELLE] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[STELLE]( [LNR] [int] IDENTITY(1,1) NOT NULL, [KBEZ] [varchar](10) NULL, [BEZ] [varchar](50) NULL, [STR] [varchar](50) NULL, [PLZ] [varchar](6) NULL, [ORT] [varchar](50) NULL, CONSTRAINT [PK_STELLE] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_STELLE] UNIQUE NONCLUSTERED ( [KBEZ] 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 /****** Object: Table [dbo].[TGTAGE] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TGTAGE]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [TAG] [smalldatetime] NULL, [WTAG] [char](2) NULL, [ANSPRUCH] [char](1) NULL, [FAHRTAG] [char](1) NULL, [ANRTAG] [char](1) NULL, [VERPTAG] [char](1) NULL, [HEIMTAG] [char](1) NULL, [WEGENT] [numeric](5, 2) NULL, [ANRECH] [numeric](5, 2) NULL, [VERPFL] [numeric](5, 2) NULL, [STEUER] [numeric](5, 2) NULL, [AMT_F] [char](1) NULL, [AMT_M] [char](1) NULL, [AMT_A] [char](1) NULL, [AMT_U] [char](1) NULL, [FS_SB] [char](1) NULL, [ME_SB] [char](1) NULL, [AE_SB] [char](1) NULL, [TRG] [numeric](5, 2) NULL, [TRG_TAG] [numeric](5, 2) NULL, [TRG_NACHT] [numeric](5, 2) NULL, [HEIMFAKO] [numeric](5, 2) NULL, [STUEB] [numeric](5, 2) NULL, [PAUSCH] [numeric](5, 2) NULL, [EINBEH] [numeric](5, 2) NULL, [EINBEHT] [numeric](5, 2) NULL, [SACHBEZ] [numeric](5, 2) NULL, [TRA_IMAG] [numeric](5, 2) NULL, [SOZVERS] [numeric](5, 2) NULL, [FAHRKO] [numeric](5, 2) NULL, [UG] [char](1) NULL, [UGTAG] [numeric](5, 2) NULL, [MIETKO] [numeric](5, 2) NULL, [UEBDO] [char](1) NULL, [STWEGP] [numeric](5, 2) NULL, [STUNTER] [numeric](5, 2) NULL, [FAHRKO2] [numeric](5, 2) NULL, [STRFREI] [numeric](5, 2) NULL, [MITNTAG] [char](1) NULL, [MITNENT] [numeric](7, 2) NULL, [TRGANSP] [char](1) NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, [UHR3] [char](5) NULL, [FAHRKM] [smallint] NULL, [MITKM] [smallint] NULL, [BEGR] [char](1) NULL, [HEIMFAKOP] [numeric](7, 2) NULL, [SACHUKS] [numeric](7, 2) NULL, [SACHUKF] [numeric](7, 2) NULL, [TGHKOST] [numeric](7, 2) NULL, [TGAKM] [numeric](4, 0) NULL, [HFBEGR] [bit] NULL, [FAHRRAD] [bit] NULL, [ERSPART1] [numeric](7, 2) NULL, [ERSPART2] [numeric](7, 2) NULL, CONSTRAINT [PK_TGTAGE] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_TGTAGE] UNIQUE NONCLUSTERED ( [ABRNR] ASC, [TAG] 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 /****** Object: Table [dbo].[UEB] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UEB]( [LNR] [int] IDENTITY(1,1) NOT NULL, [HHST] [char](40) NULL, [JAHR] [char](2) NULL, [KAP] [char](8) NULL, [TITEL] [char](8) NULL, [UTEIL] [char](16) NULL, [PZ] [char](1) NULL, [BETR] [char](30) NULL, [NR] [numeric](6, 0) NULL, [ART] [char](1) NULL, [HHANSATZ] [numeric](10, 2) NULL, [BMITTEL] [numeric](3, 0) NULL, [KUERZUNG] [numeric](10, 2) NULL, [ANSATZ] [numeric](10, 2) NULL, [VERBR] [numeric](10, 2) NULL, [P_VERBR] [numeric](6, 0) NULL, [PH_VERBR] [numeric](6, 0) NULL, [SUM_AUSZ] [numeric](6, 0) NULL, [REST] [numeric](12, 2) NULL, [WG] [char](3) NULL, [LASTNR] [numeric](6, 0) NULL, [TIMESTAMP] [char](24) NULL, [KLR_KA] [char](20) NULL, [KLR_KAN] [varchar](8000) NULL, [KLR_ANN] [varchar](8000) NULL, [KST_BA] [bit] NULL, [KLR_AZN] [varchar](8000) NULL, [TITGR] [char](4) NULL, [XX] [char](6) NULL, CONSTRAINT [PK_UEB] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_UEB] UNIQUE NONCLUSTERED ( [HHST] 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 /****** Object: Table [dbo].[UEBAKTZ] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UEBAKTZ]( [LNR] [int] IDENTITY(1,1) NOT NULL, [HHST] [char](40) NULL, [BEZ] [char](20) NULL, CONSTRAINT [PK_UEBAKTZ] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_UEBAKTZ] UNIQUE NONCLUSTERED ( [HHST] ASC, [BEZ] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_UEBAKTZ_1] UNIQUE NONCLUSTERED ( [BEZ] ASC, [HHST] 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 /****** Object: Table [dbo].[UEBSTRC] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UEBSTRC]( [LNR] [int] IDENTITY(1,1) NOT NULL, [HHST] [char](40) NULL, [KAP] [char](8) NULL, [TITEL] [char](8) NULL, [UTEIL] [char](10) NULL, [PZ] [char](1) NULL, [BETR] [char](30) NULL, [ART] [char](1) NULL, [TITGR] [char](4) NULL, CONSTRAINT [PK_UEBSTRC] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_UEBSTRC] UNIQUE NONCLUSTERED ( [HHST] 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 /****** Object: Table [dbo].[VORLAGE] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[VORLAGE]( [LNR] [int] IDENTITY(1,1) NOT NULL, [MAN] [char](4) NULL, [ZIEL] [varchar](80) NULL, [ORT1] [varchar](50) NULL, [ORT2] [varchar](50) NULL, [ORTBEGR] [varchar](2000) NULL, [BF_OVM] [bit] NULL, [BF_DW] [bit] NULL, [BF_DWS] [bit] NULL, [BF_FLUG] [bit] NULL, [BF_MITF] [bit] NULL, [BF_BEGR] [char](1) NULL, [BF_BEGRTXT] [varchar](200) NULL, [RS_DW] [bit] NULL, [RS_DWTXT] [varchar](200) NULL, [RS_FLUG] [bit] NULL, [RS_FLUGTXT] [varchar](200) NULL, [RS_HOTEL] [bit] NULL, [RS_HOTELTXT] [varchar](200) NULL, [RS_BAHN] [bit] NULL, [RS_BAHNTXT] [varchar](200) NULL, [KOSTERSATZ] [varchar](50) NULL, [EMPFID] [int] NULL, [EMPFNAME] [varchar](50) NULL, [RZWECK] [varchar](2000) NULL, [DR_ART] [char](1) NULL, [BF_PKW] [bit] NULL, [RS_DWS] [bit] NULL, [RS_DWSTXT] [varchar](200) NULL, [LAND] [varchar](40) NULL, [PAUSCH] [bit] NULL, [RS_ID] [int] NULL, [KOSTEN] [numeric](7, 2) NULL, [VERZICHT] [bit] NULL, [ORT1LIST] [varchar](30) NULL, [ORT2LIST] [varchar](30) NULL, [GENTXT2] [varchar](2000) NULL, [BF_KEIN] [bit] NULL, [WG] [char](3) NULL, [KLR_KS1B] [numeric](8, 2) NULL, [KLR_KS2B] [numeric](8, 2) NULL, [KLR_KS3B] [numeric](8, 2) NULL, [KLR_KS4B] [numeric](8, 2) NULL, [KLR_KT1B] [numeric](8, 2) NULL, [KLR_KT2B] [numeric](8, 2) NULL, [KLR_KT3B] [numeric](8, 2) NULL, [KLR_KT4B] [numeric](8, 2) NULL, [KLR_KS1W] [char](3) NULL, [KLR_KS2W] [char](3) NULL, [KLR_KS3W] [char](3) NULL, [KLR_KS4W] [char](3) NULL, [KLR_KT1W] [char](3) NULL, [KLR_KT2W] [char](3) NULL, [KLR_KT3W] [char](3) NULL, [KLR_KT4W] [char](3) NULL, [VORLAGE] [varchar](60) NULL, [ORT_BEG1] [char](1) NULL, [ORT_BEG2] [char](1) NULL, [ABW_LIST] [char](1) NULL, [GEN_STATUS] [char](1) NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, [WLAND] [int] NULL, [XUHR1] [char](5) NULL, [XUHR2] [char](5) NULL, [HINWEIS] [varchar](2000) NULL, [ABW_TXT] [varchar](2000) NULL, [OEH] [char](8) NULL, [KLR_AN1B] [numeric](8, 2) NULL, [KLR_AN2B] [numeric](8, 2) NULL, [KLR_AN3B] [numeric](8, 2) NULL, [KLR_AN4B] [numeric](8, 2) NULL, [HHBEST] [bit] NULL, [PRIVAT] [bit] NULL, [REISERL] [bit] NULL, [BEGR] [bit] NULL, [TAGRUECK] [bit] NULL, [KOSTEN1] [numeric](7, 2) NULL, [KOSTEN2] [numeric](7, 2) NULL, [KOSTEN3] [numeric](7, 2) NULL, [KOSTEN4] [numeric](7, 2) NULL, [PRIVERL] [varchar](2000) NULL, [BF_PKW_BEGR] [char](1) NULL, [BF_PKWZ_BEGR] [char](1) NULL, [BF_DW_BEGR] [char](1) NULL, [BF_DWS_BEGR] [char](1) NULL, [BF_MIETW_BEGR] [char](1) NULL, [BF_TAXI_BEGR] [char](1) NULL, [BF_FLUG_BEGR] [char](1) NULL, [FKVERZICHT] [bit] NULL, [UKVERZICHT] [bit] NULL, [VERZICHTERL] [varchar](2000) NULL, [BF_PKW_BEGRTXT] [varchar](100) NULL, [BF_PKWZ_BEGRTXT] [varchar](100) NULL, [BF_DW_BEGRTXT] [varchar](100) NULL, [BF_DWS_BEGRTXT] [varchar](100) NULL, [BF_MIETW_BEGRTXT] [varchar](100) NULL, [BF_TAXI_BEGRTXT] [varchar](100) NULL, [BF_FLUG_BEGRTXT] [varchar](100) NULL, [SEMBEZ] [varchar](200) NULL, [SEMNR] [varchar](50) NULL, [SEMART] [char](1) NULL, [SEMTG] [char](1) NULL, [SEMERL] [varchar](200) NULL, [SEMVERM] [varchar](200) NULL, [KLR_KS1] [varchar](27) NULL, [KLR_KS2] [varchar](27) NULL, [KLR_KS3] [varchar](27) NULL, [KLR_KS4] [varchar](27) NULL, [KLR_KT1] [varchar](20) NULL, [KLR_KT2] [varchar](20) NULL, [KLR_KT3] [varchar](20) NULL, [KLR_KT4] [varchar](20) NULL, [KLR_AN1] [varchar](20) NULL, [KLR_AN2] [varchar](20) NULL, [KLR_AN3] [varchar](20) NULL, [KLR_AN4] [varchar](20) NULL, [KLR_KS1P] [smallint] NULL, [KLR_KS2P] [smallint] NULL, [KLR_KS3P] [smallint] NULL, [KLR_KS4P] [smallint] NULL, [KLR_KT1P] [smallint] NULL, [KLR_KT2P] [smallint] NULL, [KLR_KT3P] [smallint] NULL, [KLR_KT4P] [smallint] NULL, [KLR_AN1P] [smallint] NULL, [KLR_AN2P] [smallint] NULL, [KLR_AN3P] [smallint] NULL, [KLR_AN4P] [smallint] NULL, CONSTRAINT [PK_VORLAGE] PRIMARY KEY CLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[VORSCHUSS] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[VORSCHUSS]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [BEZ] [char](35) NULL, [BETRAG] [decimal](8, 2) NULL, CONSTRAINT [PK_VORSCHUSS] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[WEGENT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WEGENT]( [LNR] [int] IDENTITY(1,1) NOT NULL, [GILTAB] [smalldatetime] NULL, [WEGKM] [numeric](4, 2) NULL, [WEGKMB] [numeric](4, 2) NULL, [WEGKMZ] [numeric](4, 2) NULL, [WEGKMU] [numeric](4, 2) NULL, [WEGKM6] [numeric](4, 2) NULL, [WEGKMB6] [numeric](4, 2) NULL, [WEGKMZ6] [numeric](4, 2) NULL, [WEGKMU6] [numeric](4, 2) NULL, [MITKM] [numeric](4, 2) NULL, [TGKMANRE] [numeric](4, 2) NULL, [STRFREI] [numeric](4, 2) NULL, [WG] [char](3) NULL, [HBETR] [numeric](6, 2) NULL, [WEGKME1] [numeric](4, 2) NULL, [WEGKME2] [numeric](4, 2) NULL, [WEGKME3] [numeric](4, 2) NULL, [WEGKME1BEZ] [char](10) NULL, [WEGKME2BEZ] [char](10) NULL, [WEGKME3BEZ] [char](10) NULL, [SWZKM] [numeric](7, 2) NULL, [FAHRRAD] [numeric](7, 2) NULL, [STRFREI21] [numeric](4, 2) NULL, CONSTRAINT [PK_WEGENT] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_WEGENT] UNIQUE NONCLUSTERED ( [GILTAB] 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 /****** Object: Table [dbo].[ZUNACHT] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ZUNACHT]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ANR] [int] NULL, [TAG] [smalldatetime] NULL, [BETRAG] [numeric](7, 2) NULL, [UGBETRAG] [numeric](7, 2) NULL, [AUSLAGEN] [numeric](7, 2) NULL, [QUOTE] [numeric](5, 0) NULL, [ABZUG] [char](1) NULL, [AB_BETR] [numeric](7, 2) NULL, [MBUMST] [char](2) NULL, [ZUSCHUSS] [numeric](7, 2) NULL, [LAND] [char](8) NULL, [AU] [char](1) NULL, [STPAUSCH] [numeric](7, 2) NULL, [STRFREI] [numeric](7, 2) NULL, [FRUEST] [numeric](7, 2) NULL, [UEBERN] [char](1) NULL, [BEFMITT] [char](1) NULL, [REST] [numeric](7, 2) NULL, [MB_BELEG] [numeric](7, 2) NULL, [MB_MAX] [numeric](7, 2) NULL, [N_ERST] [numeric](7, 2) NULL, [GLORT] [char](1) NULL, [GRUND] [char](1) NULL, [GRENZUEB] [char](1) NULL, [AKZG] [bit] NULL, [WG] [char](3) NULL, [WGAUSLAGEN] [numeric](7, 2) NULL, [KURS] [numeric](10, 5) NULL, [ABW_KURS] [numeric](10, 5) NULL, [STEUSATZ] [smallint] NULL, [STEUER] [numeric](6, 2) NULL, [OG] [numeric](7, 2) NULL, [FRSTKOST] [numeric](7, 2) NULL, [STEUSATZF] [smallint] NULL, [STEUERF] [numeric](7, 2) NULL, [DIREKT] [bit] NULL, [AB_BETRM] [numeric](7, 2) NULL, CONSTRAINT [PK_ZUNACHT] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_ZUNACHT] UNIQUE NONCLUSTERED ( [ANR] ASC, [TAG] 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 /****** Object: Table [dbo].[ZUSCHUSS] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ZUSCHUSS]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ABRNR] [int] NULL, [BEZ] [char](35) NULL, [BETRAG] [decimal](8, 2) NULL, CONSTRAINT [PK_ZUSCHUSS] PRIMARY KEY NONCLUSTERED ( [LNR] 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 /****** Object: Table [dbo].[ZUTAG] Script Date: 08.12.2024 12:53:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ZUTAG]( [LNR] [int] IDENTITY(1,1) NOT NULL, [ANR] [int] NULL, [TAG] [smalldatetime] NULL, [EMPFNR] [numeric](6, 0) NULL, [NAME1] [char](25) NULL, [NAME2] [char](25) NULL, [BETRAG] [numeric](7, 2) NULL, [UGBETRAG] [numeric](7, 2) NULL, [AUSLAGEN] [numeric](7, 2) NULL, [ERSPARNIS] [numeric](7, 2) NULL, [ZUSCHUSS] [numeric](7, 2) NULL, [AUS_Z] [char](5) NULL, [EIN_Z] [char](5) NULL, [LAND] [char](8) NULL, [STLAND] [char](8) NULL, [FS] [char](1) NULL, [ME] [char](1) NULL, [AE] [char](1) NULL, [FS_SB] [char](1) NULL, [ME_SB] [char](1) NULL, [AE_SB] [char](1) NULL, [DG_FS] [char](1) NULL, [DG_ME] [char](1) NULL, [DG_AE] [char](1) NULL, [FS_SBW] [numeric](7, 2) NULL, [ME_SBW] [numeric](7, 2) NULL, [AE_SBW] [numeric](7, 2) NULL, [STPAUSCH] [numeric](7, 2) NULL, [SAMETAG] [char](1) NULL, [MERKMAL] [char](1) NULL, [STDAUER] [char](5) NULL, [STBETRAG] [numeric](7, 2) NULL, [STSACHBEZ] [numeric](7, 2) NULL, [ABZUG] [numeric](7, 2) NULL, [GLORT] [char](1) NULL, [DR_ART] [char](1) NULL, [SAMEDAU] [char](5) NULL, [SAMEGES] [numeric](7, 2) NULL, [SAMEABR] [numeric](7, 2) NULL, [GRENZUEB] [char](1) NULL, [MAXBETR] [numeric](7, 2) NULL, [ABZ_FS] [char](1) NULL, [ABZ_ME] [char](1) NULL, [ABZ_AE] [char](1) NULL, [AKZG] [bit] NULL, [UHR1] [char](5) NULL, [UHR2] [char](5) NULL, [FS_PROZ] [numeric](5, 2) NULL, [ME_PROZ] [numeric](5, 2) NULL, [AE_PROZ] [numeric](5, 2) NULL, [SVFS_PROZ] [numeric](5, 2) NULL, [SVME_PROZ] [numeric](5, 2) NULL, [SVAE_PROZ] [numeric](5, 2) NULL, [VERPP1] [numeric](7, 2) NULL, [VERPP2] [numeric](7, 2) NULL, [STEUTG] [numeric](7, 2) NULL, [ZIELLAND] [bit] NULL, [ABZUGP] [numeric](7, 2) NULL, [KGLORT] [bit] NULL, [MERKMM] [bit] NULL, CONSTRAINT [PK_ZUTAG] PRIMARY KEY NONCLUSTERED ( [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_ZUTAG] UNIQUE NONCLUSTERED ( [ANR] ASC, [TAG] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_ZUTAG_1] UNIQUE NONCLUSTERED ( [EMPFNR] ASC, [TAG] ASC, [ANR] 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 /****** Object: Index [IX_DIRKO] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_DIRKO] ON [dbo].[DIRKO] ( [ABRNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_EMPF] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_EMPF] ON [dbo].[EMPF] ( [NAME1] ASC, [NAME2] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_EMPF_1] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_EMPF_1] ON [dbo].[EMPF] ( [PERSNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_EMPF_2] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_EMPF_2] ON [dbo].[EMPF] ( [ORT] ASC, [NAME1] ASC, [NAME2] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_EMPF_3] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_EMPF_3] ON [dbo].[EMPF] ( [USERID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_FAHRKO] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_FAHRKO] ON [dbo].[FAHRKO] ( [ABRNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_HUEL] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL] ON [dbo].[HUEL] ( [EMPFNR] ASC, [ZAHLDAT] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_HUEL_1] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL_1] ON [dbo].[HUEL] ( [HHST] ASC, [NR] ASC, [EMPFNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_HUEL_2] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL_2] ON [dbo].[HUEL] ( [AZ] ASC, [HHST] ASC, [ZAHLDAT] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_HUEL_3] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL_3] ON [dbo].[HUEL] ( [EMPFNR] ASC, [DAT1] ASC, [UHR1] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_HUEL_4] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL_4] ON [dbo].[HUEL] ( [NAME1] ASC, [NAME2] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_HUEL_5] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL_5] ON [dbo].[HUEL] ( [ZAHLDAT] ASC, [HHST] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_HUEL_6] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_HUEL_6] ON [dbo].[HUEL] ( [USER2] ASC, [BATNR] ASC, [ZA] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_KLR_AN] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_KLR_AN] ON [dbo].[KLR_AN] ( [BEZ] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_KLR_KS] Script Date: 08.12.2024 12:53:08 ******/ CREATE UNIQUE NONCLUSTERED INDEX [IX_KLR_KS] ON [dbo].[KLR_KS] ( [SCHL] ASC, [USERID] 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 SET ANSI_PADDING ON GO /****** Object: Index [IX_KLR_KT] Script Date: 08.12.2024 12:53:08 ******/ CREATE UNIQUE NONCLUSTERED INDEX [IX_KLR_KT] ON [dbo].[KLR_KT] ( [SCHL] ASC, [USERID] 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_MITKO] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_MITKO] ON [dbo].[MITKO] ( [ABRNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_NEBKO] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_NEBKO] ON [dbo].[NEBKO] ( [ABRNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_ONFAHR] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_ONFAHR] ON [dbo].[ONFAHR] ( [MAN] ASC, [ANR] ASC, [FNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_ONMIT] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_ONMIT] ON [dbo].[ONMIT] ( [MAN] ASC, [ANR] ASC, [FNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_ONNEB] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_ONNEB] ON [dbo].[ONNEB] ( [MAN] ASC, [ANR] ASC, [FNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [IX_PLZ] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_PLZ] ON [dbo].[PLZ] ( [PLZ] ASC, [ORT] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_SRABR] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_SRABR] ON [dbo].[SRABR] ( [ABRNR] ASC, [DATUM] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_SRABR_1] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_SRABR_1] ON [dbo].[SRABR] ( [EMPFNR] ASC, [DATUM] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_SRANTRAGT] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_SRANTRAGT] ON [dbo].[SRANTRAGT] ( [ABRNR] ASC, [DATUM] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_SRANTRAGT_1] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_SRANTRAGT_1] ON [dbo].[SRANTRAGT] ( [EMPFNR] ASC, [DATUM] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_VORSCHUSS] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_VORSCHUSS] ON [dbo].[VORSCHUSS] ( [ABRNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_ZUSCHUSS] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_ZUSCHUSS] ON [dbo].[ZUSCHUSS] ( [ABRNR] ASC, [LNR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [IX_ZUTAG_2] Script Date: 08.12.2024 12:53:08 ******/ CREATE NONCLUSTERED INDEX [IX_ZUTAG_2] ON [dbo].[ZUTAG] ( [ANR] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[DAGANACHT] WITH CHECK ADD CONSTRAINT [FK_DAGANACHT_RKANTRAG] FOREIGN KEY([ANR]) REFERENCES [dbo].[RKANTRAG] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[DAGANACHT] CHECK CONSTRAINT [FK_DAGANACHT_RKANTRAG] GO ALTER TABLE [dbo].[DAGATAGE] WITH CHECK ADD CONSTRAINT [FK_DAGATAGE_RKANTRAG] FOREIGN KEY([ANR]) REFERENCES [dbo].[RKANTRAG] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[DAGATAGE] CHECK CONSTRAINT [FK_DAGATAGE_RKANTRAG] GO ALTER TABLE [dbo].[DIRKO] WITH CHECK ADD CONSTRAINT [FK_DIRKO_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[DIRKO] CHECK CONSTRAINT [FK_DIRKO_HUEL] GO ALTER TABLE [dbo].[FAHRKO] WITH CHECK ADD CONSTRAINT [FK_FAHRKO_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FAHRKO] CHECK CONSTRAINT [FK_FAHRKO_HUEL] GO ALTER TABLE [dbo].[HUEL] WITH CHECK ADD CONSTRAINT [FK_HUEL_AKTZ] FOREIGN KEY([AZ]) REFERENCES [dbo].[AKTZ] ([BEZ]) GO ALTER TABLE [dbo].[HUEL] CHECK CONSTRAINT [FK_HUEL_AKTZ] GO ALTER TABLE [dbo].[HUEL] WITH CHECK ADD CONSTRAINT [FK_HUEL_EMPF] FOREIGN KEY([EMPFNR]) REFERENCES [dbo].[EMPF] ([LNR]) GO ALTER TABLE [dbo].[HUEL] CHECK CONSTRAINT [FK_HUEL_EMPF] GO ALTER TABLE [dbo].[HUEL] WITH CHECK ADD CONSTRAINT [FK_HUEL_UEB] FOREIGN KEY([HHST]) REFERENCES [dbo].[UEB] ([HHST]) GO ALTER TABLE [dbo].[HUEL] CHECK CONSTRAINT [FK_HUEL_UEB] GO ALTER TABLE [dbo].[KOSTRECH] WITH CHECK ADD CONSTRAINT [FK_KOSTRECH_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[KOSTRECH] CHECK CONSTRAINT [FK_KOSTRECH_HUEL] GO ALTER TABLE [dbo].[MITKO] WITH CHECK ADD CONSTRAINT [FK_MITKO_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[MITKO] CHECK CONSTRAINT [FK_MITKO_HUEL] GO ALTER TABLE [dbo].[NEBKO] WITH CHECK ADD CONSTRAINT [FK_NEBKO_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[NEBKO] CHECK CONSTRAINT [FK_NEBKO_HUEL] GO ALTER TABLE [dbo].[ONFAHR] WITH CHECK ADD CONSTRAINT [FK_ONFAHR_RKANTRAG] FOREIGN KEY([ANR]) REFERENCES [dbo].[RKANTRAG] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ONFAHR] CHECK CONSTRAINT [FK_ONFAHR_RKANTRAG] GO ALTER TABLE [dbo].[ONGRENZ] WITH CHECK ADD CONSTRAINT [FK_ONGRENZ_RKANTRAG] FOREIGN KEY([ANR]) REFERENCES [dbo].[RKANTRAG] ([LNR]) GO ALTER TABLE [dbo].[ONGRENZ] CHECK CONSTRAINT [FK_ONGRENZ_RKANTRAG] GO ALTER TABLE [dbo].[ONMIT] WITH CHECK ADD CONSTRAINT [FK_ONMIT_RKANTRAG] FOREIGN KEY([ANR]) REFERENCES [dbo].[RKANTRAG] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ONMIT] CHECK CONSTRAINT [FK_ONMIT_RKANTRAG] GO ALTER TABLE [dbo].[ONNEB] WITH CHECK ADD CONSTRAINT [FK_ONNEB_RKANTRAG] FOREIGN KEY([ANR]) REFERENCES [dbo].[RKANTRAG] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ONNEB] CHECK CONSTRAINT [FK_ONNEB_RKANTRAG] GO ALTER TABLE [dbo].[SRABR] WITH CHECK ADD CONSTRAINT [FK_SRABR_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SRABR] CHECK CONSTRAINT [FK_SRABR_HUEL] GO ALTER TABLE [dbo].[SRANTRAGT] WITH CHECK ADD CONSTRAINT [FK_SRANTRAGT_SRANTRAG] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[SRANTRAG] ([LNR]) GO ALTER TABLE [dbo].[SRANTRAGT] CHECK CONSTRAINT [FK_SRANTRAGT_SRANTRAG] GO ALTER TABLE [dbo].[SRANTRAGT] WITH CHECK ADD CONSTRAINT [SRANTRAGT_Cascade] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[SRANTRAG] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SRANTRAGT] CHECK CONSTRAINT [SRANTRAGT_Cascade] GO ALTER TABLE [dbo].[TGTAGE] WITH CHECK ADD CONSTRAINT [FK_TGTAGE_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[TGTAGE] CHECK CONSTRAINT [FK_TGTAGE_HUEL] GO ALTER TABLE [dbo].[VORSCHUSS] WITH CHECK ADD CONSTRAINT [FK_VORSCHUSS_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[VORSCHUSS] CHECK CONSTRAINT [FK_VORSCHUSS_HUEL] GO ALTER TABLE [dbo].[ZUNACHT] WITH CHECK ADD CONSTRAINT [FK_ZUNACHT_HUEL] FOREIGN KEY([ANR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ZUNACHT] CHECK CONSTRAINT [FK_ZUNACHT_HUEL] GO ALTER TABLE [dbo].[ZUSCHUSS] WITH CHECK ADD CONSTRAINT [FK_ZUSCHUSS_HUEL] FOREIGN KEY([ABRNR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ZUSCHUSS] CHECK CONSTRAINT [FK_ZUSCHUSS_HUEL] GO ALTER TABLE [dbo].[ZUTAG] WITH CHECK ADD CONSTRAINT [FK_ZUTAG_HUEL] FOREIGN KEY([ANR]) REFERENCES [dbo].[HUEL] ([LNR]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ZUTAG] CHECK CONSTRAINT [FK_ZUTAG_HUEL] GO /***** Trigger HUEL_APP *****/ IF OBJECT_ID(N'HUEL_APP', N'TR') IS NOT NULL exec sp_executesql N'DROP TRIGGER HUEL_APP'; GO CREATE TRIGGER [dbo].[HUEL_APP] ON [dbo].[HUEL] FOR INSERT AS DECLARE @NR1 NUMERIC DECLARE @NR2 NUMERIC DECLARE @COUNT_UEB NUMERIC DECLARE @COUNT_BUDGET NUMERIC DECLARE @COUNT_EMPF NUMERIC DECLARE @COUNT_BAHNCARD NUMERIC SELECT @COUNT_UEB = COUNT(*) FROM UEB,INSERTED WHERE UEB.HHST = INSERTED.HHST SELECT @COUNT_BUDGET = COUNT(*) FROM BUDGET,INSERTED WHERE BUDGET.JAHR = SUBSTRING(INSERTED.HHST,1,2) AND BUDGET.BEZ = INSERTED.AZ SELECT @COUNT_EMPF = COUNT(*) FROM EMPF,INSERTED WHERE EMPF.LNR = INSERTED.EMPFNR SELECT @COUNT_BAHNCARD = COUNT(*) FROM BAHNCARD,INSERTED WHERE BAHNCARD.EMPFNR = INSERTED.EMPFNR AND INSERTED.DAT1 >= BAHNCARD.DATVON AND INSERTED.DAT1 <= BAHNCARD.DATBIS SELECT @NR1 = INSERTED.NR FROM INSERTED IF @COUNT_UEB = 1 SELECT @NR2 = UEB.NR FROM UEB,INSERTED WHERE UEB.HHST = INSERTED.HHST IF @NR2 > @NR1 SELECT @NR1 = @NR2 UPDATE HUEL SET TIMESTAMP = CONVERT(VARCHAR,GETDATE(),21) FROM HUEL,INSERTED WHERE HUEL.LNR = INSERTED.LNR IF @COUNT_UEB = 1 UPDATE UEB SET VERBR = 0 FROM UEB, INSERTED WHERE UEB.HHST = INSERTED.HHST AND UEB.VERBR IS NULL UPDATE UEB SET VERBR = UEB.VERBR + INSERTED.BETRAG, NR = @NR1, SUM_AUSZ = UEB.SUM_AUSZ + 1 FROM UEB, INSERTED WHERE UEB.HHST = INSERTED.HHST IF @COUNT_BUDGET = 1 UPDATE BUDGET SET SUM_AUSZ = 0, A_TOTAL = 0 FROM BUDGET,INSERTED WHERE BUDGET.JAHR = SUBSTRING(INSERTED.HHST,1,2) AND BUDGET.BEZ = INSERTED.AZ AND (BUDGET.SUM_AUSZ IS NULL OR BUDGET.A_TOTAL IS NULL) UPDATE BUDGET SET SUM_AUSZ = BUDGET.SUM_AUSZ + 1, A_TOTAL = BUDGET.A_TOTAL + INSERTED.BETRAG FROM BUDGET,INSERTED WHERE BUDGET.JAHR = SUBSTRING(INSERTED.HHST,1,2) AND BUDGET.BEZ = INSERTED.AZ IF @COUNT_EMPF = 1 UPDATE EMPF SET VSZU = EMPF.VSZU + INSERTED.VSBETRAG, VSAB = EMPF.VSAB + INSERTED.SUM10 FROM EMPF,INSERTED WHERE EMPF.LNR = INSERTED.EMPFNR IF @COUNT_EMPF = 1 UPDATE EMPF SET VSSALDO = EMPF.VSZU - EMPF.VSAB FROM EMPF,INSERTED WHERE EMPF.LNR = INSERTED.EMPFNR IF @COUNT_BAHNCARD > 0 UPDATE BAHNCARD SET SUMERST = BAHNCARD.SUMERST + INSERTED.BCERST FROM BAHNCARD,INSERTED WHERE BAHNCARD.EMPFNR = INSERTED.EMPFNR AND INSERTED.DAT1 >= BAHNCARD.DATVON AND INSERTED.DAT1 <= BAHNCARD.DATBIS GO /***** Trigger HUEL_DEL *****/ IF OBJECT_ID(N'HUEL_DEL', N'TR') IS NOT NULL exec sp_executesql N'DROP TRIGGER HUEL_DEL'; GO CREATE TRIGGER [dbo].[HUEL_DEL] ON [dbo].[HUEL] FOR DELETE AS DECLARE @COUNT_UEB NUMERIC DECLARE @COUNT_BUDGET NUMERIC DECLARE @COUNT_EMPF NUMERIC DECLARE @COUNT_BAHNCARD NUMERIC SELECT @COUNT_UEB = COUNT(*) FROM UEB,DELETED WHERE UEB.HHST = DELETED.HHST SELECT @COUNT_BUDGET = COUNT(*) FROM BUDGET,DELETED WHERE BUDGET.JAHR = SUBSTRING(DELETED.HHST,1,2) AND BUDGET.BEZ = DELETED.AZ SELECT @COUNT_EMPF = COUNT(*) FROM EMPF,DELETED WHERE EMPF.LNR = DELETED.EMPFNR SELECT @COUNT_BAHNCARD = COUNT(*) FROM BAHNCARD,DELETED WHERE BAHNCARD.EMPFNR = DELETED.EMPFNR AND DELETED.DAT1 >= BAHNCARD.DATVON AND DELETED.DAT1 <= BAHNCARD.DATBIS IF @COUNT_UEB = 1 UPDATE UEB SET VERBR = UEB.VERBR - DELETED.BETRAG, SUM_AUSZ = UEB.SUM_AUSZ - 1 FROM UEB, DELETED WHERE UEB.HHST = DELETED.HHST IF @COUNT_BUDGET = 1 UPDATE BUDGET SET SUM_AUSZ = BUDGET.SUM_AUSZ - 1, A_TOTAL = BUDGET.A_TOTAL - DELETED.BETRAG FROM BUDGET,DELETED WHERE BUDGET.JAHR = SUBSTRING(DELETED.HHST,1,2) AND BUDGET.BEZ = DELETED.AZ IF @COUNT_EMPF = 1 UPDATE EMPF SET VSZU = EMPF.VSZU - DELETED.VSBETRAG, VSAB = EMPF.VSAB - DELETED.SUM10 FROM EMPF,DELETED WHERE EMPF.LNR = DELETED.EMPFNR IF @COUNT_EMPF = 1 UPDATE EMPF SET VSSALDO = EMPF.VSZU - EMPF.VSAB FROM EMPF,DELETED WHERE EMPF.LNR = DELETED.EMPFNR IF @COUNT_BAHNCARD > 0 UPDATE BAHNCARD SET SUMERST = BAHNCARD.SUMERST - DELETED.BCERST FROM BAHNCARD,DELETED WHERE BAHNCARD.EMPFNR = DELETED.EMPFNR AND DELETED.DAT1 >= BAHNCARD.DATVON AND DELETED.DAT1 <= BAHNCARD.DATBIS GO /****** Trigger HUEL_UPD ******/ IF OBJECT_ID(N'HUEL_UPD', N'TR') IS NOT NULL exec sp_executesql N'DROP TRIGGER HUEL_UPD'; GO CREATE TRIGGER [dbo].[HUEL_UPD] ON [dbo].[HUEL] FOR UPDATE AS DECLARE @NR1 NUMERIC DECLARE @NR2 NUMERIC DECLARE @COUNT_UEB NUMERIC DECLARE @COUNT_BUDGET NUMERIC DECLARE @COUNT_EMPF NUMERIC DECLARE @COUNT_UEB_D NUMERIC DECLARE @COUNT_BUDGET_D NUMERIC DECLARE @COUNT_EMPF_D NUMERIC DECLARE @BETRAG NUMERIC DECLARE @BETRAG_D NUMERIC DECLARE @COUNT_BAHNCARD NUMERIC DECLARE @COUNT_BAHNCARD_D NUMERIC SELECT @COUNT_UEB = COUNT(*) FROM UEB,INSERTED WHERE UEB.HHST = INSERTED.HHST SELECT @COUNT_BUDGET = COUNT(*) FROM BUDGET,INSERTED WHERE BUDGET.JAHR = SUBSTRING(INSERTED.HHST,1,2) AND BUDGET.BEZ = INSERTED.AZ SELECT @COUNT_EMPF = COUNT(*) FROM EMPF,INSERTED WHERE EMPF.LNR = INSERTED.EMPFNR SELECT @COUNT_BAHNCARD = COUNT(*) FROM BAHNCARD,INSERTED WHERE BAHNCARD.EMPFNR = INSERTED.EMPFNR AND INSERTED.DAT1 >= BAHNCARD.DATVON AND INSERTED.DAT1 <= BAHNCARD.DATBIS SELECT @COUNT_UEB_D = COUNT(*) FROM UEB,DELETED WHERE UEB.HHST = DELETED.HHST SELECT @COUNT_BUDGET_D = COUNT(*) FROM BUDGET,DELETED WHERE BUDGET.JAHR = SUBSTRING(DELETED.HHST,1,2) AND BUDGET.BEZ = DELETED.AZ SELECT @COUNT_EMPF_D = COUNT(*) FROM EMPF,DELETED WHERE EMPF.LNR = DELETED.EMPFNR SELECT @COUNT_BAHNCARD_D = COUNT(*) FROM BAHNCARD,DELETED WHERE BAHNCARD.EMPFNR = DELETED.EMPFNR AND DELETED.DAT1 >= BAHNCARD.DATVON AND DELETED.DAT1 <= BAHNCARD.DATBIS SELECT @NR1 = INSERTED.NR FROM INSERTED IF @COUNT_UEB = 1 SELECT @NR2 = UEB.NR FROM UEB,INSERTED WHERE UEB.HHST = INSERTED.HHST IF @NR2 > @NR1 SELECT @NR1 = @NR2 UPDATE HUEL SET TIMESTAMP = CONVERT(VARCHAR,GETDATE(),21) FROM HUEL, INSERTED WHERE HUEL.LNR = INSERTED.LNR IF @COUNT_UEB_D = 1 UPDATE UEB SET VERBR = UEB.VERBR - DELETED.BETRAG, SUM_AUSZ = UEB.SUM_AUSZ - 1 FROM UEB, DELETED WHERE UEB.HHST = DELETED.HHST IF @COUNT_UEB = 1 UPDATE UEB SET VERBR = UEB.VERBR + INSERTED.BETRAG, NR = @NR1, SUM_AUSZ = UEB.SUM_AUSZ + 1 FROM UEB, INSERTED WHERE UEB.HHST = INSERTED.HHST IF @COUNT_BUDGET_D = 1 UPDATE BUDGET SET SUM_AUSZ = BUDGET.SUM_AUSZ - 1, A_TOTAL = BUDGET.A_TOTAL - DELETED.BETRAG FROM BUDGET,DELETED WHERE BUDGET.BEZ = DELETED.AZ AND BUDGET.JAHR = SUBSTRING(DELETED.HHST,1,2) IF @COUNT_BUDGET = 1 UPDATE BUDGET SET SUM_AUSZ = BUDGET.SUM_AUSZ + 1, A_TOTAL = BUDGET.A_TOTAL + INSERTED.BETRAG FROM BUDGET,INSERTED WHERE BUDGET.BEZ = INSERTED.AZ AND BUDGET.JAHR = SUBSTRING(INSERTED.HHST,1,2) IF @COUNT_EMPF_D = 1 UPDATE EMPF SET VSZU = EMPF.VSZU - DELETED.VSBETRAG, VSAB = EMPF.VSAB - DELETED.SUM10 FROM EMPF,DELETED WHERE EMPF.LNR = DELETED.EMPFNR IF @COUNT_EMPF_D = 1 UPDATE EMPF SET VSSALDO = EMPF.VSZU - EMPF.VSAB FROM EMPF,DELETED WHERE EMPF.LNR = DELETED.EMPFNR IF @COUNT_EMPF = 1 UPDATE EMPF SET VSZU = EMPF.VSZU + INSERTED.VSBETRAG, VSAB = EMPF.VSAB + INSERTED.SUM10 FROM EMPF,INSERTED WHERE EMPF.LNR = INSERTED.EMPFNR IF @COUNT_EMPF = 1 UPDATE EMPF SET VSSALDO = EMPF.VSZU - EMPF.VSAB FROM EMPF,INSERTED WHERE EMPF.LNR = INSERTED.EMPFNR IF @COUNT_BAHNCARD_D > 0 UPDATE BAHNCARD SET SUMERST = BAHNCARD.SUMERST - DELETED.BCERST FROM BAHNCARD,DELETED WHERE BAHNCARD.EMPFNR = DELETED.EMPFNR AND DELETED.DAT1 >= BAHNCARD.DATVON AND DELETED.DAT1 <= BAHNCARD.DATBIS IF @COUNT_BAHNCARD > 0 UPDATE BAHNCARD SET SUMERST = BAHNCARD.SUMERST + INSERTED.BCERST FROM BAHNCARD,INSERTED WHERE BAHNCARD.EMPFNR = INSERTED.EMPFNR AND INSERTED.DAT1 >= BAHNCARD.DATVON AND INSERTED.DAT1 <= BAHNCARD.DATBIS GO USE [master] GO ALTER DATABASE [Reisekosten] SET READ_WRITE GO