# PlanningEmployeeSkillsByPlanningId: ROBAWS Planning Employee Skills by Planning 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: `PlanningItems` - Label: Planning Employee Skills by Planning ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | ## Columns The columns of the table `PlanningEmployeeSkillsByPlanningId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `address_addressLine1` | `string` | Address Line 1 | ☐ | | | `address_addressLine2` | `string` | Address Line 2 | ☐ | | | `address_city` | `string` | City | ☐ | | | `address_country` | `string` | Country | ☐ | | | `address_latitude` | `double` | | ☐ | | | `address_longitude` | `double` | | ☐ | | | `address_postalCode` | `string` | | ☐ | | | `archivedAt_1` | `datetime` | Archived at | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `bankAccountNumber` | `string` | Bank Account Number | ☐ | | | `basePlanningItem__metadata_description` | `string` | | ☐ | | | `basePlanningItem__metadata_href` | `string` | | ☐ | | | `basePlanningItem__metadata_resource` | `string` | | ☐ | | | `basePlanningItem__metadata_resourceTypeId` | `string` | | ☐ | | | `basePlanningItem_address_addressLine1` | `string` | | ☐ | | | `basePlanningItem_address_addressLine2` | `string` | | ☐ | | | `basePlanningItem_address_city` | `string` | | ☐ | | | `basePlanningItem_address_country` | `string` | | ☐ | | | `basePlanningItem_address_latitude` | `double` | | ☐ | | | `basePlanningItem_address_longitude` | `double` | | ☐ | | | `basePlanningItem_address_postalCode` | `string` | | ☐ | | | `basePlanningItem_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_basePlanningItemId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_clientId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_contactId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_description` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_endDate` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_executionPhaseDetail` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_executionPhaseId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_externalId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_extraFields` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_id` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_numberOfWorkOrders` | `int32` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `basePlanningItem_basePlanningItem_phaseId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_planningTypeId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_projectId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_recurrenceEndDate` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_recurrenceRule` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_recurring` | `boolean` | | ☐ | | | `basePlanningItem_basePlanningItem_recurringMode` | `string` | | ☐ | Deprecated, use recurrenceType instead. | | `basePlanningItem_basePlanningItem_startDate` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItem_summary` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_timeAndMaterial` | `boolean` | | ☐ | | | `basePlanningItem_basePlanningItem_transportId` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_unavailableReason` | `string` | | ☐ | | | `basePlanningItem_basePlanningItem_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_basePlanningItemId` | `string` | | ☐ | | | `basePlanningItem_client_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_client_assignedUserId` | `string` | | ☐ | | | `basePlanningItem_client_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_client_creditStatus` | `string` | | ☐ | | | `basePlanningItem_client_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_client_email` | `string` | | ☐ | | | `basePlanningItem_client_extraFields` | `string` | | ☐ | | | `basePlanningItem_client_fax` | `string` | | ☐ | | | `basePlanningItem_client_followUpDate` | `datetime` | | ☐ | | | `basePlanningItem_client_generalLedgerAccountId` | `string` | | ☐ | | | `basePlanningItem_client_gsm` | `string` | | ☐ | | | `basePlanningItem_client_id` | `string` | | ☐ | | | `basePlanningItem_client_invoiceEmail` | `string` | | ☐ | | | `basePlanningItem_client_language` | `string` | | ☐ | | | `basePlanningItem_client_legalFormId` | `string` | | ☐ | | | `basePlanningItem_client_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_client_name` | `string` | | ☐ | | | `basePlanningItem_client_paymentConditionId` | `string` | | ☐ | | | `basePlanningItem_client_priceGroupId` | `string` | | ☐ | | | `basePlanningItem_client_status` | `string` | | ☐ | | | `basePlanningItem_client_tel` | `string` | | ☐ | | | `basePlanningItem_client_title` | `string` | | ☐ | | | `basePlanningItem_client_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_client_vatIdNumber` | `string` | | ☐ | | | `basePlanningItem_client_vatTariffId` | `string` | | ☐ | | | `basePlanningItem_client_website` | `string` | | ☐ | | | `basePlanningItem_clientId` | `string` | | ☐ | | | `basePlanningItem_contact_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_contact_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_contact_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_contact_email` | `string` | | ☐ | | | `basePlanningItem_contact_extraFields` | `string` | | ☐ | | | `basePlanningItem_contact_gsm` | `string` | | ☐ | | | `basePlanningItem_contact_id` | `string` | | ☐ | | | `basePlanningItem_contact_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_contact_name` | `string` | | ☐ | | | `basePlanningItem_contact_position` | `string` | | ☐ | | | `basePlanningItem_contact_surname` | `string` | | ☐ | | | `basePlanningItem_contact_tel` | `string` | | ☐ | | | `basePlanningItem_contact_title` | `string` | | ☐ | | | `basePlanningItem_contact_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_contactId` | `string` | | ☐ | | | `basePlanningItem_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_description` | `string` | | ☐ | | | `basePlanningItem_endDate` | `datetime` | | ☐ | | | `basePlanningItem_executionPhase_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_executionPhase_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_executionPhase_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_executionPhase_extraFields` | `string` | | ☐ | | | `basePlanningItem_executionPhase_id` | `string` | | ☐ | | | `basePlanningItem_executionPhase_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_executionPhase_name` | `string` | | ☐ | | | `basePlanningItem_executionPhase_planningGroup` | `string` | | ☐ | | | `basePlanningItem_executionPhase_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_executionPhaseDetail` | `string` | | ☐ | | | `basePlanningItem_executionPhaseId` | `string` | | ☐ | | | `basePlanningItem_externalId` | `string` | | ☐ | | | `basePlanningItem_extraFields` | `string` | | ☐ | | | `basePlanningItem_id` | `string` | | ☐ | | | `basePlanningItem_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_numberOfWorkOrders` | `int32` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `basePlanningItem_phase_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_phase_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_phase_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_phase_endDate` | `datetime` | | ☐ | | | `basePlanningItem_phase_extraFields` | `string` | | ☐ | | | `basePlanningItem_phase_id` | `string` | | ☐ | | | `basePlanningItem_phase_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_phase_name` | `string` | | ☐ | | | `basePlanningItem_phase_offerId` | `string` | | ☐ | Only present when obtained via offer bulk endpoint | | `basePlanningItem_phase_projectId` | `string` | | ☐ | Only present when obtained via project bulk endpoint | | `basePlanningItem_phase_settlementId` | `string` | | ☐ | Only present when obtained via settlements bulk endpoint | | `basePlanningItem_phase_startDate` | `datetime` | | ☐ | | | `basePlanningItem_phase_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_phase_workingDays` | `int32` | | ☐ | | | `basePlanningItem_phaseId` | `string` | | ☐ | | | `basePlanningItem_planningType_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_planningType_color` | `string` | | ☐ | | | `basePlanningItem_planningType_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_planningType_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_planningType_extraFields` | `string` | | ☐ | | | `basePlanningItem_planningType_id` | `string` | | ☐ | | | `basePlanningItem_planningType_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_planningType_name` | `string` | | ☐ | | | `basePlanningItem_planningType_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_planningTypeId` | `string` | | ☐ | | | `basePlanningItem_project_archivedAt` | `datetime` | | ☐ | | | `basePlanningItem_project_checkInAtWork` | `string` | | ☐ | | | `basePlanningItem_project_clientContactId` | `string` | | ☐ | | | `basePlanningItem_project_clientId` | `string` | | ☐ | | | `basePlanningItem_project_clientReference` | `string` | | ☐ | | | `basePlanningItem_project_companyId` | `string` | | ☐ | | | `basePlanningItem_project_createdAt` | `datetime` | | ☐ | | | `basePlanningItem_project_date` | `datetime` | | ☐ | | | `basePlanningItem_project_deletedAt` | `datetime` | | ☐ | | | `basePlanningItem_project_distance` | `int32` | | ☐ | | | `basePlanningItem_project_endClientContactId` | `string` | | ☐ | | | `basePlanningItem_project_endClientId` | `string` | | ☐ | | | `basePlanningItem_project_extraFields` | `string` | | ☐ | | | `basePlanningItem_project_geofence` | `string` | | ☐ | | | `basePlanningItem_project_id` | `string` | | ☐ | | | `basePlanningItem_project_lockedAt` | `datetime` | | ☐ | | | `basePlanningItem_project_logicId` | `string` | | ☐ | | | `basePlanningItem_project_nssoDeclarationOfWorks` | `string` | | ☐ | | | `basePlanningItem_project_planningGroup` | `string` | | ☐ | | | `basePlanningItem_project_planningName` | `string` | | ☐ | | | `basePlanningItem_project_siteManagerId` | `string` | | ☐ | | | `basePlanningItem_project_siteNssoIdNumber` | `string` | | ☐ | | | `basePlanningItem_project_status` | `string` | | ☐ | | | `basePlanningItem_project_updatedAt` | `datetime` | | ☐ | | | `basePlanningItem_projectId` | `string` | | ☐ | | | `basePlanningItem_recurrenceEndDate` | `datetime` | | ☐ | | | `basePlanningItem_recurrenceRule` | `string` | | ☐ | | | `basePlanningItem_recurring` | `boolean` | | ☐ | | | `basePlanningItem_recurringMode` | `string` | | ☐ | Deprecated, use recurrenceType instead. | | `basePlanningItem_startDate` | `datetime` | | ☐ | | | `basePlanningItem_summary` | `string` | | ☐ | | | `basePlanningItem_timeAndMaterial` | `boolean` | | ☐ | | | `basePlanningItem_transportId` | `string` | | ☐ | | | `basePlanningItem_unavailableReason` | `string` | | ☐ | | | `basePlanningItem_updatedAt` | `datetime` | | ☐ | | | `basePlanningItemId` | `string` | Base Planning Item ID | ☐ | | | `c_metadata_description_1` | `string` | | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href_1` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource_1` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId_1` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `civilStatus` | `string` | Marital status | ☐ | | | `client__metadata_description` | `string` | | ☐ | | | `client__metadata_href` | `string` | | ☐ | | | `client__metadata_resource` | `string` | | ☐ | | | `client__metadata_resourceTypeId` | `string` | | ☐ | | | `client_address_addressLine1` | `string` | | ☐ | | | `client_address_addressLine2` | `string` | | ☐ | | | `client_address_city` | `string` | | ☐ | | | `client_address_country` | `string` | | ☐ | | | `client_address_latitude` | `double` | | ☐ | | | `client_address_longitude` | `double` | | ☐ | | | `client_address_postalCode` | `string` | | ☐ | | | `client_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_createdAt` | `datetime` | | ☐ | | | `client_assignedUser_deletedAt` | `datetime` | | ☐ | | | `client_assignedUser_email` | `string` | | ☐ | | | `client_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `client_assignedUser_extraFields` | `string` | | ☐ | | | `client_assignedUser_fullName` | `string` | | ☐ | | | `client_assignedUser_id` | `string` | | ☐ | | | `client_assignedUser_locale` | `string` | | ☐ | | | `client_assignedUser_locked` | `boolean` | | ☐ | | | `client_assignedUser_lockedAt` | `datetime` | | ☐ | | | `client_assignedUser_updatedAt` | `datetime` | | ☐ | | | `client_assignedUserId` | `string` | | ☐ | | | `client_createdAt` | `datetime` | | ☐ | | | `client_creditStatus` | `string` | | ☐ | | | `client_deletedAt` | `datetime` | | ☐ | | | `client_email` | `string` | Customer Email | ☐ | | | `client_extraFields` | `string` | | ☐ | | | `client_fax` | `string` | Customer Fax | ☐ | | | `client_followUpDate` | `datetime` | | ☐ | | | `client_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_code` | `string` | | ☐ | | | `client_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `client_generalLedgerAccount_id` | `string` | | ☐ | | | `client_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_name` | `string` | | ☐ | | | `client_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccountId` | `string` | | ☐ | | | `client_gsm` | `string` | Customer Mobile | ☐ | | | `client_id` | `string` | Client ID | ☐ | | | `client_invoiceAddress_addressLine1` | `string` | | ☐ | | | `client_invoiceAddress_addressLine2` | `string` | | ☐ | | | `client_invoiceAddress_city` | `string` | | ☐ | | | `client_invoiceAddress_country` | `string` | | ☐ | | | `client_invoiceAddress_latitude` | `double` | | ☐ | | | `client_invoiceAddress_longitude` | `double` | | ☐ | | | `client_invoiceAddress_postalCode` | `string` | | ☐ | | | `client_invoiceEmail` | `string` | | ☐ | | | `client_language` | `string` | | ☐ | | | `client_legalForm_archivedAt` | `datetime` | | ☐ | | | `client_legalForm_createdAt` | `datetime` | | ☐ | | | `client_legalForm_deletedAt` | `datetime` | | ☐ | | | `client_legalForm_extraFields` | `string` | | ☐ | | | `client_legalForm_id` | `string` | | ☐ | | | `client_legalForm_legalAbbreviation` | `string` | | ☐ | | | `client_legalForm_lockedAt` | `datetime` | | ☐ | | | `client_legalForm_name` | `string` | | ☐ | | | `client_legalForm_updatedAt` | `datetime` | | ☐ | | | `client_legalForm_vatLiable` | `boolean` | | ☐ | | | `client_legalFormId` | `string` | | ☐ | | | `client_lockedAt` | `datetime` | | ☐ | | | `client_name` | `string` | | ☐ | | | `client_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `client_paymentCondition_createdAt` | `datetime` | | ☐ | | | `client_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `client_paymentCondition_extraFields` | `string` | | ☐ | | | `client_paymentCondition_id` | `string` | | ☐ | | | `client_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `client_paymentCondition_name` | `string` | | ☐ | | | `client_paymentCondition_purchase` | `boolean` | | ☐ | | | `client_paymentCondition_sales` | `boolean` | | ☐ | | | `client_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `client_paymentConditionId` | `string` | | ☐ | | | `client_priceGroupId` | `string` | | ☐ | | | `client_status` | `string` | | ☐ | | | `client_statusDetails_color` | `string` | | ☐ | | | `client_statusDetails_name` | `string` | | ☐ | | | `client_tel` | `string` | | ☐ | | | `client_title` | `string` | | ☐ | | | `client_updatedAt` | `datetime` | | ☐ | | | `client_vatIdNumber` | `string` | | ☐ | | | `client_vatTariff_additionalMention` | `string` | | ☐ | | | `client_vatTariff_archivedAt` | `datetime` | | ☐ | | | `client_vatTariff_category` | `string` | | ☐ | | | `client_vatTariff_createdAt` | `datetime` | | ☐ | | | `client_vatTariff_deletedAt` | `datetime` | | ☐ | | | `client_vatTariff_description` | `string` | | ☐ | | | `client_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `client_vatTariff_extraFields` | `string` | | ☐ | | | `client_vatTariff_id` | `string` | | ☐ | | | `client_vatTariff_inclusive` | `boolean` | | ☐ | | | `client_vatTariff_lockedAt` | `datetime` | | ☐ | | | `client_vatTariff_name` | `string` | | ☐ | | | `client_vatTariff_percentage` | `decimal` | | ☐ | | | `client_vatTariff_updatedAt` | `datetime` | | ☐ | | | `client_vatTariffId` | `string` | | ☐ | | | `client_website` | `string` | | ☐ | | | `clientId` | `string` | Customer ID | ☐ | | | `collaborationEndDate` | `datetime` | Cooperation end date | ☐ | | | `collaborationStartDate` | `datetime` | Cooperation start date | ☐ | | | `competenceLevel` | `string` | Competence Level | ☐ | | | `contact__metadata_description` | `string` | | ☐ | | | `contact__metadata_href` | `string` | | ☐ | | | `contact__metadata_resource` | `string` | | ☐ | | | `contact__metadata_resourceTypeId` | `string` | | ☐ | | | `contact_archivedAt` | `datetime` | | ☐ | | | `contact_createdAt` | `datetime` | | ☐ | | | `contact_deletedAt` | `datetime` | | ☐ | | | `contact_email` | `string` | | ☐ | | | `contact_extraFields` | `string` | | ☐ | | | `contact_gsm` | `string` | | ☐ | | | `contact_id` | `string` | | ☐ | | | `contact_lockedAt` | `datetime` | | ☐ | | | `contact_name` | `string` | | ☐ | | | `contact_position` | `string` | | ☐ | | | `contact_surname` | `string` | | ☐ | | | `contact_tel` | `string` | | ☐ | | | `contact_title` | `string` | | ☐ | | | `contact_updatedAt` | `datetime` | | ☐ | | | `contactId` | `string` | Contact ID | ☐ | | | `costPerHour` | `decimal` | Cost per Hour | ☐ | | | `createdAt_1` | `datetime` | Created at | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `dateOfBirth` | `datetime` | Date of Birth | ☐ | | | `defaultStockLocation_archivedAt` | `datetime` | | ☐ | | | `defaultStockLocation_createdAt` | `datetime` | | ☐ | | | `defaultStockLocation_deletedAt` | `datetime` | | ☐ | | | `defaultStockLocation_extraFields` | `string` | | ☐ | | | `defaultStockLocation_id` | `string` | | ☐ | | | `defaultStockLocation_lockedAt` | `datetime` | | ☐ | | | `defaultStockLocation_name` | `string` | | ☐ | | | `defaultStockLocation_updatedAt` | `datetime` | | ☐ | | | `defaultStockLocationId` | `string` | Default stock location ID | ☐ | | | `defaultTimeOperation_activityId` | `string` | | ☐ | | | `defaultTimeOperation_archivedAt` | `datetime` | | ☐ | | | `defaultTimeOperation_articleGroupId` | `string` | | ☐ | | | `defaultTimeOperation_articleNumber` | `string` | | ☐ | | | `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. | | `defaultTimeOperation_backorderStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `defaultTimeOperation_barcode` | `string` | | ☐ | | | `defaultTimeOperation_brand` | `string` | | ☐ | | | `defaultTimeOperation_calculationType` | `string` | | ☐ | | | `defaultTimeOperation_costPrice` | `decimal` | | ☐ | | | `defaultTimeOperation_costPriceStrategy` | `string` | | ☐ | | | `defaultTimeOperation_createdAt` | `datetime` | | ☐ | | | `defaultTimeOperation_deletedAt` | `datetime` | | ☐ | | | `defaultTimeOperation_description` | `string` | | ☐ | | | `defaultTimeOperation_descriptionTranslations` | `string` | | ☐ | | | `defaultTimeOperation_extraFields` | `string` | | ☐ | | | `defaultTimeOperation_id` | `string` | | ☐ | | | `defaultTimeOperation_installation` | `boolean` | | ☐ | | | `defaultTimeOperation_lockedAt` | `datetime` | | ☐ | | | `defaultTimeOperation_margin` | `decimal` | | ☐ | | | `defaultTimeOperation_minimumStock` | `decimal` | | ☐ | | | `defaultTimeOperation_name` | `string` | | ☐ | | | `defaultTimeOperation_nameTranslations` | `string` | | ☐ | | | `defaultTimeOperation_purchaseGLAccountId` | `string` | | ☐ | | | `defaultTimeOperation_reservedStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `defaultTimeOperation_saleName` | `string` | | ☐ | | | `defaultTimeOperation_salePrice` | `decimal` | | ☐ | | | `defaultTimeOperation_salePriceStrategy` | `string` | | ☐ | | | `defaultTimeOperation_salesGLAccountId` | `string` | | ☐ | | | `defaultTimeOperation_stockArticle` | `boolean` | | ☐ | | | `defaultTimeOperation_stockPlace` | `string` | | ☐ | | | `defaultTimeOperation_targetStock` | `decimal` | | ☐ | | | `defaultTimeOperation_timeOperation` | `boolean` | | ☐ | | | `defaultTimeOperation_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `defaultTimeOperation_type` | `string` | | ☐ | | | `defaultTimeOperation_unitType` | `string` | | ☐ | | | `defaultTimeOperation_updatedAt` | `datetime` | | ☐ | | | `defaultTimeOperation_vatTariffId` | `string` | | ☐ | | | `defaultTimeOperation_wappy` | `boolean` | | ☐ | | | `defaultTimeOperationId` | `string` | Default Time Operation ID | ☐ | | | `deletedAt_1` | `datetime` | Deleted at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `dimonaExpirationDate` | `datetime` | | ☐ | | | `dimonaNumber` | `string` | | ☐ | | | `distance` | `decimal` | Distance | ☐ | | | `domicileAddress_addressLine1` | `string` | Address Line 1 | ☐ | | | `domicileAddress_addressLine2` | `string` | Address Line 2 | ☐ | | | `domicileAddress_city` | `string` | | ☐ | | | `domicileAddress_country` | `string` | | ☐ | | | `domicileAddress_latitude` | `double` | | ☐ | | | `domicileAddress_longitude` | `double` | | ☐ | | | `domicileAddress_postalCode` | `string` | | ☐ | | | `driverLicense` | `string` | Driving Licence | ☐ | | | `email` | `string` | E-mail | ☐ | | | `emergencyTel` | `string` | In Case of Emergency (phone) | ☐ | | | `employeeRole_archivedAt` | `datetime` | | ☐ | | | `employeeRole_createdAt` | `datetime` | | ☐ | | | `employeeRole_deletedAt` | `datetime` | | ☐ | | | `employeeRole_extraFields` | `string` | | ☐ | | | `employeeRole_id` | `string` | | ☐ | | | `employeeRole_lockedAt` | `datetime` | | ☐ | | | `employeeRole_name` | `string` | | ☐ | | | `employeeRole_updatedAt` | `datetime` | | ☐ | | | `employeeRoleId` | `string` | Employee Role ID | ☐ | | | `employer_archivedAt` | `datetime` | | ☐ | | | `employer_createdAt` | `datetime` | | ☐ | | | `employer_deletedAt` | `datetime` | | ☐ | | | `employer_email` | `string` | | ☐ | | | `employer_extraFields` | `string` | | ☐ | | | `employer_fax` | `string` | | ☐ | | | `employer_generalLedgerAccountId` | `string` | | ☐ | | | `employer_gsm` | `string` | | ☐ | | | `employer_iban` | `string` | | ☐ | | | `employer_id` | `string` | | ☐ | | | `employer_invoiceRemarks` | `string` | | ☐ | | | `employer_kvk` | `string` | | ☐ | | | `employer_language` | `string` | | ☐ | | | `employer_legalFormId` | `string` | | ☐ | | | `employer_lockedAt` | `datetime` | | ☐ | | | `employer_logicId` | `string` | | ☐ | | | `employer_name` | `string` | | ☐ | | | `employer_paymentConditionId` | `string` | | ☐ | | | `employer_planningEmail` | `string` | | ☐ | | | `employer_status` | `string` | | ☐ | | | `employer_supplyOrderRemarks` | `string` | | ☐ | | | `employer_tel` | `string` | | ☐ | | | `employer_type` | `string` | | ☐ | | | `employer_updatedAt` | `datetime` | | ☐ | | | `employer_vatIdNumber` | `string` | | ☐ | | | `employer_vatTariffId` | `string` | | ☐ | | | `employer_website` | `string` | | ☐ | | | `employerId` | `string` | Employer ID | ☐ | | | `endDate` | `datetime` | End Date | ☐ | | | `executionPhase__metadata_description` | `string` | | ☐ | | | `executionPhase__metadata_href` | `string` | | ☐ | | | `executionPhase__metadata_resource` | `string` | | ☐ | | | `executionPhase__metadata_resourceTypeId` | `string` | | ☐ | | | `executionPhase_archivedAt` | `datetime` | | ☐ | | | `executionPhase_createdAt` | `datetime` | | ☐ | | | `executionPhase_deletedAt` | `datetime` | | ☐ | | | `executionPhase_extraFields` | `string` | | ☐ | | | `executionPhase_id` | `string` | | ☐ | | | `executionPhase_lockedAt` | `datetime` | | ☐ | | | `executionPhase_name` | `string` | | ☐ | | | `executionPhase_planningGroup` | `string` | | ☐ | | | `executionPhase_updatedAt` | `datetime` | | ☐ | | | `executionPhaseDetail` | `string` | Execution Phase Detail | ☐ | | | `executionPhaseId` | `string` | Execution Phase ID | ☐ | | | `externalId` | `string` | External ID | ☐ | | | `extraFields_1` | `string` | Extra fields | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `grossSalary` | `decimal` | Gross Salary | ☐ | | | `gsm` | `string` | Mobile | ☐ | | | `id_1` | `string` | ID | ☐ | | | `id` | `string` | ID | ☐ | | | `identityCardExpirationDate` | `datetime` | Identity Card Expiry Date | ☐ | | | `identityCardNumber` | `string` | Identity Card Number | ☐ | | | `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` | | ☐ | | | `independentRegistration` | `boolean` | Independent Registration | ☐ | | | `limosaExpirationDate` | `datetime` | | ☐ | | | `limosaNumber` | `string` | | ☐ | | | `lockedAt_1` | `datetime` | Closed at | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `name` | `string` | Name | ☐ | | | `nationality` | `string` | Nationality | ☐ | | | `nssoIdNumber` | `string` | NSSO ID Number | ☐ | | | `nssoPayment` | `boolean` | NSSO Payment | ☐ | | | `nssoPaymentExpirationDate` | `datetime` | NSSO Payment Expiry Date | ☐ | | | `numberOfDependents` | `int32` | Number of Dependants | ☐ | | | `numberOfWorkOrders` | `int32` | Number of Work Orders | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `phase__metadata_description` | `string` | | ☐ | | | `phase__metadata_href` | `string` | | ☐ | | | `phase__metadata_resource` | `string` | | ☐ | | | `phase__metadata_resourceTypeId` | `string` | | ☐ | | | `phase_archivedAt` | `datetime` | | ☐ | | | `phase_createdAt` | `datetime` | | ☐ | | | `phase_deletedAt` | `datetime` | | ☐ | | | `phase_endDate` | `datetime` | | ☐ | | | `phase_extraFields` | `string` | | ☐ | | | `phase_id` | `string` | | ☐ | | | `phase_lockedAt` | `datetime` | | ☐ | | | `phase_name` | `string` | | ☐ | | | `phase_offerId` | `string` | | ☐ | Only present when obtained via offer bulk endpoint | | `phase_projectId` | `string` | | ☐ | Only present when obtained via project bulk endpoint | | `phase_settlementId` | `string` | | ☐ | Only present when obtained via settlements bulk endpoint | | `phase_startDate` | `datetime` | | ☐ | | | `phase_updatedAt` | `datetime` | | ☐ | | | `phase_workingDays` | `int32` | | ☐ | | | `phaseId` | `string` | Phase ID | ☐ | | | `planningGroup` | `string` | Planning Group | ☐ | | | `planningType__metadata_description` | `string` | | ☐ | | | `planningType__metadata_href` | `string` | | ☐ | | | `planningType__metadata_resource` | `string` | | ☐ | | | `planningType__metadata_resourceTypeId` | `string` | | ☐ | | | `planningType_archivedAt` | `datetime` | | ☐ | | | `planningType_color` | `string` | | ☐ | | | `planningType_createdAt` | `datetime` | | ☐ | | | `planningType_deletedAt` | `datetime` | | ☐ | | | `planningType_extraFields` | `string` | | ☐ | | | `planningType_id` | `string` | | ☐ | | | `planningType_lockedAt` | `datetime` | | ☐ | | | `planningType_name` | `string` | | ☐ | | | `planningType_updatedAt` | `datetime` | | ☐ | | | `planningTypeId` | `string` | Planning Type ID | ☐ | | | `position` | `string` | Position | ☐ | | | `project__metadata_description` | `string` | | ☐ | | | `project__metadata_href` | `string` | | ☐ | | | `project__metadata_resource` | `string` | | ☐ | | | `project__metadata_resourceTypeId` | `string` | | ☐ | | | `project_archivedAt` | `datetime` | | ☐ | | | `project_checkInAtWork` | `string` | | ☐ | | | `project_client_archivedAt` | `datetime` | | ☐ | | | `project_client_assignedUserId` | `string` | | ☐ | | | `project_client_createdAt` | `datetime` | | ☐ | | | `project_client_creditStatus` | `string` | | ☐ | | | `project_client_deletedAt` | `datetime` | | ☐ | | | `project_client_email` | `string` | | ☐ | | | `project_client_extraFields` | `string` | | ☐ | | | `project_client_fax` | `string` | | ☐ | | | `project_client_followUpDate` | `datetime` | | ☐ | | | `project_client_generalLedgerAccountId` | `string` | | ☐ | | | `project_client_gsm` | `string` | | ☐ | | | `project_client_id` | `string` | | ☐ | | | `project_client_invoiceEmail` | `string` | | ☐ | | | `project_client_language` | `string` | | ☐ | | | `project_client_legalFormId` | `string` | | ☐ | | | `project_client_lockedAt` | `datetime` | | ☐ | | | `project_client_name` | `string` | | ☐ | | | `project_client_paymentConditionId` | `string` | | ☐ | | | `project_client_priceGroupId` | `string` | | ☐ | | | `project_client_status` | `string` | | ☐ | | | `project_client_tel` | `string` | | ☐ | | | `project_client_title` | `string` | | ☐ | | | `project_client_updatedAt` | `datetime` | | ☐ | | | `project_client_vatIdNumber` | `string` | | ☐ | | | `project_client_vatTariffId` | `string` | | ☐ | | | `project_client_website` | `string` | | ☐ | | | `project_clientContact_archivedAt` | `datetime` | | ☐ | | | `project_clientContact_createdAt` | `datetime` | | ☐ | | | `project_clientContact_deletedAt` | `datetime` | | ☐ | | | `project_clientContact_email` | `string` | | ☐ | | | `project_clientContact_extraFields` | `string` | | ☐ | | | `project_clientContact_gsm` | `string` | | ☐ | | | `project_clientContact_id` | `string` | | ☐ | | | `project_clientContact_lockedAt` | `datetime` | | ☐ | | | `project_clientContact_name` | `string` | | ☐ | | | `project_clientContact_position` | `string` | | ☐ | | | `project_clientContact_surname` | `string` | | ☐ | | | `project_clientContact_tel` | `string` | | ☐ | | | `project_clientContact_title` | `string` | | ☐ | | | `project_clientContact_updatedAt` | `datetime` | | ☐ | | | `project_clientContactId` | `string` | | ☐ | | | `project_clientId` | `string` | | ☐ | | | `project_clientReference` | `string` | | ☐ | | | `project_company_archivedAt` | `datetime` | | ☐ | | | `project_company_createdAt` | `datetime` | | ☐ | | | `project_company_deletedAt` | `datetime` | | ☐ | | | `project_company_extraFields` | `string` | | ☐ | | | `project_company_id` | `string` | | ☐ | | | `project_company_lockedAt` | `datetime` | | ☐ | | | `project_company_name` | `string` | | ☐ | | | `project_company_updatedAt` | `datetime` | | ☐ | | | `project_companyId` | `string` | | ☐ | | | `project_createdAt` | `datetime` | | ☐ | | | `project_date` | `datetime` | | ☐ | | | `project_deletedAt` | `datetime` | | ☐ | | | `project_distance` | `int32` | | ☐ | | | `project_endClient_archivedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUserId` | `string` | | ☐ | | | `project_endClient_createdAt` | `datetime` | | ☐ | | | `project_endClient_creditStatus` | `string` | | ☐ | | | `project_endClient_deletedAt` | `datetime` | | ☐ | | | `project_endClient_email` | `string` | | ☐ | | | `project_endClient_extraFields` | `string` | | ☐ | | | `project_endClient_fax` | `string` | | ☐ | | | `project_endClient_followUpDate` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccountId` | `string` | | ☐ | | | `project_endClient_gsm` | `string` | | ☐ | | | `project_endClient_id` | `string` | | ☐ | | | `project_endClient_invoiceEmail` | `string` | | ☐ | | | `project_endClient_language` | `string` | | ☐ | | | `project_endClient_legalFormId` | `string` | | ☐ | | | `project_endClient_lockedAt` | `datetime` | | ☐ | | | `project_endClient_name` | `string` | | ☐ | | | `project_endClient_paymentConditionId` | `string` | | ☐ | | | `project_endClient_priceGroupId` | `string` | | ☐ | | | `project_endClient_status` | `string` | | ☐ | | | `project_endClient_tel` | `string` | | ☐ | | | `project_endClient_title` | `string` | | ☐ | | | `project_endClient_updatedAt` | `datetime` | | ☐ | | | `project_endClient_vatIdNumber` | `string` | | ☐ | | | `project_endClient_vatTariffId` | `string` | | ☐ | | | `project_endClient_website` | `string` | | ☐ | | | `project_endClientContact_archivedAt` | `datetime` | | ☐ | | | `project_endClientContact_createdAt` | `datetime` | | ☐ | | | `project_endClientContact_deletedAt` | `datetime` | | ☐ | | | `project_endClientContact_email` | `string` | | ☐ | | | `project_endClientContact_extraFields` | `string` | | ☐ | | | `project_endClientContact_gsm` | `string` | | ☐ | | | `project_endClientContact_id` | `string` | | ☐ | | | `project_endClientContact_lockedAt` | `datetime` | | ☐ | | | `project_endClientContact_name` | `string` | | ☐ | | | `project_endClientContact_position` | `string` | | ☐ | | | `project_endClientContact_surname` | `string` | | ☐ | | | `project_endClientContact_tel` | `string` | | ☐ | | | `project_endClientContact_title` | `string` | | ☐ | | | `project_endClientContact_updatedAt` | `datetime` | | ☐ | | | `project_endClientContactId` | `string` | | ☐ | | | `project_endClientId` | `string` | | ☐ | | | `project_extraFields` | `string` | | ☐ | | | `project_geofence` | `string` | | ☐ | | | `project_id` | `string` | | ☐ | | | `project_lockedAt` | `datetime` | | ☐ | | | `project_logicId` | `string` | | ☐ | | | `project_nssoDeclarationOfWorks` | `string` | | ☐ | | | `project_planningGroup` | `string` | | ☐ | | | `project_planningName` | `string` | | ☐ | | | `project_siteAddress_addressLine1` | `string` | | ☐ | | | `project_siteAddress_addressLine2` | `string` | | ☐ | | | `project_siteAddress_city` | `string` | | ☐ | | | `project_siteAddress_country` | `string` | | ☐ | | | `project_siteAddress_latitude` | `double` | | ☐ | | | `project_siteAddress_longitude` | `double` | | ☐ | | | `project_siteAddress_postalCode` | `string` | | ☐ | | | `project_siteManager_archivedAt` | `datetime` | | ☐ | | | `project_siteManager_createdAt` | `datetime` | | ☐ | | | `project_siteManager_deletedAt` | `datetime` | | ☐ | | | `project_siteManager_email` | `string` | | ☐ | | | `project_siteManager_emailAccountActive` | `boolean` | | ☐ | | | `project_siteManager_extraFields` | `string` | | ☐ | | | `project_siteManager_fullName` | `string` | | ☐ | | | `project_siteManager_id` | `string` | | ☐ | | | `project_siteManager_locale` | `string` | | ☐ | | | `project_siteManager_locked` | `boolean` | | ☐ | | | `project_siteManager_lockedAt` | `datetime` | | ☐ | | | `project_siteManager_updatedAt` | `datetime` | | ☐ | | | `project_siteManagerId` | `string` | | ☐ | | | `project_siteNssoIdNumber` | `string` | | ☐ | | | `project_status` | `string` | | ☐ | | | `project_statusDetails_color` | `string` | | ☐ | | | `project_statusDetails_name` | `string` | | ☐ | | | `project_updatedAt` | `datetime` | | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `recurrenceEndDate` | `datetime` | Recurrence End Date | ☐ | | | `recurrenceRule` | `string` | Recurrence Rule | ☐ | | | `recurring` | `boolean` | Recurring | ☐ | | | `recurringMode` | `string` | Recurrence Mode | ☐ | Deprecated, use recurrenceType instead. | | `secondment` | `boolean` | Secondment | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | | | `status` | `string` | Status | ☐ | | | `statute` | `string` | Status | ☐ | | | `subType` | `string` | Sub-type | ☐ | | | `summary` | `string` | Summary | ☐ | | | `surname` | `string` | Last Name | ☐ | | | `tel` | `string` | Phone | ☐ | | | `TEXT` | `string` | Text | ☐ | | | `timeAndMaterial` | `boolean` | Time and Materials | ☐ | | | `transportId` | `string` | Transport ID | ☐ | | | `type` | `string` | Type | ☐ | | | `unavailableReason` | `string` | Unavailable Reason | ☐ | | | `updatedAt_1` | `datetime` | Updated On | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |