# SalesInvoices: ROBAWS Sales Invoices 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 Invoices ## 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 `SalesInvoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountancyStatus` | `string` | Accounting status | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `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` | `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` | `datetime` | Deleted at | ☐ | | | `exchangeRate` | `decimal` | Exchange rate | ☐ | | | `expireDate` | `datetime` | Expiry Date | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id` | `string` | ID | ☐ | | | `journalName` | `string` | Journal name | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `openTotal` | `decimal` | Total Open | ☐ | | | `paymentConditionId` | `string` | Payment Term ID | ☐ | | | `paymentInstruction` | `string` | Payment Instruction | ☐ | | | `remark` | `string` | Remark | ☐ | | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `totalExclVat` | `decimal` | Total excluding VAT | ☐ | | | `totalInclVat` | `decimal` | Total including VAT | ☐ | | | `type` | `string` | Type | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `withRespectTo` | `string` | Attn. | ☐ | |