# InstallationsById: ROBAWS Installation by 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: `Installations` - Label: Installation by ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | ## Columns The columns of the table `InstallationsById` 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 | ☐ | | | `assignedClient__metadata_description` | `string` | | ☐ | | | `assignedClient__metadata_href` | `string` | | ☐ | | | `assignedClient__metadata_resource` | `string` | | ☐ | | | `assignedClient__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedClient_address_addressLine1` | `string` | | ☐ | | | `assignedClient_address_addressLine2` | `string` | | ☐ | | | `assignedClient_address_city` | `string` | | ☐ | | | `assignedClient_address_country` | `string` | | ☐ | | | `assignedClient_address_latitude` | `double` | | ☐ | | | `assignedClient_address_longitude` | `double` | | ☐ | | | `assignedClient_address_postalCode` | `string` | | ☐ | | | `assignedClient_archivedAt` | `datetime` | | ☐ | | | `assignedClient_assignedUser_archivedAt` | `datetime` | | ☐ | | | `assignedClient_assignedUser_createdAt` | `datetime` | | ☐ | | | `assignedClient_assignedUser_deletedAt` | `datetime` | | ☐ | | | `assignedClient_assignedUser_email` | `string` | | ☐ | | | `assignedClient_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `assignedClient_assignedUser_extraFields` | `string` | | ☐ | | | `assignedClient_assignedUser_fullName` | `string` | | ☐ | | | `assignedClient_assignedUser_id` | `string` | | ☐ | | | `assignedClient_assignedUser_locale` | `string` | | ☐ | | | `assignedClient_assignedUser_locked` | `boolean` | | ☐ | | | `assignedClient_assignedUser_lockedAt` | `datetime` | | ☐ | | | `assignedClient_assignedUser_updatedAt` | `datetime` | | ☐ | | | `assignedClient_assignedUserId` | `string` | | ☐ | | | `assignedClient_createdAt` | `datetime` | | ☐ | | | `assignedClient_creditStatus` | `string` | | ☐ | | | `assignedClient_deletedAt` | `datetime` | | ☐ | | | `assignedClient_email` | `string` | | ☐ | | | `assignedClient_extraFields` | `string` | | ☐ | | | `assignedClient_fax` | `string` | | ☐ | | | `assignedClient_followUpDate` | `datetime` | | ☐ | | | `assignedClient_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `assignedClient_generalLedgerAccount_code` | `string` | | ☐ | | | `assignedClient_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `assignedClient_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `assignedClient_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `assignedClient_generalLedgerAccount_id` | `string` | | ☐ | | | `assignedClient_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `assignedClient_generalLedgerAccount_name` | `string` | | ☐ | | | `assignedClient_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `assignedClient_generalLedgerAccountId` | `string` | | ☐ | | | `assignedClient_gsm` | `string` | | ☐ | | | `assignedClient_id` | `string` | | ☐ | | | `assignedClient_invoiceAddress_addressLine1` | `string` | | ☐ | | | `assignedClient_invoiceAddress_addressLine2` | `string` | | ☐ | | | `assignedClient_invoiceAddress_city` | `string` | | ☐ | | | `assignedClient_invoiceAddress_country` | `string` | | ☐ | | | `assignedClient_invoiceAddress_latitude` | `double` | | ☐ | | | `assignedClient_invoiceAddress_longitude` | `double` | | ☐ | | | `assignedClient_invoiceAddress_postalCode` | `string` | | ☐ | | | `assignedClient_invoiceEmail` | `string` | | ☐ | | | `assignedClient_language` | `string` | | ☐ | | | `assignedClient_legalForm_archivedAt` | `datetime` | | ☐ | | | `assignedClient_legalForm_createdAt` | `datetime` | | ☐ | | | `assignedClient_legalForm_deletedAt` | `datetime` | | ☐ | | | `assignedClient_legalForm_extraFields` | `string` | | ☐ | | | `assignedClient_legalForm_id` | `string` | | ☐ | | | `assignedClient_legalForm_legalAbbreviation` | `string` | | ☐ | | | `assignedClient_legalForm_lockedAt` | `datetime` | | ☐ | | | `assignedClient_legalForm_name` | `string` | | ☐ | | | `assignedClient_legalForm_updatedAt` | `datetime` | | ☐ | | | `assignedClient_legalForm_vatLiable` | `boolean` | | ☐ | | | `assignedClient_legalFormId` | `string` | | ☐ | | | `assignedClient_lockedAt` | `datetime` | | ☐ | | | `assignedClient_name` | `string` | | ☐ | | | `assignedClient_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `assignedClient_paymentCondition_createdAt` | `datetime` | | ☐ | | | `assignedClient_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `assignedClient_paymentCondition_extraFields` | `string` | | ☐ | | | `assignedClient_paymentCondition_id` | `string` | | ☐ | | | `assignedClient_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `assignedClient_paymentCondition_name` | `string` | | ☐ | | | `assignedClient_paymentCondition_purchase` | `boolean` | | ☐ | | | `assignedClient_paymentCondition_sales` | `boolean` | | ☐ | | | `assignedClient_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `assignedClient_paymentConditionId` | `string` | | ☐ | | | `assignedClient_priceGroupId` | `string` | | ☐ | | | `assignedClient_status` | `string` | | ☐ | | | `assignedClient_statusDetails_color` | `string` | | ☐ | | | `assignedClient_statusDetails_name` | `string` | | ☐ | | | `assignedClient_tel` | `string` | | ☐ | | | `assignedClient_title` | `string` | | ☐ | | | `assignedClient_updatedAt` | `datetime` | | ☐ | | | `assignedClient_vatIdNumber` | `string` | | ☐ | | | `assignedClient_vatTariff_additionalMention` | `string` | | ☐ | | | `assignedClient_vatTariff_archivedAt` | `datetime` | | ☐ | | | `assignedClient_vatTariff_category` | `string` | | ☐ | | | `assignedClient_vatTariff_createdAt` | `datetime` | | ☐ | | | `assignedClient_vatTariff_deletedAt` | `datetime` | | ☐ | | | `assignedClient_vatTariff_description` | `string` | | ☐ | | | `assignedClient_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `assignedClient_vatTariff_extraFields` | `string` | | ☐ | | | `assignedClient_vatTariff_id` | `string` | | ☐ | | | `assignedClient_vatTariff_inclusive` | `boolean` | | ☐ | | | `assignedClient_vatTariff_lockedAt` | `datetime` | | ☐ | | | `assignedClient_vatTariff_name` | `string` | | ☐ | | | `assignedClient_vatTariff_percentage` | `decimal` | | ☐ | | | `assignedClient_vatTariff_updatedAt` | `datetime` | | ☐ | | | `assignedClient_vatTariffId` | `string` | | ☐ | | | `assignedClient_website` | `string` | | ☐ | | | `assignedClientId` | `string` | Assigned Customer ID | ☐ | | | `assignedEmployee__metadata_description` | `string` | | ☐ | | | `assignedEmployee__metadata_href` | `string` | | ☐ | | | `assignedEmployee__metadata_resource` | `string` | | ☐ | | | `assignedEmployee__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedEmployee_archivedAt` | `datetime` | | ☐ | | | `assignedEmployee_bankAccountNumber` | `string` | | ☐ | | | `assignedEmployee_civilStatus` | `string` | | ☐ | | | `assignedEmployee_collaborationEndDate` | `datetime` | | ☐ | | | `assignedEmployee_collaborationStartDate` | `datetime` | | ☐ | | | `assignedEmployee_competenceLevel` | `string` | | ☐ | | | `assignedEmployee_costPerHour` | `decimal` | | ☐ | | | `assignedEmployee_createdAt` | `datetime` | | ☐ | | | `assignedEmployee_dateOfBirth` | `datetime` | | ☐ | | | `assignedEmployee_defaultStockLocation_archivedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultStockLocation_createdAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultStockLocation_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultStockLocation_extraFields` | `string` | | ☐ | | | `assignedEmployee_defaultStockLocation_id` | `string` | | ☐ | | | `assignedEmployee_defaultStockLocation_lockedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultStockLocation_name` | `string` | | ☐ | | | `assignedEmployee_defaultStockLocation_updatedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultStockLocationId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_activityId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_archivedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultTimeOperation_articleGroupId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_articleNumber` | `string` | | ☐ | | | `assignedEmployee_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. | | `assignedEmployee_defaultTimeOperation_backorderStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `assignedEmployee_defaultTimeOperation_barcode` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_brand` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_calculationType` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_costPrice` | `decimal` | | ☐ | | | `assignedEmployee_defaultTimeOperation_costPriceStrategy` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_createdAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultTimeOperation_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultTimeOperation_description` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_descriptionTranslations` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_extraFields` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_id` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_installation` | `boolean` | | ☐ | | | `assignedEmployee_defaultTimeOperation_lockedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultTimeOperation_margin` | `decimal` | | ☐ | | | `assignedEmployee_defaultTimeOperation_minimumStock` | `decimal` | | ☐ | | | `assignedEmployee_defaultTimeOperation_name` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_nameTranslations` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_purchaseGLAccountId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_reservedStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `assignedEmployee_defaultTimeOperation_saleName` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_salePrice` | `decimal` | | ☐ | | | `assignedEmployee_defaultTimeOperation_salePriceStrategy` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_salesGLAccountId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_stockArticle` | `boolean` | | ☐ | | | `assignedEmployee_defaultTimeOperation_stockPlace` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_targetStock` | `decimal` | | ☐ | | | `assignedEmployee_defaultTimeOperation_timeOperation` | `boolean` | | ☐ | | | `assignedEmployee_defaultTimeOperation_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `assignedEmployee_defaultTimeOperation_type` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_unitType` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_updatedAt` | `datetime` | | ☐ | | | `assignedEmployee_defaultTimeOperation_vatTariffId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperation_wappy` | `boolean` | | ☐ | | | `assignedEmployee_defaultTimeOperationId` | `string` | | ☐ | | | `assignedEmployee_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_dimonaExpirationDate` | `datetime` | | ☐ | | | `assignedEmployee_dimonaNumber` | `string` | | ☐ | | | `assignedEmployee_distance` | `decimal` | | ☐ | | | `assignedEmployee_domicileAddress_addressLine1` | `string` | | ☐ | | | `assignedEmployee_domicileAddress_addressLine2` | `string` | | ☐ | | | `assignedEmployee_domicileAddress_city` | `string` | | ☐ | | | `assignedEmployee_domicileAddress_country` | `string` | | ☐ | | | `assignedEmployee_domicileAddress_latitude` | `double` | | ☐ | | | `assignedEmployee_domicileAddress_longitude` | `double` | | ☐ | | | `assignedEmployee_domicileAddress_postalCode` | `string` | | ☐ | | | `assignedEmployee_driverLicense` | `string` | | ☐ | | | `assignedEmployee_email` | `string` | | ☐ | | | `assignedEmployee_emergencyTel` | `string` | | ☐ | | | `assignedEmployee_employeeRole_archivedAt` | `datetime` | | ☐ | | | `assignedEmployee_employeeRole_createdAt` | `datetime` | | ☐ | | | `assignedEmployee_employeeRole_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_employeeRole_extraFields` | `string` | | ☐ | | | `assignedEmployee_employeeRole_id` | `string` | | ☐ | | | `assignedEmployee_employeeRole_lockedAt` | `datetime` | | ☐ | | | `assignedEmployee_employeeRole_name` | `string` | | ☐ | | | `assignedEmployee_employeeRole_updatedAt` | `datetime` | | ☐ | | | `assignedEmployee_employeeRoleId` | `string` | | ☐ | | | `assignedEmployee_employer_archivedAt` | `datetime` | | ☐ | | | `assignedEmployee_employer_createdAt` | `datetime` | | ☐ | | | `assignedEmployee_employer_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_employer_email` | `string` | | ☐ | | | `assignedEmployee_employer_extraFields` | `string` | | ☐ | | | `assignedEmployee_employer_fax` | `string` | | ☐ | | | `assignedEmployee_employer_generalLedgerAccountId` | `string` | | ☐ | | | `assignedEmployee_employer_gsm` | `string` | | ☐ | | | `assignedEmployee_employer_iban` | `string` | | ☐ | | | `assignedEmployee_employer_id` | `string` | | ☐ | | | `assignedEmployee_employer_invoiceRemarks` | `string` | | ☐ | | | `assignedEmployee_employer_kvk` | `string` | | ☐ | | | `assignedEmployee_employer_language` | `string` | | ☐ | | | `assignedEmployee_employer_legalFormId` | `string` | | ☐ | | | `assignedEmployee_employer_lockedAt` | `datetime` | | ☐ | | | `assignedEmployee_employer_logicId` | `string` | | ☐ | | | `assignedEmployee_employer_name` | `string` | | ☐ | | | `assignedEmployee_employer_paymentConditionId` | `string` | | ☐ | | | `assignedEmployee_employer_planningEmail` | `string` | | ☐ | | | `assignedEmployee_employer_status` | `string` | | ☐ | | | `assignedEmployee_employer_supplyOrderRemarks` | `string` | | ☐ | | | `assignedEmployee_employer_tel` | `string` | | ☐ | | | `assignedEmployee_employer_type` | `string` | | ☐ | | | `assignedEmployee_employer_updatedAt` | `datetime` | | ☐ | | | `assignedEmployee_employer_vatIdNumber` | `string` | | ☐ | | | `assignedEmployee_employer_vatTariffId` | `string` | | ☐ | | | `assignedEmployee_employer_website` | `string` | | ☐ | | | `assignedEmployee_employerId` | `string` | | ☐ | | | `assignedEmployee_extraFields` | `string` | | ☐ | | | `assignedEmployee_grossSalary` | `decimal` | | ☐ | | | `assignedEmployee_gsm` | `string` | | ☐ | | | `assignedEmployee_id` | `string` | | ☐ | | | `assignedEmployee_identityCardExpirationDate` | `datetime` | | ☐ | | | `assignedEmployee_identityCardNumber` | `string` | | ☐ | | | `assignedEmployee_image_archivedAt` | `datetime` | | ☐ | | | `assignedEmployee_image_contentType` | `string` | | ☐ | | | `assignedEmployee_image_createdAt` | `datetime` | | ☐ | | | `assignedEmployee_image_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_image_directory` | `boolean` | | ☐ | | | `assignedEmployee_image_id` | `string` | | ☐ | | | `assignedEmployee_image_lockedAt` | `datetime` | | ☐ | | | `assignedEmployee_image_name` | `string` | | ☐ | | | `assignedEmployee_image_parentId` | `string` | | ☐ | | | `assignedEmployee_image_previewUrl` | `string` | | ☐ | | | `assignedEmployee_image_size` | `int64` | | ☐ | | | `assignedEmployee_image_updatedAt` | `datetime` | | ☐ | | | `assignedEmployee_image_url` | `string` | | ☐ | | | `assignedEmployee_independentRegistration` | `boolean` | | ☐ | | | `assignedEmployee_limosaExpirationDate` | `datetime` | | ☐ | | | `assignedEmployee_limosaNumber` | `string` | | ☐ | | | `assignedEmployee_lockedAt` | `datetime` | | ☐ | | | `assignedEmployee_name` | `string` | | ☐ | | | `assignedEmployee_nationality` | `string` | | ☐ | | | `assignedEmployee_nssoIdNumber` | `string` | | ☐ | | | `assignedEmployee_nssoPayment` | `boolean` | | ☐ | | | `assignedEmployee_nssoPaymentExpirationDate` | `datetime` | | ☐ | | | `assignedEmployee_numberOfDependents` | `int32` | | ☐ | | | `assignedEmployee_planningGroup` | `string` | | ☐ | | | `assignedEmployee_position` | `string` | | ☐ | | | `assignedEmployee_secondment` | `boolean` | | ☐ | | | `assignedEmployee_status` | `string` | | ☐ | | | `assignedEmployee_statute` | `string` | | ☐ | | | `assignedEmployee_subType` | `string` | | ☐ | | | `assignedEmployee_surname` | `string` | | ☐ | | | `assignedEmployee_tel` | `string` | | ☐ | | | `assignedEmployee_type` | `string` | | ☐ | | | `assignedEmployee_updatedAt` | `datetime` | | ☐ | | | `assignedEmployeeId` | `string` | Assigned Employee ID | ☐ | | | `assignedProject__metadata_description` | `string` | | ☐ | | | `assignedProject__metadata_href` | `string` | | ☐ | | | `assignedProject__metadata_resource` | `string` | | ☐ | | | `assignedProject__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedProject_archivedAt` | `datetime` | | ☐ | | | `assignedProject_checkInAtWork` | `string` | | ☐ | | | `assignedProject_client_archivedAt` | `datetime` | | ☐ | | | `assignedProject_client_assignedUserId` | `string` | | ☐ | | | `assignedProject_client_createdAt` | `datetime` | | ☐ | | | `assignedProject_client_creditStatus` | `string` | | ☐ | | | `assignedProject_client_deletedAt` | `datetime` | | ☐ | | | `assignedProject_client_email` | `string` | | ☐ | | | `assignedProject_client_extraFields` | `string` | | ☐ | | | `assignedProject_client_fax` | `string` | | ☐ | | | `assignedProject_client_followUpDate` | `datetime` | | ☐ | | | `assignedProject_client_generalLedgerAccountId` | `string` | | ☐ | | | `assignedProject_client_gsm` | `string` | | ☐ | | | `assignedProject_client_id` | `string` | | ☐ | | | `assignedProject_client_invoiceEmail` | `string` | | ☐ | | | `assignedProject_client_language` | `string` | | ☐ | | | `assignedProject_client_legalFormId` | `string` | | ☐ | | | `assignedProject_client_lockedAt` | `datetime` | | ☐ | | | `assignedProject_client_name` | `string` | | ☐ | | | `assignedProject_client_paymentConditionId` | `string` | | ☐ | | | `assignedProject_client_priceGroupId` | `string` | | ☐ | | | `assignedProject_client_status` | `string` | | ☐ | | | `assignedProject_client_tel` | `string` | | ☐ | | | `assignedProject_client_title` | `string` | | ☐ | | | `assignedProject_client_updatedAt` | `datetime` | | ☐ | | | `assignedProject_client_vatIdNumber` | `string` | | ☐ | | | `assignedProject_client_vatTariffId` | `string` | | ☐ | | | `assignedProject_client_website` | `string` | | ☐ | | | `assignedProject_clientContact_archivedAt` | `datetime` | | ☐ | | | `assignedProject_clientContact_createdAt` | `datetime` | | ☐ | | | `assignedProject_clientContact_deletedAt` | `datetime` | | ☐ | | | `assignedProject_clientContact_email` | `string` | | ☐ | | | `assignedProject_clientContact_extraFields` | `string` | | ☐ | | | `assignedProject_clientContact_gsm` | `string` | | ☐ | | | `assignedProject_clientContact_id` | `string` | | ☐ | | | `assignedProject_clientContact_lockedAt` | `datetime` | | ☐ | | | `assignedProject_clientContact_name` | `string` | | ☐ | | | `assignedProject_clientContact_position` | `string` | | ☐ | | | `assignedProject_clientContact_surname` | `string` | | ☐ | | | `assignedProject_clientContact_tel` | `string` | | ☐ | | | `assignedProject_clientContact_title` | `string` | | ☐ | | | `assignedProject_clientContact_updatedAt` | `datetime` | | ☐ | | | `assignedProject_clientContactId` | `string` | | ☐ | | | `assignedProject_clientId` | `string` | | ☐ | | | `assignedProject_clientReference` | `string` | | ☐ | | | `assignedProject_company_archivedAt` | `datetime` | | ☐ | | | `assignedProject_company_createdAt` | `datetime` | | ☐ | | | `assignedProject_company_deletedAt` | `datetime` | | ☐ | | | `assignedProject_company_extraFields` | `string` | | ☐ | | | `assignedProject_company_id` | `string` | | ☐ | | | `assignedProject_company_lockedAt` | `datetime` | | ☐ | | | `assignedProject_company_name` | `string` | | ☐ | | | `assignedProject_company_updatedAt` | `datetime` | | ☐ | | | `assignedProject_companyId` | `string` | | ☐ | | | `assignedProject_createdAt` | `datetime` | | ☐ | | | `assignedProject_date` | `datetime` | | ☐ | | | `assignedProject_deletedAt` | `datetime` | | ☐ | | | `assignedProject_distance` | `int32` | | ☐ | | | `assignedProject_endClient_archivedAt` | `datetime` | | ☐ | | | `assignedProject_endClient_assignedUserId` | `string` | | ☐ | | | `assignedProject_endClient_createdAt` | `datetime` | | ☐ | | | `assignedProject_endClient_creditStatus` | `string` | | ☐ | | | `assignedProject_endClient_deletedAt` | `datetime` | | ☐ | | | `assignedProject_endClient_email` | `string` | | ☐ | | | `assignedProject_endClient_extraFields` | `string` | | ☐ | | | `assignedProject_endClient_fax` | `string` | | ☐ | | | `assignedProject_endClient_followUpDate` | `datetime` | | ☐ | | | `assignedProject_endClient_generalLedgerAccountId` | `string` | | ☐ | | | `assignedProject_endClient_gsm` | `string` | | ☐ | | | `assignedProject_endClient_id` | `string` | | ☐ | | | `assignedProject_endClient_invoiceEmail` | `string` | | ☐ | | | `assignedProject_endClient_language` | `string` | | ☐ | | | `assignedProject_endClient_legalFormId` | `string` | | ☐ | | | `assignedProject_endClient_lockedAt` | `datetime` | | ☐ | | | `assignedProject_endClient_name` | `string` | | ☐ | | | `assignedProject_endClient_paymentConditionId` | `string` | | ☐ | | | `assignedProject_endClient_priceGroupId` | `string` | | ☐ | | | `assignedProject_endClient_status` | `string` | | ☐ | | | `assignedProject_endClient_tel` | `string` | | ☐ | | | `assignedProject_endClient_title` | `string` | | ☐ | | | `assignedProject_endClient_updatedAt` | `datetime` | | ☐ | | | `assignedProject_endClient_vatIdNumber` | `string` | | ☐ | | | `assignedProject_endClient_vatTariffId` | `string` | | ☐ | | | `assignedProject_endClient_website` | `string` | | ☐ | | | `assignedProject_endClientContact_archivedAt` | `datetime` | | ☐ | | | `assignedProject_endClientContact_createdAt` | `datetime` | | ☐ | | | `assignedProject_endClientContact_deletedAt` | `datetime` | | ☐ | | | `assignedProject_endClientContact_email` | `string` | | ☐ | | | `assignedProject_endClientContact_extraFields` | `string` | | ☐ | | | `assignedProject_endClientContact_gsm` | `string` | | ☐ | | | `assignedProject_endClientContact_id` | `string` | | ☐ | | | `assignedProject_endClientContact_lockedAt` | `datetime` | | ☐ | | | `assignedProject_endClientContact_name` | `string` | | ☐ | | | `assignedProject_endClientContact_position` | `string` | | ☐ | | | `assignedProject_endClientContact_surname` | `string` | | ☐ | | | `assignedProject_endClientContact_tel` | `string` | | ☐ | | | `assignedProject_endClientContact_title` | `string` | | ☐ | | | `assignedProject_endClientContact_updatedAt` | `datetime` | | ☐ | | | `assignedProject_endClientContactId` | `string` | | ☐ | | | `assignedProject_endClientId` | `string` | | ☐ | | | `assignedProject_extraFields` | `string` | | ☐ | | | `assignedProject_geofence` | `string` | | ☐ | | | `assignedProject_id` | `string` | | ☐ | | | `assignedProject_lockedAt` | `datetime` | | ☐ | | | `assignedProject_logicId` | `string` | | ☐ | | | `assignedProject_nssoDeclarationOfWorks` | `string` | | ☐ | | | `assignedProject_planningGroup` | `string` | | ☐ | | | `assignedProject_planningName` | `string` | | ☐ | | | `assignedProject_siteAddress_addressLine1` | `string` | | ☐ | | | `assignedProject_siteAddress_addressLine2` | `string` | | ☐ | | | `assignedProject_siteAddress_city` | `string` | | ☐ | | | `assignedProject_siteAddress_country` | `string` | | ☐ | | | `assignedProject_siteAddress_latitude` | `double` | | ☐ | | | `assignedProject_siteAddress_longitude` | `double` | | ☐ | | | `assignedProject_siteAddress_postalCode` | `string` | | ☐ | | | `assignedProject_siteManager_archivedAt` | `datetime` | | ☐ | | | `assignedProject_siteManager_createdAt` | `datetime` | | ☐ | | | `assignedProject_siteManager_deletedAt` | `datetime` | | ☐ | | | `assignedProject_siteManager_email` | `string` | | ☐ | | | `assignedProject_siteManager_emailAccountActive` | `boolean` | | ☐ | | | `assignedProject_siteManager_extraFields` | `string` | | ☐ | | | `assignedProject_siteManager_fullName` | `string` | | ☐ | | | `assignedProject_siteManager_id` | `string` | | ☐ | | | `assignedProject_siteManager_locale` | `string` | | ☐ | | | `assignedProject_siteManager_locked` | `boolean` | | ☐ | | | `assignedProject_siteManager_lockedAt` | `datetime` | | ☐ | | | `assignedProject_siteManager_updatedAt` | `datetime` | | ☐ | | | `assignedProject_siteManagerId` | `string` | | ☐ | | | `assignedProject_siteNssoIdNumber` | `string` | | ☐ | | | `assignedProject_status` | `string` | | ☐ | | | `assignedProject_statusDetails_color` | `string` | | ☐ | | | `assignedProject_statusDetails_name` | `string` | | ☐ | | | `assignedProject_updatedAt` | `datetime` | | ☐ | | | `assignedProjectId` | `string` | Assigned Project ID | ☐ | | | `assignedSubcontractor__metadata_description` | `string` | | ☐ | | | `assignedSubcontractor__metadata_href` | `string` | | ☐ | | | `assignedSubcontractor__metadata_resource` | `string` | | ☐ | | | `assignedSubcontractor__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedSubcontractor_archivedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_createdAt` | `datetime` | | ☐ | | | `assignedSubcontractor_deletedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_email` | `string` | | ☐ | | | `assignedSubcontractor_extraFields` | `string` | | ☐ | | | `assignedSubcontractor_fax` | `string` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_code` | `string` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_id` | `string` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_name` | `string` | | ☐ | | | `assignedSubcontractor_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_generalLedgerAccountId` | `string` | | ☐ | | | `assignedSubcontractor_gsm` | `string` | | ☐ | | | `assignedSubcontractor_iban` | `string` | | ☐ | | | `assignedSubcontractor_id` | `string` | | ☐ | | | `assignedSubcontractor_invoiceAddress_addressLine1` | `string` | | ☐ | | | `assignedSubcontractor_invoiceAddress_addressLine2` | `string` | | ☐ | | | `assignedSubcontractor_invoiceAddress_city` | `string` | | ☐ | | | `assignedSubcontractor_invoiceAddress_country` | `string` | | ☐ | | | `assignedSubcontractor_invoiceAddress_latitude` | `double` | | ☐ | | | `assignedSubcontractor_invoiceAddress_longitude` | `double` | | ☐ | | | `assignedSubcontractor_invoiceAddress_postalCode` | `string` | | ☐ | | | `assignedSubcontractor_invoiceRemarks` | `string` | | ☐ | | | `assignedSubcontractor_kvk` | `string` | | ☐ | | | `assignedSubcontractor_language` | `string` | | ☐ | | | `assignedSubcontractor_legalForm_archivedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_legalForm_createdAt` | `datetime` | | ☐ | | | `assignedSubcontractor_legalForm_deletedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_legalForm_extraFields` | `string` | | ☐ | | | `assignedSubcontractor_legalForm_id` | `string` | | ☐ | | | `assignedSubcontractor_legalForm_legalAbbreviation` | `string` | | ☐ | | | `assignedSubcontractor_legalForm_lockedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_legalForm_name` | `string` | | ☐ | | | `assignedSubcontractor_legalForm_updatedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_legalForm_vatLiable` | `boolean` | | ☐ | | | `assignedSubcontractor_legalFormId` | `string` | | ☐ | | | `assignedSubcontractor_lockedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_logicId` | `string` | | ☐ | | | `assignedSubcontractor_name` | `string` | | ☐ | | | `assignedSubcontractor_paymentConditionId` | `string` | | ☐ | | | `assignedSubcontractor_planningEmail` | `string` | | ☐ | | | `assignedSubcontractor_status` | `string` | | ☐ | | | `assignedSubcontractor_statusDetails_color` | `string` | | ☐ | | | `assignedSubcontractor_statusDetails_name` | `string` | | ☐ | | | `assignedSubcontractor_supplyOrderRemarks` | `string` | | ☐ | | | `assignedSubcontractor_tel` | `string` | | ☐ | | | `assignedSubcontractor_type` | `string` | | ☐ | | | `assignedSubcontractor_updatedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatIdNumber` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_additionalMention` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_archivedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatTariff_category` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_createdAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatTariff_deletedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatTariff_description` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `assignedSubcontractor_vatTariff_extraFields` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_id` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_inclusive` | `boolean` | | ☐ | | | `assignedSubcontractor_vatTariff_lockedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatTariff_name` | `string` | | ☐ | | | `assignedSubcontractor_vatTariff_percentage` | `decimal` | | ☐ | | | `assignedSubcontractor_vatTariff_updatedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatTariffId` | `string` | | ☐ | | | `assignedSubcontractor_website` | `string` | | ☐ | | | `assignedSubcontractorId` | `string` | Assigned Subcontractor ID | ☐ | | | `brand` | `string` | Brand | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id` | `string` | ID | ☐ | | | `installation` | `boolean` | Installation | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `name` | `string` | Name | ☐ | | | `serialNumber` | `string` | Serial Number | ☐ | | | `status` | `string` | Status | ☐ | | | `stockLocation__metadata_description` | `string` | | ☐ | | | `stockLocation__metadata_href` | `string` | | ☐ | | | `stockLocation__metadata_resource` | `string` | | ☐ | | | `stockLocation__metadata_resourceTypeId` | `string` | | ☐ | | | `stockLocation_archivedAt` | `datetime` | | ☐ | | | `stockLocation_createdAt` | `datetime` | | ☐ | | | `stockLocation_deletedAt` | `datetime` | | ☐ | | | `stockLocation_extraFields` | `string` | | ☐ | | | `stockLocation_id` | `string` | Stock Location ID | ☐ | | | `stockLocation_lockedAt` | `datetime` | | ☐ | | | `stockLocation_name` | `string` | Stock Location Name | ☐ | | | `stockLocation_updatedAt` | `datetime` | | ☐ | | | `stockLocationId` | `string` | Stock Location ID | ☐ | | | `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_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_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_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` | Supplier ID | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |