Description
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”.
Module Names
- Estimating
- WorkOrder
- Invoicing
- Payments
- Accounting
- Marketing
- Parts
- Macro
- Customizable
- Inventory
- TechSSLIP
- CreditCard
- Beta
- Shipping
- ServiceTicket
- BarCoding
- Course
- Accounting
- OnlineTax
- WebView
- Payroll
- ProFITS
- CCubed
- OnlineArtworkApproval
Example
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;
<code>
You could leave a comment if you were logged in.