# SalesInvoiceLines: ROBAWS Sales Invoice Lines by Sales Invoice ID 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: `SalesInvoices` - Label: Sales Invoice Lines by Sales Invoice ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `clientId` | `string` | ☐ | | | | `fromDate` | `datetime` | ☐ | | | | `journalName` | `string` | ☐ | | | | `projectId` | `string` | ☐ | | | | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `toDate` | `datetime` | ☐ | | | | `type` | `string` | ☐ | | Values: INVOICE, CREDIT_NOTE. | | `updatedFrom` | `datetime` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `SalesInvoiceLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountancyStatus` | `string` | Accounting status | ☐ | | | `activityId` | `string` | Activity ID | ☐ | | | `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` | | ☐ | | | `client_archivedAt` | `datetime` | | ☐ | | | `client_assignedUserId` | `string` | | ☐ | | | `client_createdAt` | `datetime` | | ☐ | | | `client_creditStatus` | `string` | | ☐ | | | `client_deletedAt` | `datetime` | | ☐ | | | `client_email` | `string` | Customer Email | ☐ | | | `client_extraFields` | `string` | | ☐ | | | `client_fax` | `string` | Customer Fax | ☐ | | | `client_followUpDate` | `datetime` | | ☐ | | | `client_generalLedgerAccountId` | `string` | | ☐ | | | `client_gsm` | `string` | Customer Mobile | ☐ | | | `client_id` | `string` | Client ID | ☐ | | | `client_invoiceEmail` | `string` | | ☐ | | | `client_language` | `string` | | ☐ | | | `client_legalFormId` | `string` | | ☐ | | | `client_lockedAt` | `datetime` | | ☐ | | | `client_name` | `string` | | ☐ | | | `client_paymentConditionId` | `string` | | ☐ | | | `client_priceGroupId` | `string` | | ☐ | | | `client_status` | `string` | | ☐ | | | `client_tel` | `string` | | ☐ | | | `client_title` | `string` | | ☐ | | | `client_updatedAt` | `datetime` | | ☐ | | | `client_vatIdNumber` | `string` | | ☐ | | | `client_vatTariffId` | `string` | | ☐ | | | `client_website` | `string` | | ☐ | | | `clientId` | `string` | Customer ID | ☐ | | | `clientReference` | `string` | Customer Reference | ☐ | | | `company_archivedAt` | `datetime` | | ☐ | | | `company_createdAt` | `datetime` | | ☐ | | | `company_deletedAt` | `datetime` | | ☐ | | | `company_extraFields` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `company_lockedAt` | `datetime` | | ☐ | | | `company_name` | `string` | | ☐ | | | `company_updatedAt` | `datetime` | | ☐ | | | `companyId` | `string` | Company ID | ☐ | | | `contactPersonId` | `string` | Contact Person ID | ☐ | | | `createdAt_1` | `datetime` | Created at | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `creditedInvoiceId` | `string` | Credit Note ID | ☐ | Only present for invoices of type CREDIT_NOTE. This is the id of the invoice that has been credited by this credit note. | | `creditedTotal` | `decimal` | Total credited | ☐ | Only present for invoices of type INVOICE | | `currency` | `string` | Currencies | ☐ | | | `date` | `datetime` | Date | ☐ | | | `deletedAt_1` | `datetime` | Deleted at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `discount` | `decimal` | Discount | ☐ | | | `exchangeRate` | `decimal` | Exchange rate | ☐ | | | `expireDate` | `datetime` | Expiry Date | ☐ | | | `extendedDescription` | `string` | Extended Description | ☐ | | | `extraFields_1` | `string` | Extra fields | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `generalLedgerAccountId` | `string` | Ledger Account ID | ☐ | | | `id_1` | `string` | ID | ☐ | | | `id` | `string` | ID | ☐ | | | `journalName` | `string` | Journal name | ☐ | | | `lockedAt_1` | `datetime` | Closed at | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `openTotal` | `decimal` | Total Open | ☐ | | | `orderId` | `string` | Order ID | ☐ | | | `paymentConditionId` | `string` | Payment Term ID | ☐ | | | `paymentInstruction` | `string` | Payment Instruction | ☐ | | | `postId` | `string` | Post ID | ☐ | | | `price` | `decimal` | Price | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `quantity` | `decimal` | Quantity | ☐ | | | `remark` | `string` | Remark | ☐ | | | `salesInvoiceId` | `string` | Sales Invoice ID | ☐ | Only present when obtained via bulk endpoint | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `styleName` | `string` | Style Name | ☐ | | | `totalExclVat` | `decimal` | Total excluding VAT | ☐ | | | `totalInclVat` | `decimal` | Total including VAT | ☐ | | | `transportId` | `string` | Transport ID | ☐ | | | `type_1` | `string` | Type | ☐ | | | `type` | `string` | Type | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt_1` | `datetime` | Updated On | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `vatTariffId` | `string` | VAT Rate ID | ☐ | | | `withRespectTo` | `string` | Attn. | ☐ | | | `workOrderId` | `string` | Work Order ID | ☐ | |