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