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

CREATE TABLE [import].[Item_Location] (
   [timestamp] [timestamp] NOT NULL,
   [Item No_] [varchar](20) NOT NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Reorder Point] [decimal](38,20) NOT NULL,
   [Maximum Inventory] [decimal](38,20) NOT NULL,
   [Reorder Quantity] [decimal](38,20) NOT NULL,
   [Inventory Buffer Quantity] [decimal](38,20) NOT NULL,
   [Requisition Status] [varchar](10) NOT NULL,
   [Seasonal Factor] [varchar](10) NOT NULL,
   [Item Transfer Priority] [int] NOT NULL,
   [Manual Requisition from Date] [datetime] NOT NULL,
   [Creation Date] [datetime] NOT NULL,
   [Manufacturer Req_ Status] [varchar](10) NOT NULL,
   [Manufacturer Line Count] [decimal](38,20) NOT NULL,
   [Manufacturer Req_ from Date] [datetime] NOT NULL,
   [Manufacturer Req_ Remark] [varchar](10) NOT NULL,
   [Replenishment Flag Code] [varchar](10) NOT NULL,
   [Maximum Inventory Limit] [decimal](38,20) NOT NULL,
   [Requisition Status Default] [varchar](10) NOT NULL,
   [Distribution Code] [varchar](10) NOT NULL,
   [Shelf No_] [varchar](10) NOT NULL,
   [Forecast Value] [decimal](38,20) NOT NULL,
   [Forecast Method] [int] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO