# ClaimStateLineItems: ROBAWS Claim Statement Line Items 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: `ClaimStates` - Label: Claim Statement Line Items ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `projectId` | `string` | ☐ | | | | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `ClaimStateLineItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `agreementType` | `string` | Agreement Type | ☐ | | | `archivedAt_1` | `datetime` | Archived at | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `articleId` | `string` | Item ID | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `chapter` | `string` | Chapter | ☐ | | | `claimStateId` | `string` | Claim Statement ID | ☐ | Only present when obtained via bulk endpoint | | `createdAt_1` | `datetime` | Created at | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `currentQuantity` | `decimal` | Current quantity | ☐ | | | `deletedAt_1` | `datetime` | Deleted at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `endDate` | `datetime` | End Date | ☐ | | | `extraFields_1` | `string` | Extra fields | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id_1` | `string` | ID | ☐ | | | `id` | `string` | ID | ☐ | | | `lockedAt_1` | `datetime` | Closed at | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `number` | `string` | Number | ☐ | | | `predictedQuantity` | `decimal` | Forecast quantity | ☐ | | | `previousQuantity` | `decimal` | Previous quantity | ☐ | | | `project_archivedAt` | `datetime` | | ☐ | | | `project_checkInAtWork` | `string` | | ☐ | | | `project_clientContactId` | `string` | | ☐ | | | `project_clientId` | `string` | | ☐ | | | `project_clientReference` | `string` | | ☐ | | | `project_companyId` | `string` | | ☐ | | | `project_createdAt` | `datetime` | | ☐ | | | `project_date` | `datetime` | | ☐ | | | `project_deletedAt` | `datetime` | | ☐ | | | `project_distance` | `int32` | | ☐ | | | `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_siteManagerId` | `string` | | ☐ | | | `project_siteNssoIdNumber` | `string` | | ☐ | | | `project_status` | `string` | | ☐ | | | `project_updatedAt` | `datetime` | | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `settlement` | `boolean` | Settlement | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | | | `status` | `string` | Status | ☐ | | | `styleName` | `string` | Style Name | ☐ | | | `totalExclVat_1` | `decimal` | Total excluding VAT | ☐ | | | `totalExclVat` | `decimal` | Total excluding VAT | ☐ | | | `totalInclVat` | `decimal` | Total including VAT | ☐ | | | `totalQuantity` | `decimal` | Total quantity | ☐ | | | `totalRevision` | `decimal` | Total Revision | ☐ | | | `type` | `string` | Type | ☐ | | | `unitPrice` | `decimal` | Price per unit | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt_1` | `datetime` | Updated On | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `vatTariffId` | `string` | VAT Rate ID | ☐ | |