gctools/cognos7/data/mdl/S_Offene_Auftraege_queries.sql

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose_operativ]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Invoice Date] AS [Order Date],
	--[Wochentage Id] AS [Wochentage Id],
	--[Arbeitstag Mofr] AS [Arbeitstag Mofr],
	--[Zaehler Mofr] AS [Zaehler Mofr],
	--[Summe Mofr] AS [Summe Mofr],
	--[Arbeitstag Mosa] AS [Arbeitstag Mosa],
	--[Zaehler Mosa] AS [Zaehler Mosa],
	--[Summe Mosa] AS [Summe Mosa],
	--[Feiertage Id] AS [Feiertage Id],
	--[Jahr] AS [Jahr],
	--[Arbeitstag Nr Jahr] AS [Arbeitstag Nr Jahr],
	--[Gesamt Arbeitstage] AS [Gesamt Arbeitstage] 
FROM [export_csv].[current_date_Prognose_operativ]
GO

CREATE
	OR

ALTER VIEW [load].[Offene_Auftraege]
AS
SELECT [Hauptbetrieb_ID] AS [Hauptbetrieb_ID],
	[Hauptbetrieb_Name] AS [Hauptbetrieb_Name],
	[Standort_ID] AS [Standort_ID],
	[Standort_Name] AS [Standort_Name],
	[Serviceberater] AS [Serviceberater],
	[Order Number] AS [Order Number],
	[Fabrikat] AS [Fabrikat],
	[Model] AS [Model],
	[Fahrzeug] AS [Fahrzeug],
	[Kostenstelle] AS [Kostenstelle],
	--[Marke] AS [Marke],
	[Kunde] AS [Kunde],
	--[Turnover_Type_Desc] AS [Turnover_Type_Desc],
	[Tage offen] AS [Tage offen],
	[DG] AS [DG],
	[Lohn] AS [Lohn],
	[Teile] AS [Teile],
	[Sonst.] AS [Sonst.],
	[Auftragsart] AS [Auftragsart],
	[Order Date] AS [Order Date],
	[Tage seit letzt. Stemp.] AS [Tage seit letzt. Stemp.] 
FROM [export_csv].[Offene_Auftraege]
GO