WasteBookingById: Bouw7 Waste Booking by ID
read only REST
- Catalog:
Bouw7 - Schema:
Resource - Label: Waste Booking by ID
Returns a waste booking associated with the given ID. Returns a waste booking associated with the given ID.
Can only retrieve data.
Summary
Returns a waste booking associated with the given ID.
API Source
- Endpoint:
/waste-booking/{wasteBooking} - Operation:
get /waste-booking/{wasteBooking}
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 |
|---|---|---|---|---|
waste |
`` |
Table Columns
The columns of the table WasteBookingById 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 waste booking object. | |
comment |
varchar2 |
Comment | filters on the platform, writable, comment |
The comments for the waste booking. | |
cost |
varchar2 |
Costprice | filters on the platform, writable, cost |
The cost price of the waste booking. Can only be set on update. | |
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. | |
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 waste 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 waste booking. | |
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 waste booking. Can only be set on update. | |
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. | |
waste |
int64 |
Waste per Unit ID | filters on the platform, writable, waste |
ID of the waste booking. | |
waste |
int64 |
Waste per Unit Waste Unit ID | filters on the platform, writable, waste |
ID of the waste unit. | |
waste |
varchar2 |
Waste per Unit Waste Unit Name | filters on the platform, writable, waste |
The name of the waste unit. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: