VbzCart/queries/qryStk byItem byBin wInfo - Revision history

Woozle: moved VbzCart/queries/v stk byItemAndBin wInfo to VbzCart/queries/qryStk byItem byBin wInfo: naming update

2010-02-23T13:43:21Z

moved VbzCart/queries/v stk byItemAndBin wInfo to VbzCart/queries/qryStk byItem byBin wInfo: naming update

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

Woozle: naming update

2010-02-23T13:43:05Z

naming update

← Older revision		Revision as of 13:43, 23 February 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Requires''': {{vbzcart\|table\|stk_bins}}, {{vbzcart\|table\|stk_places}}, {{vbzcart/query\|~~v_stk_byItemAndBin~~}}, {{vbzcart/query\|qryCat_Items}}		* '''Requires''': {{vbzcart\|table\|stk_bins}}, {{vbzcart\|table\|stk_places}}, {{vbzcart/query\|qryStk_byItem_byBin}}, {{vbzcart/query\|qryCat_Items}}
	* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}		* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}
	* '''History''':		* '''History''':
Line 6:		Line 6:
	** '''2009-04-24''' Added p.Name, which is what "stock needed for orders" should be showing		** '''2009-04-24''' Added p.Name, which is what "stock needed for orders" should be showing
	*** commenting out p.Descr->PlcDescr because it probably isn't needed		*** commenting out p.Descr->PlcDescr because it probably isn't needed
			** '''2010-02-23''' Renaming this from v_stk_byItemAndBin_wInfo to qryStk_byItem_byBin_wInfo
			*** Also, v_stk_byItemAndBin was renamed to qryStk_byItem_byBin
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW ~~v_stk_byItemAndBin_wInfo~~ AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_byItem_byBin_wInfo AS
	SELECT		SELECT
	s.*,		s.*,
Line 18:		Line 20:
	FROM		FROM
	((		((
	~~v_stk_byItemAndBin~~ AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID		qryStk_byItem_byBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID
	) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID		) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID
	) LEFT JOIN stk_places AS p ON b.ID_Place=p.ID;</mysql>		) LEFT JOIN stk_places AS p ON b.ID_Place=p.ID;</mysql>
	<section end=sql />		<section end=sql />

Woozle: +PlcName, -PlcDescr

2009-04-25T02:12:15Z

+PlcName, -PlcDescr

← Older revision		Revision as of 02:12, 25 April 2009
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2009-02-07''' Added p.Descr so "stock needed for orders" can show where bins are		** '''2009-02-07''' Added p.Descr so "stock needed for orders" can show where bins are
			** '''2009-04-24''' Added p.Name, which is what "stock needed for orders" should be showing
			*** commenting out p.Descr->PlcDescr because it probably isn't needed
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS
Line 12:		Line 14:
	b.Code AS BinCode,		b.Code AS BinCode,
	b.Descr AS BinDescr,		b.Descr AS BinDescr,
	p.Descr AS PlcDescr		p.Name AS PlcName
			/* p.Descr AS PlcDescr */
	FROM		FROM
	((		((

Woozle: about: 2 tables also required

2009-04-25T02:05:40Z

about: 2 tables also required

← Older revision		Revision as of 02:05, 25 April 2009
Line 1:		Line 1:
	==~~Details~~==		==About==
	* '''Requires''': {{vbzcart/query\|v_stk_byItemAndBin}}, {{vbzcart/query\|qryCat_Items}}		* '''Requires''': {{vbzcart\|table\|stk_bins}}, {{vbzcart\|table\|stk_places}}, {{vbzcart/query\|v_stk_byItemAndBin}}, {{vbzcart/query\|qryCat_Items}}
	* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}		* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}
	* '''History''':		* '''History''':

Woozle: +p.Descr

2009-02-08T02:22:40Z

+p.Descr

← Older revision		Revision as of 02:22, 8 February 2009
Line 2:		Line 2:
	* '''Requires''': {{vbzcart/query\|v_stk_byItemAndBin}}, {{vbzcart/query\|qryCat_Items}}		* '''Requires''': {{vbzcart/query\|v_stk_byItemAndBin}}, {{vbzcart/query\|qryCat_Items}}
	* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}		* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}
			* '''History''':
			** '''2009-02-07''' Added p.Descr so "stock needed for orders" can show where bins are
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS
Line 9:		Line 11:
	b.ID_Place,		b.ID_Place,
	b.Code AS BinCode,		b.Code AS BinCode,
	b.Descr AS BinDescr		b.Descr AS BinDescr,
			p.Descr AS PlcDescr
	FROM		FROM
	(		((
	v_stk_byItemAndBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID		v_stk_byItemAndBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID
	) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID;</mysql>		) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID
			) LEFT JOIN stk_places AS p ON b.ID_Place=p.ID;</mysql>
	<section end=sql />		<section end=sql />

Woozle: used by qryStock_forOpenOrders

2009-02-08T00:59:24Z

used by qryStock_forOpenOrders

← Older revision		Revision as of 00:59, 8 February 2009
Line 1:		Line 1:
	==Details==		==Details==
	* '''Requires''': {{vbzcart/query\|v_stk_byItemAndBin}}, {{vbzcart/query\|qryCat_Items}}		* '''Requires''': {{vbzcart/query\|v_stk_byItemAndBin}}, {{vbzcart/query\|qryCat_Items}}
	* '''Used by''':		* '''Used by''': {{vbzcart/query\|qryStock_forOpenOrders}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS

Woozle: New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} * '''Used by''': ==SQL==
CREATE OR REPLACE VIEW v_stk_byItem...

2008-12-04T02:04:43Z

New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItem...

New page

==Details==
* '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}}
* '''Used by''':
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS
SELECT
s.*,
i.*,
b.ID_Place,
b.Code AS BinCode,
b.Descr AS BinDescr
FROM
(
v_stk_byItemAndBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID
) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID;</mysql>
<section end=sql />