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, search

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>