invantive documentation
Invantive Support ForumsLog In / Sign Up

MaterialsPerUnit: Bouw7 Materials per Unit

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: Materials per Unit

Returns a bookable list of units associated with materials. Returns a bookable list of units associated with materials.

Can only retrieve data.

Summary

Returns a bookable list of units associated with materials.

API Source

  • Endpoint: /list/materials-per-unit
  • Operation: get /list/materials-per-unit

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 8,940
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 MaterialsPerUnit 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
articleNumber varchar2 Article Number filters on the platform, writable, articleNumber The article number (usually EAN) of this bookable unit.
conversionFactor varchar2 Conversion Factor filters on the platform, writable, conversionFactor The conversion factor of this material per unit.
costPrice varchar2 Costprice filters on the platform, writable, costPrice Cost price of this bookable unit.
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.
deliveryTimeInDays int64 Delivery Time in Days filters on the platform, writable, deliveryTimeInDays The delivery time in days of this material per unit.
eanCode varchar2 EAN Code filters on the platform, writable, eanCode Ean code of this bookable unit.
formFactorSizes varchar2 This field is dynamically hydrated by the 'hydrateFormFactorSizes'-method in the schema factory. filters on the platform, writable, formFactorSizes The sizes of the form factor associated with this material per unit.
formFactorType int64 Form Factor Type filters on the platform, writable, formFactorType The type of the form factor associated with this material per unit.
formFactorUnit int64 Form Factor Unit filters on the platform, writable, formFactorUnit The unit of the form factor associated with this material per unit.
formFactorWeight varchar2 Form Factor Weight filters on the platform, writable, formFactorWeight The weight of the form factor associated with this material per unit.
id int64 ID filters on the platform, writable, id The ID of this bookable unit.
isActive char Is Active filters on the platform, writable, isActive Whether this bookable unit is currently active.
materialGroup_id int64 Material Group ID filters on the platform, writable, materialGroup.id The ID of this material group.
materialGroup_name varchar2 Material Group Name filters on the platform, writable, materialGroup.name The name of this material group.
material_id int64 Material ID filters on the platform, writable, material.id The ID of the material.
material_name varchar2 Material Name filters on the platform, writable, material.name The name of the material.
sellingPrice varchar2 Selling Price filters on the platform, writable, sellingPrice Selling price of this bookable unit.
supplier_emailAddress varchar2 Supplier Email Address filters on the platform, writable, supplier.emailAddress The email address of the contact.
supplier_id int64 Supplier ID filters on the platform, writable, supplier.id The ID of the contact.
supplier_name varchar2 Supplier Name filters on the platform, writable, supplier.name The name of this contact.
supplier_type varchar2 Supplier Type filters on the platform, writable, supplier.type The type of this contact.
supplier_typeId int64 Supplier Type ID filters on the platform, writable, supplier.typeId The type ID of this contact.
unit_id int64 Unit ID filters on the platform, writable, unit.id The ID of the unit.
unit_name varchar2 Unit Name filters on the platform, writable, unit.name The name of the unit.
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.
vatTariff_id int64 VAT Tariff ID filters on the platform, writable, vatTariff.id The ID of the vat tariff.
vatTariff_isShifted char VAT Tariff is Shifted filters on the platform, writable, vatTariff.isShifted Whether the VAT is shifted.
vatTariff_label varchar2(255) VAT Tariff Label filters on the platform, writable, vatTariff.label Display label of the VAT tariff.
vatTariff_percentage varchar2 VAT Tariff Percentage filters on the platform, writable, vatTariff.percentage The VAT percentage.
visibilityFlag int64 Visibility Flag filters on the platform, writable, visibilityFlag The visibility flag of this material per unit.

Release Notes

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