MYOB Exo – Application Names

Thanks to Roger Bray for providing this information initially. Behind the cut, a code block with an update statement, for forgetful consultants.

/** Update MODULE_SECURITY with application names */
UPDATE MODULE_SECURITY
SET MODULE_INFO =
	CASE APP_ID
	WHEN 1 THEN 'MYOB EXO Business'
	WHEN 2 THEN 'MYOB EXO Easyshop *'
	WHEN 100 THEN 'MYOB EXO Retail Manager *'
	WHEN 150 THEN 'MYOB EXO POS'
	WHEN 300 THEN 'MYOB EXO Job Costing'
	WHEN 310 THEN 'MYOB EXO Job Costing Timesheets'
	WHEN 500 THEN 'MYOB EXO Sales Order Workflow *'
	WHEN 510 THEN 'MYOB EXO Courier'
	WHEN 600 THEN 'MYOB EXO Fixed Assets'
	WHEN 700 THEN 'MYOB EXO Data Exchanger'
	WHEN 1100 THEN 'MYOB EXO Web Debtor Lookup *'
	WHEN 1300 THEN 'MYOB EXO Business Analytics'
	WHEN 1400 THEN 'MYOB EXO Business Config'
	WHEN 1500 THEN 'MYOB EXO Finance'
	WHEN 1600 THEN 'MYOB EXO Clarity Report Designer'
	WHEN 1700 THEN 'MYOB EXO Distribution Advantage'
	WHEN 1800 THEN 'MYOB EXO Interco Consolidations'
	WHEN 2000 THEN 'MYOB EXO Subscriptions'
	WHEN 2100 THEN 'MYOB EXO RMA *'
	WHEN 2200 THEN 'MYOB EXO SDK *'
	WHEN 2250 THEN 'MYOB EXO Payroll Integration'
	WHEN 2400 THEN 'MYOB EXO ClientConnect *'
	WHEN 2500 THEN 'MYOB EXO Business Web Manager'
	WHEN 2600 THEN 'MYOB EXO Intercompany Source'
	WHEN 2700 THEN 'MYOB EXO TAFE FBI *'
	WHEN 2800 THEN 'MYOB EXO Servicable Units'
	WHEN 3001 THEN 'MYOB EXO EFTPOS'
	WHEN 3002 THEN 'MYOB EXO Payment Gateway'
	WHEN 3004 THEN 'MYOB EXO Loyalty Gateway'
	WHEN 3005 THEN 'MYOB EXO Sales Analysis Matrix'
	WHEN 3006 THEN 'MYOB EXO POS Advantage'
	WHEN 3007 THEN 'MYOB EXO Voucher Gateway'
	WHEN 3100 THEN 'MYOB EXO Business CRM'
	WHEN 4300 THEN 'MYOB EXO Accountants Assistant'
	WHEN 4400 THEN 'MYOB EXO API'
	WHEN 4500 THEN 'MYOB EXO OnTheGo'
	WHEN 6000 THEN 'MYOB EXO Business DCE'
	WHEN 150001 THEN 'MYOB EXO Finance Direct Debits'
	ELSE NULL
	END
WHERE MODULE_INFO IS NULL OR MODULE_INFO = ''