CREATE TABLE [import].[Vehicle] ( [timestamp] [binary](8) NOT NULL, [VIN] [varchar](20) NOT NULL, [Vehicle Status] [int] NOT NULL, [Model] [varchar](50) NOT NULL, [Search Description] [varchar](30) NOT NULL, [Type] [varchar](30) NOT NULL, [Class] [varchar](10) NOT NULL, [Unit of Measure Code] [varchar](10) NOT NULL, [Model No_] [varchar](20) NOT NULL, [Statistics Group] [int] NOT NULL, [Unit Price] [decimal](38,20) NOT NULL, [Price_Profit Calculation] [int] NOT NULL, [Profit %] [decimal](38,20) NOT NULL, [Unit Cost] [decimal](38,20) NOT NULL, [Standard Cost] [decimal](38,20) NOT NULL, [Last Direct Cost] [decimal](38,20) NOT NULL, [Average Cost] [decimal](38,20) NOT NULL, [Minimum Unit Price] [decimal](38,20) NOT NULL, [Indirect Cost %] [decimal](38,20) NOT NULL, [Vendor No_] [varchar](20) NOT NULL, [Vendor Item No_] [varchar](20) NOT NULL, [Lead Time Calculation] [varchar](32) NOT NULL, [Unit List Price] [decimal](38,20) NOT NULL, [Gross Weight] [decimal](38,20) NOT NULL, [Net Weight] [decimal](38,20) NOT NULL, [Tariff No_] [varchar](20) NOT NULL, [Duty Unit Conversion] [decimal](38,20) NOT NULL, [Country Purchased Code] [varchar](10) NOT NULL, [Blocked] [tinyint] NOT NULL, [Last Date Modified] [datetime] NOT NULL, [Location Code] [varchar](10) NOT NULL, [Price Includes VAT] [tinyint] NOT NULL, [VAT Bus_ Posting Gr_ (Price)] [varchar](10) NOT NULL, [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL, [Picture] [image] NULL, [VAT Prod_ Posting Group] [varchar](10) NOT NULL, [Country of Origin Code] [varchar](10) NOT NULL, [No_ Series] [varchar](10) NOT NULL, [Department Code] [varchar](10) NOT NULL, [Make Code] [varchar](10) NOT NULL, [Variant Code] [varchar](10) NOT NULL, [Customer No_] [varchar](20) NOT NULL, [License No_] [varchar](30) NOT NULL, [Mileage] [decimal](38,20) NOT NULL, [Annual Mileage] [decimal](38,20) NOT NULL, [Prod_ Year] [datetime] NOT NULL, [Initial Registration] [datetime] NOT NULL, [No_ of Previous Owners] [int] NOT NULL, [Registration Certificate] [varchar](20) NOT NULL, [Data Processing No_] [varchar](10) NOT NULL, [Engine Code] [varchar](10) NOT NULL, [Engine No_] [varchar](20) NOT NULL, [Key No_] [varchar](20) NOT NULL, [Vehicle Category Code] [varchar](10) NOT NULL, [Emissions Test Category Code] [varchar](10) NOT NULL, [Cylinder Capacity (ccm)] [decimal](38,20) NOT NULL, [Vehicle Type Code] [varchar](10) NOT NULL, [Labor Type] [varchar](30) NOT NULL, [Federal Office Manufacturer ID] [varchar](10) NOT NULL, [KBA Type] [varchar](10) NOT NULL, [Customer Registration Date] [datetime] NOT NULL, [Creation Date] [datetime] NOT NULL, [Model Code] [varchar](20) NOT NULL, [Transmission Type Code] [varchar](20) NOT NULL, [Engine Type Code] [varchar](20) NOT NULL, [Market Segment Code] [varchar](10) NOT NULL, [No_ of Cylinders] [int] NOT NULL, [Power (kW)] [int] NOT NULL, [Power (hp)] [int] NOT NULL, [Tires] [varchar](15) NOT NULL, [Empty Weight (kg)] [decimal](38,20) NOT NULL, [Total Weight (kg)] [decimal](38,20) NOT NULL, [Roof Load (kg)] [decimal](38,20) NOT NULL, [Trailer Load (kg)] [decimal](38,20) NOT NULL, [Trailer Tongue Load (kg)] [decimal](38,20) NOT NULL, [4WD] [tinyint] NOT NULL, [No_ of Axles] [int] NOT NULL, [Wheel Distance (mm)] [decimal](38,20) NOT NULL, [Front Axle Load (kg)] [int] NOT NULL, [Rear Axle Load (kg)] [int] NOT NULL, [Deregistration Date] [datetime] NOT NULL, [No_ of Doors] [int] NOT NULL, [Dealer Status] [varchar](10) NOT NULL, [Own Sale] [tinyint] NOT NULL, [Purchase Date] [datetime] NOT NULL, [Neg_ Adjmt_ Date] [datetime] NOT NULL, [Current Branch Book No_] [varchar](20) NOT NULL, [Import Vehicle] [tinyint] NOT NULL, [Old Vehicle Status] [int] NOT NULL, [Old Customer No_] [varchar](20) NOT NULL, [Old Sales Date] [datetime] NOT NULL, [Old Own Sale] [tinyint] NOT NULL, [Address No_] [int] NOT NULL, [Old Book No_] [varchar](20) NOT NULL, [Old Branch Book No_] [varchar](20) NOT NULL, [Purchase Receipt Date] [datetime] NOT NULL, [Inventory Posting Group] [varchar](10) NOT NULL, [Text 1] [varchar](50) NOT NULL, [Text 2] [varchar](50) NOT NULL, [Yes_No] [tinyint] NULL, [Yes_No 2] [tinyint] NOT NULL, [Date 1] [datetime] NULL, [Date 2] [datetime] NOT NULL, [Extra Code 1] [varchar](10) NOT NULL, [Extra Code 2] [varchar](10) NOT NULL, [Text 3] [varchar](50) NOT NULL, [Text 4] [varchar](50) NOT NULL, [Current Book No_] [varchar](20) NOT NULL, [Gross Profit (LCY)] [decimal](38,20) NOT NULL, [Gross Profit %] [decimal](38,20) NOT NULL, [Date of Sale] [datetime] NOT NULL, [Current Price Sticker] [int] NOT NULL, [Manual Price Calculation] [tinyint] NOT NULL, [Labor Charging Code] [varchar](10) NOT NULL, [Schwacke Code] [varchar](8) NULL, [Bin Code] [varchar](10) NOT NULL, [Last Time Modified] [datetime] NOT NULL, [Fabrication Code] [varchar](20) NOT NULL, [Inverse VIN] [varchar](20) NOT NULL, [Vendor Purch_ Order No_] [varchar](20) NOT NULL, [SA3 Usage] [tinyint] NOT NULL, [SA3 VAT Key ID] [int] NOT NULL, [SA3 VAT Registered] [tinyint] NOT NULL, [Warranty Add-On Contract Type] [varchar](20) NOT NULL, [License No_ Compressed] [varchar](20) NOT NULL, [Ready for Sale] [datetime] NOT NULL, [Bulkcust_ Business] [tinyint] NULL, [Purchaser Code] [varchar](10) NULL, [Salesperson Code] [varchar](10) NULL, [Reserved for] [varchar](20) NULL, [SPS Status] [int] NULL, [Date of Sales Shipment] [datetime] NULL, [GA-Programm] [int] NULL, [No SPS Transfer] [tinyint] NULL, [Next WMZ] [datetime] NOT NULL, [City Consumption] [decimal](38,20) NOT NULL, [Long-Distance Consumption] [decimal](38,20) NOT NULL, [Fuel Consumption Combined] [decimal](38,20) NOT NULL, [CO2 Emission Combined] [decimal](38,20) NOT NULL, [CO2 Emission City] [decimal](38,20) NOT NULL, [CO2 Emission Long-Distance] [decimal](38,20) NOT NULL, [PM Emission] [decimal](38,20) NOT NULL, [Particle Mass] [decimal](38,20) NOT NULL, [NOx Emission] [decimal](38,20) NOT NULL, [THC Emission] [decimal](38,20) NOT NULL, [NMHC Emission] [decimal](38,20) NOT NULL, [HC + NOx Emission] [decimal](38,20) NOT NULL, [Planned TKP Export] [tinyint] NULL, [Last TKP Export] [datetime] NULL, [Auto Planned TKP Export] [tinyint] NULL, [Prospect No_] [varchar](20) NULL, [Availability State] [varchar](10) NULL, [Eurotax ID] [varchar](20) NULL, [Auto Planned RSP Export] [tinyint] NULL, [OldMileage] [int] NULL, [Product Type] [int] NULL, [RSP TradeInChannel] [varchar](50) NULL, [Client_DB] [varchar](50) NOT NULL CONSTRAINT [DF__Vehicle__Client___65370702] DEFAULT ('1') ,CONSTRAINT [Vehicle$0] PRIMARY KEY CLUSTERED ([timestamp], [VIN], [Client_DB]) ) GO