C11/System/CARLO/SQL/schema/GC/tables/carlo.Zeit_2_C11.sql

CREATE TABLE [carlo].[Zeit_2_C11] (
   [Employee No] [varchar](100) NULL,
   [Datum] [datetime] NULL,
   [Department No] [varchar](100) NULL,
   [Time Account No] [varchar](100) NULL,
   [Time Account Value] [decimal](28,8) NULL,
   [No] [varchar](100) NULL,
   [Description] [varchar](100) NULL,
   [Description 2] [varchar](100) NULL,
   [Zeitdauer] [decimal](28,8) NULL,
   [Summe  (Zeitdauer) Nr 1] [decimal](28,8) NULL,
   [gesamt Stunden] [decimal](28,8) NULL,
   [Summe  (gesamt Stunden) Nr 3] [decimal](28,8) NULL,
   [Summe  (gesamt Stunden) Nr 2] [decimal](28,8) NULL,
   [Summe  (gesamt Stunden) Nr 1] [decimal](28,8) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [First Name] [varchar](100) NULL,
   [Last Name] [varchar](100) NULL,
   [Monteur_Gruppe_ori_alt] [varchar](100) NULL,
   [Abteilung] [varchar](100) NULL,
   [Monteur] [varchar](100) NULL,
   [Leaving Date] [datetime] NULL,
   [Group No 1] [varchar](100) NULL,
   [Group No 2] [varchar](100) NULL,
   [Group No 3] [varchar](100) NULL,
   [Tage Heute Leaving Date] [varchar](100) NULL,
   [Monteur_Gruppe] [varchar](100) NULL,
   [produktiv unproduktiv] [varchar](100) NULL,
   [Monatserster] [datetime] NULL,
   [Monatsletzter] [datetime] NULL,
   [Heute] [datetime] NULL,
   [Datum Tagesbericht] [datetime] NULL,
   [Employment Date] [datetime] NULL,
   [Kostenstelle] [varchar](100) NULL,
   [Filialcode_Employee] [varchar](100) NULL,
   [Kostenstellencode_Employee] [varchar](100) NULL,
   [Name_Kostenstelle] [varchar](100) NULL,
   [Betrieb] [varchar](100) NULL,
   [Monteur_Gruppe_2] [varchar](100) NULL,
   [Arbeitsvertragscode] [varchar](100) NULL,
   [Task Type Group] [varchar](100) NULL,
   [Monteur_Gruppe_ori] [varchar](100) NULL,
   [Kontrolle] [decimal](28,8) NULL,
   [Date] [varchar](100) NULL,
   [Company_ID] [varchar](100) NULL,
   [Department_ID] [varchar](100) NULL,
   [Mechanic_Group2] [varchar](100) NULL,
   [Mechanic] [varchar](100) NULL,
   [Mechanic_Productive] [varchar](100) NULL,
   [Mechanic_Group1] [varchar](100) NULL,
   [Order Number] [varchar](100) NULL,
   [Activity_Codes_Group1] [varchar](100) NULL,
   [Activity_Codes_Group2_ori] [varchar](100) NULL,
   [Activity_Codes_Group2] [varchar](100) NULL,
   [Activity_Desc] [varchar](100) NULL,
   [Mechanic_Trainee] [varchar](100) NULL,
   [produktiv] [varchar](100) NULL,
   [unproduktiv] [varchar](100) NULL,
   [abwesend] [decimal](28,8) NULL,
   [Filialcode_Employee2] [varchar](100) NULL
)


GO