CREATE
	OR

ALTER VIEW [load].[current_date_Prognose~1]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Invoice 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~1]
GO

CREATE
	OR

ALTER VIEW [load].[Service_offene_Auftraege_neu_mitMont_Anzeige]
AS
SELECT --[Document Type] AS [Document Type],
	--[No] AS [No],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Bill-to Customer No] AS [Bill-to Customer No],
	--[Bill-to Name] AS [Bill-to Name],
	--[Order Date] AS [Order Date],
	--[Posting Date] AS [Posting Date],
	--[Posting Description] AS [Posting Description],
	--[Due Date] AS [Due Date],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	[Make Code] AS [Make Code],
	--[Salesperson Code] AS [Salesperson Code],
	--[On Hold] AS [On Hold],
	--[Transaction Type] AS [Transaction Type],
	--[Transport Method] AS [Transport Method],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[Area] AS [Area],
	--[Reserve] AS [Reserve],
	--[Option Code] AS [Option Code],
	--[Service Posting Group] AS [Service Posting Group],
	--[Vin] AS [Vin],
	--[Model Code] AS [Model Code],
	--[Model No] AS [Model No],
	[Model] AS [Model],
	--[Type] AS [Type],
	--[Initial Registration] AS [Initial Registration],
	--[Order Limit] AS [Order Limit],
	--[Time Of Order] AS [Time Of Order],
	--[Pickup Date] AS [Pickup Date],
	--[Pickup Time] AS [Pickup Time],
	--[Completion Date] AS [Completion Date],
	--[Completion Time] AS [Completion Time],
	--[Labor Type] AS [Labor Type],
	--[Labor Charging Code] AS [Labor Charging Code],
	--[Book No] AS [Book No],
	--[Branch Book No] AS [Branch Book No],
	--[Sales Department Code] AS [Sales Department Code],
	--[Fixed Date] AS [Fixed Date],
	--[Fixed Instruction] AS [Fixed Instruction],
	--[Current Instruction Type] AS [Current Instruction Type],
	--[Work Completed] AS [Work Completed],
	--[Status Code] AS [Status Code],
	--[Service Advisor No] AS [Service Advisor No],
	[Hauptbetrieb] AS [Hauptbetrieb],
	--[Standort_Department] AS [Standort_Department],
	[Standort] AS [Standort],
	--[No_Employee] AS [No_Employee],
	--[First Name_Employee] AS [First Name_Employee],
	--[Last Name_Employee] AS [Last Name_Employee],
	[Serviceberater] AS [Serviceberater],
	--[Umsatzart] AS [Umsatzart],
	[Kunde] AS [Kunde],
	--[Order Number_mit Monteur] AS [Order Number_mit Monteur],
	--[Entry No] AS [Entry No],
	--[Order No] AS [Order No],
	--[Document No] AS [Document No],
	--[Description] AS [Description],
	--[Quantity] AS [Quantity],
	--[Direct Unit Cost] AS [Direct Unit Cost],
	--[Unit Cost] AS [Unit Cost],
	--[Total Cost] AS [Total Cost],
	--[Unit Price] AS [Unit Price],
	--[Total Price] AS [Total Price],
	--[Work Type Code] AS [Work Type Code],
	--[User Id] AS [User Id],
	--[Amt To Post To G L] AS [Amt To Post To G L],
	--[Amt Posted To G L] AS [Amt Posted To G L],
	--[Amt To Recognize] AS [Amt To Recognize],
	--[Amt Recognized] AS [Amt Recognized],
	--[Entry Type] AS [Entry Type],
	--[Positive] AS [Positive],
	--[Qty Evaluated] AS [Qty Evaluated],
	--[Corrected] AS [Corrected],
	--[Variant Code] AS [Variant Code],
	--[Qty Per Unit Of Measure] AS [Qty Per Unit Of Measure],
	--[Quantity (base)] AS [Quantity (base)],
	--[Time Type] AS [Time Type],
	--[Service Job No] AS [Service Job No],
	--[Assoc Entry] AS [Assoc Entry],
	--[Closed] AS [Closed],
	--[Qty Per Hour] AS [Qty Per Hour],
	--[Qty (hour)] AS [Qty (hour)],
	--[Item Group Code] AS [Item Group Code],
	--[Customer Group Code] AS [Customer Group Code],
	--[Charging Group No] AS [Charging Group No],
	--[Standard Time] AS [Standard Time],
	--[Standard Time Type] AS [Standard Time Type],
	--[Source Type] AS [Source Type],
	--[Main Customer] AS [Main Customer],
	--[Order Line No] AS [Order Line No],
	--[Time From] AS [Time From],
	--[Time Until] AS [Time Until],
	--[Internal Charged] AS [Internal Charged],
	--[Order Completed] AS [Order Completed],
	--[Open] AS [Open],
	--[Closed By Entry No] AS [Closed By Entry No],
	--[Closed At Date] AS [Closed At Date],
	--[Closed By Quantity] AS [Closed By Quantity],
	--[Open Quantity] AS [Open Quantity],
	--[Labor Standard Time Type] AS [Labor Standard Time Type],
	--[Menge] AS [Menge],
	--[Einstandsbetrag] AS [Einstandsbetrag],
	--[Verkaufsbetrag] AS [Verkaufsbetrag],
	--[Umsatz Lohn] AS [Umsatz Lohn],
	--[Umsatz Teile Service] AS [Umsatz Teile Service],
	--[Umsatz Sonstiges] AS [Umsatz Sonstiges],
	--[Einsatz Teile Service] AS [Einsatz Teile Service],
	--[Einsatz Sonstiges] AS [Einsatz Sonstiges],
	--[Menge pro Stunde] AS [Menge pro Stunde],
	--[verk.Stunden] AS [verk.Stunden],
	--[verk. AW] AS [verk. AW],
	--[benutzte Zeit] AS [benutzte Zeit],
	[benutzte AW] AS [benutzte AW],
	--[Name_Employee] AS [Name_Employee],
	--[Function Code] AS [Function Code],
	--[Monteur] AS [Monteur],
	--[Funktion Monteur] AS [Funktion Monteur],
	--[ben. AW ohne AZUBI] AS [ben. AW ohne AZUBI],
	--[Auftragsdatum] AS [Auftragsdatum],
	--[DG_1] AS [DG_1],
	--[DG_2] AS [DG_2],
	[Durchgänge] AS [Durchgänge],
	--[Anzahl_Tage] AS [Anzahl_Tage],
	[Tage offen] AS [Tage offen],
	[gebuchte Teile] AS [gebuchte Teile],
	--[Monteur_Anzeige] AS [Monteur_Anzeige],
	--[Serviceberater_Monteur] AS [Serviceberater_Monteur],
	[Order Number] AS [Order Number],
	[Invoice Date] AS [Invoice Date],
	--[Minimum Letzte Stempelung] AS [Minimum Letzte Stempelung],
	--[Tage letzte Stemp. bereinigt] AS [Tage letzte Stemp. bereinigt],
	[Anz. Tage letzte Stemp.] AS [Anz. Tage letzte Stemp.],
	--[Order Number_intern] AS [Order Number_intern],
	--[Anzahl Tage über Abholtermin] AS [Anzahl Tage über Abholtermin],
	[Intern/Extern] AS [Intern/Extern],
	[Tage über Abholtermin] AS [Tage über Abholtermin],
	--[Kundenname_verkauft_an] AS [Kundenname_verkauft_an],
	--[Bill-to Contact] AS [Bill-to Contact],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	[Order Number_intern_neu] AS [Order Number_intern_neu],
	--[Anzahl Tage_ori] AS [Anzahl Tage_ori],
	--[Durchgänge (Auftrag)] AS [Durchgänge (Auftrag)],
	--[Anzahl Tage] AS [Anzahl Tage],
	[Kostenstelle] AS [Kostenstelle],
	[Fahrzeug] AS [Fahrzeug],
	[Teile] AS [Teile],
	--[Arbeitswerte] AS [Arbeitswerte],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	[Fremdl.] AS [Fremdl.],
	--[Summe Amount_Order_Line_VK] AS [Summe Amount_Order_Line_VK],
	[Umsatz Auftrag] AS [Umsatz Auftrag] 
FROM [export_csv].[Service_offene_Auftraege_neu_mitMont_Anzeige]
GO