# EmployeeRoles_ItemsTimeOperationsArticleSuppliers
Search
This is a read-only table function. The ROBAWS API may not support modifying the data, or the Invantive SQL driver for ROBAWS does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the ROBAWS API.
- Catalog: `Robaws`
- Schema: `EmployeeRole`
## Parameters of Table Function
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `searchText` | `string` | ☐ | | |
| `sort` | `string` | ☐ | | |
| `withArchived` | `boolean` | ☐ | | |
## Columns
The columns of the table `EmployeeRoles_ItemsTimeOperationsArticleSuppliers` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `activity__metadata_description` | `string` | | ☐ | |
| `activity__metadata_href` | `string` | | ☐ | |
| `activity__metadata_resource` | `string` | | ☐ | |
| `activity__metadata_resourceTypeId` | `string` | | ☐ | |
| `activity_archivedAt` | `datetime` | | ☐ | |
| `activity_createdAt` | `datetime` | | ☐ | |
| `activity_deletedAt` | `datetime` | | ☐ | |
| `activity_extraFields` | `string` | | ☐ | |
| `activity_id` | `string` | | ☐ | |
| `activity_lockedAt` | `datetime` | | ☐ | |
| `activity_name` | `string` | | ☐ | |
| `activity_updatedAt` | `datetime` | | ☐ | |
| `activityId` | `string` | | ☐ | |
| `amountPerUnit` | `decimal` | | ☐ | |
| `archivedAt_1` | `datetime` | | ☐ | |
| `archivedAt_2` | `datetime` | | ☐ | |
| `archivedAt` | `datetime` | | ☐ | |
| `articleGroupId` | `string` | | ☐ | |
| `articleId` | `string` | | ☐ | Only present when obtained via bulk endpoint |
| `articleNumber` | `string` | Article Number | ☐ | |
| `availableStock` | `decimal` | | ☐ | This property should be used by third parties (for example webshops) that want to know how much stock is available for sale.When reading, only present if requested via 'include' query parameter, otherwise null. |
| `backorderStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. |
| `barcode` | `string` | Barcode | ☐ | |
| `brand` | `string` | Brand | ☐ | |
| `c_metadata_description_1` | `string` | | ☐ | |
| `c_metadata_description_2` | `string` | | ☐ | |
| `c_metadata_description` | `string` | | ☐ | |
| `c_metadata_href_1` | `string` | | ☐ | |
| `c_metadata_href_2` | `string` | | ☐ | |
| `c_metadata_href` | `string` | | ☐ | |
| `c_metadata_resource_1` | `string` | | ☐ | |
| `c_metadata_resource_2` | `string` | | ☐ | |
| `c_metadata_resource` | `string` | | ☐ | |
| `c_metadata_resourceTypeId_1` | `string` | | ☐ | |
| `c_metadata_resourceTypeId_2` | `string` | | ☐ | |
| `c_metadata_resourceTypeId` | `string` | | ☐ | |
| `calculationType` | `string` | Calculation Type | ☐ | |
| `costPrice` | `decimal` | Cost Price | ☐ | |
| `costPriceStrategy` | `string` | | ☐ | |
| `createdAt_1` | `datetime` | | ☐ | |
| `createdAt_2` | `datetime` | | ☐ | |
| `createdAt` | `datetime` | | ☐ | |
| `date` | `datetime` | Date | ☐ | |
| `deletedAt_1` | `datetime` | | ☐ | |
| `deletedAt_2` | `datetime` | | ☐ | |
| `deletedAt` | `datetime` | | ☐ | |
| `description` | `string` | Description | ☐ | |
| `descriptionTranslations` | `string` | | ☐ | |
| `extraField1` | `string` | | ☐ | |
| `extraField2` | `string` | | ☐ | |
| `extraField3` | `string` | | ☐ | |
| `extraFields_1` | `string` | | ☐ | |
| `extraFields_2` | `string` | | ☐ | |
| `extraFields` | `string` | | ☐ | |
| `grossPrice` | `decimal` | | ☐ | |
| `group__metadata_description` | `string` | | ☐ | |
| `group__metadata_href` | `string` | | ☐ | |
| `group__metadata_resource` | `string` | | ☐ | |
| `group__metadata_resourceTypeId` | `string` | | ☐ | |
| `group_archivedAt` | `datetime` | | ☐ | |
| `group_createdAt` | `datetime` | | ☐ | |
| `group_deletedAt` | `datetime` | | ☐ | |
| `group_extraFields` | `string` | | ☐ | |
| `group_id` | `string` | | ☐ | |
| `group_image__metadata_description` | `string` | | ☐ | |
| `group_image__metadata_href` | `string` | | ☐ | |
| `group_image__metadata_resource` | `string` | | ☐ | |
| `group_image__metadata_resourceTypeId` | `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_lockedAt` | `datetime` | | ☐ | |
| `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_lockedAt` | `datetime` | | ☐ | |
| `group_name` | `string` | | ☐ | |
| `group_parentId` | `string` | | ☐ | |
| `group_updatedAt` | `datetime` | | ☐ | |
| `group_wappy` | `boolean` | | ☐ | |
| `id_1` | `string` | | ☐ | |
| `id_2` | `string` | | ☐ | |
| `id` | `string` | ID | ☐ | |
| `image__metadata_description` | `string` | | ☐ | |
| `image__metadata_href` | `string` | | ☐ | |
| `image__metadata_resource` | `string` | | ☐ | |
| `image__metadata_resourceTypeId` | `string` | | ☐ | |
| `image_archivedAt` | `datetime` | | ☐ | |
| `image_contentType` | `string` | | ☐ | |
| `image_createdAt` | `datetime` | | ☐ | |
| `image_deletedAt` | `datetime` | | ☐ | |
| `image_directory` | `boolean` | | ☐ | |
| `image_id` | `string` | | ☐ | |
| `image_lockedAt` | `datetime` | | ☐ | |
| `image_name` | `string` | | ☐ | |
| `image_parentId` | `string` | | ☐ | |
| `image_previewUrl` | `string` | | ☐ | |
| `image_size` | `int64` | | ☐ | |
| `image_updatedAt` | `datetime` | | ☐ | |
| `image_url` | `string` | | ☐ | |
| `installation` | `boolean` | | ☐ | |
| `lockedAt_1` | `datetime` | | ☐ | |
| `lockedAt_2` | `datetime` | | ☐ | |
| `lockedAt` | `datetime` | | ☐ | |
| `margin` | `decimal` | Margin | ☐ | |
| `minimumPurchaseAmount` | `decimal` | | ☐ | |
| `minimumStock` | `decimal` | | ☐ | |
| `name_1` | `string` | | ☐ | |
| `name` | `string` | Name | ☐ | |
| `nameTranslations` | `string` | | ☐ | |
| `price` | `decimal` | Price | ☐ | |
| `purchaseGLAccount__metadata_description` | `string` | | ☐ | |
| `purchaseGLAccount__metadata_href` | `string` | | ☐ | |
| `purchaseGLAccount__metadata_resource` | `string` | | ☐ | |
| `purchaseGLAccount__metadata_resourceTypeId` | `string` | | ☐ | |
| `purchaseGLAccount_archivedAt` | `datetime` | | ☐ | |
| `purchaseGLAccount_code` | `string` | | ☐ | |
| `purchaseGLAccount_createdAt` | `datetime` | | ☐ | |
| `purchaseGLAccount_deletedAt` | `datetime` | | ☐ | |
| `purchaseGLAccount_extraFields` | `string` | | ☐ | |
| `purchaseGLAccount_id` | `string` | | ☐ | |
| `purchaseGLAccount_lockedAt` | `datetime` | | ☐ | |
| `purchaseGLAccount_name` | `string` | | ☐ | |
| `purchaseGLAccount_updatedAt` | `datetime` | | ☐ | |
| `purchaseGLAccountId` | `string` | | ☐ | |
| `reference` | `string` | Reference | ☐ | |
| `reservedStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. |
| `saleName` | `string` | | ☐ | |
| `salePrice` | `decimal` | Selling Price | ☐ | |
| `salePriceStrategy` | `string` | | ☐ | |
| `salesGLAccount__metadata_description` | `string` | | ☐ | |
| `salesGLAccount__metadata_href` | `string` | | ☐ | |
| `salesGLAccount__metadata_resource` | `string` | | ☐ | |
| `salesGLAccount__metadata_resourceTypeId` | `string` | | ☐ | |
| `salesGLAccount_archivedAt` | `datetime` | | ☐ | |
| `salesGLAccount_code` | `string` | | ☐ | |
| `salesGLAccount_createdAt` | `datetime` | | ☐ | |
| `salesGLAccount_deletedAt` | `datetime` | | ☐ | |
| `salesGLAccount_extraFields` | `string` | | ☐ | |
| `salesGLAccount_id` | `string` | | ☐ | |
| `salesGLAccount_lockedAt` | `datetime` | | ☐ | |
| `salesGLAccount_name` | `string` | | ☐ | |
| `salesGLAccount_updatedAt` | `datetime` | | ☐ | |
| `salesGLAccountId` | `string` | | ☐ | |
| `stockArticle` | `boolean` | | ☐ | |
| `stockPlace` | `string` | | ☐ | |
| `supplier__metadata_description` | `string` | | ☐ | |
| `supplier__metadata_href` | `string` | | ☐ | |
| `supplier__metadata_resource` | `string` | | ☐ | |
| `supplier__metadata_resourceTypeId` | `string` | | ☐ | |
| `supplier_archivedAt` | `datetime` | | ☐ | |
| `supplier_createdAt` | `datetime` | | ☐ | |
| `supplier_deletedAt` | `datetime` | | ☐ | |
| `supplier_email` | `string` | | ☐ | |
| `supplier_extraFields` | `string` | | ☐ | |
| `supplier_fax` | `string` | | ☐ | |
| `supplier_generalLedgerAccount__metadata_description` | `string` | | ☐ | |
| `supplier_generalLedgerAccount__metadata_href` | `string` | | ☐ | |
| `supplier_generalLedgerAccount__metadata_resource` | `string` | | ☐ | |
| `supplier_generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | |
| `supplier_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | |
| `supplier_generalLedgerAccount_code` | `string` | | ☐ | |
| `supplier_generalLedgerAccount_createdAt` | `datetime` | | ☐ | |
| `supplier_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | |
| `supplier_generalLedgerAccount_extraFields` | `string` | | ☐ | |
| `supplier_generalLedgerAccount_id` | `string` | | ☐ | |
| `supplier_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | |
| `supplier_generalLedgerAccount_name` | `string` | | ☐ | |
| `supplier_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | |
| `supplier_generalLedgerAccountId` | `string` | | ☐ | |
| `supplier_gsm` | `string` | | ☐ | |
| `supplier_iban` | `string` | | ☐ | |
| `supplier_id` | `string` | | ☐ | |
| `supplier_invoiceAddress_addressLine1` | `string` | | ☐ | |
| `supplier_invoiceAddress_addressLine2` | `string` | | ☐ | |
| `supplier_invoiceAddress_city` | `string` | | ☐ | |
| `supplier_invoiceAddress_country` | `string` | | ☐ | |
| `supplier_invoiceAddress_latitude` | `double` | | ☐ | |
| `supplier_invoiceAddress_longitude` | `double` | | ☐ | |
| `supplier_invoiceAddress_postalCode` | `string` | | ☐ | |
| `supplier_invoiceRemarks` | `string` | | ☐ | |
| `supplier_kvk` | `string` | | ☐ | |
| `supplier_language` | `string` | | ☐ | |
| `supplier_legalForm__metadata_description` | `string` | | ☐ | |
| `supplier_legalForm__metadata_href` | `string` | | ☐ | |
| `supplier_legalForm__metadata_resource` | `string` | | ☐ | |
| `supplier_legalForm__metadata_resourceTypeId` | `string` | | ☐ | |
| `supplier_legalForm_archivedAt` | `datetime` | | ☐ | |
| `supplier_legalForm_createdAt` | `datetime` | | ☐ | |
| `supplier_legalForm_deletedAt` | `datetime` | | ☐ | |
| `supplier_legalForm_extraFields` | `string` | | ☐ | |
| `supplier_legalForm_id` | `string` | | ☐ | |
| `supplier_legalForm_legalAbbreviation` | `string` | | ☐ | |
| `supplier_legalForm_lockedAt` | `datetime` | | ☐ | |
| `supplier_legalForm_name` | `string` | | ☐ | |
| `supplier_legalForm_updatedAt` | `datetime` | | ☐ | |
| `supplier_legalForm_vatLiable` | `boolean` | | ☐ | |
| `supplier_legalFormId` | `string` | | ☐ | |
| `supplier_lockedAt` | `datetime` | | ☐ | |
| `supplier_logicId` | `string` | | ☐ | |
| `supplier_name` | `string` | | ☐ | |
| `supplier_paymentConditionId` | `string` | | ☐ | |
| `supplier_planningEmail` | `string` | | ☐ | |
| `supplier_status` | `string` | | ☐ | |
| `supplier_statusDetails_color` | `string` | | ☐ | |
| `supplier_statusDetails_name` | `string` | | ☐ | |
| `supplier_supplyOrderRemarks` | `string` | | ☐ | |
| `supplier_tel` | `string` | | ☐ | |
| `supplier_type` | `string` | | ☐ | |
| `supplier_updatedAt` | `datetime` | | ☐ | |
| `supplier_vatIdNumber` | `string` | | ☐ | |
| `supplier_vatTariff__metadata_description` | `string` | | ☐ | |
| `supplier_vatTariff__metadata_href` | `string` | | ☐ | |
| `supplier_vatTariff__metadata_resource` | `string` | | ☐ | |
| `supplier_vatTariff__metadata_resourceTypeId` | `string` | | ☐ | |
| `supplier_vatTariff_additionalMention` | `string` | | ☐ | |
| `supplier_vatTariff_archivedAt` | `datetime` | | ☐ | |
| `supplier_vatTariff_category` | `string` | | ☐ | |
| `supplier_vatTariff_createdAt` | `datetime` | | ☐ | |
| `supplier_vatTariff_deletedAt` | `datetime` | | ☐ | |
| `supplier_vatTariff_description` | `string` | | ☐ | |
| `supplier_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | |
| `supplier_vatTariff_extraFields` | `string` | | ☐ | |
| `supplier_vatTariff_id` | `string` | | ☐ | |
| `supplier_vatTariff_inclusive` | `boolean` | | ☐ | |
| `supplier_vatTariff_lockedAt` | `datetime` | | ☐ | |
| `supplier_vatTariff_name` | `string` | | ☐ | |
| `supplier_vatTariff_percentage` | `decimal` | | ☐ | |
| `supplier_vatTariff_updatedAt` | `datetime` | | ☐ | |
| `supplier_vatTariffId` | `string` | | ☐ | |
| `supplier_website` | `string` | | ☐ | |
| `supplierId` | `string` | | ☐ | |
| `targetStock` | `decimal` | | ☐ | |
| `timeOperation` | `boolean` | Time Operation | ☐ | |
| `totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. |
| `type` | `string` | Type | ☐ | |
| `unitType_1` | `string` | | ☐ | |
| `unitType` | `string` | Unit Type | ☐ | |
| `updatedAt_1` | `datetime` | | ☐ | |
| `updatedAt_2` | `datetime` | | ☐ | |
| `updatedAt` | `datetime` | | ☐ | |
| `vatTariffId` | `string` | | ☐ | |
| `wappy` | `boolean` | | ☐ | |