# CashEntries: ROBAWS Cash Bookings 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: `CashEntries` - Label: Cash Bookings ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `CashEntries` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `decimal` | Amount | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `cashRegister_archivedAt` | `datetime` | | ☐ | | | `cashRegister_createdAt` | `datetime` | | ☐ | | | `cashRegister_deletedAt` | `datetime` | | ☐ | | | `cashRegister_extraFields` | `string` | | ☐ | | | `cashRegister_id` | `string` | | ☐ | | | `cashRegister_initialBalance` | `decimal` | | ☐ | | | `cashRegister_journalCode` | `string` | | ☐ | | | `cashRegister_lockedAt` | `datetime` | | ☐ | | | `cashRegister_miscJournalCode` | `string` | | ☐ | | | `cashRegister_name` | `string` | | ☐ | | | `cashRegister_updatedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_archivedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegisterId` | `string` | | ☐ | | | `cashRegisterClosing_closingBalance` | `decimal` | | ☐ | | | `cashRegisterClosing_createdAt` | `datetime` | | ☐ | | | `cashRegisterClosing_createdByUserId` | `string` | | ☐ | | | `cashRegisterClosing_date` | `datetime` | | ☐ | | | `cashRegisterClosing_deletedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_extraFields` | `string` | | ☐ | | | `cashRegisterClosing_id` | `string` | | ☐ | | | `cashRegisterClosing_lockedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_logicId` | `string` | | ☐ | | | `cashRegisterClosing_openingBalance` | `decimal` | | ☐ | | | `cashRegisterClosing_sentToAccountant` | `datetime` | | ☐ | | | `cashRegisterClosing_updatedAt` | `datetime` | | ☐ | | | `cashRegisterClosingId` | `string` | Cash Register Closing ID | ☐ | | | `cashRegisterId` | `string` | Cash Register ID | ☐ | | | `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 | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `createdByUser_archivedAt` | `datetime` | | ☐ | | | `createdByUser_createdAt` | `datetime` | | ☐ | | | `createdByUser_deletedAt` | `datetime` | | ☐ | | | `createdByUser_email` | `string` | | ☐ | | | `createdByUser_emailAccountActive` | `boolean` | | ☐ | | | `createdByUser_extraFields` | `string` | | ☐ | | | `createdByUser_fullName` | `string` | | ☐ | | | `createdByUser_id` | `string` | | ☐ | | | `createdByUser_locale` | `string` | | ☐ | | | `createdByUser_locked` | `boolean` | | ☐ | | | `createdByUser_lockedAt` | `datetime` | | ☐ | | | `createdByUser_updatedAt` | `datetime` | | ☐ | | | `createdByUserId` | `string` | Created by User ID | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `entryDate` | `datetime` | Effective Date | ☐ | | | `entryType` | `string` | Entry Type | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_accountancyStatus` | `string` | | ☐ | | | `invoice_archivedAt` | `datetime` | | ☐ | | | `invoice_clientId` | `string` | | ☐ | | | `invoice_clientReference` | `string` | | ☐ | | | `invoice_companyId` | `string` | | ☐ | | | `invoice_contactPersonId` | `string` | | ☐ | | | `invoice_createdAt` | `datetime` | | ☐ | | | `invoice_creditedInvoiceId` | `string` | | ☐ | Only present for invoices of type CREDIT_NOTE. This is the id of the invoice that has been credited by this credit note. | | `invoice_creditedTotal` | `decimal` | | ☐ | Only present for invoices of type INVOICE | | `invoice_currency` | `string` | | ☐ | | | `invoice_date` | `datetime` | | ☐ | | | `invoice_deletedAt` | `datetime` | | ☐ | | | `invoice_exchangeRate` | `decimal` | | ☐ | | | `invoice_expireDate` | `datetime` | | ☐ | | | `invoice_extraFields` | `string` | | ☐ | | | `invoice_id` | `string` | | ☐ | | | `invoice_journalName` | `string` | | ☐ | | | `invoice_lockedAt` | `datetime` | | ☐ | | | `invoice_logicId` | `string` | | ☐ | | | `invoice_openTotal` | `decimal` | | ☐ | | | `invoice_paymentConditionId` | `string` | | ☐ | | | `invoice_paymentInstruction` | `string` | | ☐ | | | `invoice_remark` | `string` | | ☐ | | | `invoice_status` | `string` | | ☐ | | | `invoice_totalExclVat` | `decimal` | | ☐ | | | `invoice_totalInclVat` | `decimal` | | ☐ | | | `invoice_type` | `string` | | ☐ | | | `invoice_updatedAt` | `datetime` | | ☐ | | | `invoice_withRespectTo` | `string` | | ☐ | | | `invoiceId` | `string` | Invoice ID | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `order_archivedAt` | `datetime` | | ☐ | | | `order_clientContactId` | `string` | | ☐ | | | `order_clientId` | `string` | | ☐ | | | `order_clientReference` | `string` | | ☐ | | | `order_companyId` | `string` | | ☐ | | | `order_createdAt` | `datetime` | | ☐ | | | `order_date` | `datetime` | | ☐ | | | `order_deletedAt` | `datetime` | | ☐ | | | `order_endClientContactId` | `string` | | ☐ | | | `order_endClientId` | `string` | | ☐ | | | `order_extraFields` | `string` | | ☐ | | | `order_id` | `string` | | ☐ | | | `order_lockedAt` | `datetime` | | ☐ | | | `order_logicId` | `string` | | ☐ | | | `order_projectId` | `string` | | ☐ | | | `order_remark` | `string` | | ☐ | | | `order_status` | `string` | | ☐ | | | `order_totalExclVat` | `decimal` | | ☐ | | | `order_totalInclVat` | `decimal` | | ☐ | | | `order_updatedAt` | `datetime` | | ☐ | | | `orderId` | `string` | Order ID | ☐ | | | `remark` | `string` | Remark | ☐ | | | `updatable` | `boolean` | Updatable | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |