invantive documentation
Invantive Support ForumsLog In / Sign Up

MaterialBookings: Bouw7 Material Bookings

popular read only REST

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

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

Can only retrieve data.

Summary

Returns a list of material bookings made by the organization.

API Source

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

Performance Characteristics

Characteristic Value
Average access latency (ms) 107
Full scan rows per minute 1,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 MaterialBookings 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.
id int64 ID filters on the platform, writable, id The ID of this material 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.
material_articleNumber varchar2 Material Article Number filters on the platform, writable, material.articleNumber The article number of this bookable unit.
material_costPrice varchar2 Material Cost Price filters on the platform, writable, material.costPrice The cost price of this bookable unit.
material_eanCode varchar2 Material EAN Code filters on the platform, writable, material.eanCode The ean code of this bookable unit.
material_groupId int64 Material Group ID filters on the platform, writable, material.groupId The id of the group this bookable unit belongs to.
material_groupName varchar2 Material Group Name filters on the platform, writable, material.groupName The name of the group this bookable unit belongs to.
material_id int64 Material ID filters on the platform, writable, material.id The ID of the material-per-unit.
material_isActive char Material Is Active filters on the platform, writable, material.isActive Whether this bookable unit is active.
material_materialId int64 Material Material ID filters on the platform, writable, material.materialId The ID of the material.
material_name varchar2 Material Name filters on the platform, writable, material.name The name of the material.
material_sellingPrice varchar2 Material Selling Price filters on the platform, writable, material.sellingPrice The selling price of this bookable unit.
material_unit varchar2 Material Unit filters on the platform, writable, material.unit The name of the unit which quantifies the material.
material_unitId int64 Material Unit ID filters on the platform, writable, material.unitId The id of the unit which quantifies the material.
material_visibilityFlag int64 Material Visibility Flag filters on the platform, writable, material.visibilityFlag The visibility flag of this bookable unit (1=stock, 2=price book, 3=always visible).
projectSecurityLink_code varchar2 Project Security Link Code filters on the platform, writable, projectSecurityLink.code The security code.
projectSecurityLink_costType int64 itgen_bouw7_projectsecuritylink_costtype filters on the platform, writable, projectSecurityLink.costType The name of the cost type.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, projectSecurityLink.id The ID of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, projectSecurityLink.name The name of the project security link.
projectSecurityLink_parentName varchar2 itgen_bouw7_projectsecuritylink_parentname filters on the platform, writable, projectSecurityLink.parentName The name of the security code.
projectSecurityLink_projectId int64 Project Security Link Project ID filters on the platform, writable, projectSecurityLink.projectId The ID of the project associated with this security code.
projectSecurityLink_status int64 Project Security Link Status filters on the platform, writable, projectSecurityLink.status The status of the project security link.
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: