EquipmentBookingById: Bouw7 Equipment Booking by ID
read only REST
- Catalog:
Bouw7 - Schema:
Resource - Label: Equipment Booking by ID
Returns an equipment booking associated with the given id. Returns an equipment booking associated with the given id.
Can only retrieve data.
Summary
Returns an equipment booking associated with the given id.
API Source
- Endpoint:
/equipment-booking/{id} - Operation:
get /equipment-booking/{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 |
`` | Equipment booking ID |
Table Columns
The columns of the table EquipmentBookingById 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, amount |
The amount of units of the equipment booking object. | |
comment |
varchar2 |
Comment | filters on the platform, writable, comment |
The comments for the equipment booking. | |
cost |
varchar2 |
Costprice | filters on the platform, writable, cost |
The cost price of the equipment booking. Can only be set on update. Initially set with the equipment per unit price. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
equipment |
datetime |
Equipment Group Created at | filters on the platform, writable, equipment |
The creation time of the entity. | |
equipment |
varchar2 |
Equipment Group Created by | filters on the platform, writable, equipment |
The user that created the entity. | |
equipment |
int64 |
Equipment Group ID | filters on the platform, writable, equipment |
The unique identifier of the equipment group. | |
equipment |
varchar2 |
Equipment Group Name | filters on the platform, writable, equipment |
The name of the equipment group. | |
equipment |
datetime |
Equipment Group Updated at | filters on the platform, writable, equipment |
The last updated time of the entity. | |
equipment |
varchar2 |
Equipment Group Updated by | filters on the platform, writable, equipment |
The user that last updated the entity. | |
equipment |
int64 |
Equipment per Unit Equipment Unit ID | filters on the platform, writable, equipment |
ID of this equipment unit. | |
equipment |
varchar2 |
Equipment per Unit Equipment Unit Name | filters on the platform, writable, equipment |
The name of the equipment unit. | |
equipment |
int64 |
Equipment per Unit ID | filters on the platform, writable, equipment |
ID of this equipment per unit. | |
equipment_ |
int64 |
Equipment ID | filters on the platform, writable, equipment. |
ID of the equipment. | |
equipment_ |
varchar2 |
Equipment Name | filters on the platform, writable, equipment. |
Name of the equipment. | |
exact |
varchar2 |
itgen_bouw7_exactupdatedat | filters on the platform, writable, exact |
The last time the entity was updated in Exact Online in ATOM format. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the equipment booking. | |
is |
char |
itgen_bouw7_ismutable | filters on the platform, writable, is |
Whether the waste booking is mutable. | |
log |
datetime |
Log Date | filters on the platform, writable, log |
The log date of the equipment booking. | |
project |
varchar2 |
Project Security Link Code | filters on the platform, writable, project |
The code of the security code. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, project |
The unique identifier 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_project_branch_code | filters on the platform, writable, project. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, project. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, project. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, project. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, project. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, project. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, project. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, project. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, project. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project City | filters on the platform, writable, project. |
The city of the project. | |
project_ |
varchar2 |
Project Contact Email | filters on the platform, writable, project. |
The email address. | |
project_ |
int64 |
Project Contact ID | filters on the platform, writable, project. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, project. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable, project. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, project. |
The phone number of the contact. | |
project_ |
datetime |
Project Created at | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Created by | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
datetime |
Project Delivery Date | filters on the platform, writable, project. |
Delivery date for the project. | |
project_ |
datetime |
Project End Date | filters on the platform, writable, project. |
End date for the project. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable, project. |
The full project number including year. | |
project_ |
varchar2 |
Project House Number | filters on the platform, writable, project. |
The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Information | filters on the platform, writable, project. |
The information of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Project Number | filters on the platform, writable, project. |
The project number. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable, project. |
The reference of the project. | |
project_ |
datetime |
Project Start Date | filters on the platform, writable, project. |
Start date for the project. | |
project_ |
char |
Project Status Closes Project | filters on the platform, writable, project. |
Whether or not this status closes a project. | |
project_ |
datetime |
Project Status Created at | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Status Created by | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status. | |
project_ |
char |
Project Status Invoices Project | filters on the platform, writable, project. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Project Status Name | filters on the platform, writable, project. |
The name of the status. | |
project_ |
char |
Project Status Plans Project | filters on the platform, writable, project. |
Whether or not this status plans a project. | |
project_ |
datetime |
Project Status Updated at | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Status Updated by | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Street Name | filters on the platform, writable, project. |
The street name for the project. | |
project_ |
datetime |
Project Updated at | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Updated by | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project ZIP Code | filters on the platform, writable, project. |
The zip code for the project. | |
selling |
varchar2 |
Selling Price | filters on the platform, writable, selling |
The selling price of the equipment booking. Can only be set on update. Initially set with the equipment per unit selling price. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: