ETL_DWH_ARI/schema/GC_DWH_ARI/tables/Time_Clock_Entry.sql

CREATE TABLE [dbo].[Time_Clock_Entry] (
   [Client_DB] [varchar](20) NULL,
   [Monteur] [varchar](50) NULL,
   [Monteur_Gruppe_2] [varchar](20) NULL,
   [Datum] [datetime] NULL,
   [Bookkeep Date] [datetime] NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [produktiv] [decimal](28,8) NULL,
   [unproduktiv] [decimal](28,8) NULL,
   [abwesend] [varchar](20) NULL,
   [Activity_Desc] [varchar](100) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Monteur_Gruppe] [varchar](50) NULL,
   [Department No] [varchar](20) NULL,
   [Order Number] [varchar](20) NULL,
   [Task Type Group] [varchar](20) NULL,
   [Extern] [decimal](28,8) NULL,
   [Intern] [varchar](20) NULL,
   [Home Page 2] [varchar](20) NULL,
   [Employment Date] [varchar](20) NULL,
   [Standort_Monteur] [varchar](2) NULL
)


GO