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

AS

/* Hier findet das Mapping der Spalten zwischen DWH und Transformer statt, der historisch bedingt ist. */

SELECT [Mandant ID]						AS [Mandant ID]				
      ,[Standort_ID]					AS [Standort_ID]			
      --,[Faktenart_ID]					AS [Faktenart_ID]			
      --,[Faktenart_Name]					AS [Faktenart_Name]	
	  ,[Monteurnr]						AS [Monteurnr]		
      ,[Monteurnr_Fil]					AS [Monteurnr_Fil]			
      ,[Datum]							AS [Datum]					
      ,[Order Number]					AS [Order Number]			
      ,[Monteur_Gruppe_2]				AS [Monteur_Gruppe_2]		
      ,[Monteur_Gruppe]					AS [Monteur_Gruppe]			
      ,[Activity_Codes_Group1]			AS [Activity_Codes_Group1]	
      ,[Activity_Codes_Group2]			AS [Activity_Codes_Group2]	
      ,[Activity_Desc]					AS [Activity_Desc]			
      ,[noch nicht verr. Std.]			AS [noch nicht verr. Std.]	
      ,[prod.]							AS [prod.]					
      ,[unprod.]						AS [unprod.]				
      ,[Abw.]							AS [Abw.]					
      ,[prod_unprod]					AS [prod_unprod]			
      ,[Anw.]							AS [Anw.]					
      ,[ben.Zeit_ohne_LG]				AS [ben.Zeit_ohne_LG]		
      ,[ben.Zeit]						AS [ben.Zeit]				
      ,[Kostenstelle]					AS [Kostenstelle]			
      ,[Hauptbetrieb_ID]				AS [Hauptbetrieb_ID]	
	  ,[Monteur_Azubi]					AS [Monteur_Azubi]	
      ,[Extern]							AS [Extern]					
      ,[GWL]							AS [GWL]					
      ,[Intern]							AS [Intern]					
      ,[Sollzeit]						AS [Sollzeit]				
  FROM [ZdbSNCStaging].[WERWISO].[fMonteurStempelzeiten]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO
