# Roles: ionBIZ Roles - Catalog: `ionBIZ` - Label: Roles - Retrieve: true ## Table Columns The columns of the table `Roles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `ActivityOnTasksIsRequired` | `int32` | Activity on Tasks is Required | ☐ | | | `ActivityTypeOnTasksIsRequired` | `boolean` | Activity Type on Tasks is Required | ☐ | | | `AllowAccessCosts` | `boolean` | Allow Access Costs | ☐ | | | `AllowAccessToCostBudget` | `boolean` | Allow Access to Cost Budget | ☐ | | | `AllowAccessToCostsInclOH` | `boolean` | Allow Access to Costs including Overhead | ☐ | | | `AllowAccessToCustomerAndProjectCostSheetHeader` | `boolean` | Allow Access to Customer and Project Cost Sheet Header | ☐ | | | `AllowAccessToDoneButton` | `boolean` | Allow Access to Done Button | ☐ | | | `AllowAccessToDoneButtonMyTasks` | `boolean` | Allow Access to Done Button My Tasks | ☐ | | | `AllowAccessToHourlyRates` | `boolean` | Allow Access to Hourly Rates | ☐ | | | `AllowAccessToViewIssueSalesPrice` | `boolean` | Allow Access to View Issue Sales Price | ☐ | | | `AllowAccesToViewIssueBillable` | `boolean` | Allow Access to View Issue Billable | ☐ | | | `AllowActualsGreaterThenAssigned` | `int32` | Allow Actuals Greater then Assigned | ☐ | | | `AllowCostsheetUnlock` | `boolean` | Allow Cost Sheet Unlock | ☐ | | | `AllowEditResourceRequestForm` | `boolean` | Allow Edit Resource Request Form | ☐ | | | `AllowInvoiceLock` | `boolean` | Allow Invoice Lock | ☐ | | | `AllowInvoiceUnlock` | `boolean` | Allow Invoice Unlock | ☐ | | | `AllowPlanningDailyAutomaticEmailNotification` | `boolean` | Allow Planning Daily Automatic Email Notification | ☐ | | | `AllowPlanningDraft` | `boolean` | Allow Planning Draft | ☐ | | | `AllowPlanningOnSalesQuotes` | `boolean` | Allow Planning on Sales Quotes | ☐ | | | `AllowProjectBaselineUnlock` | `boolean` | Allow Project Baseline Unlock | ☐ | | | `AllowProjectBaselineUnlockAccountManager` | `boolean` | Allow Project Baseline Unlock Account Manager | ☐ | | | `AllowProjectBaselineUnlockProjectManager` | `boolean` | Allow Project Baseline Unlock Project Manager | ☐ | | | `AllowProjectBaselineUnlockProjectSupervisor` | `boolean` | Allow Project Baseline Unlock Project Supervisor | ☐ | | | `AllowPurchaseInvoiceUnlock` | `boolean` | Allow Purchase Invoice Unlock | ☐ | | | `AllowSalesQuoteUnlock` | `boolean` | Allow Sales Quote Unlock | ☐ | | | `AllowShowBaselineAndTotalActualsMyTask` | `boolean` | Allow Show Baseline and Total Actuals my Task | ☐ | | | `AllowTimesheetConfirmationTimesheetDiffersTimeregistration` | `boolean` | Allow Timesheet Confirmation Timesheet differs Time Registration | ☐ | | | `AllowToAddCostsUntilAdminClosingDate` | `boolean` | Allow to Add Costs until Administrative Closing Date | ☐ | | | `AllowToAddDeleteCostsFromActuals` | `boolean` | Allow to Add Delete Costs from Actuals | ☐ | | | `AllowToAddDeleteCostsFromBudget` | `boolean` | Allow to Add Delete Costs from Budget | ☐ | | | `AllowToAddInvoicesUntilAdminClosingDate` | `boolean` | Allow to Add Invoices until Administrative Closing Date | ☐ | | | `AllowToAddTags` | `boolean` | Allow to Add Tags | ☐ | | | `AllowToAddTimesheetsInConfirmedPeriods` | `boolean` | Allow to Add Timesheets in Confirmed Periods | ☐ | | | `AllowToAddTimesheetsUntilAdminClosingDate` | `boolean` | Allow to Add Timesheets until Administrative Closing Date | ☐ | | | `AllowToApproveAllCosts` | `boolean` | Allow to Approve All Costs | ☐ | | | `AllowToApproveOwnLeaves` | `boolean` | Allow to Approve own Leaves | ☐ | | | `AllowToApproveOwnPlanningItems` | `boolean` | Allow to Approve own Planning Items | ☐ | | | `AllowToCorrectInStock` | `boolean` | Allow to Correct in Stock | ☐ | | | `AllowToDeleteIssuesWithLinkedTimesheetOrInvoice` | `boolean` | Allow to Delete Issues with Linked Timesheet or Invoice | ☐ | | | `AllowToDeleteProjectsWithLinkedTimesheetCostOrInvoice` | `boolean` | Allow to Delete Projects with Linked Timesheet Cost or Invoice | ☐ | | | `AllowToDeleteShareSavedFilters` | `boolean` | Allow to Delete Share Saved Filters | ☐ | | | `AllowToEditApprovedLeaves` | `boolean` | Allow to Edit Approved Leaves | ☐ | | | `AllowToEditCostIds` | `boolean` | Allow to Edit Cost IDs | ☐ | | | `AllowToEditExternalDocID` | `boolean` | Allow to Edit External Document ID | ☐ | | | `AllowToEditInvoiceFrom` | `boolean` | Allow to Edit Invoice from | ☐ | | | `AllowToEditInvoiceScheduleSelectionOnTasks` | `boolean` | Allow to Edit Invoice Schedule Selection on Tasks | ☐ | | | `AllowToEditInvoicesIds` | `boolean` | Allow to Edit Invoice IDs | ☐ | | | `AllowToEditItemIds` | `boolean` | Allow to Edit Item IDs | ☐ | | | `AllowToEditIteration` | `boolean` | Allow to Edit Iteration | ☐ | | | `AllowToEditLeaveIds` | `boolean` | Allow to Edit Leave IDs | ☐ | | | `AllowToEditOwnCostsForApproval` | `boolean` | Allow to Edit own Costs for Approval | ☐ | | | `AllowToEditPlanningIds` | `boolean` | Allow to Edit Planning IDs | ☐ | | | `AllowToEditProjectActivity` | `boolean` | Allow to Edit Project Activity | ☐ | | | `AllowToEditProjectIds` | `boolean` | Allow to Edit Project IDs | ☐ | | | `AllowToEditPurchaseQuoteIds` | `boolean` | Allow to Edit Purchase Quote IDs | ☐ | | | `AllowToEditRelationsIds` | `boolean` | Allow to Edit Relation IDs | ☐ | | | `AllowToEditResourceRequestsIds` | `boolean` | Allow to Edit Resource Request IDs | ☐ | | | `AllowToEditResourcesIds` | `boolean` | Allow to Edit Resource IDs | ☐ | | | `AllowToEditSalesQuoteActivity` | `boolean` | Allow to Edit Sales Quote Activity | ☐ | | | `AllowToEditSalesQuotesIds` | `boolean` | Allow to Edit Sales Quote IDs | ☐ | | | `AllowToEditTicketIds` | `boolean` | Allow to Edit Ticket IDs | ☐ | | | `AllowToEditTimesheetIds` | `boolean` | Allow to Edit Timesheet IDs | ☐ | | | `AllowToEditUnitCostOnItems` | `boolean` | Allow to Edit Unit Cost on Items | ☐ | | | `AllowToEditUnitPriceOnItems` | `boolean` | Allow to Edit Unit Price on Items | ☐ | | | `AllowToProcessSalesQuote` | `boolean` | Allow to Process Sales Quote | ☐ | | | `AllowToRegisterTimesheetsOnSalesQuotes` | `boolean` | Allow to Register Timesheets on Sales Quotes | ☐ | | | `AllowToSelectAnyRRFStatus` | `boolean` | Allow To Select Any RRF Status | ☐ | | | `AllowToSelectExchangeRatesOnInvoices` | `boolean` | Allow to Select Exchange Rates on Invoices | ☐ | | | `AllowToSelectFee` | `boolean` | Allow to Select Fee | ☐ | | | `AllowToSelectFromAllProjectsOnPlanning` | `boolean` | Allow to Select from All Projects on Planning | ☐ | | | `AllowToSelectFromUnassignedTasks` | `int32` | Allow to Select from Unassigned Tasks | ☐ | | | `AllowToSelectTasksOutOfPeriodOnPlanning` | `boolean` | Allow to Select Tasks out of Period on Planning | ☐ | | | `AllowToSelectTimesheetsForFlexCalculation` | `boolean` | Allow to Select Timesheets for Flex Calculation | ☐ | | | `AllowToShareSavedFilters` | `boolean` | Allow to Share Saved Filters | ☐ | | | `AllowToShareSavedFiltersOnHome` | `boolean` | Allow to Share Saved Filters on Home | ☐ | | | `AllowToTransferLinesInInvoiceProposal` | `boolean` | Allow to Transfer Lines in Invoice Proposal | ☐ | | | `AllowToTransferTasksToOtherProjects` | `boolean` | Allow to Transfer Tasks to Other Projects | ☐ | | | `AllowToUpdateCustomerOnProposals` | `boolean` | Allow to Update Customer on Proposals | ☐ | | | `AllowToViewTotalActualAndTaskBaseline` | `boolean` | Allow to View Total Actual and Task Baseline | ☐ | | | `AllowUpdateCostBudget` | `boolean` | Allow Update Cost Budget | ☐ | | | `BlockConfirmedPeriod` | `boolean` | Block Confirmed Period | ☐ | | | `CostAllowAccessToFieldBillable` | `boolean` | Cost Allow Access to Field Billable | ☐ | | | `CostAllowAccessToFieldReimburse` | `boolean` | Cost Allow Access to Field Reimburse | ☐ | | | `CostAllowToEditApprovedCosts` | `boolean` | Cost Allow to Edit Approved Costs | ☐ | | | `CostAllowToEditConfirmedCosts` | `boolean` | Cost Allow to Edit Confirmed Costs | ☐ | | | `CostAllowToEditInvoicedAndClosedCosts` | `boolean` | Cost Allow to Edit Invoiced and Closed Costs | ☐ | | | `Default` | `boolean` | Default | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IssueAllowToAssignUsers` | `boolean` | Issue Allow to Assign Users | ☐ | | | `IssueAllowToUpdateActionRequiredBy` | `boolean` | Issue Allow to Update Action Required by | ☐ | | | `IsSupport` | `boolean` | Is Support | ☐ | | | `MaximumRegistrationPerDay` | `decimal` | Maximum Registration per Day | ☐ | | | `Name` | `string` | Name | ☐ | | | `PasswordAccessOtherAccounts` | `string` | Password Access Other Accounts | ☐ | | | `PlanningHideTaskPanel` | `boolean` | Planning Hide Task Panel | ☐ | | | `PlanningWorkLocation` | `int32` | Planning Work Location | ☐ | | | `RequestRequiresCustomerApproval` | `boolean` | Request Requires Customer Approval | ☐ | | | `SendingEmailNotificationForUnregisteredTime` | `boolean` | Sending Email Notification for Unregistered Time | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `TimesheetAllowAccessToPercentBillable` | `boolean` | Timesheet Allow Access to Percentage Billable | ☐ | | | `TimesheetAllowToEditApprovedTimesheets` | `boolean` | Timesheet Allow to Edit Approved Timesheets | ☐ | | | `TimesheetAllowToEditConfirmedTimesheets` | `boolean` | Timesheet Allow to Edit Confirmed Timesheets | ☐ | | | `TimesheetAllowToEditCurrency` | `boolean` | Timesheet Allow to Edit Currency | ☐ | | | `TimesheetAllowToEditInvoicedAndClosedTimesheets` | `boolean` | Timesheet Allow to Edit Invoiced and Closed Timesheets | ☐ | | | `TimesheetGiveAccessToBillableNotBillable` | `boolean` | Timesheet Give Access to Billable/Not Billable | ☐ | | | `TimesheetWorkLocation` | `int32` | Timesheet Work Location | ☐ | | | `UserTypeId` | `int32` | User Type ID | ☐ | |