ContactHourLogs: Bouw7 Contact Hour Logs
read only REST
- Catalog:
Bouw7 - Schema:
HourLog - Label: Contact Hour Logs
Returns a list of contact hour logs associated with your organization. Returns a list of contact hour logs associated with your organization.
Can only retrieve data.
Summary
Returns a list of contact hour logs associated with your organization.
API Source
- Endpoint:
/list/hour-logs/contact - Operation:
get /list/hour-logs/contact
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 391 |
| 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 |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string |
Table Columns
The columns of the table ContactHourLogs 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 |
datetime |
Approved at | filters on the platform, writable, approved |
The time this hour log entry was approved at. | |
approved |
int64 |
Approved by ID | filters on the platform, writable, approved |
The ID of the user. | |
approved |
varchar2 |
Approved by User Name | filters on the platform, writable, approved |
The username. The e-mail address the user uses to sign in. | |
booking |
int64 |
Booking Status | filters on the platform, writable, booking |
The booking status of this entry. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. | |
comment |
varchar2 |
Comment | filters on the platform, writable, comment |
The remark added to this entry. | |
contact_ |
varchar2 |
Contact Email Address | filters on the platform, writable, contact. |
The email address of the contact. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, contact. |
The ID of the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, contact. |
The name of this contact. | |
contact_ |
varchar2 |
Contact Type | filters on the platform, writable, contact. |
The type of this contact. | |
contact_ |
int64 |
Contact Type ID | filters on the platform, writable, contact. |
The type ID of this contact. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
hourly |
varchar2 |
Hourly Rate | filters on the platform, writable, hourly |
The hourly rate. | |
hours |
varchar2 |
Hours | filters on the platform, writable, hours |
The amount of hours logged to this entry. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the hour log. | |
invoice |
int64 |
Invoice Line ID | filters on the platform, writable, invoice |
The ID of the invoice line. | |
invoice |
int64 |
Invoice Line Invoice ID | filters on the platform, writable, invoice |
The ID of the invoice this invoice line belongs to. | |
invoice |
int64 |
Invoice Line Invoice Status ID | filters on the platform, writable, invoice |
The ID of the status of the invoice this line belongs to. | |
invoiced |
varchar2 |
Invoiced Amount | filters on the platform, writable, invoiced |
The amount to invoice for this hour log entry. | |
is |
char |
Is Approved | filters on the platform, writable, is |
Whether this hour log entry has been approved for processing. | |
log |
datetime |
Log Date | filters on the platform, writable, log |
The log date of this entry. ATOM format. | |
project |
varchar2 |
Project Security Link Code | filters on the platform, writable, project |
The security code. | |
project |
int64 |
itgen_bouw7_projectsecuritylink_costtype | filters on the platform, writable, project |
The name of the cost type. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, project |
The ID of the project security link. | |
project |
varchar2 |
Project Security Link Name | filters on the platform, writable, project |
The name of the project security link. | |
project |
varchar2 |
itgen_bouw7_projectsecuritylink_parentname | filters on the platform, writable, project |
The name of the security code. | |
project |
int64 |
Project Security Link Project ID | filters on the platform, writable, project |
The ID of the project associated with this security code. | |
project |
int64 |
Project Security Link Status | filters on the platform, writable, project |
The status of the project security link. | |
project_ |
int64 |
Project Branch ID | filters on the platform, writable, project. |
The ID of the branch of this project. | |
project_ |
int64 |
Project Category ID | filters on the platform, writable, project. |
The ID of the category of this project. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable, project. |
The name of the contact associated with this project. | |
project_ |
varchar2 |
Project Executor Name | filters on the platform, writable, project. |
The full name of the executor associated with this project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Number | filters on the platform, writable, project. |
The number of the project. | |
project_ |
varchar2 |
Project Project Leader Name | filters on the platform, writable, project. |
The full name of the project leader associated with this project. | |
project_ |
varchar2 |
Project Status | filters on the platform, writable, project. |
The name of the current status of this project. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status of this project. | |
project_ |
varchar2 |
Project Work Planner Name | filters on the platform, writable, project. |
The full name of the work planner associated with this project. | |
type_ |
int64 |
Type ID | filters on the platform, writable, type. |
The ID of the hour type. | |
type_ |
varchar2 |
Type Name | filters on the platform, writable, type. |
The name of the hour type. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: