# StockChangesFromSupplyOrderMaterial: ROBAWS Stock Changes from Material Supply Order Get stock change from supply order 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 Changes from Material Supply Order ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `supplyOrderId` | `string` | ☑ | | | ## Columns The columns of the table `StockChangesFromSupplyOrderMaterial` 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 | ☐ | | | `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 | ☐ | | | `assignedSupplier__metadata_description` | `string` | | ☐ | | | `assignedSupplier__metadata_href` | `string` | | ☐ | | | `assignedSupplier__metadata_resource` | `string` | | ☐ | | | `assignedSupplier__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedSupplier_archivedAt` | `datetime` | | ☐ | | | `assignedSupplier_createdAt` | `datetime` | | ☐ | | | `assignedSupplier_deletedAt` | `datetime` | | ☐ | | | `assignedSupplier_email` | `string` | | ☐ | | | `assignedSupplier_extraFields` | `string` | | ☐ | | | `assignedSupplier_fax` | `string` | | ☐ | | | `assignedSupplier_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `assignedSupplier_generalLedgerAccount_code` | `string` | | ☐ | | | `assignedSupplier_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `assignedSupplier_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `assignedSupplier_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `assignedSupplier_generalLedgerAccount_id` | `string` | | ☐ | | | `assignedSupplier_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `assignedSupplier_generalLedgerAccount_name` | `string` | | ☐ | | | `assignedSupplier_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `assignedSupplier_generalLedgerAccountId` | `string` | | ☐ | | | `assignedSupplier_gsm` | `string` | | ☐ | | | `assignedSupplier_iban` | `string` | | ☐ | | | `assignedSupplier_id` | `string` | | ☐ | | | `assignedSupplier_invoiceAddress_addressLine1` | `string` | | ☐ | | | `assignedSupplier_invoiceAddress_addressLine2` | `string` | | ☐ | | | `assignedSupplier_invoiceAddress_city` | `string` | | ☐ | | | `assignedSupplier_invoiceAddress_country` | `string` | | ☐ | | | `assignedSupplier_invoiceAddress_latitude` | `double` | | ☐ | | | `assignedSupplier_invoiceAddress_longitude` | `double` | | ☐ | | | `assignedSupplier_invoiceAddress_postalCode` | `string` | | ☐ | | | `assignedSupplier_invoiceRemarks` | `string` | | ☐ | | | `assignedSupplier_kvk` | `string` | | ☐ | | | `assignedSupplier_language` | `string` | | ☐ | | | `assignedSupplier_legalForm_archivedAt` | `datetime` | | ☐ | | | `assignedSupplier_legalForm_createdAt` | `datetime` | | ☐ | | | `assignedSupplier_legalForm_deletedAt` | `datetime` | | ☐ | | | `assignedSupplier_legalForm_extraFields` | `string` | | ☐ | | | `assignedSupplier_legalForm_id` | `string` | | ☐ | | | `assignedSupplier_legalForm_legalAbbreviation` | `string` | | ☐ | | | `assignedSupplier_legalForm_lockedAt` | `datetime` | | ☐ | | | `assignedSupplier_legalForm_name` | `string` | | ☐ | | | `assignedSupplier_legalForm_updatedAt` | `datetime` | | ☐ | | | `assignedSupplier_legalForm_vatLiable` | `boolean` | | ☐ | | | `assignedSupplier_legalFormId` | `string` | | ☐ | | | `assignedSupplier_lockedAt` | `datetime` | | ☐ | | | `assignedSupplier_logicId` | `string` | | ☐ | | | `assignedSupplier_name` | `string` | | ☐ | | | `assignedSupplier_paymentConditionId` | `string` | | ☐ | | | `assignedSupplier_planningEmail` | `string` | | ☐ | | | `assignedSupplier_status` | `string` | | ☐ | | | `assignedSupplier_statusDetails_color` | `string` | | ☐ | | | `assignedSupplier_statusDetails_name` | `string` | | ☐ | | | `assignedSupplier_supplyOrderRemarks` | `string` | | ☐ | | | `assignedSupplier_tel` | `string` | | ☐ | | | `assignedSupplier_type` | `string` | | ☐ | | | `assignedSupplier_updatedAt` | `datetime` | | ☐ | | | `assignedSupplier_vatIdNumber` | `string` | | ☐ | | | `assignedSupplier_vatTariff_additionalMention` | `string` | | ☐ | | | `assignedSupplier_vatTariff_archivedAt` | `datetime` | | ☐ | | | `assignedSupplier_vatTariff_category` | `string` | | ☐ | | | `assignedSupplier_vatTariff_createdAt` | `datetime` | | ☐ | | | `assignedSupplier_vatTariff_deletedAt` | `datetime` | | ☐ | | | `assignedSupplier_vatTariff_description` | `string` | | ☐ | | | `assignedSupplier_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `assignedSupplier_vatTariff_extraFields` | `string` | | ☐ | | | `assignedSupplier_vatTariff_id` | `string` | | ☐ | | | `assignedSupplier_vatTariff_inclusive` | `boolean` | | ☐ | | | `assignedSupplier_vatTariff_lockedAt` | `datetime` | | ☐ | | | `assignedSupplier_vatTariff_name` | `string` | | ☐ | | | `assignedSupplier_vatTariff_percentage` | `decimal` | | ☐ | | | `assignedSupplier_vatTariff_updatedAt` | `datetime` | | ☐ | | | `assignedSupplier_vatTariffId` | `string` | | ☐ | | | `assignedSupplier_website` | `string` | | ☐ | | | `assignedSupplierId` | `string` | Assigned Supplier ID | ☐ | | | `assignedUser__metadata_description` | `string` | | ☐ | | | `assignedUser__metadata_href` | `string` | | ☐ | | | `assignedUser__metadata_resource` | `string` | | ☐ | | | `assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedUser_archivedAt` | `datetime` | | ☐ | | | `assignedUser_createdAt` | `datetime` | | ☐ | | | `assignedUser_deletedAt` | `datetime` | | ☐ | | | `assignedUser_email` | `string` | | ☐ | | | `assignedUser_emailAccount_from` | `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__metadata_description` | `string` | | ☐ | | | `fromLocation__metadata_href` | `string` | | ☐ | | | `fromLocation__metadata_resource` | `string` | | ☐ | | | `fromLocation__metadata_resourceTypeId` | `string` | | ☐ | | | `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 | ☐ | | | `material_archivedAt` | `datetime` | | ☐ | | | `material_articleId` | `string` | | ☐ | | | `material_assignedClientId` | `string` | | ☐ | | | `material_assignedEmployeeId` | `string` | | ☐ | | | `material_assignedProjectId` | `string` | | ☐ | | | `material_assignedSubcontractorId` | `string` | | ☐ | | | `material_brand` | `string` | | ☐ | | | `material_createdAt` | `datetime` | | ☐ | | | `material_deletedAt` | `datetime` | | ☐ | | | `material_extraFields` | `string` | | ☐ | | | `material_id` | `string` | | ☐ | | | `material_installation` | `boolean` | | ☐ | | | `material_lockedAt` | `datetime` | | ☐ | | | `material_name` | `string` | | ☐ | | | `material_serialNumber` | `string` | | ☐ | | | `material_status` | `string` | | ☐ | | | `material_stockLocationId` | `string` | | ☐ | | | `material_supplierId` | `string` | | ☐ | | | `material_updatedAt` | `datetime` | | ☐ | | | `materialId` | `string` | Material ID | ☐ | | | `project_archivedAt` | `datetime` | | ☐ | | | `project_checkInAtWork` | `string` | | ☐ | | | `project_clientContactId` | `string` | | ☐ | | | `project_clientId` | `string` | | ☐ | | | `project_clientReference` | `string` | | ☐ | | | `project_companyId` | `string` | | ☐ | | | `project_createdAt` | `datetime` | | ☐ | | | `project_date` | `datetime` | | ☐ | | | `project_deletedAt` | `datetime` | | ☐ | | | `project_distance` | `int32` | | ☐ | | | `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_siteManagerId` | `string` | | ☐ | | | `project_siteNssoIdNumber` | `string` | | ☐ | | | `project_status` | `string` | | ☐ | | | `project_updatedAt` | `datetime` | | ☐ | | | `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__metadata_description` | `string` | | ☐ | | | `supplyOrder__metadata_href` | `string` | | ☐ | | | `supplyOrder__metadata_resource` | `string` | | ☐ | | | `supplyOrder__metadata_resourceTypeId` | `string` | | ☐ | | | `supplyOrder_archivedAt` | `datetime` | | ☐ | | | `supplyOrder_assignedUser_archivedAt` | `datetime` | | ☐ | | | `supplyOrder_assignedUser_createdAt` | `datetime` | | ☐ | | | `supplyOrder_assignedUser_deletedAt` | `datetime` | | ☐ | | | `supplyOrder_assignedUser_email` | `string` | | ☐ | | | `supplyOrder_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `supplyOrder_assignedUser_extraFields` | `string` | | ☐ | | | `supplyOrder_assignedUser_fullName` | `string` | | ☐ | | | `supplyOrder_assignedUser_id` | `string` | | ☐ | | | `supplyOrder_assignedUser_locale` | `string` | | ☐ | | | `supplyOrder_assignedUser_locked` | `boolean` | | ☐ | | | `supplyOrder_assignedUser_lockedAt` | `datetime` | | ☐ | | | `supplyOrder_assignedUser_updatedAt` | `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_statusDetails_color` | `string` | | ☐ | | | `supplyOrder_statusDetails_name` | `string` | | ☐ | | | `supplyOrder_type` | `string` | | ☐ | | | `supplyOrder_updatedAt` | `datetime` | | ☐ | | | `supplyOrderId` | `string` | Delivery Order ID | ☐ | | | `toClient__metadata_description` | `string` | | ☐ | | | `toClient__metadata_href` | `string` | | ☐ | | | `toClient__metadata_resource` | `string` | | ☐ | | | `toClient__metadata_resourceTypeId` | `string` | | ☐ | | | `toClient_address_addressLine1` | `string` | | ☐ | | | `toClient_address_addressLine2` | `string` | | ☐ | | | `toClient_address_city` | `string` | | ☐ | | | `toClient_address_country` | `string` | | ☐ | | | `toClient_address_latitude` | `double` | | ☐ | | | `toClient_address_longitude` | `double` | | ☐ | | | `toClient_address_postalCode` | `string` | | ☐ | | | `toClient_archivedAt` | `datetime` | | ☐ | | | `toClient_assignedUser_archivedAt` | `datetime` | | ☐ | | | `toClient_assignedUser_createdAt` | `datetime` | | ☐ | | | `toClient_assignedUser_deletedAt` | `datetime` | | ☐ | | | `toClient_assignedUser_email` | `string` | | ☐ | | | `toClient_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `toClient_assignedUser_extraFields` | `string` | | ☐ | | | `toClient_assignedUser_fullName` | `string` | | ☐ | | | `toClient_assignedUser_id` | `string` | | ☐ | | | `toClient_assignedUser_locale` | `string` | | ☐ | | | `toClient_assignedUser_locked` | `boolean` | | ☐ | | | `toClient_assignedUser_lockedAt` | `datetime` | | ☐ | | | `toClient_assignedUser_updatedAt` | `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_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `toClient_generalLedgerAccount_code` | `string` | | ☐ | | | `toClient_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `toClient_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `toClient_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `toClient_generalLedgerAccount_id` | `string` | | ☐ | | | `toClient_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `toClient_generalLedgerAccount_name` | `string` | | ☐ | | | `toClient_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `toClient_generalLedgerAccountId` | `string` | | ☐ | | | `toClient_gsm` | `string` | | ☐ | | | `toClient_id` | `string` | | ☐ | | | `toClient_invoiceAddress_addressLine1` | `string` | | ☐ | | | `toClient_invoiceAddress_addressLine2` | `string` | | ☐ | | | `toClient_invoiceAddress_city` | `string` | | ☐ | | | `toClient_invoiceAddress_country` | `string` | | ☐ | | | `toClient_invoiceAddress_latitude` | `double` | | ☐ | | | `toClient_invoiceAddress_longitude` | `double` | | ☐ | | | `toClient_invoiceAddress_postalCode` | `string` | | ☐ | | | `toClient_invoiceEmail` | `string` | | ☐ | | | `toClient_language` | `string` | | ☐ | | | `toClient_legalForm_archivedAt` | `datetime` | | ☐ | | | `toClient_legalForm_createdAt` | `datetime` | | ☐ | | | `toClient_legalForm_deletedAt` | `datetime` | | ☐ | | | `toClient_legalForm_extraFields` | `string` | | ☐ | | | `toClient_legalForm_id` | `string` | | ☐ | | | `toClient_legalForm_legalAbbreviation` | `string` | | ☐ | | | `toClient_legalForm_lockedAt` | `datetime` | | ☐ | | | `toClient_legalForm_name` | `string` | | ☐ | | | `toClient_legalForm_updatedAt` | `datetime` | | ☐ | | | `toClient_legalForm_vatLiable` | `boolean` | | ☐ | | | `toClient_legalFormId` | `string` | | ☐ | | | `toClient_lockedAt` | `datetime` | | ☐ | | | `toClient_name` | `string` | | ☐ | | | `toClient_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `toClient_paymentCondition_createdAt` | `datetime` | | ☐ | | | `toClient_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `toClient_paymentCondition_extraFields` | `string` | | ☐ | | | `toClient_paymentCondition_id` | `string` | | ☐ | | | `toClient_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `toClient_paymentCondition_name` | `string` | | ☐ | | | `toClient_paymentCondition_purchase` | `boolean` | | ☐ | | | `toClient_paymentCondition_sales` | `boolean` | | ☐ | | | `toClient_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `toClient_paymentConditionId` | `string` | | ☐ | | | `toClient_priceGroupId` | `string` | | ☐ | | | `toClient_status` | `string` | | ☐ | | | `toClient_statusDetails_color` | `string` | | ☐ | | | `toClient_statusDetails_name` | `string` | | ☐ | | | `toClient_tel` | `string` | | ☐ | | | `toClient_title` | `string` | | ☐ | | | `toClient_updatedAt` | `datetime` | | ☐ | | | `toClient_vatIdNumber` | `string` | | ☐ | | | `toClient_vatTariff_additionalMention` | `string` | | ☐ | | | `toClient_vatTariff_archivedAt` | `datetime` | | ☐ | | | `toClient_vatTariff_category` | `string` | | ☐ | | | `toClient_vatTariff_createdAt` | `datetime` | | ☐ | | | `toClient_vatTariff_deletedAt` | `datetime` | | ☐ | | | `toClient_vatTariff_description` | `string` | | ☐ | | | `toClient_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `toClient_vatTariff_extraFields` | `string` | | ☐ | | | `toClient_vatTariff_id` | `string` | | ☐ | | | `toClient_vatTariff_inclusive` | `boolean` | | ☐ | | | `toClient_vatTariff_lockedAt` | `datetime` | | ☐ | | | `toClient_vatTariff_name` | `string` | | ☐ | | | `toClient_vatTariff_percentage` | `decimal` | | ☐ | | | `toClient_vatTariff_updatedAt` | `datetime` | | ☐ | | | `toClient_vatTariffId` | `string` | | ☐ | | | `toClient_website` | `string` | | ☐ | | | `toClientId` | `string` | To Customer ID | ☐ | | | `toLocation__metadata_description` | `string` | | ☐ | | | `toLocation__metadata_href` | `string` | | ☐ | | | `toLocation__metadata_resource` | `string` | | ☐ | | | `toLocation__metadata_resourceTypeId` | `string` | | ☐ | | | `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 | ☐ | |