VbzCart/queries/qryRpt Pkg Trx

About

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

SQL
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;