ResourceBookingEmployeesById: Bouw7 Resource Booking Employees by ID
read only REST
- Catalog:
Bouw7 - Schema:
Resource - Label: Resource Booking Employees by ID
Returns a resource booking associated with the given id. Returns a resource booking associated with the given id.
Can only retrieve data.
Summary
Returns a resource booking associated with the given id.
API Source
- Endpoint:
/resource-booking/{type}/{id} - Operation:
get /resource-booking/{type}/{id}
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 |
|---|---|---|---|---|
id |
`` | Resource booking ID | ||
type |
`` | The type of resource |
Table Columns
The columns of the table ResourceBookingEmployeesById 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 | filters on the platform, writable, ::ancestor. |
The amount of the resource booking. | |
comment |
varchar2 |
Comment | filters on the platform, writable, ::ancestor. |
The comment of this booking. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
group_ |
int64 |
Group ID | filters on the platform, writable, ::ancestor. |
The unique identifier of the resource group. | |
group_ |
varchar2 |
Group Name | filters on the platform, writable, ::ancestor. |
The name of the resource group. | |
id |
int64 |
ID | writable, id |
The unique identifier of the employee. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The unique identifier of the resource booking. | |
log |
datetime |
Log Date | filters on the platform, writable, ::ancestor. |
The cost price of this booking. | |
name |
varchar2 |
Name | writable, name |
The name of the employee. | |
price |
varchar2 |
Price | filters on the platform, writable, ::ancestor. |
The price of this booking, if this is not provided, the price of the unit will be used for the booking. | |
price |
varchar2 |
Price Total | filters on the platform, writable, ::ancestor. |
The total price of this booking. | |
project |
varchar2 |
Project Security Link Chapter Name | filters on the platform, writable, ::ancestor. |
The name of the project security chapter. | |
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. | |
project |
int64 |
Project Security Link Status | filters on the platform, writable, ::ancestor. |
The status of the project security link. | |
project_ |
int64 |
Project ID | filters on the platform, writable, ::ancestor. |
The unique identifier of the project the resource belongs to. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, ::ancestor. |
The name of the project the resource belongs to. | |
resource_ |
int64 |
Resource ID | filters on the platform, writable, ::ancestor. |
The unique identifier of the resource. | |
resource_ |
varchar2 |
Resource Name | filters on the platform, writable, ::ancestor. |
The name of the resource. | |
selling |
varchar2 |
Selling Price | filters on the platform, writable, ::ancestor. |
The selling price of this booking. | |
selling |
varchar2 |
Selling Price Total | filters on the platform, writable, ::ancestor. |
The total selling price of this booking. | |
type |
varchar2 |
Type | filters on the platform, writable, ::ancestor. |
Resource type, possible values: equipment. | |
unit_ |
int64 |
Unit ID | filters on the platform, writable, ::ancestor. |
The unique identifier of the resource unit. | |
updated |
datetime |
Updated At | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: