VbzCart/queries/qryRstkReq Items expected

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Purpose: Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already received for those requests
  • Requires:
  1. REDIRECT Template:l/vc/query
  • Used by : DEPRECATED - seems less accurate than qryRstkItms_expected_byItem
  • Related: Like qryRstkItms_expected, but grouped by Item (eliminates rstk_req data)
  • History:
    • 2010-01-03 Created for generating list of needed items
    • 2010-01-04 This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS SELECT 

 ID_Item,
 SUM(QtyRecd) AS QtyRecd,
 SUM(QtyExp) AS QtyExp

FROM qryRstkReq_Item_status GROUP BY ID_Item HAVING SUM(QtyExp)-SUM(QtyRecd)>0;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryRstkReq_Items_expected&oldid=13198"