Difference between revisions of "VbzCart/queries/qryRstkReq Item status"
Jump to navigation
Jump to search
(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...) |
(also used by qryRstkReq_Items_expected) |
||
| 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 | ||
Revision as of 02:32, 4 January 2010
Details
- Returns: Information about items Restock Requested and how many have been Received
- Requires:
- REDIRECT Template:l/vc/table,
- REDIRECT Template:l/vc/query
- Used by: qryRstkReq_Item_status_Req_info, qryRstkReq_Items_expected
- History:
- 2008-11-21 Created for new restock process
- Fields:
- WhenFirstOrder / WhenFinalorder are timestamps of customer orders for this item
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>