C11/System/ARI/SQL/schema/GC_ETL_ARI/views/load.Offene_Auftraege.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE VIEW [load].[Offene_Auftraege]
AS
SELECT [S].[Client_DB]
     , [S].[Make Code]
     , [S].[Model]
     , [S].[Hauptbetrieb]
     , [S].[Standort]
     , [S].[Serviceberater]
     , [S].[Umsatzart]
     , [S].[Kunde]
     , [S].[benutzte AW]
     , [S].[Durchgänge]
     , [S].[Tage offen]
     , [S].[gebuchte Teile]
     , [S].[Order Number]
     , [S].[Invoice Date]
     , [S].[Anz. Tage letzte Stemp.]
     , [S].[Intern/Extern]
     , [S].[Tage über Abholtermin]
     , [S].[Order Number_intern_neu]
     , [S].[Kostenstelle]
     , [S].[Fahrzeug]
     , [S].[Teile]
     , [S].[Fremdl.]
     , [S].[Umsatz Auftrag]
     , [S].[Tag_Dashboard]
     , [S].[Monat_Dashboard]
     , [S].[Jahr_Dashboard]
     , [S].[Location Code]
     , [L].[Hauptbetrieb_ID]
     , [L].[Hauptbetrieb_Name]
     , [L].[Standort_ID]
     , [L].[Standort_Name]
     , [L].[Branch ID]
FROM [transform].[Service_offene_Auftraege_neu_mit_Mont_Anzeige] [S]
         LEFT OUTER JOIN [transform_basis].[Location_Standort] [L] ON [S].[Client_DB] = [L].[Client_DB] AND [S].[Location Code] = [L].[Location Code]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO