---
title: "HourLogs_ItemsProjectCategoryDivisionSettings (Bouw7)"
description: "itgen_bouw7_hourlogs_itemsprojectcategorydivisionsettings_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.HourLog.HourLogs_ItemsProjectCategoryDivisionSettings
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.HourLog.HourLogs_ItemsProjectCategoryDivisionSettings
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/en/
---

# 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` | `` | [x] |  | Project ID |
| `q` | `` | [ ] |  | Filter collections with the [Heimdall Query Language](https://heimdall.bouw7.nl/docs/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:

- [Bouw7](/en/release-notes/drivers?driver=bouw7)

