Please enable JavaScript to view this site.

Navigation: Schema:  > Tabellen

Roles: ionBIZ Rollen

Catalogus: ionBIZ

Label: Rollen

Ophalen: true

Tabelkolommen

De kolommen van de tabel Roles worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.

Naam

Datatype

Label

Verplicht

Documentatie

Active

boolean

itgen_ibz_active

 

ActivityOnTasksIsRequired

int32

itgen_ibz_activityontasksisrequired

 

ActivityTypeOnTasksIsRequired

boolean

itgen_ibz_activitytypeontasksisrequired

 

AllowAccessCosts

boolean

itgen_ibz_allowaccesscosts

 

AllowAccessToCostBudget

boolean

itgen_ibz_allowaccesstocostbudget

 

AllowAccessToCostsInclOH

boolean

itgen_ibz_allowaccesstocostsincloh

 

AllowAccessToCustomerAndProjectCostSheetHeader

boolean

itgen_ibz_allowaccesstocustomerandprojectcostsheetheader

 

AllowAccessToDoneButton

boolean

itgen_ibz_allowaccesstodonebutton

 

AllowAccessToDoneButtonMyTasks

boolean

itgen_ibz_allowaccesstodonebuttonmytasks

 

AllowAccessToHourlyRates

boolean

itgen_ibz_allowaccesstohourlyrates

 

AllowAccessToViewIssueSalesPrice

boolean

itgen_ibz_allowaccesstoviewissuesalesprice

 

AllowAccesToViewIssueBillable

boolean

itgen_ibz_allowaccestoviewissuebillable

 

AllowActualsGreaterThenAssigned

int32

itgen_ibz_allowactualsgreaterthenassigned

 

AllowCostsheetUnlock

boolean

itgen_ibz_allowcostsheetunlock

 

AllowEditResourceRequestForm

boolean

itgen_ibz_alloweditresourcerequestform

 

AllowInvoiceLock

boolean

itgen_ibz_allowinvoicelock

 

AllowInvoiceUnlock

boolean

itgen_ibz_allowinvoiceunlock

 

AllowPlanningDailyAutomaticEmailNotification

boolean

itgen_ibz_allowplanningdailyautomaticemailnotification

 

AllowPlanningDraft

boolean

itgen_ibz_allowplanningdraft

 

AllowPlanningOnSalesQuotes

boolean

itgen_ibz_allowplanningonsalesquotes

 

AllowProjectBaselineUnlock

boolean

itgen_ibz_allowprojectbaselineunlock

 

AllowProjectBaselineUnlockAccountManager

boolean

itgen_ibz_allowprojectbaselineunlockaccountmanager

 

AllowProjectBaselineUnlockProjectManager

boolean

itgen_ibz_allowprojectbaselineunlockprojectmanager

 

AllowProjectBaselineUnlockProjectSupervisor

boolean

itgen_ibz_allowprojectbaselineunlockprojectsupervisor

 

AllowPurchaseInvoiceUnlock

boolean

itgen_ibz_allowpurchaseinvoiceunlock

 

AllowSalesQuoteUnlock

boolean

itgen_ibz_allowsalesquoteunlock

 

AllowShowBaselineAndTotalActualsMyTask

boolean

itgen_ibz_allowshowbaselineandtotalactualsmytask

 

AllowTimesheetConfirmationTimesheetDiffersTimeregistration

boolean

itgen_ibz_allowtimesheetconfirmationtimesheetdifferstimeregistration

 

AllowToAddCostsUntilAdminClosingDate

boolean

itgen_ibz_allowtoaddcostsuntiladminclosingdate

 

AllowToAddDeleteCostsFromActuals

boolean

itgen_ibz_allowtoadddeletecostsfromactuals

 

AllowToAddDeleteCostsFromBudget

boolean

itgen_ibz_allowtoadddeletecostsfrombudget

 

AllowToAddInvoicesUntilAdminClosingDate

boolean

itgen_ibz_allowtoaddinvoicesuntiladminclosingdate

 

AllowToAddTags

boolean

itgen_ibz_allowtoaddtags

 

AllowToAddTimesheetsInConfirmedPeriods

boolean

itgen_ibz_allowtoaddtimesheetsinconfirmedperiods

 

AllowToAddTimesheetsUntilAdminClosingDate

boolean

itgen_ibz_allowtoaddtimesheetsuntiladminclosingdate

 

AllowToApproveAllCosts

boolean

itgen_ibz_allowtoapproveallcosts

 

AllowToApproveOwnLeaves

boolean

itgen_ibz_allowtoapproveownleaves

 

AllowToApproveOwnPlanningItems

boolean

itgen_ibz_allowtoapproveownplanningitems

 

AllowToCorrectInStock

boolean

itgen_ibz_allowtocorrectinstock

 

AllowToDeleteIssuesWithLinkedTimesheetOrInvoice

boolean

itgen_ibz_allowtodeleteissueswithlinkedtimesheetorinvoice

 

AllowToDeleteProjectsWithLinkedTimesheetCostOrInvoice

boolean

itgen_ibz_allowtodeleteprojectswithlinkedtimesheetcostorinvoice

 

AllowToDeleteShareSavedFilters

boolean

itgen_ibz_allowtodeletesharesavedfilters

 

AllowToEditApprovedLeaves

boolean

itgen_ibz_allowtoeditapprovedleaves

 

AllowToEditCostIds

boolean

itgen_ibz_allowtoeditcostids

 

AllowToEditExternalDocID

boolean

itgen_ibz_allowtoeditexternaldocid

 

AllowToEditInvoiceFrom

boolean

itgen_ibz_allowtoeditinvoicefrom

 

AllowToEditInvoiceScheduleSelectionOnTasks

boolean

itgen_ibz_allowtoeditinvoicescheduleselectionontasks

 

AllowToEditInvoicesIds

boolean

itgen_ibz_allowtoeditinvoicesids

 

AllowToEditItemIds

boolean

itgen_ibz_allowtoedititemids

 

AllowToEditIteration

boolean

itgen_ibz_allowtoedititeration

 

AllowToEditLeaveIds

boolean

itgen_ibz_allowtoeditleaveids

 

AllowToEditOwnCostsForApproval

boolean

itgen_ibz_allowtoeditowncostsforapproval

 

AllowToEditPlanningIds

boolean

itgen_ibz_allowtoeditplanningids

 

AllowToEditProjectActivity

boolean

itgen_ibz_allowtoeditprojectactivity

 

AllowToEditProjectIds

boolean

itgen_ibz_allowtoeditprojectids

 

AllowToEditPurchaseQuoteIds

boolean

itgen_ibz_allowtoeditpurchasequoteids

 

AllowToEditRelationsIds

boolean

itgen_ibz_allowtoeditrelationsids

 

AllowToEditResourceRequestsIds

boolean

itgen_ibz_allowtoeditresourcerequestsids

 

AllowToEditResourcesIds

boolean

itgen_ibz_allowtoeditresourcesids

 

AllowToEditSalesQuoteActivity

boolean

itgen_ibz_allowtoeditsalesquoteactivity

 

AllowToEditSalesQuotesIds

boolean

itgen_ibz_allowtoeditsalesquotesids

 

AllowToEditTicketIds

boolean

itgen_ibz_allowtoeditticketids

 

AllowToEditTimesheetIds

boolean

itgen_ibz_allowtoedittimesheetids

 

AllowToEditUnitCostOnItems

boolean

itgen_ibz_allowtoeditunitcostonitems

 

AllowToEditUnitPriceOnItems

boolean

itgen_ibz_allowtoeditunitpriceonitems

 

AllowToProcessSalesQuote

boolean

itgen_ibz_allowtoprocesssalesquote

 

AllowToRegisterTimesheetsOnSalesQuotes

boolean

itgen_ibz_allowtoregistertimesheetsonsalesquotes

 

AllowToSelectExchangeRatesOnInvoices

boolean

itgen_ibz_allowtoselectexchangeratesoninvoices

 

AllowToSelectFee

boolean

itgen_ibz_allowtoselectfee

 

AllowToSelectFromAllProjectsOnPlanning

boolean

itgen_ibz_allowtoselectfromallprojectsonplanning

 

AllowToSelectFromUnassignedTasks

int32

itgen_ibz_allowtoselectfromunassignedtasks

 

AllowToSelectTasksOutOfPeriodOnPlanning

boolean

itgen_ibz_allowtoselecttasksoutofperiodonplanning

 

AllowToSelectTimesheetsForFlexCalculation

boolean

itgen_ibz_allowtoselecttimesheetsforflexcalculation

 

AllowToShareSavedFilters

boolean

itgen_ibz_allowtosharesavedfilters

 

AllowToShareSavedFiltersOnHome

boolean

itgen_ibz_allowtosharesavedfiltersonhome

 

AllowToTransferLinesInInvoiceProposal

boolean

itgen_ibz_allowtotransferlinesininvoiceproposal

 

AllowToTransferTasksToOtherProjects

boolean

itgen_ibz_allowtotransfertaskstootherprojects

 

AllowToUpdateCustomerOnProposals

boolean

itgen_ibz_allowtoupdatecustomeronproposals

 

AllowToViewTotalActualAndTaskBaseline

boolean

itgen_ibz_allowtoviewtotalactualandtaskbaseline

 

AllowUpdateCostBudget

boolean

itgen_ibz_allowupdatecostbudget

 

BlockConfirmedPeriod

boolean

itgen_ibz_blockconfirmedperiod

 

CostAllowAccessToFieldBillable

boolean

itgen_ibz_costallowaccesstofieldbillable

 

CostAllowAccessToFieldReimburse

boolean

itgen_ibz_costallowaccesstofieldreimburse

 

CostAllowToEditApprovedCosts

boolean

itgen_ibz_costallowtoeditapprovedcosts

 

CostAllowToEditConfirmedCosts

boolean

itgen_ibz_costallowtoeditconfirmedcosts

 

CostAllowToEditInvoicedAndClosedCosts

boolean

itgen_ibz_costallowtoeditinvoicedandclosedcosts

 

Default

boolean

itgen_ibz_default

 

ExternalCode

string

itgen_ibz_externalcode

 

Id

int32

itgen_ibz_id

 

IsDeleted

boolean

itgen_ibz_isdeleted

 

IssueAllowToAssignUsers

boolean

itgen_ibz_issueallowtoassignusers

 

IssueAllowToUpdateActionRequiredBy

boolean

itgen_ibz_issueallowtoupdateactionrequiredby

 

IsSupport

boolean

itgen_ibz_issupport

 

MaximumRegistrationPerDay

decimal

itgen_ibz_maximumregistrationperday

 

Name

string

itgen_ibz_name

 

PasswordAccessOtherAccounts

string

itgen_ibz_passwordaccessotheraccounts

 

PlanningHideTaskPanel

boolean

itgen_ibz_planninghidetaskpanel

 

PlanningWorkLocation

int32

itgen_ibz_planningworklocation

 

RequestRequiresCustomerApproval

boolean

itgen_ibz_requestrequirescustomerapproval

 

SendingEmailNotificationForUnregisteredTime

boolean

itgen_ibz_sendingemailnotificationforunregisteredtime

 

Sequence

int32

itgen_ibz_sequence

 

TimesheetAllowAccessToPercentBillable

boolean

itgen_ibz_timesheetallowaccesstopercentbillable

 

TimesheetAllowToEditApprovedTimesheets

boolean

itgen_ibz_timesheetallowtoeditapprovedtimesheets

 

TimesheetAllowToEditConfirmedTimesheets

boolean

itgen_ibz_timesheetallowtoeditconfirmedtimesheets

 

TimesheetAllowToEditCurrency

boolean

itgen_ibz_timesheetallowtoeditcurrency

 

TimesheetAllowToEditInvoicedAndClosedTimesheets

boolean

itgen_ibz_timesheetallowtoeditinvoicedandclosedtimesheets

 

TimesheetGiveAccessToBillableNotBillable

boolean

itgen_ibz_timesheetgiveaccesstobillablenotbillable

 

TimesheetWorkLocation

int32

itgen_ibz_timesheetworklocation

 

UserTypeId

int32

itgen_ibz_usertypeid

 

 

22-12-2022 20:59 Versie 22.1.101-BETA+3681