ETL_DWH_ARI/schema/GC_DWH_ARI/tables/Zeit_gesamt_DWH.sql

CREATE TABLE [dbo].[Zeit_gesamt_DWH] (
   [Client_DB] [varchar](20) NULL,
   [No] [varchar](20) NULL,
   [Document No] [varchar](20) NULL,
   [Zeitdauer] [decimal](28,8) NULL,
   [Stempel-Code] [varchar](20) NULL,
   [Monteur] [varchar](100) NULL,
   [Datum] [datetime] NULL,
   [Department No] [varchar](20) NULL,
   [Order Number] [varchar](100) NULL,
   [Employment Date] [datetime] NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Activity_Codes_Group1] [varchar](50) NULL,
   [Activity_Codes_Group2] [varchar](50) NULL,
   [Activity_Desc] [varchar](50) NULL,
   [First Name] [varchar](100) NULL,
   [Last Name] [varchar](100) NULL,
   [Task Type Group] [varchar](20) NULL,
   [Function Code] [varchar](20) NULL,
   [Group No_ 1] [varchar](20) NULL,
   [Group No_ 2] [varchar](20) NULL,
   [Group No_ 3] [varchar](20) NULL,
   [Monteur_Gruppe] [varchar](50) NULL,
   [Monteur_Gruppe_2] [varchar](50) NULL,
   [prod.] [decimal](28,8) NULL,
   [unprod.] [decimal](28,8) NULL,
   [Abw.] [decimal](28,8) NULL,
   [Extern] [decimal](28,8) NULL,
   [Intern] [decimal](28,8) NULL,
   [fakt. Std.] [decimal](28,8) NULL,
   [Umsatz Lohn] [decimal](28,8) NULL,
   [Nachlass] [decimal](28,8) NULL,
   [ben. Std.] [decimal](28,8) NULL,
   [Sollzeit] [decimal](28,8) NULL,
   [Source Table] [varchar](50) NULL
)


GO