invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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

read only REST

  • Catalogue : Bouw7
  • Schéma : 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.

Permet uniquement de récupérer des données.

Résumé

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

Source de l'API

  • Point de terminaison : /material-per-unit/{id}
  • Opération : get /material-per-unit/{id}

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 90
Nombre de lignes par minute en mode de balayage complet 241,000
Nombre de lignes de requêtes ponctuelles par minute 666

Le résultat peut être mis en cache côté client.

Paramètres

Name Type de données Required Default Documentation
id ``

Colonnes de table

Les colonnes de la table MaterialPerUnitPerDivisionByMaterialPerUnitId sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
articleNumber varchar2(255) Référence de l'article filters on the platform, writable, ::ancestor.articleNumber The article number of this material per unit.
conversionFactor varchar2(255) Facteur de conversion filters on the platform, writable, ::ancestor.conversionFactor The conversion factor of this material per unit.
createdAt datetime Créé le filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Crée par filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
deliveryTimeInDays int64 Délai de livraison en jours filters on the platform, writable, ::ancestor.deliveryTimeInDays The delivery time in days of this material per unit.
divisionId int64 ID de l'entreprise writable, divisionId The division ID that belongs to this material per division.
eanCode varchar2(13) Code EAN filters on the platform, writable, ::ancestor.eanCode The ean code of this material per unit.
formFactor_bottomRadius varchar2 Format - Rayon inférieur filters on the platform, writable, ::ancestor.formFactor.bottomRadius The bottom radius of the form factor.
formFactor_createdAt datetime Format créé le filters on the platform, writable, ::ancestor.formFactor.createdAt The creation time of the entity.
formFactor_createdBy varchar2 Format créé par filters on the platform, writable, ::ancestor.formFactor.createdBy The user that created the entity.
formFactor_depth varchar2 Profondeur du format filters on the platform, writable, ::ancestor.formFactor.depth The depth of the form factor.
formFactor_height varchar2 Hauteur du format filters on the platform, writable, ::ancestor.formFactor.height The height of the form factor.
formFactor_id int64 Identifiant du format filters on the platform, writable, ::ancestor.formFactor.id ID of the form factor.
formFactor_innerRadius varchar2 Forme - Rayon intérieur filters on the platform, writable, ::ancestor.formFactor.innerRadius The inner radius of the form factor.
formFactor_outerRadius varchar2 Forme - Rayon extérieur filters on the platform, writable, ::ancestor.formFactor.outerRadius The outer radius of the form factor.
formFactor_radius varchar2 Rayon du facteur de forme filters on the platform, writable, ::ancestor.formFactor.radius The radius of the form factor.
formFactor_topRadius varchar2 Facteur de forme – Rayon supérieur filters on the platform, writable, ::ancestor.formFactor.topRadius The top radius of the form factor.
formFactor_type int64 Type de format filters on the platform, writable, ::ancestor.formFactor.type The form factor type/shape of this form factor.
formFactor_unit int64 Unité de format filters on the platform, writable, ::ancestor.formFactor.unit The unit of the form factor.
formFactor_updatedAt datetime Format Mise à jour le filters on the platform, writable, ::ancestor.formFactor.updatedAt The last updated time of the entity.
formFactor_updatedBy varchar2 Format mis à jour par filters on the platform, writable, ::ancestor.formFactor.updatedBy The user that last updated the entity.
formFactor_weight varchar2 Format Poids filters on the platform, writable, ::ancestor.formFactor.weight The weight of the form factor.
formFactor_width varchar2 Largeur du format filters on the platform, writable, ::ancestor.formFactor.width The width of the form factor.
glAccountCode varchar2 Code du grand compte livre général 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 Est actif 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 Groupe de matériaux créé le filters on the platform, writable, ::ancestor.materialGroup.createdAt The creation time of the entity.
materialGroup_createdBy varchar2 Groupe de matériaux créé par filters on the platform, writable, ::ancestor.materialGroup.createdBy The user that created the entity.
materialGroup_id int64 Identifiant du groupe de matériaux filters on the platform, writable, ::ancestor.materialGroup.id ID of the material group.
materialGroup_name varchar2(255) Nom du groupe de matériaux filters on the platform, writable, ::ancestor.materialGroup.name Name of the material group.
materialGroup_updatedAt datetime Groupe de matériaux Mis à jour le filters on the platform, writable, ::ancestor.materialGroup.updatedAt The last updated time of the entity.
materialGroup_updatedBy varchar2 Groupe de matériaux Mis à jour par filters on the platform, writable, ::ancestor.materialGroup.updatedBy The user that last updated the entity.
materialUnit_id int64 Référence de l'unité de matériau filters on the platform, writable, ::ancestor.materialUnit.id ID of the material unit.
materialUnit_name varchar2 Nom de l'unité de mesure filters on the platform, writable, ::ancestor.materialUnit.name The name of the material unit.
material_id int64 Référence du matériau filters on the platform, writable, ::ancestor.material.id ID of the material.
material_information varchar2 Informations sur les matériaux filters on the platform, writable, ::ancestor.material.information Extra information describing this material.
material_name varchar2 Nom du matériau 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 Prix de vente filters on the platform, writable, ::ancestor.sellingPrice The selling price of this material per unit.
supplier_contactType_id int64 Identifiant du type de contact du fournisseur filters on the platform, writable, ::ancestor.supplier.contactType.id The ID of contact type.
supplier_contactType_name varchar2 Fournisseur Type de contact Nom filters on the platform, writable, ::ancestor.supplier.contactType.name The name of contact type.
supplier_email varchar2 E-mail du fournisseur filters on the platform, writable, ::ancestor.supplier.email The email address.
supplier_id int64 Référence fournisseur 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 Nom du fournisseur 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 Mise à jour à filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Mise à jour par filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.
vatTariff_effectiveFrom varchar2 Barème de la TVA en vigueur à compter du filters on the platform, writable, ::ancestor.vatTariff.effectiveFrom The date since this VAT tariff is effective.
vatTariff_id int64 Numéro d'identification TVA filters on the platform, writable, ::ancestor.vatTariff.id ID of the vat tariff.
vatTariff_isDefault char Le taux de TVA est celui par défaut filters on the platform, writable, ::ancestor.vatTariff.isDefault Whether this VAT is default for the country its associated with.
vatTariff_isShifted char Modification du barème de la TVA filters on the platform, writable, ::ancestor.vatTariff.isShifted Whether the VAT is shifted.
vatTariff_label varchar2(255) Étiquette indiquant le taux de TVA 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 Taux de TVA filters on the platform, writable, ::ancestor.vatTariff.percentage The VAT percentage.
vatTariff_shiftedPercentage varchar2 Taux de TVA modifié filters on the platform, writable, ::ancestor.vatTariff.shiftedPercentage The shifted VAT percentage.
visibilityFlag int64 Indicateur de visibilité filters on the platform, writable, ::ancestor.visibilityFlag The visibility flag of this material per unit.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :