View: dbo.Privilege_Requiring_Accounting_View
View definition
-- Privileges to exclude from ACS if there's no Accounting
-- license.
-----------------------------------------------------------
-- If this list changes set Firm.has_accounting to true so
-- if the user doesn't have a Accounting license we'll react.
-----------------------------------------------------------
-- SBPR never has the accounting license, so this doesn't
-- get applied to SBPR databases. Restrict points available
-- in SBPR with the dbo.Privileges_Sbpr_View View.
CREATE VIEW dbo.Privilege_Requiring_Accounting_View
AS
SELECT
privilege_KEY = P.privilege_KEY
FROM
dbo.Privilege P
WHERE privilege_KEY IN (
1030, -- ACS_File_Import_Spreadsheet_Cust
1032, -- ACS_File_Import_Spreadsheet_InvItems
1036, -- ACS_File_Import_Spreadsheet_APTrans
1037, -- ACS_File_Import_Spreadsheet_ARTrans
715, -- ACS_Actions_BankTx_APChk
716, -- ACS_Actions_BankTx_APChk_View
717, -- ACS_Actions_BankTx_APChk_Add
718, -- ACS_Actions_BankTx_APChk_Edit
719, -- ACS_Actions_BankTx_APChk_Del
724, -- ACS_Actions_BankTx_APChk_Del_Unprinted
725, -- ACS_Actions_BankTx_APChk_Del_Printed
726, -- ACS_Actions_BankTx_APChk_Del_Handwritten
727, -- ACS_Actions_BankTx_APChk_Del_Voided
736, -- ACS_Actions_BankTx_APChk_Void
737, -- ACS_Actions_BankTx_APChk_Reverse
985, -- ACS_Actions_BankTx_ArDep
986, -- ACS_Actions_BankTx_ArDep_View
987, -- ACS_Actions_BankTx_ArDep_Edit
988, -- ACS_Actions_BankTx_ArDep_Del
740, -- ACS_Actions_BankTx_ApPmt
742, -- ACS_Actions_BankTx_ApPmt_View
743, -- ACS_Actions_BankTx_ApPmt_Add
744, -- ACS_Actions_BankTx_ApPmt_Edit
745, -- ACS_Actions_BankTx_ApPmt_Del
746, -- ACS_Actions_BankTx_ApPmt_Void
747, -- ACS_Actions_BankTx_ApPmt_Reverse
507, -- ACS_Actions_BankTx_ChkSummary
233, -- ACS_Actions_BankTx_ChkSummary_View
234, -- ACS_Actions_BankTx_ChkSummary_Add
293, -- ACS_Actions_BankTx_ChkSummary_Edit
298, -- ACS_Actions_BankTx_ChkSummary_Del
709, -- ACS_Setup_FirmInfo_SecGroup_AP
859, -- ACS_Setup_FirmInfo_SecGroup_AR
710, -- ACS_Setup_FirmInfo_Staff_Sec_AP
860, -- ACS_Setup_FirmInfo_Staff_Sec_AR
711, -- ACS_Setup_FirmInfo_ClientSecGroup_AP
861, -- ACS_Setup_FirmInfo_ClientSecGroup_AR
759, -- ACS_Setup_Client_AP
760, -- ACS_Setup_Client_AP_View
761, -- ACS_Setup_Client_AP_Edit
917, -- ACS_Setup_Client_AR
918, -- ACS_Setup_Client_AR_View
919, -- ACS_Setup_Client_AR_Edit
790, -- ACS_Setup_CliTmpl_AP
795, -- ACS_Setup_CliTmpl_AP_View
796, -- ACS_Setup_CliTmpl_AP_Edit
924, -- ACS_Setup_CliTmpl_AR
925, -- ACS_Setup_CliTmpl_AR_View
926, -- ACS_Setup_CliTmpl_AR_Edit
950, -- GL_Setup_CustFld_Cust
951, -- GL_Setup_CustFld_Cust_View
952, -- GL_Setup_CustFld_Cust_Add
953, -- GL_Setup_CustFld_Cust_Edit
954, -- GL_Setup_CustFld_Cust_Del
788, -- AP_File_PrintChk
789, -- AP_File_PrintChk_AP
1048, -- AP_File_Import_Spreadsheet_APTrans
712, -- AP_Actions
713, -- AP_Actions_BankTx
714, -- AP_Actions_BankTx_APChk
720, -- AP_Actions_BankTx_APChk_View
721, -- AP_Actions_BankTx_APChk_Add
722, -- AP_Actions_BankTx_APChk_Edit
723, -- AP_Actions_BankTx_APChk_Del
730, -- AP_Actions_BankTx_APChk_Del_Unprinted
731, -- AP_Actions_BankTx_APChk_Del_Printed
732, -- AP_Actions_BankTx_APChk_Del_Handwritten
733, -- AP_Actions_BankTx_APChk_Del_Voided
738, -- AP_Actions_BankTx_APChk_Void
739, -- AP_Actions_BankTx_APChk_Reverse
741, -- AP_Actions_BankTx_ApPmt
748, -- AP_Actions_BankTx_ApPmt_View
749, -- AP_Actions_BankTx_ApPmt_Add
750, -- AP_Actions_BankTx_ApPmt_Edit
751, -- AP_Actions_BankTx_ApPmt_Del
752, -- AP_Actions_BankTx_ApPmt_Void
753, -- AP_Actions_BankTx_ApPmt_Reverse
798, -- AP_Actions_Payables
799, -- AP_Actions_Payables_Liab
800, -- AP_Actions_Payables_CreditMemo
801, -- AP_Actions_MngPmt
1007, -- AP_Actions_ChangeAPDate
802, -- AP_Setup_FirmInfo
804, -- AP_Setup_FirmInfo_PmtTerms
968, -- AP_Setup_FirmInfo_PmtTerms_View
970, -- AP_Setup_FirmInfo_PmtTerms_Add
972, -- AP_Setup_FirmInfo_PmtTerms_Edit
974, -- AP_Setup_FirmInfo_PmtTerms_Del
755, -- AP_Setup_Client
756, -- AP_Setup_Client_AP
757, -- AP_Setup_Client_AP_View
758, -- AP_Setup_Client_AP_Edit
791, -- AP_Setup_CliTmpl
792, -- AP_Setup_CliTmpl_AP
793, -- AP_Setup_CliTmpl_AP_View
794, -- AP_Setup_CliTmpl_AP_Edit
803, -- AR_File
862, -- AR_File_PrintARForms
912, -- AR_File_Import
913, -- AR_File_Import_Spreadsheet
915, -- AR_File_Import_Spreadsheet_Cust
1042, -- AR_File_Import_Spreadsheet_InvItems
914, -- AR_File_Import_Spreadsheet_ARTrans
865, -- AR_Actions
980, -- AR_Actions_BankTx
981, -- AR_Actions_BankTx_ArDep
982, -- AR_Actions_BankTx_ArDep_View
983, -- AR_Actions_BankTx_ArDep_Edit
984, -- AR_Actions_BankTx_ArDep_Del
866, -- AR_Actions_EnterInv
869, -- AR_Actions_MngCustPmt
870, -- AR_Actions_ApplyCustPmt
868, -- AR_Actions_AssessFinChrg
910, -- AR_Actions_EnterDeposits
976, -- AR_Actions_EnterDeposits_View
977, -- AR_Actions_EnterDeposits_Add
978, -- AR_Actions_EnterDeposits_Edit
979, -- AR_Actions_EnterDeposits_Del
1012, -- AR_Actions_ChangeARDate
873, -- AR_Setup_FirmInfo_PmtTerms
969, -- AR_Setup_FirmInfo_PmtTerms_View
971, -- AR_Setup_FirmInfo_PmtTerms_Add
973, -- AR_Setup_FirmInfo_PmtTerms_Edit
975, -- AR_Setup_FirmInfo_PmtTerms_Del
879, -- AR_Setup_Client
880, -- AR_Setup_Client_AR
881, -- AR_Setup_Client_AR_View
882, -- AR_Setup_Client_AR_Edit
920, -- AR_Setup_CliTmpl
921, -- AR_Setup_CliTmpl_AR
922, -- AR_Setup_CliTmpl_AR_View
923, -- AR_Setup_CliTmpl_AR_Edit
945, -- AR_Setup_CustFld_Cust
946, -- AR_Setup_CustFld_Cust_View
947, -- AR_Setup_CustFld_Cust_Add
948, -- AR_Setup_CustFld_Cust_Edit
949, -- AR_Setup_CustFld_Cust_Del
883, -- AR_Setup_Cust
927, -- AR_Setup_Cust_Main
884, -- AR_Setup_Cust_Main_View
885, -- AR_Setup_Cust_Main_Add
886, -- AR_Setup_Cust_Main_Edit
887, -- AR_Setup_Cust_Main_Del
928, -- AR_Setup_Cust_AR
929, -- AR_Setup_Cust_AR_View
930, -- AR_Setup_Cust_AR_Edit
931, -- AR_Setup_Cust_Reg
932, -- AR_Setup_Cust_Notes
933, -- AR_Setup_Cust_Notes_View
934, -- AR_Setup_Cust_Notes_Edit
935, -- AR_Setup_Cust_CustFld
936, -- AR_Setup_Cust_CustFld_View
937, -- AR_Setup_Cust_CustFld_Edit
888, -- AR_Setup_InvItems
889, -- AR_Setup_InvItems_View
890, -- AR_Setup_InvItems_Add
891, -- AR_Setup_InvItems_Edit
892, -- AR_Setup_InvItems_Del
893, -- AR_Setup_FinChrg
894, -- AR_Setup_FinChrg_View
895, -- AR_Setup_FinChrg_Add
896, -- AR_Setup_FinChrg_Edit
897) -- AR_Setup_FinChrg_Del