---Update Branch_Information Set BR_Code='EN'
delete from AccessRights_Employees where User_Code<>'0001'
Update User_Logins Set Br_Code=(Select Br_Code from Branch_Information)

--Update Branch_Information set HasSwipeFeature=0,LogOutAfterTransaction=0,AppType='Retail'

----if user wants to logout after everytransaction---
------------------------------------------------------------------------------------------------------
--Update Branch_Information set LogOutAfterTransaction=1
------------------------------------------------------------------------------------------------------
----if swipe feature is available
------------------------------------------------------------------------------------------------------
--Update Branch_Information set HasSwipeFeature=1
---------------------------------------------------------------------------------------------------------

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Sizes List','Fittings List','Colors List','Multi Products')


Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Magazine Types','Customer Magazines Link','Customer Magazines Delivery','Rooms','Services','Services and Rooms Linking','Customer Compliments Letter','Customer Medical History List','Customer Compliments','Customer Recurring Deposits List','Shifts List','Shifts Definition')

delete from syskeys
delete from BankDetails
DELETE FROM Appointments_Sub_Detail
DELETE FROM Appointments_Detail
DELETE FROM Appointments_Master

delete from CashDrawer_Dtl
delete from CashDrawer_Log
delete from CashDrawer_Mst
delete from Customer_Compliments_Letters

DELETE FROM Customer_MedicalHistory_Link
DELETE FROM CustomerComplimentList
DELETE FROM CustomerMedicalHistoryList

delete from Customers
delete from CustomerType_Product_Qty_PriceList

delete from Customer_Types

delete from EndDay_BalancingDtl
delete from EndDay_BalancingMst
delete from Grn_Dtl
delete from Grn_Mst
delete from HoldSales_Dtl
delete from HoldSales_Mst


DELETE FROM Locations_Master where ShopFloor<>'Y'

DELETE FROM Log_Detail
DELETE FROM Log_MASTER

delete from Login_History

delete from Payment_Details
delete from PettyCash

delete from Product_Qty_PriceList where centralProductCode not in ('9999','0000','1111')
delete from Product_Supplier_BarCodes where centralProductCode not in ('9999','0000','1111')
delete from Product_Master where central_Product_Code not in ('9999','0000','1111')

delete from subcategories where Category_ID2 not in (Select SubcategoryID from Product_master where SubcategoryID is not null and central_Product_Code in ('9999','0000','1111'))
delete from Product_Categories_Level2 where Category_ID2 not in (Select Category_ID2 from Product_master where central_Product_Code in ('9999','0000','1111'))
delete from Product_Categories_Level1 where Category_ID1 not in (Select Category_ID1 from Product_master where central_Product_Code in ('9999','0000','1111'))and category_id1 not in (select category_id1 from subcategories)


delete from Product_StockList

delete from ProductMovement_Dtl
delete from ProductMovement_Mst
delete from Promotions_Detail
delete from Promotions_Master
delete from Purchase_Order_Details
delete from Purchase_Orders
DELETE FROM Purchase_Payment_Details
DELETE FROM Purchase_Inv_Entry_Detail
DELETE FROM Purchase_Inv_Entry_MASTER


DELETE FROM Purchase_Payment_mASTER

DELETE FROM Sales_Payment_Details
DELETE FROM Sales_Payment_MASTER

DELETE FROM Service_Rooms
DELETE FROM Service_Rooms_Linking
DELETE FROM Services_Users_Linking

DELETE FROM Services_MixedServices
DELETE FROM Services_Pricing
DELETE FROM Services_Master

delete from Refund_Detail
delete from Refund_Mst
delete from Repacking_Detail
delete from Repacking_Master

delete from Sales_Dtl
delete from Sales_Mst
delete from Stock_Transactions
delete from StockAdjustment_Dtl
delete from StockAdjustmentMaster

delete from Supplier_Details
--delete from TillSettings
DELETE FROM User_ClockIn_ClockOut

DELETE FROM User_Commissions_Dtl_Overall
DELETE FROM User_Commissions_Detail
DELETE FROM User_Salary_Log
DELETE FROM User_Commissions_mASTER
DELETE FROM User_Logins  where Usr_Code<>'0001'
--delete from Unit_Of_Measure
--delete from  Vat_Master