invantive documentation
Invantive Support ForumsLog In / Sign Up

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
wasteBooking ``

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.
costPrice varchar2 Costprice filters on the platform, writable, costPrice The cost price of the waste booking. Can only be set on update.
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy The user that created the entity.
exactUpdatedAt varchar2 itgen_bouw7_exactupdatedat filters on the platform, writable, exactUpdatedAt 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.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, isMutable Whether the waste booking is mutable.
logDate datetime Log Date filters on the platform, writable, logDate The log date of the waste booking.
project_branch_code varchar2 itgen_bouw7_project_branch_code filters on the platform, writable, project.branch.code The code for this branch
project_branch_id int64 itgen_bouw7_project_branch_id filters on the platform, writable, project.branch.id The ID of the branch.
project_branch_name varchar2 itgen_bouw7_project_branch_name filters on the platform, writable, project.branch.name The name of this branch
project_category_code varchar2 itgen_bouw7_project_category_code filters on the platform, writable, project.category.code The code for the category.
project_category_createdAt datetime itgen_bouw7_project_category_createdat filters on the platform, writable, project.category.createdAt The creation time of the entity.
project_category_createdBy varchar2 itgen_bouw7_project_category_createdby filters on the platform, writable, project.category.createdBy The user that created the entity.
project_category_generalCostsOrProfit varchar2 itgen_bouw7_project_category_generalcostsorprofit filters on the platform, writable, project.category.generalCostsOrProfit The general costs or profit for the category.
project_category_generalCostsPercentage varchar2 itgen_bouw7_project_category_generalcostspercentage filters on the platform, writable, project.category.generalCostsPercentage The general costs percentage for the category.
project_category_grossProfitMargin varchar2 itgen_bouw7_project_category_grossprofitmargin filters on the platform, writable, project.category.grossProfitMargin The gross profit margin for the category.
project_category_id int64 itgen_bouw7_project_category_id filters on the platform, writable, project.category.id The ID of the category.
project_category_name varchar2 itgen_bouw7_project_category_name filters on the platform, writable, project.category.name The name of the category.
project_category_updatedAt datetime itgen_bouw7_project_category_updatedat filters on the platform, writable, project.category.updatedAt The last updated time of the entity.
project_category_updatedBy varchar2 itgen_bouw7_project_category_updatedby filters on the platform, writable, project.category.updatedBy The user that last updated the entity.
project_city varchar2 Project City filters on the platform, writable, project.city The city of the project.
project_contact_email varchar2 Project Contact Email filters on the platform, writable, project.contact.email The email address.
project_contact_id int64 Project Contact ID filters on the platform, writable, project.contact.id ID of contact.
project_contact_isVatShifted char itgen_bouw7_project_contact_isvatshifted filters on the platform, writable, project.contact.isVatShifted Whether VAT is shifted for the contact.
project_contact_name varchar2 Project Contact Name filters on the platform, writable, project.contact.name Name of contact.
project_contact_phoneNumber varchar2 itgen_bouw7_project_contact_phonenumber filters on the platform, writable, project.contact.phoneNumber The phone number of the contact.
project_createdAt datetime Project Created at filters on the platform, writable, project.createdAt The creation time of the entity.
project_createdBy varchar2 Project Created by filters on the platform, writable, project.createdBy The user that created the entity.
project_deliveryDate datetime Project Delivery Date filters on the platform, writable, project.deliveryDate Delivery date for the project.
project_endDate datetime Project End Date filters on the platform, writable, project.endDate End date for the project.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable, project.fullProjectNumber The full project number including year.
project_houseNumber varchar2 Project House Number filters on the platform, writable, project.houseNumber The house number for the project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_information varchar2 Project Information filters on the platform, writable, project.information The information of the project.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project.
project_projectNumber varchar2 Project Project Number filters on the platform, writable, project.projectNumber The project number.
project_reference varchar2 Project Reference filters on the platform, writable, project.reference The reference of the project.
project_startDate datetime Project Start Date filters on the platform, writable, project.startDate Start date for the project.
project_status_closesProject char Project Status Closes Project filters on the platform, writable, project.status.closesProject Whether or not this status closes a project.
project_status_createdAt datetime Project Status Created at filters on the platform, writable, project.status.createdAt The creation time of the entity.
project_status_createdBy varchar2 Project Status Created by filters on the platform, writable, project.status.createdBy The user that created the entity.
project_status_id int64 Project Status ID filters on the platform, writable, project.status.id The ID of the status.
project_status_invoicesProject char Project Status Invoices Project filters on the platform, writable, project.status.invoicesProject Whether or not this status invoices a project.
project_status_name varchar2 Project Status Name filters on the platform, writable, project.status.name The name of the status.
project_status_plansProject char Project Status Plans Project filters on the platform, writable, project.status.plansProject Whether or not this status plans a project.
project_status_updatedAt datetime Project Status Updated at filters on the platform, writable, project.status.updatedAt The last updated time of the entity.
project_status_updatedBy varchar2 Project Status Updated by filters on the platform, writable, project.status.updatedBy The user that last updated the entity.
project_streetName varchar2 Project Street Name filters on the platform, writable, project.streetName The street name for the project.
project_updatedAt datetime Project Updated at filters on the platform, writable, project.updatedAt The last updated time of the entity.
project_updatedBy varchar2 Project Updated by filters on the platform, writable, project.updatedBy The user that last updated the entity.
project_zipCode varchar2 Project ZIP Code filters on the platform, writable, project.zipCode The zip code for the project.
sellingPrice varchar2 Selling Price filters on the platform, writable, sellingPrice The selling price of the waste booking. Can only be set on update.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy The user that last updated the entity.
wastePerUnit_id int64 Waste per Unit ID filters on the platform, writable, wastePerUnit.id ID of the waste booking.
wastePerUnit_wasteUnit_id int64 Waste per Unit Waste Unit ID filters on the platform, writable, wastePerUnit.wasteUnit.id ID of the waste unit.
wastePerUnit_wasteUnit_name varchar2 Waste per Unit Waste Unit Name filters on the platform, writable, wastePerUnit.wasteUnit.name The name of the waste unit.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: