Difference between revisions of "VbzCart/queries/qryRstkItms unsent for order"

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
(adapted from Access version, using new restock tables)
 
(No difference)

Revision as of 23:16, 4 December 2008

Details

  • Purpose: This should have enough information in it that we can use it to generate a restock order in whatever format the supplier needs it to be in, with minimal hand-massaging.
  • Requires:
  1. REDIRECT Template:l/vc/table,
  2. REDIRECT Template:l/vc/query
  • Used by: eventually, the restock order generation form (currently working on this)
  • History:
    • 2008-12-04 Created for new restock process

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkReq_for_order AS SELECT 

 ri.ID_Restock,
 ri.ID_Item,
 ci.CatNum,
 ci.Title_CatNum,
 ci.Title_Name,
 ci.ID_ItTyp,
 ci.ID_itOpt,
 ci.ItOpt_Descr,
 ci.ItOpt_Sort,
 ci.Supp_CatNum,
 ri.QtyOrd,
 ri.QtyExp,
 ci.QtyMin_Stk,
 ri.CostExpPer,
 ci.PriceSell

FROM rstk_req_item AS ri LEFT JOIN qryCat_Items AS ci ON ci.ID=ri.ID_Item ORDER BY ci.CatNum;</mysql>

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