VbzCart/queries/qryRstkItms unsent for order

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:, ,
 * 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
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;