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

AS

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


SELECT [Mandant ID]					AS [Mandant ID]				
      --,[Faktenart_ID]				AS [Faktenart_ID]			
      --,[Faktenart_Name]				AS [Faktenart_Name]			
      ,[Vorgangsnummer]				AS [Vorgangsnummer]			
      ,[Invoice Date]				AS [Invoice Date]			
      ,[Datum]						AS [Datum]					
      ,[RechArt]					AS [RechArt]				
      ,[SplitNr]					AS [SplitNr]
	  ,[Order Number]				AS [Order Number]		
      ,[Filial_ID]					AS [Filial_ID]				
      ,[MonteurID1]					AS [MonteurID1]				
      ,[MonteurID2]					AS [MonteurID2]				
      ,[MonteurID3]					AS [MonteurID3]				
      ,[MonteurID4]					AS [MonteurID4]				
      ,[MonteurID5]					AS [MonteurID5]				
	  ,[Monteurnr]					AS [Monteurnr]
	  ,[Monteurnr_Fil]				AS [Monteurnr_Fil]
      ,[Positionskennzeichen]		AS [Positionskennzeichen]	
      ,[Positionsnummer]			AS [Positionsnummer]		
      ,[RE_Prozent]					AS [RE_Prozent]				
      ,[Mengemonteurid1]			AS [Mengemonteurid1]		
      ,[Mengemonteurid2]			AS [Mengemonteurid2]		
      ,[Mengemonteurid3]			AS [Mengemonteurid3]		
      ,[Mengemonteurid4]			AS [Mengemonteurid4]		
      ,[Mengemonteurid5]			AS [Mengemonteurid5]		
      ,[verr. Zeit]					AS [verr. Zeit]				
  FROM [ZdbSNCStaging].[WERWISO].[fMonteurRechnungsausgangsbuch]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO
