C11/System/ARI/Models/mdl/Dashboard_gesamt_queries.sql

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen]
AS
SELECT [Konto_Nr] AS [Acct Nr],
	--[Konto_Bezeichnung] AS [Konto_Bezeichnung],
	--[Konto_Art] AS [Konto_Art],
	[Kostenstelle] AS [Kostenstelle_FIBU],
	--[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],
	[Acct Nr] + ' - ' + [Konto_Bezeichnung] AS [Konto] 
FROM [export_csv].[Kontenrahmen]
GO

CREATE
	OR

ALTER VIEW [load].[Zuordnung_Task_Type]
AS
SELECT --[Code] AS [Code],
	--[Description] AS [Description],
	[Activity_Desc] AS [Activity_Desc],
	[Activity_Codes_Group1] AS [Activity_Codes_Group1],
	[Activity_Codes_Group2] AS [Activity_Codes_Group2] 
FROM [export_csv].[Zuordnung_Task_Type]
GO

CREATE
	OR

ALTER VIEW [load].[Zuordnung_Time_Account_Abw]
AS
SELECT --[No_] AS [No_],
	--[Description] AS [Description],
	[Activity_Desc] AS [Activity_Desc],
	[Activity_Codes_Group1] AS [Activity_Codes_Group1],
	[Activity_Codes_Group2] AS [Activity_Codes_Group2] 
FROM [export_csv].[Zuordnung_Time_Account_Abw]
GO

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose~1]
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],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard] 
FROM [export_csv].[current_date_Prognose~1]
GO

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose_VJ]
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],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard] 
FROM [export_csv].[current_date_Prognose_VJ]
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],
	--[(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

CREATE
	OR

ALTER VIEW [load].[Belege_Umsatz_FIBU]
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_KST],
	--[Betrag] AS [Betrag_],
	--[Amount_1] AS [Amount_1],
	--[Text] AS [Text],
	[Hauptbetrieb] AS [Hauptbetrieb],
	--[Marke] AS [Marke],
	--[Ebene1] AS [Ebene1_],
	--[Ebene2] AS [Ebene2_],
	[Umsatz FIBU gesamt] AS [Umsatz FIBU gesamt],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard] 
FROM [export_csv].[Belege_Umsatz_FIBU]
GO

CREATE
	OR

ALTER VIEW [load].[NW_GW_VK_TIM]
AS
SELECT --[No] AS [No],
	--[Name] AS [Name],
	--[Account Type] AS [Account Type],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Income Balance] AS [Income Balance],
	--[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],
	--[Amount] AS [Amount],
	--[Bal Account No] AS [Bal Account No],
	--[(2) Department Code] AS [(2) Department Code],
	--[(2) Make Code] AS [(2) Make Code],
	--[User Id] AS [User Id],
	--[Source Code] AS [Source Code],
	--[Quantity] AS [Quantity],
	--[Debit Amount] AS [Debit Amount],
	--[Credit Amount] AS [Credit Amount],
	--[Document Date] AS [Document Date],
	--[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],
	--[Betrag] AS [Betrag_],
	--[Vin_Vehicle] AS [Vin_Vehicle],
	--[Vehicle Status] AS [Vehicle Status],
	--[Model_ori] AS [Model_ori],
	--[Type] AS [Type],
	--[Class] AS [Class],
	--[Model No] AS [Model No],
	[Hauptbetrieb] AS [Hauptbetrieb],
	--[Standort_alt] AS [Standort_alt],
	--[Make Code_Vehicle] AS [Make Code_Vehicle],
	--[Fabrikat_ori] AS [Fabrikat_ori],
	[Model] AS [Model],
	--[Market Segment Code] AS [Market Segment Code],
	--[Modellbez] AS [Modellbez],
	[Fahrzeugart] AS [Fahrzeugart],
	--[Vat Prod Posting Group] AS [Vat Prod Posting Group],
	--[Fahrzeugtyp_alt] AS [Fahrzeugtyp_alt],
	[FZG] AS [FZG],
	--[Location Code] AS [Location Code],
	--[VB_Einkauf] AS [VB_Einkauf],
	--[Purchase Receipt Date] AS [Purchase Receipt Date],
	--[Standtage_ori] AS [Standtage_ori],
	[Standtagestaffel] AS [Standtagestaffel],
	--[Initial Registration] AS [Initial Registration],
	--[EZ/Eingang] AS [EZ/Eingang],
	--[Polster] AS [Polster],
	--[Farbe] AS [Farbe],
	--[Einsatz_ori] AS [Einsatz_ori],
	--[Heute] AS [Heute],
	--[Fahrzeugstatus] AS [Fahrzeugstatus],
	--[FZG-Liste] AS [FZG-Liste],
	--[Anzahl] AS [Anzahl],
	--[Standtage] AS [Standtage],
	--[Inventory Posting Group] AS [Inventory Posting Group],
	--[Date Of Sale] AS [Date Of Sale],
	[Invoice Date] AS [Bookkeep Date],
	--[Customer No] AS [Customer No],
	--[No_Customer] AS [No_Customer],
	--[Name_Customer] AS [Name_Customer],
	[Kunde] AS [Kunde],
	--[Customer Type] AS [Customer Type],
	[Kundenart] AS [Kundenart],
	--[Old Customer No] AS [Old Customer No],
	--[(2) Old Customer No] AS [(2) Old Customer No],
	--[No_Vorbesitzer] AS [No_Vorbesitzer],
	--[Name_Vorbesitzer] AS [Name_Vorbesitzer],
	--[Vorbesitzer] AS [Vorbesitzer],
	--[Engine Code] AS [Engine Code],
	--[Motor Code] AS [Motor Code],
	--[Geschäftsart] AS [Geschäftsart],
	--[FZG_Liste_1_ori] AS [FZG_Liste_1_ori],
	--[FZG_Liste_2] AS [FZG_Liste_2],
	--[FZG_Liste_3] AS [FZG_Liste_3],
	--[FZG_Liste_4] AS [FZG_Liste_4],
	[Erlös] AS [Erlös FZG],
	[Einsatz] AS [Einsatz FZG],
	--[EK Fahrzeug] AS [EK Fahrzeug],
	--[Bonus] AS [Bonus],
	--[int. Kosten] AS [int. Kosten],
	--[Current Branch Book No] AS [Current Branch Book No],
	--[Current Book No] AS [Current Book No],
	--[Summe EK-FZG] AS [Summe EK-FZG],
	[Fabrikat] AS [Fabrikat],
	--[Buchnummer gleich_ja_nein] AS [Buchnummer gleich_ja_nein],
	--[Menge1] AS [Menge1],
	--[Menge2] AS [Menge2],
	--[Menge3] AS [Menge3],
	--[Menge4] AS [Menge4],
	--[VIN + PostingDate] AS [VIN + PostingDate],
	--[Summe Menge4] AS [Summe Menge4],
	--[Menge_2_test] AS [Menge_2_test],
	--[Menge3_test] AS [Menge3_test],
	--[Menge4_test] AS [Menge4_test],
	--[Fahrzeugart_Schmidt] AS [Fahrzeugart_Schmidt],
	--[Salespers Purch Code_VLE] AS [Salespers Purch Code_VLE],
	--[Code_für_VEH_Ledger_Entry] AS [Code_für_VEH_Ledger_Entry],
	--[Name_für_VEH_Ledger_Entry] AS [Name_für_VEH_Ledger_Entry],
	[Verkäufer] AS [Verkäufer],
	--[FZG_Liste_1_falsch] AS [FZG_Liste_1_falsch],
	--[FZG_Liste_0_ori] AS [FZG_Liste_0_ori],
	--[FZG_Liste_1] AS [FZG_Liste_1],
	--[FZG_Liste_0] AS [FZG_Liste_0],
	--[Beleg] AS [Beleg],
	--[Standort_FIBU] AS [Standort_FIBU],
	--[Fahrzeugart_neu] AS [Fahrzeugart_neu],
	[Standort] AS [Standort],
	--[Summe_Betrag] AS [Summe_Betrag],
	--[Country Code_Kunde] AS [Country Code_Kunde],
	--[Vat Bus Posting Group_Kunde] AS [Vat Bus Posting Group_Kunde],
	--[FZG_Liste_5_ori] AS [FZG_Liste_5_ori],
	--[Customer Group Code] AS [Customer Group Code],
	--[FZG_Liste_5] AS [FZG_Liste_5],
	--[FZG_Liste_6] AS [FZG_Liste_6],
	--[FZG_Liste_7] AS [FZG_Liste_7],
	--[FZG_Detail] AS [FZG_Detail],
	--[Anz. Sätze] AS [Anz. Sätze],
	[Menge_final] AS [Menge_FZG],
	--[No_Item] AS [No_Item],
	--[Description_Item] AS [Description_Item],
	--[Vehicle Type Code_Item] AS [Vehicle Type Code_Item],
	--[Modell_zwischen] AS [Modell_zwischen],
	--[Vehicle Category Code] AS [Vehicle Category Code],
	--[Summe Erlös FZG] AS [Summe Erlös FZG],
	--[Erlöse FZG] AS [Erlöse FZG],
	--[Modell_final] AS [Modell_final],
	[Fahrzeugtyp] AS [Fahrzeugtyp],
	[FZG] AS [FZG_Verkauf_Dashboard],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	[Fahrzeugart] AS [Bereich Umsatz] 
FROM [export_csv].[NW_GW_VK_TIM]
GO

CREATE
	OR

ALTER VIEW [load].[NW_GW_BE_neu]
AS
SELECT --[No] AS [No],
	--[Name] AS [Name],
	--[Account Type] AS [Account Type],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Income Balance] AS [Income Balance],
	--[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],
	--[Amount] AS [Amount],
	--[Bal Account No] AS [Bal Account No],
	--[User Id] AS [User Id],
	--[Source Code] AS [Source Code],
	--[Quantity] AS [Quantity],
	--[Debit Amount] AS [Debit Amount],
	--[Credit Amount] AS [Credit Amount],
	--[Document Date] AS [Document Date],
	--[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],
	--[Betrag] AS [Betrag_],
	--[Vin_Vehicle] AS [Vin_Vehicle],
	--[Vehicle Status] AS [Vehicle Status],
	--[Model_ori] AS [Model_ori],
	--[Type] AS [Type],
	--[Class] AS [Class],
	--[Model No] AS [Model No],
	[Hauptbetrieb] AS [Hauptbetrieb],
	--[Standort_FIBU] AS [Standort_FIBU],
	--[Make Code_Vehicle] AS [Make Code_Vehicle],
	--[Fabrikat_ori] AS [Fabrikat_ori],
	--[Model_alt] AS [Model_alt],
	--[Market Segment Code] AS [Market Segment Code],
	--[Modellbez] AS [Modellbez],
	[Fahrzeugart] AS [Fahrzeugart],
	--[Vat Prod Posting Group] AS [Vat Prod Posting Group],
	--[Fahrzeugtyp_ori] AS [Fahrzeugtyp_ori],
	[FZG] AS [FZG_Bestand_Dashboard],
	--[Location Code] AS [Location Code],
	--[VB_Einkauf] AS [VB_Einkauf],
	--[Purchase Receipt Date] AS [Purchase Receipt Date],
	[Standtage_ori] AS [Standtage_ori_Bestand],
	--[Standtagestaffel_ori] AS [Standtagestaffel_ori],
	--[Initial Registration] AS [Initial Registration],
	--[EZ/Eingang] AS [EZ/Eingang],
	--[Option Type_Polster] AS [Option Type_Polster],
	--[Polster] AS [Polster],
	--[Option Type_Farbe] AS [Option Type_Farbe],
	--[Farbe] AS [Farbe],
	[Einsatz] AS [Einsatz_Bestand],
	[Heute] AS [Bookkeep Date],
	--[Fahrzeugstatus] AS [Fahrzeugstatus],
	--[FZG-Liste] AS [FZG-Liste],
	--[Anzahl] AS [Anzahl],
	--[Standtage] AS [Standtage],
	--[Summe Standtage] AS [Summe Standtage],
	--[Menge_FZG] AS [Menge_FZG_],
	--[Inventory Posting Group] AS [Inventory Posting Group],
	--[Summe Betrag] AS [Summe Betrag],
	--[Fzg_Typ_Herkunft] AS [Fzg_Typ_Herkunft],
	--[Current Price Sticker] AS [Current Price Sticker],
	--[Manual Price Calculation] AS [Manual Price Calculation],
	--[Total Quote Amount] AS [Total Quote Amount],
	--[Price Sticker Date] AS [Price Sticker Date],
	--[gepl. VK] AS [gepl. VK],
	--[Datum letzte Änderung] AS [Datum letzte Änderung],
	--[FZG-Kosten] AS [FZG-Kosten],
	--[EK FZG] AS [EK FZG],
	--[Text 3] AS [Text 3],
	--[Bestand/reserviert] AS [Bestand/reserviert],
	--[Ort_B_R_Dat_Änd] AS [Ort_B_R_Dat_Änd],
	--[Date Of Sale] AS [Date Of Sale],
	--[Summe EK] AS [Summe EK],
	[Standort] AS [Standort],
	--[Dealer Status_ori] AS [Dealer Status_ori],
	--[Transmission Type Code] AS [Transmission Type Code],
	--[Key No] AS [Key No],
	--[Mileage] AS [Mileage],
	--[License No] AS [License No],
	--[Händlerstatus_Text] AS [Händlerstatus_Text],
	--[Händlerstatus] AS [Händlerstatus],
	--[Händlerstatus Gruppe] AS [Händlerstatus Gruppe],
	--[Dealer Status] AS [Dealer Status],
	--[Extra Code 1] AS [Extra Code 1],
	--[Text 1_Vorbesitzer] AS [Text 1_Vorbesitzer],
	--[Deregistration Date] AS [Deregistration Date],
	--[VFW zugel./abgem] AS [VFW zugel./abgem],
	--[EK erh. Pos.] AS [EK erh. Pos.],
	--[Name_Vorbesitzer] AS [Name_Vorbesitzer],
	--[EZ_Zeichen] AS [EZ_Zeichen],
	--[Abmeldung_Zeichen] AS [Abmeldung_Zeichen],
	--[Dat_letzte_Änderung_Zeichen] AS [Dat_letzte_Änderung_Zeichen],
	--[Bemerkung] AS [Bemerkung],
	--[UPE] AS [UPE],
	--[Fahrzeugtyp_alt] AS [Fahrzeugtyp_alt],
	--[Model_alt_1] AS [Model_alt_1],
	--[kundenbelegt ja/nein] AS [kundenbelegt ja/nein],
	[Standtagestaffel] AS [Standtagestaffel],
	--[No_Item] AS [No_Item],
	--[Description_Item] AS [Description_Item],
	--[Vehicle Type Code_Item] AS [Vehicle Type Code_Item],
	--[Vehicle Category Code_Item] AS [Vehicle Category Code_Item],
	--[Modell_zwischen] AS [Modell_zwischen],
	[Fabrikat] AS [Fabrikat],
	--[Modell_final] AS [Modell_final],
	[Model] AS [Model],
	[Fahrzeugtyp] AS [Fahrzeugtyp],
	--[Tage letzte Preisänderung_ori] AS [Tage letzte Preisänderung_ori],
	--[Tage letzte Preisänderung] AS [Tage letzte Preisänderung],
	--[Description_Dealer_Status] AS [Description_Dealer_Status],
	--[Code_Dealer_Status] AS [Code_Dealer_Status],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	--[Tage seit Erstzul.] AS [Tage seit Erstzul.] 
FROM [export_csv].[NW_GW_BE_neu]
GO

CREATE
	OR

ALTER VIEW [load].[Service_offene_Auftraege_neu_mitMont_Anzeige]
AS
SELECT --[Document Type] AS [Document Type],
	--[No] AS [No],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Bill-to Customer No] AS [Bill-to Customer No],
	--[Bill-to Name] AS [Bill-to Name],
	--[Order Date] AS [Order Date],
	--[Posting Date] AS [Posting Date],
	--[Posting Description] AS [Posting Description],
	--[Due Date] AS [Due Date],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Salesperson Code] AS [Salesperson Code],
	--[On Hold] AS [On Hold],
	--[Transaction Type] AS [Transaction Type],
	--[Transport Method] AS [Transport Method],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[Area] AS [Area],
	--[Reserve] AS [Reserve],
	--[Option Code] AS [Option Code],
	--[Service Posting Group] AS [Service Posting Group],
	--[Vin] AS [Vin],
	--[Model Code] AS [Model Code],
	--[Model No] AS [Model No],
	--[Model] AS [Model_],
	--[Type] AS [Type],
	--[Initial Registration] AS [Initial Registration],
	--[Order Limit] AS [Order Limit],
	--[Time Of Order] AS [Time Of Order],
	--[Pickup Date] AS [Pickup Date],
	--[Pickup Time] AS [Pickup Time],
	--[Completion Date] AS [Completion Date],
	--[Completion Time] AS [Completion Time],
	--[Labor Type] AS [Labor Type],
	--[Labor Charging Code] AS [Labor Charging Code],
	--[Book No] AS [Book No],
	--[Branch Book No] AS [Branch Book No],
	--[Sales Department Code] AS [Sales Department Code],
	--[Fixed Date] AS [Fixed Date],
	--[Fixed Instruction] AS [Fixed Instruction],
	--[Current Instruction Type] AS [Current Instruction Type],
	--[Work Completed] AS [Work Completed],
	--[Status Code] AS [Status Code],
	--[Service Advisor No] AS [Service Advisor No],
	[Hauptbetrieb] AS [Hauptbetrieb],
	--[Standort_Department] AS [Standort_Department],
	[Standort] AS [Standort],
	--[No_Employee] AS [No_Employee],
	--[First Name_Employee] AS [First Name_Employee],
	--[Last Name_Employee] AS [Last Name_Employee],
	[Serviceberater] AS [Serviceberater],
	[Umsatzart] AS [Umsatzart],
	--[Kunde] AS [Kunde_],
	--[Order Number_mit Monteur] AS [Order Number_mit Monteur],
	--[Entry No] AS [Entry No],
	--[Order No] AS [Order No],
	--[Document No] AS [Document No],
	--[Description] AS [Description],
	--[Quantity] AS [Quantity],
	--[Direct Unit Cost] AS [Direct Unit Cost],
	--[Unit Cost] AS [Unit Cost],
	--[Total Cost] AS [Total Cost],
	--[Unit Price] AS [Unit Price],
	--[Total Price] AS [Total Price],
	--[Work Type Code] AS [Work Type Code],
	--[User Id] AS [User Id],
	--[Amt To Post To G L] AS [Amt To Post To G L],
	--[Amt Posted To G L] AS [Amt Posted To G L],
	--[Amt To Recognize] AS [Amt To Recognize],
	--[Amt Recognized] AS [Amt Recognized],
	--[Entry Type] AS [Entry Type],
	--[Positive] AS [Positive],
	--[Qty Evaluated] AS [Qty Evaluated],
	--[Corrected] AS [Corrected],
	--[Variant Code] AS [Variant Code],
	--[Qty Per Unit Of Measure] AS [Qty Per Unit Of Measure],
	--[Quantity (base)] AS [Quantity (base)],
	--[Time Type] AS [Time Type],
	--[Service Job No] AS [Service Job No],
	--[Assoc Entry] AS [Assoc Entry],
	--[Closed] AS [Closed],
	--[Qty Per Hour] AS [Qty Per Hour],
	--[Qty (hour)] AS [Qty (hour)],
	--[Item Group Code] AS [Item Group Code],
	--[Customer Group Code] AS [Customer Group Code],
	--[Charging Group No] AS [Charging Group No],
	--[Standard Time] AS [Standard Time],
	--[Standard Time Type] AS [Standard Time Type],
	--[Source Type] AS [Source Type],
	--[Main Customer] AS [Main Customer],
	--[Order Line No] AS [Order Line No],
	--[Time From] AS [Time From],
	--[Time Until] AS [Time Until],
	--[Internal Charged] AS [Internal Charged],
	--[Order Completed] AS [Order Completed],
	--[Open] AS [Open],
	--[Closed By Entry No] AS [Closed By Entry No],
	--[Closed At Date] AS [Closed At Date],
	--[Closed By Quantity] AS [Closed By Quantity],
	--[Open Quantity] AS [Open Quantity],
	--[Labor Standard Time Type] AS [Labor Standard Time Type],
	--[Menge] AS [Menge],
	--[Einstandsbetrag] AS [Einstandsbetrag],
	--[Verkaufsbetrag] AS [Verkaufsbetrag],
	--[Umsatz Lohn] AS [Umsatz Lohn oA],
	--[Umsatz Teile Service] AS [Umsatz Teile Service oA],
	--[Umsatz Sonstiges] AS [Umsatz Sonstiges oA],
	--[Einsatz Teile Service] AS [Einsatz Teile Service oA],
	--[Einsatz Sonstiges] AS [Einsatz Sonstiges oA],
	--[Menge pro Stunde] AS [Menge pro Stunde],
	--[verk.Stunden] AS [verk.Stunden oA],
	--[verk. AW] AS [verk. AW oA],
	--[benutzte Zeit] AS [benutzte Zeit oA],
	--[benutzte AW] AS [benutzte AW oA],
	--[Name_Employee] AS [Name_Employee],
	--[Function Code] AS [Function Code],
	--[Monteur] AS [Monteur_],
	--[Funktion Monteur] AS [Funktion Monteur],
	--[ben. AW ohne AZUBI] AS [ben. AW ohne AZUBI],
	--[Auftragsdatum] AS [Auftragsdatum],
	--[DG_1] AS [DG_1],
	--[DG_2] AS [DG_2],
	[Durchgänge] AS [Durchgänge oA],
	--[Anzahl_Tage] AS [Anzahl_Tage],
	[Tage offen] AS [Tage offen],
	--[gebuchte Teile] AS [gebuchte Teile oA],
	--[Monteur_Anzeige] AS [Monteur_Anzeige],
	--[Serviceberater_Monteur] AS [Serviceberater_Monteur],
	--[Order Number] AS [Order Number],
	[Invoice Date] AS [Bookkeep Date],
	--[Minimum Letzte Stempelung] AS [Minimum Letzte Stempelung],
	--[Tage letzte Stemp. bereinigt] AS [Tage letzte Stemp. bereinigt],
	--[Anz. Tage letzte Stemp.] AS [Anz. Tage letzte Stemp.],
	--[Order Number_intern] AS [Order Number_intern],
	--[Anzahl Tage über Abholtermin] AS [Anzahl Tage über Abholtermin],
	--[Intern/Extern] AS [Intern/Extern],
	--[Tage über Abholtermin] AS [Tage über Abholtermin],
	--[Kundenname_verkauft_an] AS [Kundenname_verkauft_an],
	--[Bill-to Contact] AS [Bill-to Contact],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	--[Order Number_intern_neu] AS [Order Number_intern_neu],
	--[Anzahl Tage_ori] AS [Anzahl Tage_ori],
	--[Durchgänge (Auftrag)] AS [Durchgänge (Auftrag)],
	--[Anzahl Tage] AS [Anzahl Tage],
	--[Kostenstelle] AS [Kostenstelle],
	--[Fahrzeug] AS [Fahrzeug],
	--[Teile] AS [Teile oA],
	--[Arbeitswerte] AS [Arbeitswerte oA],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Fremdl.] AS [Fremdl.],
	[Auftragsart Service/Teile] AS [Auftragsart Service/Teile],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	--[Summe Amount_Order_Line_VK] AS [Summe Amount_Order_Line_VK],
	--[Umsatz Auftrag] AS [Umsatz Auftrag] 
FROM [export_csv].[Service_offene_Auftraege_neu_mitMont_Anzeige]
GO

CREATE
	OR

ALTER VIEW [load].[OP_ARI]
AS
SELECT --[Entry No] AS [Entry No],
	--[Customer No] AS [Customer No],
	--[Posting Date] AS [Posting Date],
	--[Document Type] AS [Document Type],
	--[Document No] AS [Document No],
	--[Description] AS [Description],
	--[Sales (lcy)] AS [Sales (lcy)],
	--[Profit (lcy)] AS [Profit (lcy)],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Global Dimension 1 Code] AS [Global Dimension 1 Code],
	--[Global Dimension 2 Code] AS [Global Dimension 2 Code],
	--[Salesperson Code] AS [Salesperson Code],
	--[User Id] AS [User Id],
	--[Source Code] AS [Source Code],
	--[On Hold_ori] AS [On Hold_ori],
	--[On Hold] AS [On Hold],
	--[Applies-to Doc Type] AS [Applies-to Doc Type],
	--[Applies-to Doc No] AS [Applies-to Doc No],
	--[Open] AS [Open],
	--[Due Date] AS [Due Date],
	--[Pmt Discount Date] AS [Pmt Discount Date],
	--[Positive] AS [Positive],
	--[Closed By Entry No] AS [Closed By Entry No],
	--[Closed At Date] AS [Closed At Date],
	--[Closed By Amount] AS [Closed By Amount],
	--[Journal Batch Name] AS [Journal Batch Name],
	--[Closed By Amount (lcy)] AS [Closed By Amount (lcy)],
	--[Document Date] AS [Document Date],
	--[No Series] AS [No Series],
	--[Last Issued Reminder Level] AS [Last Issued Reminder Level],
	--[Dimension Set Id] AS [Dimension Set Id],
	--[Direct Debit Mandate Id] AS [Direct Debit Mandate Id],
	--[Customer Group Code] AS [Customer Group Code],
	--[Branch Code] AS [Branch Code],
	--[Main Area] AS [Main Area],
	--[Pmt Disc Base] AS [Pmt Disc Base],
	--[Vin] AS [Vin],
	--[Factory No] AS [Factory No],
	--[Cash Reg Receipt No] AS [Cash Reg Receipt No],
	--[Comment] AS [Comment],
	--[Service Advisor No] AS [Service Advisor No],
	--[Salesperson Code 2] AS [Salesperson Code 2],
	--[Cust Ledger Entry No] AS [Cust Ledger Entry No],
	--[Entry Type] AS [Entry Type],
	--[Document Type_detail_cust] AS [Document Type_detail_cust],
	--[Document No_detail] AS [Document No_detail],
	--[User Id_detail_cust] AS [User Id_detail_cust],
	--[Amount] AS [Amount],
	--[Debit Amount] AS [Debit Amount],
	--[Credit Amount] AS [Credit Amount],
	--[Initial Entry Due Date] AS [Initial Entry Due Date],
	--[Initial Entry Global Dim 1] AS [Initial Entry Global Dim 1],
	--[Initial Entry Global Dim 2] AS [Initial Entry Global Dim 2],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Initial Document Type] AS [Initial Document Type],
	--[Saldo_Beleg_1] AS [Saldo_Beleg_1],
	--[Anzahl_Sätze_Entry_No] AS [Anzahl_Sätze_Entry_No],
	[offen] AS [offen],
	[Gesamt offen KD (Info)] AS [Gesamt offen KD (Info)],
	--[Sel Name_alt] AS [Sel Name_alt],
	--[Invoice Date] AS [Invoice Date],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Sel Name] AS [Sel Name],
	--[No_Customer] AS [No_Customer],
	--[Name_Customer] AS [Name_Customer],
	--[Last Name_Customer] AS [Last Name_Customer],
	--[First Name_Customer] AS [First Name_Customer],
	[Kunde] AS [Kunde],
	--[Beleg] AS [Beleg],
	[Bereich] AS [Bereich],
	--[Tage] AS [Tage],
	[Staffel] AS [Staffel],
	--[Salesperson Code_Sales_Inv_Header] AS [Salesperson Code_Sales_Inv_Header],
	--[Service Advisor No_Sales_Inv_Header] AS [Service Advisor No_Sales_Inv_Header],
	--[Code_Salesperson_Purchaser_Verkauf] AS [Code_Salesperson_Purchaser_Verkauf],
	--[Name_Salesperson_Purchaser_Verkauf] AS [Name_Salesperson_Purchaser_Verkauf],
	--[Code_Salesperson_Purchaser_Service] AS [Code_Salesperson_Purchaser_Service],
	--[Name_Salesperson_Purchaser_Service] AS [Name_Salesperson_Purchaser_Service],
	--[No_Employee_Service_Advisor] AS [No_Employee_Service_Advisor],
	--[First Name_Employee_Service_Advisor] AS [First Name_Employee_Service_Advisor],
	--[Last Name_Employee_Service_Advisor] AS [Last Name_Employee_Service_Advisor],
	--[No_Employee_Salesperson_Code] AS [No_Employee_Salesperson_Code],
	--[First Name_Employee_Salesperson_Code] AS [First Name_Employee_Salesperson_Code],
	--[Last Name_Employee_Salesperson_Code] AS [Last Name_Employee_Salesperson_Code],
	--[Sel Name_ori] AS [Sel Name_ori],
	--[Mahnstufe] AS [Mahnstufe],
	--[Betrag Rg.] AS [Betrag Rg.],
	--[Forderungsart] AS [Forderungsart],
	--[Abwarten] AS [Abwarten],
	--[Leasing] AS [Leasing],
	--[Message To Recipient] AS [Message To Recipient],
	--[Haft_Kasko] AS [Haft_Kasko] 
FROM [export_csv].[OP_ARI]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Ausgangsrechnung_ab_2011]
AS
SELECT --[No] AS [No],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Bill-to Customer No] AS [Bill-to Customer No],
	--[Bill-to Name] AS [Bill-to Name],
	--[Bill-to Address] AS [Bill-to Address],
	--[Bill-to City] AS [Bill-to City],
	--[Order Date] AS [Order Date],
	--[Posting Date] AS [Posting Date],
	--[Payment Terms Code] AS [Payment Terms Code],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Price Group Code] AS [Price Group Code],
	--[Prices Including Vat] AS [Prices Including Vat],
	--[Allow Quantity Disc] AS [Allow Quantity Disc],
	--[Salesperson Code] AS [Salesperson Code],
	--[Order No] AS [Order No],
	--[On Hold] AS [On Hold],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Transaction Type] AS [Transaction Type],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	--[Sell-to Address] AS [Sell-to Address],
	--[Sell-to City] AS [Sell-to City],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[External Document No] AS [External Document No],
	--[Area] AS [Area],
	--[Shipping Agent Code] AS [Shipping Agent Code],
	--[No Series] AS [No Series],
	--[Order No Series] AS [Order No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	--[Service Order No] AS [Service Order No],
	--[Customer Group Code] AS [Customer Group Code],
	--[Service Order Line No] AS [Service Order Line No],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[Line No] AS [Line No],
	--[(2) No] AS [(2) No],
	--[Description] AS [Description],
	--[Description 2] AS [Description 2],
	--[Quantity] AS [Quantity],
	--[Unit Price] AS [Unit Price],
	--[Unit Cost (lcy)] AS [Unit Cost (lcy)],
	--[Line Discount Amount] AS [Line Discount Amount],
	--[Amount] AS [Amount],
	--[Amount Including Vat] AS [Amount Including Vat],
	--[(2) Department Code] AS [(2) Department Code],
	--[(2) Make Code] AS [(2) Make Code],
	--[Inv Discount Amount] AS [Inv Discount Amount],
	--[(2) Gen Bus Posting Group] AS [(2) Gen Bus Posting Group],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Unit Cost] AS [Unit Cost],
	--[(2) Order No] AS [(2) Order No],
	--[Order Line No] AS [Order Line No],
	--[(2) Order Type] AS [(2) Order Type],
	--[Item Type] AS [Item Type],
	--[(2) Vin] AS [(2) Vin],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[(2) Service Order No] AS [(2) Service Order No],
	--[(2) Service Order Line No] AS [(2) Service Order Line No],
	--[Labor No] AS [Labor No],
	--[Item Group Code] AS [Item Group Code],
	--[(2) Customer Group Code] AS [(2) Customer Group Code],
	--[Service Advisor No_Archiv] AS [Service Advisor No_Archiv],
	--[Service Advisor No_oA] AS [Service Advisor No_oA],
	--[No_für_Archiv] AS [No_für_Archiv],
	--[First Name_für_Archiv] AS [First Name_für_Archiv],
	--[Last Name_für_Archiv] AS [Last Name_für_Archiv],
	--[(3) No] AS [(3) No],
	--[First Name] AS [First Name],
	--[Last Name] AS [Last Name],
	[Serviceberater] AS [Serviceberater],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Umsatzart] AS [Umsatzart],
	[Fabrikat] AS [Fabrikat],
	[Model] AS [Model],
	--[Fahrzeug] AS [Fahrzeug],
	--[Marke] AS [Marke],
	--[Service Posting Group_für_Archiv] AS [Service Posting Group_für_Archiv],
	--[Service Posting Group] AS [Service Posting Group],
	--[Auftragsart] AS [Auftragsart],
	--[Cust_Gr_Code] AS [Cust_Gr_Code],
	--[Cust_Gr_Description] AS [Cust_Gr_Description],
	[Kundenart] AS [Kundenart],
	--[Cust_No] AS [Cust_No],
	--[Cust_Name] AS [Cust_Name],
	[Kunde] AS [Kunde],
	--[Auftragsart_1] AS [Auftragsart_1],
	--[Function Code] AS [Function Code],
	--[Monteur] AS [Monteur_],
	[Umsatz Lohn] AS [Umsatz Lohn],
	--[Umsatz Teile Service_ori] AS [Umsatz Teile Service_ori],
	--[Umsatz Sonstiges_ori] AS [Umsatz Sonstiges_ori],
	--[Document No_Service_ledger] AS [Document No_Service_ledger],
	--[No_Service_ledger] AS [No_Service_ledger],
	--[Total Cost_Service_ledger] AS [Total Cost_Service_ledger],
	--[Anzahl Datensätze] AS [Anzahl Datensätze],
	[Umsatz Teile Service] AS [Umsatz Teile Service],
	--[Umsatz Sonstiges] AS [Umsatz Sonstiges],
	[Einsatz Teile Service] AS [Einsatz Teile Service],
	[verk Std] AS [verk Std],
	--[(2) Labor No] AS [(2) Labor No],
	--[Actual Time] AS [Actual Time],
	--[benutzte AW] AS [benutzte AW],
	[Invoice Date] AS [Bookkeep Date],
	--[Order Number] AS [Order Number],
	--[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[DG1] AS [DG1],
	--[DG2] AS [DG2],
	[DG] AS [DG],
	--[Order Number_Rg_Ausg_2] AS [Order Number_Rg_Ausg_2],
	--[Order Number_Rg_Ausg_1] AS [Order Number_Rg_Ausg_1],
	--[Charging Group No] AS [Charging Group No],
	--[ben  Zeit] AS [ben  Zeit],
	--[EW Lohn Basis (Std)] AS [EW Lohn Basis (Std)],
	--[EW Lohn] AS [EW Lohn],
	--[Cust_No_Verkaufskunde] AS [Cust_No_Verkaufskunde],
	--[Cust_Name_Verkaufskunde] AS [Cust_Name_Verkaufskunde],
	--[Cust_Group_Description_Verkaufskunde] AS [Cust_Group_Description_Verkaufskunde],
	--[Kundenart_Verkaufskunde] AS [Kundenart_Verkaufskunde],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	--[Auftragsposition] AS [Auftragsposition],
	--[Rabatt Lohn] AS [Rabatt Lohn],
	--[NL Teile_ori] AS [NL Teile_ori],
	--[Rabatt Teile] AS [Rabatt Teile],
	--[Hauptbetrieb_ID] AS [Hauptbetrieb_ID],
	--[Standort_ID] AS [Standort_ID],
	--[NL Lohn %] AS [NL Lohn %],
	--[Nachlass > 90 %] AS [Nachlass > 90 %],
	--[NL Teile %] AS [NL Teile %],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	[Order_Desc_30] AS [Order_Desc_30],
	[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Order_Desc_100] AS [Order_Desc_100],
	--[Invoice_Desc_100] AS [Invoice_Desc_100],
	--[Model_Desc] AS [Model_Desc],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[Fahrzeugalter] AS [Fahrzeugalter],
	--[FZG-Altersstaffel] AS [FZG-Altersstaffel],
	--[Repair_Group_Desc] AS [Repair_Group_Desc],
	--[DB1_><_EK] AS [DB1_><_EK],
	--[Rechnung_Gutschrift] AS [Rechnung_Gutschrift],
	--[Parts_Group_Desc] AS [Parts_Group_Desc],
	--[Parts_Make_Desc] AS [Parts_Make_Desc],
	--[Parts_Focus_Group] AS [Parts_Focus_Group],
	--[Post Code] AS [Post Code],
	[PLZ_1_Stelle] AS [PLZ_1_Stelle],
	[PLZ_2_Stelle] AS [PLZ_2_Stelle],
	[PLZ_3_Stelle] AS [PLZ_3_Stelle],
	[PLZ_4_Stelle] AS [PLZ_4_Stelle],
	[PLZ] AS [PLZ],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	[TÜV_Amount] AS [TÜV_Amount],
	[FL_Lack_Amount] AS [FL_Lack_Amount],
	[Mietw_Amount] AS [Mietw_Amount],
	[Umsatz_Sonst_Rest] AS [Umsatz_Sonst_Rest],
	[Kunde] AS [Kunde_PLZ],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	[Auftragsart Service/Teile] AS [Auftragsart Service/Teile],
	[Bereich Umsatz] AS [Bereich Umsatz] 
FROM [export_csv].[Service_Ausgangsrechnung_ab_2011]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Gutschriften_ab_2011]
AS
SELECT --[No] AS [No],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Bill-to Customer No] AS [Bill-to Customer No],
	--[Bill-to Name] AS [Bill-to Name],
	--[Bill-to Address] AS [Bill-to Address],
	--[Bill-to City] AS [Bill-to City],
	--[Posting Date] AS [Posting Date],
	--[Payment Terms Code] AS [Payment Terms Code],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Price Group Code] AS [Price Group Code],
	--[Prices Including Vat] AS [Prices Including Vat],
	--[Allow Quantity Disc] AS [Allow Quantity Disc],
	--[Salesperson Code] AS [Salesperson Code],
	--[On Hold] AS [On Hold],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Transaction Type] AS [Transaction Type],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	--[Sell-to Address] AS [Sell-to Address],
	--[Sell-to City] AS [Sell-to City],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[External Document No] AS [External Document No],
	--[Area] AS [Area],
	--[No Series] AS [No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	--[Service Order No_ohne_Einschränkung] AS [Service Order No_ohne_Einschränkung],
	--[Service Order No] AS [Service Order No],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model Code] AS [Model Code],
	--[Model No] AS [Model No],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[Line No] AS [Line No],
	--[Type] AS [Type],
	--[Description] AS [Description],
	--[Description 2] AS [Description 2],
	--[Quantity] AS [Quantity],
	--[Unit Price] AS [Unit Price],
	--[Unit Cost (lcy)] AS [Unit Cost (lcy)],
	--[Line Discount Amount] AS [Line Discount Amount],
	--[Amount] AS [Amount],
	--[Amount Including Vat] AS [Amount Including Vat],
	--[Inv Discount Amount] AS [Inv Discount Amount],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Unit Cost] AS [Unit Cost],
	--[Order No] AS [Order No],
	--[Order Line No] AS [Order Line No],
	--[Item Type] AS [Item Type],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[Service Order No_] AS [Service Order No_],
	--[Service Order Line No] AS [Service Order Line No],
	--[Labor No] AS [Labor No],
	--[Customer Group Code] AS [Customer Group Code],
	--[Item Group Code] AS [Item Group Code],
	--[Service Advisor No_Archiv] AS [Service Advisor No_Archiv],
	--[Service Advisor No_oA] AS [Service Advisor No_oA],
	--[No_für_Archiv] AS [No_für_Archiv],
	--[First Name_für_Archiv] AS [First Name_für_Archiv],
	--[Last Name_für_Archiv] AS [Last Name_für_Archiv],
	--[First Name] AS [First Name],
	--[Last Name] AS [Last Name],
	[Serviceberater] AS [Serviceberater],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Umsatzart] AS [Umsatzart],
	[Fabrikat] AS [Fabrikat],
	[Model] AS [Model],
	--[Fahrzeug] AS [Fahrzeug],
	--[Marke] AS [Marke],
	--[Service Posting Group_für_Archiv] AS [Service Posting Group_für_Archiv],
	--[Service Posting Group] AS [Service Posting Group],
	--[Auftragsart] AS [Auftragsart],
	--[Cust_Gr_Code] AS [Cust_Gr_Code],
	--[Cust_Gr_Description] AS [Cust_Gr_Description],
	[Kundenart] AS [Kundenart],
	--[Cust_No] AS [Cust_No],
	--[Cust_Name] AS [Cust_Name],
	[Kunde] AS [Kunde],
	--[Auftragsart_1] AS [Auftragsart_1],
	--[Function Code] AS [Function Code],
	--[Monteur] AS [Monteur_],
	[Umsatz Lohn] AS [Umsatz Lohn],
	--[Umsatz Teile Service_ori] AS [Umsatz Teile Service_ori],
	--[Umsatz Sonstiges_ori] AS [Umsatz Sonstiges_ori],
	--[Anzahl Datensätze] AS [Anzahl Datensätze],
	[Umsatz Teile Service] AS [Umsatz Teile Service],
	--[Umsatz Sonstiges] AS [Umsatz Sonstiges],
	[Einsatz Teile Service] AS [Einsatz Teile Service],
	[verk Std] AS [verk Std],
	--[ben Zeit] AS [ben Zeit],
	[Invoice Date] AS [Bookkeep Date],
	--[Order Number] AS [Order Number],
	--[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[DG1] AS [DG1],
	--[DG2] AS [DG2],
	[DG] AS [DG],
	--[Order Number_Rg_Ausg_2] AS [Order Number_Rg_Ausg_2],
	--[Order Number_Rg_Ausg_1] AS [Order Number_Rg_Ausg_1],
	--[Cust_No_Verkaufskunde] AS [Cust_No_Verkaufskunde],
	--[Cust_Name_Verkaufskunde] AS [Cust_Name_Verkaufskunde],
	--[Cust_Group_Description_Verkaufskunde] AS [Cust_Group_Description_Verkaufskunde],
	--[Kundenart_Verkaufskunde] AS [Kundenart_Verkaufskunde],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	--[Auftragsposition] AS [Auftragsposition],
	--[Rabatt Lohn] AS [Rabatt Lohn],
	--[NL Teile_ori] AS [NL Teile_ori],
	--[Rabatt Teile] AS [Rabatt Teile],
	--[Hauptbetrieb_ID] AS [Hauptbetrieb_ID],
	--[Standort_ID] AS [Standort_ID],
	--[NL Lohn %] AS [NL Lohn %],
	--[Nachlass > 90 %] AS [Nachlass > 90 %],
	--[NL Teile %] AS [NL Teile %],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	[Order_Desc_30] AS [Order_Desc_30],
	[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Model_Desc] AS [Model_Desc],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Fahrzeugalter] AS [Fahrzeugalter],
	--[FZG-Altersstaffel] AS [FZG-Altersstaffel],
	--[Repair_Group_Desc] AS [Repair_Group_Desc],
	--[Rechnung_Gutschrift] AS [Rechnung_Gutschrift],
	--[Parts_Focus_Group] AS [Parts_Focus_Group],
	--[Parts_Make_Desc] AS [Parts_Make_Desc],
	--[Parts_Group_Desc] AS [Parts_Group_Desc],
	--[Post Code] AS [Post Code],
	[PLZ_1_Stelle] AS [PLZ_1_Stelle],
	[PLZ_2_Stelle] AS [PLZ_2_Stelle],
	[PLZ_3_Stelle] AS [PLZ_3_Stelle],
	[PLZ_4_Stelle] AS [PLZ_4_Stelle],
	[PLZ] AS [PLZ],
	--[Order_Desc_100] AS [Order_Desc_100],
	--[Invoice_Desc_100] AS [Invoice_Desc_100],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	[TÜV_Amount] AS [TÜV_Amount],
	[FL_Lack_Amount] AS [FL_Lack_Amount],
	[Mietw_Amount] AS [Mietw_Amount],
	[Umsatz_Sonst_Rest] AS [Umsatz_Sonst_Rest],
	[Kunde] AS [Kunde_PLZ],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	--[Service_Order_No_Teile_Order_No] AS [Service_Order_No_Teile_Order_No],
	--[Code_Salesperson] AS [Code_Salesperson],
	--[Name_Salesperson] AS [Name_Salesperson],
	--[Serviceberater_Service] AS [Serviceberater_Service],
	--[Tage bis Rechnung] AS [Tage bis Rechnung],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	[Auftragsart Service/Teile] AS [Auftragsart Service/Teile],
	[Bereich Umsatz] AS [Bereich Umsatz] 
FROM [export_csv].[Service_Gutschriften_ab_2011]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Ausgangsrechnung_ab_2011_ben_AW]
AS
SELECT --[No] AS [No],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Bill-to Customer No] AS [Bill-to Customer No],
	--[Bill-to Name] AS [Bill-to Name],
	--[Bill-to Address] AS [Bill-to Address],
	--[Bill-to City] AS [Bill-to City],
	--[Order Date] AS [Order Date],
	--[Posting Date] AS [Posting Date],
	--[Payment Terms Code] AS [Payment Terms Code],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Price Group Code] AS [Price Group Code],
	--[Prices Including Vat] AS [Prices Including Vat],
	--[Allow Quantity Disc] AS [Allow Quantity Disc],
	--[Salesperson Code] AS [Salesperson Code],
	--[Order No] AS [Order No],
	--[On Hold] AS [On Hold],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Transaction Type] AS [Transaction Type],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	--[Sell-to Address] AS [Sell-to Address],
	--[Sell-to City] AS [Sell-to City],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[External Document No] AS [External Document No],
	--[Area] AS [Area],
	--[Shipping Agent Code] AS [Shipping Agent Code],
	--[No Series] AS [No Series],
	--[Order No Series] AS [Order No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	--[Service Order No] AS [Service Order No],
	--[Customer Group Code] AS [Customer Group Code],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[(2) Department Code] AS [(2) Department Code],
	--[(2) Make Code] AS [(2) Make Code],
	--[(2) Order No] AS [(2) Order No],
	--[(2) Order Type] AS [(2) Order Type],
	--[(2) Vin] AS [(2) Vin],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[(2) Customer Group Code] AS [(2) Customer Group Code],
	--[Service Advisor No_Archiv] AS [Service Advisor No_Archiv],
	--[Service Advisor No_oA] AS [Service Advisor No_oA],
	--[No_für_Archiv] AS [No_für_Archiv],
	--[First Name_für_Archiv] AS [First Name_für_Archiv],
	--[Last Name_für_Archiv] AS [Last Name_für_Archiv],
	--[(2) No] AS [(2) No],
	--[First Name] AS [First Name],
	--[Last Name] AS [Last Name],
	[Serviceberater] AS [Serviceberater],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Umsatzart] AS [Umsatzart],
	[Fabrikat] AS [Fabrikat],
	[Model] AS [Model],
	--[Fahrzeug] AS [Fahrzeug],
	--[Marke] AS [Marke],
	--[Service Posting Group_für_Archiv] AS [Service Posting Group_für_Archiv],
	--[Service Posting Group] AS [Service Posting Group],
	--[Auftragsart] AS [Auftragsart],
	--[Cust_Gr_Code] AS [Cust_Gr_Code],
	--[Cust_Gr_Description] AS [Cust_Gr_Description],
	[Kundenart] AS [Kundenart],
	--[Cust_No] AS [Cust_No],
	--[Cust_Name] AS [Cust_Name],
	[Kunde] AS [Kunde],
	--[Auftragsart_1] AS [Auftragsart_1],
	--[Function Code] AS [Function Code],
	--[Monteur] AS [Monteur_],
	[Invoice Date] AS [Bookkeep Date],
	--[Order Number] AS [Order Number],
	--[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[Order Number_Rg_Ausg_2] AS [Order Number_Rg_Ausg_2],
	--[Order Number_Rg_Ausg_1] AS [Order Number_Rg_Ausg_1],
	--[Cust_No_Verkaufskunde] AS [Cust_No_Verkaufskunde],
	--[Cust_Name_Verkaufskunde] AS [Cust_Name_Verkaufskunde],
	--[Cust_Group_Description_Verkaufskunde] AS [Cust_Group_Description_Verkaufskunde],
	--[Kundenart_Verkaufskunde] AS [Kundenart_Verkaufskunde],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	--[Duration Time Clock_Add_Service_Time_Clock_ims] AS [Duration Time Clock_Add_Service_Time_Clock_ims],
	--[(2) Monteur] AS [(2) Monteur],
	--[Auftragsposition] AS [Auftragsposition],
	[ben. AW_Time_Clock] AS [ben. AW_Time_Clock],
	--[ben Zeit] AS [ben Zeit],
	[Rechtseinheit_ID] AS [Rechtseinheit_ID],
	--[Standort_ID] AS [Standort_ID],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	--[Order_Desc_100] AS [Order_Desc_100],
	--[Invoice_Desc_100] AS [Invoice_Desc_100],
	[Order_Desc_30] AS [Order_Desc_30],
	[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Model_Desc] AS [Model_Desc],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[Fahrzeugalter] AS [Fahrzeugalter],
	--[FZG-Altersstaffel] AS [FZG-Altersstaffel],
	--[Repair_Group_Desc] AS [Repair_Group_Desc],
	--[Rechnung_Gutschrift] AS [Rechnung_Gutschrift],
	--[Parts_Focus_Group] AS [Parts_Focus_Group],
	--[Parts_Make_Desc] AS [Parts_Make_Desc],
	--[Parts_Group_Desc] AS [Parts_Group_Desc],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	[Auftragsart Service/Teile] AS [Auftragsart Service/Teile],
	[Bereich Umsatz] AS [Bereich Umsatz] 
FROM [export_csv].[Service_Ausgangsrechnung_ab_2011_ben_AW]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Gutschriften_ab_2011_ben_AW]
AS
SELECT --[No] AS [No],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Bill-to Customer No] AS [Bill-to Customer No],
	--[Bill-to Name] AS [Bill-to Name],
	--[Bill-to Address] AS [Bill-to Address],
	--[Bill-to City] AS [Bill-to City],
	--[Posting Date] AS [Posting Date],
	--[Payment Terms Code] AS [Payment Terms Code],
	--[Location Code] AS [Location Code],
	--[Department Code] AS [Department Code],
	--[Make Code] AS [Make Code],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Price Group Code] AS [Price Group Code],
	--[Prices Including Vat] AS [Prices Including Vat],
	--[Allow Quantity Disc] AS [Allow Quantity Disc],
	--[Salesperson Code] AS [Salesperson Code],
	--[On Hold] AS [On Hold],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Transaction Type] AS [Transaction Type],
	--[Sell-to Customer Name] AS [Sell-to Customer Name],
	--[Sell-to Address] AS [Sell-to Address],
	--[Sell-to City] AS [Sell-to City],
	--[Correction] AS [Correction],
	--[Document Date] AS [Document Date],
	--[External Document No] AS [External Document No],
	--[Area] AS [Area],
	--[No Series] AS [No Series],
	--[User Id] AS [User Id],
	--[Order Type] AS [Order Type],
	--[Service Order No_ohne_Einschränkung] AS [Service Order No_ohne_Einschränkung],
	--[Service Order No] AS [Service Order No],
	--[Branch Code] AS [Branch Code],
	--[Vin] AS [Vin],
	--[Model Code] AS [Model Code],
	--[Model No] AS [Model No],
	--[Model_ori] AS [Model_ori],
	--[Document No] AS [Document No],
	--[Order No] AS [Order No],
	--[Vehicle Status] AS [Vehicle Status],
	--[Registration Date] AS [Registration Date],
	--[Mileage] AS [Mileage],
	--[Service Order No_] AS [Service Order No_],
	--[Customer Group Code] AS [Customer Group Code],
	--[Service Advisor No_Archiv] AS [Service Advisor No_Archiv],
	--[Service Advisor No_oA] AS [Service Advisor No_oA],
	--[No_für_Archiv] AS [No_für_Archiv],
	--[First Name_für_Archiv] AS [First Name_für_Archiv],
	--[Last Name_für_Archiv] AS [Last Name_für_Archiv],
	--[First Name] AS [First Name],
	--[Last Name] AS [Last Name],
	[Serviceberater] AS [Serviceberater],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Umsatzart] AS [Umsatzart],
	[Fabrikat] AS [Fabrikat],
	[Model] AS [Model],
	--[Fahrzeug] AS [Fahrzeug],
	--[Marke] AS [Marke],
	--[Service Posting Group_für_Archiv] AS [Service Posting Group_für_Archiv],
	--[Service Posting Group] AS [Service Posting Group],
	--[Auftragsart] AS [Auftragsart],
	--[Cust_Gr_Code] AS [Cust_Gr_Code],
	--[Cust_Gr_Description] AS [Cust_Gr_Description],
	[Kundenart] AS [Kundenart],
	--[Cust_No] AS [Cust_No],
	--[Cust_Name] AS [Cust_Name],
	[Kunde] AS [Kunde],
	--[Auftragsart_1] AS [Auftragsart_1],
	[Invoice Date] AS [Bookkeep Date],
	--[Order Number] AS [Order Number],
	--[Order Number_Rg_Ausg] AS [Order Number_Rg_Ausg],
	--[Order Number_Rg_Ausg_2] AS [Order Number_Rg_Ausg_2],
	--[Order Number_Rg_Ausg_1] AS [Order Number_Rg_Ausg_1],
	--[Cust_No_Verkaufskunde] AS [Cust_No_Verkaufskunde],
	--[Cust_Name_Verkaufskunde] AS [Cust_Name_Verkaufskunde],
	--[Cust_Group_Description_Verkaufskunde] AS [Cust_Group_Description_Verkaufskunde],
	--[Kundenart_Verkaufskunde] AS [Kundenart_Verkaufskunde],
	--[Kunde_Verkaufskunde] AS [Kunde_Verkaufskunde],
	--[Duration Time Clock_Add_Service_Time_Clock_ims] AS [Duration Time Clock_Add_Service_Time_Clock_ims],
	--[Monteur] AS [Monteur_],
	--[Auftragsposition] AS [Auftragsposition],
	[ben. AW_Time_Clock] AS [ben. AW_Time_Clock],
	[Rechtseinheit_ID] AS [Rechtseinheit_ID],
	--[Standort_ID] AS [Standort_ID],
	--[Zuordnung_Funktion] AS [Zuordnung_Funktion],
	--[Cost_Centre_ID] AS [Cost_Centre_ID],
	--[Order_Desc_100] AS [Order_Desc_100],
	--[Invoice_Desc_100] AS [Invoice_Desc_100],
	[Order_Desc_30] AS [Order_Desc_30],
	[Invoice_Desc_30] AS [Invoice_Desc_30],
	--[Customer_Group_Owner] AS [Customer_Group_Owner],
	--[Customer_Name_Owner] AS [Customer_Name_Owner],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Model_Desc] AS [Model_Desc],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Fahrzeugalter_Tage] AS [Fahrzeugalter_Tage],
	--[Fahrzeugalter] AS [Fahrzeugalter],
	--[FZG-Altersstaffel] AS [FZG-Altersstaffel],
	--[Repair_Group_Desc] AS [Repair_Group_Desc],
	--[Rechnung_Gutschrift] AS [Rechnung_Gutschrift],
	--[Parts_Focus_Group] AS [Parts_Focus_Group],
	--[Parts_Make_Desc] AS [Parts_Make_Desc],
	--[Parts_Group_Desc] AS [Parts_Group_Desc],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	[Auftragsart Service/Teile] AS [Auftragsart Service/Teile],
	[Bereich Umsatz] AS [Bereich Umsatz] 
FROM [export_csv].[Service_Gutschriften_ab_2011_ben_AW]
GO

CREATE
	OR

ALTER VIEW [load].[Time_Clock_Entry]
AS
SELECT --[Entry No] AS [Entry No],
	--[Employee No] AS [Employee No],
	--[Resource No] AS [Resource No],
	--[Address No] AS [Address No],
	--[Date] AS [Date],
	--[Time] AS [Time],
	--[Sorting] AS [Sorting],
	--[Duration] AS [Duration],
	--[Task Type Code] AS [Task Type Code],
	--[Type] AS [Type],
	--[Linked To Entry No] AS [Linked To Entry No],
	--[Leaving] AS [Leaving],
	--[Service Order No] AS [Service Order No],
	--[Service Job No] AS [Service Job No],
	--[Service Line No] AS [Service Line No],
	--[Labor Standard Time Type] AS [Labor Standard Time Type],
	--[Approved] AS [Approved],
	--[Approved By Employee No] AS [Approved By Employee No],
	--[Approval Timestamp] AS [Approval Timestamp],
	--[Canceled] AS [Canceled],
	--[Canceled By User Id] AS [Canceled By User Id],
	--[Cancelation Timestamp] AS [Cancelation Timestamp],
	--[Created By User Id] AS [Created By User Id],
	--[Creation Timestamp] AS [Creation Timestamp],
	--[Productive] AS [Productive],
	--[Statistics Group] AS [Statistics Group],
	--[Considered As Working] AS [Considered As Working],
	--[Order Location Code] AS [Order Location Code],
	--[Resource Location Code] AS [Resource Location Code],
	--[Make Code] AS [Make Code],
	--[Branch Code] AS [Branch Code],
	--[Labor No] AS [Labor No],
	--[Description] AS [Description],
	--[Source Code] AS [Source Code],
	--[Efficiency] AS [Efficiency],
	--[Automatic] AS [Automatic],
	--[Passed] AS [Passed],
	--[Code_Task_Type] AS [Code_Task_Type],
	--[Description_Task_Type] AS [Description_Task_Type],
	--[No_Employee_T] AS [No_Employee_T],
	--[Name_Employee_T] AS [Name_Employee_T],
	--[Last Name_Employee_T] AS [Last Name_Employee_T],
	--[First Name_Employee_T] AS [First Name_Employee_T],
	--[Group No 1_Employee_T] AS [Group No 1_Employee_T],
	--[Group No 2_Employee_T] AS [Group No 2_Employee_T],
	--[Group No 3_Employee_T] AS [Group No 3_Employee_T],
	--[Leaving Date_Employee_T] AS [Leaving Date_Employee_T],
	--[produktiv/unproduktiv] AS [produktiv/unproduktiv],
	[Monteur] AS [Monteur],
	--[Monteur_Gruppe_ori] AS [Monteur_Gruppe_ori],
	--[Tage Heute Leaving Date] AS [Tage Heute Leaving Date],
	[Monteur_Gruppe_2] AS [Monteur_Gruppe_2],
	[Datum] AS [Bookkeep Date],
	--[Monatserster] AS [Monatserster],
	--[Monatsletzter] AS [Monatsletzter],
	--[Heute] AS [Heute],
	--[Datum Tagesbericht] AS [Datum Tagesbericht],
	[Hauptbetrieb_ID] AS [Hauptbetrieb],
	--[Standort] AS [Standort_],
	[prod.] AS [prod.],
	[unprod.] AS [unprod.],
	[Abw.] AS [Abw.],
	--[produktiv_für_Berechnung_LG] AS [produktiv_für_Berechnung_LG],
	--[Servicemobil] AS [Servicemobil],
	--[krank] AS [krank],
	--[Meistervertr.] AS [Meistervertr.],
	[Activity_Desc] AS [Activity_Desc],
	[Standort_ID] AS [Standort],
	[Monteur_Gruppe] AS [Monteur_Gruppe],
	--[Department No] AS [Department No],
	--[Order Number] AS [Order Number],
	--[Task Type Group] AS [Task Type Group],
	--[Extern] AS [Extern],
	--[Intern] AS [Intern],
	--[Home Page 2] AS [Home Page 2] 
FROM [export_csv].[Time_Clock_Entry]
GO

CREATE
	OR

ALTER VIEW [load].[Zeit_2_Ryma]
AS
SELECT --[Employee No] AS [Employee No],
	[Datum] AS [Bookkeep Date],
	--[Department No_ori] AS [Department No_ori],
	--[Time Account No] AS [Time Account No],
	--[Time Account Value] AS [Time Account Value],
	--[Ta Class (general)] AS [Ta Class (general)],
	--[Ta Class (statistics)] AS [Ta Class (statistics)],
	--[Ta Class (absent Days)] AS [Ta Class (absent Days)],
	--[Ta Class (time Processing)] AS [Ta Class (time Processing)],
	--[Ta Class (individual)] AS [Ta Class (individual)],
	--[Ta Class (employee Info)] AS [Ta Class (employee Info)],
	--[Ta Class (vacation Reduction)] AS [Ta Class (vacation Reduction)],
	--[Ta Formatting] AS [Ta Formatting],
	--[Generating Function] AS [Generating Function],
	--[Record Protected] AS [Record Protected],
	--[No] AS [No],
	--[Description] AS [Description],
	--[Description 2] AS [Description 2],
	--[Zeitdauer_ori] AS [Zeitdauer_ori],
	--[Zeitdauer] AS [Zeitdauer],
	--[gesamt Stunden] AS [gesamt Stunden],
	--[krank] AS [krank],
	--[Wehr- /Zivildienst] AS [Wehr- /Zivildienst],
	--[Sonderurlaub] AS [Sonderurlaub],
	--[Berufsschule] AS [Berufsschule],
	--[Innung Azubi] AS [Innung Azubi],
	--[Feiertag] AS [Feiertag],
	--[Schulung extern] AS [Schulung extern],
	--[Urlaub] AS [Urlaub],
	--[W-fix Stunden] AS [W-fix Stunden],
	[Hauptbetrieb_ID] AS [Hauptbetrieb],
	--[Standort] AS [Standort-],
	--[First Name] AS [First Name],
	--[Last Name] AS [Last Name],
	--[Monteur_Gruppe_ori] AS [Monteur_Gruppe_ori],
	--[Abteilung] AS [Abteilung],
	--[Order Number] AS [Order Number],
	[Monteur] AS [Monteur],
	--[Zeitausgleich] AS [Zeitausgleich],
	--[Überstunden] AS [Überstunden],
	--[Leaving Date] AS [Leaving Date],
	--[Group No 1] AS [Group No 1],
	--[Group No 2] AS [Group No 2],
	--[Group No 3] AS [Group No 3],
	--[Tage Heute Leaving Date] AS [Tage Heute Leaving Date],
	[Monteur_Gruppe] AS [Monteur_Gruppe],
	--[produktiv/unproduktiv] AS [produktiv/unproduktiv],
	--[Monatserster] AS [Monatserster],
	--[Monatsletzter] AS [Monatsletzter],
	--[Heute] AS [Heute],
	--[Datum Tagesbericht] AS [Datum Tagesbericht],
	--[Employment Date] AS [Employment Date],
	--[Department No] AS [Department No],
	--[Datum_Monteurlisten] AS [Datum_Monteurlisten],
	--[Fehlzeiten genehm./ungenem.] AS [Fehlzeiten genehm./ungenem.],
	[Activity Desc] AS [Activity_Desc],
	[Monteur_Gruppe_2] AS [Monteur_Gruppe_2],
	[Standort_ID] AS [Standort],
	--[Task Type Group] AS [Task Type Group],
	--[Sollzeit] AS [Sollzeit],
	[abwesend] AS [Abw.],
	--[Home Page 2] AS [Home Page 2],
	--[Summe Sollzeit] AS [Summe Sollzeit] 
FROM [export_csv].[Zeit_2_Ryma]
GO

CREATE
	OR

ALTER VIEW [load].[Add_Serv_Ledger_Entry_fakt_AW_Monteur]
AS
SELECT --[Order No] AS [Order No],
	--[Document No] AS [Document No],
	--[No] AS [No],
	--[Description] AS [Description],
	--[Res Efficiency Level] AS [Res Efficiency Level],
	--[Source Code] AS [Source Code],
	--[Qty Evaluated] AS [Qty Evaluated],
	--[Portion] AS [Portion],
	--[Cust Split Portion] AS [Cust Split Portion],
	--[Service Job No] AS [Service Job No],
	--[Quantity] AS [Quantity],
	--[Entry No] AS [Entry No],
	[fakt. Stunden] AS [fakt. Stunden],
	--[Qty (hour)] AS [Qty (hour)],
	--[Standard Time] AS [Standard Time],
	--[Standard Time Type] AS [Standard Time Type],
	--[Standard_Time_Portion] AS [Standard_Time_Portion],
	--[Vorgabezeit incl. AZ] AS [Vorgabezeit incl. AZ],
	[Monteur] AS [Monteur],
	--[Order Number] AS [Order Number],
	--[Bill-to Name] AS [Bill-to Name],
	--[Posting Date] AS [Posting Date],
	[Datum] AS [Bookkeep Date],
	--[Auftrag_Kunde] AS [Auftrag_Kunde],
	--[Minimum_Datum_Auftrag] AS [Minimum_Datum_Auftrag],
	--[Datum_Monteurlisten] AS [Datum_Monteurlisten],
	--[Group No 1] AS [Group No 1],
	--[Group No 2] AS [Group No 2],
	--[Group No 3] AS [Group No 3],
	--[produktiv/unproduktiv] AS [produktiv/unproduktiv],
	--[Monteur_Gruppe_ori] AS [Monteur_Gruppe_ori],
	--[Leaving Date] AS [Leaving Date],
	[Monteur_Gruppe] AS [Monteur_Gruppe],
	[Hauptbetrieb_ID] AS [Hauptbetrieb],
	--[Location Code] AS [Location Code],
	--[Standort] AS [Standort_],
	--[Department No_Employee_T] AS [Department No_Employee_T],
	[Standort_ID] AS [Standort],
	--[Function Code] AS [Function Code],
	--[Task Type Group] AS [Task Type Group],
	[Monteur_Gruppe_2] AS [Monteur_Gruppe_2],
	--[Quantity_Service_Ledger_Entry] AS [Quantity_Service_Ledger_Entry],
	--[Unit Price_Service_Ledger_Entry] AS [Unit Price_Service_Ledger_Entry],
	--[Total Price_Service_Ledger_Entry] AS [Total Price_Service_Ledger_Entry],
	--[Umsatz Lohn_zwischen] AS [Umsatz Lohn_zwischen],
	--[Umsatz Lohn] AS [Umsatz Lohn_],
	--[Discount Amount] AS [Discount Amount],
	--[Nachlass_zwischen] AS [Nachlass_zwischen],
	--[Nachlass] AS [Nachlass],
	--[Home Page 2] AS [Home Page 2] 
FROM [export_csv].[Add_Serv_Ledger_Entry_fakt_AW_Monteur]
GO

CREATE
	OR

ALTER VIEW [load].[Stempelzeiten_Monteurlisten_aus_ims]
AS
SELECT --[Entry No] AS [Entry No],
	--[Employee No] AS [Employee No],
	--[Resource No] AS [Resource No],
	--[Address No] AS [Address No],
	--[Date] AS [Date],
	--[Time] AS [Time],
	--[Sorting] AS [Sorting],
	--[Duration] AS [Duration],
	--[Task Type Code] AS [Task Type Code],
	--[Type] AS [Type],
	--[Linked To Entry No] AS [Linked To Entry No],
	--[Leaving] AS [Leaving],
	--[Service Order No] AS [Service Order No],
	--[Service Job No] AS [Service Job No],
	--[Service Line No] AS [Service Line No],
	--[Labor Standard Time Type] AS [Labor Standard Time Type],
	--[Approved] AS [Approved],
	--[Approved By Employee No] AS [Approved By Employee No],
	--[Approval Timestamp] AS [Approval Timestamp],
	--[Canceled] AS [Canceled],
	--[Canceled By User Id] AS [Canceled By User Id],
	--[Cancelation Timestamp] AS [Cancelation Timestamp],
	--[Created By User Id] AS [Created By User Id],
	--[Creation Timestamp] AS [Creation Timestamp],
	--[Productive] AS [Productive],
	--[Statistics Group] AS [Statistics Group],
	--[Considered As Working] AS [Considered As Working],
	--[Order Location Code] AS [Order Location Code],
	--[Resource Location Code] AS [Resource Location Code],
	--[Make Code] AS [Make Code],
	--[Branch Code] AS [Branch Code],
	--[Labor No] AS [Labor No],
	--[Description] AS [Description],
	--[Source Code] AS [Source Code],
	--[Efficiency] AS [Efficiency],
	--[Automatic] AS [Automatic],
	--[Passed] AS [Passed],
	--[Code] AS [Code],
	--[Description2] AS [Description2],
	--[No] AS [No],
	--[Name] AS [Name],
	--[Last Name] AS [Last Name],
	--[First Name] AS [First Name],
	--[Group No 1] AS [Group No 1],
	--[Group No 2] AS [Group No 2],
	--[Leaving Date] AS [Leaving Date],
	--[Produktiv/unproduktiv] AS [Produktiv/unproduktiv],
	[Monteur] AS [Monteur],
	--[Tage Heute Leaving Date] AS [Tage Heute Leaving Date],
	[Monteur_Gruppe_2] AS [Monteur_Gruppe_2],
	--[Datum_Stempelung] AS [Datum_Stempelung],
	--[Monatserster] AS [Monatserster],
	--[Monatsletzter] AS [Monatsletzter],
	--[Heute] AS [Heute],
	--[Datum Tagesbericht] AS [Datum Tagesbericht],
	[Hauptbetrieb_ID] AS [Hauptbetrieb],
	[Standort_ID] AS [Standort],
	[Produktiv Für Berechnung Lg_Monteurlisten] AS [Summe Produktiv Monteur Auftrag],
	[Datum] AS [Bookkeep Date],
	--[Order Number] AS [Order Number],
	[Monteur_Gruppe] AS [Monteur_Gruppe],
	--[Department No] AS [Department No],
	--[Task Type Group] AS [Task Type Group],
	--[Home Page 2] AS [Home Page 2] 
FROM [export_csv].[Stempelzeiten_Monteurlisten_aus_ims]
GO