VbzCart/queries/qryRstkItms expected byItem
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Purpose: Returns a list of items we're currently expecting to receive in restocks,
- Requires: qryRstkItms_expected
- Used by : restock request generation admin page
- History:
- 2010-01-05 Created for VbzAdmin; replaced qryRstkReq_Items_expected
- 2016-03-02 No longer works; dropped from database.
SQL
<mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS SELECT
ID_Item, SUM(QtyExp) AS QtyExp, SUM(QtyRecd) AS QtyRecd
FROM qryRstkItms_expected GROUP BY ID_Item;</mysql>
