User contributions for Woozle

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot

Results for Woozle talk block log uploads logs

A user with 20,113 edits.

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
00:3100:31, 4 December 2008 diff hist +907 N VbzCart/queries/qryRstkItms expected New page: ==Details== * '''Returns''': Restock items requested, not yet received, but possibly expected because the restock request hasn't been closed or orphaned. * '''Requires''': {{vbzcart/table|...
00:2900:29, 4 December 2008 diff hist +779 N VbzCart/queries/qryRstkItms active New page: ==Details== * '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled). * '''Requires''': {{vbzcart/table|rstk_req_item}}, {...
00:2700:27, 4 December 2008 diff hist +669 VbzCart/queries/deprecated →qryFrm_RestockLines_byItem: qryRstkLines_en_route
00:2600:26, 4 December 2008 diff hist +1,087 N VbzCart/queries/qryRstks active New page: ==Details== * '''Returns''': List of restock requests for which we are currently expecting one or more shipments * '''Requires''': {{vbzcart/table|rstk_req}} * '''Used by''': * '''History'...
00:2300:23, 4 December 2008 diff hist +1,376 N VbzCart/queries/qryRstks info New page: ==Details== * '''Returns''': Information about restock requests and receipts, one line per receipt (or request, if nothing received) * '''Requires''': {{vbzcart/table|rstk_req}}, {{vbzcart... current
00:1000:10, 4 December 2008 diff hist +2,030 VbzCart/queries/deprecated →qryCbx_Restocks: two queries using rstk_lines
00:0500:05, 4 December 2008 diff hist +2,234 VbzCart/queries/deprecated qryCbx queries based on (obsolete) core_restocks

23:5423:54, 3 December 2008 diff hist +446 VbzCart/queries/discarded qryRstkReq_wItem_info
23:5023:50, 3 December 2008 diff hist +427 VbzCart/queries/deprecated v_rstk_lines_wItemInfo
23:4523:45, 3 December 2008 diff hist −2,254 VbzCart/queries →Packages: moved queries into separate pages
23:4523:45, 3 December 2008 diff hist +1,211 N VbzCart/queries/qryOrdLines open New page: ==Details== * '''Requires''': {{vbzcart/query|qryOrders_Active}}, {{vbzcart/query|qryPkgLines_byOrdLine_andItem}} * '''Used by''': * '''History''': ** '''2008-11-02''' +WhenNeeded, +WhenSt... current
23:4323:43, 3 December 2008 diff hist +735 N VbzCart/queries/qryOrdLines PkgdQtys New page: ==Details== * '''Requires''': {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}} * '''Used by''': order detail in Item table * '''History''': ** '''2008-11-21''... current
23:4123:41, 3 December 2008 diff hist +535 N VbzCart/queries/qryPkgLines byOrdLine andItem New page: ==Details== * '''Requires''': {{vbzcart/table|ord_pkg_lines}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryPkgLines_byOrdLine_andItem AS SELECT ID_OrdLi... current
21:3421:34, 3 December 2008 diff hist −308 VbzCart/queries →Customers: moved query to separate page
21:3421:34, 3 December 2008 diff hist +405 N VbzCart/queries/qryCustAddrs New page: ==Details== * '''Requires''': {{vbzcart/table|cust_addrs}} * '''Used by''': * '''Notes''': Any basic simple calculations not involving other tables can be added to this query as needed. ==... current
21:3221:32, 3 December 2008 diff hist −9,131 VbzCart/queries →Orders: split off queries into separate pages
21:3121:31, 3 December 2008 diff hist +765 N VbzCart/queries/qryItms to restock w info New page: ==Details== * '''Returns''': Same data as {{vbzcart/query|qryItms_to_restock}} but with additional info as needed for creating a restock request * '''Requires''': {{vbzcart/query|qryItms_t...
21:3021:30, 3 December 2008 diff hist +1,332 N VbzCart/queries/qryItms to restock New page: ==Details== * '''Returns''': List of items where we need more of them, either to fill orders or to meet minimum stock levels. Accounts for restock items already requested and items current... current
21:2821:28, 3 December 2008 diff hist +1,403 N VbzCart/queries/qryItms to restock union New page: ==Details== * '''Returns''': List of all items relevant to calculating items-to-restock, along with the relevant numbers (quantity on hand, quantity needed for orders...) but not combined ...
21:2521:25, 3 December 2008 diff hist +528 N VbzCart/queries/qryItms open New page: ==Details== * '''Returns''': Same rows as {{vbzcart/query|qryOrdItms_open}} but GROUPed by ID_Item * '''Requires''': {{vbzcart/query|qryOrdItms_open}} * '''Used by''': * '''History''': ** ... current
21:2521:25, 3 December 2008 diff hist +35 N Template:l/vc/query New page: [[VbzCart/queries/{{{1}}}|{{{1}}}]]
21:2321:23, 3 December 2008 diff hist +320 N VbzCart/queries/qryOrdItms open New page: ==Details== * '''Requires''': qryOrdItms_Pkg_qtys * '''Used by''': * '''History''': ** '''2008-11-16''' created for new restocking process ==SQL== <section begin... current
21:2221:22, 3 December 2008 diff hist +633 N VbzCart/queries/qryOrdItms Pkg qtys New page: ==Details== * '''Requires''': qryOrderLines_Active, qry_PkgItem_qtys_byOrder * '''Used by''': * '''History''': ** '''2008-11-16... current
21:1721:17, 3 December 2008 diff hist +1,132 N VbzCart/queries/qry PkgItem qtys byOrder New page: ==Details== * '''Returns''': data for items packaged for each order -- totals actually put into non-voided packages ("QtySent") and totals "handled" ("QtyDone" - sent ''or'' marked as n/a ... current
21:1421:14, 3 December 2008 diff hist +882 N VbzCart/queries/qtyOrderItems Active New page: ==Details== * '''Returns''': Same as qryOrderLines_Active, but by Item instead of OrdLine (and leaving out extra info about items which might return multiple re... current
21:1121:11, 3 December 2008 diff hist +585 N VbzCart/queries/qryOrderLines Active New page: ==Details== * '''Returns''': all order lines for orders which are currently active as determined by qryOrders_Active. * '''Requires''': {{vbzcart/table|ord_lines}},... current
21:0921:09, 3 December 2008 diff hist +487 VbzCart/queries/qryOrders Active alternate version current
21:0821:08, 3 December 2008 diff hist +841 N VbzCart/queries/qryOrders Active New page: ==Details== * '''Returns''': all orders which are currently active. For now, this just shows orders which haven't been pulled , but later it will look at the order state. As simple as it i...
21:0721:07, 3 December 2008 diff hist +889 N VbzCart/queries/qryOrderLines notPkgd New page: ==Details== * '''Returns''': Active order lines which have yet to be (completely) put into a package * '''Requires''': {{vbzcart/table|ord_lines}}, {{vbzcart/table|ord_pkg_lines}} * '''Use...
21:0621:06, 3 December 2008 diff hist +34 N Template:l/vc/table New page: [[VbzCart/tables/{{{1}}}|{{{1}}}]]
21:0321:03, 3 December 2008 diff hist +526 N VbzCart/queries/qryCbx Orders New page: ==Details== * '''Requires''': core_orders * '''Used by''': various forms, I think * '''Fields''': ** '''ID_Pull''' and '''WhenNeeded''' are needed for [[../qry...
18:3918:39, 3 December 2008 diff hist +110 m MediaWiki/archive/embedding Reverted edits by 66.63.165.62 (Talk); changed back to last version by 149.166.168.178

19:5619:56, 30 November 2008 diff hist −3,564 m VbzCart/queries →Catalog Sources: moved to separate pages
19:5619:56, 30 November 2008 diff hist +343 N VbzCart/queries/qryCtg build moved from single-page listing

Retrieved from "https://htyp.org/Special:Contributions/Woozle"