C11/System/ARI/Export/SQL/views_load/load.Service_Umsaetze.sql

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

CREATE
	OR

ALTER VIEW [load].[Service_Umsaetze]
AS
SELECT [G L Account No],
	[Posting Date],
	[Document Type],
	[Document No],
	[Description],
	[Amount],
	[Gen Bus Posting Group],
	[Service Ledger Entry No],
	[Invoice Date],
	[Hauptbetrieb],
	[Branch Code],
	[Standort],
	[Entry No],
	[Order No],
	[Ebene3],
	[Zeile],
	[Umsatz Lohn],
	[Umsatz Sonstiges],
	[Make Code],
	[Marke],
	[Department Code]
FROM [export_csv].[Service_Umsaetze]
GO

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS OFF
GO


GO