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() | |||