# Posts_CalculationLineItemsById 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: `Posts` ## Columns The columns of the table `Posts_CalculationLineItemsById` 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` | | ☐ | | | `archivedAt_1` | `datetime` | | ☐ | | | `archivedAt` | `datetime` | | ☐ | | | `article__metadata_description` | `string` | | ☐ | | | `article__metadata_href` | `string` | | ☐ | | | `article__metadata_resource` | `string` | | ☐ | | | `article__metadata_resourceTypeId` | `string` | | ☐ | | | `article_activity__metadata_description` | `string` | | ☐ | | | `article_activity__metadata_href` | `string` | | ☐ | | | `article_activity__metadata_resource` | `string` | | ☐ | | | `article_activity__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__metadata_description` | `string` | | ☐ | | | `article_group__metadata_href` | `string` | | ☐ | | | `article_group__metadata_resource` | `string` | | ☐ | | | `article_group__metadata_resourceTypeId` | `string` | | ☐ | | | `article_group_archivedAt` | `datetime` | | ☐ | | | `article_group_createdAt` | `datetime` | | ☐ | | | `article_group_deletedAt` | `datetime` | | ☐ | | | `article_group_extraFields` | `string` | | ☐ | | | `article_group_id` | `string` | | ☐ | | | `article_group_image__metadata_description` | `string` | | ☐ | | | `article_group_image__metadata_href` | `string` | | ☐ | | | `article_group_image__metadata_resource` | `string` | | ☐ | | | `article_group_image__metadata_resourceTypeId` | `string` | | ☐ | | | `article_group_image_archivedAt` | `datetime` | | ☐ | | | `article_group_image_contentType` | `string` | | ☐ | | | `article_group_image_createdAt` | `datetime` | | ☐ | | | `article_group_image_deletedAt` | `datetime` | | ☐ | | | `article_group_image_directory` | `boolean` | | ☐ | | | `article_group_image_id` | `string` | | ☐ | | | `article_group_image_lockedAt` | `datetime` | | ☐ | | | `article_group_image_name` | `string` | | ☐ | | | `article_group_image_parentId` | `string` | | ☐ | | | `article_group_image_previewUrl` | `string` | | ☐ | | | `article_group_image_size` | `int64` | | ☐ | | | `article_group_image_updatedAt` | `datetime` | | ☐ | | | `article_group_image_url` | `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__metadata_description` | `string` | | ☐ | | | `article_image__metadata_href` | `string` | | ☐ | | | `article_image__metadata_resource` | `string` | | ☐ | | | `article_image__metadata_resourceTypeId` | `string` | | ☐ | | | `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__metadata_description` | `string` | | ☐ | | | `article_purchaseGLAccount__metadata_href` | `string` | | ☐ | | | `article_purchaseGLAccount__metadata_resource` | `string` | | ☐ | | | `article_purchaseGLAccount__metadata_resourceTypeId` | `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__metadata_description` | `string` | | ☐ | | | `article_salesGLAccount__metadata_href` | `string` | | ☐ | | | `article_salesGLAccount__metadata_resource` | `string` | | ☐ | | | `article_salesGLAccount__metadata_resourceTypeId` | `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` | | ☐ | | | `articleGroupId` | `string` | | ☐ | | | `articleId` | `string` | | ☐ | | | `c_metadata_description_1` | `string` | | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href_1` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource_1` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId_1` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `calculationDescription` | `string` | | ☐ | | | `calculationDescriptionOnPdf` | `boolean` | | ☐ | | | `calculationType` | `string` | Calculation Type | ☐ | | | `chapter` | `string` | Chapter | ☐ | | | `costPrice` | `decimal` | Cost Price | ☐ | | | `createdAt_1` | `datetime` | | ☐ | | | `createdAt` | `datetime` | | ☐ | | | `customPrice_1` | `decimal` | | ☐ | | | `customPrice` | `boolean` | Custom Price | ☐ | | | `deletedAt_1` | `datetime` | | ☐ | | | `deletedAt` | `datetime` | | ☐ | | | `description` | `string` | Description | ☐ | | | `extendedDescription` | `string` | | ☐ | | | `extraFields_1` | `string` | | ☐ | | | `extraFields` | `string` | | ☐ | | | `headerLevel` | `string` | Heading Level | ☐ | | | `id_1` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `indirectCostFactor` | `decimal` | Indirect Cost Factor | ☐ | | | `lineType` | `string` | Line Type | ☐ | | | `lockedAt_1` | `datetime` | | ☐ | | | `lockedAt` | `datetime` | | ☐ | | | `margin` | `decimal` | Margin | ☐ | | | `name` | `string` | Name | ☐ | | | `nameTranslations` | `string` | | ☐ | | | `newPage` | `boolean` | New Page | ☐ | | | `number` | `string` | | ☐ | | | `postId` | `string` | | ☐ | Only present when obtained via bulk endpoint | | `price` | `decimal` | Price | ☐ | | | `quantity` | `decimal` | | ☐ | | | `quantityFormula` | `string` | | ☐ | | | `saleName` | `string` | | ☐ | | | `totalExclVat` | `decimal` | | ☐ | | | `totality` | `boolean` | Total | ☐ | | | `type` | `string` | Type | ☐ | | | `unitType_1` | `string` | | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt_1` | `datetime` | | ☐ | | | `updatedAt` | `datetime` | | ☐ | | | `vatTariffId` | `string` | | ☐ | |