# Installations: ROBAWS Installations Search This is a read-only table function. The ROBAWS API may not support modifying the data, or the Invantive SQL driver for ROBAWS does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the ROBAWS API. - Catalog: `Robaws` - Schema: `Installations` - Label: Installations ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `searchText` | `string` | ☐ | | | | `serialNumber` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `updatedFrom` | `datetime` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `Installations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | Archived at | ☐ | | | `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_id` | `string` | Item ID | ☐ | | | `article_installation` | `boolean` | | ☐ | | | `article_lockedAt` | `datetime` | | ☐ | | | `article_margin` | `decimal` | | ☐ | | | `article_minimumStock` | `decimal` | | ☐ | | | `article_name` | `string` | | ☐ | | | `article_nameTranslations` | `string` | | ☐ | | | `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_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_archivedAt` | `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_generalLedgerAccountId` | `string` | | ☐ | | | `assignedClient_gsm` | `string` | | ☐ | | | `assignedClient_id` | `string` | | ☐ | | | `assignedClient_invoiceEmail` | `string` | | ☐ | | | `assignedClient_language` | `string` | | ☐ | | | `assignedClient_legalFormId` | `string` | | ☐ | | | `assignedClient_lockedAt` | `datetime` | | ☐ | | | `assignedClient_name` | `string` | | ☐ | | | `assignedClient_paymentConditionId` | `string` | | ☐ | | | `assignedClient_priceGroupId` | `string` | | ☐ | | | `assignedClient_status` | `string` | | ☐ | | | `assignedClient_tel` | `string` | | ☐ | | | `assignedClient_title` | `string` | | ☐ | | | `assignedClient_updatedAt` | `datetime` | | ☐ | | | `assignedClient_vatIdNumber` | `string` | | ☐ | | | `assignedClient_vatTariffId` | `string` | | ☐ | | | `assignedClient_website` | `string` | | ☐ | | | `assignedClientId` | `string` | Assigned Customer ID | ☐ | | | `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_defaultStockLocationId` | `string` | | ☐ | | | `assignedEmployee_defaultTimeOperationId` | `string` | | ☐ | | | `assignedEmployee_deletedAt` | `datetime` | | ☐ | | | `assignedEmployee_dimonaExpirationDate` | `datetime` | | ☐ | | | `assignedEmployee_dimonaNumber` | `string` | | ☐ | | | `assignedEmployee_distance` | `decimal` | | ☐ | | | `assignedEmployee_driverLicense` | `string` | | ☐ | | | `assignedEmployee_email` | `string` | | ☐ | | | `assignedEmployee_emergencyTel` | `string` | | ☐ | | | `assignedEmployee_employeeRoleId` | `string` | | ☐ | | | `assignedEmployee_employerId` | `string` | | ☐ | | | `assignedEmployee_extraFields` | `string` | | ☐ | | | `assignedEmployee_grossSalary` | `decimal` | | ☐ | | | `assignedEmployee_gsm` | `string` | | ☐ | | | `assignedEmployee_id` | `string` | | ☐ | | | `assignedEmployee_identityCardExpirationDate` | `datetime` | | ☐ | | | `assignedEmployee_identityCardNumber` | `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_archivedAt` | `datetime` | | ☐ | | | `assignedProject_checkInAtWork` | `string` | | ☐ | | | `assignedProject_clientContactId` | `string` | | ☐ | | | `assignedProject_clientId` | `string` | | ☐ | | | `assignedProject_clientReference` | `string` | | ☐ | | | `assignedProject_companyId` | `string` | | ☐ | | | `assignedProject_createdAt` | `datetime` | | ☐ | | | `assignedProject_date` | `datetime` | | ☐ | | | `assignedProject_deletedAt` | `datetime` | | ☐ | | | `assignedProject_distance` | `int32` | | ☐ | | | `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_siteManagerId` | `string` | | ☐ | | | `assignedProject_siteNssoIdNumber` | `string` | | ☐ | | | `assignedProject_status` | `string` | | ☐ | | | `assignedProject_updatedAt` | `datetime` | | ☐ | | | `assignedProjectId` | `string` | Assigned Project ID | ☐ | | | `assignedSubcontractor_archivedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_createdAt` | `datetime` | | ☐ | | | `assignedSubcontractor_deletedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_email` | `string` | | ☐ | | | `assignedSubcontractor_extraFields` | `string` | | ☐ | | | `assignedSubcontractor_fax` | `string` | | ☐ | | | `assignedSubcontractor_generalLedgerAccountId` | `string` | | ☐ | | | `assignedSubcontractor_gsm` | `string` | | ☐ | | | `assignedSubcontractor_iban` | `string` | | ☐ | | | `assignedSubcontractor_id` | `string` | | ☐ | | | `assignedSubcontractor_invoiceRemarks` | `string` | | ☐ | | | `assignedSubcontractor_kvk` | `string` | | ☐ | | | `assignedSubcontractor_language` | `string` | | ☐ | | | `assignedSubcontractor_legalFormId` | `string` | | ☐ | | | `assignedSubcontractor_lockedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_logicId` | `string` | | ☐ | | | `assignedSubcontractor_name` | `string` | | ☐ | | | `assignedSubcontractor_paymentConditionId` | `string` | | ☐ | | | `assignedSubcontractor_planningEmail` | `string` | | ☐ | | | `assignedSubcontractor_status` | `string` | | ☐ | | | `assignedSubcontractor_supplyOrderRemarks` | `string` | | ☐ | | | `assignedSubcontractor_tel` | `string` | | ☐ | | | `assignedSubcontractor_type` | `string` | | ☐ | | | `assignedSubcontractor_updatedAt` | `datetime` | | ☐ | | | `assignedSubcontractor_vatIdNumber` | `string` | | ☐ | | | `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_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_archivedAt` | `datetime` | | ☐ | | | `supplier_createdAt` | `datetime` | | ☐ | | | `supplier_deletedAt` | `datetime` | | ☐ | | | `supplier_email` | `string` | | ☐ | | | `supplier_extraFields` | `string` | | ☐ | | | `supplier_fax` | `string` | | ☐ | | | `supplier_generalLedgerAccountId` | `string` | | ☐ | | | `supplier_gsm` | `string` | | ☐ | | | `supplier_iban` | `string` | | ☐ | | | `supplier_id` | `string` | | ☐ | | | `supplier_invoiceRemarks` | `string` | | ☐ | | | `supplier_kvk` | `string` | | ☐ | | | `supplier_language` | `string` | | ☐ | | | `supplier_legalFormId` | `string` | | ☐ | | | `supplier_lockedAt` | `datetime` | | ☐ | | | `supplier_logicId` | `string` | | ☐ | | | `supplier_name` | `string` | | ☐ | | | `supplier_paymentConditionId` | `string` | | ☐ | | | `supplier_planningEmail` | `string` | | ☐ | | | `supplier_status` | `string` | | ☐ | | | `supplier_supplyOrderRemarks` | `string` | | ☐ | | | `supplier_tel` | `string` | | ☐ | | | `supplier_type` | `string` | | ☐ | | | `supplier_updatedAt` | `datetime` | | ☐ | | | `supplier_vatIdNumber` | `string` | | ☐ | | | `supplier_vatTariffId` | `string` | | ☐ | | | `supplier_website` | `string` | | ☐ | | | `supplierId` | `string` | Supplier ID | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |