On startup of the SSLIP, it will populate the UserOption table with all of the Control Module, so tools outside of Control can easily determine if a user has a particular module.
The Option Name is the name of the module (see the list below). And the Option Value is either “YES” or “NO”.
The following code could be used to determine if a particular business has the Accounting module …
DECLARE @HasAccountingModule BIT;
– Convert the resulting Yes or No into a Bit using this handy Cyrious Function
SET @HasAccountingModule = dbo.[Util.Conversion.TextToBit]( (
SELECT OptionValue
FROM UserOption
WHERE OptionName = 'Accounting'
), 0 )
;
PRINT @HasAccountingModule;