VbzCart/docs/queries/qryStk lines remaining byBin

About

• Returns: list of bins, with stock quantities for each (for sale, for shipping, existing)
• Requires: Template:Vbzcart/query
• Used by: Template:Vbzcart/query
• History:
  • 2009-04-29 Created for Special:VbzAdmin

SQL

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

 SELECT
   ID_Bin,
   SUM(QtyForSale) AS QtyForSale,
   SUM(QtyForShip) AS QtyForShip,
   SUM(QtyExisting) AS QtyExisting
 FROM v_stk_lines_remaining GROUP BY ID_Bin;</mysql>

<section end=sql />