invantive documentation
Invantive Support ForumsLog In / Sign Up

HourLogs_ItemsProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_hourlogs_itemsprojectcategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: HourLog
  • Label: itgen_bouw7_hourlogs_itemsprojectcategorydivisionsettings_plural

Returns a list of hour logs associated with the given project. Returns a list of hour logs associated with the given project.

Can only retrieve data.

Summary

Returns a list of hour logs associated with the given project.

API Source

  • Endpoint: /project/{project}/hour-logs
  • Operation: get /project/{project}/hour-logs

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
project `` Project ID
q `` Filter collections with the Heimdall Query Language

Table Columns

The columns of the table HourLogs_ItemsProjectCategoryDivisionSettings are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
approved char Approved filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approved Whether this hour log has been approved.
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
comments varchar2 Comments filters on the platform, writable, ::ancestor.::ancestor.::ancestor.comments The comments for this hour log.
contact_email varchar2 Contact Email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.email The email address.
contact_id int64 Contact ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
createdAt datetime Created at writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
employee_firstName varchar2 Employee First Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.employee.firstName First name of the employee.
employee_id int64 Employee ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.employee.id ID of the employee.
employee_lastName varchar2 Employee Last Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.employee.lastName Last name of the employee.
endDate datetime End Date writable, ::ancestor.::ancestor.endDate End date for the project.
endTime varchar2 End Time filters on the platform, writable, ::ancestor.::ancestor.::ancestor.endTime The end time of the workday. Only available if enabled for your organization.
exactUpdatedAt varchar2 itgen_bouw7_exactupdatedat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactUpdatedAt The last time the entity was updated in Exact Online in ATOM format.
fullProjectNumber varchar2 Full Project Number writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
hourType_id int64 Hour Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.hourType.id The ID of HourType.
hourType_name varchar2 Hour Type Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.hourType.name The name of the HourType.
hourlyRate varchar2 Hourly Rate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.hourlyRate The hourly rate.
houseNumber varchar2 House Number writable, ::ancestor.::ancestor.houseNumber The house number for the project.
id int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_2 int64 ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of the hour log.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
invoiceAmount varchar2 Invoice Amount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAmount The amount that will be shown on the invoice.
isEditable char itgen_bouw7_iseditable filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isEditable Whether this hour log is editable and deletable.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isMutable Whether the hour log booking is mutable. Applicable only if this hour log belongs to a employee, otherwise null.
logDate datetime Log Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.logDate The date for which the hours were logged.
logHours varchar2 Log Hours filters on the platform, writable, ::ancestor.::ancestor.::ancestor.logHours The amount of hours logged.
name varchar2 Name writable, ::ancestor.::ancestor.name The name of the project.
paidOff char Paid Off filters on the platform, writable, ::ancestor.::ancestor.::ancestor.paidOff Whether this hour log has been paid off.
projectNumber varchar2 Project Number writable, ::ancestor.::ancestor.projectNumber The project number.
projectSecurityLink_code varchar2 Project Security Link Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectSecurityLink.code The code of the security code.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectSecurityLink.id The unique identifier of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectSecurityLink.name The name of the project security link.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
startDate datetime Start Date writable, ::ancestor.::ancestor.startDate Start date for the project.
startTime varchar2 Start Time filters on the platform, writable, ::ancestor.::ancestor.::ancestor.startTime The start time of the workday. Only available if enabled for your organization.
streetName varchar2 Street Name writable, ::ancestor.::ancestor.streetName The street name for the project.
updatedAt datetime Updated At writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
zipCode varchar2 ZIP Code writable, ::ancestor.::ancestor.zipCode The zip code for the project.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: