ETL_DWH_ARI/schema/GC_DWH_ARI/tables/Fahrzeug_Bestand.sql

CREATE TABLE [dbo].[Fahrzeug_Bestand] (
   [Client_DB] [varchar](20) NULL,
   [Modellbez] [varchar](50) NULL,
   [FZG] [varchar](100) NULL,
   [VIN] [varchar](100) NULL,
   [Location Code] [varchar](20) NULL,
   [VB_Einkauf] [varchar](20) NULL,
   [Standtage_ori] [decimal](28,8) NULL,
   [EZ/Eingang] [varchar](20) NULL,
   [Farbe] [varchar](50) NULL,
   [Einsatz] [decimal](28,8) NULL,
   [Invoice Date] [datetime] NULL,
   [Standtage] [decimal](28,8) NULL,
   [gepl. VK] [decimal](28,8) NULL,
   [Händlerstatus] [varchar](20) NULL,
   [UPE] [decimal](28,8) NULL,
   [Model] [varchar](50) NULL,
   [Standtagestaffel] [varchar](50) NULL,
   [Tage letzte Preisänderung_ori] [decimal](28,8) NULL,
   [Tage seit Erstzul.] [decimal](28,8) NULL,
   [Tag_Dashboard] [decimal](28,8) NULL,
   [Monat_Dashboard] [decimal](28,8) NULL,
   [Jahr_Dashboard] [decimal](28,8) NULL,
   [Fahrzeugart] [varchar](20) NULL,
   [Fahrzeugtyp] [varchar](20) 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
)


GO