VbzCart/queries/qryOrdLines PkgdQtys

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.

Details

  • Requires:
  1. REDIRECT Template:l/vc/query,
  2. REDIRECT Template:l/vc/table
  • Used by: order detail in Item table
  • History:
    • 2008-11-21: Added CatNum, Descr, OrdNum, WhenStarted, ID_Pull fields

SQL

<mysql>CREATE OR REPLACE VIEW qryOrdLines_PkgdQtys AS SELECT 

 ol.ID,
 ol.ID_Order,
 o.Number AS OrdNum,
 o.WhenStarted AS OrdDate,
 o.ID_Pull,
 ol.ID_Item,
 ol.CatNum,
 ol.Descr,
 ol.QtyOrd,
 pl.QtyDone,
 pl.QtyShipped,
 pl.QtyExtra,
 pl.QtyNotAvail,
 pl.QtyKilled

FROM 

     (ord_lines AS ol
   LEFT JOIN qryPkgLines_byOrdLine_andItem AS pl ON pl.ID_OrdLine=ol.ID)
 LEFT JOIN core_orders AS o ON ol.ID_Order=o.ID;</mysql>

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