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. |
Whether this hour log has been approved. | |
city |
varchar2 |
City | writable, ::ancestor. |
The city of the project. | |
comments |
varchar2 |
Comments | filters on the platform, writable, ::ancestor. |
The comments for this hour log. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
datetime |
Delivery Date | writable, ::ancestor. |
Delivery date for the project. | |
employee_ |
varchar2 |
Employee First Name | filters on the platform, writable, ::ancestor. |
First name of the employee. | |
employee_ |
int64 |
Employee ID | filters on the platform, writable, ::ancestor. |
ID of the employee. | |
employee_ |
varchar2 |
Employee Last Name | filters on the platform, writable, ::ancestor. |
Last name of the employee. | |
end |
datetime |
End Date | writable, ::ancestor. |
End date for the project. | |
end |
varchar2 |
End Time | filters on the platform, writable, ::ancestor. |
The end time of the workday. Only available if enabled for your organization. | |
exact |
varchar2 |
itgen_bouw7_exactupdatedat | filters on the platform, writable, ::ancestor. |
The last time the entity was updated in Exact Online in ATOM format. | |
full |
varchar2 |
Full Project Number | writable, ::ancestor. |
The full project number including year. | |
hour |
int64 |
Hour Type ID | filters on the platform, writable, ::ancestor. |
The ID of HourType. | |
hour |
varchar2 |
Hour Type Name | filters on the platform, writable, ::ancestor. |
The name of the HourType. | |
hourly |
varchar2 |
Hourly Rate | filters on the platform, writable, ::ancestor. |
The hourly rate. | |
house |
varchar2 |
House Number | writable, ::ancestor. |
The house number for the project. | |
id |
int64 |
ID | writable, ::ancestor. |
The ID of the project. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of the hour log. | |
information |
varchar2 |
Information | writable, ::ancestor. |
The information of the project. | |
invoice |
varchar2 |
Invoice Amount | filters on the platform, writable, ::ancestor. |
The amount that will be shown on the invoice. | |
is |
char |
itgen_bouw7_iseditable | filters on the platform, writable, ::ancestor. |
Whether this hour log is editable and deletable. | |
is |
char |
itgen_bouw7_ismutable | filters on the platform, writable, ::ancestor. |
Whether the hour log booking is mutable. Applicable only if this hour log belongs to a employee, otherwise null. | |
log |
datetime |
Log Date | filters on the platform, writable, ::ancestor. |
The date for which the hours were logged. | |
log |
varchar2 |
Log Hours | filters on the platform, writable, ::ancestor. |
The amount of hours logged. | |
name |
varchar2 |
Name | writable, ::ancestor. |
The name of the project. | |
paid |
char |
Paid Off | filters on the platform, writable, ::ancestor. |
Whether this hour log has been paid off. | |
project |
varchar2 |
Project Number | writable, ::ancestor. |
The project number. | |
project |
varchar2 |
Project Security Link Code | filters on the platform, writable, ::ancestor. |
The code of the security code. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, ::ancestor. |
The unique identifier of the project security link. | |
project |
varchar2 |
Project Security Link Name | filters on the platform, writable, ::ancestor. |
The name of the project security link. | |
reference |
varchar2 |
Reference | writable, ::ancestor. |
The reference of the project. | |
start |
datetime |
Start Date | writable, ::ancestor. |
Start date for the project. | |
start |
varchar2 |
Start Time | filters on the platform, writable, ::ancestor. |
The start time of the workday. Only available if enabled for your organization. | |
street |
varchar2 |
Street Name | writable, ::ancestor. |
The street name for the project. | |
updated |
datetime |
Updated At | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
zip |
varchar2 |
ZIP Code | writable, ::ancestor. |
The zip code for the project. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: