ETL_DWH_ARI/schema/GC_DWH_ARI/tables/Verkauf.sql

CREATE TABLE [dbo].[Verkauf] (
   [Client_DB] [varchar](20) NULL,
   [Konto-Nr] [varchar](20) NULL,
   [Amount] [decimal](28,8) NULL,
   [Betrag] [decimal](28,8) NULL,
   [Summe Betrag] [decimal](28,8) NULL,
   [Summe Erlös FZG] [decimal](28,8) NULL,
   [Branch Code] [varchar](20) NULL,
   [Location Code] [varchar](20) NULL,
   [Vin] [varchar](20) NULL,
   [Book No] [varchar](20) NULL,
   [Vehicle Status] [varchar](10) NULL,
   [Old Vehicle Status] [varchar](10) NULL,
   [Make Code_Vehicle] [varchar](20) NULL,
   [Model] [varchar](20) NULL,
   [Modellbez] [varchar](50) NULL,
   [Vat Prod Posting Group] [varchar](20) NULL,
   [Inventory Posting Group] [varchar](20) NULL,
   [Fahrzeugart] [varchar](20) NULL,
   [Fahrzeugtyp] [varchar](20) NULL,
   [FZG] [varchar](316) NULL,
   [VB_Einkauf] [varchar](100) NULL,
   [Standtage_ori] [decimal](28,8) NULL,
   [Standtagestaffel] [varchar](20) NULL,
   [Standtage] [decimal](28,8) NULL,
   [Invoice Date] [datetime] NULL,
   [Kunde] [varchar](200) NOT NULL,
   [Kundenart] [varchar](50) NOT NULL,
   [Kunde_FZG_Dashboard] [varchar](200) NOT NULL,
   [Kunde_FZG] [varchar](200) NOT NULL,
   [Vorbesitzer] [varchar](200) NULL,
   [Verkäufer] [varchar](100) NOT NULL,
   [Beleg] [varchar](200) NULL,
   [FZG_Detail] [varchar](425) NOT NULL,
   [Konto] [varchar](100) NULL,
   [Menge] [decimal](28,8) NULL,
   [Tag] [int] NULL,
   [Monat] [int] NULL,
   [Jahr] [int] NULL,
   [Bereich Umsatz] [varchar](20) NULL,
   [Ebene1] [varchar](50) NULL,
   [Ebene2] [varchar](50) NULL,
   [Ebene3] [varchar](50) NULL,
   [Ebene4] [varchar](50) NULL,
   [Ebene5] [varchar](50) NULL,
   [Erlös FZG] [decimal](28,8) NULL,
   [Einsatz FZG] [decimal](28,8) NULL,
   [Boni] [decimal](28,8) NULL,
   [Instandsetz. ges.] [decimal](28,8) NULL,
   [Fabrikat] [varchar](20) NULL,
   [Fabrikat_Sortierung] [int] NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Datum] [date] NULL,
   [Jahr/Monat] [varchar](20) NULL,
   [Aktueller Tag] [date] NULL,
   [Monatserster] [date] NULL,
   [Monatsletzter] [date] NULL,
   [MUN_DATE] [varchar](100) NULL,
   [Mitgliedsname] [varchar](50) NULL,
   [Beginn Geschäftsjahr] [date] NULL,
   [Monat_Jahr] [varchar](20) NULL,
   [Monat_kurz] [nvarchar](4000) NULL

)

CREATE NONCLUSTERED INDEX [Verkauf_Datum] ON [dbo].[Verkauf] ([Datum])
CREATE NONCLUSTERED INDEX [Verkauf_Monatserster] ON [dbo].[Verkauf] ([Monatserster])

GO