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

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

AS

SELECT [Mandant ID]						AS [Mandant ID]				
      ,[Standort_ID]					AS [Standort_ID]			
      ,[Model]							AS [Model]					
      ,[Farbe]							AS [Farbe]					
      ,[Name_Lieferant]					AS [Name_Lieferant]			
      ,[Lieferant/Einkäufer]			AS [Lieferant/Einkäufer]	
      ,[EZ]								AS [EZ]						
      ,[Km-Stand]						AS [Km-Stand]				
      ,[Fahrzeugart]					AS [Fahrzeugart]			
      ,[Fahrzeugtyp]					AS [Fahrzeugtyp]			
      ,[Standtage]						AS [Standtage]				
      ,[Bestand/Vorlauf]				AS [Bestand/Vorlauf]		
      ,[Bestand / verk. Bestand]		AS [Bestand / verk. Bestand]
      ,[FZG]							AS [FZG]					
      ,[Modell_Beschreibung]			AS [Modell_Beschreibung]	
      ,[Standtagestaffel]				AS [Standtagestaffel]		
	  ,[Fabrikat_ori]					AS [Fabrikat_ori]
      ,[Einsatz]						AS [Einsatz]				
      ,[geplanter_VK]					AS [geplanter_VK]			
      ,[Menge]							AS [Menge]					
      ,[int. Aufw.]						AS [int. Aufw.]				
      ,[Fahrzeugtyp_1]					AS [Fahrzeugtyp_1]			
      ,[Name_Einkäufer]					AS [Name_Einkäufer]			
      ,[FZG_Einkäufer]					AS [FZG_Einkäufer]			
      ,[Hauptbetrieb_ID]				AS [Hauptbetrieb_ID]		
      ,[Invoice Date]					AS [Invoice Date]			
  FROM [fFahrzeugbestand]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO