A list of items.
View Name: vw_KPIItems
Filter: n/a
Features: n/a
Transactional: Yes, by AddDate; however, normally returned as a value
| Field | Type | Description |
|---|---|---|
| PartNo | varchar | Item Number |
| ProdFam | varchar | Product Family Code |
| ProdFamName | varchar | Product Family Name |
| InclDmnd | bit | Include in Demand (is this an inventory item)? (1=Yes, 0=No) |
| SingleSource | bit | Single Source? (1=Yes, 0=No) |
| ShipHold | bit | On shipping hold? (1=Yes, 0=No) |
| AddDate | datetime | Add Date |
| Active | bit | Is item active? (1=Yes, 0=No) |
| EOLDate | datetime | End of life date (can be null/blank) |
| Product | bit | Is item a saleable product (can be used on a sales order)? (1=Yes, 0=No) |
| LastTrx | datetime | Date of last inventory transaction |
| LastSale | datetime | Date of last sale |
| LastPO | datetime | Date of last purchase |
| 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) |
