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