invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

CurrentUser_DepartmentWorkInProgressSettings: Bouw7 itgen_bouw7_currentuser_departmentworkinprogresssettings_plural

read only REST

  • Catalogus: Bouw7
  • Schema: Organization
  • Label: itgen_bouw7_currentuser_departmentworkinprogresssettings_plural

Returns the user that is currently authenticated. Returns the user that is currently authenticated.

Kan alleen gegevens ophalen.

Samenvatting

Returns the user that is currently authenticated.

API-bron

  • Eindpunt: /organization/me
  • Operatie: get /organization/me

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 70
Aantal rijen per minuut bij volledige scan 241,000
Aantal rijen per minuut in een Query 666

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel CurrentUser_DepartmentWorkInProgressSettings worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
avatarFileHash varchar2 Avatar Bestandshash filters on the platform, writable, ::ancestor.::ancestor.avatarFileHash A file hash associated with the user avatar.
branchId int64 itgen_bouw7_branchid writable, branchId The ID of the linked branch.
branch_code varchar2 Vestigingscode writable, ::ancestor.branch.code The code for this branch
branch_id int64 Vestiging-ID writable, ::ancestor.branch.id The ID of the branch.
branch_name varchar2 Filiaalnaam writable, ::ancestor.branch.name The name of this branch
color varchar2 Colour writable, ::ancestor.color Display color of the department
costCenterHours varchar2(255) itgen_bouw7_costcenterhours writable, costCenterHours A cost center to use for hours related items.
costCenterHoursDebit varchar2(255) itgen_bouw7_costcenterhoursdebit writable, costCenterHoursDebit A cost center to use for hours debit related items.
createdAt datetime Aangemaakt op writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Gemaakt door writable, ::ancestor.createdBy The user that created the entity.
employee_address varchar2 Adres Medewerker filters on the platform, writable, ::ancestor.::ancestor.employee.address The address of the employee.
employee_birthDate datetime Medewerker Geboortedatum filters on the platform, writable, ::ancestor.::ancestor.employee.birthDate The birth date of the employee.
employee_bsn varchar2 Werknemer BSN filters on the platform, writable, ::ancestor.::ancestor.employee.bsn The BSN of the employee.
employee_city varchar2 Werknemer Stad filters on the platform, writable, ::ancestor.::ancestor.employee.city The city of the employee.
employee_createdAt datetime Medewerker Gemaakt op filters on the platform, writable, ::ancestor.::ancestor.employee.createdAt The creation time of the entity.
employee_createdBy varchar2 Medewerker Aangemaakt door filters on the platform, writable, ::ancestor.::ancestor.employee.createdBy The user that created the entity.
employee_department_id int64 Medewerker Afdelings-ID filters on the platform, writable, ::ancestor.::ancestor.employee.department.id ID of the department.
employee_department_name varchar2 Medewerker Afdelingsnaam filters on the platform, writable, ::ancestor.::ancestor.employee.department.name Name of the department.
employee_employeeMail varchar2 Medewerker Mederwerkerse-mail filters on the platform, writable, ::ancestor.::ancestor.employee.employeeMail The email of the employee.
employee_firstName varchar2 Medewerker Voornaam filters on the platform, writable, ::ancestor.::ancestor.employee.firstName The first name of the employee.
employee_function varchar2 Medewerkerfunctie filters on the platform, writable, ::ancestor.::ancestor.employee.function The function of the employee.
employee_hourlyRate varchar2 Medewerker Uurtarief filters on the platform, writable, ::ancestor.::ancestor.employee.hourlyRate The hourly rate
employee_id int64 Werknemer ID filters on the platform, writable, ::ancestor.::ancestor.employee.id The ID of the employee.
employee_lastName varchar2 Medewerker Achternaam filters on the platform, writable, ::ancestor.::ancestor.employee.lastName The last name of the employee.
employee_phoneNumber varchar2 Medewerker Telefoonnummer filters on the platform, writable, ::ancestor.::ancestor.employee.phoneNumber The phone number of the employee.
employee_sellingHourlyRate varchar2 Medewerker Verkoopuurtarief filters on the platform, writable, ::ancestor.::ancestor.employee.sellingHourlyRate The selling hourly rate
employee_updatedAt datetime Medewerker Bijgewerkt op filters on the platform, writable, ::ancestor.::ancestor.employee.updatedAt The last updated time of the entity.
employee_updatedBy varchar2 Medewerker Bijgewerkt door filters on the platform, writable, ::ancestor.::ancestor.employee.updatedBy The user that last updated the entity.
employee_workload varchar2 Medewerker Werkdruk filters on the platform, writable, ::ancestor.::ancestor.employee.workload The workload of the employee
employee_zipCode varchar2 Medewerker Postcode filters on the platform, writable, ::ancestor.::ancestor.employee.zipCode ZIP code of the address.
eulaAcceptedAt varchar2 itgen_bouw7_eulaacceptedat filters on the platform, writable, ::ancestor.::ancestor.eulaAcceptedAt The date and time in ATOM/ISO-8601 format when this user accepted the latest EULA, or NULL if the user never accepted it.
eulaFirstAcceptedAt varchar2 itgen_bouw7_eulafirstacceptedat filters on the platform, writable, ::ancestor.::ancestor.eulaFirstAcceptedAt The date and time in ATOM/ISO-8601 format when this user first accepted the EULA, or NULL if the user never accepted it.
familyName varchar2 itgen_bouw7_familyname filters on the platform, writable, ::ancestor.::ancestor.familyName The family (last) name of the user.
givenName varchar2 itgen_bouw7_givenname filters on the platform, writable, ::ancestor.::ancestor.givenName The given (first) name of the user.
glAccountCodeHours varchar2(255) itgen_bouw7_glaccountcodehours writable, glAccountCodeHours A general ledger account code to use for hours related items.
glAccountCodeHoursClosing varchar2(255) itgen_bouw7_glaccountcodehoursclosing writable, glAccountCodeHoursClosing A general ledger account code to use for hours closing related items.
glAccountCodeHoursDebit varchar2(255) itgen_bouw7_glaccountcodehoursdebit writable, glAccountCodeHoursDebit A general ledger account code to use for hours debit related items.
hasBranchSpecificAccess char itgen_bouw7_hasbranchspecificaccess writable, ::ancestor.hasBranchSpecificAccess Whether users within the department can only access items associated with one of the specified branches.
id int64 ID writable, id The ID of the work in progress settings.
id_2 int64 ID writable, ::ancestor.id ID of the department.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.id The ID of the User.
isActive char Is Actief writable, ::ancestor.isActive Whether or not the department is active.
isAdmin char Is Beheerder filters on the platform, writable, ::ancestor.::ancestor.isAdmin Whether the user is an admin.
isDataWithoutBranchAccessible char itgen_bouw7_isdatawithoutbranchaccessible writable, ::ancestor.isDataWithoutBranchAccessible Whether this branch can access data without a branch, this option is only used in combination with the hasBranchSpecificAccess=true.
linkId int64 Koppeling-ID filters on the platform, writable, ::ancestor.::ancestor.linkId The ID of the relation between the user and organization.
name varchar2 Name writable, ::ancestor.name Name of the department.
organization_alternativeAddressPosition char Organisatie Alternatieve Adrespositie filters on the platform, writable, ::ancestor.::ancestor.organization.alternativeAddressPosition Whether to show the alternative address position.
organization_city varchar2 Organisatie Stad filters on the platform, writable, ::ancestor.::ancestor.organization.city The organization's city.
organization_cocNumber varchar2 Organisatie KvK-nummer filters on the platform, writable, ::ancestor.::ancestor.organization.cocNumber The organization's coc number.
organization_contactFirstName varchar2 Organisatie Contactpersoon Voornaam filters on the platform, writable, ::ancestor.::ancestor.organization.contactFirstName The contact first name.
organization_contactLastName varchar2 Organisatie Contactpersoon Achternaam filters on the platform, writable, ::ancestor.::ancestor.organization.contactLastName The contact last name.
organization_country varchar2 Organisatie Land filters on the platform, writable, ::ancestor.::ancestor.organization.country The organization's country.
organization_currency varchar2 Organisatie Valuta filters on the platform, writable, ::ancestor.::ancestor.organization.currency The currency used by this organization, e.g.: EUR.
organization_emailAddress varchar2 Organisatie E-mailadres filters on the platform, writable, ::ancestor.::ancestor.organization.emailAddress The organization's email address.
organization_expirationReminder int64 Organisatie Vervaldatumherinnering filters on the platform, writable, ::ancestor.::ancestor.organization.expirationReminder The expiration reminder days for this organization.
organization_glnNumber varchar2 Organisatie Grootboekrekeningnummer filters on the platform, writable, ::ancestor.::ancestor.organization.glnNumber The Global Location Number.
organization_hasExactHostingAssociation char itgen_bouw7_organization_hasexacthostingassociation filters on the platform, writable, ::ancestor.::ancestor.organization.hasExactHostingAssociation Whether the organization has an exact hosting association.
organization_hourlyRate varchar2 Organisatie Uurtarief filters on the platform, writable, ::ancestor.::ancestor.organization.hourlyRate The hourly rate for this organization.
organization_houseNumber varchar2 Organisatie Huisnummer filters on the platform, writable, ::ancestor.::ancestor.organization.houseNumber The organization's house number (incl. additions).
organization_iban varchar2 Organisatie IBAN filters on the platform, writable, ::ancestor.::ancestor.organization.iban The organization's IBAN.
organization_id int64 Organisatie ID filters on the platform, writable, ::ancestor.::ancestor.organization.id The organization ID.
organization_invoiceMail varchar2 Organisatie Factuurmail filters on the platform, writable, ::ancestor.::ancestor.organization.invoiceMail The invoice email address.
organization_isAutomaticInvoiceNumbering char itgen_bouw7_organization_isautomaticinvoicenumbering filters on the platform, writable, ::ancestor.::ancestor.organization.isAutomaticInvoiceNumbering Whether automatic invoice numbering is enabled for this organization.
organization_isEnableAlternativeEmail char itgen_bouw7_organization_isenablealternativeemail filters on the platform, writable, ::ancestor.::ancestor.organization.isEnableAlternativeEmail Whether an alternative email is enabled for this organization.
organization_language varchar2 Organisatie Taal filters on the platform, writable, ::ancestor.::ancestor.organization.language The locale used by this organization, e.g.: nl-NL.
organization_logo_createdAt datetime Organisatielogo Gemaakt op filters on the platform, writable, ::ancestor.::ancestor.organization.logo.createdAt The creation time of the entity.
organization_logo_createdBy varchar2 Organisatielogo Gemaakt door filters on the platform, writable, ::ancestor.::ancestor.organization.logo.createdBy The user that created the entity.
organization_logo_extension varchar2 Organisatielogo-extensie filters on the platform, writable, ::ancestor.::ancestor.organization.logo.extension The extension of the file.
organization_logo_id int64 Organisatielogo-ID filters on the platform, writable, ::ancestor.::ancestor.organization.logo.id The ID of this file
organization_logo_modelId int64 Organisatielogo Model-ID filters on the platform, writable, ::ancestor.::ancestor.organization.logo.modelId The ID of the associated type.
organization_logo_modelType varchar2 Organisatie Logo Modeltype filters on the platform, writable, ::ancestor.::ancestor.organization.logo.modelType The category of the file.
organization_logo_name varchar2 Organisatie Logonaam filters on the platform, writable, ::ancestor.::ancestor.organization.logo.name The public name of the file.
organization_logo_secureHash varchar2 itgen_bouw7_organization_logo_securehash filters on the platform, writable, ::ancestor.::ancestor.organization.logo.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
organization_logo_size int64 Organisatie Logogrootte filters on the platform, writable, ::ancestor.::ancestor.organization.logo.size The size of the file in bytes.
organization_logo_updatedAt datetime Organisatie Logo Bijgewerkt op filters on the platform, writable, ::ancestor.::ancestor.organization.logo.updatedAt The last updated time of the entity.
organization_logo_updatedBy varchar2 Organisatie Logo Bijgewerkt door filters on the platform, writable, ::ancestor.::ancestor.organization.logo.updatedBy The user that last updated the entity.
organization_logo_uri varchar2 Organisatielogo-URI filters on the platform, writable, ::ancestor.::ancestor.organization.logo.uri The URI of the file, used to fetch the contents.
organization_name varchar2 Organisatienaam filters on the platform, writable, ::ancestor.::ancestor.organization.name The organization name.
organization_note varchar2 Organisatie Notitie filters on the platform, writable, ::ancestor.::ancestor.organization.note Note field for organization.
organization_phoneNumber varchar2 Organisatie Telefoonnummer filters on the platform, writable, ::ancestor.::ancestor.organization.phoneNumber The organization's phone number.
organization_prognosisHourlyRate varchar2 Organisatie Prognose Uurtarief filters on the platform, writable, ::ancestor.::ancestor.organization.prognosisHourlyRate The prognosis hourly rate for this organization.
organization_requireHourLogTimes char Organisatie Vereist Urenregistratietijden filters on the platform, writable, ::ancestor.::ancestor.organization.requireHourLogTimes Whether hour log times are enabled and therefore required for this organization.
organization_sellingHourlyRate varchar2 Organisatie Verkooptarief per Uur filters on the platform, writable, ::ancestor.::ancestor.organization.sellingHourlyRate The selling hourly rate for this organization.
organization_shouldCopyProjectDescription char Organisatie moet Projectomschrijving Kopiëren filters on the platform, writable, ::ancestor.::ancestor.organization.shouldCopyProjectDescription True if the project description should be copied to an invoice.
organization_status int64 Organisatiestatus filters on the platform, writable, ::ancestor.::ancestor.organization.status The status of the organization.
organization_streetName varchar2 Organisatie Straatnaam filters on the platform, writable, ::ancestor.::ancestor.organization.streetName The organization's street name.
organization_vatNumber varchar2 Organisatie BTW-nummer filters on the platform, writable, ::ancestor.::ancestor.organization.vatNumber The organization's vat number.
organization_website varchar2 Organisatie Website filters on the platform, writable, ::ancestor.::ancestor.organization.website The organization's website.
organization_zipCode varchar2 Organisatie Postcode filters on the platform, writable, ::ancestor.::ancestor.organization.zipCode The organization's zip-code.
updatedAt datetime Bijgewerkt op writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Bijgewerkt door writable, ::ancestor.updatedBy The user that last updated the entity.
username varchar2 Gebruikersnaam filters on the platform, writable, ::ancestor.::ancestor.username The username of the user.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: