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