Please enable JavaScript to view this site.

ROBAWS Data Model

Navigation: Catalog: Robaws > Schemas > Schema: Materials > Tables

MaterialsById: False

Contents Previous Home Next More

Name: MaterialsById

get

Catalog: Robaws

Schema: Materials

Label: Materials by ID

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): /api/v1/materials/{id}

Insert Service URL (OData-specific): /api/v1/materials/{id}

Update Service URL (OData-specific): /api/v1/materials/{id}

Delete Service URL (OData-specific): /api/v1/materials/{id}

Field Selection Method (OData-specific): NotRequired

Select Operation (Swagger-specific): get /api/v1/materials/{id}

Parameters

Name

Data Type

Required

Default Value

Documentation

id

int64

 

id

 

Table Columns

Name

Data Type

Label

Required

Documentation

article_activity

string

 

 

article_agreementType

string

 

 

article_articleNumber

string

 

 

article_articleType

string

 

 

article_barcode

string

 

 

article_brand

string

 

 

article_calc

boolean

 

 

article_calcDescription

string

 

 

article_calculationType

string

 

 

article_chapter

string

 

 

article_compositeArticle

boolean

 

 

article_costPrice

double

 

 

article_currencySymbol

string

 

 

article_description

string

 

 

article_deviantSalesName

string

 

 

article_headerLevel

string

 

 

article_id

int64

 

 

article_indirectCostFactor

double

 

 

article_internalPhoto

boolean

 

 

article_lineType

string

 

 

article_margin

double

 

 

article_materialInstallation

boolean

 

 

article_minimumSaleAmount

double

 

 

article_minimumStockAmount

double

 

 

article_name

string

 

 

article_newPage

boolean

 

 

article_saleName

string

 

 

article_salePrice

double

 

 

article_stockAmount

double

 

 

article_stockChanges

string

 

 

article_stockLocation

string

 

 

article_supplierNames

string

 

 

article_timeOperation

boolean

 

 

article_unitType

string

 

 

article_useMargin

boolean

 

 

article_vatTarif

string

 

 

article_version

int64

 

 

articleName

string

Article Name

 

available

boolean

Available

 

barcode

string

Bar Code

 

brand

string

Brand

 

id

int64

ID

 

location

string

Location

 

materialInstallation

boolean

 

 

name

string

Name

 

onProject_addressString

string

 

 

onProject_checkInAtWork

string

 

 

onProject_clientName

string

 

 

onProject_clientReference

string

 

 

onProject_contactPersonMail

string

 

 

onProject_contactPersonName

string

 

 

onProject_contactPersonTel

string

 

 

onProject_date

datetime

 

 

onProject_endClientName

string

 

 

onProject_id

int64

 

 

onProject_kilometers

int32

 

 

onProject_km

double

 

 

onProject_logicId

string

 

 

onProject_planningGroup

string

 

 

onProject_planningName

string

 

 

onProject_siteNotification

string

 

 

onProject_siteRsz

string

 

 

onProject_status

string

 

 

onProject_version

int64

 

 

onProject_workOrderInfo

string

 

 

onProject_yearNumber

int32

 

 

onProjectString

string

 

 

ownerClient_accountNr

string

 

 

ownerClient_addressString

string

 

 

ownerClient_assigneeName

string

 

 

ownerClient_bank

string

 

 

ownerClient_contactMedium

string

 

 

ownerClient_creditDate

datetime

 

 

ownerClient_creditInfo

string

 

 

ownerClient_creditLimit

double

 

 

ownerClient_creditStatus

string

 

 

ownerClient_currencySymbol

string

 

 

ownerClient_email

string

 

 

ownerClient_emailPermissionDate

datetime

 

 

ownerClient_emailPermissionFrom

string

 

 

ownerClient_externalId

string

 

 

ownerClient_fax

string

 

 

ownerClient_followUpDate

datetime

 

 

ownerClient_gsm

string

 

 

ownerClient_id

int64

 

 

ownerClient_invoiceEmail

string

 

 

ownerClient_invoiceRemarks

string

 

 

ownerClient_language

string

 

 

ownerClient_legalName

string

 

 

ownerClient_logicId

string

 

 

ownerClient_name

string

 

 

ownerClient_seperateInvoicePage

boolean

 

 

ownerClient_status

string

 

 

ownerClient_tel

string

 

 

ownerClient_title

string

 

 

ownerClient_useInvoiceAddress

boolean

 

 

ownerClient_usePeppol

boolean

 

 

ownerClient_vatNr

string

 

 

ownerClient_vatTarif

string

 

 

ownerClient_version

int64

 

 

ownerClient_website

string

 

 

ownerClient_withRespectTo

string

 

 

ownerClientName

string

 

 

ownerEmployee_bankaccountNr

string

 

 

ownerEmployee_birthDate

datetime

 

 

ownerEmployee_civilStatus

string

 

 

ownerEmployee_competenceLevel

string

 

 

ownerEmployee_costPerHour

double

 

 

ownerEmployee_dependentChildren

int32

 

 

ownerEmployee_detachment

boolean

 

 

ownerEmployee_dimona

string

 

 

ownerEmployee_dimonaExpireDate

datetime

 

 

ownerEmployee_distance

double

 

 

ownerEmployee_documentRsz

int64

 

 

ownerEmployee_documentRszPayment

int64

 

 

ownerEmployee_documentRszValidTill

datetime

 

 

ownerEmployee_driverLicense

string

 

 

ownerEmployee_email

string

 

 

ownerEmployee_emergencyTel

string

 

 

ownerEmployee_employeeGone

datetime

 

 

ownerEmployee_employeeSince

datetime

 

 

ownerEmployee_employeeStatute

string

 

 

ownerEmployee_expireDateRszPayment

datetime

 

 

ownerEmployee_fullname

string

 

 

ownerEmployee_function

string

 

 

ownerEmployee_gender

string

 

 

ownerEmployee_grossSalary

double

 

 

ownerEmployee_gsm

string

 

 

ownerEmployee_gsmOrTel

string

 

 

ownerEmployee_id

int64

 

 

ownerEmployee_independentCertificate

boolean

 

 

ownerEmployee_independentConnection

boolean

 

 

ownerEmployee_insz

string

 

 

ownerEmployee_limosaExpireDate

datetime

 

 

ownerEmployee_limosaNr

string

 

 

ownerEmployee_name

string

 

 

ownerEmployee_nameAndState

string

 

 

ownerEmployee_nationality

string

 

 

ownerEmployee_passportExpireDate

datetime

 

 

ownerEmployee_passportNr

string

 

 

ownerEmployee_paymentRsz

boolean

 

 

ownerEmployee_planningGroup

string

 

 

ownerEmployee_startDate

datetime

 

 

ownerEmployee_status

string

 

 

ownerEmployee_subType

string

 

 

ownerEmployee_supplierName

string

 

 

ownerEmployee_surname

string

 

 

ownerEmployee_tel

string

 

 

ownerEmployee_type

string

 

 

ownerEmployee_version

int64

 

 

ownerEmployeeName

string

 

 

ownerSupplier_accountNr

string

 

 

ownerSupplier_addressString

string

 

 

ownerSupplier_bank

string

 

 

ownerSupplier_btwNumber

string

 

 

ownerSupplier_currencySymbol

string

 

 

ownerSupplier_email

string

 

 

ownerSupplier_externalId

string

 

 

ownerSupplier_fax

string

 

 

ownerSupplier_gsm

string

 

 

ownerSupplier_id

int64

 

 

ownerSupplier_invoiceRemarks

string

 

 

ownerSupplier_language

string

 

 

ownerSupplier_legalName

string

 

 

ownerSupplier_logicId

string

 

 

ownerSupplier_name

string

 

 

ownerSupplier_status

string

 

 

ownerSupplier_supplyOrderRemarks

string

 

 

ownerSupplier_tel

string

 

 

ownerSupplier_vatNr

string

 

 

ownerSupplier_vatTarif

string

 

 

ownerSupplier_version

int64

 

 

ownerSupplier_website

string

 

 

ownerSupplierName

string

 

 

planningGroup

string

Planning Group

 

remark

string

Remark

 

status

string

Status

 

stockLocation_id

int64

 

 

stockLocation_name

string

 

 

stockLocation_version

int64

 

 

stockLocationName

string

Stock Location Name

 

supplier_accountNr

string

 

 

supplier_addressString

string

 

 

supplier_bank

string

 

 

supplier_btwNumber

string

 

 

supplier_currencySymbol

string

 

 

supplier_email

string

 

 

supplier_externalId

string

 

 

supplier_fax

string

 

 

supplier_gsm

string

 

 

supplier_id

int64

 

 

supplier_invoiceRemarks

string

 

 

supplier_language

string

 

 

supplier_legalName

string

 

 

supplier_logicId

string

 

 

supplier_name

string

 

 

supplier_status

string

 

 

supplier_supplyOrderRemarks

string

 

 

supplier_tel

string

 

 

supplier_vatNr

string

 

 

supplier_vatTarif

string

 

 

supplier_version

int64

 

 

supplier_website

string

 

 

supplierName

string

Supplier Name

 

type

string

Type

 

version

int64

Version

 

 

25-05-2020 14:5220.1.44-BETA+2813