BookingLineEmployeeHoursByProject: Bouw7 Booking Line Employee Hours by Project
read only REST
- Catalog:
Bouw7 - Schema:
Booking - Label: Booking Line Employee Hours by Project
Returns all available booking items based on its criteria. Returns all available booking items based on its criteria.
Can only retrieve data.
Summary
Returns all available booking items based on its criteria.
API Source
- Endpoint:
/project/{project}/booking-lines - Operation:
get /project/{project}/booking-lines
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 |
|---|---|---|---|---|
end |
`` | End date | ||
find |
`` | Whether the booking lines should be retrieved for a checkout document. Available values: 0, 1. | ||
project |
`` | Project ID | ||
start |
`` | Start date | ||
type |
`` | Type bit mask |
Table Columns
The columns of the table BookingLineEmployeeHoursByProject 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 |
|---|---|---|---|---|---|
amount |
varchar2 |
Amount | writable, amount |
The unit amount of the Booking object. | |
comment |
varchar2 |
Comment | writable, comment |
The comments for this invoice booking. | |
cost |
varchar2 |
Costprice | writable, cost |
The cost price. | |
employee |
int64 |
Employee ID | writable, employee |
The ID of the employee. | |
employee |
varchar2 |
Employee Name | writable, employee |
The name of the employee. | |
end |
varchar2 |
End Time | writable, end |
The end time of the workday. Only available if enabled for your organization. | |
hour |
varchar2 |
Hour Type Name | writable, hour |
The hour type name. | |
id |
int64 |
ID | writable, id |
The ID of the hour log. | |
invoice |
varchar2 |
Invoice Amount | writable, invoice |
The amount that will be shown on the invoice. | |
invoice |
int64 |
Invoice Cost Status ID | writable, invoice |
The invoice cost status id. | |
invoice |
varchar2 |
Invoice Description | writable, invoice |
The invoice description of the booking item. | |
invoice |
int64 |
Invoice Line ID | writable, invoice |
The id of the invoice line the booking line is linked to. | |
is |
char |
itgen_bouw7_ismutable | writable, is |
Whether the employee hour log booking is mutable. | |
log |
datetime |
Log Date | writable, log |
The log date of this booking in ATOM format. | |
selling |
varchar2 |
Selling Price | writable, selling |
The selling price. | |
start |
varchar2 |
Start Time | writable, start |
The start time of the workday. Only available if enabled for your organization. | |
summary_ |
varchar2 |
Summary Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Contact Hours Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Delivery Tickets Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Employee Hours Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Equipment Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Equipment Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Equipment Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Equipment Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Equipment Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Garbage Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Garbage Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Garbage Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Garbage Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Garbage Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Material Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Material Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Material Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Material Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Material Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Profit | filters on the platform, writable, ::ancestor. |
The profit. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Purchase Invoice Lines Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
total |
varchar2 |
Total Cost Price | writable, total |
Total cost price. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: