VbzCart/queries/qryRstkReq Item status - Revision history

Woozle: QtyOrd -> QtyExp

2010-01-05T00:57:18Z

QtyOrd -> QtyExp

← Older revision		Revision as of 00:57, 5 January 2010
Line 1:		Line 1:
	==Details==		==Details==
	* '''Returns''': Information about items Restock Requested and how many have been Received		* '''Returns''': Information about items Restock Requested and how many have been Received
			* '''Status''': possibly no longer in use (2010-01-04), unless it turns out to be faster this way
	* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstkReq_Item_Rcd_status}}		* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstkReq_Item_Rcd_status}}
	* '''Used by''': {{vbzcart/query\|qryRstkReq_Item_status_Req_info}}, {{vbzcart/query\|qryRstkReq_Items_expected}}		* '''Used by''': {{vbzcart/query\|qryRstkReq_Item_status_Req_info}}, {{vbzcart/query\|qryRstkReq_Items_expected}}
	* '''History''':		* '''History''':
	** '''2008-11-21''' Created for new restock process		** '''2008-11-21''' Created for new restock process
			** '''2010-01-04''' QtyExp replaces QtyOrd
	* '''Fields''':		* '''Fields''':
	** '''WhenFirstOrder / WhenFinalorder''' are timestamps of ''customer'' orders for this item		** '''WhenFirstOrder / WhenFinalorder''' are timestamps of ''customer'' orders for this item
Line 11:		Line 13:
	SELECT		SELECT
	rci.*,		rci.*,
	rqi.QtyOrd,		IFNULL(rqi.QtyExp,rqi.QtyOrd) AS QtyExp,
	rqi.Notes		rqi.Notes
	FROM		FROM

Woozle: also used by qryRstkReq_Items_expected

2010-01-04T02:32:53Z

also used by qryRstkReq_Items_expected

← Older revision		Revision as of 02:32, 4 January 2010
Line 2:		Line 2:
	* '''Returns''': Information about items Restock Requested and how many have been Received		* '''Returns''': Information about items Restock Requested and how many have been Received
	* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstkReq_Item_Rcd_status}}		* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstkReq_Item_Rcd_status}}
	* '''Used by''': {{vbzcart/query\|qryRstkReq_Item_status_Req_info}}		* '''Used by''': {{vbzcart/query\|qryRstkReq_Item_status_Req_info}}, {{vbzcart/query\|qryRstkReq_Items_expected}}
	* '''History''':		* '''History''':
	** '''2008-11-21''' Created for new restock process		** '''2008-11-21''' Created for new restock process

Woozle: New page: ==Details== * '''Returns''': Information about items Restock Requested and how many have been Received * '''Requires''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryRstkReq_Item_Rc...

2008-12-04T00:34:30Z

New page: ==Details== * '''Returns''': Information about items Restock Requested and how many have been Received * '''Requires''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryRstkReq_Item_Rc...

New page

==Details==
* '''Returns''': Information about items Restock Requested and how many have been Received
* '''Requires''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryRstkReq_Item_Rcd_status}}
* '''Used by''': {{vbzcart/query|qryRstkReq_Item_status_Req_info}}
* '''History''':
** '''2008-11-21''' Created for new restock process
* '''Fields''':
** '''WhenFirstOrder / WhenFinalorder''' are timestamps of ''customer'' orders for this item
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Item_status AS
SELECT
rci.*,
rqi.QtyOrd,
rqi.Notes
FROM
rstk_req_item AS rqi
LEFT JOIN qryRstkReq_Item_Rcd_status AS rci ON (rqi.ID_Restock=rci.ID_RstkReq) AND (rqi.ID_Item=rci.ID_Item)
WHERE rci.ID_RstkReq IS NOT NULL
ORDER BY rci.ID_RstkReq, rci.ID_Item;</mysql>
<section end=sql />