invantive documentation
Invantive Support ForumsLog In / Sign Up

GarbageBookings: Bouw7 Garbage Bookings

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: Garbage Bookings

Returns a list of waste bookings made by the organization. Returns a list of waste bookings made by the organization.

Can only retrieve data.

Summary

Returns a list of waste bookings made by the organization.

API Source

  • Endpoint: /list/booking/garbage
  • Operation: get /list/booking/garbage

Performance Characteristics

Characteristic Value
Average access latency (ms) 94
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
q `` A Heimdall Query Language string

Table Columns

The columns of the table GarbageBookings 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
bookingStatus int64 Booking Status filters on the platform, writable, bookingStatus The status of this booking. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited.
comment varchar2 Comment filters on the platform, writable, comment The comment associated with this booked item.
costPrice varchar2 Costprice filters on the platform, writable, costPrice The cost price of the booked item.
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username The username of the user.
date datetime Date filters on the platform, writable, date The log date of the booked item.
exactUpdatedAt varchar2 itgen_bouw7_exactupdatedat filters on the platform, writable, exactUpdatedAt The last time the entity was updated in Exact Online in ATOM format.
garbage_articleNumber varchar2 Garbage Article Number filters on the platform, writable, garbage.articleNumber The article number (usually EAN) of this bookable unit.
garbage_costPrice varchar2 Garbage Cost Price filters on the platform, writable, garbage.costPrice The cost price of this bookable unit.
garbage_id int64 Garbage ID filters on the platform, writable, garbage.id The ID of the waste-per-unit.
garbage_isActive char Garbage Is Active filters on the platform, writable, garbage.isActive The active state of this bookable unit.
garbage_name varchar2 Garbage Name filters on the platform, writable, garbage.name The name of the waste.
garbage_sellingPrice varchar2 Garbage Selling Price filters on the platform, writable, garbage.sellingPrice The selling price of this bookable unit.
garbage_unit varchar2 Garbage Unit filters on the platform, writable, garbage.unit The name of the unit which quantifies the waste.
garbage_unitId int64 Garbage Unit ID filters on the platform, writable, garbage.unitId The id of the unit which quantifies the waste.
garbage_wasteId int64 Garbage Waste ID filters on the platform, writable, garbage.wasteId The ID of the waste.
id int64 ID filters on the platform, writable, id The ID of this waste booking.
invoiceLine_id int64 Invoice Line ID filters on the platform, writable, invoiceLine.id The ID of the invoice line.
invoiceLine_invoiceId int64 Invoice Line Invoice ID filters on the platform, writable, invoiceLine.invoiceId The ID of the invoice this invoice line belongs to.
invoiceLine_invoiceStatusId int64 Invoice Line Invoice Status ID filters on the platform, writable, invoiceLine.invoiceStatusId The ID of the status of the invoice this line belongs to.
invoicedAmount varchar2 Invoiced Amount filters on the platform, writable, invoicedAmount The invoiced amount of the booked item.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, isMutable Whether the booked item is mutable.
project_branchId int64 Project Branch ID filters on the platform, writable, project.branchId The ID of the branch of this project.
project_categoryId int64 Project Category ID filters on the platform, writable, project.categoryId The ID of the category of this project.
project_divisionId int64 Project Division ID filters on the platform, writable, project.divisionId The ID of the division of this project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project.
project_number varchar2 Project Number filters on the platform, writable, project.number The number of the project.
project_status varchar2 Project Status filters on the platform, writable, project.status The name of the current status of this project.
project_statusId int64 Project Status ID filters on the platform, writable, project.statusId The ID of the status of this project.
quantity varchar2 Quantity filters on the platform, writable, quantity The quantity of the booked item.
sellingPrice varchar2 Selling Price filters on the platform, writable, sellingPrice The selling price of the booked item.
totalCostPrice varchar2 Total Cost Price filters on the platform, writable, totalCostPrice The total cost price of the booked item.
totalSellingPrice varchar2 Total Selling Price filters on the platform, writable, totalSellingPrice The total selling price of the booked item.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.

Release Notes

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