CREATE TABLE [optima].[Monteur_neu_Zeiterf_neu] (
   [Unique Ident] [varchar](100) NULL,
   [Activity Code] [varchar](100) NULL,
   [Profile Code] [varchar](100) NULL,
   [Handler] [varchar](100) NULL,
   [Function Code] [varchar](100) NULL,
   [Program] [varchar](100) NULL,
   [Transact Date Long] [datetime] NULL,
   [Start Punch Function] [varchar](100) NULL,
   [Start Punch Program] [varchar](100) NULL,
   [End Punch Function] [varchar](100) NULL,
   [End Punch Program] [varchar](100) NULL,
   [Done For Department] [varchar](100) NULL,
   [Done For Work Leader] [varchar](100) NULL,
   [Ended Punch] [varchar](100) NULL,
   [Order Number] [varchar](100) NULL,
   [Line Number] [varchar](100) NULL,
   [Start Date Time] [datetime] NULL,
   [End Date Time] [datetime] NULL,
   [Tmcs Idle Punch] [varchar](100) NULL,
   [Duration Int] [decimal](28,8) NULL,
   [Used Time Int] [decimal](28,8) NULL,
   [Wage Extracted] [varchar](100) NULL,
   [Punch Remark Code] [varchar](100) NULL,
   [Remark Accepted] [varchar](100) NULL,
   [Punch Period Start Id] [varchar](100) NULL,
   [Conv Flag] [varchar](100) NULL,
   [Seller Code] [varchar](100) NULL,
   [Sel Name] [varchar](100) NULL,
   [Sel Department] [varchar](100) NULL,
   [Sel First Name] [varchar](100) NULL,
   [Sel Family Name] [varchar](100) NULL,
   [Work Leader Group] [varchar](100) NULL,
   [Workleader Text] [varchar](100) NULL,
   [Activity Code_Activity] [varchar](100) NULL,
   [Activity Description] [varchar](100) NULL,
   [Present_Activity] [varchar](100) NULL,
   [Anwesenheit] [decimal](28,8) NULL,
   [Nacharbeit] [decimal](28,8) NULL,
   [Leerlauf Wartezeit] [decimal](28,8) NULL,
   [Prob fahrt Endkontr ] [decimal](28,8) NULL,
   [Instandhltg  Werkstatt] [decimal](28,8) NULL,
   [Unprod  Anwes ] [decimal](28,8) NULL,
   [FZG-Aufbereitung] [decimal](28,8) NULL,
   [Schulung intern] [decimal](28,8) NULL,
   [Schulung extern] [decimal](28,8) NULL,
   [Betriebsversammlung] [decimal](28,8) NULL,
   [Krank] [decimal](28,8) NULL,
   [Arzt] [decimal](28,8) NULL,
   [Urlaub] [decimal](28,8) NULL,
   [Sonderurlaub] [decimal](28,8) NULL,
   [Feiertag] [decimal](28,8) NULL,
   [zu spät] [decimal](28,8) NULL,
   [Überstunden] [decimal](28,8) NULL,
   [Order Number_Auftrag] [varchar](100) NULL,
   [Customer Group] [varchar](100) NULL,
   [Umsatzart] [varchar](100) NULL,
   [Extern] [decimal](28,8) NULL,
   [GWL] [decimal](28,8) NULL,
   [Intern] [decimal](28,8) NULL,
   [produktiv] [decimal](28,8) NULL,
   [Summe  (produktiv) Nr 1] [decimal](28,8) NULL,
   [unproduktiv] [decimal](28,8) NULL,
   [Summe  (unproduktiv) Nr 1] [decimal](28,8) NULL,
   [abwesend] [decimal](28,8) NULL,
   [Monteur_Gruppe_ori] [varchar](100) NULL,
   [Datum] [datetime] NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Department Type Id] [varchar](100) NULL,
   [Description] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [Kostenstelle] [varchar](100) NULL,
   [Monteur_ori] [varchar](100) NULL,
   [Abschleppen] [varchar](100) NULL,
   [Berufsschule] [varchar](100) NULL,
   [Instandhltg  Gebäude] [varchar](100) NULL,
   [Work Leader Group Id] [varchar](100) NULL,
   [Fahrten für KDD] [varchar](100) NULL,
   [MW tanken] [varchar](100) NULL,
   [Arbeiten Anlage B] [varchar](100) NULL,
   [Aushilfe Annahme] [varchar](100) NULL,
   [Abzug T390] [varchar](100) NULL,
   [Monteur_Gruppe] [varchar](100) NULL,
   [Monteur] [varchar](100) NULL,
   [Aushilfe GW] [varchar](100) NULL
)


GO