CREATE TABLE [optima].[Schichtplan_pro_MA_neu] (
   [Reference Ident] [varchar](100) NULL,
   [Reference Name] [varchar](100) NULL,
   [Calendar Type Id] [varchar](100) NULL,
   [Transact Date] [datetime] NULL,
   [Calendar Info Id] [varchar](100) NULL,
   [Calendar Type Id2] [varchar](100) NULL,
   [Recurring Pattern Id] [varchar](100) NULL,
   [Recurring Pattern Priority] [varchar](100) NULL,
   [Transact Date2] [datetime] NULL,
   [Name] [varchar](100) NULL,
   [Pattern_rechts_3] [varchar](100) NULL,
   [Std_Tag] [varchar](100) NULL,
   [Work Leader Group] [varchar](100) NULL,
   [Workleader Text] [varchar](100) NULL,
   [Monteur_Gruppe] [varchar](100) NULL,
   [Calendar Event Name] [varchar](100) NULL,
   [Event Start] [datetime] NULL,
   [Event End] [datetime] NULL,
   [Occurrence] [varchar](100) NULL,
   [All Day Event] [varchar](100) NULL,
   [Recurring Pattern Id2] [varchar](100) NULL,
   [Activity Id] [varchar](100) NULL,
   [Calendar Info Id2] [varchar](100) NULL,
   [Calendar Type Id3] [varchar](100) NULL,
   [Recurring Type Id] [varchar](100) NULL,
   [Holiday Id] [varchar](100) NULL,
   [Wochentag] [varchar](100) NULL,
   [Monteur_ori] [varchar](100) NULL,
   [Datum] [datetime] NULL,
   [Pers Department] [varchar](100) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [Profile Code] [varchar](100) NULL,
   [Kostenstelle] [varchar](100) NULL,
   [Feiertag] [varchar](100) NULL,
   [Order Number] [varchar](100) NULL,
   [Work Leader Group Id] [varchar](100) NULL,
   [Job End Date] [datetime] NULL,
   [abwesend] [varchar](100) NULL,
   [Recurring Pattern Id_aus_Workin_Period] [varchar](100) NULL,
   [Core Working Hours] [varchar](100) NULL,
   [Workingday] [varchar](100) NULL,
   [Start Day Id] [varchar](100) NULL,
   [Monteur] [varchar](100) NULL
)


GO