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 | |||