C11/System/WERWISO/SQL/schema/ZdbSNCDatawarehouse/views/TFM_vfServiceOffeneAufträge.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE VIEW [dbo].[TFM_vfServiceOffeneAufträge]

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]
	  ,[Hauptbetrieb_ID]						AS [Hauptbetrieb_ID]
	  ,[SachbearbeiterNr]						AS [SachbearbeiterNr]
      ,[KostRechMerkMarke]						AS [KostRechMerkMarke]
      ,[Invoice Date]							AS [Invoice Date]
      --,[Vorgangspositionsnummer]				AS [Vorgangspositionsnummer]
	  ,[Model]									AS [Model]
      ,[Fahrzeug]								AS [Fahrzeug]
      ,[Umsatzart]								AS [Umsatzart]
      ,[Kunde]									AS [Kunde]
      ,[Auftragsart]							AS [Auftragsart]
      ,[Order Number]							AS [Order Number]
      ,[Order Number_Vorgang]					AS [Order Number_Vorgang]
      ,[Kostenstelle]							AS [Kostenstelle]
      ,[Tage offen]								AS [Tage offen]
      ,[verk. Std.]								AS [verk. Std.]
	  ,[verk. Std. Monteur]						AS [verk. Std. Monteur]
      ,[Rädereinl.]								AS [Rädereinl.]
      ,[Mietw.]									AS [Mietw.]
      ,[EW Fremdl.]								AS [EW Fremdl.]
      ,[Fremdl.]								AS [Fremdl.]
      ,[TÜV]									AS [TÜV]
      ,[EW Teile]								AS [EW Teile]
      ,[Teile]									AS [Teile]
      ,[Lohn]									AS [Lohn]
      ,[DG]										AS [DG]
      ,[ben. Zeit]								AS [ben. Zeit]
      ,[Tage_seit_letzter_Stemp.]				AS [Tage_seit_letzter_Stemp.]
      ,[DG_mit_Zeit]							AS [DG_mit_Zeit]
      ,[bereits ber. Zeit]						AS [bereits ber. Zeit]
      ,[nicht ber. gest. Std.]					AS [nicht ber. gest. Std.]
  FROM [fServiceOffeneAufträge]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO