VbzCart/queries/qryStk lines remaining byBin
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Returns: list of bins, with stock quantities for each (for sale, for shipping, existing)
- Requires: v_stk_lines_remaining
- Used by: qryStk_Bins_w_info
- 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 />
