Warehouse.StockItems

Columns

• //

  ${escapify(column.description)}
  StockItemID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[StockItemID])
• //

  ${escapify(column.description)}
  StockItemName
  [nvarchar](100) NOT NULL
• //

  ${escapify(column.description)}
  SupplierID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  ColorID
  [int] NULL
• //

  ${escapify(column.description)}
  UnitPackageID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  OuterPackageID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  Brand
  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  Size
  [nvarchar](20) NULL
• //

  ${escapify(column.description)}
  LeadTimeDays
  [int] NOT NULL
• //

  ${escapify(column.description)}
  QuantityPerOuter
  [int] NOT NULL
• //

  ${escapify(column.description)}
  IsChillerStock
  [bit] NOT NULL
• //

  ${escapify(column.description)}
  Barcode
  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  TaxRate
  [decimal](18, 3) NOT NULL
• //

  ${escapify(column.description)}
  UnitPrice
  [decimal](18, 2) NOT NULL
• //

  ${escapify(column.description)}
  RecommendedRetailPrice
  [decimal](18, 2) NULL
• //

  ${escapify(column.description)}
  TypicalWeightPerUnit
  [decimal](18, 3) NOT NULL
• //

  ${escapify(column.description)}
  MarketingComments
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  InternalComments
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  Photo
  [varbinary](MAX) NULL
• //

  ${escapify(column.description)}
  CustomFields
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  Tags
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  SearchDetails
  [nvarchar](MAX) NOT NULL
• LastEditedBy
  [int] NOT NULL
• ValidFrom
  [datetime2](8) NOT NULL
• ValidTo
  [datetime2](8) NOT NULL

Indexes

• PK_Warehouse_StockItems
  UNIQUE CLUSTERED
  StockItemID
• UQ_Warehouse_StockItems_StockItemName
  UNIQUE NONCLUSTERED
  StockItemName
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItems_SupplierID
  NONCLUSTERED
  SupplierID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItems_ColorID
  NONCLUSTERED
  ColorID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItems_UnitPackageID
  NONCLUSTERED
  UnitPackageID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItems_OuterPackageID
  NONCLUSTERED
  OuterPackageID

Foreign Keys

• FK_Warehouse_StockItems_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Warehouse_StockItems_ColorID_Warehouse_Colors
  Warehouse.Colors
  ColorID ⥱ ColorID
• FK_Warehouse_StockItems_OuterPackageID_Warehouse_PackageTypes
  Warehouse.PackageTypes
  OuterPackageID ⥱ PackageTypeID
• FK_Warehouse_StockItems_SupplierID_Purchasing_Suppliers
  Purchasing.Suppliers
  SupplierID ⥱ SupplierID
• FK_Warehouse_StockItems_UnitPackageID_Warehouse_PackageTypes
  Warehouse.PackageTypes
  UnitPackageID ⥱ PackageTypeID

Sample Data