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

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Invoice 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].[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],
	--[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] AS [Fahrzeugtyp],
	[FZG] AS [FZG],
	--[Fahrzeugtyp_alt] AS [Fahrzeugtyp_alt],
	--[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 [Invoice 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],
	--[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],
	[Einsatz] AS [Einsatz],
	--[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],
	[No] + ' - ' + [Name] AS [Konto],
	--[Anz. Sätze] AS [Anz. Sätze],
	[Menge_final] AS [Menge_final],
	--[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] 
FROM [export_csv].[NW_GW_VK_TIM]
GO

CREATE
	OR

ALTER VIEW [load].[NW_GW_VK_TIM_Grosskd]
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_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] AS [Fahrzeugtyp],
	[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 [Invoice 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],
	--[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],
	[Einsatz] AS [Einsatz],
	--[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],
	--[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],
	[Menge_final] AS [Menge_final],
	[No] + ' - ' + [Name] AS [Konto],
	--[No_Item] AS [No_Item],
	--[Description_Item] AS [Description_Item],
	--[Vehicle Type Code_Item] AS [Vehicle Type Code_Item] 
FROM [export_csv].[NW_GW_VK_TIM_Grosskd]
GO