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

CREATE TABLE [import].[Vehicle_Option] (
   [timestamp] [binary](8) NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Line No_] [int] NOT NULL,
   [Make Code] [varchar](10) NOT NULL,
   [Model No_] [varchar](20) NOT NULL,
   [Option Code] [varchar](20) NOT NULL,
   [Internal Code] [varchar](10) NOT NULL,
   [Option Type] [int] NOT NULL,
   [Short Description] [varchar](10) NOT NULL,
   [Description] [varchar](30) NOT NULL,
   [Description 2] [varchar](30) NOT NULL,
   [Unit Price] [decimal](38,20) NOT NULL,
   [Unit Cost] [decimal](38,20) NOT NULL,
   [Total Price] [decimal](38,20) NOT NULL,
   [Total Cost] [decimal](38,20) NOT NULL,
   [Purchase Discount Amount] [decimal](38,20) NOT NULL,
   [Purchase Discount %] [decimal](38,20) NOT NULL,
   [Bill of Materials] [tinyint] NOT NULL,
   [Series Option] [tinyint] NOT NULL,
   [Built-in Date] [datetime] NOT NULL,
   [Type] [int] NOT NULL,
   [Quantity] [decimal](38,20) NOT NULL,
   [Copy-to Setting] [int] NOT NULL,
   [Sorting] [int] NOT NULL,
   [Total Price Incl_ VAT] [decimal](38,20) NOT NULL,
   [VAT %] [decimal](38,20) NOT NULL,
   [VAT Base Amount] [decimal](38,20) NOT NULL,
   [Differential Taxation] [tinyint] NOT NULL,
   [List Price] [decimal](38,20) NOT NULL,
   [List Price Incl_ VAT] [decimal](38,20) NOT NULL,
   [Inventory Posting Group] [varchar](10) NOT NULL,
   [Gen_ Product Posting Group] [varchar](10) NOT NULL,
   [Service Order No_] [varchar](20) NOT NULL,
   [Radio Code] [varchar](20) NOT NULL,
   [Option Class] [varchar](20) NOT NULL,
   [Search Internal Code] [tinyint] NOT NULL,
   [Replaced Option Code] [varchar](20) NOT NULL,
   [Replaced Internal Code] [varchar](10) NOT NULL,
   [Corrected on] [datetime] NOT NULL,
   [Corrected at] [datetime] NOT NULL,
   [Belongs To Model Line] [varchar](20) NOT NULL,
   [Emission Relevant] [tinyint] NOT NULL,
   [SA2 Transfer] [tinyint] NULL,
   [SPS Transfer] [tinyint] NULL,
   [GWM Transfer] [tinyint] NULL,
   [Client_DB] [varchar](50) NOT NULL
      CONSTRAINT [DF__Vehicle_O__Clien__671F4F74] DEFAULT ('1')

   ,CONSTRAINT [Vehicle Option$0] PRIMARY KEY CLUSTERED ([timestamp], [VIN], [Line No_], [Client_DB])
)


GO