VbzCart/docs/queries/qryRpt Pkg Trx

About

• Requires: Template:Vbzcart, Template:Vbzcart, Template:Vbzcart
• History:
  • 2011-06-01 ported from MS Access so I can print packing slips from web interface (final major piece?)

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRpt_Pkg_Trx AS SELECT

 t.ID_Order,
 tt.Code,
 t.WhenDone,
 CONCAT(IF(t.ID_Package IS NULL,"",CONCAT("pkg #",p.Seq,": ")),t.Descr) AS Descr,
 t.Amount

FROM (

 ord_trxact AS t LEFT JOIN
 ord_trx_type AS tt ON t.ID_Type=tt.ID) LEFT JOIN
 ord_pkgs AS p ON t.ID_Package=p.ID

WHERE WhenVoid IS NULL ORDER BY WhenDone, Amount>0;</mysql> <section end=sql />