invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

MaterialPerUnitById: Bouw7 Material per Unit by ID

read only REST

  • Catalogus: Bouw7
  • Schema: Resource
  • Label: Material per Unit by ID

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

Kan alleen gegevens ophalen.

Samenvatting

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

API-bron

  • Eindpunt: /material-per-unit/{id}
  • Operatie: get /material-per-unit/{id}

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 90
Aantal rijen per minuut bij volledige scan 241,000
Aantal rijen per minuut in een Query 666

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
id ``

Tabelkolommen

De kolommen van de tabel MaterialPerUnitById worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
articleNumber varchar2(255) Artikel Nummer filters on the platform, writable, articleNumber The article number of this material per unit.
conversionFactor varchar2(255) Conversiefactor filters on the platform, writable, conversionFactor The conversion factor of this material per unit.
createdAt datetime Aangemaakt op filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Gemaakt door filters on the platform, writable, createdBy The user that created the entity.
deliveryTimeInDays int64 Levertijd in Dagen filters on the platform, writable, deliveryTimeInDays The delivery time in days of this material per unit.
eanCode varchar2(13) EAN-code filters on the platform, writable, eanCode The ean code of this material per unit.
formFactor_bottomRadius varchar2 Vormfactor Onderste Radius filters on the platform, writable, formFactor.bottomRadius The bottom radius of the form factor.
formFactor_createdAt datetime Vormfactor Gemaakt op filters on the platform, writable, formFactor.createdAt The creation time of the entity.
formFactor_createdBy varchar2 Vormfactor Gemaakt door filters on the platform, writable, formFactor.createdBy The user that created the entity.
formFactor_depth varchar2 Vormfactor Diepte filters on the platform, writable, formFactor.depth The depth of the form factor.
formFactor_height varchar2 Vormfactor Hoogte filters on the platform, writable, formFactor.height The height of the form factor.
formFactor_id int64 Vormfactor-ID filters on the platform, writable, formFactor.id ID of the form factor.
formFactor_innerRadius varchar2 Vormfactor Binnenradius filters on the platform, writable, formFactor.innerRadius The inner radius of the form factor.
formFactor_outerRadius varchar2 Vormfactor Buitenradius filters on the platform, writable, formFactor.outerRadius The outer radius of the form factor.
formFactor_radius varchar2 Vormfactor Radius filters on the platform, writable, formFactor.radius The radius of the form factor.
formFactor_topRadius varchar2 Vormfactor Bovenste Radius filters on the platform, writable, formFactor.topRadius The top radius of the form factor.
formFactor_type int64 Vormfactorsoort filters on the platform, writable, formFactor.type The form factor type/shape of this form factor.
formFactor_unit int64 Vormfactoreenheid filters on the platform, writable, formFactor.unit The unit of the form factor.
formFactor_updatedAt datetime Vormfactor Bijgewerkt op filters on the platform, writable, formFactor.updatedAt The last updated time of the entity.
formFactor_updatedBy varchar2 Vormfactor Bijgewerkt door filters on the platform, writable, formFactor.updatedBy The user that last updated the entity.
formFactor_weight varchar2 Vormfactor Gewicht filters on the platform, writable, formFactor.weight The weight of the form factor.
formFactor_width varchar2 Vormfactor Breedte filters on the platform, writable, formFactor.width The width of the form factor.
glAccountCode varchar2(255) Grootboekrekeningcode filters on the platform, writable, glAccountCode The general ledger account code of this material per unit.
id int64 ID filters on the platform, writable, id ID of this material per unit.
isActive char Is Actief filters on the platform, writable, isActive Whether or not this material per unit is active.
isLinkedToBookings char itgen_bouw7_islinkedtobookings filters on the platform, writable, isLinkedToBookings Whether this material per unit is linked to bookings.
materialGroup_createdAt datetime Materiaalgroep Gemaakt op filters on the platform, writable, materialGroup.createdAt The creation time of the entity.
materialGroup_createdBy varchar2 Materiaalgroep Gemaakt door filters on the platform, writable, materialGroup.createdBy The user that created the entity.
materialGroup_id int64 Materiaalgroep-ID filters on the platform, writable, materialGroup.id ID of the material group.
materialGroup_name varchar2(255) Materiaalgroepnaam filters on the platform, writable, materialGroup.name Name of the material group.
materialGroup_updatedAt datetime Materiaalgroep Bijgewerkt op filters on the platform, writable, materialGroup.updatedAt The last updated time of the entity.
materialGroup_updatedBy varchar2 Materiaalgroep Bijgewerkt door filters on the platform, writable, materialGroup.updatedBy The user that last updated the entity.
materialUnit_id int64 Materiaaleenheid-ID filters on the platform, writable, materialUnit.id ID of the material unit.
materialUnit_name varchar2 Materiaal Naam Eenheid filters on the platform, writable, materialUnit.name The name of the material unit.
material_id int64 Materiaal-ID filters on the platform, writable, material.id ID of the material.
material_information varchar2 Materiaalinformatie filters on the platform, writable, material.information Extra information describing this material.
material_name varchar2 Materiaalnaam filters on the platform, writable, material.name Name of the material.
price varchar2 Price filters on the platform, writable, price The price of this material per unit.
sellingPrice varchar2 Verkoopprijs filters on the platform, writable, sellingPrice The selling price of this material per unit.
supplier_contactType_id int64 Leverancier Contactsoort-ID filters on the platform, writable, supplier.contactType.id The ID of contact type.
supplier_contactType_name varchar2 Leverancier Contactsoortnaam filters on the platform, writable, supplier.contactType.name The name of contact type.
supplier_email varchar2 Leverancier E-mail filters on the platform, writable, supplier.email The email address.
supplier_id int64 Leverancier-ID filters on the platform, writable, supplier.id ID of contact.
supplier_isVatShifted char itgen_bouw7_supplier_isvatshifted filters on the platform, writable, supplier.isVatShifted Whether VAT is shifted for the contact.
supplier_name varchar2 Leveranciersnaam filters on the platform, writable, supplier.name Name of contact.
supplier_phoneNumber varchar2 itgen_bouw7_supplier_phonenumber filters on the platform, writable, supplier.phoneNumber The phone number of the contact.
updatedAt datetime Bijgewerkt op filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Bijgewerkt door filters on the platform, writable, updatedBy The user that last updated the entity.
vatTariff_effectiveFrom varchar2 BTW-tarief Geldig vanaf filters on the platform, writable, vatTariff.effectiveFrom The date since this VAT tariff is effective.
vatTariff_id int64 BTW-Tarief ID filters on the platform, writable, vatTariff.id ID of the vat tariff.
vatTariff_isDefault char BTW-tarief is Standaard filters on the platform, writable, vatTariff.isDefault Whether this VAT is default for the country its associated with.
vatTariff_isShifted char BTW-Tarief Is Verlegd filters on the platform, writable, vatTariff.isShifted Whether the VAT is shifted.
vatTariff_label varchar2(255) BTW-Tarief Label filters on the platform, writable, vatTariff.label Display label of the VAT tariff.
vatTariff_legalText varchar2(2096) itgen_bouw7_vattariff_legaltext filters on the platform, writable, vatTariff.legalText The legal text for the VAT tariff.Only for customers from the belgian hosting.
vatTariff_percentage varchar2 BTW-Tarief Percentage filters on the platform, writable, vatTariff.percentage The VAT percentage.
vatTariff_shiftedPercentage varchar2 BTW-tarief Verlegd Percentage filters on the platform, writable, vatTariff.shiftedPercentage The shifted VAT percentage.
visibilityFlag int64 Zichtbaarheidsvlag filters on the platform, writable, visibilityFlag The visibility flag of this material per unit.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: