Difference between revisions of "VbzCart/queries/qryStk byItem byBin"
Jump to navigation
Jump to search
(New page: ==Details== * '''Returns''': Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Item and Bin (so we have totals for each Item in each Bin) * '''Requires''': {{vbzcart/...) |
(another usage) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Details== | ==Details== | ||
| − | * '''Returns''': Same records as {{vbzcart/query| | + | * '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item and Bin (so we have totals for each Item in each Bin) |
| − | * '''Requires''': {{vbzcart/query| | + | * '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} |
| − | * '''Used by''': | + | * '''Used by''': {{vbzcart/query|v_stk_byItemAndBin_wInfo}}, VbzStockBins::Info_forItems() |
| + | * '''History''': | ||
| + | ** '''2010-02-23''' v_stk_lines_remaining was renamed to qryStk_lines_remaining | ||
| + | *** also renaming this from v_stk_byItemAndBin to qryStk_byItem_byBin | ||
==SQL== | ==SQL== | ||
| − | <section begin=sql /><mysql>CREATE OR REPLACE VIEW | + | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_byItem_byBin AS |
SELECT | SELECT | ||
ID_Item, | ID_Item, | ||
| Line 11: | Line 14: | ||
SUM(QtyForShip) AS QtyForShip, | SUM(QtyForShip) AS QtyForShip, | ||
SUM(QtyExisting) AS QtyExisting | SUM(QtyExisting) AS QtyExisting | ||
| − | FROM | + | FROM qryStk_lines_remaining |
GROUP BY ID_Item, ID_Bin | GROUP BY ID_Item, ID_Bin | ||
HAVING SUM(QtyExisting)>0;</mysql> | HAVING SUM(QtyExisting)>0;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Latest revision as of 15:54, 5 December 2010
Details
- Returns: Same records as
- REDIRECT Template:l/vc/query, but grouped by Item and Bin (so we have totals for each Item in each Bin)
- Requires: qryStk_lines_remaining
- Used by: v_stk_byItemAndBin_wInfo, VbzStockBins::Info_forItems()
- History:
- 2010-02-23 v_stk_lines_remaining was renamed to qryStk_lines_remaining
- also renaming this from v_stk_byItemAndBin to qryStk_byItem_byBin
- 2010-02-23 v_stk_lines_remaining was renamed to qryStk_lines_remaining
SQL
<mysql>CREATE OR REPLACE VIEW qryStk_byItem_byBin AS
SELECT ID_Item, ID_Bin, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM qryStk_lines_remaining GROUP BY ID_Item, ID_Bin HAVING SUM(QtyExisting)>0;</mysql>