MaterialPerUnitPerDivisionByMaterialPerUnitId: Bouw7 Material per Unit per Division by Material per Unit ID
read only REST
- Catalogus:
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.
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 MaterialPerUnitPerDivisionByMaterialPerUnitId 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 |
|---|---|---|---|---|---|
article |
varchar2 |
Artikel Nummer | filters on the platform, writable, ::ancestor. |
The article number of this material per unit. | |
conversion |
varchar2 |
Conversiefactor | filters on the platform, writable, ::ancestor. |
The conversion factor of this material per unit. | |
created |
datetime |
Aangemaakt op | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Gemaakt door | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
int64 |
Levertijd in Dagen | filters on the platform, writable, ::ancestor. |
The delivery time in days of this material per unit. | |
division |
int64 |
Divisie ID | writable, division |
The division ID that belongs to this material per division. | |
ean |
varchar2 |
EAN-code | filters on the platform, writable, ::ancestor. |
The ean code of this material per unit. | |
form |
varchar2 |
Vormfactor Onderste Radius | filters on the platform, writable, ::ancestor. |
The bottom radius of the form factor. | |
form |
datetime |
Vormfactor Gemaakt op | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
form |
varchar2 |
Vormfactor Gemaakt door | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
form |
varchar2 |
Vormfactor Diepte | filters on the platform, writable, ::ancestor. |
The depth of the form factor. | |
form |
varchar2 |
Vormfactor Hoogte | filters on the platform, writable, ::ancestor. |
The height of the form factor. | |
form |
int64 |
Vormfactor-ID | filters on the platform, writable, ::ancestor. |
ID of the form factor. | |
form |
varchar2 |
Vormfactor Binnenradius | filters on the platform, writable, ::ancestor. |
The inner radius of the form factor. | |
form |
varchar2 |
Vormfactor Buitenradius | filters on the platform, writable, ::ancestor. |
The outer radius of the form factor. | |
form |
varchar2 |
Vormfactor Radius | filters on the platform, writable, ::ancestor. |
The radius of the form factor. | |
form |
varchar2 |
Vormfactor Bovenste Radius | filters on the platform, writable, ::ancestor. |
The top radius of the form factor. | |
form |
int64 |
Vormfactorsoort | filters on the platform, writable, ::ancestor. |
The form factor type/shape of this form factor. | |
form |
int64 |
Vormfactoreenheid | filters on the platform, writable, ::ancestor. |
The unit of the form factor. | |
form |
datetime |
Vormfactor Bijgewerkt op | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
form |
varchar2 |
Vormfactor Bijgewerkt door | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
form |
varchar2 |
Vormfactor Gewicht | filters on the platform, writable, ::ancestor. |
The weight of the form factor. | |
form |
varchar2 |
Vormfactor Breedte | filters on the platform, writable, ::ancestor. |
The width of the form factor. | |
gl |
varchar2 |
Grootboekrekeningcode | writable, gl |
The general ledger account code that belongs to this material per division. | |
gl |
varchar2 |
itgen_bouw7_glaccountcode_2 | filters on the platform, writable, ::ancestor. |
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 of this material per unit. | |
is |
char |
Is Actief | 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 |
datetime |
Materiaalgroep Gemaakt op | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
material |
varchar2 |
Materiaalgroep Gemaakt door | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
material |
int64 |
Materiaalgroep-ID | filters on the platform, writable, ::ancestor. |
ID of the material group. | |
material |
varchar2 |
Materiaalgroepnaam | filters on the platform, writable, ::ancestor. |
Name of the material group. | |
material |
datetime |
Materiaalgroep Bijgewerkt op | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
material |
varchar2 |
Materiaalgroep Bijgewerkt door | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
material |
int64 |
Materiaaleenheid-ID | filters on the platform, writable, ::ancestor. |
ID of the material unit. | |
material |
varchar2 |
Materiaal Naam Eenheid | filters on the platform, writable, ::ancestor. |
The name of the material unit. | |
material_ |
int64 |
Materiaal-ID | filters on the platform, writable, ::ancestor. |
ID of the material. | |
material_ |
varchar2 |
Materiaalinformatie | filters on the platform, writable, ::ancestor. |
Extra information describing this material. | |
material_ |
varchar2 |
Materiaalnaam | filters on the platform, writable, ::ancestor. |
Name of the material. | |
price |
varchar2 |
Price | filters on the platform, writable, ::ancestor. |
The price of this material per unit. | |
selling |
varchar2 |
Verkoopprijs | filters on the platform, writable, ::ancestor. |
The selling price of this material per unit. | |
supplier_ |
int64 |
Leverancier Contactsoort-ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
supplier_ |
varchar2 |
Leverancier Contactsoortnaam | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
supplier_ |
varchar2 |
Leverancier E-mail | filters on the platform, writable, ::ancestor. |
The email address. | |
supplier_ |
int64 |
Leverancier-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 |
Leveranciersnaam | 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 |
Bijgewerkt op | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Bijgewerkt door | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
vat |
varchar2 |
BTW-tarief Geldig vanaf | filters on the platform, writable, ::ancestor. |
The date since this VAT tariff is effective. | |
vat |
int64 |
BTW-Tarief ID | filters on the platform, writable, ::ancestor. |
ID of the vat tariff. | |
vat |
char |
BTW-tarief is Standaard | filters on the platform, writable, ::ancestor. |
Whether this VAT is default for the country its associated with. | |
vat |
char |
BTW-Tarief Is Verlegd | filters on the platform, writable, ::ancestor. |
Whether the VAT is shifted. | |
vat |
varchar2 |
BTW-Tarief 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 |
BTW-Tarief Percentage | filters on the platform, writable, ::ancestor. |
The VAT percentage. | |
vat |
varchar2 |
BTW-tarief Verlegd Percentage | filters on the platform, writable, ::ancestor. |
The shifted VAT percentage. | |
visibility |
int64 |
Zichtbaarheidsvlag | filters on the platform, writable, ::ancestor. |
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: