Difference between revisions of "VbzCart/queries/discarded"

Latest revision as of 23:12, 3 March 2016

More Recent

The pages for these still need to be moved:

qryCat_Items - no longer even works
qryItms_to_restock_w_info - wasn't even migrated to current server
qryCtg_Titles_active
qryCtg_src
qryCtg_src_sub
qryItems_needed_forStock
qryRstkItms_active
- qryRstkItms_expected
  - qryRstkItms_expected_byItem - grouped by ID_Item
qryStk_History - combined current stock history and stk_history_legacy data
qryStock_containers - generated IDS codes
qryStock_forOpenOrders
qryStock_byOpt_andType
qryStock_by_Opt_Type
qryStock_by_Supp_Type_Opt - unused (and should be Supp_Opt_Type)
qryStock_Titles_most_recent
qryStkItms_for_sale_wItem_data
qryStk_byItem_byBin_wInfo - adds information to qryStk_byItem_byBin

@@ Line 1: / Line 1: @@
-==v_items==
+==More Recent==
-===Details===
+The pages for these still need to be moved:
-* '''Used by''': clsItemsExt (MS Access) -- as of 2008-11-30, this class does not seem to be in use anymore. It probably was not included in the big rescue operation when the old order DB developed some unopenable modules.
+* {{l/vc/query|qryCat_Items}} - no longer even works
-===SQL===
+* {{l/vc/query|qryItms_to_restock_w_info}} - wasn't even migrated to current server
-<section begin=sql /><mysql>CREATE OR REPLACE VIEW `v_items` AS
+* {{l/vc/query|qryCtg_Titles_active}}
-  SELECT
+* {{l/vc/query|qryCtg_src}}
-    i.ID,
+* {{l/vc/query|qryCtg_src_sub}}
-    i.CatNum,
+* {{l/vc/query|qryItems_needed_forStock}}
-    i.isForSale,
+* {{l/vc/query|qryRstkItms_active}}
-    i.isMaster,
+** {{l/vc/query|qryRstkItms_expected}}
-    i.qtyInStock,
+*** {{l/vc/query|qryRstkItms_expected_byItem}} - grouped by ID_Item
-    i.isInPrint,
+* {{l/vc/query|qryStk_History}} - combined current stock history and {{l/vc/table|stk_history_legacy}} data
-    i.isCloseOut,
+* {{l/vc/query|qryStock_containers}} - generated IDS codes
-    i.isPulled,
+* {{l/vc/query|qryStock_forOpenOrders}}
-    i.isDumped,
+* {{l/vc/query|qryStock_byOpt_andType}}
-    i.ID_Title,
+* {{l/vc/query|qryStock_by_Opt_Type}}
-    i.ID_ItTyp,
+* {{l/vc/query|qryStock_by_Supp_Type_Opt}} - unused (and should be Supp_Opt_Type)
-    i.ID_ItOpt,
+* {{l/vc/query|qryStock_Titles_most_recent}}
-    i.ItOpt_Descr,
+* {{l/vc/query|qryStkItms_for_sale_wItem_data}}
-    i.ID_ShipCost,
+* {{l/vc/query|qryStk_byItem_byBin_wInfo}} - adds information to {{l/vc/query|qryStk_byItem_byBin}}
-    i.PriceBuy,
-    i.PriceSell,
+==Older==
-    i.PriceList,
+* [[/v_items]]
-    i.Supp_CatNum,
+* [[/qryRstkReq_wItem_info]]
-    io.Sort AS OptSort
+* [[/qryCbx_Restocks_byStatus]]
-  FROM (
+* [[/qryCbx_Restocks_byPurchOrd]]
-    `cat_items` AS `i` LEFT JOIN
+* [[/qryCbx_Restocks]]
-    `cat_ioptns` AS `io` ON
-      ((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql>
-<section end=sql />
-==qryRstkReq_wItem_info==
-===Details===
-* '''Status''': not being used
-* '''History''':
-** '''2008-11-21''' Created for new restock process
-** '''2008-12-03''' officially abandoned
-===SQL===
-<mysql>CREATE OR REPLACE VIEW qryRstkReq_wItem_info AS
-SELECT
-  rqi.*,
-  i.ID_Title,
-  r.WhenCreated,
-  r.WhenOrdered
-FROM
-  (rstk_req_item AS rqi
-  LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)
-  LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql>

Difference between revisions of "VbzCart/queries/discarded"

Latest revision as of 23:12, 3 March 2016

More Recent

Older

Navigation menu

Search