ROBAWS Data Model

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

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

UsersById:

Contents Previous Home Next More

Name: UsersById

get

Catalog: Robaws

Schema: Users

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

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

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

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

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

Field Selection Method (OData-specific): NotRequired

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

Parameters

Name	Data Type	Required	Default Value	Documentation
id	int64	☑		id

Table Columns

Name	Data Type	Label	Required
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

Please enable JavaScript to view this site.

ROBAWS Data Model

Parameters

Table Columns