CREATE
	OR

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

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen]
AS
SELECT --[Konto_Nr] AS [Konto_Nr],
	--[Konto_Bezeichnung] AS [Konto_Bezeichnung],
	--[Konto_Art] AS [Konto_Art],
	[Kostenstelle] AS [Kostenstelle],
	--[STK] AS [STK],
	--[Konto_1] AS [Konto_1],
	--[Konto_2] AS [Konto_2],
	--[Konto_3] AS [Konto_3],
	--[Konto_4] AS [Konto_4],
	--[Konto_5] AS [Konto_5],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Ebene5] AS [Ebene5],
	--[Ebene6] AS [Ebene6],
	--[Ebene7] AS [Ebene7],
	--[Ebene8] AS [Ebene8],
	--[Ebene9] AS [Ebene9],
	--[Ebene10] AS [Ebene10],
	--[Ebene11] AS [Ebene11],
	[Ebene12] AS [Ebene12],
	[Ebene13] AS [Ebene13],
	[Ebene14] AS [Ebene14],
	[Ebene15] AS [Ebene15],
	--[Ebene16] AS [Ebene16],
	--[Ebene17] AS [Ebene17],
	--[Ebene18] AS [Ebene18],
	--[Ebene19] AS [Ebene19],
	--[Ebene20] AS [Ebene20],
	[Ebene21] AS [Ebene21],
	[Ebene22] AS [Ebene22],
	[Ebene23] AS [Ebene23],
	[Ebene24] AS [Ebene24],
	[Ebene25] AS [Ebene25],
	[Ebene26] AS [Ebene26],
	--[Ebene27] AS [Ebene27],
	--[Ebene28] AS [Ebene28],
	--[Ebene29] AS [Ebene29],
	--[Ebene30] AS [Ebene30],
	[Ebene31] AS [Ebene31],
	[Ebene32] AS [Ebene32],
	[Ebene33] AS [Ebene33],
	[Ebene34] AS [Ebene34],
	[Ebene35] AS [Ebene35],
	[Ebene36] AS [Ebene36],
	--[Ebene37] AS [Ebene37],
	--[Ebene38] AS [Ebene38],
	--[Ebene39] AS [Ebene39],
	--[Ebene40] AS [Ebene40],
	--[Ebene41] AS [Ebene41],
	--[Ebene42] AS [Ebene42],
	--[Ebene43] AS [Ebene43],
	--[Ebene44] AS [Ebene44],
	--[Ebene45] AS [Ebene45],
	--[Ebene46] AS [Ebene46],
	--[Ebene47] AS [Ebene47],
	--[Ebene48] AS [Ebene48],
	--[Ebene49] AS [Ebene49],
	--[Ebene50] AS [Ebene50],
	--[Ebene51] AS [Ebene51],
	--[Ebene52] AS [Ebene52],
	--[Ebene53] AS [Ebene53],
	--[Ebene54] AS [Ebene54],
	--[Ebene55] AS [Ebene55],
	--[Ebene56] AS [Ebene56],
	--[Ebene57] AS [Ebene57],
	--[Ebene58] AS [Ebene58],
	--[Ebene59] AS [Ebene59],
	--[Ebene60] AS [Ebene60],
	[Konto_Art] AS [GuV_Bilanz],
	left ( [Konto_Nr] , 1 ) AS [Susa],
	[Konto_Nr] AS [Acct Nr],
	[Konto_Nr] + ' - ' + [Konto_Bezeichnung] AS [Konto] 
FROM [export_csv].[Kontenrahmen]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_STK]
AS
SELECT --[Konto_Nr] AS [Konto_Nr],
	--[Konto_Bezeichnung] AS [Konto_Bezeichnung],
	--[Konto_Art] AS [Konto_Art],
	[Kostenstelle] AS [Kostenstelle],
	--[STK] AS [STK],
	--[Konto_1] AS [Konto_1],
	--[Konto_2] AS [Konto_2],
	--[Konto_3] AS [Konto_3],
	--[Konto_4] AS [Konto_4],
	--[Konto_5] AS [Konto_5],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Ebene5] AS [Ebene5],
	--[Ebene6] AS [Ebene6],
	--[Ebene7] AS [Ebene7],
	--[Ebene8] AS [Ebene8],
	--[Ebene9] AS [Ebene9],
	--[Ebene10] AS [Ebene10],
	--[Ebene11] AS [Ebene11],
	[Ebene12] AS [Ebene12],
	[Ebene13] AS [Ebene13],
	[Ebene14] AS [Ebene14],
	[Ebene15] AS [Ebene15],
	--[Ebene16] AS [Ebene16],
	--[Ebene17] AS [Ebene17],
	--[Ebene18] AS [Ebene18],
	--[Ebene19] AS [Ebene19],
	--[Ebene20] AS [Ebene20],
	[Ebene21] AS [Ebene21],
	[Ebene22] AS [Ebene22],
	[Ebene23] AS [Ebene23],
	[Ebene24] AS [Ebene24],
	[Ebene25] AS [Ebene25],
	[Ebene26] AS [Ebene26],
	--[Ebene27] AS [Ebene27],
	--[Ebene28] AS [Ebene28],
	--[Ebene29] AS [Ebene29],
	--[Ebene30] AS [Ebene30],
	[Ebene31] AS [Ebene31],
	[Ebene32] AS [Ebene32],
	[Ebene33] AS [Ebene33],
	[Ebene34] AS [Ebene34],
	[Ebene35] AS [Ebene35],
	[Ebene36] AS [Ebene36],
	--[Ebene37] AS [Ebene37],
	--[Ebene38] AS [Ebene38],
	--[Ebene39] AS [Ebene39],
	--[Ebene40] AS [Ebene40],
	--[Ebene41] AS [Ebene41],
	--[Ebene42] AS [Ebene42],
	--[Ebene43] AS [Ebene43],
	--[Ebene44] AS [Ebene44],
	--[Ebene45] AS [Ebene45],
	--[Ebene46] AS [Ebene46],
	--[Ebene47] AS [Ebene47],
	--[Ebene48] AS [Ebene48],
	--[Ebene49] AS [Ebene49],
	--[Ebene50] AS [Ebene50],
	--[Ebene51] AS [Ebene51],
	--[Ebene52] AS [Ebene52],
	--[Ebene53] AS [Ebene53],
	--[Ebene54] AS [Ebene54],
	--[Ebene55] AS [Ebene55],
	--[Ebene56] AS [Ebene56],
	--[Ebene57] AS [Ebene57],
	--[Ebene58] AS [Ebene58],
	--[Ebene59] AS [Ebene59],
	--[Ebene60] AS [Ebene60],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Susa] AS [Susa],
	[Konto_Nr] AS [Acct Nr],
	[Konto_Nr] + ' - ' + [Konto_Bezeichnung] AS [Konto] 
FROM [export_csv].[Kontenrahmen_STK]
GO

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],
	[Bookkeep Date] AS [Bookkeep Date],
	[Betrieb] AS [Betrieb Nr],
	[Acct Nr] AS [Acct Nr],
	[Betrag] AS [Betrag],
	--[Amount_1] AS [Amount_1],
	[Text] AS [Text],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Marke] AS [Marke] 
FROM [export_csv].[Belege]
GO

CREATE
	OR

ALTER VIEW [load].[NW_GW_GK_Stk_fuer_FIBU_Betrag]
AS
SELECT --[Entry No] AS [Entry No],
	--[Entry Type] AS [Entry Type],
	--[Document No] AS [Document No],
	--[Posting Date] AS [Posting Date],
	--[Book No] AS [Book No],
	--[Vin] AS [Vin],
	--[Description] AS [Description],
	--[Quantity] AS [Quantity],
	--[Department Code_veh_ledger_entry] AS [Department Code_veh_ledger_entry],
	--[Make Code] AS [Make Code],
	--[Document Date] AS [Document Date],
	--[Type] AS [Type],
	--[No] AS [No],
	--[License No] AS [License No],
	--[Location Code] AS [Location Code],
	[Date Of Sale] AS [Bookkeep Date],
	--[Open] AS [Open],
	--[Current Sales Ledger Entry] AS [Current Sales Ledger Entry],
	--[Credit Memo] AS [Credit Memo],
	--[Sold] AS [Sold],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Vat Prod Posting Group] AS [Vat Prod Posting Group],
	--[Bal Account No] AS [Bal Account No],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Vat Bus Posting Group] AS [Vat Bus Posting Group],
	--[Salespers Purch Code] AS [Salespers Purch Code],
	--[Model No] AS [Model No],
	--[Vehicle] AS [Vehicle],
	--[Vehicle Status] AS [Vehicle Status],
	--[Branch Book No] AS [Branch Book No],
	--[Source Type] AS [Source Type],
	--[Source No] AS [Source No],
	--[Source No (payment)] AS [Source No (payment)],
	--[Source Group Code] AS [Source Group Code],
	--[Main Customer] AS [Main Customer],
	--[Main Area] AS [Main Area],
	--[Document Type] AS [Document Type],
	--[Value Ledger Entry No] AS [Value Ledger Entry No],
	--[Veh Status Change] AS [Veh Status Change],
	--[Item Ledger Entry Type] AS [Item Ledger Entry Type],
	--[Inventory Posting Group] AS [Inventory Posting Group],
	--[Source Posting Group] AS [Source Posting Group],
	--[Valued Quantity] AS [Valued Quantity],
	--[Invoiced Quantity] AS [Invoiced Quantity],
	--[Cost Posted To G L] AS [Cost Posted To G L],
	--[Amount_Value_ledger_entry] AS [Amount_Value_ledger_entry],
	--[Amount] AS [Amount],
	--[Variance Type] AS [Variance Type],
	--[Item Type_value_ledger_entry] AS [Item Type_value_ledger_entry],
	--[Menge_ori] AS [Menge_ori],
	--[Summe_Menge] AS [Summe_Menge],
	--[Menge] AS [Menge],
	--[Summe  (Menge) Nr.4] AS [Summe  (Menge) Nr.4],
	--[Summe  (Menge) Nr.3] AS [Summe  (Menge) Nr.3],
	--[G L Account No] AS [G L Account No],
	--[Source Code] AS [Source Code],
	--[Veh Source Code] AS [Veh Source Code],
	--[Document No_GL_Entry] AS [Document No_GL_Entry],
	--[Department Code] AS [Department Code],
	--[Vat Prod Posting Group_GL_Account] AS [Vat Prod Posting Group_GL_Account],
	--[Branch Code] AS [Branch Code],
	--[Geschäftsart] AS [Geschäftsart],
	--[Filter_Document_No] AS [Filter_Document_No],
	--[Filter_Vehicle_Source_Code] AS [Filter_Vehicle_Source_Code],
	--[Jahr] AS [Jahr],
	[Betrieb Nr] AS [Betrieb Nr],
	--[Konto Nr] AS [Konto Nr],
	--[Description_GL_Entry] AS [Description_GL_Entry],
	[Text] AS [Text],
	[Betrag] AS [Betrag],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Marke] AS [Marke],
	[Acct Nr] AS [Acct Nr] 
FROM [export_csv].[NW_GW_GK_Stk_fuer_FIBU_Betrag]
GO

CREATE
	OR

ALTER VIEW [load].[NW_GW_GK_Stk_fuer_FIBU_Menge]
AS
SELECT --[Entry No] AS [Entry No],
	--[Entry Type] AS [Entry Type],
	--[Document No] AS [Document No],
	--[Posting Date] AS [Posting Date],
	--[Book No] AS [Book No],
	--[Vin] AS [Vin],
	--[Description] AS [Description],
	--[Quantity] AS [Quantity],
	--[Department Code_veh_ledger_entry] AS [Department Code_veh_ledger_entry],
	--[Make Code] AS [Make Code],
	--[Document Date] AS [Document Date],
	--[Type] AS [Type],
	--[No] AS [No],
	--[License No] AS [License No],
	--[Location Code] AS [Location Code],
	[Date Of Sale] AS [Bookkeep Date],
	--[Open] AS [Open],
	--[Current Sales Ledger Entry] AS [Current Sales Ledger Entry],
	--[Credit Memo] AS [Credit Memo],
	--[Sold] AS [Sold],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Vat Prod Posting Group] AS [Vat Prod Posting Group],
	--[Bal Account No] AS [Bal Account No],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Vat Bus Posting Group] AS [Vat Bus Posting Group],
	--[Salespers Purch Code] AS [Salespers Purch Code],
	--[Model No] AS [Model No],
	--[Vehicle] AS [Vehicle],
	--[Vehicle Status] AS [Vehicle Status],
	--[Branch Book No] AS [Branch Book No],
	--[Source Type] AS [Source Type],
	--[Source No] AS [Source No],
	--[Source No (payment)] AS [Source No (payment)],
	--[Source Group Code] AS [Source Group Code],
	--[Main Customer] AS [Main Customer],
	--[Main Area] AS [Main Area],
	--[Document Type] AS [Document Type],
	--[Value Ledger Entry No] AS [Value Ledger Entry No],
	--[Veh Status Change] AS [Veh Status Change],
	--[Item Ledger Entry Type] AS [Item Ledger Entry Type],
	--[Inventory Posting Group] AS [Inventory Posting Group],
	--[Source Posting Group] AS [Source Posting Group],
	--[Valued Quantity] AS [Valued Quantity],
	--[Invoiced Quantity] AS [Invoiced Quantity],
	--[Cost Posted To G L] AS [Cost Posted To G L],
	--[Amount_Value_ledger_entry] AS [Amount_Value_ledger_entry],
	--[Amount] AS [Amount],
	--[Variance Type] AS [Variance Type],
	--[Item Type_value_ledger_entry] AS [Item Type_value_ledger_entry],
	--[Menge_ori] AS [Menge_ori],
	--[Summe_Menge] AS [Summe_Menge],
	--[Menge_alt] AS [Menge_alt],
	--[Summe  (Menge) Nr.4] AS [Summe  (Menge) Nr.4],
	--[Summe  (Menge) Nr.3] AS [Summe  (Menge) Nr.3],
	--[G L Account No] AS [G L Account No],
	--[Source Code] AS [Source Code],
	--[Veh Source Code] AS [Veh Source Code],
	--[Document No_GL_Entry] AS [Document No_GL_Entry],
	--[Department Code] AS [Department Code],
	--[Vat Prod Posting Group_GL_Account] AS [Vat Prod Posting Group_GL_Account],
	--[Branch Code] AS [Branch Code],
	--[Geschäftsart] AS [Geschäftsart],
	--[Filter_Document_No] AS [Filter_Document_No],
	--[Filter_Vehicle_Source_Code] AS [Filter_Vehicle_Source_Code],
	--[Jahr] AS [Jahr],
	[Betrieb Nr] AS [Betrieb Nr],
	--[Konto Nr] AS [Konto Nr],
	--[Description_GL_Entry] AS [Description_GL_Entry],
	[Text] AS [Text],
	[Menge_FIBU] AS [Menge_FIBU],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Marke] AS [Marke],
	[Acct Nr] AS [Acct Nr] 
FROM [export_csv].[NW_GW_GK_Stk_fuer_FIBU_Menge]
GO

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