# PurchaseInvoiceLineIdsByPurchaseInvoiceId: ROBAWS Inkoopfactuurregel-ID's op inkoopfactuur-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: `PurchaseInvoiceLineItems` - Label: Purchase Invoice Line IDs by Purchase Invoice ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | | `purchaseInvoiceId` | `string` | ☐ | | | ## Columns The columns of the table `PurchaseInvoiceLineIdsByPurchaseInvoiceId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity__metadata_description` | `string` | | ☐ | | | `activity__metadata_href` | `string` | | ☐ | | | `activity__metadata_resource` | `string` | | ☐ | | | `activity__metadata_resourceTypeId` | `string` | | ☐ | | | `activity_archivedAt` | `datetime` | | ☐ | | | `activity_createdAt` | `datetime` | | ☐ | | | `activity_deletedAt` | `datetime` | | ☐ | | | `activity_extraFields` | `string` | | ☐ | | | `activity_id` | `string` | | ☐ | | | `activity_lockedAt` | `datetime` | | ☐ | | | `activity_name` | `string` | | ☐ | | | `activity_updatedAt` | `datetime` | | ☐ | | | `activityId` | `string` | Activity ID | ☐ | | | `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 | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `discount` | `decimal` | Discount | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `generalLedgerAccount__metadata_description` | `string` | | ☐ | | | `generalLedgerAccount__metadata_href` | `string` | | ☐ | | | `generalLedgerAccount__metadata_resource` | `string` | | ☐ | | | `generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | | | `generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `generalLedgerAccount_code` | `string` | | ☐ | | | `generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `generalLedgerAccount_extraFields` | `string` | | ☐ | | | `generalLedgerAccount_id` | `string` | | ☐ | | | `generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `generalLedgerAccount_name` | `string` | | ☐ | | | `generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `generalLedgerAccountId` | `string` | Ledger Account ID | ☐ | | | `id` | `string` | ID | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `material__metadata_description` | `string` | | ☐ | | | `material__metadata_href` | `string` | | ☐ | | | `material__metadata_resource` | `string` | | ☐ | | | `material__metadata_resourceTypeId` | `string` | | ☐ | | | `material_archivedAt` | `datetime` | | ☐ | | | `material_article_activityId` | `string` | | ☐ | | | `material_article_archivedAt` | `datetime` | | ☐ | | | `material_article_articleGroupId` | `string` | | ☐ | | | `material_article_articleNumber` | `string` | | ☐ | | | `material_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. | | `material_article_backorderStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `material_article_barcode` | `string` | | ☐ | | | `material_article_brand` | `string` | | ☐ | | | `material_article_calculationType` | `string` | | ☐ | | | `material_article_costPrice` | `decimal` | | ☐ | | | `material_article_costPriceStrategy` | `string` | | ☐ | | | `material_article_createdAt` | `datetime` | | ☐ | | | `material_article_deletedAt` | `datetime` | | ☐ | | | `material_article_description` | `string` | | ☐ | | | `material_article_descriptionTranslations` | `string` | | ☐ | | | `material_article_extraFields` | `string` | | ☐ | | | `material_article_id` | `string` | | ☐ | | | `material_article_installation` | `boolean` | | ☐ | | | `material_article_lockedAt` | `datetime` | | ☐ | | | `material_article_margin` | `decimal` | | ☐ | | | `material_article_minimumStock` | `decimal` | | ☐ | | | `material_article_name` | `string` | | ☐ | | | `material_article_nameTranslations` | `string` | | ☐ | | | `material_article_purchaseGLAccountId` | `string` | | ☐ | | | `material_article_reservedStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `material_article_saleName` | `string` | | ☐ | | | `material_article_salePrice` | `decimal` | | ☐ | | | `material_article_salePriceStrategy` | `string` | | ☐ | | | `material_article_salesGLAccountId` | `string` | | ☐ | | | `material_article_stockArticle` | `boolean` | | ☐ | | | `material_article_stockPlace` | `string` | | ☐ | | | `material_article_targetStock` | `decimal` | | ☐ | | | `material_article_timeOperation` | `boolean` | | ☐ | | | `material_article_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `material_article_type` | `string` | | ☐ | | | `material_article_unitType` | `string` | | ☐ | | | `material_article_updatedAt` | `datetime` | | ☐ | | | `material_article_vatTariffId` | `string` | | ☐ | | | `material_article_wappy` | `boolean` | | ☐ | | | `material_articleId` | `string` | | ☐ | | | `material_assignedClient_archivedAt` | `datetime` | | ☐ | | | `material_assignedClient_assignedUserId` | `string` | | ☐ | | | `material_assignedClient_createdAt` | `datetime` | | ☐ | | | `material_assignedClient_creditStatus` | `string` | | ☐ | | | `material_assignedClient_deletedAt` | `datetime` | | ☐ | | | `material_assignedClient_email` | `string` | | ☐ | | | `material_assignedClient_extraFields` | `string` | | ☐ | | | `material_assignedClient_fax` | `string` | | ☐ | | | `material_assignedClient_followUpDate` | `datetime` | | ☐ | | | `material_assignedClient_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedClient_gsm` | `string` | | ☐ | | | `material_assignedClient_id` | `string` | | ☐ | | | `material_assignedClient_invoiceEmail` | `string` | | ☐ | | | `material_assignedClient_language` | `string` | | ☐ | | | `material_assignedClient_legalFormId` | `string` | | ☐ | | | `material_assignedClient_lockedAt` | `datetime` | | ☐ | | | `material_assignedClient_name` | `string` | | ☐ | | | `material_assignedClient_paymentConditionId` | `string` | | ☐ | | | `material_assignedClient_priceGroupId` | `string` | | ☐ | | | `material_assignedClient_status` | `string` | | ☐ | | | `material_assignedClient_tel` | `string` | | ☐ | | | `material_assignedClient_title` | `string` | | ☐ | | | `material_assignedClient_updatedAt` | `datetime` | | ☐ | | | `material_assignedClient_vatIdNumber` | `string` | | ☐ | | | `material_assignedClient_vatTariffId` | `string` | | ☐ | | | `material_assignedClient_website` | `string` | | ☐ | | | `material_assignedClientId` | `string` | | ☐ | | | `material_assignedEmployee_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_bankAccountNumber` | `string` | | ☐ | | | `material_assignedEmployee_civilStatus` | `string` | | ☐ | | | `material_assignedEmployee_collaborationEndDate` | `datetime` | | ☐ | | | `material_assignedEmployee_collaborationStartDate` | `datetime` | | ☐ | | | `material_assignedEmployee_competenceLevel` | `string` | | ☐ | | | `material_assignedEmployee_costPerHour` | `decimal` | | ☐ | | | `material_assignedEmployee_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_dateOfBirth` | `datetime` | | ☐ | | | `material_assignedEmployee_defaultStockLocationId` | `string` | | ☐ | | | `material_assignedEmployee_defaultTimeOperationId` | `string` | | ☐ | | | `material_assignedEmployee_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_dimonaExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_dimonaNumber` | `string` | | ☐ | | | `material_assignedEmployee_distance` | `decimal` | | ☐ | | | `material_assignedEmployee_driverLicense` | `string` | | ☐ | | | `material_assignedEmployee_email` | `string` | | ☐ | | | `material_assignedEmployee_emergencyTel` | `string` | | ☐ | | | `material_assignedEmployee_employeeRoleId` | `string` | | ☐ | | | `material_assignedEmployee_employerId` | `string` | | ☐ | | | `material_assignedEmployee_extraFields` | `string` | | ☐ | | | `material_assignedEmployee_grossSalary` | `decimal` | | ☐ | | | `material_assignedEmployee_gsm` | `string` | | ☐ | | | `material_assignedEmployee_id` | `string` | | ☐ | | | `material_assignedEmployee_identityCardExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_identityCardNumber` | `string` | | ☐ | | | `material_assignedEmployee_independentRegistration` | `boolean` | | ☐ | | | `material_assignedEmployee_limosaExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_limosaNumber` | `string` | | ☐ | | | `material_assignedEmployee_lockedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_name` | `string` | | ☐ | | | `material_assignedEmployee_nationality` | `string` | | ☐ | | | `material_assignedEmployee_nssoIdNumber` | `string` | | ☐ | | | `material_assignedEmployee_nssoPayment` | `boolean` | | ☐ | | | `material_assignedEmployee_nssoPaymentExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_numberOfDependents` | `int32` | | ☐ | | | `material_assignedEmployee_planningGroup` | `string` | | ☐ | | | `material_assignedEmployee_position` | `string` | | ☐ | | | `material_assignedEmployee_secondment` | `boolean` | | ☐ | | | `material_assignedEmployee_status` | `string` | | ☐ | | | `material_assignedEmployee_statute` | `string` | | ☐ | | | `material_assignedEmployee_subType` | `string` | | ☐ | | | `material_assignedEmployee_surname` | `string` | | ☐ | | | `material_assignedEmployee_tel` | `string` | | ☐ | | | `material_assignedEmployee_type` | `string` | | ☐ | | | `material_assignedEmployee_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployeeId` | `string` | | ☐ | | | `material_assignedProject_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_checkInAtWork` | `string` | | ☐ | | | `material_assignedProject_clientContactId` | `string` | | ☐ | | | `material_assignedProject_clientId` | `string` | | ☐ | | | `material_assignedProject_clientReference` | `string` | | ☐ | | | `material_assignedProject_companyId` | `string` | | ☐ | | | `material_assignedProject_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_date` | `datetime` | | ☐ | | | `material_assignedProject_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_distance` | `int32` | | ☐ | | | `material_assignedProject_endClientContactId` | `string` | | ☐ | | | `material_assignedProject_endClientId` | `string` | | ☐ | | | `material_assignedProject_extraFields` | `string` | | ☐ | | | `material_assignedProject_geofence` | `string` | | ☐ | | | `material_assignedProject_id` | `string` | | ☐ | | | `material_assignedProject_lockedAt` | `datetime` | | ☐ | | | `material_assignedProject_logicId` | `string` | | ☐ | | | `material_assignedProject_nssoDeclarationOfWorks` | `string` | | ☐ | | | `material_assignedProject_planningGroup` | `string` | | ☐ | | | `material_assignedProject_planningName` | `string` | | ☐ | | | `material_assignedProject_siteManagerId` | `string` | | ☐ | | | `material_assignedProject_siteNssoIdNumber` | `string` | | ☐ | | | `material_assignedProject_status` | `string` | | ☐ | | | `material_assignedProject_updatedAt` | `datetime` | | ☐ | | | `material_assignedProjectId` | `string` | | ☐ | | | `material_assignedSubcontractor_archivedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_createdAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_deletedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_email` | `string` | | ☐ | | | `material_assignedSubcontractor_extraFields` | `string` | | ☐ | | | `material_assignedSubcontractor_fax` | `string` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedSubcontractor_gsm` | `string` | | ☐ | | | `material_assignedSubcontractor_iban` | `string` | | ☐ | | | `material_assignedSubcontractor_id` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceRemarks` | `string` | | ☐ | | | `material_assignedSubcontractor_kvk` | `string` | | ☐ | | | `material_assignedSubcontractor_language` | `string` | | ☐ | | | `material_assignedSubcontractor_legalFormId` | `string` | | ☐ | | | `material_assignedSubcontractor_lockedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_logicId` | `string` | | ☐ | | | `material_assignedSubcontractor_name` | `string` | | ☐ | | | `material_assignedSubcontractor_paymentConditionId` | `string` | | ☐ | | | `material_assignedSubcontractor_planningEmail` | `string` | | ☐ | | | `material_assignedSubcontractor_status` | `string` | | ☐ | | | `material_assignedSubcontractor_supplyOrderRemarks` | `string` | | ☐ | | | `material_assignedSubcontractor_tel` | `string` | | ☐ | | | `material_assignedSubcontractor_type` | `string` | | ☐ | | | `material_assignedSubcontractor_updatedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_vatIdNumber` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariffId` | `string` | | ☐ | | | `material_assignedSubcontractor_website` | `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_stockLocation_archivedAt` | `datetime` | | ☐ | | | `material_stockLocation_createdAt` | `datetime` | | ☐ | | | `material_stockLocation_deletedAt` | `datetime` | | ☐ | | | `material_stockLocation_extraFields` | `string` | | ☐ | | | `material_stockLocation_id` | `string` | | ☐ | | | `material_stockLocation_lockedAt` | `datetime` | | ☐ | | | `material_stockLocation_name` | `string` | | ☐ | | | `material_stockLocation_updatedAt` | `datetime` | | ☐ | | | `material_stockLocationId` | `string` | | ☐ | | | `material_supplier_archivedAt` | `datetime` | | ☐ | | | `material_supplier_createdAt` | `datetime` | | ☐ | | | `material_supplier_deletedAt` | `datetime` | | ☐ | | | `material_supplier_email` | `string` | | ☐ | | | `material_supplier_extraFields` | `string` | | ☐ | | | `material_supplier_fax` | `string` | | ☐ | | | `material_supplier_generalLedgerAccountId` | `string` | | ☐ | | | `material_supplier_gsm` | `string` | | ☐ | | | `material_supplier_iban` | `string` | | ☐ | | | `material_supplier_id` | `string` | | ☐ | | | `material_supplier_invoiceRemarks` | `string` | | ☐ | | | `material_supplier_kvk` | `string` | | ☐ | | | `material_supplier_language` | `string` | | ☐ | | | `material_supplier_legalFormId` | `string` | | ☐ | | | `material_supplier_lockedAt` | `datetime` | | ☐ | | | `material_supplier_logicId` | `string` | | ☐ | | | `material_supplier_name` | `string` | | ☐ | | | `material_supplier_paymentConditionId` | `string` | | ☐ | | | `material_supplier_planningEmail` | `string` | | ☐ | | | `material_supplier_status` | `string` | | ☐ | | | `material_supplier_supplyOrderRemarks` | `string` | | ☐ | | | `material_supplier_tel` | `string` | | ☐ | | | `material_supplier_type` | `string` | | ☐ | | | `material_supplier_updatedAt` | `datetime` | | ☐ | | | `material_supplier_vatIdNumber` | `string` | | ☐ | | | `material_supplier_vatTariffId` | `string` | | ☐ | | | `material_supplier_website` | `string` | | ☐ | | | `material_supplierId` | `string` | | ☐ | | | `material_updatedAt` | `datetime` | | ☐ | | | `materialId` | `string` | Material ID | ☐ | | | `postId` | `string` | Post ID | ☐ | | | `price` | `decimal` | Price | ☐ | | | `project__metadata_description` | `string` | | ☐ | | | `project__metadata_href` | `string` | | ☐ | | | `project__metadata_resource` | `string` | | ☐ | | | `project__metadata_resourceTypeId` | `string` | | ☐ | | | `project_archivedAt` | `datetime` | | ☐ | | | `project_checkInAtWork` | `string` | | ☐ | | | `project_client_archivedAt` | `datetime` | | ☐ | | | `project_client_assignedUserId` | `string` | | ☐ | | | `project_client_createdAt` | `datetime` | | ☐ | | | `project_client_creditStatus` | `string` | | ☐ | | | `project_client_deletedAt` | `datetime` | | ☐ | | | `project_client_email` | `string` | | ☐ | | | `project_client_extraFields` | `string` | | ☐ | | | `project_client_fax` | `string` | | ☐ | | | `project_client_followUpDate` | `datetime` | | ☐ | | | `project_client_generalLedgerAccountId` | `string` | | ☐ | | | `project_client_gsm` | `string` | | ☐ | | | `project_client_id` | `string` | | ☐ | | | `project_client_invoiceEmail` | `string` | | ☐ | | | `project_client_language` | `string` | | ☐ | | | `project_client_legalFormId` | `string` | | ☐ | | | `project_client_lockedAt` | `datetime` | | ☐ | | | `project_client_name` | `string` | | ☐ | | | `project_client_paymentConditionId` | `string` | | ☐ | | | `project_client_priceGroupId` | `string` | | ☐ | | | `project_client_status` | `string` | | ☐ | | | `project_client_tel` | `string` | | ☐ | | | `project_client_title` | `string` | | ☐ | | | `project_client_updatedAt` | `datetime` | | ☐ | | | `project_client_vatIdNumber` | `string` | | ☐ | | | `project_client_vatTariffId` | `string` | | ☐ | | | `project_client_website` | `string` | | ☐ | | | `project_clientContact_archivedAt` | `datetime` | | ☐ | | | `project_clientContact_createdAt` | `datetime` | | ☐ | | | `project_clientContact_deletedAt` | `datetime` | | ☐ | | | `project_clientContact_email` | `string` | | ☐ | | | `project_clientContact_extraFields` | `string` | | ☐ | | | `project_clientContact_gsm` | `string` | | ☐ | | | `project_clientContact_id` | `string` | | ☐ | | | `project_clientContact_lockedAt` | `datetime` | | ☐ | | | `project_clientContact_name` | `string` | | ☐ | | | `project_clientContact_position` | `string` | | ☐ | | | `project_clientContact_surname` | `string` | | ☐ | | | `project_clientContact_tel` | `string` | | ☐ | | | `project_clientContact_title` | `string` | | ☐ | | | `project_clientContact_updatedAt` | `datetime` | | ☐ | | | `project_clientContactId` | `string` | | ☐ | | | `project_clientId` | `string` | | ☐ | | | `project_clientReference` | `string` | | ☐ | | | `project_company_archivedAt` | `datetime` | | ☐ | | | `project_company_createdAt` | `datetime` | | ☐ | | | `project_company_deletedAt` | `datetime` | | ☐ | | | `project_company_extraFields` | `string` | | ☐ | | | `project_company_id` | `string` | | ☐ | | | `project_company_lockedAt` | `datetime` | | ☐ | | | `project_company_name` | `string` | | ☐ | | | `project_company_updatedAt` | `datetime` | | ☐ | | | `project_companyId` | `string` | | ☐ | | | `project_createdAt` | `datetime` | | ☐ | | | `project_date` | `datetime` | | ☐ | | | `project_deletedAt` | `datetime` | | ☐ | | | `project_distance` | `int32` | | ☐ | | | `project_endClient_archivedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUserId` | `string` | | ☐ | | | `project_endClient_createdAt` | `datetime` | | ☐ | | | `project_endClient_creditStatus` | `string` | | ☐ | | | `project_endClient_deletedAt` | `datetime` | | ☐ | | | `project_endClient_email` | `string` | | ☐ | | | `project_endClient_extraFields` | `string` | | ☐ | | | `project_endClient_fax` | `string` | | ☐ | | | `project_endClient_followUpDate` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccountId` | `string` | | ☐ | | | `project_endClient_gsm` | `string` | | ☐ | | | `project_endClient_id` | `string` | | ☐ | | | `project_endClient_invoiceEmail` | `string` | | ☐ | | | `project_endClient_language` | `string` | | ☐ | | | `project_endClient_legalFormId` | `string` | | ☐ | | | `project_endClient_lockedAt` | `datetime` | | ☐ | | | `project_endClient_name` | `string` | | ☐ | | | `project_endClient_paymentConditionId` | `string` | | ☐ | | | `project_endClient_priceGroupId` | `string` | | ☐ | | | `project_endClient_status` | `string` | | ☐ | | | `project_endClient_tel` | `string` | | ☐ | | | `project_endClient_title` | `string` | | ☐ | | | `project_endClient_updatedAt` | `datetime` | | ☐ | | | `project_endClient_vatIdNumber` | `string` | | ☐ | | | `project_endClient_vatTariffId` | `string` | | ☐ | | | `project_endClient_website` | `string` | | ☐ | | | `project_endClientContact_archivedAt` | `datetime` | | ☐ | | | `project_endClientContact_createdAt` | `datetime` | | ☐ | | | `project_endClientContact_deletedAt` | `datetime` | | ☐ | | | `project_endClientContact_email` | `string` | | ☐ | | | `project_endClientContact_extraFields` | `string` | | ☐ | | | `project_endClientContact_gsm` | `string` | | ☐ | | | `project_endClientContact_id` | `string` | | ☐ | | | `project_endClientContact_lockedAt` | `datetime` | | ☐ | | | `project_endClientContact_name` | `string` | | ☐ | | | `project_endClientContact_position` | `string` | | ☐ | | | `project_endClientContact_surname` | `string` | | ☐ | | | `project_endClientContact_tel` | `string` | | ☐ | | | `project_endClientContact_title` | `string` | | ☐ | | | `project_endClientContact_updatedAt` | `datetime` | | ☐ | | | `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_siteAddress_addressLine1` | `string` | | ☐ | | | `project_siteAddress_addressLine2` | `string` | | ☐ | | | `project_siteAddress_city` | `string` | | ☐ | | | `project_siteAddress_country` | `string` | | ☐ | | | `project_siteAddress_latitude` | `double` | | ☐ | | | `project_siteAddress_longitude` | `double` | | ☐ | | | `project_siteAddress_postalCode` | `string` | | ☐ | | | `project_siteManager_archivedAt` | `datetime` | | ☐ | | | `project_siteManager_createdAt` | `datetime` | | ☐ | | | `project_siteManager_deletedAt` | `datetime` | | ☐ | | | `project_siteManager_email` | `string` | | ☐ | | | `project_siteManager_emailAccountActive` | `boolean` | | ☐ | | | `project_siteManager_extraFields` | `string` | | ☐ | | | `project_siteManager_fullName` | `string` | | ☐ | | | `project_siteManager_id` | `string` | | ☐ | | | `project_siteManager_locale` | `string` | | ☐ | | | `project_siteManager_locked` | `boolean` | | ☐ | | | `project_siteManager_lockedAt` | `datetime` | | ☐ | | | `project_siteManager_updatedAt` | `datetime` | | ☐ | | | `project_siteManagerId` | `string` | | ☐ | | | `project_siteNssoIdNumber` | `string` | | ☐ | | | `project_status` | `string` | | ☐ | | | `project_statusDetails_color` | `string` | | ☐ | | | `project_statusDetails_name` | `string` | | ☐ | | | `project_updatedAt` | `datetime` | | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `purchaseInvoiceId` | `string` | Purchase Invoice ID | ☐ | Only present when obtained via bulk endpoint | | `quantity` | `decimal` | Quantity | ☐ | | | `styleName` | `string` | Style Name | ☐ | | | `supplyOrderId` | `string` | Delivery Order ID | ☐ | | | `type` | `string` | Type | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `vatTariff__metadata_description` | `string` | | ☐ | | | `vatTariff__metadata_href` | `string` | | ☐ | | | `vatTariff__metadata_resource` | `string` | | ☐ | | | `vatTariff__metadata_resourceTypeId` | `string` | | ☐ | | | `vatTariff_additionalMention` | `string` | | ☐ | | | `vatTariff_archivedAt` | `datetime` | | ☐ | | | `vatTariff_category` | `string` | | ☐ | | | `vatTariff_createdAt` | `datetime` | | ☐ | | | `vatTariff_deletedAt` | `datetime` | | ☐ | | | `vatTariff_description` | `string` | | ☐ | | | `vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `vatTariff_extraFields` | `string` | | ☐ | | | `vatTariff_id` | `string` | | ☐ | | | `vatTariff_inclusive` | `boolean` | | ☐ | | | `vatTariff_lockedAt` | `datetime` | | ☐ | | | `vatTariff_name` | `string` | | ☐ | | | `vatTariff_percentage` | `decimal` | | ☐ | | | `vatTariff_updatedAt` | `datetime` | | ☐ | | | `vatTariffId` | `string` | VAT Rate ID | ☐ | |