Generated using SQL Data Dictionary demo version.
Non-temporal attributes for stock items
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
PK, FK | StockItemID | int | |||
ID of the stock item that this holding relates to (this table holds non-temporal columns for stock) | |||||
QuantityOnHand | int | ||||
Quantity currently on hand (if tracked) | |||||
BinLocation | nvarchar(20) | ||||
Bin location (ie location of this stock item within the depot) | |||||
LastStocktakeQuantity | int | ||||
Quantity at last stocktake (if tracked) | |||||
LastCostPrice | decimal(18,2) | ||||
Unit cost price the last time this stock item was purchased | |||||
ReorderLevel | int | ||||
Quantity below which reordering should take place | |||||
TargetStockLevel | int | ||||
Typical quantity ordered | |||||
FK | LastEditedBy | int | |||
LastEditedWhen | datetime2 | sysdatetime() |