123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182 |
- 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
|