Advanced Retail (UK) Ltd
Company Wiki

Some common and useful SPs used on a daily basis:

From HO

[dbo].[traxs_EOD_ResendPOs_Single] @guid='?'
[dbo].[traxs_Promotions_ImplementAll]

traxs_Promotions_ImplementAll @include_prices = 0
nimbus_ApplicationCommands_ReloadPromos_All

[dbo].[traxs_Promotions_PopulateItems]
EXEC [dbo].[traxs_Promotions_ImplementAll] @exclude_price_rebuild = 1
traxs_Diagnostics_BranchList
[dbo].[traxs_Utility_StockRewind]
[dbo].[nimbus_PoSImage_GetForTerminal] @terminal_id = ?
[dbo].[nimbus_ApplicationCommands_LoadPosImages_All] or [dbo].[nimbus_ApplicationCommands_LoadPosImages] @terminal_id = ?
EXEC traxs_Utility_SwapStocks_AllWarehouses  @product = ?,   @product_new = ?,  @user_no = ?

EXEC [dbo].[traxs_ReplenishmentOrder_ScheduleChange_Wrap] @offset = 1, @test_eval = 1
  
-- ran new store requests job
EXEC [petscorner].[traxs_ReplenishmentForNewStore] @whse_no = ?, @stock_whse = 1, @option = 1
EXEC [petscorner].[traxs_ReplenishmentForNewStore_ConsumablesOnly] @whse_no = ?, @stock_whse = 1 
  
EXEC [dbo].[traxs_ReplenishmentRequest_CreateSystemRequests] @default_whse_no = ?, @stock_whse_no = 1
EXEC traxs_Engineer_ReplenishmentRequest_ReRunRequestandAlloc	
@whse_no_requesting = 283,
@stock_whse_no = 607

select * from vw_salesorders where order_ref = ? 
EXEC  [petscorner].[traxs_SalesOrder_ForceComplete] @hdr_id = ?
EXEC traxs_SalesOrdersProducts_CancelOrder @sales_order_id = ?, @force = 1
EXEC  traxs_SalesOrders_ReinstateFromCancelled @hdr_id = ?
  
EXEC [warehouse].[traxs_Warehouse_Allocation] @stock_whse = 607
   
exec traxs_SalesOrders_FinalPrices_Recalc @hdr_id = ?

-- weekly takings report produced daily
exec traxs_JobQueue2_Immediate_AddJob_ManagementReport @email_address = 'gd@advanced-retail.co.uk'

​https://handcross.petfamily-branch.co.uk/WarehouseDispatch/DispatchSalesOrderReport.aspx?hdr_id=2930

EDI server details
SELECT * FROM data_destination

-- add new user to use Sales Order branding
SELECT * FROM websites.sites WHERE instance IN (1, 2) AND instance_site_no IS NULL

EXEC traxs_Engineer_SalesOrderUser_Add
@user_no = 3804,
@site_no = 9
  
-- picker and packer
SELECT packed_user_no, packed_users_id, * FROM vw_SalesOrder_Hdr WHERE order_ref = '1000125930'

-- we careful with this as it will show picks not completed
SELECT user_no_assigned, users_id_assigned, * FROM vw_SalesOrdersPick_Full WHERE order_ref = '1000125930' ORDER BY pick_created
  
exec traxs_ProcessId_List
EXEC traxs_ProcessForID @spid = 121
  
 

switch off Logon Encryption

UPDATE traxs_config SET boolean_value = 0 WHERE row_id = 290

From Store

[dbo].[traxs_PricesLive_Rebuild_Wrap]
[dbo].[traxs_PricesLive_Rebuild] @list_no='?'
[dbo].[traxs_Mobile_ProcessData]
[dbo].[traxs_Mobile_HHTPopulate]
[dbo].[traxs_Mobile_HHTPopulate_PO]
traxs_Utility_Stock_CheckVsMovements @whse_no=100
traxs_Utility_Stock_CheckVsMovements_OneProduct @whse_no=100,@product= 104980
traxs_ProductBranch_UpdateFromMinMax_Catchup
EXEC nimbus_User_Fingerprint_Reset @user_no = ?
[dbo].[traxs_Utility_StockRewindLocal]
traxs_Engineer_PromoRebuildWithTruncateCache
traxs_Engineer_TransferOutToBranch_FixDestination
traxs_EOD_ResendMovements @date_from = ?
traxs_EOD_ResendMovements @date_from = ?, @date_to = ?
traxs_ReplenishmentRequest_ExecuteFromSchedule @force = 1
EXEC traxs_Engineer_VerifyUserForPasswordReset @user_no = 638
SELECT * FROM [vw_LookupValues_MobileData_UsedFor]

From NDS

traxs_Engineer_WebPick_Remove  @transaction_ref = '?' -- changes status to 100 and removes from webpick screen
traxs_Engineer_Picks_FixDeleted] @allocation_pick = ?, @guid_safety = '36F932F1-B48F-4021-856B-14DCF8F1D031'  
traxs_Engineer_Picks_Fixstep] check params?

http://192.168.120.100/traxs/FileMaint_System/Driver.aspx
http://192.168.120.100/traxs/RouteMaintenance/RouteMaintenance.aspx 

Rebuilt triggers on the server:

[dbo].[nimbus_DataDistribution_Triggers_Create]

Also the following would be useful: An SP to reset mobile data @mobile_data_id='?' An SP or view indicating replenishment details

traxs_Polling_Triggers_CreateWrap @am_ho=?     --- to define if running at HO or not

Software versioning

software versions by store
[software_control].[dbo].[usp_VersionControl_DeployedVersions_Get]

software version by version
[software_control].[dbo].[usp_VersionControl_DeployedVersions_Count_Get]

TraxsMobile software version by device
[software_control].[dbo].[usp_VersionControl_DeployedVersions_MobileStore_Get]

Views

replenishmentorder
select * from vw_ProductAlternatives
select * from vw_ImmediateJobs
select * from vw_JobQueue2_ScheduledJobs_Now
select * from vw_JobQueue2_ScheduledJobs_Current
select * from vw_Movements
select * from vw_MovementsAll
select * from vw_Product1
[dbo].[vw_ProductsWithSupplier] 
[dbo].[vw_ReplenishmentRequest]
[dbo].[vw_ReportsScheduled]
[dbo].[vw_StockPosition]
[dbo].[vw_StocktakeScheduled_Hdr]
[dbo].[vw_StocktakeScheduled_Det]
[dbo].[vw_SupplierDiscount]
[dbo].[vw_TerminalBranch]
[dbo].[vw_TerminalBranchWarehouse]
[dbo].[vw_TerminalToBranch]
[dbo].[vw_ProductPrice]
[dbo].[vw_ProductPrices]
[dbo].[vw_ProductAttribute]

On Polling Server to identify outstanding tables to poll

[dbo].[traxs_Server__System_TablesToGo] 1

On new Kendo version to identify menu options and aspx pages

SELECT * FROM vw_Page WHERE description LIKE '%invoke%'