VbzCart/queries/qryRstkItms unsent for order
Jump to navigation
Jump to search
About
- 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:
- REDIRECT Template:l/vc/query, qryCat_Items, Template:vbzcat/table
- Used by: eventually, the restock order generation form (currently working on this)
- History:
- 2008-12-04 Created for new restock process; renamed
- 2008-12-05 Added cat_ittyps
SQL
<mysql>CREATE OR REPLACE VIEW qryRstkItms_unsent_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, it.NameSng, IFNULL(it.NamePlr,it.NameSng) AS NamePlr, ri.QtyOrd, ri.QtyExp, ci.QtyMin_Stk, ri.CostExpPer, ci.PriceSell
FROM
(qryRstkItms_unsent AS ri LEFT JOIN qryCat_Items AS ci ON ci.ID=ri.ID_Item) LEFT JOIN cat_ittyps AS it ON ci.ID_ItTyp=it.ID
ORDER BY ci.CatNum;</mysql>