VbzCart/docs/queries/qryRstkItms expected byItem
Jump to navigation
Jump to search
About
- Purpose: Returns a list of items we're currently expecting to receive in restocks,
- Requires: Template:Vbzcart/query
- Used by : restock request generation admin page
- History:
- 2010-01-05 Created for VbzAdmin; replaced Template:Vbzcart/query
- 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>