C11/System/ARI/Models/mdl/S_Aftersales_queries.sql

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose_VJ]
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_VJ]
GO

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
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]
GO

CREATE
	OR

ALTER VIEW [load].[Zuordnung_Produktbuchungsgruppe]
AS
SELECT --[Client_DB] AS [Client_DB],
	[Produktbuchungsgruppe] AS [Gen Prod Posting Group],
	[Zuordnung] AS [Zuordnung],
	--[Beschreibung] AS [Beschreibung] 
FROM [export_csv].[Zuordnung_Produktbuchungsgruppe]
GO

CREATE
	OR

ALTER VIEW [load].[service_ausgangsrechnung_ab_2011_sle_ims_ohne_sle]
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],
	--[Order Date] AS [Order Date],
	--[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],
	--[Order No] AS [Order No],
	--[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],
	--[Shipping Agent Code] AS [Shipping Agent Code],
	--[No Series] AS [No Series],
	--[Order No Series] AS [Order No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	--[Service Order No_alt] AS [Service Order No_alt],
	[Service Order No] AS [Service Order No],
	--[Customer Group Code] AS [Customer Group Code],
	--[Service Order Line No] AS [Service Order Line No],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[Line No] AS [Line No],
	--[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 Line No] AS [Order Line No],
	--[Item Type] AS [Item Type],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[Labor No] AS [Labor No],
	--[Item Group Code] AS [Item Group Code],
	--[Service Advisor No_Archiv] AS [Service Advisor No_Archiv],
	--[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],
	[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],
	[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],
	--[Actual Time] AS [Actual Time],
	--[benutzte AW] AS [benutzte AW],
	[Invoice Date] AS [Invoice Date],
	[Order Number] AS [Order Number],
	[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[DG1] AS [DG1],
	--[DG2] AS [DG2],
	--[Order Number_Rg_Ausg_2] AS [Order Number_Rg_Ausg_2],
	--[Order Number_Rg_Ausg_1] AS [Order Number_Rg_Ausg_1],
	[verk Std] AS [verk Std],
	--[Charging Group No] AS [Charging Group No],
	--[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],
	[DG] AS [DG],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	[Auftragsposition] AS [Auftragsposition],
	[SB_Gruppe] AS [SB_Gruppe],
	--[ben  Zeit] AS [ben  Zeit],
	--[NL Teile_ori] AS [NL Teile_ori],
	[Rabatt Lohn] AS [Rabatt Lohn],
	[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],
	[Order_Desc_100] AS [Order_Desc_100],
	[Invoice_Desc_100] AS [Invoice_Desc_100],
	--[Model_Desc] AS [Model_Desc],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Repair_Group_Desc] AS [Repair_Group_Desc],
	--[DB1_><_EK] AS [DB1_><_EK],
	--[Rechnung_Gutschrift] AS [Rechnung_Gutschrift],
	--[Parts_Group_Desc] AS [Parts_Group_Desc],
	--[Parts_Make_Desc] AS [Parts_Make_Desc],
	--[Parts_Focus_Group] AS [Parts_Focus_Group],
	--[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],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	[TÜV_Amount] AS [TÜV_Amount],
	--[Code_Salesperson] AS [Code_Salesperson],
	--[Name_Salesperson] AS [Name_Salesperson],
	--[gepl. AW-Satz] AS [gepl. AW-Satz],
	--[Umsatz Lohn Plan] AS [Umsatz Lohn Plan],
	--[Tage bis Rechnung_ori] AS [Tage bis Rechnung_ori],
	--[Tage bis Rechnung] AS [Tage bis Rechnung],
	[FL_Lack_Amount] AS [FL_Lack_Amount],
	[Mietw_Amount] AS [Mietw_Amount],
	[Umsatz_Sonst_Rest] AS [Umsatz_Sonst_Rest] 
FROM [export_csv].[service_ausgangsrechnung_ab_2011_sle_ims_ohne_sle]
GO

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 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],
	--[Service Order No_] AS [Service Order No_],
	--[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],
	[Invoice Date] AS [Invoice Date],
	[Order Number] AS [Order Number],
	[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[DG1] AS [DG1],
	--[DG2] AS [DG2],
	[verk Std] AS [verk Std],
	--[ben Zeit] AS [ben Zeit],
	--[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],
	[DG] AS [DG],
	--[Cust_Group_Description_Verkaufskunde] AS [Cust_Group_Description_Verkaufskunde],
	--[Kundenart_Verkaufskunde] AS [Kundenart_Verkaufskunde],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	[Auftragsposition] AS [Auftragsposition],
	--[NL Teile_ori] AS [NL Teile_ori],
	[SB_Gruppe] AS [SB_Gruppe],
	[Rabatt Lohn] AS [Rabatt Lohn],
	[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],
	--[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] 
FROM [export_csv].[Service_Gutschriften_ab_2011]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Ausgangsrechnung_ab_2011_ben_AW_final]
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],
	--[Order Date] AS [Order Date],
	--[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],
	--[Order No] AS [Order No],
	--[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],
	--[Shipping Agent Code] AS [Shipping Agent Code],
	--[No Series] AS [No Series],
	--[Order No Series] AS [Order No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	[Service Order No] AS [Service Order No],
	--[Customer Group Code] AS [Customer Group Code],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[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],
	[Invoice Date] AS [Invoice Date],
	[Order Number] AS [Order Number],
	[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[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],
	--[Monteur_] AS [Monteur_],
	--[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],
	[ben. AW_Time_Clock] AS [ben. AW_Time_Clock],
	[Auftragsposition] AS [Auftragsposition],
	[SB_Gruppe] AS [SB_Gruppe],
	[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[ben Zeit] AS [ben Zeit],
	--[Rechtseinheit_ID] AS [Rechtseinheit_ID],
	--[Standort_ID] AS [Standort_ID],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	[Order_Desc_100] AS [Order_Desc_100],
	[Invoice_Desc_100] AS [Invoice_Desc_100],
	--[Order_Desc_30] AS [Order_Desc_30],
	--[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Model_Desc] AS [Model_Desc],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[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],
	--[Service Job No] AS [Service Job No],
	--[Resource No] AS [Resource No],
	--[Summe Order Job] AS [Summe Order Job] 
FROM [export_csv].[Service_Ausgangsrechnung_ab_2011_ben_AW_final]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Gutschriften_ab_2011_ben_AW_final]
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],
	--[Order No] AS [Order No],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[Service Order No_] AS [Service Order No_],
	--[Customer Group Code] AS [Customer 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],
	[Invoice Date] AS [Invoice Date],
	[Order Number] AS [Order Number],
	[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[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],
	--[Duration Time Clock_Add_Service_Time_Clock_ims] AS [Duration Time Clock_Add_Service_Time_Clock_ims],
	--[Monteur] AS [Monteur],
	[Auftragsposition] AS [Auftragsposition],
	[ben. AW_Time_Clock] AS [ben. AW_Time_Clock],
	--[Rechtseinheit_ID] AS [Rechtseinheit_ID],
	--[Standort_ID] AS [Standort_ID],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	[Order_Desc_100] AS [Order_Desc_100],
	[Invoice_Desc_100] AS [Invoice_Desc_100],
	--[Order_Desc_30] AS [Order_Desc_30],
	--[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Model_Desc] AS [Model_Desc],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[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],
	[SB_Gruppe] AS [SB_Gruppe],
	[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Service Job No] AS [Service Job No],
	--[Resource No] AS [Resource No],
	--[Summe Order Job] AS [Summe Order Job] 
FROM [export_csv].[Service_Gutschriften_ab_2011_ben_AW_final]
GO