SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

CREATE
	OR

ALTER VIEW [load].[Service_Eroeffnung_oA]
AS
SELECT [Document Type],
	[No],
	[Sell-to Customer No],
	[Bill-to Customer No],
	[Bill-to Name],
	[Bill-to Name 2],
	[Order Date],
	[Location Code],
	[Department Code],
	[Make Code],
	[Customer Posting Group],
	[Salesperson Code],
	[Order Class],
	[Sell-to Customer Name],
	[Sell-to Customer Name 2],
	[Document Date],
	[No Series],
	[Vin],
	[Mileage],
	[Model Code],
	[Model No],
	[Prod Year],
	[Model_ori],
	[Service Advisor No Pick-up],
	[Service Advisor No],
	[Hauptbetrieb],
	[Standort_Department],
	[Umsatzart],
	[Marke],
	[Customer Group Code],
	[Kundenart_ori],
	[Fabrikat],
	[Model],
	[Fahrzeug],
	[Cust_No],
	[Cust_Name],
	[Kunde],
	[Cust_Group_Description],
	[Kundenart],
	[Order Number],
	[Auftragsdatum],
	[DG_1],
	[Standort],
	[Order Number_Rg_Ausg],
	[First Name],
	[Last Name],
	[Serviceberater],
	[Auftragsart],
	[Auftragsart_1],
	[Serv.beratung am FZG],
	[Arbeitsgang],
	[DG_2],
	[Durchgänge eröffnet],
	[offene Aufträge],
	[offene Aufträge älter 20 Tage],
	[Invoice Date],
	[Resource Group No],
	[SB_Gruppe]
FROM [export_csv].[Service_Eroeffnung_oA]
GO

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS OFF
GO


GO