# StockChangeMaterials: ROBAWS Stock Change Materials 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: `StockChanges` - Label: Stock Change Materials ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `isBookedOnly` | `boolean` | ☐ | | | | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `StockChangeMaterials` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | Archived at | ☐ | | | `articleId` | `string` | Item 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 | ☐ | | | `assignedSupplier_archivedAt` | `datetime` | | ☐ | | | `assignedSupplier_createdAt` | `datetime` | | ☐ | | | `assignedSupplier_deletedAt` | `datetime` | | ☐ | | | `assignedSupplier_email` | `string` | | ☐ | | | `assignedSupplier_extraFields` | `string` | | ☐ | | | `assignedSupplier_fax` | `string` | | ☐ | | | `assignedSupplier_generalLedgerAccountId` | `string` | | ☐ | | | `assignedSupplier_gsm` | `string` | | ☐ | | | `assignedSupplier_iban` | `string` | | ☐ | | | `assignedSupplier_id` | `string` | | ☐ | | | `assignedSupplier_invoiceRemarks` | `string` | | ☐ | | | `assignedSupplier_kvk` | `string` | | ☐ | | | `assignedSupplier_language` | `string` | | ☐ | | | `assignedSupplier_legalFormId` | `string` | | ☐ | | | `assignedSupplier_lockedAt` | `datetime` | | ☐ | | | `assignedSupplier_logicId` | `string` | | ☐ | | | `assignedSupplier_name` | `string` | | ☐ | | | `assignedSupplier_paymentConditionId` | `string` | | ☐ | | | `assignedSupplier_planningEmail` | `string` | | ☐ | | | `assignedSupplier_status` | `string` | | ☐ | | | `assignedSupplier_supplyOrderRemarks` | `string` | | ☐ | | | `assignedSupplier_tel` | `string` | | ☐ | | | `assignedSupplier_type` | `string` | | ☐ | | | `assignedSupplier_updatedAt` | `datetime` | | ☐ | | | `assignedSupplier_vatIdNumber` | `string` | | ☐ | | | `assignedSupplier_vatTariffId` | `string` | | ☐ | | | `assignedSupplier_website` | `string` | | ☐ | | | `assignedSupplierId` | `string` | Assigned Supplier ID | ☐ | | | `assignedUser_archivedAt` | `datetime` | | ☐ | | | `assignedUser_createdAt` | `datetime` | | ☐ | | | `assignedUser_deletedAt` | `datetime` | | ☐ | | | `assignedUser_email` | `string` | | ☐ | | | `assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `assignedUser_extraFields` | `string` | | ☐ | | | `assignedUser_fullName` | `string` | | ☐ | | | `assignedUser_id` | `string` | | ☐ | | | `assignedUser_locale` | `string` | | ☐ | | | `assignedUser_locked` | `boolean` | | ☐ | | | `assignedUser_lockedAt` | `datetime` | | ☐ | | | `assignedUser_updatedAt` | `datetime` | | ☐ | | | `assignedUserId` | `string` | Assigned User ID | ☐ | | | `booked` | `boolean` | Booked | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `date` | `datetime` | Date | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `enumeration` | `boolean` | Enumeration | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `fromLocation_archivedAt` | `datetime` | | ☐ | | | `fromLocation_createdAt` | `datetime` | | ☐ | | | `fromLocation_deletedAt` | `datetime` | | ☐ | | | `fromLocation_extraFields` | `string` | | ☐ | | | `fromLocation_id` | `string` | | ☐ | | | `fromLocation_lockedAt` | `datetime` | | ☐ | | | `fromLocation_name` | `string` | | ☐ | | | `fromLocation_updatedAt` | `datetime` | | ☐ | | | `fromLocationId` | `string` | From Place ID | ☐ | | | `id` | `string` | ID | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `materialId` | `string` | Material ID | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `quantity` | `decimal` | Quantity | ☐ | | | `serialNumber` | `string` | Serial Number | ☐ | | | `status` | `string` | Status | ☐ | | | `stockChangeId` | `string` | Change Stock ID | ☐ | Only present when obtained via bulk endpoint | | `supplyOrder_archivedAt` | `datetime` | | ☐ | | | `supplyOrder_assignedUserId` | `string` | | ☐ | | | `supplyOrder_completionPercentage` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `supplyOrder_createdAt` | `datetime` | | ☐ | | | `supplyOrder_deletedAt` | `datetime` | | ☐ | | | `supplyOrder_extraFields` | `string` | | ☐ | | | `supplyOrder_id` | `string` | | ☐ | | | `supplyOrder_lockedAt` | `datetime` | | ☐ | | | `supplyOrder_logicId` | `string` | | ☐ | | | `supplyOrder_remark` | `string` | | ☐ | | | `supplyOrder_status` | `string` | | ☐ | | | `supplyOrder_type` | `string` | | ☐ | | | `supplyOrder_updatedAt` | `datetime` | | ☐ | | | `supplyOrderId` | `string` | Delivery Order ID | ☐ | | | `toClient_archivedAt` | `datetime` | | ☐ | | | `toClient_assignedUserId` | `string` | | ☐ | | | `toClient_createdAt` | `datetime` | | ☐ | | | `toClient_creditStatus` | `string` | | ☐ | | | `toClient_deletedAt` | `datetime` | | ☐ | | | `toClient_email` | `string` | | ☐ | | | `toClient_extraFields` | `string` | | ☐ | | | `toClient_fax` | `string` | | ☐ | | | `toClient_followUpDate` | `datetime` | | ☐ | | | `toClient_generalLedgerAccountId` | `string` | | ☐ | | | `toClient_gsm` | `string` | | ☐ | | | `toClient_id` | `string` | | ☐ | | | `toClient_invoiceEmail` | `string` | | ☐ | | | `toClient_language` | `string` | | ☐ | | | `toClient_legalFormId` | `string` | | ☐ | | | `toClient_lockedAt` | `datetime` | | ☐ | | | `toClient_name` | `string` | | ☐ | | | `toClient_paymentConditionId` | `string` | | ☐ | | | `toClient_priceGroupId` | `string` | | ☐ | | | `toClient_status` | `string` | | ☐ | | | `toClient_tel` | `string` | | ☐ | | | `toClient_title` | `string` | | ☐ | | | `toClient_updatedAt` | `datetime` | | ☐ | | | `toClient_vatIdNumber` | `string` | | ☐ | | | `toClient_vatTariffId` | `string` | | ☐ | | | `toClient_website` | `string` | | ☐ | | | `toClientId` | `string` | To Customer ID | ☐ | | | `toLocation_archivedAt` | `datetime` | | ☐ | | | `toLocation_createdAt` | `datetime` | | ☐ | | | `toLocation_deletedAt` | `datetime` | | ☐ | | | `toLocation_extraFields` | `string` | | ☐ | | | `toLocation_id` | `string` | | ☐ | | | `toLocation_lockedAt` | `datetime` | | ☐ | | | `toLocation_name` | `string` | | ☐ | | | `toLocation_updatedAt` | `datetime` | | ☐ | | | `toLocationId` | `string` | To Location ID | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |