Please enable JavaScript to view this site.

ROBAWS Data Model

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

Users: False

Contents Previous Home Next More

Name: Users

search

Catalog: Robaws

Schema: Users

Label: Users

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

Select Service URL (OData-specific): /api/v1/users

Insert Service URL (OData-specific): /api/v1/users

Update Service URL (OData-specific): /api/v1/users

Delete Service URL (OData-specific): /api/v1/users

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): content[*]

Select Operation (Swagger-specific): get /api/v1/users

Insert Operation (Swagger-specific): post /api/v1/users

Update Operation (Swagger-specific): put /api/v1/users/{id}

Delete Operation (Swagger-specific): delete /api/v1/users/{id}

Parameters

Name

Data Type

Required

Default Value

Documentation

name

string

 

name

offset

int64

 

 

paged

boolean

 

 

pageNumber

int32

 

 

size

int32

 

Number of records per page.

sort.sorted

boolean

 

 

sort.unsorted

boolean

 

 

unpaged

boolean

 

 

updatedFrom

datetime

 

updatedFrom

 

Table Columns

Name

Data Type

Label

Required

Documentation

avatar_directory

boolean

 

 

avatar_documentDate

datetime

 

 

avatar_expirationDate

datetime

 

 

avatar_filename

string

 

 

avatar_fileSize

int64

 

 

avatar_id

int64

 

 

avatar_mimeType

string

 

 

avatar_objectRef_objectId

int64

 

 

avatar_objectRef_objectType

string

 

 

avatar_parentId

int64

 

 

avatar_path

string

 

 

avatar_uuid

string

 

 

avatar_version

int64

 

 

avatar_wappy

boolean

 

 

email

string

Email

 

emailAccount_emailAccountType

string

 

 

emailAccount_emailBcc

string

 

 

emailAccount_emailFrom

string

 

 

emailAccount_emailFromName

string

 

 

emailAccount_emailHost

string

 

 

emailAccount_emailPass

string

 

 

emailAccount_emailPort

string

 

 

emailAccount_emailUser

string

 

 

emailAccount_starttls

boolean

 

 

emailAccount_uuid

string

 

 

employee_address_city

string

 

 

employee_address_country

string

 

 

employee_address_latLng_lat

double

 

 

employee_address_latLng_lng

double

 

 

employee_address_street

string

 

 

employee_address_streetExtra

string

 

 

employee_address_zipcode

string

 

 

employee_bankaccountNr

string

 

 

employee_birthDate

datetime

 

 

employee_civilStatus

string

 

 

employee_competenceLevel

string

 

 

employee_costPerHour

double

 

 

employee_defaultMobility_id

int64

 

 

employee_defaultMobility_name

string

 

 

employee_defaultMobility_version

int64

 

 

employee_defaultOperation_accountancyCode_code

string

 

 

employee_defaultOperation_accountancyCode_externalId

string

 

 

employee_defaultOperation_accountancyCode_id

int64

 

 

employee_defaultOperation_accountancyCode_name

string

 

 

employee_defaultOperation_accountancyCode_version

int64

 

 

employee_defaultOperation_accountancyCodePurchase_code

string

 

 

employee_defaultOperation_accountancyCodePurchase_externalId

string

 

 

employee_defaultOperation_accountancyCodePurchase_id

int64

 

 

employee_defaultOperation_accountancyCodePurchase_name

string

 

 

employee_defaultOperation_accountancyCodePurchase_version

int64

 

 

employee_defaultOperation_activity

string

 

 

employee_defaultOperation_agreementType

string

 

 

employee_defaultOperation_articleGroup_contextPath

string

 

 

employee_defaultOperation_articleGroup_id

int64

 

 

employee_defaultOperation_articleGroup_name

string

 

 

employee_defaultOperation_articleGroup_photo_directory

boolean

 

 

employee_defaultOperation_articleGroup_photo_documentDate

datetime

 

 

employee_defaultOperation_articleGroup_photo_expirationDate

datetime

 

 

employee_defaultOperation_articleGroup_photo_filename

string

 

 

employee_defaultOperation_articleGroup_photo_fileSize

int64

 

 

employee_defaultOperation_articleGroup_photo_id

int64

 

 

employee_defaultOperation_articleGroup_photo_mimeType

string

 

 

employee_defaultOperation_articleGroup_photo_objectRef_objectId

int64

 

 

employee_defaultOperation_articleGroup_photo_objectRef_objectType

string

 

 

employee_defaultOperation_articleGroup_photo_parentId

int64

 

 

employee_defaultOperation_articleGroup_photo_path

string

 

 

employee_defaultOperation_articleGroup_photo_uuid

string

 

 

employee_defaultOperation_articleGroup_photo_version

int64

 

 

employee_defaultOperation_articleGroup_photo_wappy

boolean

 

 

employee_defaultOperation_articleGroup_version

int64

 

 

employee_defaultOperation_articleNumber

string

 

 

employee_defaultOperation_articleType

string

 

 

employee_defaultOperation_barcode

string

 

 

employee_defaultOperation_brand

string

 

 

employee_defaultOperation_calc

boolean

 

 

employee_defaultOperation_calcDescription

string

 

 

employee_defaultOperation_calculationType

string

 

 

employee_defaultOperation_chapter

string

 

 

employee_defaultOperation_compositeArticle

boolean

 

 

employee_defaultOperation_costPrice

double

 

 

employee_defaultOperation_currencySymbol

string

 

 

employee_defaultOperation_description

string

 

 

employee_defaultOperation_deviantSalesName

string

 

 

employee_defaultOperation_headerLevel

string

 

 

employee_defaultOperation_id

int64

 

 

employee_defaultOperation_indirectCostFactor

double

 

 

employee_defaultOperation_internalPhoto

boolean

 

 

employee_defaultOperation_lineType

string

 

 

employee_defaultOperation_margin

double

 

 

employee_defaultOperation_materialInstallation

boolean

 

 

employee_defaultOperation_minimumSaleAmount

double

 

 

employee_defaultOperation_minimumStockAmount

double

 

 

employee_defaultOperation_name

string

 

 

employee_defaultOperation_newPage

boolean

 

 

employee_defaultOperation_photo_directory

boolean

 

 

employee_defaultOperation_photo_documentDate

datetime

 

 

employee_defaultOperation_photo_expirationDate

datetime

 

 

employee_defaultOperation_photo_filename

string

 

 

employee_defaultOperation_photo_fileSize

int64

 

 

employee_defaultOperation_photo_id

int64

 

 

employee_defaultOperation_photo_mimeType

string

 

 

employee_defaultOperation_photo_objectRef_objectId

int64

 

 

employee_defaultOperation_photo_objectRef_objectType

string

 

 

employee_defaultOperation_photo_parentId

int64

 

 

employee_defaultOperation_photo_path

string

 

 

employee_defaultOperation_photo_uuid

string

 

 

employee_defaultOperation_photo_version

int64

 

 

employee_defaultOperation_photo_wappy

boolean

 

 

employee_defaultOperation_saleName

string

 

 

employee_defaultOperation_salePrice

double

 

 

employee_defaultOperation_stockAmount

double

 

 

employee_defaultOperation_stockChanges

string

 

 

employee_defaultOperation_stockLocation

string

 

 

employee_defaultOperation_supplierNames

string

 

 

employee_defaultOperation_timeOperation

boolean

 

 

employee_defaultOperation_unitType

string

 

 

employee_defaultOperation_useMargin

boolean

 

 

employee_defaultOperation_vatTarif

string

 

 

employee_defaultOperation_version

int64

 

 

employee_dependentChildren

int32

 

 

employee_detachment

boolean

 

 

employee_dimona

string

 

 

employee_dimonaExpireDate

datetime

 

 

employee_distance

double

 

 

employee_documentRsz

int64

 

 

employee_documentRszPayment

int64

 

 

employee_documentRszValidTill

datetime

 

 

employee_driverLicense

string

 

 

employee_email

string

 

 

employee_emergencyTel

string

 

 

employee_employeeGone

datetime

 

 

employee_employeeRole_id

int64

 

 

employee_employeeRole_name

string

 

 

employee_employeeRole_version

int64

 

 

employee_employeeSince

datetime

 

 

employee_employeeStatute

string

 

 

employee_expireDateRszPayment

datetime

 

 

employee_fullname

string

 

 

employee_function

string

 

 

employee_gender

string

 

 

employee_grossSalary

double

 

 

employee_gsm

string

 

 

employee_gsmOrTel

string

 

 

employee_id

int64

 

 

employee_independentCertificate

boolean

 

 

employee_independentConnection

boolean

 

 

employee_insz

string

 

 

employee_limosaExpireDate

datetime

 

 

employee_limosaNr

string

 

 

employee_name

string

 

 

employee_nameAndState

string

 

 

employee_nationality

string

 

 

employee_passportExpireDate

datetime

 

 

employee_passportNr

string

 

 

employee_paymentRsz

boolean

 

 

employee_planningGroup

string

 

 

employee_startDate

datetime

 

 

employee_status

string

 

 

employee_subType

string

 

 

employee_supplier_accountancyCodePurchase_code

string

 

 

employee_supplier_accountancyCodePurchase_externalId

string

 

 

employee_supplier_accountancyCodePurchase_id

int64

 

 

employee_supplier_accountancyCodePurchase_name

string

 

 

employee_supplier_accountancyCodePurchase_version

int64

 

 

employee_supplier_accountNr

string

 

 

employee_supplier_addressString

string

 

 

employee_supplier_bank

string

 

 

employee_supplier_btwNumber

string

 

 

employee_supplier_currencySymbol

string

 

 

employee_supplier_email

string

 

 

employee_supplier_externalId

string

 

 

employee_supplier_fax

string

 

 

employee_supplier_gsm

string

 

 

employee_supplier_id

int64

 

 

employee_supplier_invoiceAddress_city

string

 

 

employee_supplier_invoiceAddress_country

string

 

 

employee_supplier_invoiceAddress_latLng_lat

double

 

 

employee_supplier_invoiceAddress_latLng_lng

double

 

 

employee_supplier_invoiceAddress_street

string

 

 

employee_supplier_invoiceAddress_streetExtra

string

 

 

employee_supplier_invoiceAddress_zipcode

string

 

 

employee_supplier_invoiceRemarks

string

 

 

employee_supplier_language

string

 

 

employee_supplier_legalForm_hasVat

boolean

 

 

employee_supplier_legalForm_id

int64

 

 

employee_supplier_legalForm_name

string

 

 

employee_supplier_legalForm_pdfName

string

 

 

employee_supplier_legalForm_version

int64

 

 

employee_supplier_legalName

string

 

 

employee_supplier_logicId

string

 

 

employee_supplier_name

string

 

 

employee_supplier_status

string

 

 

employee_supplier_supplyOrderRemarks

string

 

 

employee_supplier_tel

string

 

 

employee_supplier_vat_ublSchemeId

string

 

 

employee_supplier_vat_vatCode

string

 

 

employee_supplier_vat_vatCountry

string

 

 

employee_supplier_vat_vatValid

boolean

 

 

employee_supplier_vatNr

string

 

 

employee_supplier_vatTarif

string

 

 

employee_supplier_version

int64

 

 

employee_supplier_website

string

 

 

employee_supplierName

string

 

 

employee_surname

string

 

 

employee_tel

string

 

 

employee_type

string

 

 

employee_version

int64

 

 

employeeId

int64

Employee ID

 

fullname

string

Full Name

 

id

int64

ID

 

schema

string

Schema

 

signature

string

Signature

 

useEmailAccount

boolean

Use Email Account

 

username

string

User Name

 

userRole_id

int64

 

 

userRole_name

string

 

 

userRole_version

int64

 

 

userRoleString

string

 

 

version

int64

Version

 

 

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