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

CREATE
	OR

ALTER VIEW [load].[Belege]
AS
SELECT --[No] AS [No],
	--[Name] AS [Name],
	--[Account Type] AS [Account Type],
	--[Income Balance] AS [Income Balance],
	--[Last Date Modified] AS [Last Date Modified],
	--[Entry No] AS [Entry No],
	--[G L Account No] AS [G L Account No],
	--[Posting Date] AS [Posting Date],
	--[Document Type] AS [Document Type],
	--[Document No] AS [Document No],
	--[Description] AS [Description],
	--[Bal Account No] AS [Bal Account No],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[User Id] AS [User Id],
	--[Source Code] AS [Source Code],
	--[Quantity] AS [Quantity],
	--[Reason Code] AS [Reason Code],
	--[Gen Posting Type] AS [Gen Posting Type],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Bal Account Type] AS [Bal Account Type],
	--[Transaction No] AS [Transaction No],
	--[Document Date] AS [Document Date],
	--[External Document No] AS [External Document No],
	--[Source Type] AS [Source Type],
	--[Source No] AS [Source No],
	--[No Series] AS [No Series],
	--[Branch Code] AS [Branch Code],
	--[Main Area] AS [Main Area],
	--[Vin] AS [Vin],
	--[Book No] AS [Book No],
	--[Veh Source Code] AS [Veh Source Code],
	--[Reposted] AS [Reposted],
	--[Corrected] AS [Corrected],
	--[Correction To Curr No] AS [Correction To Curr No],
	--[Reposting To Curr No] AS [Reposting To Curr No],
	--[Code] AS [Code],
	--[(2) Name] AS [(2) Name],
	[Bookkeep Date] AS [Bookkeep Date],
	[Betrieb] AS [Betrieb],
	[Acct Nr] AS [Acct Nr],
	[Betrag] AS [Betrag],
	--[Amount_1] AS [Amount_1],
	--[Text] AS [Text],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Marke] AS [Fabrikat],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard] 
FROM [export_csv].[Belege]
GO