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

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