# WorkOrderTimeEntriesIdsByWorkOrderId: ROBAWS Work Order Time Entry IDs by Work Order ID Find one 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: `WorkOrderTimeEntries` - Label: Work Order Time Entry IDs by Work Order ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | | `workOrderId` | `string` | ☐ | | | ## Columns The columns of the table `WorkOrderTimeEntriesIdsByWorkOrderId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | Archived at | ☐ | | | `article__metadata_description` | `string` | | ☐ | | | `article__metadata_href` | `string` | | ☐ | | | `article__metadata_resource` | `string` | | ☐ | | | `article__metadata_resourceTypeId` | `string` | | ☐ | | | `article_activity_archivedAt` | `datetime` | | ☐ | | | `article_activity_createdAt` | `datetime` | | ☐ | | | `article_activity_deletedAt` | `datetime` | | ☐ | | | `article_activity_extraFields` | `string` | | ☐ | | | `article_activity_id` | `string` | | ☐ | | | `article_activity_lockedAt` | `datetime` | | ☐ | | | `article_activity_name` | `string` | | ☐ | | | `article_activity_updatedAt` | `datetime` | | ☐ | | | `article_activityId` | `string` | | ☐ | | | `article_archivedAt` | `datetime` | | ☐ | | | `article_articleGroupId` | `string` | | ☐ | | | `article_articleNumber` | `string` | | ☐ | | | `article_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. | | `article_backorderStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_barcode` | `string` | Article Barcode | ☐ | | | `article_brand` | `string` | | ☐ | | | `article_calculationType` | `string` | | ☐ | | | `article_costPrice` | `decimal` | | ☐ | | | `article_costPriceStrategy` | `string` | | ☐ | | | `article_createdAt` | `datetime` | | ☐ | | | `article_deletedAt` | `datetime` | | ☐ | | | `article_description` | `string` | | ☐ | | | `article_descriptionTranslations` | `string` | | ☐ | | | `article_extraFields` | `string` | | ☐ | | | `article_group_archivedAt` | `datetime` | | ☐ | | | `article_group_createdAt` | `datetime` | | ☐ | | | `article_group_deletedAt` | `datetime` | | ☐ | | | `article_group_extraFields` | `string` | | ☐ | | | `article_group_id` | `string` | | ☐ | | | `article_group_lockedAt` | `datetime` | | ☐ | | | `article_group_name` | `string` | | ☐ | | | `article_group_parentId` | `string` | | ☐ | | | `article_group_updatedAt` | `datetime` | | ☐ | | | `article_group_wappy` | `boolean` | | ☐ | | | `article_id` | `string` | Item ID | ☐ | | | `article_image_archivedAt` | `datetime` | | ☐ | | | `article_image_contentType` | `string` | | ☐ | | | `article_image_createdAt` | `datetime` | | ☐ | | | `article_image_deletedAt` | `datetime` | | ☐ | | | `article_image_directory` | `boolean` | | ☐ | | | `article_image_id` | `string` | | ☐ | | | `article_image_lockedAt` | `datetime` | | ☐ | | | `article_image_name` | `string` | | ☐ | | | `article_image_parentId` | `string` | | ☐ | | | `article_image_previewUrl` | `string` | | ☐ | | | `article_image_size` | `int64` | | ☐ | | | `article_image_updatedAt` | `datetime` | | ☐ | | | `article_image_url` | `string` | | ☐ | | | `article_installation` | `boolean` | | ☐ | | | `article_lockedAt` | `datetime` | | ☐ | | | `article_margin` | `decimal` | | ☐ | | | `article_minimumStock` | `decimal` | | ☐ | | | `article_name` | `string` | | ☐ | | | `article_nameTranslations` | `string` | | ☐ | | | `article_purchaseGLAccount_archivedAt` | `datetime` | | ☐ | | | `article_purchaseGLAccount_code` | `string` | | ☐ | | | `article_purchaseGLAccount_createdAt` | `datetime` | | ☐ | | | `article_purchaseGLAccount_deletedAt` | `datetime` | | ☐ | | | `article_purchaseGLAccount_extraFields` | `string` | | ☐ | | | `article_purchaseGLAccount_id` | `string` | | ☐ | | | `article_purchaseGLAccount_lockedAt` | `datetime` | | ☐ | | | `article_purchaseGLAccount_name` | `string` | | ☐ | | | `article_purchaseGLAccount_updatedAt` | `datetime` | | ☐ | | | `article_purchaseGLAccountId` | `string` | | ☐ | | | `article_reservedStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_saleName` | `string` | | ☐ | | | `article_salePrice` | `decimal` | | ☐ | | | `article_salePriceStrategy` | `string` | | ☐ | | | `article_salesGLAccount_archivedAt` | `datetime` | | ☐ | | | `article_salesGLAccount_code` | `string` | | ☐ | | | `article_salesGLAccount_createdAt` | `datetime` | | ☐ | | | `article_salesGLAccount_deletedAt` | `datetime` | | ☐ | | | `article_salesGLAccount_extraFields` | `string` | | ☐ | | | `article_salesGLAccount_id` | `string` | | ☐ | | | `article_salesGLAccount_lockedAt` | `datetime` | | ☐ | | | `article_salesGLAccount_name` | `string` | | ☐ | | | `article_salesGLAccount_updatedAt` | `datetime` | | ☐ | | | `article_salesGLAccountId` | `string` | | ☐ | | | `article_stockArticle` | `boolean` | | ☐ | | | `article_stockPlace` | `string` | | ☐ | | | `article_targetStock` | `decimal` | | ☐ | | | `article_timeOperation` | `boolean` | | ☐ | | | `article_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_type` | `string` | | ☐ | | | `article_unitType` | `string` | | ☐ | | | `article_updatedAt` | `datetime` | | ☐ | | | `article_vatTariffId` | `string` | | ☐ | | | `article_wappy` | `boolean` | | ☐ | | | `articleId` | `string` | Item ID | ☐ | | | `breakMinutes` | `decimal` | Break (minutes) | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `costPrice` | `decimal` | Cost Price | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `employee__metadata_description` | `string` | | ☐ | | | `employee__metadata_href` | `string` | | ☐ | | | `employee__metadata_resource` | `string` | | ☐ | | | `employee__metadata_resourceTypeId` | `string` | | ☐ | | | `employee_archivedAt` | `datetime` | | ☐ | | | `employee_bankAccountNumber` | `string` | | ☐ | | | `employee_civilStatus` | `string` | | ☐ | | | `employee_collaborationEndDate` | `datetime` | | ☐ | | | `employee_collaborationStartDate` | `datetime` | | ☐ | | | `employee_competenceLevel` | `string` | | ☐ | | | `employee_costPerHour` | `decimal` | | ☐ | | | `employee_createdAt` | `datetime` | | ☐ | | | `employee_dateOfBirth` | `datetime` | | ☐ | | | `employee_defaultStockLocation_archivedAt` | `datetime` | | ☐ | | | `employee_defaultStockLocation_createdAt` | `datetime` | | ☐ | | | `employee_defaultStockLocation_deletedAt` | `datetime` | | ☐ | | | `employee_defaultStockLocation_extraFields` | `string` | | ☐ | | | `employee_defaultStockLocation_id` | `string` | | ☐ | | | `employee_defaultStockLocation_lockedAt` | `datetime` | | ☐ | | | `employee_defaultStockLocation_name` | `string` | | ☐ | | | `employee_defaultStockLocation_updatedAt` | `datetime` | | ☐ | | | `employee_defaultStockLocationId` | `string` | | ☐ | | | `employee_defaultTimeOperation_activityId` | `string` | | ☐ | | | `employee_defaultTimeOperation_archivedAt` | `datetime` | | ☐ | | | `employee_defaultTimeOperation_articleGroupId` | `string` | | ☐ | | | `employee_defaultTimeOperation_articleNumber` | `string` | | ☐ | | | `employee_defaultTimeOperation_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. | | `employee_defaultTimeOperation_backorderStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `employee_defaultTimeOperation_barcode` | `string` | | ☐ | | | `employee_defaultTimeOperation_brand` | `string` | | ☐ | | | `employee_defaultTimeOperation_calculationType` | `string` | | ☐ | | | `employee_defaultTimeOperation_costPrice` | `decimal` | | ☐ | | | `employee_defaultTimeOperation_costPriceStrategy` | `string` | | ☐ | | | `employee_defaultTimeOperation_createdAt` | `datetime` | | ☐ | | | `employee_defaultTimeOperation_deletedAt` | `datetime` | | ☐ | | | `employee_defaultTimeOperation_description` | `string` | | ☐ | | | `employee_defaultTimeOperation_descriptionTranslations` | `string` | | ☐ | | | `employee_defaultTimeOperation_extraFields` | `string` | | ☐ | | | `employee_defaultTimeOperation_id` | `string` | | ☐ | | | `employee_defaultTimeOperation_installation` | `boolean` | | ☐ | | | `employee_defaultTimeOperation_lockedAt` | `datetime` | | ☐ | | | `employee_defaultTimeOperation_margin` | `decimal` | | ☐ | | | `employee_defaultTimeOperation_minimumStock` | `decimal` | | ☐ | | | `employee_defaultTimeOperation_name` | `string` | | ☐ | | | `employee_defaultTimeOperation_nameTranslations` | `string` | | ☐ | | | `employee_defaultTimeOperation_purchaseGLAccountId` | `string` | | ☐ | | | `employee_defaultTimeOperation_reservedStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `employee_defaultTimeOperation_saleName` | `string` | | ☐ | | | `employee_defaultTimeOperation_salePrice` | `decimal` | | ☐ | | | `employee_defaultTimeOperation_salePriceStrategy` | `string` | | ☐ | | | `employee_defaultTimeOperation_salesGLAccountId` | `string` | | ☐ | | | `employee_defaultTimeOperation_stockArticle` | `boolean` | | ☐ | | | `employee_defaultTimeOperation_stockPlace` | `string` | | ☐ | | | `employee_defaultTimeOperation_targetStock` | `decimal` | | ☐ | | | `employee_defaultTimeOperation_timeOperation` | `boolean` | | ☐ | | | `employee_defaultTimeOperation_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `employee_defaultTimeOperation_type` | `string` | | ☐ | | | `employee_defaultTimeOperation_unitType` | `string` | | ☐ | | | `employee_defaultTimeOperation_updatedAt` | `datetime` | | ☐ | | | `employee_defaultTimeOperation_vatTariffId` | `string` | | ☐ | | | `employee_defaultTimeOperation_wappy` | `boolean` | | ☐ | | | `employee_defaultTimeOperationId` | `string` | | ☐ | | | `employee_deletedAt` | `datetime` | | ☐ | | | `employee_dimonaExpirationDate` | `datetime` | | ☐ | | | `employee_dimonaNumber` | `string` | | ☐ | | | `employee_distance` | `decimal` | | ☐ | | | `employee_domicileAddress_addressLine1` | `string` | | ☐ | | | `employee_domicileAddress_addressLine2` | `string` | | ☐ | | | `employee_domicileAddress_city` | `string` | | ☐ | | | `employee_domicileAddress_country` | `string` | | ☐ | | | `employee_domicileAddress_latitude` | `double` | | ☐ | | | `employee_domicileAddress_longitude` | `double` | | ☐ | | | `employee_domicileAddress_postalCode` | `string` | | ☐ | | | `employee_driverLicense` | `string` | | ☐ | | | `employee_email` | `string` | | ☐ | | | `employee_emergencyTel` | `string` | | ☐ | | | `employee_employeeRole_archivedAt` | `datetime` | | ☐ | | | `employee_employeeRole_createdAt` | `datetime` | | ☐ | | | `employee_employeeRole_deletedAt` | `datetime` | | ☐ | | | `employee_employeeRole_extraFields` | `string` | | ☐ | | | `employee_employeeRole_id` | `string` | | ☐ | | | `employee_employeeRole_lockedAt` | `datetime` | | ☐ | | | `employee_employeeRole_name` | `string` | | ☐ | | | `employee_employeeRole_updatedAt` | `datetime` | | ☐ | | | `employee_employeeRoleId` | `string` | | ☐ | | | `employee_employer_archivedAt` | `datetime` | | ☐ | | | `employee_employer_createdAt` | `datetime` | | ☐ | | | `employee_employer_deletedAt` | `datetime` | | ☐ | | | `employee_employer_email` | `string` | | ☐ | | | `employee_employer_extraFields` | `string` | | ☐ | | | `employee_employer_fax` | `string` | | ☐ | | | `employee_employer_generalLedgerAccountId` | `string` | | ☐ | | | `employee_employer_gsm` | `string` | | ☐ | | | `employee_employer_iban` | `string` | | ☐ | | | `employee_employer_id` | `string` | | ☐ | | | `employee_employer_invoiceRemarks` | `string` | | ☐ | | | `employee_employer_kvk` | `string` | | ☐ | | | `employee_employer_language` | `string` | | ☐ | | | `employee_employer_legalFormId` | `string` | | ☐ | | | `employee_employer_lockedAt` | `datetime` | | ☐ | | | `employee_employer_logicId` | `string` | | ☐ | | | `employee_employer_name` | `string` | | ☐ | | | `employee_employer_paymentConditionId` | `string` | | ☐ | | | `employee_employer_planningEmail` | `string` | | ☐ | | | `employee_employer_status` | `string` | | ☐ | | | `employee_employer_supplyOrderRemarks` | `string` | | ☐ | | | `employee_employer_tel` | `string` | | ☐ | | | `employee_employer_type` | `string` | | ☐ | | | `employee_employer_updatedAt` | `datetime` | | ☐ | | | `employee_employer_vatIdNumber` | `string` | | ☐ | | | `employee_employer_vatTariffId` | `string` | | ☐ | | | `employee_employer_website` | `string` | | ☐ | | | `employee_employerId` | `string` | | ☐ | | | `employee_extraFields` | `string` | | ☐ | | | `employee_grossSalary` | `decimal` | | ☐ | | | `employee_gsm` | `string` | | ☐ | | | `employee_id` | `string` | | ☐ | | | `employee_identityCardExpirationDate` | `datetime` | | ☐ | | | `employee_identityCardNumber` | `string` | | ☐ | | | `employee_image_archivedAt` | `datetime` | | ☐ | | | `employee_image_contentType` | `string` | | ☐ | | | `employee_image_createdAt` | `datetime` | | ☐ | | | `employee_image_deletedAt` | `datetime` | | ☐ | | | `employee_image_directory` | `boolean` | | ☐ | | | `employee_image_id` | `string` | | ☐ | | | `employee_image_lockedAt` | `datetime` | | ☐ | | | `employee_image_name` | `string` | | ☐ | | | `employee_image_parentId` | `string` | | ☐ | | | `employee_image_previewUrl` | `string` | | ☐ | | | `employee_image_size` | `int64` | | ☐ | | | `employee_image_updatedAt` | `datetime` | | ☐ | | | `employee_image_url` | `string` | | ☐ | | | `employee_independentRegistration` | `boolean` | | ☐ | | | `employee_limosaExpirationDate` | `datetime` | | ☐ | | | `employee_limosaNumber` | `string` | | ☐ | | | `employee_lockedAt` | `datetime` | | ☐ | | | `employee_name` | `string` | | ☐ | | | `employee_nationality` | `string` | | ☐ | | | `employee_nssoIdNumber` | `string` | | ☐ | | | `employee_nssoPayment` | `boolean` | | ☐ | | | `employee_nssoPaymentExpirationDate` | `datetime` | | ☐ | | | `employee_numberOfDependents` | `int32` | | ☐ | | | `employee_planningGroup` | `string` | | ☐ | | | `employee_position` | `string` | | ☐ | | | `employee_secondment` | `boolean` | | ☐ | | | `employee_status` | `string` | | ☐ | | | `employee_statute` | `string` | | ☐ | | | `employee_subType` | `string` | | ☐ | | | `employee_surname` | `string` | | ☐ | | | `employee_tel` | `string` | | ☐ | | | `employee_type` | `string` | | ☐ | | | `employee_updatedAt` | `datetime` | | ☐ | | | `employeeId` | `string` | Employee ID | ☐ | | | `endTime_hour` | `int32` | | ☐ | | | `endTime_minute` | `int32` | | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `hours` | `decimal` | Hours | ☐ | | | `id` | `string` | ID | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `remark` | `string` | Remark | ☐ | | | `salePrice` | `decimal` | Selling Price | ☐ | | | `startTime_hour` | `int32` | | ☐ | | | `startTime_minute` | `int32` | | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `workOrderId` | `string` | Work Order ID | ☐ | Only present when obtained via bulk endpoint |