View: dbo.Privilege_Requiring_Accounting_Or_Workpapers_View
View definition
-- Privileges to exclude from if there's no Accounting or Workpapers license.
-----------------------------------------------------------
-- If this list changes set Firm.has_Accounting and Firm.has_workpapers to true so
-- if the user doesn't have an Accounting or Workpapers license we'll react.
-----------------------------------------------------------
CREATE VIEW dbo.Privilege_Requiring_Accounting_Or_Workpapers_View
AS
SELECT
privilege_KEY = P.privilege_KEY
FROM
dbo.Privilege P
WHERE privilege_KEY IN (
506, -- ACS_Actions_BankTx_JrnEntry
484, -- ACS_Actions_BankTx_JrnEntry_View
27, -- ACS_Actions_BankTx_JrnEntry_Add
225, -- ACS_Actions_BankTx_JrnEntry_Edit
232, -- ACS_Actions_BankTx_JrnEntry_Del
1006, -- ACS_Actions_BankTx_JrnEntry_Recalc
146, -- ACS_Setup_FirmInfo_SecGroup_GL
148, -- ACS_Setup_FirmInfo_Staff_Sec_GL
598, -- ACS_Setup_FirmInfo_ClientSecGroup_GL
133, -- ACS_Setup_Client_AcctMask
411, -- ACS_Setup_Client_AcctMask_View
412, -- ACS_Setup_Client_AcctMask_Edit
135, -- ACS_Setup_Client_GL
419, -- ACS_Setup_Client_GL_View
420, -- ACS_Setup_Client_GL_Edit
134, -- ACS_Setup_CliTmpl_AcctMask
415, -- ACS_Setup_CliTmpl_AcctMask_View
416, -- ACS_Setup_CliTmpl_AcctMask_Edit
136, -- ACS_Setup_CliTmpl_GL
423, -- ACS_Setup_CliTmpl_GL_View
424, -- ACS_Setup_CliTmpl_GL_Edit
237, -- GL_Setup_Client
239, -- GL_Setup_Client_AcctMask
413, -- GL_Setup_Client_AcctMask_View
414, -- GL_Setup_Client_AcctMask_Edit
240, -- GL_Setup_Client_GL
421, -- GL_Setup_Client_GL_View
422, -- GL_Setup_Client_GL_Edit
241, -- GL_Setup_CliTmpl_AcctMask
417, -- GL_Setup_CliTmpl_AcctMask_View
418, -- GL_Setup_CliTmpl_AcctMask_Edit
242, -- GL_Setup_CliTmpl_GL
425, -- GL_Setup_CliTmpl_GL_View
426) -- GL_Setup_CliTmpl_GL_Edit