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