View: dbo.Privilege_Requiring_Payroll_View | |||
View definition | |||
-- Privileges to exclude if there's no Payroll license -- Payroll ----------------------------------------------------------- -- If this list changes set Firm.has_payroll to true so -- if the user doesn't have a Payroll license we'll react. ----------------------------------------------------------- CREATE VIEW dbo.Privilege_Requiring_Payroll_View AS SELECT privilege_KEY = P.privilege_KEY FROM dbo.Privilege P WHERE privilege_KEY IN ( 230, -- SBPR_Actions_ImpBankRec 31, -- SBPR_Actions_ImpBankRec_View 155, -- SBPR_Actions_ImpBankRec_CreateAdj 629, -- SBPR_Actions_ImpBankRec_UnfinalRec 42, -- SBPR_Setup_FirmInfo_ImpBankAcc 56, -- SBPR_Setup_FirmInfo_ImpBankAcc_Main 253, -- SBPR_Setup_FirmInfo_ImpBankAcc_Main_View 254, -- SBPR_Setup_FirmInfo_ImpBankAcc_Main_Add 385, -- SBPR_Setup_FirmInfo_ImpBankAcc_Main_Edit 255, -- SBPR_Setup_FirmInfo_ImpBankAcc_Main_Del 57, -- SBPR_Setup_FirmInfo_ImpBankAcc_ChkLayout 386, -- SBPR_Setup_FirmInfo_ImpBankAcc_ChkLayout_View 387, -- SBPR_Setup_FirmInfo_ImpBankAcc_ChkLayout_Edit 390, -- SBPR_Setup_FirmInfo_ImpBankAcc_ChkLayout_MICR 58, -- SBPR_Setup_FirmInfo_ImpBankAcc_DirDep 388, -- SBPR_Setup_FirmInfo_ImpBankAcc_DirDep_View 389) -- SBPR_Setup_FirmInfo_ImpBankAcc_DirDep_Edit | |||