# SalesInvoiceLinesBySalesInvoiceId: ROBAWS Sales Invoice Lines by Sales Invoice ID 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: `SalesInvoices` - Label: Sales Invoice Lines by Sales Invoice ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | ## Columns The columns of the table `SalesInvoiceLinesBySalesInvoiceId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountancyStatus` | `string` | Accounting status | ☐ | | | `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` | Activity ID | ☐ | | | `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` | `string` | Item ID | ☐ | | | `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` | | ☐ | | | `client__metadata_description` | `string` | | ☐ | | | `client__metadata_href` | `string` | | ☐ | | | `client__metadata_resource` | `string` | | ☐ | | | `client__metadata_resourceTypeId` | `string` | | ☐ | | | `client_address_addressLine1` | `string` | | ☐ | | | `client_address_addressLine2` | `string` | | ☐ | | | `client_address_city` | `string` | | ☐ | | | `client_address_country` | `string` | | ☐ | | | `client_address_latitude` | `double` | | ☐ | | | `client_address_longitude` | `double` | | ☐ | | | `client_address_postalCode` | `string` | | ☐ | | | `client_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_createdAt` | `datetime` | | ☐ | | | `client_assignedUser_deletedAt` | `datetime` | | ☐ | | | `client_assignedUser_email` | `string` | | ☐ | | | `client_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `client_assignedUser_extraFields` | `string` | | ☐ | | | `client_assignedUser_fullName` | `string` | | ☐ | | | `client_assignedUser_id` | `string` | | ☐ | | | `client_assignedUser_locale` | `string` | | ☐ | | | `client_assignedUser_locked` | `boolean` | | ☐ | | | `client_assignedUser_lockedAt` | `datetime` | | ☐ | | | `client_assignedUser_updatedAt` | `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_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_code` | `string` | | ☐ | | | `client_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `client_generalLedgerAccount_id` | `string` | | ☐ | | | `client_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccount_name` | `string` | | ☐ | | | `client_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `client_generalLedgerAccountId` | `string` | | ☐ | | | `client_gsm` | `string` | Customer Mobile | ☐ | | | `client_id` | `string` | Client ID | ☐ | | | `client_invoiceAddress_addressLine1` | `string` | | ☐ | | | `client_invoiceAddress_addressLine2` | `string` | | ☐ | | | `client_invoiceAddress_city` | `string` | | ☐ | | | `client_invoiceAddress_country` | `string` | | ☐ | | | `client_invoiceAddress_latitude` | `double` | | ☐ | | | `client_invoiceAddress_longitude` | `double` | | ☐ | | | `client_invoiceAddress_postalCode` | `string` | | ☐ | | | `client_invoiceEmail` | `string` | | ☐ | | | `client_language` | `string` | | ☐ | | | `client_legalForm_archivedAt` | `datetime` | | ☐ | | | `client_legalForm_createdAt` | `datetime` | | ☐ | | | `client_legalForm_deletedAt` | `datetime` | | ☐ | | | `client_legalForm_extraFields` | `string` | | ☐ | | | `client_legalForm_id` | `string` | | ☐ | | | `client_legalForm_legalAbbreviation` | `string` | | ☐ | | | `client_legalForm_lockedAt` | `datetime` | | ☐ | | | `client_legalForm_name` | `string` | | ☐ | | | `client_legalForm_updatedAt` | `datetime` | | ☐ | | | `client_legalForm_vatLiable` | `boolean` | | ☐ | | | `client_legalFormId` | `string` | | ☐ | | | `client_lockedAt` | `datetime` | | ☐ | | | `client_name` | `string` | | ☐ | | | `client_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `client_paymentCondition_createdAt` | `datetime` | | ☐ | | | `client_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `client_paymentCondition_extraFields` | `string` | | ☐ | | | `client_paymentCondition_id` | `string` | | ☐ | | | `client_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `client_paymentCondition_name` | `string` | | ☐ | | | `client_paymentCondition_purchase` | `boolean` | | ☐ | | | `client_paymentCondition_sales` | `boolean` | | ☐ | | | `client_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `client_paymentConditionId` | `string` | | ☐ | | | `client_priceGroupId` | `string` | | ☐ | | | `client_status` | `string` | | ☐ | | | `client_statusDetails_color` | `string` | | ☐ | | | `client_statusDetails_name` | `string` | | ☐ | | | `client_tel` | `string` | | ☐ | | | `client_title` | `string` | | ☐ | | | `client_updatedAt` | `datetime` | | ☐ | | | `client_vatIdNumber` | `string` | | ☐ | | | `client_vatTariff_additionalMention` | `string` | | ☐ | | | `client_vatTariff_archivedAt` | `datetime` | | ☐ | | | `client_vatTariff_category` | `string` | | ☐ | | | `client_vatTariff_createdAt` | `datetime` | | ☐ | | | `client_vatTariff_deletedAt` | `datetime` | | ☐ | | | `client_vatTariff_description` | `string` | | ☐ | | | `client_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `client_vatTariff_extraFields` | `string` | | ☐ | | | `client_vatTariff_id` | `string` | | ☐ | | | `client_vatTariff_inclusive` | `boolean` | | ☐ | | | `client_vatTariff_lockedAt` | `datetime` | | ☐ | | | `client_vatTariff_name` | `string` | | ☐ | | | `client_vatTariff_percentage` | `decimal` | | ☐ | | | `client_vatTariff_updatedAt` | `datetime` | | ☐ | | | `client_vatTariffId` | `string` | | ☐ | | | `client_website` | `string` | | ☐ | | | `clientId` | `string` | Customer ID | ☐ | | | `clientReference` | `string` | Customer Reference | ☐ | | | `company__metadata_description` | `string` | | ☐ | | | `company__metadata_href` | `string` | | ☐ | | | `company__metadata_resource` | `string` | | ☐ | | | `company__metadata_resourceTypeId` | `string` | | ☐ | | | `company_address_addressLine1` | `string` | | ☐ | | | `company_address_addressLine2` | `string` | | ☐ | | | `company_address_city` | `string` | | ☐ | | | `company_address_country` | `string` | | ☐ | | | `company_address_latitude` | `double` | | ☐ | | | `company_address_longitude` | `double` | | ☐ | | | `company_address_postalCode` | `string` | | ☐ | | | `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 | ☐ | | | `generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `generalLedgerAccount_code` | `string` | | ☐ | | | `generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `generalLedgerAccount_extraFields` | `string` | | ☐ | | | `generalLedgerAccount_id` | `string` | | ☐ | | | `generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `generalLedgerAccount_name` | `string` | | ☐ | | | `generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `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 | ☐ | | | `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 | ☐ | | | `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 | ☐ | | | `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 | ☐ | | | `withRespectTo` | `string` | Attn. | ☐ | | | `workOrder_archivedAt` | `datetime` | | ☐ | | | `workOrder_clientId` | `string` | | ☐ | | | `workOrder_clientReference` | `string` | | ☐ | | | `workOrder_companyId` | `string` | | ☐ | | | `workOrder_createdAt` | `datetime` | | ☐ | | | `workOrder_date` | `datetime` | | ☐ | | | `workOrder_deletedAt` | `datetime` | | ☐ | | | `workOrder_endClientId` | `string` | | ☐ | | | `workOrder_extraFields` | `string` | | ☐ | | | `workOrder_id` | `string` | | ☐ | | | `workOrder_lockedAt` | `datetime` | | ☐ | | | `workOrder_logicId` | `string` | | ☐ | | | `workOrder_planningItemId` | `string` | | ☐ | | | `workOrder_projectId` | `string` | | ☐ | | | `workOrder_remark` | `string` | | ☐ | | | `workOrder_status` | `string` | | ☐ | | | `workOrder_timeAndMaterial` | `boolean` | | ☐ | | | `workOrder_title` | `string` | | ☐ | | | `workOrder_totalCostExclVat` | `decimal` | | ☐ | | | `workOrder_totalExclVat` | `decimal` | | ☐ | | | `workOrder_updatedAt` | `datetime` | | ☐ | | | `workOrderId` | `string` | Work Order ID | ☐ | |