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

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