# OfferCalculationLineIdsByOfferId Find one - Catalog: `Robaws` - Schema: `OfferLineItems` - Select Robaws API URL: `/api/v2/offers/{offerId}/line-items/{id}` - Insert Robaws API URL: `/api/v2/offers/{offerId}/line-items/{id}` - Update Robaws API URL: `/api/v2/offers/{offerId}/line-items/{id}` - Delete Robaws API URL: `/api/v2/offers/{offerId}/line-items/{id}` - Field Selection Method: NotRequired - Base Path: `calculationLineItems[*]` - Select Robaws API Operation: `get /api/v2/offers/{offerId}/line-items/{id}` This is a read-only table function. The Robaws API may not support changing the data or the Invantive SQL driver for Robaws does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Robaws API. ## Columns of Table Function The columns of the table function `OfferCalculationLineIdsByOfferId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity_archivedAt` | `datetime` | | ☐ | | | `activity_createdAt` | `datetime` | | ☐ | | | `activity_deletedAt` | `datetime` | | ☐ | | | `activity_id` | `string` | | ☐ | | | `activity_name` | `string` | | ☐ | | | `activity_updatedAt` | `datetime` | | ☐ | | | `activityId` | `string` | | ☐ | | | `agreementType` | `string` | Agreement Type | ☐ | | | `archivedAt` | `datetime` | | ☐ | | | `article_archivedAt_1` | `datetime` | | ☐ | | | `article_archivedAt` | `datetime` | | ☐ | | | `article_articleGroupId_1` | `string` | | ☐ | | | `article_articleGroupId` | `string` | | ☐ | | | `article_articleNumber_1` | `string` | | ☐ | | | `article_articleNumber` | `string` | | ☐ | | | `article_availableStock_1` | `decimal` | | ☐ | This property should be used by third parties (for example webshops) that want to know how much stockis available for sale.When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_availableStock` | `decimal` | | ☐ | This property should be used by third parties (for example webshops) that want to know how much stockis available for sale.When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_barcode_1` | `string` | | ☐ | | | `article_barcode` | `string` | Article Bar Code | ☐ | | | `article_brand_1` | `string` | | ☐ | | | `article_brand` | `string` | | ☐ | | | `article_costPrice_1` | `decimal` | | ☐ | | | `article_costPrice` | `decimal` | | ☐ | | | `article_costPriceStrategy_1` | `string` | | ☐ | | | `article_costPriceStrategy` | `string` | | ☐ | | | `article_createdAt_1` | `datetime` | | ☐ | | | `article_createdAt` | `datetime` | | ☐ | | | `article_deletedAt_1` | `datetime` | | ☐ | | | `article_deletedAt` | `datetime` | | ☐ | | | `article_description_1` | `string` | | ☐ | | | `article_description` | `string` | | ☐ | | | `article_group_archivedAt_1` | `datetime` | | ☐ | | | `article_group_archivedAt` | `datetime` | | ☐ | | | `article_group_createdAt_1` | `datetime` | | ☐ | | | `article_group_createdAt` | `datetime` | | ☐ | | | `article_group_deletedAt_1` | `datetime` | | ☐ | | | `article_group_deletedAt` | `datetime` | | ☐ | | | `article_group_id_1` | `string` | | ☐ | | | `article_group_id` | `string` | | ☐ | | | `article_group_image_archivedAt_1` | `datetime` | | ☐ | | | `article_group_image_archivedAt` | `datetime` | | ☐ | | | `article_group_image_contentType_1` | `string` | | ☐ | | | `article_group_image_contentType` | `string` | | ☐ | | | `article_group_image_createdAt_1` | `datetime` | | ☐ | | | `article_group_image_createdAt` | `datetime` | | ☐ | | | `article_group_image_deletedAt_1` | `datetime` | | ☐ | | | `article_group_image_deletedAt` | `datetime` | | ☐ | | | `article_group_image_directory_1` | `boolean` | | ☐ | | | `article_group_image_directory` | `boolean` | | ☐ | | | `article_group_image_id_1` | `string` | | ☐ | | | `article_group_image_id` | `string` | | ☐ | | | `article_group_image_name_1` | `string` | | ☐ | | | `article_group_image_name` | `string` | | ☐ | | | `article_group_image_parentId_1` | `string` | | ☐ | | | `article_group_image_parentId` | `string` | | ☐ | | | `article_group_image_previewUrl_1` | `string` | | ☐ | | | `article_group_image_previewUrl` | `string` | | ☐ | | | `article_group_image_size_1` | `int64` | | ☐ | | | `article_group_image_size` | `int64` | | ☐ | | | `article_group_image_updatedAt_1` | `datetime` | | ☐ | | | `article_group_image_updatedAt` | `datetime` | | ☐ | | | `article_group_image_url_1` | `string` | | ☐ | | | `article_group_image_url` | `string` | | ☐ | | | `article_group_name_1` | `string` | | ☐ | | | `article_group_name` | `string` | | ☐ | | | `article_group_parentId_1` | `string` | | ☐ | | | `article_group_parentId` | `string` | | ☐ | | | `article_group_updatedAt_1` | `datetime` | | ☐ | | | `article_group_updatedAt` | `datetime` | | ☐ | | | `article_id_1` | `string` | | ☐ | | | `article_id` | `string` | Article ID | ☐ | | | `article_image_archivedAt_1` | `datetime` | | ☐ | | | `article_image_archivedAt` | `datetime` | | ☐ | | | `article_image_contentType_1` | `string` | | ☐ | | | `article_image_contentType` | `string` | | ☐ | | | `article_image_createdAt_1` | `datetime` | | ☐ | | | `article_image_createdAt` | `datetime` | | ☐ | | | `article_image_deletedAt_1` | `datetime` | | ☐ | | | `article_image_deletedAt` | `datetime` | | ☐ | | | `article_image_directory_1` | `boolean` | | ☐ | | | `article_image_directory` | `boolean` | | ☐ | | | `article_image_id_1` | `string` | | ☐ | | | `article_image_id` | `string` | | ☐ | | | `article_image_name_1` | `string` | | ☐ | | | `article_image_name` | `string` | | ☐ | | | `article_image_parentId_1` | `string` | | ☐ | | | `article_image_parentId` | `string` | | ☐ | | | `article_image_previewUrl_1` | `string` | | ☐ | | | `article_image_previewUrl` | `string` | | ☐ | | | `article_image_size_1` | `int64` | | ☐ | | | `article_image_size` | `int64` | | ☐ | | | `article_image_updatedAt_1` | `datetime` | | ☐ | | | `article_image_updatedAt` | `datetime` | | ☐ | | | `article_image_url_1` | `string` | | ☐ | | | `article_image_url` | `string` | | ☐ | | | `article_name_1` | `string` | | ☐ | | | `article_name` | `string` | | ☐ | | | `article_saleName_1` | `string` | | ☐ | | | `article_saleName` | `string` | | ☐ | | | `article_salePrice_1` | `decimal` | | ☐ | | | `article_salePrice` | `decimal` | | ☐ | | | `article_salePriceStrategy_1` | `string` | | ☐ | | | `article_salePriceStrategy` | `string` | | ☐ | | | `article_stockArticle_1` | `boolean` | | ☐ | | | `article_stockArticle` | `boolean` | | ☐ | | | `article_stockPlace_1` | `string` | | ☐ | | | `article_stockPlace` | `string` | | ☐ | | | `article_timeOperation_1` | `boolean` | | ☐ | | | `article_timeOperation` | `boolean` | | ☐ | | | `article_totalStock_1` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `article_unitType_1` | `string` | | ☐ | | | `article_unitType` | `string` | | ☐ | | | `article_updatedAt_1` | `datetime` | | ☐ | | | `article_updatedAt` | `datetime` | | ☐ | | | `article_vatTariffId_1` | `string` | | ☐ | | | `article_vatTariffId` | `string` | | ☐ | | | `articleId_1` | `string` | | ☐ | | | `articleId` | `string` | | ☐ | | | `calculationType` | `string` | Calculation Type | ☐ | | | `chapter` | `string` | Chapter | ☐ | | | `costPrice` | `decimal` | Cost Price | ☐ | | | `createdAt` | `datetime` | | ☐ | | | `customPrice` | `boolean` | Custom Price | ☐ | | | `deletedAt` | `datetime` | | ☐ | | | `description_1` | `string` | | ☐ | | | `description` | `string` | Description | ☐ | | | `discount` | `decimal` | Discount | ☐ | | | `extendedDescription` | `string` | | ☐ | | | `extendedDescriptionRendered` | `string` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `id` | `string` | ID | ☐ | | | `image_archivedAt` | `datetime` | | ☐ | | | `image_contentType` | `string` | | ☐ | | | `image_createdAt` | `datetime` | | ☐ | | | `image_deletedAt` | `datetime` | | ☐ | | | `image_directory` | `boolean` | | ☐ | | | `image_id` | `string` | | ☐ | | | `image_name` | `string` | | ☐ | | | `image_parentId` | `string` | | ☐ | | | `image_previewUrl` | `string` | | ☐ | | | `image_size` | `int64` | | ☐ | | | `image_updatedAt` | `datetime` | | ☐ | | | `image_url` | `string` | | ☐ | | | `margin` | `decimal` | Margin | ☐ | | | `material_archivedAt` | `datetime` | | ☐ | | | `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 stockis available for sale.When reading, only present if requested via 'include' query parameter, otherwise null. | | `material_article_barcode` | `string` | | ☐ | | | `material_article_brand` | `string` | | ☐ | | | `material_article_costPrice` | `decimal` | | ☐ | | | `material_article_costPriceStrategy` | `string` | | ☐ | | | `material_article_createdAt` | `datetime` | | ☐ | | | `material_article_deletedAt` | `datetime` | | ☐ | | | `material_article_description` | `string` | | ☐ | | | `material_article_group_archivedAt` | `datetime` | | ☐ | | | `material_article_group_createdAt` | `datetime` | | ☐ | | | `material_article_group_deletedAt` | `datetime` | | ☐ | | | `material_article_group_id` | `string` | | ☐ | | | `material_article_group_image_archivedAt` | `datetime` | | ☐ | | | `material_article_group_image_contentType` | `string` | | ☐ | | | `material_article_group_image_createdAt` | `datetime` | | ☐ | | | `material_article_group_image_deletedAt` | `datetime` | | ☐ | | | `material_article_group_image_directory` | `boolean` | | ☐ | | | `material_article_group_image_id` | `string` | | ☐ | | | `material_article_group_image_name` | `string` | | ☐ | | | `material_article_group_image_parentId` | `string` | | ☐ | | | `material_article_group_image_previewUrl` | `string` | | ☐ | | | `material_article_group_image_size` | `int64` | | ☐ | | | `material_article_group_image_updatedAt` | `datetime` | | ☐ | | | `material_article_group_image_url` | `string` | | ☐ | | | `material_article_group_name` | `string` | | ☐ | | | `material_article_group_parentId` | `string` | | ☐ | | | `material_article_group_updatedAt` | `datetime` | | ☐ | | | `material_article_id` | `string` | | ☐ | | | `material_article_image_archivedAt` | `datetime` | | ☐ | | | `material_article_image_contentType` | `string` | | ☐ | | | `material_article_image_createdAt` | `datetime` | | ☐ | | | `material_article_image_deletedAt` | `datetime` | | ☐ | | | `material_article_image_directory` | `boolean` | | ☐ | | | `material_article_image_id` | `string` | | ☐ | | | `material_article_image_name` | `string` | | ☐ | | | `material_article_image_parentId` | `string` | | ☐ | | | `material_article_image_previewUrl` | `string` | | ☐ | | | `material_article_image_size` | `int64` | | ☐ | | | `material_article_image_updatedAt` | `datetime` | | ☐ | | | `material_article_image_url` | `string` | | ☐ | | | `material_article_name` | `string` | | ☐ | | | `material_article_saleName` | `string` | | ☐ | | | `material_article_salePrice` | `decimal` | | ☐ | | | `material_article_salePriceStrategy` | `string` | | ☐ | | | `material_article_stockArticle` | `boolean` | | ☐ | | | `material_article_stockPlace` | `string` | | ☐ | | | `material_article_timeOperation` | `boolean` | | ☐ | | | `material_article_totalStock` | `decimal` | | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `material_article_unitType` | `string` | | ☐ | | | `material_article_updatedAt` | `datetime` | | ☐ | | | `material_article_vatTariffId` | `string` | | ☐ | | | `material_articleId` | `string` | | ☐ | | | `material_assignedClient_address_addressLine1` | `string` | | ☐ | | | `material_assignedClient_address_addressLine2` | `string` | | ☐ | | | `material_assignedClient_address_city` | `string` | | ☐ | | | `material_assignedClient_address_country` | `string` | | ☐ | | | `material_assignedClient_address_latitude` | `double` | | ☐ | | | `material_assignedClient_address_longitude` | `double` | | ☐ | | | `material_assignedClient_address_postalCode` | `string` | | ☐ | | | `material_assignedClient_archivedAt` | `datetime` | | ☐ | | | `material_assignedClient_assignedUserId` | `string` | | ☐ | | | `material_assignedClient_createdAt` | `datetime` | | ☐ | | | `material_assignedClient_deletedAt` | `datetime` | | ☐ | | | `material_assignedClient_email` | `string` | | ☐ | | | `material_assignedClient_fax` | `string` | | ☐ | | | `material_assignedClient_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `material_assignedClient_generalLedgerAccount_code` | `string` | | ☐ | | | `material_assignedClient_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `material_assignedClient_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `material_assignedClient_generalLedgerAccount_id` | `string` | | ☐ | | | `material_assignedClient_generalLedgerAccount_name` | `string` | | ☐ | | | `material_assignedClient_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `material_assignedClient_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedClient_gsm` | `string` | | ☐ | | | `material_assignedClient_id` | `string` | | ☐ | | | `material_assignedClient_invoiceAddress_addressLine1` | `string` | | ☐ | | | `material_assignedClient_invoiceAddress_addressLine2` | `string` | | ☐ | | | `material_assignedClient_invoiceAddress_city` | `string` | | ☐ | | | `material_assignedClient_invoiceAddress_country` | `string` | | ☐ | | | `material_assignedClient_invoiceAddress_latitude` | `double` | | ☐ | | | `material_assignedClient_invoiceAddress_longitude` | `double` | | ☐ | | | `material_assignedClient_invoiceAddress_postalCode` | `string` | | ☐ | | | `material_assignedClient_invoiceEmail` | `string` | | ☐ | | | `material_assignedClient_language` | `string` | | ☐ | | | `material_assignedClient_legalForm_archivedAt` | `datetime` | | ☐ | | | `material_assignedClient_legalForm_createdAt` | `datetime` | | ☐ | | | `material_assignedClient_legalForm_deletedAt` | `datetime` | | ☐ | | | `material_assignedClient_legalForm_id` | `string` | | ☐ | | | `material_assignedClient_legalForm_legalAbbreviation` | `string` | | ☐ | | | `material_assignedClient_legalForm_name` | `string` | | ☐ | | | `material_assignedClient_legalForm_updatedAt` | `datetime` | | ☐ | | | `material_assignedClient_legalForm_vatLiable` | `boolean` | | ☐ | | | `material_assignedClient_legalFormId` | `string` | | ☐ | | | `material_assignedClient_name` | `string` | | ☐ | | | `material_assignedClient_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `material_assignedClient_paymentCondition_createdAt` | `datetime` | | ☐ | | | `material_assignedClient_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `material_assignedClient_paymentCondition_id` | `string` | | ☐ | | | `material_assignedClient_paymentCondition_name` | `string` | | ☐ | | | `material_assignedClient_paymentCondition_purchase` | `boolean` | | ☐ | | | `material_assignedClient_paymentCondition_sales` | `boolean` | | ☐ | | | `material_assignedClient_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `material_assignedClient_paymentConditionId` | `string` | | ☐ | | | `material_assignedClient_status` | `string` | | ☐ | | | `material_assignedClient_statusDetails_color` | `string` | | ☐ | | | `material_assignedClient_statusDetails_name` | `string` | | ☐ | | | `material_assignedClient_tel` | `string` | | ☐ | | | `material_assignedClient_title` | `string` | | ☐ | | | `material_assignedClient_updatedAt` | `datetime` | | ☐ | | | `material_assignedClient_vatIdNumber` | `string` | | ☐ | | | `material_assignedClient_vatTariff_additionalMention` | `string` | | ☐ | | | `material_assignedClient_vatTariff_archivedAt` | `datetime` | | ☐ | | | `material_assignedClient_vatTariff_category` | `string` | | ☐ | | | `material_assignedClient_vatTariff_createdAt` | `datetime` | | ☐ | | | `material_assignedClient_vatTariff_deletedAt` | `datetime` | | ☐ | | | `material_assignedClient_vatTariff_description` | `string` | | ☐ | | | `material_assignedClient_vatTariff_id` | `string` | | ☐ | | | `material_assignedClient_vatTariff_name` | `string` | | ☐ | | | `material_assignedClient_vatTariff_percentage` | `decimal` | | ☐ | | | `material_assignedClient_vatTariff_updatedAt` | `datetime` | | ☐ | | | `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_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_dimonaExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_dimonaNumber` | `string` | | ☐ | | | `material_assignedEmployee_distance` | `decimal` | | ☐ | | | `material_assignedEmployee_domicileAddress_addressLine1` | `string` | | ☐ | | | `material_assignedEmployee_domicileAddress_addressLine2` | `string` | | ☐ | | | `material_assignedEmployee_domicileAddress_city` | `string` | | ☐ | | | `material_assignedEmployee_domicileAddress_country` | `string` | | ☐ | | | `material_assignedEmployee_domicileAddress_latitude` | `double` | | ☐ | | | `material_assignedEmployee_domicileAddress_longitude` | `double` | | ☐ | | | `material_assignedEmployee_domicileAddress_postalCode` | `string` | | ☐ | | | `material_assignedEmployee_driverLicense` | `string` | | ☐ | | | `material_assignedEmployee_email` | `string` | | ☐ | | | `material_assignedEmployee_emergencyTel` | `string` | | ☐ | | | `material_assignedEmployee_employeeRole_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employeeRole_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employeeRole_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employeeRole_id` | `string` | | ☐ | | | `material_assignedEmployee_employeeRole_name` | `string` | | ☐ | | | `material_assignedEmployee_employeeRole_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employeeRoleId` | `string` | | ☐ | | | `material_assignedEmployee_employer_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_email` | `string` | | ☐ | | | `material_assignedEmployee_employer_fax` | `string` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_code` | `string` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_id` | `string` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_name` | `string` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedEmployee_employer_gsm` | `string` | | ☐ | | | `material_assignedEmployee_employer_iban` | `string` | | ☐ | | | `material_assignedEmployee_employer_id` | `string` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_addressLine1` | `string` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_addressLine2` | `string` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_city` | `string` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_country` | `string` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_latitude` | `double` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_longitude` | `double` | | ☐ | | | `material_assignedEmployee_employer_invoiceAddress_postalCode` | `string` | | ☐ | | | `material_assignedEmployee_employer_invoiceRemarks` | `string` | | ☐ | | | `material_assignedEmployee_employer_kvk` | `string` | | ☐ | | | `material_assignedEmployee_employer_language` | `string` | | ☐ | | | `material_assignedEmployee_employer_legalForm_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_legalForm_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_legalForm_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_legalForm_id` | `string` | | ☐ | | | `material_assignedEmployee_employer_legalForm_legalAbbreviation` | `string` | | ☐ | | | `material_assignedEmployee_employer_legalForm_name` | `string` | | ☐ | | | `material_assignedEmployee_employer_legalForm_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_legalForm_vatLiable` | `boolean` | | ☐ | | | `material_assignedEmployee_employer_legalFormId` | `string` | | ☐ | | | `material_assignedEmployee_employer_logicId` | `string` | | ☐ | | | `material_assignedEmployee_employer_name` | `string` | | ☐ | | | `material_assignedEmployee_employer_paymentConditionId` | `string` | | ☐ | | | `material_assignedEmployee_employer_planningEmail` | `string` | | ☐ | | | `material_assignedEmployee_employer_status` | `string` | | ☐ | | | `material_assignedEmployee_employer_supplyOrderRemarks` | `string` | | ☐ | | | `material_assignedEmployee_employer_tel` | `string` | | ☐ | | | `material_assignedEmployee_employer_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_vatIdNumber` | `string` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_additionalMention` | `string` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_category` | `string` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_description` | `string` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_id` | `string` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_name` | `string` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_percentage` | `decimal` | | ☐ | | | `material_assignedEmployee_employer_vatTariff_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_employer_vatTariffId` | `string` | | ☐ | | | `material_assignedEmployee_employer_website` | `string` | | ☐ | | | `material_assignedEmployee_employerId` | `string` | | ☐ | | | `material_assignedEmployee_grossSalary` | `decimal` | | ☐ | | | `material_assignedEmployee_gsm` | `string` | | ☐ | | | `material_assignedEmployee_id` | `string` | | ☐ | | | `material_assignedEmployee_identityCardExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_identityCardNumber` | `string` | | ☐ | | | `material_assignedEmployee_image_archivedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_image_contentType` | `string` | | ☐ | | | `material_assignedEmployee_image_createdAt` | `datetime` | | ☐ | | | `material_assignedEmployee_image_deletedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_image_directory` | `boolean` | | ☐ | | | `material_assignedEmployee_image_id` | `string` | | ☐ | | | `material_assignedEmployee_image_name` | `string` | | ☐ | | | `material_assignedEmployee_image_parentId` | `string` | | ☐ | | | `material_assignedEmployee_image_previewUrl` | `string` | | ☐ | | | `material_assignedEmployee_image_size` | `int64` | | ☐ | | | `material_assignedEmployee_image_updatedAt` | `datetime` | | ☐ | | | `material_assignedEmployee_image_url` | `string` | | ☐ | | | `material_assignedEmployee_independentRegistration` | `boolean` | | ☐ | | | `material_assignedEmployee_limosaExpirationDate` | `datetime` | | ☐ | | | `material_assignedEmployee_limosaNumber` | `string` | | ☐ | | | `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_client_address_addressLine1` | `string` | | ☐ | | | `material_assignedProject_client_address_addressLine2` | `string` | | ☐ | | | `material_assignedProject_client_address_city` | `string` | | ☐ | | | `material_assignedProject_client_address_country` | `string` | | ☐ | | | `material_assignedProject_client_address_latitude` | `double` | | ☐ | | | `material_assignedProject_client_address_longitude` | `double` | | ☐ | | | `material_assignedProject_client_address_postalCode` | `string` | | ☐ | | | `material_assignedProject_client_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_assignedUserId` | `string` | | ☐ | | | `material_assignedProject_client_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_client_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_email` | `string` | | ☐ | | | `material_assignedProject_client_fax` | `string` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_code` | `string` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_id` | `string` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_name` | `string` | | ☐ | | | `material_assignedProject_client_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedProject_client_gsm` | `string` | | ☐ | | | `material_assignedProject_client_id` | `string` | | ☐ | | | `material_assignedProject_client_invoiceAddress_addressLine1` | `string` | | ☐ | | | `material_assignedProject_client_invoiceAddress_addressLine2` | `string` | | ☐ | | | `material_assignedProject_client_invoiceAddress_city` | `string` | | ☐ | | | `material_assignedProject_client_invoiceAddress_country` | `string` | | ☐ | | | `material_assignedProject_client_invoiceAddress_latitude` | `double` | | ☐ | | | `material_assignedProject_client_invoiceAddress_longitude` | `double` | | ☐ | | | `material_assignedProject_client_invoiceAddress_postalCode` | `string` | | ☐ | | | `material_assignedProject_client_invoiceEmail` | `string` | | ☐ | | | `material_assignedProject_client_language` | `string` | | ☐ | | | `material_assignedProject_client_legalForm_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_legalForm_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_client_legalForm_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_legalForm_id` | `string` | | ☐ | | | `material_assignedProject_client_legalForm_legalAbbreviation` | `string` | | ☐ | | | `material_assignedProject_client_legalForm_name` | `string` | | ☐ | | | `material_assignedProject_client_legalForm_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_legalForm_vatLiable` | `boolean` | | ☐ | | | `material_assignedProject_client_legalFormId` | `string` | | ☐ | | | `material_assignedProject_client_name` | `string` | | ☐ | | | `material_assignedProject_client_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_paymentCondition_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_client_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_paymentCondition_id` | `string` | | ☐ | | | `material_assignedProject_client_paymentCondition_name` | `string` | | ☐ | | | `material_assignedProject_client_paymentCondition_purchase` | `boolean` | | ☐ | | | `material_assignedProject_client_paymentCondition_sales` | `boolean` | | ☐ | | | `material_assignedProject_client_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_paymentConditionId` | `string` | | ☐ | | | `material_assignedProject_client_status` | `string` | | ☐ | | | `material_assignedProject_client_statusDetails_color` | `string` | | ☐ | | | `material_assignedProject_client_statusDetails_name` | `string` | | ☐ | | | `material_assignedProject_client_tel` | `string` | | ☐ | | | `material_assignedProject_client_title` | `string` | | ☐ | | | `material_assignedProject_client_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_vatIdNumber` | `string` | | ☐ | | | `material_assignedProject_client_vatTariff_additionalMention` | `string` | | ☐ | | | `material_assignedProject_client_vatTariff_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_vatTariff_category` | `string` | | ☐ | | | `material_assignedProject_client_vatTariff_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_client_vatTariff_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_vatTariff_description` | `string` | | ☐ | | | `material_assignedProject_client_vatTariff_id` | `string` | | ☐ | | | `material_assignedProject_client_vatTariff_name` | `string` | | ☐ | | | `material_assignedProject_client_vatTariff_percentage` | `decimal` | | ☐ | | | `material_assignedProject_client_vatTariff_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_client_vatTariffId` | `string` | | ☐ | | | `material_assignedProject_client_website` | `string` | | ☐ | | | `material_assignedProject_clientContact_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_clientContact_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_clientContact_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_clientContact_email` | `string` | | ☐ | | | `material_assignedProject_clientContact_gsm` | `string` | | ☐ | | | `material_assignedProject_clientContact_id` | `string` | | ☐ | | | `material_assignedProject_clientContact_name` | `string` | | ☐ | | | `material_assignedProject_clientContact_position` | `string` | | ☐ | | | `material_assignedProject_clientContact_surname` | `string` | | ☐ | | | `material_assignedProject_clientContact_tel` | `string` | | ☐ | | | `material_assignedProject_clientContact_title` | `string` | | ☐ | | | `material_assignedProject_clientContact_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_clientContactId` | `string` | | ☐ | | | `material_assignedProject_clientId` | `string` | | ☐ | | | `material_assignedProject_clientReference` | `string` | | ☐ | | | `material_assignedProject_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_date` | `datetime` | | ☐ | | | `material_assignedProject_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_distance` | `int32` | | ☐ | | | `material_assignedProject_endClient_address_addressLine1` | `string` | | ☐ | | | `material_assignedProject_endClient_address_addressLine2` | `string` | | ☐ | | | `material_assignedProject_endClient_address_city` | `string` | | ☐ | | | `material_assignedProject_endClient_address_country` | `string` | | ☐ | | | `material_assignedProject_endClient_address_latitude` | `double` | | ☐ | | | `material_assignedProject_endClient_address_longitude` | `double` | | ☐ | | | `material_assignedProject_endClient_address_postalCode` | `string` | | ☐ | | | `material_assignedProject_endClient_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_assignedUserId` | `string` | | ☐ | | | `material_assignedProject_endClient_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_email` | `string` | | ☐ | | | `material_assignedProject_endClient_fax` | `string` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_code` | `string` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_id` | `string` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_name` | `string` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedProject_endClient_gsm` | `string` | | ☐ | | | `material_assignedProject_endClient_id` | `string` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_addressLine1` | `string` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_addressLine2` | `string` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_city` | `string` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_country` | `string` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_latitude` | `double` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_longitude` | `double` | | ☐ | | | `material_assignedProject_endClient_invoiceAddress_postalCode` | `string` | | ☐ | | | `material_assignedProject_endClient_invoiceEmail` | `string` | | ☐ | | | `material_assignedProject_endClient_language` | `string` | | ☐ | | | `material_assignedProject_endClient_legalForm_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_legalForm_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_legalForm_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_legalForm_id` | `string` | | ☐ | | | `material_assignedProject_endClient_legalForm_legalAbbreviation` | `string` | | ☐ | | | `material_assignedProject_endClient_legalForm_name` | `string` | | ☐ | | | `material_assignedProject_endClient_legalForm_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_legalForm_vatLiable` | `boolean` | | ☐ | | | `material_assignedProject_endClient_legalFormId` | `string` | | ☐ | | | `material_assignedProject_endClient_name` | `string` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_id` | `string` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_name` | `string` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_purchase` | `boolean` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_sales` | `boolean` | | ☐ | | | `material_assignedProject_endClient_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_paymentConditionId` | `string` | | ☐ | | | `material_assignedProject_endClient_status` | `string` | | ☐ | | | `material_assignedProject_endClient_statusDetails_color` | `string` | | ☐ | | | `material_assignedProject_endClient_statusDetails_name` | `string` | | ☐ | | | `material_assignedProject_endClient_tel` | `string` | | ☐ | | | `material_assignedProject_endClient_title` | `string` | | ☐ | | | `material_assignedProject_endClient_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_vatIdNumber` | `string` | | ☐ | | | `material_assignedProject_endClient_vatTariff_additionalMention` | `string` | | ☐ | | | `material_assignedProject_endClient_vatTariff_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_vatTariff_category` | `string` | | ☐ | | | `material_assignedProject_endClient_vatTariff_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_vatTariff_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_vatTariff_description` | `string` | | ☐ | | | `material_assignedProject_endClient_vatTariff_id` | `string` | | ☐ | | | `material_assignedProject_endClient_vatTariff_name` | `string` | | ☐ | | | `material_assignedProject_endClient_vatTariff_percentage` | `decimal` | | ☐ | | | `material_assignedProject_endClient_vatTariff_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClient_vatTariffId` | `string` | | ☐ | | | `material_assignedProject_endClient_website` | `string` | | ☐ | | | `material_assignedProject_endClientContact_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClientContact_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_endClientContact_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClientContact_email` | `string` | | ☐ | | | `material_assignedProject_endClientContact_gsm` | `string` | | ☐ | | | `material_assignedProject_endClientContact_id` | `string` | | ☐ | | | `material_assignedProject_endClientContact_name` | `string` | | ☐ | | | `material_assignedProject_endClientContact_position` | `string` | | ☐ | | | `material_assignedProject_endClientContact_surname` | `string` | | ☐ | | | `material_assignedProject_endClientContact_tel` | `string` | | ☐ | | | `material_assignedProject_endClientContact_title` | `string` | | ☐ | | | `material_assignedProject_endClientContact_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_endClientContactId` | `string` | | ☐ | | | `material_assignedProject_endClientId` | `string` | | ☐ | | | `material_assignedProject_id` | `string` | | ☐ | | | `material_assignedProject_logicId` | `string` | | ☐ | | | `material_assignedProject_nssoDeclarationOfWorks` | `string` | | ☐ | | | `material_assignedProject_planningName` | `string` | | ☐ | | | `material_assignedProject_siteAddress_addressLine1` | `string` | | ☐ | | | `material_assignedProject_siteAddress_addressLine2` | `string` | | ☐ | | | `material_assignedProject_siteAddress_city` | `string` | | ☐ | | | `material_assignedProject_siteAddress_country` | `string` | | ☐ | | | `material_assignedProject_siteAddress_latitude` | `double` | | ☐ | | | `material_assignedProject_siteAddress_longitude` | `double` | | ☐ | | | `material_assignedProject_siteAddress_postalCode` | `string` | | ☐ | | | `material_assignedProject_siteManager_archivedAt` | `datetime` | | ☐ | | | `material_assignedProject_siteManager_createdAt` | `datetime` | | ☐ | | | `material_assignedProject_siteManager_deletedAt` | `datetime` | | ☐ | | | `material_assignedProject_siteManager_email` | `string` | | ☐ | | | `material_assignedProject_siteManager_fullName` | `string` | | ☐ | | | `material_assignedProject_siteManager_id` | `string` | | ☐ | | | `material_assignedProject_siteManager_locked` | `boolean` | | ☐ | | | `material_assignedProject_siteManager_updatedAt` | `datetime` | | ☐ | | | `material_assignedProject_siteManagerId` | `string` | | ☐ | | | `material_assignedProject_siteNssoIdNumber` | `string` | | ☐ | | | `material_assignedProject_status` | `string` | | ☐ | | | `material_assignedProject_statusDetails_color` | `string` | | ☐ | | | `material_assignedProject_statusDetails_name` | `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_fax` | `string` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_code` | `string` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_id` | `string` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_name` | `string` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_generalLedgerAccountId` | `string` | | ☐ | | | `material_assignedSubcontractor_gsm` | `string` | | ☐ | | | `material_assignedSubcontractor_iban` | `string` | | ☐ | | | `material_assignedSubcontractor_id` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_addressLine1` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_addressLine2` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_city` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_country` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_latitude` | `double` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_longitude` | `double` | | ☐ | | | `material_assignedSubcontractor_invoiceAddress_postalCode` | `string` | | ☐ | | | `material_assignedSubcontractor_invoiceRemarks` | `string` | | ☐ | | | `material_assignedSubcontractor_kvk` | `string` | | ☐ | | | `material_assignedSubcontractor_language` | `string` | | ☐ | | | `material_assignedSubcontractor_legalForm_archivedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_legalForm_createdAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_legalForm_deletedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_legalForm_id` | `string` | | ☐ | | | `material_assignedSubcontractor_legalForm_legalAbbreviation` | `string` | | ☐ | | | `material_assignedSubcontractor_legalForm_name` | `string` | | ☐ | | | `material_assignedSubcontractor_legalForm_updatedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_legalForm_vatLiable` | `boolean` | | ☐ | | | `material_assignedSubcontractor_legalFormId` | `string` | | ☐ | | | `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_updatedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_vatIdNumber` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariff_additionalMention` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariff_archivedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_vatTariff_category` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariff_createdAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_vatTariff_deletedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_vatTariff_description` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariff_id` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariff_name` | `string` | | ☐ | | | `material_assignedSubcontractor_vatTariff_percentage` | `decimal` | | ☐ | | | `material_assignedSubcontractor_vatTariff_updatedAt` | `datetime` | | ☐ | | | `material_assignedSubcontractor_vatTariffId` | `string` | | ☐ | | | `material_assignedSubcontractor_website` | `string` | | ☐ | | | `material_assignedSubcontractorId` | `string` | | ☐ | | | `material_brand` | `string` | | ☐ | | | `material_createdAt` | `datetime` | | ☐ | | | `material_deletedAt` | `datetime` | | ☐ | | | `material_id` | `string` | | ☐ | | | `material_installation` | `boolean` | | ☐ | | | `material_name` | `string` | | ☐ | | | `material_serialNumber` | `string` | | ☐ | | | `material_status` | `string` | | ☐ | | | `material_supplier_archivedAt` | `datetime` | | ☐ | | | `material_supplier_createdAt` | `datetime` | | ☐ | | | `material_supplier_deletedAt` | `datetime` | | ☐ | | | `material_supplier_email` | `string` | | ☐ | | | `material_supplier_fax` | `string` | | ☐ | | | `material_supplier_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `material_supplier_generalLedgerAccount_code` | `string` | | ☐ | | | `material_supplier_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `material_supplier_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `material_supplier_generalLedgerAccount_id` | `string` | | ☐ | | | `material_supplier_generalLedgerAccount_name` | `string` | | ☐ | | | `material_supplier_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `material_supplier_generalLedgerAccountId` | `string` | | ☐ | | | `material_supplier_gsm` | `string` | | ☐ | | | `material_supplier_iban` | `string` | | ☐ | | | `material_supplier_id` | `string` | | ☐ | | | `material_supplier_invoiceAddress_addressLine1` | `string` | | ☐ | | | `material_supplier_invoiceAddress_addressLine2` | `string` | | ☐ | | | `material_supplier_invoiceAddress_city` | `string` | | ☐ | | | `material_supplier_invoiceAddress_country` | `string` | | ☐ | | | `material_supplier_invoiceAddress_latitude` | `double` | | ☐ | | | `material_supplier_invoiceAddress_longitude` | `double` | | ☐ | | | `material_supplier_invoiceAddress_postalCode` | `string` | | ☐ | | | `material_supplier_invoiceRemarks` | `string` | | ☐ | | | `material_supplier_kvk` | `string` | | ☐ | | | `material_supplier_language` | `string` | | ☐ | | | `material_supplier_legalForm_archivedAt` | `datetime` | | ☐ | | | `material_supplier_legalForm_createdAt` | `datetime` | | ☐ | | | `material_supplier_legalForm_deletedAt` | `datetime` | | ☐ | | | `material_supplier_legalForm_id` | `string` | | ☐ | | | `material_supplier_legalForm_legalAbbreviation` | `string` | | ☐ | | | `material_supplier_legalForm_name` | `string` | | ☐ | | | `material_supplier_legalForm_updatedAt` | `datetime` | | ☐ | | | `material_supplier_legalForm_vatLiable` | `boolean` | | ☐ | | | `material_supplier_legalFormId` | `string` | | ☐ | | | `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_updatedAt` | `datetime` | | ☐ | | | `material_supplier_vatIdNumber` | `string` | | ☐ | | | `material_supplier_vatTariff_additionalMention` | `string` | | ☐ | | | `material_supplier_vatTariff_archivedAt` | `datetime` | | ☐ | | | `material_supplier_vatTariff_category` | `string` | | ☐ | | | `material_supplier_vatTariff_createdAt` | `datetime` | | ☐ | | | `material_supplier_vatTariff_deletedAt` | `datetime` | | ☐ | | | `material_supplier_vatTariff_description` | `string` | | ☐ | | | `material_supplier_vatTariff_id` | `string` | | ☐ | | | `material_supplier_vatTariff_name` | `string` | | ☐ | | | `material_supplier_vatTariff_percentage` | `decimal` | | ☐ | | | `material_supplier_vatTariff_updatedAt` | `datetime` | | ☐ | | | `material_supplier_vatTariffId` | `string` | | ☐ | | | `material_supplier_website` | `string` | | ☐ | | | `material_supplierId` | `string` | | ☐ | | | `material_updatedAt` | `datetime` | | ☐ | | | `materialId` | `string` | | ☐ | | | `number` | `string` | | ☐ | | | `price_1` | `decimal` | | ☐ | | | `price` | `decimal` | Price | ☐ | | | `quantity_1` | `decimal` | | ☐ | | | `quantity` | `decimal` | | ☐ | | | `quantityFormula_1` | `string` | | ☐ | | | `quantityFormula` | `string` | | ☐ | | | `styleName` | `string` | | ☐ | | | `totalExclVat_1` | `decimal` | | ☐ | | | `totalExclVat` | `decimal` | | ☐ | | | `totality` | `boolean` | Totality | ☐ | | | `type` | `string` | Type | ☐ | | | `unitType_1` | `string` | | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt` | `datetime` | | ☐ | | | `vatTariff_additionalMention` | `string` | | ☐ | | | `vatTariff_archivedAt` | `datetime` | | ☐ | | | `vatTariff_category` | `string` | | ☐ | | | `vatTariff_createdAt` | `datetime` | | ☐ | | | `vatTariff_deletedAt` | `datetime` | | ☐ | | | `vatTariff_description` | `string` | | ☐ | | | `vatTariff_id` | `string` | | ☐ | | | `vatTariff_name` | `string` | | ☐ | | | `vatTariff_percentage` | `decimal` | | ☐ | | | `vatTariff_updatedAt` | `datetime` | | ☐ | | | `vatTariffId` | `string` | | ☐ | |