invantive documentation
Invantive Support ForumsLog In / Sign Up

MaterialPerUnitPerDivisionByMaterialPerUnitId: Bouw7 Material per Unit per Division by Material per Unit ID

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: Material per Unit per Division by Material per Unit ID

Returns a single material per unit based on the given ID. Returns a single material per unit based on the given ID.

Can only retrieve data.

Summary

Returns a single material per unit based on the given ID.

API Source

  • Endpoint: /material-per-unit/{id}
  • Operation: get /material-per-unit/{id}

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
id ``

Table Columns

The columns of the table MaterialPerUnitPerDivisionByMaterialPerUnitId 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(255) Article Number filters on the platform, writable, ::ancestor.articleNumber The article number of this material per unit.
conversionFactor varchar2(255) Conversion Factor filters on the platform, writable, ::ancestor.conversionFactor The conversion factor of this material per unit.
createdAt datetime Created at filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
deliveryTimeInDays int64 Delivery Time in Days filters on the platform, writable, ::ancestor.deliveryTimeInDays The delivery time in days of this material per unit.
divisionId int64 Division ID writable, divisionId The division ID that belongs to this material per division.
eanCode varchar2(13) EAN Code filters on the platform, writable, ::ancestor.eanCode The ean code of this material per unit.
formFactor_bottomRadius varchar2 Form Factor Bottom Radius filters on the platform, writable, ::ancestor.formFactor.bottomRadius The bottom radius of the form factor.
formFactor_createdAt datetime Form Factor Created at filters on the platform, writable, ::ancestor.formFactor.createdAt The creation time of the entity.
formFactor_createdBy varchar2 Form Factor Created by filters on the platform, writable, ::ancestor.formFactor.createdBy The user that created the entity.
formFactor_depth varchar2 Form Factor Depth filters on the platform, writable, ::ancestor.formFactor.depth The depth of the form factor.
formFactor_height varchar2 Form Factor Height filters on the platform, writable, ::ancestor.formFactor.height The height of the form factor.
formFactor_id int64 Form Factor ID filters on the platform, writable, ::ancestor.formFactor.id ID of the form factor.
formFactor_innerRadius varchar2 Form Factor Inner Radius filters on the platform, writable, ::ancestor.formFactor.innerRadius The inner radius of the form factor.
formFactor_outerRadius varchar2 Form Factor Outer Radius filters on the platform, writable, ::ancestor.formFactor.outerRadius The outer radius of the form factor.
formFactor_radius varchar2 Form Factor Radius filters on the platform, writable, ::ancestor.formFactor.radius The radius of the form factor.
formFactor_topRadius varchar2 Form Factor Top Radius filters on the platform, writable, ::ancestor.formFactor.topRadius The top radius of the form factor.
formFactor_type int64 Form Factor Type filters on the platform, writable, ::ancestor.formFactor.type The form factor type/shape of this form factor.
formFactor_unit int64 Form Factor Unit filters on the platform, writable, ::ancestor.formFactor.unit The unit of the form factor.
formFactor_updatedAt datetime Form Factor Updated at filters on the platform, writable, ::ancestor.formFactor.updatedAt The last updated time of the entity.
formFactor_updatedBy varchar2 Form Factor Updated by filters on the platform, writable, ::ancestor.formFactor.updatedBy The user that last updated the entity.
formFactor_weight varchar2 Form Factor Weight filters on the platform, writable, ::ancestor.formFactor.weight The weight of the form factor.
formFactor_width varchar2 Form Factor Width filters on the platform, writable, ::ancestor.formFactor.width The width of the form factor.
glAccountCode varchar2 General Ledger Account Code writable, glAccountCode The general ledger account code that belongs to this material per division.
glAccountCode_2 varchar2(255) itgen_bouw7_glaccountcode_2 filters on the platform, writable, ::ancestor.glAccountCode The general ledger account code of this material per unit.
id int64 ID writable, id The ID of this material per division.
id_2 int64 ID filters on the platform, writable, ::ancestor.id ID of this material per unit.
isActive char Is Active filters on the platform, writable, ::ancestor.isActive Whether or not this material per unit is active.
isLinkedToBookings char itgen_bouw7_islinkedtobookings filters on the platform, writable, ::ancestor.isLinkedToBookings Whether this material per unit is linked to bookings.
materialGroup_createdAt datetime Material Group Created at filters on the platform, writable, ::ancestor.materialGroup.createdAt The creation time of the entity.
materialGroup_createdBy varchar2 Material Group Created by filters on the platform, writable, ::ancestor.materialGroup.createdBy The user that created the entity.
materialGroup_id int64 Material Group ID filters on the platform, writable, ::ancestor.materialGroup.id ID of the material group.
materialGroup_name varchar2(255) Material Group Name filters on the platform, writable, ::ancestor.materialGroup.name Name of the material group.
materialGroup_updatedAt datetime Material Group Updated at filters on the platform, writable, ::ancestor.materialGroup.updatedAt The last updated time of the entity.
materialGroup_updatedBy varchar2 Material Group Updated by filters on the platform, writable, ::ancestor.materialGroup.updatedBy The user that last updated the entity.
materialUnit_id int64 Material Unit ID filters on the platform, writable, ::ancestor.materialUnit.id ID of the material unit.
materialUnit_name varchar2 Material Unit Name filters on the platform, writable, ::ancestor.materialUnit.name The name of the material unit.
material_id int64 Material ID filters on the platform, writable, ::ancestor.material.id ID of the material.
material_information varchar2 Material Information filters on the platform, writable, ::ancestor.material.information Extra information describing this material.
material_name varchar2 Material Name filters on the platform, writable, ::ancestor.material.name Name of the material.
price varchar2 Price filters on the platform, writable, ::ancestor.price The price of this material per unit.
sellingPrice varchar2 Selling Price filters on the platform, writable, ::ancestor.sellingPrice The selling price of this material per unit.
supplier_contactType_id int64 Supplier Contact Type ID filters on the platform, writable, ::ancestor.supplier.contactType.id The ID of contact type.
supplier_contactType_name varchar2 Supplier Contact Type Name filters on the platform, writable, ::ancestor.supplier.contactType.name The name of contact type.
supplier_email varchar2 Supplier Email filters on the platform, writable, ::ancestor.supplier.email The email address.
supplier_id int64 Supplier ID filters on the platform, writable, ::ancestor.supplier.id ID of contact.
supplier_isVatShifted char itgen_bouw7_supplier_isvatshifted filters on the platform, writable, ::ancestor.supplier.isVatShifted Whether VAT is shifted for the contact.
supplier_name varchar2 Supplier Name filters on the platform, writable, ::ancestor.supplier.name Name of contact.
supplier_phoneNumber varchar2 itgen_bouw7_supplier_phonenumber filters on the platform, writable, ::ancestor.supplier.phoneNumber The phone number of the contact.
updatedAt datetime Updated At filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.
vatTariff_effectiveFrom varchar2 VAT Tariff Effective From filters on the platform, writable, ::ancestor.vatTariff.effectiveFrom The date since this VAT tariff is effective.
vatTariff_id int64 VAT Tariff ID filters on the platform, writable, ::ancestor.vatTariff.id ID of the vat tariff.
vatTariff_isDefault char VAT Tariff Is Default filters on the platform, writable, ::ancestor.vatTariff.isDefault Whether this VAT is default for the country its associated with.
vatTariff_isShifted char VAT Tariff is Shifted filters on the platform, writable, ::ancestor.vatTariff.isShifted Whether the VAT is shifted.
vatTariff_label varchar2(255) VAT Tariff Label filters on the platform, writable, ::ancestor.vatTariff.label Display label of the VAT tariff.
vatTariff_legalText varchar2(2096) itgen_bouw7_vattariff_legaltext filters on the platform, writable, ::ancestor.vatTariff.legalText The legal text for the VAT tariff. Only for customers from the belgian hosting.
vatTariff_percentage varchar2 VAT Tariff Percentage filters on the platform, writable, ::ancestor.vatTariff.percentage The VAT percentage.
vatTariff_shiftedPercentage varchar2 VAT Tariff Shifted Percentage filters on the platform, writable, ::ancestor.vatTariff.shiftedPercentage The shifted VAT percentage.
visibilityFlag int64 Visibility Flag filters on the platform, writable, ::ancestor.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: