Dimension.Stock Item - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Dimension
Name	Stock Item
Modules	Movement, Order, Stock Holding, Sale

StockItem dimension

Columns

		Name	Data type	Attributes	Description
	1	Stock Item Key	int	Default: NEXT VALUE FOR [Sequences].[StockItemKey]	DW key for the stock item dimension
DW key for the stock item dimension Default: NEXT VALUE FOR [Sequences].[StockItemKey]
	2	WWI Stock Item ID	int		Numeric ID used for reference to a stock item within the WWI database
Numeric ID used for reference to a stock item within the WWI database
	3	Stock Item	nvarchar(100)		Full name of a stock item (but not a full description)
Full name of a stock item (but not a full description)
	4	Color	nvarchar(20)		Color (optional) for this stock item
Color (optional) for this stock item
	5	Selling Package	nvarchar(50)		Usual package for selling units of this stock item
Usual package for selling units of this stock item
	6	Buying Package	nvarchar(50)		Usual package for selling outers of this stock item (ie cartons, boxes, etc.)
Usual package for selling outers of this stock item (ie cartons, boxes, etc.)
	7	Brand	nvarchar(50)		Brand for the stock item (if the item is branded)
Brand for the stock item (if the item is branded)
	8	Size	nvarchar(20)		Size of this item (eg: 100mm)
Size of this item (eg: 100mm)
	9	Lead Time Days	int		Number of days typically taken from order to receipt of this stock item
Number of days typically taken from order to receipt of this stock item
	10	Quantity Per Outer	int		Quantity of the stock item in an outer package
Quantity of the stock item in an outer package
	11	Is Chiller Stock	bit		Does this stock item need to be in a chiller?
Does this stock item need to be in a chiller?
	12	Barcode	nvarchar(50)		Barcode for this stock item
Barcode for this stock item
	13	Tax Rate	decimal(18, 3)		Tax rate to be applied
Tax rate to be applied
	14	Unit Price	decimal(18, 2)		Selling price (ex-tax) for one unit of this product
Selling price (ex-tax) for one unit of this product
	15	Recommended Retail Price	decimal(18, 2)		Recommended retail price for this stock item
Recommended retail price for this stock item
	16	Typical Weight Per Unit	decimal(18, 3)		Typical weight for one unit of this product (packaged)
Typical weight for one unit of this product (packaged)
	17	Photo	varbinary(MAX)		Photo of the product
Photo of the product
	18	Valid From	datetime2(7)		Valid from this date and time
Valid from this date and time
	19	Valid To	datetime2(7)		Valid until this date and time
Valid until this date and time
	20	Lineage Key	int		Lineage Key for the data load for this row
Lineage Key for the data load for this row

Relations

Foreign table	Primary table	Join	Title / Name / Description
Fact.Movement	Dimension.Stock Item	Fact.Movement.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Movement_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Movement.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Movement_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Order	Dimension.Stock Item	Fact.Order.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Order_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Order.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Order_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Purchase	Dimension.Stock Item	Fact.Purchase.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Purchase_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Purchase.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Purchase_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Sale	Dimension.Stock Item	Fact.Sale.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Sale_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Sale.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Sale_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Stock Holding	Dimension.Stock Item	Fact.Stock Holding.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Stock_Holding_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Stock Holding.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Stock_Holding_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key

Unique keys

	Key name	Columns	Description
	PK_Dimension_Stock_Item	Stock Item Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

Name
Dimension.Stock Item
Fact.Movement
Fact.Order
Fact.Purchase
Fact.Sale
Fact.Stock Holding

Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59