Techna AR Selector update script Follow

Run this SQL when you ever need to register the integration tool for CRP branches:

Update Branch set ARSelector = 'QB1' where BranchID in ('BOU', 'BRG', 'CLR', 'COSP', 'COSM', 'CRP', 'DIM','DIOM', 'DISL','DPR', 'HOL','LGL', 'LGM','LOG', 'LOM', 'LVM', 'LVN', 'LVS', 'MRY', 'OGD', 'OGM', 'ORE', 'ORM', 'PEO', 'PKC', 'PLG',  'POR', 'POM','PRO', 'SAC', 'SAN', 'SAT', 'SLC', 'SLM', 'SOG', 'SPA', 'TAY', 'TOL', 'VER','WHS', 'WLV')

Update Branch set ARSelector = 'QB2' where BranchID in ('TLM', 'TLE')

Update Branch set ARSelector = 'QB3' where BranchID in ('RNO', 'RNM')

Update Branch set ARSelector = 'QB4' where BranchID = 'FRM'

Update Branch set ARSelector = 'QB5' where BranchID in ('FOUN', 'FOUNCRP')

Update Branch set ARSelector = 'QB6' where BranchID in ('STG', 'STM')

Update Branch set ARSelector = 'QB7' where BranchID in ('TBWY', 'TBWY01')

Update Branch set ARSelector = 'QB8' where BranchID in ('CTU', 'PCM', 'SFM', 'SPF')

Update Branch set ARSelector = 'QB9' where BranchID in ('CSA', 'CTC')

Update Branch set ARSelector = 'QB10' where BranchID in ('JAMS', 'JAMS001', 'JAMS002')

Update Branch set ARSelector = 'QB11' where BranchID in ('MEOR', 'MEOR001')

Update Branch set ARSelector = 'QB12' where BranchID in ('SDCA', 'SDCA01')

Update Branch set ARSelector = 'QB13' where BranchID = 'GRN'

Update Branch set ARSelector = 'QB14' where BranchID in ('BGCO','BGCO01')

 

 

Update Branch set ARSelector = 'QBA' where BranchID in ('GPNM', 'GPNM0969', 'GPNM0970', 'GPNM1177', 'GPNM1399', 'GPNM1456', 'GPNM1736', 'GPNM1737', 'GPNM1754', 'GPNM1937', 'GPNM1938', 'GPNM2951', 'GPNM3161', 'GPNM3162', 'GPNM3163', 'GPNM3164', 'GPNM3165', 'GPNM3166', 'GPNM3168', 'GPNM3169', 'GPNM3170', 'GPNM3250', 'GPNMCW1', 'GPNMMV1')


Update the IIF location for the franchisees with the server name below, then the franchisee data folder name,
and then the applicable franchisee branch folder. It fluctuates depending on branch.


Below is an example:

\\DC2TS297A\FranchiseeACCDATA\[Branch]\

Have more questions? Submit a request

Comments

Powered by Zendesk