C11/System/ARI/Models/SQL/Service_Gutschriften_ab_2011_Dashboard_gesamt.sql

CREATE
	OR

ALTER VIEW [load].[Service_Gutschriften_ab_2011]
AS
SELECT --[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],
	--[Bill-to Address] AS [Bill-to Address],
	--[Bill-to City] AS [Bill-to City],
	--[Posting Date] AS [Posting Date],
	--[Payment Terms Code] AS [Payment Terms Code],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Price Group Code] AS [Price Group Code],
	--[Prices Including Vat] AS [Prices Including Vat],
	--[Allow Quantity Disc] AS [Allow Quantity Disc],
	--[Salesperson Code] AS [Salesperson Code],
	--[On Hold] AS [On Hold],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Transaction Type] AS [Transaction Type],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	--[Sell-to Address] AS [Sell-to Address],
	--[Sell-to City] AS [Sell-to City],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[External Document No] AS [External Document No],
	--[Area] AS [Area],
	--[No Series] AS [No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	--[Service Order No_ohne_Einschränkung] AS [Service Order No_ohne_Einschränkung],
	--[Service Order No] AS [Service Order No],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model Code] AS [Model Code],
	--[Model No] AS [Model No],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[Line No] AS [Line No],
	--[Type] AS [Type],
	--[Description] AS [Description],
	--[Description 2] AS [Description 2],
	--[Quantity] AS [Quantity],
	--[Unit Price] AS [Unit Price],
	--[Unit Cost (lcy)] AS [Unit Cost (lcy)],
	--[Line Discount Amount] AS [Line Discount Amount],
	--[Amount] AS [Amount],
	--[Amount Including Vat] AS [Amount Including Vat],
	--[Inv Discount Amount] AS [Inv Discount Amount],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Unit Cost] AS [Unit Cost],
	--[Order No] AS [Order No],
	--[Order Line No] AS [Order Line No],
	--[Item Type] AS [Item Type],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[Service Order No_] AS [Service Order No_],
	--[Service Order Line No] AS [Service Order Line No],
	--[Labor No] AS [Labor No],
	--[Customer Group Code] AS [Customer Group Code],
	--[Item Group Code] AS [Item Group Code],
	--[Service Advisor No_Archiv] AS [Service Advisor No_Archiv],
	--[Service Advisor No_oA] AS [Service Advisor No_oA],
	--[No_für_Archiv] AS [No_für_Archiv],
	--[First Name_für_Archiv] AS [First Name_für_Archiv],
	--[Last Name_für_Archiv] AS [Last Name_für_Archiv],
	--[First Name] AS [First Name],
	--[Last Name] AS [Last Name],
	[Serviceberater] AS [Serviceberater],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Umsatzart] AS [Umsatzart],
	[Fabrikat] AS [Fabrikat],
	[Model] AS [Model],
	--[Fahrzeug] AS [Fahrzeug],
	--[Marke] AS [Marke],
	--[Service Posting Group_für_Archiv] AS [Service Posting Group_für_Archiv],
	--[Service Posting Group] AS [Service Posting Group],
	--[Auftragsart] AS [Auftragsart],
	--[Cust_Gr_Code] AS [Cust_Gr_Code],
	--[Cust_Gr_Description] AS [Cust_Gr_Description],
	[Kundenart] AS [Kundenart],
	--[Cust_No] AS [Cust_No],
	--[Cust_Name] AS [Cust_Name],
	[Kunde] AS [Kunde],
	--[Auftragsart_1] AS [Auftragsart_1],
	--[Function Code] AS [Function Code],
	--[Monteur] AS [Monteur_],
	[Umsatz Lohn] AS [Umsatz Lohn],
	--[Umsatz Teile Service_ori] AS [Umsatz Teile Service_ori],
	--[Umsatz Sonstiges_ori] AS [Umsatz Sonstiges_ori],
	--[Anzahl Datensätze] AS [Anzahl Datensätze],
	[Umsatz Teile Service] AS [Umsatz Teile Service],
	--[Umsatz Sonstiges] AS [Umsatz Sonstiges],
	[Einsatz Teile Service] AS [Einsatz Teile Service],
	[verk Std] AS [verk Std],
	--[ben Zeit] AS [ben Zeit],
	[Invoice Date] AS [Bookkeep Date],
	--[Order Number] AS [Order Number],
	--[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[DG1] AS [DG1],
	--[DG2] AS [DG2],
	[DG] AS [DG],
	--[Order Number_Rg_Ausg_2] AS [Order Number_Rg_Ausg_2],
	--[Order Number_Rg_Ausg_1] AS [Order Number_Rg_Ausg_1],
	--[Cust_No_Verkaufskunde] AS [Cust_No_Verkaufskunde],
	--[Cust_Name_Verkaufskunde] AS [Cust_Name_Verkaufskunde],
	--[Cust_Group_Description_Verkaufskunde] AS [Cust_Group_Description_Verkaufskunde],
	--[Kundenart_Verkaufskunde] AS [Kundenart_Verkaufskunde],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	--[Auftragsposition] AS [Auftragsposition],
	--[Rabatt Lohn] AS [Rabatt Lohn],
	--[NL Teile_ori] AS [NL Teile_ori],
	--[Rabatt Teile] AS [Rabatt Teile],
	--[Hauptbetrieb_ID] AS [Hauptbetrieb_ID],
	--[Standort_ID] AS [Standort_ID],
	--[NL Lohn %] AS [NL Lohn %],
	--[Nachlass > 90 %] AS [Nachlass > 90 %],
	--[NL Teile %] AS [NL Teile %],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	[Order_Desc_30] AS [Order_Desc_30],
	[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Model_Desc] AS [Model_Desc],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Fahrzeugalter] AS [Fahrzeugalter],
	--[FZG-Altersstaffel] AS [FZG-Altersstaffel],
	--[Repair_Group_Desc] AS [Repair_Group_Desc],
	--[Rechnung_Gutschrift] AS [Rechnung_Gutschrift],
	--[Parts_Focus_Group] AS [Parts_Focus_Group],
	--[Parts_Make_Desc] AS [Parts_Make_Desc],
	--[Parts_Group_Desc] AS [Parts_Group_Desc],
	--[Post Code] AS [Post Code],
	[PLZ_1_Stelle] AS [PLZ_1_Stelle],
	[PLZ_2_Stelle] AS [PLZ_2_Stelle],
	[PLZ_3_Stelle] AS [PLZ_3_Stelle],
	[PLZ_4_Stelle] AS [PLZ_4_Stelle],
	[PLZ] AS [PLZ],
	--[Order_Desc_100] AS [Order_Desc_100],
	--[Invoice_Desc_100] AS [Invoice_Desc_100],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	[TÜV_Amount] AS [TÜV_Amount],
	[FL_Lack_Amount] AS [FL_Lack_Amount],
	[Mietw_Amount] AS [Mietw_Amount],
	[Umsatz_Sonst_Rest] AS [Umsatz_Sonst_Rest],
	[Kunde] AS [Kunde_PLZ],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	--[Service_Order_No_Teile_Order_No] AS [Service_Order_No_Teile_Order_No],
	--[Code_Salesperson] AS [Code_Salesperson],
	--[Name_Salesperson] AS [Name_Salesperson],
	--[Serviceberater_Service] AS [Serviceberater_Service],
	--[Tage bis Rechnung] AS [Tage bis Rechnung],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	[Auftragsart Service/Teile] AS [Auftragsart Service/Teile],
	[Bereich Umsatz] AS [Bereich Umsatz] 
FROM [export_csv].[Service_Gutschriften_ab_2011]
GO