dataexport: 27
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 27 | SELECT p_comp.num AS component_part_number, p_comp.description AS component_description, u.name AS uom, b.num AS bom_number, m.num AS mo_number, w.num AS wo_number, m.dateScheduled AS mo_scheduled_date, SUM( (mi.qtyToFulfill - mi.qtyFulfilled) * bi.quantity ) AS total_demand, qt.QTYONHAND AS qty_on_hand, qt.QTYONHAND - SUM( (mi.qtyToFulfill - mi.qtyFulfilled) * bi.quantity ) AS net_available, qt.QTYONORDER AS qty_on_order, CASE WHEN qt.QTYONHAND < SUM( (mi.qtyToFulfill - mi.qtyFulfilled) * bi.quantity ) THEN 'SHORT' ELSE '' END AS status FROM mo m JOIN moitem mi ON mi.moId = m.id JOIN part p_mo ON p_mo.id = mi.partId JOIN bom b ON b.num = p_mo.num JOIN bomitem bi ON bi.bomid = b.id JOIN part p_comp ON p_comp.id = bi.partid JOIN parttype pt ON pt.id = p_comp.typeid JOIN uom u ON u.id = p_comp.uomid LEFT JOIN qtyinventorytotals qt ON qt.PARTID = p_comp.id LEFT JOIN wo w ON w.moItemId = mi.id WHERE m.statusId IN (10, 20, 50) AND mi.statusId NOT IN (60, 70, 80) AND m.dateScheduled <= '2026-05-31' AND mi.partId IS NOT NULL AND p_mo.activeFlag = 1 AND p_comp.activeFlag = 1 AND pt.id NOT IN (20, 21, 22, 60) GROUP BY p_comp.num, p_comp.description, u.name, b.num, m.num, w.num, m.dateScheduled, qt.QTYONHAND, qt.QTYONORDER HAVING SUM( (mi.qtyToFulfill - mi.qtyFulfilled) * bi.quantity ) > 0 ORDER BY net_available ASC; | 2026-04-14 17:09:10.783000 | 2026-04-14 17:09:10.783000 | Dataset to determine demand over a given period of time | 51 | Demand |