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
< VbzCart‎ | queries
Revision as of 22:57, 2 March 2016 by Woozle (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: Returns a list of items we're currently expecting to receive in restocks,
  • Requires:
  1. REDIRECT Template:l/vc/query
  • Used by : restock request generation admin page
  • History:

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>