Subject Re: Column Sequence in Grid
From Peter Hegelbach <peter@hegelbach.com>
Date Tue, 20 Sep 2022 23:04:49 +0200
Newsgroups dbase.getting-started
Attachment(s) create Tables.sql

and hier a sql for creating the tables
Peter


Am 20.09.2022 um 23:00 schrieb Peter Hegelbach:
> Hi Daniel
 >
> A short explanation first:
 > for any user, client and grid a save the settings in a database (in my
> case ms sql). Also all fields must be registered with name, type and so
> on. User 0 ist the presetting.
 >
>  >> how do you handle the "filter bar", if the grid is wider then
 >  >> the window (horizontal scrolling)?
 >
> I don't do much. If the grid is longer, part of it is not shown.
 >
>  >> How do you change the columns "on the fly" without reopening the
 >  >> form? Do you create a new grid?
 >
> Yes. I delete the old grid an build a new one. See function
> PH_FilterGrid::myinit(iUserFID, iClientFID)
 >
> In the ZIP-File is hopefully all, what you need to analyze. Otherwise aks.
 >
> Peter
 >
>
> Am 20.09.2022 um 14:20 schrieb Daniel Georgi:
 >> Am 19.09.2022 um 22:22 schrieb Peter Hegelbach:
 >>> Do you mean something like this (in the video)?
 >>>
 >>> Once I had a project called filterGrid, which was able to select
>>> columns, change order and save seperately for every user. Lot of
>>> code, so first only a video:
 >>>
 >>> https://vimeo.com/751392896/6ce7bd5c1b
 >>>
 >>> Peter
 >>>
 >>>
 >>> Am 16.09.2022 um 18:25 schrieb Milind Nighojkar:
 >>>> Is there any way to change the column sequence in a grid (not by
>>>> drag and drop menthod.) thru code before opening  a form.
 >>>>
 >>>> Example : Say column 3 is date filed and should me moved to column 5
>>>> and column 5 to col 3.
 >>>>
 >>>> Regards
 >>>>
 >>>> Milind Nighojkar
 >>>
 >>
 >> Hello Peter,
 >>
 >> how do you handle the "filter bar", if the grid is wider then the
>> window (horizontal scrolling)?
 >>
 >> How do you change the columns "on the fly" without reopening the form?
 >> Do you create a new grid?
 >>
 >> Thanks
 >> Daniel
 >>



CREATE TABLE [dbo].[GRIDSET](
        [GRIDS_ID] [int] IDENTITY(1,1) NOT NULL,
        [GRIDS_LIST] [varchar](30) NOT NULL,
        [GRIDS_CLIENTFID] [int] NULL,
        [GRIDS_USERFID] [int] NULL,
        [GRIDS_SORTORDER] [varchar](30) NULL,
CONSTRAINT [PK_GRIDSET] PRIMARY KEY CLUSTERED
(
        [GRIDS_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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[GRIDSETUP]    Script Date: 20.09.2022 23:02:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GRIDSETUP](
        [GRIDU_ID] [int] IDENTITY(1,1) NOT NULL,
        [GRIDU_GRIDSETFID] [int] NOT NULL,
        [GRIDU_COLUMNNO] [int] NOT NULL,
        [GRIDU_FIELDDB] [varchar](25) NOT NULL,
        [GRIDU_DISPLAYNAME] [varchar](25) NOT NULL,
        [GRIDU_WIDTH] [int] NOT NULL,
        [GRIDU_VISIBLE] [bit] NOT NULL,
        [GRIDU_ALIGNEMENT] [varchar](3) NOT NULL,
        [GRIDU_KEYFIELD] [bit] NOT NULL,
        [GRIDU_COLUMNNEW] [int] NULL,
CONSTRAINT [PK_GRIDSETUP] PRIMARY KEY CLUSTERED
(
        [GRIDU_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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MITARBEITER]    Script Date: 20.09.2022 23:02:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MITARBEITER](
        [ID] [int] IDENTITY(1,1) NOT NULL,
        [MANDANT_FID] [int] NOT NULL,
        [ZEICHEN] [varchar](5) NOT NULL,
        [NAME] [varchar](30) NOT NULL,
        [VORNAME] [varchar](25) NULL,
        [VERRSATZ] [numeric](6, 2) NULL,
        [AKTIV] [bit] NULL,
        [ISTREVISOR] [bit] NULL,
        [ISTREVEXPERTE] [bit] NULL,
        [MANDATSLEITER] [bit] NULL,
        [EMAIL] [varchar](100) NULL,
        [SHAB_BEOBACHTGDE] [varchar](200) NULL,
        [PLZ] [varchar](5) NULL,
        [ORT] [varchar](30) NULL,
        [KANTON] [varchar](3) NULL,
        [STRASSE] [varchar](40) NULL,
        [SHAB_BEOBKUNDEN] [bit] NULL DEFAULT ((0)),
CONSTRAINT [PK_MITARBEITER] PRIMARY KEY CLUSTERED
(
        [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
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[GRIDSET] ON

GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (1, N'MITARBEITERLISTE', 0, 0, N'NAME')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (2, N'MANDANTENLISTE', 0, 0, N'SORTNAME')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (3, N'PLZCODE', 0, 0, N'PLZ')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (4, N'LAND', 0, 0, N'CODE')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (5, N'PLZCODE', 1, 1, N'PLZ')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (6, N'MITARBEITERLISTE', 1, 1, N'ZEICHEN DESC')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (7, N'MANDANTENLISTE', 1, 1, N'SORTNAME')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (8, N'MITARBEITERLISTE', 1, 3, N'NAME')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (9, N'MANDANTENLISTE', 1, 3, N'SORTNAME')
GO
INSERT [dbo].[GRIDSET] ([GRIDS_ID], [GRIDS_LIST], [GRIDS_CLIENTFID], [GRIDS_USERFID], [GRIDS_SORTORDER]) VALUES (10, N'PLZCODE', 1, 3, N'PLZ')
GO
SET IDENTITY_INSERT [dbo].[GRIDSET] OFF
GO
SET IDENTITY_INSERT [dbo].[GRIDSETUP] ON

GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (1, 1, 1, N'MA_ID', N'ID', 15, 1, N'nuT', 1, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (2, 1, 2, N'ZEICHEN', N'Alias', 20, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (3, 1, 3, N'NAME', N'Name', 30, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (4, 1, 4, N'VORNAME', N'Vorname', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (5, 1, 5, N'VERRSATZ', N'Ansatz', 10, 1, N'be2', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (6, 1, 6, N'AKTIV', N'Aktiv', 10, 1, N'log', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (7, 1, 7, N'ISTREVISOR', N'Revisor', 10, 1, N'log', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (8, 1, 8, N'ISTREVEXPERTE', N'Rev.experte', 10, 1, N'log', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (9, 1, 9, N'MANDATSLEITER', N'Mandatsleit.', 10, 1, N'log', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (10, 2, 1, N'ID', N'ID', 15, 1, N'nuT', 1, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (11, 2, 2, N'SORTNAME', N'Sortiername', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (12, 2, 3, N'MANDANTNR', N'Mand.#', 15, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (13, 2, 4, N'NAME', N'Name1', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (14, 2, 5, N'NAME2', N'Name2', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (15, 2, 6, N'ADRESSE', N'Adresse', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (16, 2, 7, N'LAND', N'Land', 10, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (17, 2, 8, N'PLZ', N'PLZ', 10, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (18, 2, 9, N'ORT', N'Ort', 15, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (19, 2, 10, N'TOPALSERVER', N'Topalserver', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (20, 2, 11, N'TOPALMANDANT', N'Topalmandant', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (21, 3, 1, N'ID', N'ID', 7, 1, N'nuT', 1, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (22, 3, 2, N'PLZ', N'PLZ', 7, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (23, 3, 3, N'ORT', N'Ort', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (24, 3, 4, N'KANTON', N'Kanton', 7, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (25, 3, 5, N'LAND', N'Land', 7, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (26, 4, 1, N'CODE', N'Code', 7, 1, N'tex', 1, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (27, 4, 2, N'BEZ_GER', N'Bez. Deutsch', 20, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (28, 4, 3, N'BEZ_FRA', N'Bez. Französisch', 20, 0, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (29, 4, 4, N'BEZ_ITA', N'Bez. Italienisch', 20, 0, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (30, 4, 5, N'BEZ_ENG', N'Bez. Englisch', 20, 0, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (31, 5, 1, N'ID', N'ID', 7, 1, N'nuT', 1, 1)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (32, 5, 2, N'PLZ', N'PLZ', 7, 1, N'tex', 0, 2)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (33, 5, 3, N'ORT', N'Ort', 25, 1, N'tex', 0, 3)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (34, 5, 4, N'KANTON', N'Kanton', 7, 1, N'tex', 0, 4)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (35, 5, 5, N'LAND', N'Land', 7, 1, N'tex', 0, 5)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (36, 6, 1, N'MA_ID', N'ID', 18, 1, N'nuT', 1, 1)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (37, 6, 3, N'ZEICHEN', N'Alias', 20, 1, N'tex', 0, 3)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (38, 6, 2, N'NAME', N'Name', 23, 1, N'tex', 0, 2)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (39, 6, 4, N'VORNAME', N'Vorname', 18, 1, N'tex', 0, 4)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (40, 6, 6, N'VERRSATZ', N'Ansatz', 12, 1, N'be2', 0, 6)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (41, 6, 5, N'AKTIV', N'Aktiv', 9, 1, N'log', 0, 5)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (42, 6, 7, N'ISTREVISOR', N'Revisor', 10, 1, N'log', 0, 7)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (43, 6, 8, N'ISTREVEXPERTE', N'Rev.experte', 20, 1, N'log', 0, 8)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (44, 6, 9, N'MANDATSLEITER', N'Mandatsleit.', 12, 1, N'log', 0, 9)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (45, 7, 1, N'ID', N'ID', 15, 1, N'nuT', 1, 1)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (46, 7, 2, N'SORTNAME', N'Sortiername', 25, 1, N'tex', 0, 2)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (47, 7, 3, N'MANDANTNR', N'Mand.#', 15, 1, N'tex', 0, 3)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (48, 7, 5, N'NAME', N'Name1', 25, 1, N'tex', 0, 5)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (49, 7, 4, N'NAME2', N'Name2', 25, 1, N'tex', 0, 4)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (50, 7, 6, N'ADRESSE', N'Adresse', 25, 1, N'tex', 0, 6)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (51, 7, 7, N'LAND', N'Land', 10, 1, N'tex', 0, 7)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (52, 7, 8, N'PLZ', N'PLZ', 10, 1, N'tex', 0, 8)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (53, 7, 9, N'ORT', N'Ort', 15, 1, N'tex', 0, 9)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (54, 7, 10, N'TOPALSERVER', N'Topalserver', 25, 1, N'tex', 0, 10)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (55, 7, 11, N'TOPALMANDANT', N'Topalmandant', 25, 1, N'tex', 0, 11)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (56, 8, 3, N'MA_ID', N'ID', 8, 1, N'nuT', 1, 3)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (57, 8, 1, N'ZEICHEN', N'Alias', 20, 0, N'tex', 0, 1)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (58, 8, 2, N'NAME', N'Name', 16, 1, N'tex', 0, 2)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (59, 8, 4, N'VORNAME', N'Vorname', 25, 1, N'tex', 0, 4)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (60, 8, 5, N'VERRSATZ', N'Ansatz', 10, 1, N'be2', 0, 5)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (61, 8, 6, N'AKTIV', N'Aktiv', 10, 1, N'log', 0, 6)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (62, 8, 7, N'ISTREVISOR', N'Revisor', 10, 1, N'log', 0, 7)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (63, 8, 8, N'ISTREVEXPERTE', N'Rev.experte', 10, 1, N'log', 0, 8)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (64, 8, 9, N'MANDATSLEITER', N'Mandatsleit.', 10, 1, N'log', 0, 9)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (65, 9, 1, N'ID', N'ID', 15, 1, N'nuT', 1, 1)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (66, 9, 2, N'SORTNAME', N'Sortiername', 25, 1, N'tex', 0, 2)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (67, 9, 3, N'MANDANTNR', N'Mand.#', 15, 1, N'tex', 0, 3)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (68, 9, 5, N'NAME', N'Name1', 25, 1, N'tex', 0, 5)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (69, 9, 4, N'NAME2', N'Name2', 25, 1, N'tex', 0, 4)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (70, 9, 6, N'ADRESSE', N'Adresse', 25, 1, N'tex', 0, 6)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (71, 9, 7, N'LAND', N'Land', 10, 0, N'tex', 0, 7)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (72, 9, 9, N'PLZ', N'PLZ', 10, 1, N'tex', 0, 9)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (73, 9, 8, N'ORT', N'Ort', 15, 1, N'tex', 0, 8)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (74, 9, 10, N'TOPALSERVER', N'Topalserver', 25, 1, N'tex', 0, 10)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (75, 9, 11, N'TOPALMANDANT', N'Topalmandant', 25, 1, N'tex', 0, 11)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (76, 10, 1, N'ID', N'ID', 7, 1, N'nuT', 1, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (77, 10, 2, N'PLZ', N'PLZ', 7, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (78, 10, 3, N'ORT', N'Ort', 25, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (79, 10, 4, N'KANTON', N'Kanton', 7, 1, N'tex', 0, NULL)
GO
INSERT [dbo].[GRIDSETUP] ([GRIDU_ID], [GRIDU_GRIDSETFID], [GRIDU_COLUMNNO], [GRIDU_FIELDDB], [GRIDU_DISPLAYNAME], [GRIDU_WIDTH], [GRIDU_VISIBLE], [GRIDU_ALIGNEMENT], [GRIDU_KEYFIELD], [GRIDU_COLUMNNEW]) VALUES (80, 10, 5, N'LAND', N'Land', 7, 1, N'tex', 0, NULL)
GO
SET IDENTITY_INSERT [dbo].[GRIDSETUP] OFF
GO
SET IDENTITY_INSERT [dbo].[MITARBEITER] ON

GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (0, 1, N'UD', N'undefinierter Mitarbeiter', N'', CAST(100.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (1, 1, N'PH', N'Hegelbach', N'Peter', CAST(210.00 AS Numeric(6, 2)), 1, 1, 1, 1, N'p.hegelbach@hit-treuhand.ch', N'Uster; Oetwil am See;', N'8610', N'Uster', N'ZH', N'Forchstrasse 22a', 1)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (2, 1, N'SP', N'Preisig', N'Sonja', CAST(100.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (3, 1, N'PG', N'Ghilardi', N'Pawel', CAST(150.00 AS Numeric(6, 2)), 0, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (4, 1, N'MM', N'Montanari', N'Moira', CAST(130.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (5, 1, N'KW', N'Walther', N'Karin', CAST(130.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (6, 1, N'SW', N'Wambululu', N'Silvia', CAST(100.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (7, 1, N'PJ', N'Jäger', N'Petra', CAST(178.00 AS Numeric(6, 2)), 1, 1, 0, 1, N'p.jaeger@hit-treuhand.ch', N'Wildberg;', N'8489', N'Wildberg', N'ZH', N'Sunnhaldestrasse 14', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (8, 1, N'LH', N'Hegelbach', N'Laura', CAST(20.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (9, 1, N'CS', N'Sporis', N'Carmen', CAST(130.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (10, 1, N'KÜ', N'Kündig', N'Martin', CAST(140.00 AS Numeric(6, 2)), 0, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (11, 1, N'WP', N'Weibel', N'Petra', CAST(120.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (12, 1, N'NF', N'Fehr', N'Nicole', CAST(130.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (13, 1, N'SS', N'Stahl', N'Stefanie', CAST(178.00 AS Numeric(6, 2)), 1, 1, 1, 1, N's.stahl@hit-treuhand.ch', N'Hittnau; Pfäffikon', N'8335', N'Hittnau', N'ZH', N'Zimbergstrasse 13', 1)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (14, 1, N'FI', N'Fiktiver MA', N'', CAST(140.00 AS Numeric(6, 2)), 1, 0, 0, 0, NULL, NULL, N'8610', N'Uster', N'ZH', NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (15, 1, N'RH', N'Hegelbach', N'Ruth', CAST(180.00 AS Numeric(6, 2)), 0, 0, 0, 0, N'ruth@hegelbach.com', N'', NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (16, 1, N'KB', N'Bachmann', N'Karin', CAST(120.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (17, 1, N'SIH', N'Harmann', N'Simona', CAST(90.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (18, 1, N'RK', N'Keist', N'Remo', CAST(178.00 AS Numeric(6, 2)), 1, 1, 0, 1, N'r.keist@hit-treuhand.ch', N'Bauma; Fischenthal; Wila;Bäretswil;', N'8615', N'Wermatswil', N'ZH', N'Kleinjogg-Strasse 14', 1)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (19, 1, N'DS', N'Suremann', N'Danja', CAST(80.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (20, 1, N'LE', N'Ehrbar', N'Livia', CAST(170.00 AS Numeric(6, 2)), 1, 0, 0, 1, N'l.ehrbar@hit-treuhand.ch', N'Oetwil am See;', N'8610', N'Uster', N'ZH', N'Feldhofstrasse 24', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (24, 1, N'SH', N'Hauri', N'Sylviane', CAST(160.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (26, 1, N'NU', N'Urscheler', N'Nadine', CAST(160.00 AS Numeric(6, 2)), 0, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (27, 1, N'MK', N'Küng', N'Michael', CAST(110.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (28, 1, N'NM', N'Molag', N'Nicole', CAST(160.00 AS Numeric(6, 2)), 0, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (29, 1, N'JS', N'Schiesser', N'Jasmin', CAST(145.00 AS Numeric(6, 2)), 1, 0, 0, 1, N'j.schiesser@hit-treuhand.ch', N'Wildberg;', N'8488', N'Turbenthal', N'ZH', N'Setziweg 3', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (30, 1, N'AF', N'Faiglé', N'Alfons', CAST(45.00 AS Numeric(6, 2)), 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (31, 1, N'SA', N'Ammann', N'Sabrina', CAST(170.00 AS Numeric(6, 2)), 1, 0, 0, 1, N's.ammann@hit-treuhand.ch', NULL, N'8409', N'Winterthur', N'ZH', N'Im oberen Gern 75', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (32, 1, N'JT', N'Thalhofer', N'Jana', CAST(55.00 AS Numeric(6, 2)), 0, 0, 0, 0, N'j.thalhofer@hit-treuhand.ch', NULL, N'8737', N'Gommiswald', N'SG', N'Rietwiesstrasse 10', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (33, 1, N'VVA', N'von Allmen', N'Verena', CAST(165.00 AS Numeric(6, 2)), 0, 0, 0, 1, N'v.vonallmen@hit-treuhand.ch', NULL, N'8627', N'Grüningen', N'ZH', N'In der Gass 1', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (34, 1, N'KE', N'Ebnöther', N'Karin', CAST(170.00 AS Numeric(6, 2)), 1, 0, 0, 1, N'k.ebnoether@hit-treuhand.ch', N'Turbenthal;', N'8494', N'Bauma', N'ZH', N'Lüwisstrasse 12', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (35, 1, N'MN', N'Nuzzo', N'Maurizio', CAST(160.00 AS Numeric(6, 2)), 0, 0, 0, 1, N'm.nuzzo@hit-treuhand.ch', N'', N'8700', N'Küsnacht', N'ZH', N'Schüracherstrasse 2', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (36, 1, N'LB', N'Bischoff', N'Lars', CAST(55.00 AS Numeric(6, 2)), 0, 0, 0, 0, N'l.bischoff@hit-treuhand.ch', N'', N'', N'', N'', N'', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (37, 1, N'TB', N'Bernhard', N'Tamara', CAST(145.00 AS Numeric(6, 2)), 1, 0, 0, 1, N't.bernhard@hit-treuhand.ch', N'', N'8303', N'Bassersdorf', N'ZH', N'Bachstrasse 3', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (38, 1, N'HA', N'Al-Rafu', N'Hadi', CAST(55.00 AS Numeric(6, 2)), 0, 0, 0, 0, N'h.alrafu@hit-treuhand.ch', N'', N'8053', N'Zürich', N'ZH', N'Drusbergstrasse 136', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (39, 1, N'PD', N'Dias', N'Patricia', CAST(135.00 AS Numeric(6, 2)), 0, 0, 0, 0, N'p.dias@hit-treuhand.ch', N'', N'8330', N'Pfäffikon ZH', N'ZH', N'Mattenstrasse 92', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (1039, 1, N'LW', N'Widmer', N'Lina', CAST(130.00 AS Numeric(6, 2)), 1, 0, 0, 0, N'', N'', N'', N'', N'', N'', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (1040, 1, N'CB', N'Brunner', N'Celine', CAST(80.00 AS Numeric(6, 2)), 1, 0, 0, 0, N'c.brunner@hit-treuhand.ch', N'', N'8332', N'Russikon', N'ZH', N'Eggwiesstrasse 39', 0)
GO
INSERT [dbo].[MITARBEITER] ([ID], [MANDANT_FID], [ZEICHEN], [NAME], [VORNAME], [VERRSATZ], [AKTIV], [ISTREVISOR], [ISTREVEXPERTE], [MANDATSLEITER], [EMAIL], [SHAB_BEOBACHTGDE], [PLZ], [ORT], [KANTON], [STRASSE], [SHAB_BEOBKUNDEN]) VALUES (1041, 1, N'NW', N'Wymann', N'Nadia', CAST(120.00 AS Numeric(6, 2)), 1, 0, 0, 0, N'n.wymann@hit-treuhand.ch', N'Hombrechtikon', N'8340', N'Hinwil', N'ZH', N'Birchstrasse 2', 0)
GO
SET IDENTITY_INSERT [dbo].[MITARBEITER] OFF
GO
ALTER TABLE [dbo].[GRIDSET]  WITH CHECK ADD  CONSTRAINT [FK_GRIDS_to_BENUT] FOREIGN KEY([GRIDS_USERFID])
REFERENCES [dbo].[BENUTZER] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[GRIDSET] CHECK CONSTRAINT [FK_GRIDS_to_BENUT]
GO
ALTER TABLE [dbo].[GRIDSETUP]  WITH CHECK ADD  CONSTRAINT [FK_GRIDU_to_GRIDS] FOREIGN KEY([GRIDU_GRIDSETFID])
REFERENCES [dbo].[GRIDSET] ([GRIDS_ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[GRIDSETUP] CHECK CONSTRAINT [FK_GRIDU_to_GRIDS]
GO