C11/System/WERWISO/SQL/schema/ZdbSNCDatawarehouse/tables/fMonteurStempelzeiten.sql

CREATE TABLE [dbo].[fMonteurStempelzeiten] (
   [Mandant ID] [varchar](3) NULL,
   [Standort_ID] [varchar](150) NULL,
   [Faktenart_ID] [varchar](150) NULL,
   [Faktenart_Name] [varchar](150) NULL,
   [Monteurnr] [varchar](150) NULL,
   [Monteurnr_Fil] [varchar](150) NULL,
   [Datum] [varchar](150) NULL,
   [Order Number] [varchar](150) NULL,
   [Monteur_Gruppe_2] [varchar](150) NULL,
   [Monteur_Gruppe] [varchar](150) NULL,
   [Activity_Codes_Group1] [varchar](150) NULL,
   [Activity_Codes_Group2] [varchar](150) NULL,
   [Activity_Desc] [varchar](150) NULL,
   [noch nicht verr. Std.] [numeric](18,5) NULL,
   [prod.] [numeric](18,5) NULL,
   [unprod.] [numeric](18,5) NULL,
   [Abw.] [numeric](18,5) NULL,
   [prod_unprod] [numeric](18,5) NULL,
   [Anw.] [numeric](18,5) NULL,
   [ben.Zeit_ohne_LG] [numeric](18,5) NULL,
   [ben.Zeit] [numeric](18,5) NULL,
   [Kostenstelle] [varchar](150) NULL,
   [Hauptbetrieb_ID] [varchar](150) NULL,
   [Monteur_Azubi] [varchar](150) NULL,
   [Extern] [numeric](18,5) NULL,
   [GWL] [numeric](18,5) NULL,
   [Intern] [numeric](18,5) NULL,
   [Sollzeit] [numeric](18,5) NULL
)


GO