Please enable JavaScript to view this site.

Navigation: Schema:  > Tabellen

Resources: ionBIZ Resources

Catalogus: ionBIZ

Label: Resources

Ophalen: true

Tabelkolommen

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

Naam

Datatype

Label

Verplicht

Documentatie

AccountManager

boolean

itgen_ibz_accountmanager

 

Active

boolean

itgen_ibz_active

 

Address_CountryId

int32

itgen_ibz_address_countryid

 

AllowAccessToViewIssueSalesPrice

boolean

itgen_ibz_allowaccesstoviewissuesalesprice

 

AllowAccesToViewIssueBillable

boolean

itgen_ibz_allowaccestoviewissuebillable

 

BadgingRequired

boolean

itgen_ibz_badgingrequired

 

BankAccount

string

itgen_ibz_bankaccount

 

Bic

string

itgen_ibz_bic

 

Birthdate

datetimeoffset

itgen_ibz_birthdate

 

CanSyncExchange

boolean

itgen_ibz_cansyncexchange

 

Color

string

itgen_ibz_color

 

CreationDate

datetimeoffset

itgen_ibz_creationdate

 

CreatorId

int32

itgen_ibz_creatorid

 

CurrencyId

int32

itgen_ibz_currencyid

 

CVPicture

byte[]

itgen_ibz_cvpicture

 

CVSkillLevelColorOne

string

itgen_ibz_cvskilllevelcolorone

 

CVSkillLevelColorTwo

string

itgen_ibz_cvskilllevelcolortwo

 

CVText1

string

itgen_ibz_cvtext1

 

CVText2

string

itgen_ibz_cvtext2

 

DeletedById

int32

itgen_ibz_deletedbyid

 

DeletionDate

datetimeoffset

itgen_ibz_deletiondate

 

DepartmentId

int32

itgen_ibz_departmentid

 

Email

string

itgen_ibz_email

 

EnableMfa

boolean

itgen_ibz_enablemfa

 

EndDate

datetimeoffset

itgen_ibz_enddate

 

ExternalCode

string

itgen_ibz_externalcode

 

FlexOTCounterDayFrom

datetimeoffset

itgen_ibz_flexotcounterdayfrom

 

FullName

string

itgen_ibz_fullname

 

FunctionId

int32

itgen_ibz_functionid

 

Iban

string

itgen_ibz_iban

 

Id

int32

itgen_ibz_id

 

IncludeBreakInTimeRegistration

boolean

itgen_ibz_includebreakintimeregistration

 

Initials

string

itgen_ibz_initials

 

IsDeleted

boolean

itgen_ibz_isdeleted

 

IsProjectManager

boolean

itgen_ibz_isprojectmanager

 

Language

string

itgen_ibz_language

 

LocationId

int32

itgen_ibz_locationid

 

MobilePhone

string

itgen_ibz_mobilephone

 

ModifiedById

int32

itgen_ibz_modifiedbyid

 

Name

string

itgen_ibz_name

 

Name2

string

itgen_ibz_name2

 

PayrollCode

string

itgen_ibz_payrollcode

 

PeriodicTimesheetConfirmationDuration

int32

itgen_ibz_periodictimesheetconfirmationduration

 

Picture

byte[]

itgen_ibz_picture

 

PlaceOfBirth

string

itgen_ibz_placeofbirth

 

PlanningSynchronizationDefaultToPrimaryCalendar

boolean

itgen_ibz_planningsynchronizationdefaulttoprimarycalendar

 

PlanningSynchronizationExchangeCalendarId

string

itgen_ibz_planningsynchronizationexchangecalendarid

 

PlanningSynchronizationExchangeCalendarName

string

itgen_ibz_planningsynchronizationexchangecalendarname

 

PlanningSynchronizationShowIonSyncTicketDropdown

boolean

itgen_ibz_planningsynchronizationshowionsyncticketdropdown

 

PrivateEmailAddress

string

itgen_ibz_privateemailaddress

 

PrivateMobilePhone

string

itgen_ibz_privatemobilephone

 

ProjectManager

boolean

itgen_ibz_projectmanager

 

RequiredPercentageTimesheetConfirmation

int32

itgen_ibz_requiredpercentagetimesheetconfirmation

 

ResourceCategory

int32

itgen_ibz_resourcecategory

 

ResourceLanguageId

int32

itgen_ibz_resourcelanguageid

 

ResourceTypeId

int32

itgen_ibz_resourcetypeid

 

RoleId

int32

itgen_ibz_roleid

 

SendDailyEmailNotificationForProjectPlanning

boolean

itgen_ibz_senddailyemailnotificationforprojectplanning

 

SendEmailNotificationForPlanning

boolean

itgen_ibz_sendemailnotificationforplanning

 

SendingEmailNotificationForUnregisteredTime

boolean

itgen_ibz_sendingemailnotificationforunregisteredtime

 

Sex

string

itgen_ibz_sex

 

ShortName

string

itgen_ibz_shortname

 

Sofi

string

itgen_ibz_sofi

 

StartDate

datetimeoffset

itgen_ibz_startdate

 

SysEndTime

datetimeoffset

itgen_ibz_sysendtime

 

SysStartTime

datetimeoffset

itgen_ibz_sysstarttime

 

SystemAdministrator

boolean

itgen_ibz_systemadministrator

 

Telephone

string

itgen_ibz_telephone

 

UseIpRecognition

boolean

itgen_ibz_useiprecognition

 

 

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