User contributions for Woozle
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
6 December 2008
- 15:2815:28, 6 December 2008 diff hist +1,491 N VbzCart/tables/cat ittyps extracted from "tables" page
- 15:2115:21, 6 December 2008 diff hist +2,952 N VbzCart/tables/cat items extracted from "tables" page
- 15:1515:15, 6 December 2008 diff hist +1,300 N VbzCart/tables/cat titles extracted from "tables" page
- 15:1215:12, 6 December 2008 diff hist +840 N VbzCart/tables/cat depts extracted from "tables" page
- 15:0715:07, 6 December 2008 diff hist +1,451 N VbzCart/tables/cat supp extracted from "tables" page
- 03:2303:23, 6 December 2008 diff hist +503 VbzCart/pieces/catalog/building →ctg_upd* data building: inactive catalog number update in stage 3
- 00:1000:10, 6 December 2008 diff hist +250 artificial intelligence →Applications: iwantsandy closing down
5 December 2008
- 23:4523:45, 5 December 2008 diff hist +132 VbzCart/queries/qryItms to restock union updated source query name current
- 18:3818:38, 5 December 2008 diff hist +180 VbzCart/queries/qryRstkItms unsent for order Added cat_ittyps current
- 01:4901:49, 5 December 2008 diff hist +1,012 VbzCart/queries →Restocks: more queries, plus some reorg due to refined terminology; added terminology listing
- 01:4601:46, 5 December 2008 diff hist +73 VbzCart/queries/qryRstks active →Details: used by (2 queries)
- 01:4401:44, 5 December 2008 diff hist +18 m VbzCart/queries/qryRstks unsent →About: used by: ? current
- 01:4301:43, 5 December 2008 diff hist +18 m VbzCart/queries/qryRstkItms expected →About: used by: ?
- 01:4201:42, 5 December 2008 diff hist +25 VbzCart/queries/qryRstkItms unsent for order No edit summary
- 01:4001:40, 5 December 2008 diff hist −10 m VbzCart/queries/qryRstkItms unsent →SQL: oops, wrong name current
- 01:3901:39, 5 December 2008 diff hist +466 N VbzCart/queries/qryRstkItms unsent New page: ==About== * '''Returns''': items from restock requests which have not yet been submitted to the supplier * '''Requires''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryRstks_unsent}...
4 December 2008
- 23:2923:29, 4 December 2008 diff hist +108 VbzCart/queries/qryRstkItms expected post-move cleanup & doc
- 23:2223:22, 4 December 2008 diff hist +384 N VbzCart/queries/qryRstks unsent new query
- 23:1623:16, 4 December 2008 diff hist +58 N VbzCart/queries/qryRstkReq for order VbzCart/queries/qryRstkReq for order moved to VbzCart/queries/qryRstkItms unsent for order: more careful naming convention current
- 23:1623:16, 4 December 2008 diff hist 0 m VbzCart/queries/qryRstkItms unsent for order VbzCart/queries/qryRstkReq for order moved to VbzCart/queries/qryRstkItms unsent for order: more careful naming convention
- 23:0423:04, 4 December 2008 diff hist +283 VbzCart/tables/rstk req item +QtyCust; tidied documentation
- 21:5021:50, 4 December 2008 diff hist +60 VbzCart/queries/deprecated →Details: dropped
- 21:4821:48, 4 December 2008 diff hist +50 N VbzCart/queries/qryRstkItms en route VbzCart/queries/qryRstkItms en route moved to VbzCart/queries/qryRstkItms expected: reorganized terminology current
- 21:4821:48, 4 December 2008 diff hist 0 m VbzCart/queries/qryRstkItms expected VbzCart/queries/qryRstkItms en route moved to VbzCart/queries/qryRstkItms expected: reorganized terminology
- 21:0021:00, 4 December 2008 diff hist +152 US/NC/Durham →Religion: oh, yeah, and Mount Zion too
- 20:5420:54, 4 December 2008 diff hist +116 US/NC/Durham →Religion: misnomer ministries
- 19:1719:17, 4 December 2008 diff hist +28 VbzCart/queries →Restocks: qryRstkReq_for_order
- 19:1719:17, 4 December 2008 diff hist +889 N VbzCart/queries/qryRstkItms unsent for order adapted from Access version, using new restock tables
- 13:3913:39, 4 December 2008 diff hist +218 m merchant card processing Reverted edits by 221.11.27.110 (Talk); changed back to last version by Woozle
- 02:4302:43, 4 December 2008 diff hist +3,714 VbzCart/queries/deprecated →qryFrm_OrdLines_to_restock: and yet more obsolete stock queries
- 02:3702:37, 4 December 2008 diff hist −11,628 VbzCart/queries →Stock: moved queries to separate pages (except obsolete ones, which go on deprecated page)
- 02:3602:36, 4 December 2008 diff hist +723 N VbzCart/queries/qryStock Titles most recent New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_titles_remaining}} * '''Used by''': This defines what the "latest ... current
- 02:3602:36, 4 December 2008 diff hist +863 N VbzCart/queries/qryStock byOpt andType New page: ==Details== * '''Requires''': {{vbzcart/table|cat_items}}, {{vbzcart/table|cat_ioptns}}, {{vbzcart/table|cat_ittyps}} * '''Used by''': This is used for displaying the "stock" area on the w... current
- 02:3602:36, 4 December 2008 diff hist +1,088 N VbzCart/queries/qryStock forOpenOrders New page: ==Details== * '''Returns''': all stock available to fill open orders, along with helpful information about the Bin, Order, and Item * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin_wIn...
- 02:2402:24, 4 December 2008 diff hist +1,401 VbzCart/queries/deprecated →qryOrdLines_ord_status: more stock queries which use old restock tables
- 02:2302:23, 4 December 2008 diff hist +308 N VbzCart/queries/qryStk lines Title info New page: ==Details== * '''Requires''': {{vbzcart/table|stk_items}}, {{vbzcart/table|cat_items}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_Title_info A... current
- 02:1702:17, 4 December 2008 diff hist +979 VbzCart/queries/deprecated →qryRstkLines_en_route: qryOrdLines_ord_status
- 02:1102:11, 4 December 2008 diff hist +554 N VbzCart/queries/qryStkItms for sale wItem data New page: ==Details== * '''Requires''': {{vbzcart/query|qryStkItms_for_sale}} * '''Used by''': * '''Status''': this one may be redundant; the time when we need the item data is *after* all the sourc... current
- 02:0902:09, 4 December 2008 diff hist +521 N VbzCart/queries/qryStkItms for sale New page: ==Details== * '''Requires''': {{vbzcart/query|qryStk_lines_remaining_forSale}} * '''Used by''': {{vbzcart/query|qryStkItms_for_sale_wItem_data}} * '''History''': ** '''2008-11-17''' Create...
- 02:0802:08, 4 December 2008 diff hist +365 N VbzCart/queries/qryStk lines remaining forSale New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}} * '''Used by''': {{vbzcart/query|qryStkItms_for_sale}} * '''Note''': Eventually rename as "qryStkLines_for_sale" ==SQL...
- 02:0402:04, 4 December 2008 diff hist +452 N VbzCart/queries/qryStk byItem byBin wInfo 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...
- 02:0002:00, 4 December 2008 diff hist +433 N VbzCart/queries/v stk byItemAndBin wItemInfo New page: ==Details== * '''Status''': Is anything actually using this? '''Document!''' (I've tentatively removed the link in Access.) * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcar... current
- 01:5801:58, 4 December 2008 diff hist +568 N VbzCart/queries/qryStk byItem byBin 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/...
- 01:5601:56, 4 December 2008 diff hist +552 N VbzCart/queries/v stk titles remaining New page: ==Details== * '''Returns''': Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Title * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/query|cat_it... current
- 01:5401:54, 4 December 2008 diff hist +470 N VbzCart/queries/qryStk items remaining New page: ==Details== * '''Returns''': Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Item * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}} * '''Used by''': ==SQL=...
- 01:4901:49, 4 December 2008 diff hist +1,075 N VbzCart/queries/qryStk lines remaining New page: ==Details== * '''Returns''': {{vbzcart/table|stk_items}} actually in stock, which is actually different things: ** "forSale": items which are visible as "in stock" to customers ** "forShip...
- 00:3600:36, 4 December 2008 diff hist −10,891 VbzCart/queries →Restocks: moved deprecated queries to deprecated page, and the others to separate pages
- 00:3500:35, 4 December 2008 diff hist +664 N VbzCart/queries/qryRstkReq Item status Req info New page: ==Details== * '''Returns''': Data from {{vbzcart/query|qryRstkReq_Item_status}} with some additional info about the request * '''Requires''': {{vbzcart/query|qryRstkReq_Item_status}}, {{vb...
- 00:3400:34, 4 December 2008 diff hist +810 N VbzCart/queries/qryRstkReq Item status 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...
- 00:3200:32, 4 December 2008 diff hist +1,298 N VbzCart/queries/qryRstkReq Item Rcd status New page: ==Details== * '''Returns''': Information about received shipments for a given Item in a given Restock Request * '''Requires''': {{vbzcart/table|rstk_rcd_line}}, {{vbzcart/table|rstk_rcd}},... current
