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 |
|---|---|---|---|---|---|
article |
varchar2 |
Article Number | filters on the platform, writable, article |
The article number (usually EAN) of this bookable unit. | |
conversion |
varchar2 |
Conversion Factor | filters on the platform, writable, conversion |
The conversion factor of this material per unit. | |
cost |
varchar2 |
Costprice | filters on the platform, writable, cost |
Cost price of this bookable unit. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
delivery |
int64 |
Delivery Time in Days | filters on the platform, writable, delivery |
The delivery time in days of this material per unit. | |
ean |
varchar2 |
EAN Code | filters on the platform, writable, ean |
Ean code of this bookable unit. | |
form |
varchar2 |
This field is dynamically hydrated by the 'hydrateFormFactorSizes'-method in the schema factory. | filters on the platform, writable, form |
The sizes of the form factor associated with this material per unit. | |
form |
int64 |
Form Factor Type | filters on the platform, writable, form |
The type of the form factor associated with this material per unit. | |
form |
int64 |
Form Factor Unit | filters on the platform, writable, form |
The unit of the form factor associated with this material per unit. | |
form |
varchar2 |
Form Factor Weight | filters on the platform, writable, form |
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. | |
is |
char |
Is Active | filters on the platform, writable, is |
Whether this bookable unit is currently active. | |
material |
int64 |
Material Group ID | filters on the platform, writable, material |
The ID of this material group. | |
material |
varchar2 |
Material Group Name | filters on the platform, writable, material |
The name of this material group. | |
material_ |
int64 |
Material ID | filters on the platform, writable, material. |
The ID of the material. | |
material_ |
varchar2 |
Material Name | filters on the platform, writable, material. |
The name of the material. | |
selling |
varchar2 |
Selling Price | filters on the platform, writable, selling |
Selling price of this bookable unit. | |
supplier_ |
varchar2 |
Supplier Email Address | filters on the platform, writable, supplier. |
The email address of the contact. | |
supplier_ |
int64 |
Supplier ID | filters on the platform, writable, supplier. |
The ID of the contact. | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, supplier. |
The name of this contact. | |
supplier_ |
varchar2 |
Supplier Type | filters on the platform, writable, supplier. |
The type of this contact. | |
supplier_ |
int64 |
Supplier Type ID | filters on the platform, writable, supplier. |
The type ID of this contact. | |
unit_ |
int64 |
Unit ID | filters on the platform, writable, unit. |
The ID of the unit. | |
unit_ |
varchar2 |
Unit Name | filters on the platform, writable, unit. |
The name of the unit. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. | |
vat |
int64 |
VAT Tariff ID | filters on the platform, writable, vat |
The ID of the vat tariff. | |
vat |
char |
VAT Tariff is Shifted | filters on the platform, writable, vat |
Whether the VAT is shifted. | |
vat |
varchar2 |
VAT Tariff Label | filters on the platform, writable, vat |
Display label of the VAT tariff. | |
vat |
varchar2 |
VAT Tariff Percentage | filters on the platform, writable, vat |
The VAT percentage. | |
visibility |
int64 |
Visibility Flag | filters on the platform, writable, visibility |
The visibility flag of this material per unit. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: