Difference between revisions of "VbzCart/queries/discarded"
Jump to navigation
Jump to search
(4 more) |
(→More Recent: many more queries no longer in database) |
||
| Line 10: | Line 10: | ||
** {{l/vc/query|qryRstkItms_expected}} | ** {{l/vc/query|qryRstkItms_expected}} | ||
*** {{l/vc/query|qryRstkItms_expected_byItem}} - grouped by ID_Item | *** {{l/vc/query|qryRstkItms_expected_byItem}} - grouped by ID_Item | ||
| − | + | * {{l/vc/query|qryStk_History}} - combined current stock history and {{l/vc/table|stk_history_legacy}} data | |
| + | * {{l/vc/query|qryStock_containers}} - generated IDS codes | ||
| + | * {{l/vc/query|qryStock_forOpenOrders}} | ||
| + | * {{l/vc/query|qryStock_byOpt_andType}} | ||
| + | * {{l/vc/query|qryStock_by_Opt_Type}} | ||
| + | * {{l/vc/query|qryStock_by_Supp_Type_Opt}} - unused (and should be Supp_Opt_Type) | ||
| + | * {{l/vc/query|qryStock_Titles_most_recent}} | ||
| + | * {{l/vc/query|qryStkItms_for_sale_wItem_data}} | ||
| + | * {{l/vc/query|qryStk_byItem_byBin_wInfo}} - adds information to {{l/vc/query|qryStk_byItem_byBin}} | ||
==Older== | ==Older== | ||
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
- qryRstkItms_expected
- 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