invantive documentation
Invantive SupportforenAnmelden / Eintragen

MaterialPerUnit_MaterialGroupDivisionSettings: Bouw7 itgen_bouw7_materialperunit_materialgroupdivisionsettings_plural

Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: itgen_bouw7_materialperunit_materialgroupdivisionsettings_plural

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 MaterialPerUnit_MaterialGroupDivisionSettings 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.::ancestor.articleNumber The article number of this material per unit.
conversionFactor varchar2(255) Conversion Factor filters on the platform, writable, ::ancestor.::ancestor.conversionFactor The conversion factor of this material per unit.
costCenterMaterial varchar2(36) itgen_bouw7_costcentermaterial writable, costCenterMaterial A cost center to use for material related items.
costCenterMaterialDebit varchar2(36) itgen_bouw7_costcentermaterialdebit writable, costCenterMaterialDebit A cost center to use for material debit related items.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at filters on the platform, writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by filters on the platform, writable, ::ancestor.::ancestor.createdBy The user that created the entity.
deliveryTimeInDays int64 Delivery Time in Days filters on the platform, writable, ::ancestor.::ancestor.deliveryTimeInDays The delivery time in days of this material per unit.
divisionId int64 Division ID writable, divisionId The ID of the linked division.
eanCode varchar2(13) EAN Code filters on the platform, writable, ::ancestor.::ancestor.eanCode The ean code of this material per unit.
formFactor_bottomRadius varchar2 Form Factor Bottom Radius filters on the platform, writable, ::ancestor.::ancestor.formFactor.bottomRadius The bottom radius of the form factor.
formFactor_createdAt datetime Form Factor Created at filters on the platform, writable, ::ancestor.::ancestor.formFactor.createdAt The creation time of the entity.
formFactor_createdBy varchar2 Form Factor Created by filters on the platform, writable, ::ancestor.::ancestor.formFactor.createdBy The user that created the entity.
formFactor_depth varchar2 Form Factor Depth filters on the platform, writable, ::ancestor.::ancestor.formFactor.depth The depth of the form factor.
formFactor_height varchar2 Form Factor Height filters on the platform, writable, ::ancestor.::ancestor.formFactor.height The height of the form factor.
formFactor_id int64 Form Factor ID filters on the platform, writable, ::ancestor.::ancestor.formFactor.id ID of the form factor.
formFactor_innerRadius varchar2 Form Factor Inner Radius filters on the platform, writable, ::ancestor.::ancestor.formFactor.innerRadius The inner radius of the form factor.
formFactor_outerRadius varchar2 Form Factor Outer Radius filters on the platform, writable, ::ancestor.::ancestor.formFactor.outerRadius The outer radius of the form factor.
formFactor_radius varchar2 Form Factor Radius filters on the platform, writable, ::ancestor.::ancestor.formFactor.radius The radius of the form factor.
formFactor_topRadius varchar2 Form Factor Top Radius filters on the platform, writable, ::ancestor.::ancestor.formFactor.topRadius The top radius of the form factor.
formFactor_type int64 Form Factor Type filters on the platform, writable, ::ancestor.::ancestor.formFactor.type The form factor type/shape of this form factor.
formFactor_unit int64 Form Factor Unit filters on the platform, writable, ::ancestor.::ancestor.formFactor.unit The unit of the form factor.
formFactor_updatedAt datetime Form Factor Updated at filters on the platform, writable, ::ancestor.::ancestor.formFactor.updatedAt The last updated time of the entity.
formFactor_updatedBy varchar2 Form Factor Updated by filters on the platform, writable, ::ancestor.::ancestor.formFactor.updatedBy The user that last updated the entity.
formFactor_weight varchar2 Form Factor Weight filters on the platform, writable, ::ancestor.::ancestor.formFactor.weight The weight of the form factor.
formFactor_width varchar2 Form Factor Width filters on the platform, writable, ::ancestor.::ancestor.formFactor.width The width of the form factor.
glAccountCode varchar2(255) General Ledger Account Code filters on the platform, writable, ::ancestor.::ancestor.glAccountCode The general ledger account code of this material per unit.
glAccountCodeMaterial varchar2(36) itgen_bouw7_glaccountcodematerial writable, glAccountCodeMaterial A general ledger account code to use for material related items.
glAccountCodeMaterialClosing varchar2(36) itgen_bouw7_glaccountcodematerialclosing writable, glAccountCodeMaterialClosing A general ledger account code to use for material closing related items.
glAccountCodeMaterialDebit varchar2(36) itgen_bouw7_glaccountcodematerialdebit writable, glAccountCodeMaterialDebit A general ledger account code to use for material debit related items.
id int64 ID writable, id The ID of the division project category settings.
id_2 int64 ID writable, ::ancestor.id ID of the material group.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.id ID of this material per unit.
isActive char Is Active filters on the platform, writable, ::ancestor.::ancestor.isActive Whether or not this material per unit is active.
isLinkedToBookings char itgen_bouw7_islinkedtobookings filters on the platform, writable, ::ancestor.::ancestor.isLinkedToBookings Whether this material per unit is linked to bookings.
materialUnit_id int64 Material Unit ID filters on the platform, writable, ::ancestor.::ancestor.materialUnit.id ID of the material unit.
materialUnit_name varchar2 Material Unit Name filters on the platform, writable, ::ancestor.::ancestor.materialUnit.name The name of the material unit.
material_id int64 Material ID filters on the platform, writable, ::ancestor.::ancestor.material.id ID of the material.
material_information varchar2 Material Information filters on the platform, writable, ::ancestor.::ancestor.material.information Extra information describing this material.
material_name varchar2 Material Name filters on the platform, writable, ::ancestor.::ancestor.material.name Name of the material.
name varchar2(255) Name writable, ::ancestor.name Name of the material group.
price varchar2 Price filters on the platform, writable, ::ancestor.::ancestor.price The price of this material per unit.
sellingPrice varchar2 Selling Price filters on the platform, writable, ::ancestor.::ancestor.sellingPrice The selling price of this material per unit.
supplier_contactType_id int64 Supplier Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.supplier.contactType.id The ID of contact type.
supplier_contactType_name varchar2 Supplier Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.supplier.contactType.name The name of contact type.
supplier_email varchar2 Supplier Email filters on the platform, writable, ::ancestor.::ancestor.supplier.email The email address.
supplier_id int64 Supplier ID filters on the platform, writable, ::ancestor.::ancestor.supplier.id ID of contact.
supplier_isVatShifted char itgen_bouw7_supplier_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.supplier.isVatShifted Whether VAT is shifted for the contact.
supplier_name varchar2 Supplier Name filters on the platform, writable, ::ancestor.::ancestor.supplier.name Name of contact.
supplier_phoneNumber varchar2 itgen_bouw7_supplier_phonenumber filters on the platform, writable, ::ancestor.::ancestor.supplier.phoneNumber The phone number of the contact.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at filters on the platform, writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by filters on the platform, writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
vatTariff_effectiveFrom varchar2 VAT Tariff Effective From filters on the platform, writable, ::ancestor.::ancestor.vatTariff.effectiveFrom The date since this VAT tariff is effective.
vatTariff_id int64 VAT Tariff ID filters on the platform, writable, ::ancestor.::ancestor.vatTariff.id ID of the vat tariff.
vatTariff_isDefault char VAT Tariff Is Default filters on the platform, writable, ::ancestor.::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.::ancestor.vatTariff.isShifted Whether the VAT is shifted.
vatTariff_label varchar2(255) VAT Tariff Label filters on the platform, writable, ::ancestor.::ancestor.vatTariff.label Display label of the VAT tariff.
vatTariff_legalText varchar2(2096) itgen_bouw7_vattariff_legaltext filters on the platform, writable, ::ancestor.::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.::ancestor.vatTariff.percentage The VAT percentage.
vatTariff_shiftedPercentage varchar2 VAT Tariff Shifted Percentage filters on the platform, writable, ::ancestor.::ancestor.vatTariff.shiftedPercentage The shifted VAT percentage.
visibilityFlag int64 Visibility Flag filters on the platform, writable, ::ancestor.::ancestor.visibilityFlag The visibility flag of this material per unit.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: