# BulkItemCalculationLineItemOfferLineItems: ROBAWS Bulk Item Calculation Line Item Offer Line Items Fetch 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: `OfferLineItemBulkController` - Label: Bulk Item Calculation Line Item Offer Line Items ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `sort` | `string` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `BulkItemCalculationLineItemOfferLineItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activityId` | `string` | Activity ID | ☐ | | | `agreementType` | `string` | Agreement Type | ☐ | | | `archivedAt_1` | `datetime` | Archived at | ☐ | | | `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_1` | `string` | Item ID | ☐ | | | `articleId` | `string` | Item ID | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `calculationType` | `string` | Calculation Type | ☐ | | | `chapter` | `string` | Chapter | ☐ | | | `costPrice` | `decimal` | Cost Price | ☐ | | | `createdAt_1` | `datetime` | Created at | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `customPrice` | `boolean` | Custom Price | ☐ | | | `deletedAt_1` | `datetime` | Deleted at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description_1` | `string` | Description | ☐ | | | `description` | `string` | Description | ☐ | | | `discount` | `decimal` | Discount | ☐ | | | `extendedDescription` | `string` | Extended Description | ☐ | | | `extendedDescriptionRendered` | `string` | Extended Description Issued | ☐ | When reading, only present if requested via 'include' query parameter, otherwise null. | | `extraFields_1` | `string` | Extra fields | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id_1` | `string` | ID | ☐ | | | `id` | `string` | ID | ☐ | | | `image_archivedAt` | `datetime` | | ☐ | | | `image_contentType` | `string` | | ☐ | | | `image_createdAt` | `datetime` | | ☐ | | | `image_deletedAt` | `datetime` | | ☐ | | | `image_directory` | `boolean` | | ☐ | | | `image_id` | `string` | | ☐ | | | `image_lockedAt` | `datetime` | | ☐ | | | `image_name` | `string` | | ☐ | | | `image_parentId` | `string` | | ☐ | | | `image_previewUrl` | `string` | | ☐ | | | `image_size` | `int64` | | ☐ | | | `image_updatedAt` | `datetime` | | ☐ | | | `image_url` | `string` | | ☐ | | | `lockedAt_1` | `datetime` | Closed at | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `margin` | `decimal` | Margin | ☐ | | | `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 | ☐ | | | `number` | `string` | Number | ☐ | | | `offerId` | `string` | Offer ID | ☐ | Only present when obtained via bulk endpoint | | `postId` | `string` | Post ID | ☐ | Only present when obtained via bulk endpoint | | `price_1` | `decimal` | Price | ☐ | | | `price` | `decimal` | Price | ☐ | | | `quantity_1` | `decimal` | Quantity | ☐ | | | `quantity` | `decimal` | Quantity | ☐ | | | `quantityFormula_1` | `string` | Quantity Formula | ☐ | | | `quantityFormula` | `string` | Quantity Formula | ☐ | | | `styleName` | `string` | Style Name | ☐ | | | `totalExclVat_1` | `decimal` | Total excluding VAT | ☐ | | | `totalExclVat` | `decimal` | Total excluding VAT | ☐ | | | `totality` | `boolean` | Total | ☐ | | | `type` | `string` | Type | ☐ | | | `unitType_1` | `string` | Unit Type | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt_1` | `datetime` | Updated On | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `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 | ☐ | |