Difference between revisions of "VbzCart/queries/qryRstkItms expected byItem"
Jump to navigation
Jump to search
(Created page with '==About== * '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, * '''Requires''': {{vbzcart/query|qryRstkItms_expected}} * '''Used by ''': re…') |
(No difference)
|
Revision as of 00:15, 6 January 2010
About
- Purpose: Returns a list of items we're currently expecting to receive in restocks,
- Requires:
- REDIRECT Template:l/vc/query
- Used by : restock request generation admin page
- History:
- 2010-01-05 Created for VbzAdmin; replaced qryRstkReq_Items_expected
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>