SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE VIEW [dbo].[TFM_fMonteurStempelzeiten]

AS

SELECT [Mandant ID]
      ,[Standort_ID]
	  ,[Monteurnr]
      ,[Monteurnr_Fil]
      ,[Datum]
      ,[Order Number]
      ,[Monteur_Gruppe_2]
      ,[Monteur_Gruppe]
      ,[Activity_Codes_Group1]
      ,[Activity_Codes_Group2]
      ,[Activity_Desc]
      ,[noch nicht verr. Std.]
      ,[prod.]
      ,[unprod.]
      ,[Abw.]
      ,[prod_unprod]
      ,[Anw.]
      ,[ben.Zeit_ohne_LG]
      ,[ben.Zeit]
      ,[Kostenstelle]
      ,[Hauptbetrieb_ID]
	  ,[Monteur_Azubi]
      ,[Extern]
      ,[GWL]
      ,[Intern]
      ,[Sollzeit]
      ,[Monteur]
      ,[Hauptbetrieb_Name]
      ,[Standort_Name]
  FROM [dbo].[TFM_fMonteurStempelzeiten95_3]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO