Warehouse.StockItemHoldings - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Warehouse
Name	StockItemHoldings
Module	Warehouse

Non-temporal columns for stock items. These are frequently updated columns.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		StockItemID	int			Warehouse.StockItems	ID of the stock item that this holding relates to (this table holds non-temporal columns for stock)
ID of the stock item that this holding relates to (this table holds non-temporal columns for stock) References: Warehouse.StockItems
	2		QuantityOnHand	int				Quantity currently on hand (if tracked)
Quantity currently on hand (if tracked)
	3		BinLocation	nvarchar(20)				Bin location (ie location of this stock item within the depot)
Bin location (ie location of this stock item within the depot)
	4		LastStocktakeQuantity	int				Quantity at last stocktake (if tracked)
Quantity at last stocktake (if tracked)
	5		LastCostPrice	decimal(18, 2)				Unit cost price the last time this stock item was purchased
Unit cost price the last time this stock item was purchased
	6		ReorderLevel	int				Quantity below which reordering should take place
Quantity below which reordering should take place
	7		TargetStockLevel	int				Typical quantity ordered
Typical quantity ordered
	8		LastEditedBy	int			Application.People
References: Application.People
	9		LastEditedWhen	datetime2(7)		Default: sysdatetime()		When this row was last edited
When this row was last edited Default: sysdatetime()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Warehouse.StockItemHoldings		Application.People	Warehouse.StockItemHoldings.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockItemHoldings_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemHoldings.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItemHoldings_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemHoldings		Warehouse.StockItems	Warehouse.StockItemHoldings.StockItemID = Warehouse.StockItems.StockItemID	PKFK_Warehouse_StockItemHoldings_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID
Warehouse.StockItemHoldings.StockItemID = Warehouse.StockItems.StockItemID Name: PKFK_Warehouse_StockItemHoldings_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID

Unique keys

	Key name	Columns	Description
	PK_Warehouse_StockItemHoldings	StockItemID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Warehouse.StockItemHoldings
Application.People
Warehouse.StockItems

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