A list of stock control records (Whse-Item).
View Name: vw_KPIStockControl
Filter: n/a
Features: Whse
Transactional: No
| Field | Type | Description |
|---|---|---|
| StkID | int | Stock Control unique ID |
| Whse | varchar | Warehouse |
| WhseName | varchar | Warehouse Name |
| PartNo | varchar | Item Number |
| ItemDes | varchar | Item Description |
| ProdFam | varchar | Product Family Code |
| ProdFamName | varchar | Product Family Name |
| SingleSource | bit | Single Source? (1=Yes, 0=No) |
| ShipHold | bit | On shipping hold? (1=Yes, 0=No) |
| LastCycDate | datetime | Date of last cycle count |
| CycDays | int | Days since last cycle count |
| Qty | decimal | Quantity on hand |
| LUM | varchar | Lowest unit of measure (stock uom) |
| QtyPickable | decimal | Quantity that can be picked (not reserved) |
| QtyAlloc | decimal | Quantity allocated to orders |
| QtyAvail | decimal | Quantity available for new orders (QtyPickable-QtyAlloc) |
| TotalCost | decimal | Total cost of inventory |
| DoNotStock | bit | Do Not Stock flag (1=don't stock, 0=stock) |
| Active | bit | Item Active flag (1=active, 0=inactive) |
| EOLDate | datetime | End of life date (can be null/blank) |
| LastUsedDate | datetime | Last used (max of LastTrx, LastSale and LastPO) |
| IsDead | bit | Is item dead (no usage for last 365 days and not added within last 365 days)? (1=Yes, 0=No) |
