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

AS

SELECT [Mandant ID]					AS [Mandant ID]			
      ,[Standort_ID]				AS [Standort_ID]		
      ,[Invoice Date]				AS [Invoice Date]		
      ,[Plz]						AS [Plz]				
      ,[Kundengruppe]				AS [Kundengruppe]		
      ,[Verkaeufer]					AS [Verkaeufer]			
      ,[Fahrzeugtyp_1]				AS [Fahrzeugtyp_1]		
      ,[Modell_Beschreibung]		AS [Modell_Beschreibung]
      ,[Standort_Name]				AS [Standort_Name]		
      ,[Kunde]						AS [Kunde]				
      ,[Buch_Text]					AS [Buch_Text]			
      ,[Konto]						AS [Konto]				
      ,[Verkäufer]					AS [Verkäufer]			
      ,[Fahrzeugtyp]				AS [Fahrzeugtyp]		
      ,[Fahrzeugart]				AS [Fahrzeugart]		
      ,[DB1 < 0]					AS [DB1 < 0]			
      ,[Fabrikat_ori]				AS [Fabrikat_ori]			
      ,[Model]						AS [Model]				
      ,[FZG]						AS [FZG]				
      ,[FZG-Detail]					AS [FZG-Detail]			
      ,[Standtage]					AS [Standtage]			
      ,[Erlös FZG]					AS [Erlös FZG]			
      ,[Nachlass]					AS [Nachlass]			
      ,[Menge]						AS [Menge]				
      ,[Boni]						AS [Boni]				
      ,[Einsatz_FZG]				AS [Einsatz_FZG]		
      ,[Hauptbetrieb_ID]			AS [Hauptbetrieb_ID]	
      ,[Name_Lieferant]				AS [Name_Lieferant]		
      ,[Name_Einkäufer]				AS [Name_Einkäufer]		
  FROM [fVerkaufsauftrag]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO
