View: dbo.Privileges_Workpapers_View
View definition
`-- Privileges for Workpapers. CREATE VIEW dbo.Privileges_Workpapers_View AS SELECT privilege_KEY = P.privilege_KEY FROM dbo.Privilege P WHERE privilege_KEY IN ( 0, -- ACS 1, -- ACS_File 2, -- ACS_File_Import 1038, -- ACS_File_Import_CsConversion 1028, -- ACS_File_Import_Spreadsheet 1029, -- ACS_File_Import_Spreadsheet_COA 1033, -- ACS_File_Import_Spreadsheet_Transactions 1034, -- ACS_File_Import_Spreadsheet_QBBalances 1039, -- ACS_File_Import_ClientData 1040, -- ACS_File_Import_GenConversion 1041, -- ACS_File_Import_PopClientUT 1124, -- ACS_File_Import_ProSystemFx 1105, -- ACS_File_Import_QuickBooks, 1178, -- ACS_File_Import_Spreadsheet_XeroBalances 10, -- ACS_File_Exp 1103, -- ACS_File_Exp_ClientData 489, -- ACS_File_TransferClient 22, -- ACS_File_PrintRep 61, -- ACS_File_RepDesign 650, -- ACS_File_Backup 911, -- ACS_File_CDMU 211, -- ACS_File_Connect 3, -- ACS_Actions 35, -- ACS_Actions_BankTx 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 483, -- ACS_Actions_BankTx_EditMultBankTx 1082, -- ACS_Actions_AnalyzeCliAct 1098, -- ACS_Actions_AnalyzeCliAct_TrialBal 1099, -- ACS_Actions_AnalyzeCliAct_GL 1100, -- ACS_Actions_AnalyzeCliAct_FinStateWrksht 4, -- ACS_Setup 129, -- ACS_Setup_FirmInfo 14, -- ACS_Setup_FirmInfo_Firm 59, -- ACS_Setup_FirmInfo_Firm_Main 391, -- ACS_Setup_FirmInfo_Firm_Main_View 392, -- ACS_Setup_FirmInfo_Firm_Main_Edit 60, -- ACS_Setup_FirmInfo_Firm_Prefs 393, -- ACS_Setup_FirmInfo_Firm_Prefs_View 394, -- ACS_Setup_FirmInfo_Firm_Prefs_Edit 303, -- ACS_Setup_FirmInfo_Firm_Event 131, -- ACS_Setup_FirmInfo_Firm_CustFld 399, -- ACS_Setup_FirmInfo_Firm_CustFld_View 400, -- ACS_Setup_FirmInfo_Firm_CustFld_Edit 16, -- ACS_Setup_FirmInfo_SecGroup 570, -- ACS_Setup_FirmInfo_SecGroup_View 177, -- ACS_Setup_FirmInfo_SecGroup_Add 571, -- ACS_Setup_FirmInfo_SecGroup_Edit 176, -- ACS_Setup_FirmInfo_SecGroup_Del 116, -- ACS_Setup_FirmInfo_SecGroup_ACS 146, -- ACS_Setup_FirmInfo_SecGroup_GL 706, -- ACS_Setup_FirmInfo_SecGroup_WP 23, -- ACS_Setup_FirmInfo_SecGroup_Rep 15, -- ACS_Setup_FirmInfo_Staff 93, -- ACS_Setup_FirmInfo_Staff_Main 200, -- ACS_Setup_FirmInfo_Staff_Main_View 683, -- ACS_Setup_FirmInfo_Staff_Main_Add 346, -- ACS_Setup_FirmInfo_Staff_Main_Edit 201, -- ACS_Setup_FirmInfo_Staff_Main_Del 94, -- ACS_Setup_FirmInfo_Staff_Sec 347, -- ACS_Setup_FirmInfo_Staff_Sec_View 348, -- ACS_Setup_FirmInfo_Staff_Sec_Edit 144, -- ACS_Setup_FirmInfo_Staff_Sec_ACS 148, -- ACS_Setup_FirmInfo_Staff_Sec_GL 707, -- ACS_Setup_FirmInfo_Staff_Sec_WP 221, -- ACS_Setup_FirmInfo_Staff_Sec_Rep 132, -- ACS_Setup_FirmInfo_Staff_CustFld 344, -- ACS_Setup_FirmInfo_Staff_CustFld_View 345, -- ACS_Setup_FirmInfo_Staff_CustFld_Edit 154, -- ACS_Setup_FirmInfo_RepProf 188, -- ACS_Setup_FirmInfo_RepProf_View 189, -- ACS_Setup_FirmInfo_RepProf_Add 349, -- ACS_Setup_FirmInfo_RepProf_Edit 190, -- ACS_Setup_FirmInfo_RepProf_Del 17, -- ACS_Setup_Client 82, -- ACS_Setup_Client_Main 183, -- ACS_Setup_Client_Main_View 184, -- ACS_Setup_Client_Main_Add 409, -- ACS_Setup_Client_Main_Edit 120, -- ACS_Setup_Client_Main_Del 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 219, -- ACS_Setup_Client_Integrate 461, -- ACS_Setup_Client_Integrate_View 462, -- ACS_Setup_Client_Integrate_Edit 465, -- ACS_Setup_Client_StaffAccess 466, -- ACS_Setup_Client_StaffAccess_View 467, -- ACS_Setup_Client_StaffAccess_Edit 1078, -- ACS_Setup_Client_Event 137, -- ACS_Setup_Client_CustFld 468, -- ACS_Setup_Client_CustFld_View 469, -- ACS_Setup_Client_CustFld_Edit 607, -- ACS_Setup_Client_EditMult 18, -- ACS_Setup_CliTmpl 87, -- ACS_Setup_CliTmpl_Main 185, -- ACS_Setup_CliTmpl_Main_View 186, -- ACS_Setup_CliTmpl_Main_Add 410, -- ACS_Setup_CliTmpl_Main_Edit 187, -- ACS_Setup_CliTmpl_Main_Del 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 220, -- ACS_Setup_CliTmpl_Integrate 463, -- ACS_Setup_CliTmpl_Integrate_View 464, -- ACS_Setup_CliTmpl_Integrate_Edit 138, -- ACS_Setup_CliTmpl_CustFld 470, -- ACS_Setup_CliTmpl_CustFld_View 471, -- ACS_Setup_CliTmpl_CustFld_Edit 19, -- ACS_Setup_CustFld 139, -- ACS_Setup_CustFld_Firm 318, -- ACS_Setup_CustFld_Firm_View 319, -- ACS_Setup_CustFld_Firm_Add 320, -- ACS_Setup_CustFld_Firm_Edit 321, -- ACS_Setup_CustFld_Firm_Del 140, -- ACS_Setup_CustFld_Staff 322, -- ACS_Setup_CustFld_Staff_View 323, -- ACS_Setup_CustFld_Staff_Add 324, -- ACS_Setup_CustFld_Staff_Edit 325, -- ACS_Setup_CustFld_Staff_Del 141, -- ACS_Setup_CustFld_Client 326, -- ACS_Setup_CustFld_Client_View 327, -- ACS_Setup_CustFld_Client_Add 328, -- ACS_Setup_CustFld_Client_Edit 329, -- ACS_Setup_CustFld_Client_Del 40, -- ACS_Setup_COA 222, -- ACS_Setup_COA_View 223, -- ACS_Setup_COA_Add 595, -- ACS_Setup_COA_Edit 224, -- ACS_Setup_COA_Del 857, -- ACS_Setup_COA_EditMult 851, -- ACS_Setup_BankTxTmpl 852, -- ACS_Setup_BankTxTmpl_View 853, -- ACS_Setup_BankTxTmpl_Add 854, -- ACS_Setup_BankTxTmpl_Edit 855, -- ACS_Setup_BankTxTmpl_Del 153, -- ACS_Setup_RepProf 191, -- ACS_Setup_RepProf_View 192, -- ACS_Setup_RepProf_Add 350, -- ACS_Setup_RepProf_Edit 193, -- ACS_Setup_RepProf_Del 21, -- ACS_Setup_FileLoc 634, -- ACS_Setup_FileLoc_Integrate 637, -- ACS_Setup_FileLoc_Integrate_View 638, -- ACS_Setup_FileLoc_Integrate_Edit 636, -- ACS_Setup_FileLoc_Import 641, -- ACS_Setup_FileLoc_Import_View 642, -- ACS_Setup_FileLoc_Import_Edit 1096, -- ACS_Setup_GoFileRoom 1119, -- ACS_Setup_OnvioDocuments 20, -- ACS_Setup_UserPref 147, -- GL 151, -- GL_Actions 487, -- GL_Actions_TrialBal 651, -- GL_Actions_TrialBal_View 652, -- GL_Actions_TrialBal_ViewMaint 653, -- GL_Actions_TrialBal_ViewMaint_View 654, -- GL_Actions_TrialBal_ViewMaint_Add 655, -- GL_Actions_TrialBal_ViewMaint_Edit 656, -- GL_Actions_TrialBal_ViewMaint_Del 603, -- GL_Actions_TaxCodeAdj 604, -- GL_Actions_TaxCodeAdj_View 605, -- GL_Actions_TaxCodeAdj_Edit 404, -- GL_Actions_ViewAcctAct 405, -- GL_Actions_ViewNetIncLoss 621, -- GL_Actions_ConsCli 212, -- GL_Actions_ChngPostPrd 12, -- GL_Actions_PriorPeriod 156, -- GL_Setup 213, -- GL_Setup_FirmInfo 214, -- GL_Setup_FirmInfo_StdAccMap 361, -- GL_Setup_FirmInfo_StdAccMap_View 362, -- GL_Setup_FirmInfo_StdAccMap_Edit 215, -- GL_Setup_FirmInfo_FirmAccGroup 314, -- GL_Setup_FirmInfo_FirmAccGroup_View 315, -- GL_Setup_FirmInfo_FirmAccGroup_Add 316, -- GL_Setup_FirmInfo_FirmAccGroup_Edit 317, -- GL_Setup_FirmInfo_FirmAccGroup_Del 304, -- GL_Setup_FirmInfo_TaxCodes 305, -- GL_Setup_FirmInfo_TaxCodes_View 306, -- GL_Setup_FirmInfo_TaxCodes_Add 307, -- GL_Setup_FirmInfo_TaxCodes_Edit 308, -- GL_Setup_FirmInfo_TaxCodes_Del 309, -- GL_Setup_FirmInfo_Tick 310, -- GL_Setup_FirmInfo_Tick_View 311, -- GL_Setup_FirmInfo_Tick_Add 312, -- GL_Setup_FirmInfo_Tick_Edit 313, -- GL_Setup_FirmInfo_Tick_Del 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 238, -- GL_Setup_CliTmpl 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 216, -- GL_Setup_AccSeg 582, -- GL_Setup_AccSeg_View 583, -- GL_Setup_AccSeg_Add 584, -- GL_Setup_AccSeg_Edit 585, -- GL_Setup_AccSeg_Del 217, -- GL_Setup_AccGroup 586, -- GL_Setup_AccGroup_View 587, -- GL_Setup_AccGroup_Add 588, -- GL_Setup_AccGroup_Edit 589, -- GL_Setup_AccGroup_Del 41, -- GL_Setup_Jrn 623, -- GL_Setup_Jrn_View 624, -- GL_Setup_Jrn_Add 625, -- GL_Setup_Jrn_Edit 626, -- GL_Setup_Jrn_Del 488, -- GL_Setup_TaxCode 599, -- GL_Setup_TaxCode_View 600, -- GL_Setup_TaxCode_Add 601, -- GL_Setup_TaxCode_Edit 602, -- GL_Setup_TaxCode_Del 705, -- WP 805, -- WP_View 806, -- WP_View_WorkpapersDash 814, -- WP_View_WorkpapersDash_View 821, -- WP_View_WorkpapersDash_EngBinders 826, -- WP_View_WorkpapersDash_EngBinders_Workpapers 830, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Add 831, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Del 846, -- WP_View_WorkpapersDash_EngBinders_Workpapers_DiscardCheckout 1058, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Disconnect 1059, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Protect 1060, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Unprotect 832, -- WP_View_WorkpapersDash_EngBinders_Workpapers_SignOff 833, -- WP_View_WorkpapersDash_EngBinders_Workpapers_SignOff_Add 834, -- WP_View_WorkpapersDash_EngBinders_Workpapers_SignOff_Edit 835, -- WP_View_WorkpapersDash_EngBinders_Workpapers_SignOff_Del 836, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Properties 837, -- WP_View_WorkpapersDash_EngBinders_Workpapers_Properties_Edit 827, -- WP_View_WorkpapersDash_EngBinders_Folders 843, -- WP_View_WorkpapersDash_EngBinders_Folders_Add 844, -- WP_View_WorkpapersDash_EngBinders_Folders_Properties 845, -- WP_View_WorkpapersDash_EngBinders_Folders_Del 1011, -- WP_View_WorkpapersDash_EngBinders_TransRetrieve 1180, -- WP_View_WorkpapersDash_EngBinders_RecycleBin 1181, -- WP_View_WorkpapersDash_EngBinders_RecycleBin_EmptyBin 1182, -- WP_View_WorkpapersDash_EngBinders_RecycleBin_RestoreAll 1183, -- WP_View_WorkpapersDash_EngBinders_RecycleBin_Restore 1184, -- WP_View_WorkpapersDash_EngBinders_RecycleBin_Del 829, -- WP_View_WorkpapersDash_EngBinders_Notes 839, -- WP_View_WorkpapersDash_EngBinders_Notes_Edit 838, -- WP_View_WorkpapersDash_EngBinders_Notes_Add 841, -- WP_View_WorkpapersDash_EngBinders_Notes_Priority 842, -- WP_View_WorkpapersDash_EngBinders_Notes_Status 840, -- WP_View_WorkpapersDash_EngBinders_Notes_Del 908, -- WP_View_WorkpapersDash_EngBinders_Finalize 909, -- WP_View_WorkpapersDash_EngBinders_Unfinalize 963, -- WP_View_WorkpapersDash_EngBinders_RollForward 863, -- WP_View_WorkpapersDash_EngBinders_Print 807, -- WP_Setup 808, -- WP_Setup_EngBinders 809, -- WP_Setup_EngBinders_Main 810, -- WP_Setup_EngBinders_Main_View 811, -- WP_Setup_EngBinders_Main_Add 812, -- WP_Setup_EngBinders_Main_Edit 813, -- WP_Setup_EngBinders_Main_Del 815, -- WP_Setup_FirmInfo 816, -- WP_Setup_FirmInfo_SignOffTypes 817, -- WP_Setup_FirmInfo_SignOffTypes_View 818, -- WP_Setup_FirmInfo_SignOffTypes_Add 819, -- WP_Setup_FirmInfo_SignOffTypes_Edit 820) -- WP_Setup_FirmInfo_SignOffTypes_Del`