C11/System/NAVISION/SQL/schema/NAVISION_BYD/tables/import.Vehicle.sql

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