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 |
|---|---|---|---|---|---|
article |
varchar2 |
Article Number | filters on the platform, writable, ::ancestor. |
The article number of this material per unit. | |
conversion |
varchar2 |
Conversion Factor | filters on the platform, writable, ::ancestor. |
The conversion factor of this material per unit. | |
cost |
varchar2 |
itgen_bouw7_costcentermaterial | writable, cost |
A cost center to use for material related items. | |
cost |
varchar2 |
itgen_bouw7_costcentermaterialdebit | writable, cost |
A cost center to use for material debit related items. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
int64 |
Delivery Time in Days | filters on the platform, writable, ::ancestor. |
The delivery time in days of this material per unit. | |
division |
int64 |
Division ID | writable, division |
The ID of the linked division. | |
ean |
varchar2 |
EAN Code | filters on the platform, writable, ::ancestor. |
The ean code of this material per unit. | |
form |
varchar2 |
Form Factor Bottom Radius | filters on the platform, writable, ::ancestor. |
The bottom radius of the form factor. | |
form |
datetime |
Form Factor Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
form |
varchar2 |
Form Factor Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
form |
varchar2 |
Form Factor Depth | filters on the platform, writable, ::ancestor. |
The depth of the form factor. | |
form |
varchar2 |
Form Factor Height | filters on the platform, writable, ::ancestor. |
The height of the form factor. | |
form |
int64 |
Form Factor ID | filters on the platform, writable, ::ancestor. |
ID of the form factor. | |
form |
varchar2 |
Form Factor Inner Radius | filters on the platform, writable, ::ancestor. |
The inner radius of the form factor. | |
form |
varchar2 |
Form Factor Outer Radius | filters on the platform, writable, ::ancestor. |
The outer radius of the form factor. | |
form |
varchar2 |
Form Factor Radius | filters on the platform, writable, ::ancestor. |
The radius of the form factor. | |
form |
varchar2 |
Form Factor Top Radius | filters on the platform, writable, ::ancestor. |
The top radius of the form factor. | |
form |
int64 |
Form Factor Type | filters on the platform, writable, ::ancestor. |
The form factor type/shape of this form factor. | |
form |
int64 |
Form Factor Unit | filters on the platform, writable, ::ancestor. |
The unit of the form factor. | |
form |
datetime |
Form Factor Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
form |
varchar2 |
Form Factor Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
form |
varchar2 |
Form Factor Weight | filters on the platform, writable, ::ancestor. |
The weight of the form factor. | |
form |
varchar2 |
Form Factor Width | filters on the platform, writable, ::ancestor. |
The width of the form factor. | |
gl |
varchar2 |
General Ledger Account Code | filters on the platform, writable, ::ancestor. |
The general ledger account code of this material per unit. | |
gl |
varchar2 |
itgen_bouw7_glaccountcodematerial | writable, gl |
A general ledger account code to use for material related items. | |
gl |
varchar2 |
itgen_bouw7_glaccountcodematerialclosing | writable, gl |
A general ledger account code to use for material closing related items. | |
gl |
varchar2 |
itgen_bouw7_glaccountcodematerialdebit | writable, gl |
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 of the material group. | |
id_3 |
int64 |
itgen_bouw7_id_3 | filters on the platform, writable, ::ancestor. |
ID of this material per unit. | |
is |
char |
Is Active | filters on the platform, writable, ::ancestor. |
Whether or not this material per unit is active. | |
is |
char |
itgen_bouw7_islinkedtobookings | filters on the platform, writable, ::ancestor. |
Whether this material per unit is linked to bookings. | |
material |
int64 |
Material Unit ID | filters on the platform, writable, ::ancestor. |
ID of the material unit. | |
material |
varchar2 |
Material Unit Name | filters on the platform, writable, ::ancestor. |
The name of the material unit. | |
material_ |
int64 |
Material ID | filters on the platform, writable, ::ancestor. |
ID of the material. | |
material_ |
varchar2 |
Material Information | filters on the platform, writable, ::ancestor. |
Extra information describing this material. | |
material_ |
varchar2 |
Material Name | filters on the platform, writable, ::ancestor. |
Name of the material. | |
name |
varchar2 |
Name | writable, ::ancestor. |
Name of the material group. | |
price |
varchar2 |
Price | filters on the platform, writable, ::ancestor. |
The price of this material per unit. | |
selling |
varchar2 |
Selling Price | filters on the platform, writable, ::ancestor. |
The selling price of this material per unit. | |
supplier_ |
int64 |
Supplier Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
supplier_ |
varchar2 |
Supplier Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
supplier_ |
varchar2 |
Supplier Email | filters on the platform, writable, ::ancestor. |
The email address. | |
supplier_ |
int64 |
Supplier ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
supplier_ |
char |
itgen_bouw7_supplier_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
supplier_ |
varchar2 |
itgen_bouw7_supplier_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
updated |
datetime |
Updated At | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
vat |
varchar2 |
VAT Tariff Effective From | filters on the platform, writable, ::ancestor. |
The date since this VAT tariff is effective. | |
vat |
int64 |
VAT Tariff ID | filters on the platform, writable, ::ancestor. |
ID of the vat tariff. | |
vat |
char |
VAT Tariff Is Default | filters on the platform, writable, ::ancestor. |
Whether this VAT is default for the country its associated with. | |
vat |
char |
VAT Tariff is Shifted | filters on the platform, writable, ::ancestor. |
Whether the VAT is shifted. | |
vat |
varchar2 |
VAT Tariff Label | filters on the platform, writable, ::ancestor. |
Display label of the VAT tariff. | |
vat |
varchar2 |
itgen_bouw7_vattariff_legaltext | filters on the platform, writable, ::ancestor. |
The legal text for the VAT tariff. Only for customers from the belgian hosting. | |
vat |
varchar2 |
VAT Tariff Percentage | filters on the platform, writable, ::ancestor. |
The VAT percentage. | |
vat |
varchar2 |
VAT Tariff Shifted Percentage | filters on the platform, writable, ::ancestor. |
The shifted VAT percentage. | |
visibility |
int64 |
Visibility Flag | filters on the platform, writable, ::ancestor. |
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: