C11/System/WERWISO/SQL/schema/ZdbSNCDatawarehouse/views/TFM_vfStempelzeiten.sql

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

AS

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

SELECT [Mandant ID] 
      ,[Standort_ID]						AS [Standort_ID]					
      ,[Invoice Date]						AS [Invoice Date]				
      --,[Order Number]						AS [Order Number]				
      --,[Abwesenheitsart]					AS [Abwesenheitsart]			
      --,[Activity_Codes_Group_1]				AS [Activity_Codes_Group_1]		
      --,[Activity_Codes_Group2]				AS [Activity_Codes_Group2]		
      --,[Activity_Desc]						AS [Activity_Desc]				
      --,[prod.]								AS [prod.]						
      --,[unprod.]							AS [unprod.]					
      ,[Anwesenheit Mech Karo Lack]			AS [Anwesenheit Mech Karo Lack]	
      --,[Abw.]								AS [Abw.]						
      --,[Kostenstelle]						AS [Kostenstelle]				
      ,[Hauptbetrieb_ID]					AS [Hauptbetrieb_ID]			
      --,[Extern]								AS [Extern]						
      --,[GWL]								AS [GWL]						
      --,[Intern]								AS [Intern]						
      --,[Sollzeit]							AS [Sollzeit]					
      ,[Anwesenheit Meister]				AS [Anwesenheit Meister]		
      --,[Monteur Azubi]						AS [Monteur Azubi]	
	  ,[MonteurNr]							AS [MonteurNr]			
  FROM [fStempelzeiten]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO