Generated using SQL Data Dictionary demo version.


Table Warehouse.StockItems_Archive (444 rows)


  Column Data Type Identity Nullable Default
StockItemID int
StockItemName nvarchar(100)
SupplierID int
ColorID int X
UnitPackageID int
OuterPackageID int
Brand nvarchar(50) X
Size nvarchar(20) X
LeadTimeDays int
QuantityPerOuter int
IsChillerStock bit
Barcode nvarchar(50) X
TaxRate decimal(18,3)
UnitPrice decimal(18,2)
RecommendedRetailPrice decimal(18,2) X
TypicalWeightPerUnit decimal(18,3)
MarketingComments nvarchar(max) X
InternalComments nvarchar(max) X
Photo varbinary(max) X
CustomFields nvarchar(max) X
Tags nvarchar(max) X
SearchDetails nvarchar(max)
LastEditedBy int
ValidFrom datetime2
ValidTo datetime2

Indexes:


Used by: