EmployeeRoleTimeOperationsByEmployeeRoleId |
Find one
Catalog: Robaws
Schema: EmployeeRole
This is a read-only table function. The Robaws API may not support changing the data or the Invantive SQL driver for Robaws does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Robaws API.
Select Robaws API URL: /api/v2/employee-roles/{id}
Insert Robaws API URL: /api/v2/employee-roles/{id}
Update Robaws API URL: /api/v2/employee-roles/{id}
Delete Robaws API URL: /api/v2/employee-roles/{id}
Field Selection Method: NotRequired
Base Path: timeOperations[*]
Select Robaws API Operation: get /api/v2/employee-roles/{id}
Table Function Columns
The columns of the table function EmployeeRoleTimeOperationsByEmployeeRoleId are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
archivedAt_1 |
datetime |
|
☐ |
|
archivedAt |
datetime |
|
☐ |
|
articleGroupId |
string |
|
☐ |
|
articleNumber |
string |
Article Number |
☐ |
|
availableStock |
decimal |
|
☐ |
This property should be used by third parties (for example webshops) that want to know how much stockis available for sale.When reading, only present if requested via 'include' query parameter, otherwise null. |
barcode |
string |
Bar Code |
☐ |
|
brand |
string |
Brand |
☐ |
|
costPrice |
decimal |
Cost Price |
☐ |
|
costPriceStrategy |
string |
|
☐ |
|
createdAt_1 |
datetime |
|
☐ |
|
createdAt |
datetime |
|
☐ |
|
deletedAt_1 |
datetime |
|
☐ |
|
deletedAt |
datetime |
|
☐ |
|
description |
string |
Description |
☐ |
|
group_archivedAt |
datetime |
|
☐ |
|
group_createdAt |
datetime |
|
☐ |
|
group_deletedAt |
datetime |
|
☐ |
|
group_id |
string |
|
☐ |
|
group_image_archivedAt |
datetime |
|
☐ |
|
group_image_contentType |
string |
|
☐ |
|
group_image_createdAt |
datetime |
|
☐ |
|
group_image_deletedAt |
datetime |
|
☐ |
|
group_image_directory |
boolean |
|
☐ |
|
group_image_id |
string |
|
☐ |
|
group_image_name |
string |
|
☐ |
|
group_image_parentId |
string |
|
☐ |
|
group_image_previewUrl |
string |
|
☐ |
|
group_image_size |
int64 |
|
☐ |
|
group_image_updatedAt |
datetime |
|
☐ |
|
group_image_url |
string |
|
☐ |
|
group_name |
string |
|
☐ |
|
group_parentId |
string |
|
☐ |
|
group_updatedAt |
datetime |
|
☐ |
|
id_1 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
image_archivedAt |
datetime |
|
☐ |
|
image_contentType |
string |
|
☐ |
|
image_createdAt |
datetime |
|
☐ |
|
image_deletedAt |
datetime |
|
☐ |
|
image_directory |
boolean |
|
☐ |
|
image_id |
string |
|
☐ |
|
image_name |
string |
|
☐ |
|
image_parentId |
string |
|
☐ |
|
image_previewUrl |
string |
|
☐ |
|
image_size |
int64 |
|
☐ |
|
image_updatedAt |
datetime |
|
☐ |
|
image_url |
string |
|
☐ |
|
name_1 |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
saleName |
string |
|
☐ |
|
salePrice |
decimal |
Sales Price |
☐ |
|
salePriceStrategy |
string |
|
☐ |
|
stockArticle |
boolean |
|
☐ |
|
stockPlace |
string |
|
☐ |
|
timeOperation |
boolean |
Time Operation |
☐ |
|
totalStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
unitType |
string |
Unit Type |
☐ |
|
updatedAt_1 |
datetime |
|
☐ |
|
updatedAt |
datetime |
|
☐ |
|
vatTariffId |
string |
|
☐ |
|
17-06-2022 11:59 Version 22.1.46-BETA+3385