User Tools

Site Tools


hot_ket_setup

Hot Key Setup

You will need to connect to the store through SQL and run the following script on the Back Office server. Give it about 5 minutes to poll through and reload AR-PoS.

USE priarch
GO
  DECLARE @branch_no smallint
    SELECt @branch_no = branch_no FROM z_database_identity
    UPDATE pos_hotkey_hdr SET target_value = @branch_no
    WHERE guid NOT IN ('8CA31219-B6ED-4232-A158-62CB0522EA9B',
    '914FDEBE-925A-4183-8B75-6D370793FF59',
    '0309346A-8360-46D4-8302-9D7187E6A282')
    UPDATE pos_hotkey_det SET key_action = key_action
    UPDATE pos_hotkey_hdr SET target_value = 0, screen_status = 3
    WHERE guid IN ('8CA31219-B6ED-4232-A158-62CB0522EA9B',
    '914FDEBE-925A-4183-8B75-6D370793FF59',
    '0309346A-8360-46D4-8302-9D7187E6A282')
EXEC [dbo].[nimbus_TableDelete_PosHotkeyHdrAll]
UPDATE pos_hotkey_hdr SET  target_value = target_value
hot_ket_setup.txt · Last modified: 2016/07/21 09:37 by 82.148.34.141