VbzCart/queries/qryStk byItem byBin - Revision history

Woozle: another usage

2010-12-05T15:54:37Z

another usage

← Older revision		Revision as of 15:54, 5 December 2010
Line 2:		Line 2:
	* '''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)		* '''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\|qryStk_lines_remaining}}		* '''Requires''': {{vbzcart/query\|qryStk_lines_remaining}}
	* '''Used by''': {{vbzcart/query\|v_stk_byItemAndBin_wInfo}}		* '''Used by''': {{vbzcart/query\|v_stk_byItemAndBin_wInfo}}, VbzStockBins::Info_forItems()
	* '''History''':		* '''History''':
	** '''2010-02-23''' v_stk_lines_remaining was renamed to qryStk_lines_remaining		** '''2010-02-23''' v_stk_lines_remaining was renamed to qryStk_lines_remaining

Woozle: moved VbzCart/queries/v stk byItemAndBin to VbzCart/queries/qryStk byItem byBin: updated naming canon

2010-02-23T13:38:04Z

moved VbzCart/queries/v stk byItemAndBin to VbzCart/queries/qryStk byItem byBin: updated naming canon

← Older revision	Revision as of 13:38, 23 February 2010
(No difference)

Woozle at 13:33, 23 February 2010

2010-02-23T13:33:57Z

← Older revision		Revision as of 13:33, 23 February 2010
Line 1:		Line 1:
	==Details==		==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)		* '''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\|~~v_stk_lines_remaining~~}}		* '''Requires''': {{vbzcart/query\|qryStk_lines_remaining}}
	* '''Used by''': {{vbzcart/query\|v_stk_byItemAndBin_wInfo}}		* '''Used by''': {{vbzcart/query\|v_stk_byItemAndBin_wInfo}}
			* '''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 ~~v_stk_byItemAndBin~~ AS		<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 ~~v_stk_lines_remaining~~		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 />

Woozle: used by v_stk_byItemAndBin_wInfo

2009-02-08T01:00:30Z

used by v_stk_byItemAndBin_wInfo

← Older revision		Revision as of 01:00, 8 February 2009
Line 2:		Line 2:
	* '''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)		* '''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/query\|v_stk_lines_remaining}}		* '''Requires''': {{vbzcart/query\|v_stk_lines_remaining}}
	* '''Used by''':		* '''Used by''': {{vbzcart/query\|v_stk_byItemAndBin_wInfo}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin AS

Woozle: 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/...

2008-12-04T01:58:11Z

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/...

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/query|v_stk_lines_remaining}}
* '''Used by''':
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin AS
SELECT
ID_Item,
ID_Bin,
SUM(QtyForSale) AS QtyForSale,
SUM(QtyForShip) AS QtyForShip,
SUM(QtyExisting) AS QtyExisting
FROM v_stk_lines_remaining
GROUP BY ID_Item, ID_Bin
HAVING SUM(QtyExisting)>0;</mysql>
<section end=sql />