gctools/data/S_Offene_Auftraege_queries.txt

CREATE 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 [staging].[current_date_Prognose_operativ_fm]
GO

CREATE 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 [staging].[Offene_Auftraege_fm]
GO