invantive documentation
Invantive Support ForumsLog In / Sign Up

WasteBooking_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_wastebooking_projectcategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: itgen_bouw7_wastebooking_projectcategorydivisionsettings_plural

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 WasteBooking_ProjectCategoryDivisionSettings 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.::ancestor.::ancestor.amount The amount of units of the waste booking object.
branch_code varchar2 Branch Code writable, ::ancestor.::ancestor.branch.code The code for this branch
branch_id int64 Branch ID writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_name varchar2 Branch Name writable, ::ancestor.::ancestor.branch.name The name of this branch
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
code varchar2 Code writable, ::ancestor.code The code for the category.
comment varchar2 Comment filters on the platform, writable, ::ancestor.::ancestor.::ancestor.comment The comments for the waste booking.
contact_email varchar2 Contact Email writable, ::ancestor.::ancestor.contact.email The email address.
contact_id int64 Contact ID writable, ::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted writable, ::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name writable, ::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number writable, ::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
costPrice varchar2 Costprice filters on the platform, writable, ::ancestor.::ancestor.::ancestor.costPrice The cost price of the waste booking. Can only be set on update.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_3 datetime itgen_bouw7_createdat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_3 varchar2 itgen_bouw7_createdby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
endDate datetime End Date writable, ::ancestor.::ancestor.endDate End date for the project.
exactUpdatedAt varchar2 itgen_bouw7_exactupdatedat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactUpdatedAt The last time the entity was updated in Exact Online in ATOM format.
fullProjectNumber varchar2 Full Project Number writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
generalCostsOrProfit varchar2 General Costs or Profit writable, ::ancestor.generalCostsOrProfit The general costs or profit for the category.
generalCostsPercentage varchar2 General Costs Percentage writable, ::ancestor.generalCostsPercentage The general costs percentage for the category.
grossProfitMargin varchar2 Gross Profit Margin writable, ::ancestor.grossProfitMargin The gross profit margin for the category.
houseNumber varchar2 House Number writable, ::ancestor.::ancestor.houseNumber The house number for the project.
id int64 ID writable, ::ancestor.id The ID of the category.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of the waste booking.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isMutable Whether the waste booking is mutable.
logDate datetime Log Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.logDate The log date of the waste booking.
name varchar2 Name writable, ::ancestor.name The name of the category.
name_2 varchar2 itgen_bouw7_name_2 writable, ::ancestor.::ancestor.name The name of the project.
projectNumber varchar2 Project Number writable, ::ancestor.::ancestor.projectNumber The project number.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
sellingPrice varchar2 Selling Price filters on the platform, writable, ::ancestor.::ancestor.::ancestor.sellingPrice The selling price of the waste booking. Can only be set on update.
startDate datetime Start Date writable, ::ancestor.::ancestor.startDate Start date for the project.
status_closesProject char Status Closes Project writable, ::ancestor.::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Status Created at writable, ::ancestor.::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Status Created by writable, ::ancestor.::ancestor.status.createdBy The user that created the entity.
status_id int64 Status ID writable, ::ancestor.::ancestor.status.id The ID of the status.
status_invoicesProject char Status Invoices Project writable, ::ancestor.::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Status Name writable, ::ancestor.::ancestor.status.name The name of the status.
status_plansProject char Status Plans Project writable, ::ancestor.::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Status Updated at writable, ::ancestor.::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Status Updated by writable, ::ancestor.::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Street Name writable, ::ancestor.::ancestor.streetName The street name for the project.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_3 datetime itgen_bouw7_updatedat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_3 varchar2 itgen_bouw7_updatedby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
wastePerUnit_id int64 Waste per Unit ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.wastePerUnit.id ID of the waste booking.
wastePerUnit_wasteUnit_id int64 Waste per Unit Waste Unit ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.wastePerUnit.wasteUnit.id ID of the waste unit.
wastePerUnit_wasteUnit_name varchar2 Waste per Unit Waste Unit Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.wastePerUnit.wasteUnit.name The name of the waste unit.
zipCode varchar2 ZIP Code writable, ::ancestor.::ancestor.zipCode The zip code for the project.

Release Notes

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