CREATE TABLE [dbo].[Fahrzeug_Bestand] ( [Client_DB] [varchar](20) NULL, [Modellbez] [varchar](50) NULL, [FZG] [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] [varchar](10) NULL, [Hauptbetrieb_ID] [varchar](20) NULL, [Hauptbetrieb_Name] [varchar](50) NULL, [Standort_ID] [varchar](20) NULL, [Standort_Name] [varchar](50) NULL ) GO