# CashEntriesById: ROBAWS Cash Entry by 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: `CashEntries` - Label: Cash Entry by ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | ## Columns The columns of the table `CashEntriesById` 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__metadata_description` | `string` | | ☐ | | | `cashRegister__metadata_href` | `string` | | ☐ | | | `cashRegister__metadata_resource` | `string` | | ☐ | | | `cashRegister__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__metadata_description` | `string` | | ☐ | | | `cashRegisterClosing__metadata_href` | `string` | | ☐ | | | `cashRegisterClosing__metadata_resource` | `string` | | ☐ | | | `cashRegisterClosing__metadata_resourceTypeId` | `string` | | ☐ | | | `cashRegisterClosing_archivedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegister_archivedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegister_createdAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegister_deletedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegister_extraFields` | `string` | | ☐ | | | `cashRegisterClosing_cashRegister_id` | `string` | | ☐ | | | `cashRegisterClosing_cashRegister_initialBalance` | `decimal` | | ☐ | | | `cashRegisterClosing_cashRegister_journalCode` | `string` | | ☐ | | | `cashRegisterClosing_cashRegister_lockedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegister_miscJournalCode` | `string` | | ☐ | | | `cashRegisterClosing_cashRegister_name` | `string` | | ☐ | | | `cashRegisterClosing_cashRegister_updatedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_cashRegisterId` | `string` | | ☐ | | | `cashRegisterClosing_closingBalance` | `decimal` | | ☐ | | | `cashRegisterClosing_createdAt` | `datetime` | | ☐ | | | `cashRegisterClosing_createdByUser_archivedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_createdByUser_createdAt` | `datetime` | | ☐ | | | `cashRegisterClosing_createdByUser_deletedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_createdByUser_email` | `string` | | ☐ | | | `cashRegisterClosing_createdByUser_emailAccountActive` | `boolean` | | ☐ | | | `cashRegisterClosing_createdByUser_extraFields` | `string` | | ☐ | | | `cashRegisterClosing_createdByUser_fullName` | `string` | | ☐ | | | `cashRegisterClosing_createdByUser_id` | `string` | | ☐ | | | `cashRegisterClosing_createdByUser_locale` | `string` | | ☐ | | | `cashRegisterClosing_createdByUser_locked` | `boolean` | | ☐ | | | `cashRegisterClosing_createdByUser_lockedAt` | `datetime` | | ☐ | | | `cashRegisterClosing_createdByUser_updatedAt` | `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__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 | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `createdByUser__metadata_description` | `string` | | ☐ | | | `createdByUser__metadata_href` | `string` | | ☐ | | | `createdByUser__metadata_resource` | `string` | | ☐ | | | `createdByUser__metadata_resourceTypeId` | `string` | | ☐ | | | `createdByUser_archivedAt` | `datetime` | | ☐ | | | `createdByUser_createdAt` | `datetime` | | ☐ | | | `createdByUser_deletedAt` | `datetime` | | ☐ | | | `createdByUser_email` | `string` | | ☐ | | | `createdByUser_emailAccount_from` | `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__metadata_description` | `string` | | ☐ | | | `invoice__metadata_href` | `string` | | ☐ | | | `invoice__metadata_resource` | `string` | | ☐ | | | `invoice__metadata_resourceTypeId` | `string` | | ☐ | | | `invoice_accountancyStatus` | `string` | | ☐ | | | `invoice_archivedAt` | `datetime` | | ☐ | | | `invoice_client_archivedAt` | `datetime` | | ☐ | | | `invoice_client_assignedUserId` | `string` | | ☐ | | | `invoice_client_createdAt` | `datetime` | | ☐ | | | `invoice_client_creditStatus` | `string` | | ☐ | | | `invoice_client_deletedAt` | `datetime` | | ☐ | | | `invoice_client_email` | `string` | | ☐ | | | `invoice_client_extraFields` | `string` | | ☐ | | | `invoice_client_fax` | `string` | | ☐ | | | `invoice_client_followUpDate` | `datetime` | | ☐ | | | `invoice_client_generalLedgerAccountId` | `string` | | ☐ | | | `invoice_client_gsm` | `string` | | ☐ | | | `invoice_client_id` | `string` | | ☐ | | | `invoice_client_invoiceEmail` | `string` | | ☐ | | | `invoice_client_language` | `string` | | ☐ | | | `invoice_client_legalFormId` | `string` | | ☐ | | | `invoice_client_lockedAt` | `datetime` | | ☐ | | | `invoice_client_name` | `string` | | ☐ | | | `invoice_client_paymentConditionId` | `string` | | ☐ | | | `invoice_client_priceGroupId` | `string` | | ☐ | | | `invoice_client_status` | `string` | | ☐ | | | `invoice_client_tel` | `string` | | ☐ | | | `invoice_client_title` | `string` | | ☐ | | | `invoice_client_updatedAt` | `datetime` | | ☐ | | | `invoice_client_vatIdNumber` | `string` | | ☐ | | | `invoice_client_vatTariffId` | `string` | | ☐ | | | `invoice_client_website` | `string` | | ☐ | | | `invoice_clientId` | `string` | | ☐ | | | `invoice_clientReference` | `string` | | ☐ | | | `invoice_company_archivedAt` | `datetime` | | ☐ | | | `invoice_company_createdAt` | `datetime` | | ☐ | | | `invoice_company_deletedAt` | `datetime` | | ☐ | | | `invoice_company_extraFields` | `string` | | ☐ | | | `invoice_company_id` | `string` | | ☐ | | | `invoice_company_lockedAt` | `datetime` | | ☐ | | | `invoice_company_name` | `string` | | ☐ | | | `invoice_company_updatedAt` | `datetime` | | ☐ | | | `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_statusDetails_color` | `string` | | ☐ | | | `invoice_statusDetails_name` | `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__metadata_description` | `string` | | ☐ | | | `order__metadata_href` | `string` | | ☐ | | | `order__metadata_resource` | `string` | | ☐ | | | `order__metadata_resourceTypeId` | `string` | | ☐ | | | `order_archivedAt` | `datetime` | | ☐ | | | `order_client_archivedAt` | `datetime` | | ☐ | | | `order_client_assignedUserId` | `string` | | ☐ | | | `order_client_createdAt` | `datetime` | | ☐ | | | `order_client_creditStatus` | `string` | | ☐ | | | `order_client_deletedAt` | `datetime` | | ☐ | | | `order_client_email` | `string` | | ☐ | | | `order_client_extraFields` | `string` | | ☐ | | | `order_client_fax` | `string` | | ☐ | | | `order_client_followUpDate` | `datetime` | | ☐ | | | `order_client_generalLedgerAccountId` | `string` | | ☐ | | | `order_client_gsm` | `string` | | ☐ | | | `order_client_id` | `string` | | ☐ | | | `order_client_invoiceEmail` | `string` | | ☐ | | | `order_client_language` | `string` | | ☐ | | | `order_client_legalFormId` | `string` | | ☐ | | | `order_client_lockedAt` | `datetime` | | ☐ | | | `order_client_name` | `string` | | ☐ | | | `order_client_paymentConditionId` | `string` | | ☐ | | | `order_client_priceGroupId` | `string` | | ☐ | | | `order_client_status` | `string` | | ☐ | | | `order_client_tel` | `string` | | ☐ | | | `order_client_title` | `string` | | ☐ | | | `order_client_updatedAt` | `datetime` | | ☐ | | | `order_client_vatIdNumber` | `string` | | ☐ | | | `order_client_vatTariffId` | `string` | | ☐ | | | `order_client_website` | `string` | | ☐ | | | `order_clientContact_archivedAt` | `datetime` | | ☐ | | | `order_clientContact_createdAt` | `datetime` | | ☐ | | | `order_clientContact_deletedAt` | `datetime` | | ☐ | | | `order_clientContact_email` | `string` | | ☐ | | | `order_clientContact_extraFields` | `string` | | ☐ | | | `order_clientContact_gsm` | `string` | | ☐ | | | `order_clientContact_id` | `string` | | ☐ | | | `order_clientContact_lockedAt` | `datetime` | | ☐ | | | `order_clientContact_name` | `string` | | ☐ | | | `order_clientContact_position` | `string` | | ☐ | | | `order_clientContact_surname` | `string` | | ☐ | | | `order_clientContact_tel` | `string` | | ☐ | | | `order_clientContact_title` | `string` | | ☐ | | | `order_clientContact_updatedAt` | `datetime` | | ☐ | | | `order_clientContactId` | `string` | | ☐ | | | `order_clientId` | `string` | | ☐ | | | `order_clientReference` | `string` | | ☐ | | | `order_company_archivedAt` | `datetime` | | ☐ | | | `order_company_createdAt` | `datetime` | | ☐ | | | `order_company_deletedAt` | `datetime` | | ☐ | | | `order_company_extraFields` | `string` | | ☐ | | | `order_company_id` | `string` | | ☐ | | | `order_company_lockedAt` | `datetime` | | ☐ | | | `order_company_name` | `string` | | ☐ | | | `order_company_updatedAt` | `datetime` | | ☐ | | | `order_companyId` | `string` | | ☐ | | | `order_createdAt` | `datetime` | | ☐ | | | `order_date` | `datetime` | | ☐ | | | `order_deletedAt` | `datetime` | | ☐ | | | `order_endClient_archivedAt` | `datetime` | | ☐ | | | `order_endClient_assignedUserId` | `string` | | ☐ | | | `order_endClient_createdAt` | `datetime` | | ☐ | | | `order_endClient_creditStatus` | `string` | | ☐ | | | `order_endClient_deletedAt` | `datetime` | | ☐ | | | `order_endClient_email` | `string` | | ☐ | | | `order_endClient_extraFields` | `string` | | ☐ | | | `order_endClient_fax` | `string` | | ☐ | | | `order_endClient_followUpDate` | `datetime` | | ☐ | | | `order_endClient_generalLedgerAccountId` | `string` | | ☐ | | | `order_endClient_gsm` | `string` | | ☐ | | | `order_endClient_id` | `string` | | ☐ | | | `order_endClient_invoiceEmail` | `string` | | ☐ | | | `order_endClient_language` | `string` | | ☐ | | | `order_endClient_legalFormId` | `string` | | ☐ | | | `order_endClient_lockedAt` | `datetime` | | ☐ | | | `order_endClient_name` | `string` | | ☐ | | | `order_endClient_paymentConditionId` | `string` | | ☐ | | | `order_endClient_priceGroupId` | `string` | | ☐ | | | `order_endClient_status` | `string` | | ☐ | | | `order_endClient_tel` | `string` | | ☐ | | | `order_endClient_title` | `string` | | ☐ | | | `order_endClient_updatedAt` | `datetime` | | ☐ | | | `order_endClient_vatIdNumber` | `string` | | ☐ | | | `order_endClient_vatTariffId` | `string` | | ☐ | | | `order_endClient_website` | `string` | | ☐ | | | `order_endClientContact_archivedAt` | `datetime` | | ☐ | | | `order_endClientContact_createdAt` | `datetime` | | ☐ | | | `order_endClientContact_deletedAt` | `datetime` | | ☐ | | | `order_endClientContact_email` | `string` | | ☐ | | | `order_endClientContact_extraFields` | `string` | | ☐ | | | `order_endClientContact_gsm` | `string` | | ☐ | | | `order_endClientContact_id` | `string` | | ☐ | | | `order_endClientContact_lockedAt` | `datetime` | | ☐ | | | `order_endClientContact_name` | `string` | | ☐ | | | `order_endClientContact_position` | `string` | | ☐ | | | `order_endClientContact_surname` | `string` | | ☐ | | | `order_endClientContact_tel` | `string` | | ☐ | | | `order_endClientContact_title` | `string` | | ☐ | | | `order_endClientContact_updatedAt` | `datetime` | | ☐ | | | `order_endClientContactId` | `string` | | ☐ | | | `order_endClientId` | `string` | | ☐ | | | `order_extraFields` | `string` | | ☐ | | | `order_id` | `string` | | ☐ | | | `order_lockedAt` | `datetime` | | ☐ | | | `order_logicId` | `string` | | ☐ | | | `order_project_archivedAt` | `datetime` | | ☐ | | | `order_project_checkInAtWork` | `string` | | ☐ | | | `order_project_clientContactId` | `string` | | ☐ | | | `order_project_clientId` | `string` | | ☐ | | | `order_project_clientReference` | `string` | | ☐ | | | `order_project_companyId` | `string` | | ☐ | | | `order_project_createdAt` | `datetime` | | ☐ | | | `order_project_date` | `datetime` | | ☐ | | | `order_project_deletedAt` | `datetime` | | ☐ | | | `order_project_distance` | `int32` | | ☐ | | | `order_project_endClientContactId` | `string` | | ☐ | | | `order_project_endClientId` | `string` | | ☐ | | | `order_project_extraFields` | `string` | | ☐ | | | `order_project_geofence` | `string` | | ☐ | | | `order_project_id` | `string` | | ☐ | | | `order_project_lockedAt` | `datetime` | | ☐ | | | `order_project_logicId` | `string` | | ☐ | | | `order_project_nssoDeclarationOfWorks` | `string` | | ☐ | | | `order_project_planningGroup` | `string` | | ☐ | | | `order_project_planningName` | `string` | | ☐ | | | `order_project_siteManagerId` | `string` | | ☐ | | | `order_project_siteNssoIdNumber` | `string` | | ☐ | | | `order_project_status` | `string` | | ☐ | | | `order_project_updatedAt` | `datetime` | | ☐ | | | `order_projectId` | `string` | | ☐ | | | `order_remark` | `string` | | ☐ | | | `order_status` | `string` | | ☐ | | | `order_statusDetails_color` | `string` | | ☐ | | | `order_statusDetails_name` | `string` | | ☐ | | | `order_totalExclVat` | `decimal` | | ☐ | | | `order_totalInclVat` | `decimal` | | ☐ | | | `order_updatedAt` | `datetime` | | ☐ | | | `orderId` | `string` | Order ID | ☐ | | | `remark` | `string` | Remark | ☐ | | | `updatable` | `boolean` | Updatable | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |