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

CREATE
	OR

ALTER VIEW [load].[Service_Plan_ohne_FL]
AS
SELECT [Hauptbetrieb] AS [Hauptbetrieb],
	[Betrieb Nr] AS [Betrieb Nr],
	[Kostenstelle] AS [Kostenstelle],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	--[Gesamt] AS [Gesamt],
	--[Periode13] AS [Periode13],
	--[Jan] AS [Jan],
	--[Feb] AS [Feb],
	--[Mar] AS [Mar],
	--[Apr] AS [Apr],
	--[Mai] AS [Mai],
	--[Jun] AS [Jun],
	--[Jul] AS [Jul],
	--[Aug] AS [Aug],
	--[Sep] AS [Sep],
	--[Okt] AS [Okt],
	--[Nov] AS [Nov],
	--[Dez] AS [Dez],
	[Version] AS [Version],
	--[Jahr] AS [Jahr],
	--[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Bookkeep 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],
	--[Monat] AS [Monat],
	--[Plan] AS [Plan_ori],
	[Plan_ori] * - 1 AS [Plan] 
FROM [export_csv].[Service_Plan_ohne_FL]
GO