C11/System/ARI/SQL/schema/ARI/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](100) NOT NULL,
   [Search Description] [varchar](100) 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](20) NOT NULL,
   [Shelf No_] [varchar](10) NOT NULL,
   [Sales Qty_ Disc_ Code] [varchar](30) NOT NULL,
   [Cust__Item Disc_ Gr_] [varchar](20) 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,
   [Cost is Adjusted] [tinyint] 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,
   [Global Dimension 1 Code] [varchar](20) NOT NULL,
   [Stockout Warning] [int] NOT NULL,
   [Prevent Negative Inventory] [int] NOT NULL,
   [Application Wksh_ User ID] [varchar](128) 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](20) 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,
   [Engine Type Code] [varchar](20) NOT NULL,
   [Transmission Type Code] [varchar](20) NOT NULL,
   [Cylinder Capacity (ccm)] [decimal](38,20) 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](50) 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,
   [Print Options] [tinyint] NOT NULL,
   [Print Unit Price] [tinyint] NOT NULL,
   [Valid-To Date] [datetime] NOT NULL,
   [Not Available for New Sales] [tinyint] NOT NULL,
   [Coded Part Type] [varchar](30) NOT NULL,
   [Model Year] [varchar](30) NOT NULL,
   [Top Speed] [int] NOT NULL,
   [Acceleration] [decimal](38,20) NOT NULL,
   [Desc_ Trans_ to Vehicle Option] [tinyint] NOT NULL,
   [Last Landed Unit Cost] [decimal](38,20) NOT NULL,
   [Duty Due Amount] [decimal](38,20) NOT NULL,
   [Freight _] [decimal](38,20) NOT NULL,
   [Freight Amount] [decimal](38,20) NOT NULL,
   [Supply Req_ Worksheet Template] [varchar](10) NOT NULL,
   [Ext_ Warehouse Inventory] [decimal](38,20) NOT NULL,
   [ABC Code] [varchar](10) NOT NULL,
   [Pick Release Code] [varchar](10) NOT NULL,
   [Special Waste] [tinyint] NOT NULL,
   [Special Waste Group Code] [varchar](10) NOT NULL,
   [Dangerous Goods Indicator] [tinyint] NOT NULL,
   [Dangerous Goods Code] [varchar](10) NOT NULL,
   [No_ of Seats] [int] NOT NULL,
   [Dangerous Goods Class] [varchar](10) NOT NULL,
   [UN No_] [varchar](10) 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,
   [Update Alternative Parts Prio_] [tinyint] NOT NULL,
   [Original Part] [tinyint] NOT NULL,
   [Quality] [int] NOT NULL,
   [Proposal for Alternative Part] [int] NOT NULL,
   [Manufacturer No_] [varchar](30) NOT NULL,
   [Select Unit Price] [int] NOT NULL,
   [Accept posting group from Veh_] [tinyint] NOT NULL,
   [e-Part] [tinyint] NOT NULL,
   [Bonus Code] [varchar](10) NOT NULL,
   [Ship Proposal Transfer Prio] [int] NOT NULL,
   [Check of Serial No_] [tinyint] NOT NULL,
   [National Tariff No_] [varchar](20) NOT NULL,
   [Parts Category] [varchar](10) NOT NULL,
   [Parts Family] [varchar](10) NOT NULL,
   [Container Package Qty_ (Base)] [decimal](38,20) NOT NULL,
   [Distribution Code] [varchar](10) NOT NULL,
   [Maximum Inventory Limit] [decimal](38,20) NOT NULL,
   [Manuf_ Replacement Status] [varchar](10) NOT NULL,
   [Emission Standard Code] [varchar](10) NOT NULL,
   [Diesel Particulate Filter] [tinyint] NOT NULL,
   [Template Code] [varchar](10) NOT NULL,
   [Tire Item] [tinyint] NOT NULL,
   [EU Tire Data Code] [varchar](27) NOT NULL,
   [Inverse Item No_] [varchar](30) NOT NULL,
   [Drive] [int] NOT NULL,
   [Engine Speed Rate Output] [varchar](50) NOT NULL,
   [Maximum Torque] [varchar](50) NOT NULL,
   [Axle -3 Load (kg)] [int] NOT NULL,
   [Axle -4 Load (kg)] [int] NOT NULL,
   [Length (mm)] [int] NOT NULL,
   [Width (mm)] [int] NOT NULL,
   [Height (mm)] [int] NOT NULL,
   [Common Item No_] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Item$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)

CREATE UNIQUE NONCLUSTERED INDEX [$1] ON [import].[Item] ([Client_DB], [Search Description], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$10] ON [import].[Item] ([Client_DB], [Replacement Status], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$11] ON [import].[Item] ([Client_DB], [Make Code], [Item Group Code], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$12] ON [import].[Item] ([Client_DB], [Make Code], [Main Group Code], [Subgroup Code], [Line Group Code], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$13] ON [import].[Item] ([Client_DB], [Item Type], [Make Code], [Search Description], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$14] ON [import].[Item] ([Client_DB], [Item Type], [Make Code], [Shelf No_], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$15] ON [import].[Item] ([Client_DB], [Item Type], [Make Code], [Vendor No_], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$16] ON [import].[Item] ([Client_DB], [Item Type], [Inventory Posting Group], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$17] ON [import].[Item] ([Client_DB], [Manufacturer No_], [Make Code], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$18] ON [import].[Item] ([Client_DB], [Common Item No_], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$19] ON [import].[Item] ([Client_DB], [Inverse Item No_], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$2] ON [import].[Item] ([Client_DB], [Inventory Posting Group], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$20] ON [import].[Item] ([Client_DB], [EU Tire Data Code], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$3] ON [import].[Item] ([Client_DB], [Shelf No_], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$4] ON [import].[Item] ([Client_DB], [Vendor No_], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$5] ON [import].[Item] ([Client_DB], [Gen_ Prod_ Posting Group], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$6] ON [import].[Item] ([Client_DB], [Low-Level Code], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$7] ON [import].[Item] ([Client_DB], [Item Type], [Make Code], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$8] ON [import].[Item] ([Client_DB], [Item Type], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$9] ON [import].[Item] ([Client_DB], [Item Type], [Vendor No_], [No_])

GO