CREATE TABLE [import].[Item] ( [timestamp] [binary](8) NOT NULL, [No_] [varchar](30) NOT NULL, [No_ 2] [varchar](20) NOT NULL, [Description] [varchar](50) NOT NULL, [Search Description] [varchar](50) NOT NULL, [Description 2] [varchar](50) NOT NULL, [Class] [varchar](10) NOT NULL, [Base Unit of Measure] [varchar](10) NOT NULL, [Price Unit Conversion] [int] NOT NULL, [Inventory Posting Group] [varchar](30) NOT NULL, [Shelf No_] [varchar](10) NOT NULL, [Sales Qty_ Disc_ Code] [varchar](30) NOT NULL, [Cust__Item Disc_ Gr_] [varchar](10) NOT NULL, [Allow Invoice Disc_] [tinyint] NOT NULL, [Statistics Group] [int] NOT NULL, [Commission Group] [int] NOT NULL, [Unit Price] [decimal](38,20) NOT NULL, [Price_Profit Calculation] [int] NOT NULL, [Profit %] [decimal](38,20) NOT NULL, [Costing Method] [int] 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, [Reorder Point] [decimal](38,20) NOT NULL, [Maximum Inventory] [decimal](38,20) NOT NULL, [Reorder Quantity] [decimal](38,20) NOT NULL, [Alternative Item No_] [varchar](20) NOT NULL, [Unit List Price] [decimal](38,20) NOT NULL, [Duty Due %] [decimal](38,20) NOT NULL, [Duty Code] [varchar](10) NOT NULL, [Gross Weight] [decimal](38,20) NOT NULL, [Net Weight] [decimal](38,20) NOT NULL, [Units per Parcel] [decimal](38,20) NOT NULL, [Unit Volume] [decimal](38,20) NOT NULL, [Durability] [varchar](10) NOT NULL, [Freight Type] [varchar](10) NOT NULL, [Tariff No_] [varchar](20) NOT NULL, [Duty Unit Conversion] [decimal](38,20) NOT NULL, [Country Purchased Code] [varchar](10) NOT NULL, [Budget Quantity] [decimal](38,20) NOT NULL, [Budgeted Amount] [decimal](38,20) NOT NULL, [Budget Profit] [decimal](38,20) NOT NULL, [Blocked] [tinyint] NOT NULL, [Last Date Modified] [datetime] 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, [Country of Origin Code] [varchar](10) NOT NULL, [Automatic Ext_ Texts] [tinyint] NOT NULL, [No_ Series] [varchar](10) NOT NULL, [Tax Group Code] [varchar](10) NOT NULL, [VAT Prod_ Posting Group] [varchar](10) NOT NULL, [Reserve] [int] NOT NULL, [Average Cost (Add_ Curr_)] [decimal](38,20) NOT NULL, [Low-Level Code] [int] NOT NULL, [Lot Size] [decimal](38,20) NOT NULL, [Serial Nos_] [varchar](10) NOT NULL, [Last Unit Cost Calc_ Date] [datetime] NOT NULL, [Material Cost per Unit] [decimal](38,20) NOT NULL, [Labor Cost per Unit] [decimal](38,20) NOT NULL, [Indirect Cost per Unit] [decimal](38,20) NOT NULL, [Scrap %] [decimal](38,20) NOT NULL, [Requisition Method Code] [varchar](10) NOT NULL, [Inventory Value Zero] [tinyint] NOT NULL, [Combine No_ of Cycles] [int] NOT NULL, [Minimum Order Quantity] [decimal](38,20) NOT NULL, [Maximum Order Quantity] [decimal](38,20) NOT NULL, [Inventory Buffer Quantity] [decimal](38,20) NOT NULL, [Order Multiple] [decimal](38,20) NOT NULL, [Safety Lead Time] [varchar](32) NOT NULL, [Posting Method] [int] NOT NULL, [Requisition System] [int] NOT NULL, [Rounding Precision] [decimal](38,20) NOT NULL, [Sales Unit of Measure Code] [varchar](10) NOT NULL, [Purch_ Unit of Measure Code] [varchar](10) NOT NULL, [Reorder Cycle] [varchar](32) NOT NULL, [No Inventory Tracking] [tinyint] NOT NULL, [List Price (LCY)] [decimal](38,20) NOT NULL, [Item Group Code] [varchar](10) NOT NULL, [Manual Price Calculation] [tinyint] NOT NULL, [Unit Price incl_ VAT] [decimal](38,20) NOT NULL, [Deposit for Main Item] [tinyint] NOT NULL, [Item Type] [int] NOT NULL, [Make Code] [varchar](10) NOT NULL, [Vehicle Type Code] [varchar](10) NOT NULL, [Vehicle Category Code] [varchar](10) NOT NULL, [Emissions Test Category Code] [varchar](10) NOT NULL, [Engine Code] [varchar](10) NOT NULL, [Model Code] [varchar](20) NOT NULL, [Warranty Percentage] [decimal](38,20) NOT NULL, [Valid-From Date] [datetime] NOT NULL, [MVEG Consumption] [decimal](38,20) NOT NULL, [NOVA Tax %] [decimal](38,20) NOT NULL, [NOVA Calculation Type] [varchar](10) NOT NULL, [Engine Type Code] [varchar](20) NOT NULL, [Transmission Type Code] [varchar](20) NOT NULL, [Cylinder Capacity (ccm)] [decimal](38,20) NOT NULL, [Federal Office Manufacturer ID] [varchar](10) NOT NULL, [KBA Type] [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, [Wheelbase (mm)] [decimal](38,20) NOT NULL, [Front Axle Load (kg)] [int] NOT NULL, [Rear Axle Load (kg)] [int] NOT NULL, [Market Segment Code] [varchar](10) NOT NULL, [No_ of Doors] [int] NOT NULL, [Vehicle Type] [varchar](80) NOT NULL, [Minimum Purchase Qty_ (Base)] [decimal](38,20) NOT NULL, [Manufacturer Req_ Status] [varchar](10) NOT NULL, [Requisition Status] [varchar](10) NOT NULL, [Requisition Group] [varchar](10) NOT NULL, [Manual Requisition] [tinyint] NOT NULL, [Blocked Qty_] [decimal](38,20) NOT NULL, [Main Group Code] [varchar](10) NOT NULL, [Subgroup Code] [varchar](10) NOT NULL, [Line Group Code] [varchar](10) NOT NULL, [Labor Type] [varchar](30) NOT NULL, [Replacement Status] [int] NOT NULL, [Old Replacement Status] [int] NOT NULL, [Update Description] [tinyint] NOT NULL, [Allow Discount] [tinyint] NOT NULL, [List Price incl_ VAT (LCY)] [decimal](38,20) NOT NULL, [Labor Charging Code] [varchar](10) NOT NULL, [Rpl_ Status Reset User ID] [varchar](20) NOT NULL, [Rpl_ Status Reset Date] [datetime] NOT NULL, [Sending Required] [int] NOT NULL, [Option Class] [varchar](20) NOT NULL, [No Service Surcharge] [tinyint] NOT NULL, [Last Time Modified] [datetime] NOT NULL, [Creation Date] [datetime] NOT NULL, [Creation Time] [datetime] NOT NULL, [Deposit Validity in Days] [int] NOT NULL, [Seasonal Factor] [varchar](10) NOT NULL, [Manual Requisition from Date] [datetime] NOT NULL, [Min_ Packaging Qty_ (Base)] [decimal](38,20) NOT NULL, [Replenishment Flag Code] [varchar](10) NOT NULL, [Manufacturer Line Count] [decimal](38,20) NOT NULL, [Manufacturer Req_ from Date] [datetime] NOT NULL, [Bulk Pack Quantity (Base)] [decimal](38,20) NOT NULL, [Manufacturer Req_ Remark] [varchar](10) NOT NULL, [Average Cost (LCY)] [decimal](38,20) NOT NULL, [Add_-Curr_ Average Cost] [decimal](38,20) NOT NULL, [Item Category] [varchar](30) NOT NULL, [BMW Parts Type] [varchar](10) NOT NULL, [SA3 Dealer Option ID] [int] NOT NULL, [SA3 Default Option] [tinyint] NOT NULL, [Maximum Inventory Limit] [decimal](38,20) NOT NULL, [Requisition Status Default] [varchar](10) NOT NULL, [Distribution Code] [varchar](10) NOT NULL, [Dangerous Goods Code] [varchar](10) NOT NULL, [Parts Family] [varchar](10) NOT NULL, [Sales Blocked] [tinyint] NOT NULL, [Not Orderable via DMS] [tinyint] NOT NULL, [Inverse Item No_] [varchar](20) NOT NULL, [Tire Data EAN Code] [varchar](27) NOT NULL, [Exch_ Parts Tax Amount] [decimal](38,20) NOT NULL, [Unit Price Total] [decimal](38,20) NOT NULL, [Last Date Price Change] [datetime] NOT NULL, [Send-In Duty From] [datetime] NOT NULL, [SA2 Transfer] [tinyint] NOT NULL, [SPS Transfer] [tinyint] NOT NULL, [GWM Transfer] [tinyint] NOT NULL, [Container Package Qty_ (Base)] [decimal](38,20) NOT NULL, [Not Accident Free] [tinyint] NOT NULL, [Client_DB] [varchar](50) NOT NULL DEFAULT ('1') ,CONSTRAINT [Item$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB]) ) GO