# PostCalculationLines: ROBAWS Post-Calculation Lines Search 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` - Label: Post-Calculation Lines ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `updatedFrom` | `datetime` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `PostCalculationLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activityId` | `string` | Activity ID | ☐ | | | `archivedAt_1` | `datetime` | Archived at | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `articleGroupId` | `string` | Article Group ID | ☐ | | | `articleId` | `string` | Item ID | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `calculationDescription` | `string` | Calculation Description | ☐ | | | `calculationDescriptionOnPdf` | `boolean` | Calculation Description on PDF | ☐ | | | `calculationType` | `string` | Calculation Type | ☐ | | | `chapter` | `string` | Chapter | ☐ | | | `costPrice` | `decimal` | Cost Price | ☐ | | | `createdAt_1` | `datetime` | Created at | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `customPrice_1` | `decimal` | Custom price | ☐ | | | `customPrice` | `boolean` | Custom Price | ☐ | | | `deletedAt_1` | `datetime` | Deleted at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `extendedDescription` | `string` | Extended Description | ☐ | | | `extraFields_1` | `string` | Extra fields | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `headerLevel` | `string` | Heading Level | ☐ | | | `id_1` | `string` | ID | ☐ | | | `id` | `string` | ID | ☐ | | | `indirectCostFactor` | `decimal` | Indirect Cost Factor | ☐ | | | `lineType` | `string` | Line Type | ☐ | | | `lockedAt_1` | `datetime` | Closed at | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `margin` | `decimal` | Margin | ☐ | | | `name` | `string` | Name | ☐ | | | `nameTranslations` | `string` | Name Translations | ☐ | | | `newPage` | `boolean` | New Page | ☐ | | | `number` | `string` | Number | ☐ | | | `postId` | `string` | Post ID | ☐ | Only present when obtained via bulk endpoint | | `price` | `decimal` | Price | ☐ | | | `quantity` | `decimal` | Quantity | ☐ | | | `quantityFormula` | `string` | Quantity Formula | ☐ | | | `saleName` | `string` | Sales name | ☐ | | | `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 | ☐ | | | `vatTariffId` | `string` | VAT Rate ID | ☐ | |