# PurchaseSupplyOrdersById: ROBAWS Purchase Supply Order 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: `PurchaseSupplyOrders` - Label: Purchase Supply Order by ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | ## Columns The columns of the table `PurchaseSupplyOrdersById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | Archived at | ☐ | | | `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 | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `completionPercentage` | `decimal` | Completion Percentage | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `createdAt` | `datetime` | Created at | ☐ | | | `date` | `datetime` | Date | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `deliveryAddress` | `string` | Delivery address | ☐ | | | `expectedDeliveryDate` | `datetime` | Expected delivery date | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id` | `string` | ID | ☐ | | | `latestDeliveryDate` | `datetime` | Latest delivery date | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `reference` | `string` | Reference | ☐ | | | `remark` | `string` | Remark | ☐ | | | `sentViaWebshop` | `datetime` | Sent via Webshop | ☐ | | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `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` | | ☐ | | | `supplierContact__metadata_description` | `string` | | ☐ | | | `supplierContact__metadata_href` | `string` | | ☐ | | | `supplierContact__metadata_resource` | `string` | | ☐ | | | `supplierContact__metadata_resourceTypeId` | `string` | | ☐ | | | `supplierContact_archivedAt` | `datetime` | | ☐ | | | `supplierContact_createdAt` | `datetime` | | ☐ | | | `supplierContact_deletedAt` | `datetime` | | ☐ | | | `supplierContact_email` | `string` | | ☐ | | | `supplierContact_extraFields` | `string` | | ☐ | | | `supplierContact_gsm` | `string` | | ☐ | | | `supplierContact_id` | `string` | | ☐ | | | `supplierContact_lockedAt` | `datetime` | | ☐ | | | `supplierContact_name` | `string` | | ☐ | | | `supplierContact_position` | `string` | | ☐ | | | `supplierContact_surname` | `string` | | ☐ | | | `supplierContact_tel` | `string` | | ☐ | | | `supplierContact_title` | `string` | | ☐ | | | `supplierContact_updatedAt` | `datetime` | | ☐ | | | `supplierContactId` | `string` | Supplier Contact ID | ☐ | | | `supplierId` | `string` | Supplier 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 | ☐ | | | `type` | `string` | Type | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |