# Settlements_ParametersPossibleValuesById 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: `Settlements` ## Columns The columns of the table `Settlements_ParametersPossibleValuesById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activeOnProject` | `boolean` | Active on Project | ☐ | | | `address_addressLine1` | `string` | | ☐ | | | `address_addressLine2` | `string` | | ☐ | | | `address_city` | `string` | City | ☐ | | | `address_country` | `string` | Country | ☐ | | | `address_latitude` | `double` | | ☐ | | | `address_longitude` | `double` | | ☐ | | | `address_postalCode` | `string` | | ☐ | | | `addressDistance_unit` | `string` | | ☐ | | | `addressDistance_value` | `int32` | | ☐ | | | `archivedAt_1` | `datetime` | | ☐ | | | `archivedAt` | `datetime` | | ☐ | | | `assignedUserId` | `string` | | ☐ | | | `assignee__metadata_description` | `string` | | ☐ | | | `assignee__metadata_href` | `string` | | ☐ | | | `assignee__metadata_resource` | `string` | | ☐ | | | `assignee__metadata_resourceTypeId` | `string` | | ☐ | | | `assignee_archivedAt` | `datetime` | | ☐ | | | `assignee_createdAt` | `datetime` | | ☐ | | | `assignee_deletedAt` | `datetime` | | ☐ | | | `assignee_email` | `string` | Recipient Email | ☐ | | | `assignee_emailAccount_from` | `string` | | ☐ | | | `assignee_emailAccountActive` | `boolean` | | ☐ | | | `assignee_extraFields` | `string` | | ☐ | | | `assignee_fullName` | `string` | Assigned Person Full Name | ☐ | | | `assignee_id` | `string` | Authorised Representative ID | ☐ | | | `assignee_locale` | `string` | | ☐ | | | `assignee_locked` | `boolean` | | ☐ | | | `assignee_lockedAt` | `datetime` | | ☐ | | | `assignee_updatedAt` | `datetime` | | ☐ | | | `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` | | ☐ | | | `calculated` | `boolean` | | ☐ | | | `calculation` | `boolean` | Calculation | ☐ | | | `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__metadata_description` | `string` | | ☐ | | | `client_assignedUser__metadata_href` | `string` | | ☐ | | | `client_assignedUser__metadata_resource` | `string` | | ☐ | | | `client_assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `client_assignedUser_archivedAt` | `datetime` | | ☐ | | | `client_assignedUser_createdAt` | `datetime` | | ☐ | | | `client_assignedUser_deletedAt` | `datetime` | | ☐ | | | `client_assignedUser_email` | `string` | | ☐ | | | `client_assignedUser_emailAccount_from` | `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__metadata_description` | `string` | | ☐ | | | `client_generalLedgerAccount__metadata_href` | `string` | | ☐ | | | `client_generalLedgerAccount__metadata_resource` | `string` | | ☐ | | | `client_generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | | | `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__metadata_description` | `string` | | ☐ | | | `client_legalForm__metadata_href` | `string` | | ☐ | | | `client_legalForm__metadata_resource` | `string` | | ☐ | | | `client_legalForm__metadata_resourceTypeId` | `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__metadata_description` | `string` | | ☐ | | | `client_paymentCondition__metadata_href` | `string` | | ☐ | | | `client_paymentCondition__metadata_resource` | `string` | | ☐ | | | `client_paymentCondition__metadata_resourceTypeId` | `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__metadata_description` | `string` | | ☐ | | | `client_vatTariff__metadata_href` | `string` | | ☐ | | | `client_vatTariff__metadata_resource` | `string` | | ☐ | | | `client_vatTariff__metadata_resourceTypeId` | `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` | | ☐ | | | `clientContact__metadata_description` | `string` | | ☐ | | | `clientContact__metadata_href` | `string` | | ☐ | | | `clientContact__metadata_resource` | `string` | | ☐ | | | `clientContact__metadata_resourceTypeId` | `string` | | ☐ | | | `clientContact_archivedAt` | `datetime` | | ☐ | | | `clientContact_createdAt` | `datetime` | | ☐ | | | `clientContact_deletedAt` | `datetime` | | ☐ | | | `clientContact_email` | `string` | | ☐ | | | `clientContact_extraFields` | `string` | | ☐ | | | `clientContact_gsm` | `string` | | ☐ | | | `clientContact_id` | `string` | | ☐ | | | `clientContact_lockedAt` | `datetime` | | ☐ | | | `clientContact_name` | `string` | | ☐ | | | `clientContact_position` | `string` | | ☐ | | | `clientContact_surname` | `string` | | ☐ | | | `clientContact_tel` | `string` | | ☐ | | | `clientContact_title` | `string` | | ☐ | | | `clientContact_updatedAt` | `datetime` | | ☐ | | | `clientContactId` | `string` | | ☐ | | | `clientId` | `string` | | ☐ | | | `clientReference` | `string` | Customer Reference | ☐ | | | `commission` | `decimal` | | ☐ | | | `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` | | ☐ | | | `createdAt_1` | `datetime` | | ☐ | | | `createdAt` | `datetime` | | ☐ | | | `date` | `datetime` | Date | ☐ | | | `deletedAt_1` | `datetime` | | ☐ | | | `deletedAt` | `datetime` | | ☐ | | | `description` | `string` | Description | ☐ | | | `endClient__metadata_description` | `string` | | ☐ | | | `endClient__metadata_href` | `string` | | ☐ | | | `endClient__metadata_resource` | `string` | | ☐ | | | `endClient__metadata_resourceTypeId` | `string` | | ☐ | | | `endClient_address_addressLine1` | `string` | | ☐ | | | `endClient_address_addressLine2` | `string` | | ☐ | | | `endClient_address_city` | `string` | | ☐ | | | `endClient_address_country` | `string` | | ☐ | | | `endClient_address_latitude` | `double` | | ☐ | | | `endClient_address_longitude` | `double` | | ☐ | | | `endClient_address_postalCode` | `string` | | ☐ | | | `endClient_archivedAt` | `datetime` | | ☐ | | | `endClient_assignedUser__metadata_description` | `string` | | ☐ | | | `endClient_assignedUser__metadata_href` | `string` | | ☐ | | | `endClient_assignedUser__metadata_resource` | `string` | | ☐ | | | `endClient_assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `endClient_assignedUser_archivedAt` | `datetime` | | ☐ | | | `endClient_assignedUser_createdAt` | `datetime` | | ☐ | | | `endClient_assignedUser_deletedAt` | `datetime` | | ☐ | | | `endClient_assignedUser_email` | `string` | | ☐ | | | `endClient_assignedUser_emailAccount_from` | `string` | | ☐ | | | `endClient_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `endClient_assignedUser_extraFields` | `string` | | ☐ | | | `endClient_assignedUser_fullName` | `string` | | ☐ | | | `endClient_assignedUser_id` | `string` | | ☐ | | | `endClient_assignedUser_locale` | `string` | | ☐ | | | `endClient_assignedUser_locked` | `boolean` | | ☐ | | | `endClient_assignedUser_lockedAt` | `datetime` | | ☐ | | | `endClient_assignedUser_updatedAt` | `datetime` | | ☐ | | | `endClient_assignedUserId` | `string` | | ☐ | | | `endClient_createdAt` | `datetime` | | ☐ | | | `endClient_creditStatus` | `string` | | ☐ | | | `endClient_deletedAt` | `datetime` | | ☐ | | | `endClient_email` | `string` | | ☐ | | | `endClient_extraFields` | `string` | | ☐ | | | `endClient_fax` | `string` | | ☐ | | | `endClient_followUpDate` | `datetime` | | ☐ | | | `endClient_generalLedgerAccount__metadata_description` | `string` | | ☐ | | | `endClient_generalLedgerAccount__metadata_href` | `string` | | ☐ | | | `endClient_generalLedgerAccount__metadata_resource` | `string` | | ☐ | | | `endClient_generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | | | `endClient_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `endClient_generalLedgerAccount_code` | `string` | | ☐ | | | `endClient_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `endClient_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `endClient_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `endClient_generalLedgerAccount_id` | `string` | | ☐ | | | `endClient_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `endClient_generalLedgerAccount_name` | `string` | | ☐ | | | `endClient_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `endClient_generalLedgerAccountId` | `string` | | ☐ | | | `endClient_gsm` | `string` | | ☐ | | | `endClient_id` | `string` | | ☐ | | | `endClient_invoiceAddress_addressLine1` | `string` | | ☐ | | | `endClient_invoiceAddress_addressLine2` | `string` | | ☐ | | | `endClient_invoiceAddress_city` | `string` | | ☐ | | | `endClient_invoiceAddress_country` | `string` | | ☐ | | | `endClient_invoiceAddress_latitude` | `double` | | ☐ | | | `endClient_invoiceAddress_longitude` | `double` | | ☐ | | | `endClient_invoiceAddress_postalCode` | `string` | | ☐ | | | `endClient_invoiceEmail` | `string` | | ☐ | | | `endClient_language` | `string` | | ☐ | | | `endClient_legalForm__metadata_description` | `string` | | ☐ | | | `endClient_legalForm__metadata_href` | `string` | | ☐ | | | `endClient_legalForm__metadata_resource` | `string` | | ☐ | | | `endClient_legalForm__metadata_resourceTypeId` | `string` | | ☐ | | | `endClient_legalForm_archivedAt` | `datetime` | | ☐ | | | `endClient_legalForm_createdAt` | `datetime` | | ☐ | | | `endClient_legalForm_deletedAt` | `datetime` | | ☐ | | | `endClient_legalForm_extraFields` | `string` | | ☐ | | | `endClient_legalForm_id` | `string` | | ☐ | | | `endClient_legalForm_legalAbbreviation` | `string` | | ☐ | | | `endClient_legalForm_lockedAt` | `datetime` | | ☐ | | | `endClient_legalForm_name` | `string` | | ☐ | | | `endClient_legalForm_updatedAt` | `datetime` | | ☐ | | | `endClient_legalForm_vatLiable` | `boolean` | | ☐ | | | `endClient_legalFormId` | `string` | | ☐ | | | `endClient_lockedAt` | `datetime` | | ☐ | | | `endClient_name` | `string` | | ☐ | | | `endClient_paymentCondition__metadata_description` | `string` | | ☐ | | | `endClient_paymentCondition__metadata_href` | `string` | | ☐ | | | `endClient_paymentCondition__metadata_resource` | `string` | | ☐ | | | `endClient_paymentCondition__metadata_resourceTypeId` | `string` | | ☐ | | | `endClient_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `endClient_paymentCondition_createdAt` | `datetime` | | ☐ | | | `endClient_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `endClient_paymentCondition_extraFields` | `string` | | ☐ | | | `endClient_paymentCondition_id` | `string` | | ☐ | | | `endClient_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `endClient_paymentCondition_name` | `string` | | ☐ | | | `endClient_paymentCondition_purchase` | `boolean` | | ☐ | | | `endClient_paymentCondition_sales` | `boolean` | | ☐ | | | `endClient_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `endClient_paymentConditionId` | `string` | | ☐ | | | `endClient_priceGroupId` | `string` | | ☐ | | | `endClient_status` | `string` | | ☐ | | | `endClient_statusDetails_color` | `string` | | ☐ | | | `endClient_statusDetails_name` | `string` | | ☐ | | | `endClient_tel` | `string` | | ☐ | | | `endClient_title` | `string` | | ☐ | | | `endClient_updatedAt` | `datetime` | | ☐ | | | `endClient_vatIdNumber` | `string` | | ☐ | | | `endClient_vatTariff__metadata_description` | `string` | | ☐ | | | `endClient_vatTariff__metadata_href` | `string` | | ☐ | | | `endClient_vatTariff__metadata_resource` | `string` | | ☐ | | | `endClient_vatTariff__metadata_resourceTypeId` | `string` | | ☐ | | | `endClient_vatTariff_additionalMention` | `string` | | ☐ | | | `endClient_vatTariff_archivedAt` | `datetime` | | ☐ | | | `endClient_vatTariff_category` | `string` | | ☐ | | | `endClient_vatTariff_createdAt` | `datetime` | | ☐ | | | `endClient_vatTariff_deletedAt` | `datetime` | | ☐ | | | `endClient_vatTariff_description` | `string` | | ☐ | | | `endClient_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `endClient_vatTariff_extraFields` | `string` | | ☐ | | | `endClient_vatTariff_id` | `string` | | ☐ | | | `endClient_vatTariff_inclusive` | `boolean` | | ☐ | | | `endClient_vatTariff_lockedAt` | `datetime` | | ☐ | | | `endClient_vatTariff_name` | `string` | | ☐ | | | `endClient_vatTariff_percentage` | `decimal` | | ☐ | | | `endClient_vatTariff_updatedAt` | `datetime` | | ☐ | | | `endClient_vatTariffId` | `string` | | ☐ | | | `endClient_website` | `string` | | ☐ | | | `endClientContact__metadata_description` | `string` | | ☐ | | | `endClientContact__metadata_href` | `string` | | ☐ | | | `endClientContact__metadata_resource` | `string` | | ☐ | | | `endClientContact__metadata_resourceTypeId` | `string` | | ☐ | | | `endClientContact_archivedAt` | `datetime` | | ☐ | | | `endClientContact_createdAt` | `datetime` | | ☐ | | | `endClientContact_deletedAt` | `datetime` | | ☐ | | | `endClientContact_email` | `string` | | ☐ | | | `endClientContact_extraFields` | `string` | | ☐ | | | `endClientContact_gsm` | `string` | | ☐ | | | `endClientContact_id` | `string` | | ☐ | | | `endClientContact_lockedAt` | `datetime` | | ☐ | | | `endClientContact_name` | `string` | | ☐ | | | `endClientContact_position` | `string` | | ☐ | | | `endClientContact_surname` | `string` | | ☐ | | | `endClientContact_tel` | `string` | | ☐ | | | `endClientContact_title` | `string` | | ☐ | | | `endClientContact_updatedAt` | `datetime` | | ☐ | | | `endClientContactId` | `string` | | ☐ | | | `endClientId` | `string` | | ☐ | | | `extraFields_1` | `string` | | ☐ | | | `extraFields` | `string` | | ☐ | | | `formula` | `string` | Formula | ☐ | | | `id_1` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `lockedAt_1` | `datetime` | | ☐ | | | `lockedAt` | `datetime` | | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `name` | `string` | Name | ☐ | | | `offerId` | `string` | | ☐ | Only present when obtained via offer bulk endpoint | | `postId` | `string` | | ☐ | Only present when obtained via post bulk endpoint | | `project__metadata_description` | `string` | | ☐ | | | `project__metadata_href` | `string` | | ☐ | | | `project__metadata_resource` | `string` | | ☐ | | | `project__metadata_resourceTypeId` | `string` | | ☐ | | | `project_archivedAt` | `datetime` | | ☐ | | | `project_checkInAtWork` | `string` | | ☐ | | | `project_client__metadata_description` | `string` | | ☐ | | | `project_client__metadata_href` | `string` | | ☐ | | | `project_client__metadata_resource` | `string` | | ☐ | | | `project_client__metadata_resourceTypeId` | `string` | | ☐ | | | `project_client_address_addressLine1` | `string` | | ☐ | | | `project_client_address_addressLine2` | `string` | | ☐ | | | `project_client_address_city` | `string` | | ☐ | | | `project_client_address_country` | `string` | | ☐ | | | `project_client_address_latitude` | `double` | | ☐ | | | `project_client_address_longitude` | `double` | | ☐ | | | `project_client_address_postalCode` | `string` | | ☐ | | | `project_client_archivedAt` | `datetime` | | ☐ | | | `project_client_assignedUser__metadata_description` | `string` | | ☐ | | | `project_client_assignedUser__metadata_href` | `string` | | ☐ | | | `project_client_assignedUser__metadata_resource` | `string` | | ☐ | | | `project_client_assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `project_client_assignedUser_archivedAt` | `datetime` | | ☐ | | | `project_client_assignedUser_createdAt` | `datetime` | | ☐ | | | `project_client_assignedUser_deletedAt` | `datetime` | | ☐ | | | `project_client_assignedUser_email` | `string` | | ☐ | | | `project_client_assignedUser_emailAccount_from` | `string` | | ☐ | | | `project_client_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `project_client_assignedUser_extraFields` | `string` | | ☐ | | | `project_client_assignedUser_fullName` | `string` | | ☐ | | | `project_client_assignedUser_id` | `string` | | ☐ | | | `project_client_assignedUser_locale` | `string` | | ☐ | | | `project_client_assignedUser_locked` | `boolean` | | ☐ | | | `project_client_assignedUser_lockedAt` | `datetime` | | ☐ | | | `project_client_assignedUser_updatedAt` | `datetime` | | ☐ | | | `project_client_assignedUserId` | `string` | | ☐ | | | `project_client_createdAt` | `datetime` | | ☐ | | | `project_client_creditStatus` | `string` | | ☐ | | | `project_client_deletedAt` | `datetime` | | ☐ | | | `project_client_email` | `string` | | ☐ | | | `project_client_extraFields` | `string` | | ☐ | | | `project_client_fax` | `string` | | ☐ | | | `project_client_followUpDate` | `datetime` | | ☐ | | | `project_client_generalLedgerAccount__metadata_description` | `string` | | ☐ | | | `project_client_generalLedgerAccount__metadata_href` | `string` | | ☐ | | | `project_client_generalLedgerAccount__metadata_resource` | `string` | | ☐ | | | `project_client_generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | | | `project_client_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `project_client_generalLedgerAccount_code` | `string` | | ☐ | | | `project_client_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `project_client_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `project_client_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `project_client_generalLedgerAccount_id` | `string` | | ☐ | | | `project_client_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `project_client_generalLedgerAccount_name` | `string` | | ☐ | | | `project_client_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `project_client_generalLedgerAccountId` | `string` | | ☐ | | | `project_client_gsm` | `string` | | ☐ | | | `project_client_id` | `string` | | ☐ | | | `project_client_invoiceAddress_addressLine1` | `string` | | ☐ | | | `project_client_invoiceAddress_addressLine2` | `string` | | ☐ | | | `project_client_invoiceAddress_city` | `string` | | ☐ | | | `project_client_invoiceAddress_country` | `string` | | ☐ | | | `project_client_invoiceAddress_latitude` | `double` | | ☐ | | | `project_client_invoiceAddress_longitude` | `double` | | ☐ | | | `project_client_invoiceAddress_postalCode` | `string` | | ☐ | | | `project_client_invoiceEmail` | `string` | | ☐ | | | `project_client_language` | `string` | | ☐ | | | `project_client_legalForm__metadata_description` | `string` | | ☐ | | | `project_client_legalForm__metadata_href` | `string` | | ☐ | | | `project_client_legalForm__metadata_resource` | `string` | | ☐ | | | `project_client_legalForm__metadata_resourceTypeId` | `string` | | ☐ | | | `project_client_legalForm_archivedAt` | `datetime` | | ☐ | | | `project_client_legalForm_createdAt` | `datetime` | | ☐ | | | `project_client_legalForm_deletedAt` | `datetime` | | ☐ | | | `project_client_legalForm_extraFields` | `string` | | ☐ | | | `project_client_legalForm_id` | `string` | | ☐ | | | `project_client_legalForm_legalAbbreviation` | `string` | | ☐ | | | `project_client_legalForm_lockedAt` | `datetime` | | ☐ | | | `project_client_legalForm_name` | `string` | | ☐ | | | `project_client_legalForm_updatedAt` | `datetime` | | ☐ | | | `project_client_legalForm_vatLiable` | `boolean` | | ☐ | | | `project_client_legalFormId` | `string` | | ☐ | | | `project_client_lockedAt` | `datetime` | | ☐ | | | `project_client_name` | `string` | | ☐ | | | `project_client_paymentCondition__metadata_description` | `string` | | ☐ | | | `project_client_paymentCondition__metadata_href` | `string` | | ☐ | | | `project_client_paymentCondition__metadata_resource` | `string` | | ☐ | | | `project_client_paymentCondition__metadata_resourceTypeId` | `string` | | ☐ | | | `project_client_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `project_client_paymentCondition_createdAt` | `datetime` | | ☐ | | | `project_client_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `project_client_paymentCondition_extraFields` | `string` | | ☐ | | | `project_client_paymentCondition_id` | `string` | | ☐ | | | `project_client_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `project_client_paymentCondition_name` | `string` | | ☐ | | | `project_client_paymentCondition_purchase` | `boolean` | | ☐ | | | `project_client_paymentCondition_sales` | `boolean` | | ☐ | | | `project_client_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `project_client_paymentConditionId` | `string` | | ☐ | | | `project_client_priceGroupId` | `string` | | ☐ | | | `project_client_status` | `string` | | ☐ | | | `project_client_statusDetails_color` | `string` | | ☐ | | | `project_client_statusDetails_name` | `string` | | ☐ | | | `project_client_tel` | `string` | | ☐ | | | `project_client_title` | `string` | | ☐ | | | `project_client_updatedAt` | `datetime` | | ☐ | | | `project_client_vatIdNumber` | `string` | | ☐ | | | `project_client_vatTariff__metadata_description` | `string` | | ☐ | | | `project_client_vatTariff__metadata_href` | `string` | | ☐ | | | `project_client_vatTariff__metadata_resource` | `string` | | ☐ | | | `project_client_vatTariff__metadata_resourceTypeId` | `string` | | ☐ | | | `project_client_vatTariff_additionalMention` | `string` | | ☐ | | | `project_client_vatTariff_archivedAt` | `datetime` | | ☐ | | | `project_client_vatTariff_category` | `string` | | ☐ | | | `project_client_vatTariff_createdAt` | `datetime` | | ☐ | | | `project_client_vatTariff_deletedAt` | `datetime` | | ☐ | | | `project_client_vatTariff_description` | `string` | | ☐ | | | `project_client_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `project_client_vatTariff_extraFields` | `string` | | ☐ | | | `project_client_vatTariff_id` | `string` | | ☐ | | | `project_client_vatTariff_inclusive` | `boolean` | | ☐ | | | `project_client_vatTariff_lockedAt` | `datetime` | | ☐ | | | `project_client_vatTariff_name` | `string` | | ☐ | | | `project_client_vatTariff_percentage` | `decimal` | | ☐ | | | `project_client_vatTariff_updatedAt` | `datetime` | | ☐ | | | `project_client_vatTariffId` | `string` | | ☐ | | | `project_client_website` | `string` | | ☐ | | | `project_clientContact__metadata_description` | `string` | | ☐ | | | `project_clientContact__metadata_href` | `string` | | ☐ | | | `project_clientContact__metadata_resource` | `string` | | ☐ | | | `project_clientContact__metadata_resourceTypeId` | `string` | | ☐ | | | `project_clientContact_archivedAt` | `datetime` | | ☐ | | | `project_clientContact_createdAt` | `datetime` | | ☐ | | | `project_clientContact_deletedAt` | `datetime` | | ☐ | | | `project_clientContact_email` | `string` | | ☐ | | | `project_clientContact_extraFields` | `string` | | ☐ | | | `project_clientContact_gsm` | `string` | | ☐ | | | `project_clientContact_id` | `string` | | ☐ | | | `project_clientContact_lockedAt` | `datetime` | | ☐ | | | `project_clientContact_name` | `string` | | ☐ | | | `project_clientContact_position` | `string` | | ☐ | | | `project_clientContact_surname` | `string` | | ☐ | | | `project_clientContact_tel` | `string` | | ☐ | | | `project_clientContact_title` | `string` | | ☐ | | | `project_clientContact_updatedAt` | `datetime` | | ☐ | | | `project_clientContactId` | `string` | | ☐ | | | `project_clientId` | `string` | | ☐ | | | `project_clientReference` | `string` | | ☐ | | | `project_company__metadata_description` | `string` | | ☐ | | | `project_company__metadata_href` | `string` | | ☐ | | | `project_company__metadata_resource` | `string` | | ☐ | | | `project_company__metadata_resourceTypeId` | `string` | | ☐ | | | `project_company_address_addressLine1` | `string` | | ☐ | | | `project_company_address_addressLine2` | `string` | | ☐ | | | `project_company_address_city` | `string` | | ☐ | | | `project_company_address_country` | `string` | | ☐ | | | `project_company_address_latitude` | `double` | | ☐ | | | `project_company_address_longitude` | `double` | | ☐ | | | `project_company_address_postalCode` | `string` | | ☐ | | | `project_company_archivedAt` | `datetime` | | ☐ | | | `project_company_createdAt` | `datetime` | | ☐ | | | `project_company_deletedAt` | `datetime` | | ☐ | | | `project_company_extraFields` | `string` | | ☐ | | | `project_company_id` | `string` | | ☐ | | | `project_company_lockedAt` | `datetime` | | ☐ | | | `project_company_name` | `string` | | ☐ | | | `project_company_updatedAt` | `datetime` | | ☐ | | | `project_companyId` | `string` | | ☐ | | | `project_createdAt` | `datetime` | | ☐ | | | `project_date` | `datetime` | | ☐ | | | `project_deletedAt` | `datetime` | | ☐ | | | `project_distance` | `int32` | | ☐ | | | `project_endClient__metadata_description` | `string` | | ☐ | | | `project_endClient__metadata_href` | `string` | | ☐ | | | `project_endClient__metadata_resource` | `string` | | ☐ | | | `project_endClient__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClient_address_addressLine1` | `string` | | ☐ | | | `project_endClient_address_addressLine2` | `string` | | ☐ | | | `project_endClient_address_city` | `string` | | ☐ | | | `project_endClient_address_country` | `string` | | ☐ | | | `project_endClient_address_latitude` | `double` | | ☐ | | | `project_endClient_address_longitude` | `double` | | ☐ | | | `project_endClient_address_postalCode` | `string` | | ☐ | | | `project_endClient_archivedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUser__metadata_description` | `string` | | ☐ | | | `project_endClient_assignedUser__metadata_href` | `string` | | ☐ | | | `project_endClient_assignedUser__metadata_resource` | `string` | | ☐ | | | `project_endClient_assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClient_assignedUser_archivedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUser_createdAt` | `datetime` | | ☐ | | | `project_endClient_assignedUser_deletedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUser_email` | `string` | | ☐ | | | `project_endClient_assignedUser_emailAccount_from` | `string` | | ☐ | | | `project_endClient_assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `project_endClient_assignedUser_extraFields` | `string` | | ☐ | | | `project_endClient_assignedUser_fullName` | `string` | | ☐ | | | `project_endClient_assignedUser_id` | `string` | | ☐ | | | `project_endClient_assignedUser_locale` | `string` | | ☐ | | | `project_endClient_assignedUser_locked` | `boolean` | | ☐ | | | `project_endClient_assignedUser_lockedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUser_updatedAt` | `datetime` | | ☐ | | | `project_endClient_assignedUserId` | `string` | | ☐ | | | `project_endClient_createdAt` | `datetime` | | ☐ | | | `project_endClient_creditStatus` | `string` | | ☐ | | | `project_endClient_deletedAt` | `datetime` | | ☐ | | | `project_endClient_email` | `string` | | ☐ | | | `project_endClient_extraFields` | `string` | | ☐ | | | `project_endClient_fax` | `string` | | ☐ | | | `project_endClient_followUpDate` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccount__metadata_description` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount__metadata_href` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount__metadata_resource` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccount_code` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount_id` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccount_name` | `string` | | ☐ | | | `project_endClient_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `project_endClient_generalLedgerAccountId` | `string` | | ☐ | | | `project_endClient_gsm` | `string` | | ☐ | | | `project_endClient_id` | `string` | | ☐ | | | `project_endClient_invoiceAddress_addressLine1` | `string` | | ☐ | | | `project_endClient_invoiceAddress_addressLine2` | `string` | | ☐ | | | `project_endClient_invoiceAddress_city` | `string` | | ☐ | | | `project_endClient_invoiceAddress_country` | `string` | | ☐ | | | `project_endClient_invoiceAddress_latitude` | `double` | | ☐ | | | `project_endClient_invoiceAddress_longitude` | `double` | | ☐ | | | `project_endClient_invoiceAddress_postalCode` | `string` | | ☐ | | | `project_endClient_invoiceEmail` | `string` | | ☐ | | | `project_endClient_language` | `string` | | ☐ | | | `project_endClient_legalForm__metadata_description` | `string` | | ☐ | | | `project_endClient_legalForm__metadata_href` | `string` | | ☐ | | | `project_endClient_legalForm__metadata_resource` | `string` | | ☐ | | | `project_endClient_legalForm__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClient_legalForm_archivedAt` | `datetime` | | ☐ | | | `project_endClient_legalForm_createdAt` | `datetime` | | ☐ | | | `project_endClient_legalForm_deletedAt` | `datetime` | | ☐ | | | `project_endClient_legalForm_extraFields` | `string` | | ☐ | | | `project_endClient_legalForm_id` | `string` | | ☐ | | | `project_endClient_legalForm_legalAbbreviation` | `string` | | ☐ | | | `project_endClient_legalForm_lockedAt` | `datetime` | | ☐ | | | `project_endClient_legalForm_name` | `string` | | ☐ | | | `project_endClient_legalForm_updatedAt` | `datetime` | | ☐ | | | `project_endClient_legalForm_vatLiable` | `boolean` | | ☐ | | | `project_endClient_legalFormId` | `string` | | ☐ | | | `project_endClient_lockedAt` | `datetime` | | ☐ | | | `project_endClient_name` | `string` | | ☐ | | | `project_endClient_paymentCondition__metadata_description` | `string` | | ☐ | | | `project_endClient_paymentCondition__metadata_href` | `string` | | ☐ | | | `project_endClient_paymentCondition__metadata_resource` | `string` | | ☐ | | | `project_endClient_paymentCondition__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClient_paymentCondition_archivedAt` | `datetime` | | ☐ | | | `project_endClient_paymentCondition_createdAt` | `datetime` | | ☐ | | | `project_endClient_paymentCondition_deletedAt` | `datetime` | | ☐ | | | `project_endClient_paymentCondition_extraFields` | `string` | | ☐ | | | `project_endClient_paymentCondition_id` | `string` | | ☐ | | | `project_endClient_paymentCondition_lockedAt` | `datetime` | | ☐ | | | `project_endClient_paymentCondition_name` | `string` | | ☐ | | | `project_endClient_paymentCondition_purchase` | `boolean` | | ☐ | | | `project_endClient_paymentCondition_sales` | `boolean` | | ☐ | | | `project_endClient_paymentCondition_updatedAt` | `datetime` | | ☐ | | | `project_endClient_paymentConditionId` | `string` | | ☐ | | | `project_endClient_priceGroupId` | `string` | | ☐ | | | `project_endClient_status` | `string` | | ☐ | | | `project_endClient_statusDetails_color` | `string` | | ☐ | | | `project_endClient_statusDetails_name` | `string` | | ☐ | | | `project_endClient_tel` | `string` | | ☐ | | | `project_endClient_title` | `string` | | ☐ | | | `project_endClient_updatedAt` | `datetime` | | ☐ | | | `project_endClient_vatIdNumber` | `string` | | ☐ | | | `project_endClient_vatTariff__metadata_description` | `string` | | ☐ | | | `project_endClient_vatTariff__metadata_href` | `string` | | ☐ | | | `project_endClient_vatTariff__metadata_resource` | `string` | | ☐ | | | `project_endClient_vatTariff__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClient_vatTariff_additionalMention` | `string` | | ☐ | | | `project_endClient_vatTariff_archivedAt` | `datetime` | | ☐ | | | `project_endClient_vatTariff_category` | `string` | | ☐ | | | `project_endClient_vatTariff_createdAt` | `datetime` | | ☐ | | | `project_endClient_vatTariff_deletedAt` | `datetime` | | ☐ | | | `project_endClient_vatTariff_description` | `string` | | ☐ | | | `project_endClient_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `project_endClient_vatTariff_extraFields` | `string` | | ☐ | | | `project_endClient_vatTariff_id` | `string` | | ☐ | | | `project_endClient_vatTariff_inclusive` | `boolean` | | ☐ | | | `project_endClient_vatTariff_lockedAt` | `datetime` | | ☐ | | | `project_endClient_vatTariff_name` | `string` | | ☐ | | | `project_endClient_vatTariff_percentage` | `decimal` | | ☐ | | | `project_endClient_vatTariff_updatedAt` | `datetime` | | ☐ | | | `project_endClient_vatTariffId` | `string` | | ☐ | | | `project_endClient_website` | `string` | | ☐ | | | `project_endClientContact__metadata_description` | `string` | | ☐ | | | `project_endClientContact__metadata_href` | `string` | | ☐ | | | `project_endClientContact__metadata_resource` | `string` | | ☐ | | | `project_endClientContact__metadata_resourceTypeId` | `string` | | ☐ | | | `project_endClientContact_archivedAt` | `datetime` | | ☐ | | | `project_endClientContact_createdAt` | `datetime` | | ☐ | | | `project_endClientContact_deletedAt` | `datetime` | | ☐ | | | `project_endClientContact_email` | `string` | | ☐ | | | `project_endClientContact_extraFields` | `string` | | ☐ | | | `project_endClientContact_gsm` | `string` | | ☐ | | | `project_endClientContact_id` | `string` | | ☐ | | | `project_endClientContact_lockedAt` | `datetime` | | ☐ | | | `project_endClientContact_name` | `string` | | ☐ | | | `project_endClientContact_position` | `string` | | ☐ | | | `project_endClientContact_surname` | `string` | | ☐ | | | `project_endClientContact_tel` | `string` | | ☐ | | | `project_endClientContact_title` | `string` | | ☐ | | | `project_endClientContact_updatedAt` | `datetime` | | ☐ | | | `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_siteAddress_addressLine1` | `string` | | ☐ | | | `project_siteAddress_addressLine2` | `string` | | ☐ | | | `project_siteAddress_city` | `string` | | ☐ | | | `project_siteAddress_country` | `string` | | ☐ | | | `project_siteAddress_latitude` | `double` | | ☐ | | | `project_siteAddress_longitude` | `double` | | ☐ | | | `project_siteAddress_postalCode` | `string` | | ☐ | | | `project_siteManager__metadata_description` | `string` | | ☐ | | | `project_siteManager__metadata_href` | `string` | | ☐ | | | `project_siteManager__metadata_resource` | `string` | | ☐ | | | `project_siteManager__metadata_resourceTypeId` | `string` | | ☐ | | | `project_siteManager_archivedAt` | `datetime` | | ☐ | | | `project_siteManager_createdAt` | `datetime` | | ☐ | | | `project_siteManager_deletedAt` | `datetime` | | ☐ | | | `project_siteManager_email` | `string` | | ☐ | | | `project_siteManager_emailAccount_from` | `string` | | ☐ | | | `project_siteManager_emailAccountActive` | `boolean` | | ☐ | | | `project_siteManager_extraFields` | `string` | | ☐ | | | `project_siteManager_fullName` | `string` | | ☐ | | | `project_siteManager_id` | `string` | | ☐ | | | `project_siteManager_locale` | `string` | | ☐ | | | `project_siteManager_locked` | `boolean` | | ☐ | | | `project_siteManager_lockedAt` | `datetime` | | ☐ | | | `project_siteManager_updatedAt` | `datetime` | | ☐ | | | `project_siteManagerId` | `string` | | ☐ | | | `project_siteNssoIdNumber` | `string` | | ☐ | | | `project_status` | `string` | | ☐ | | | `project_statusDetails_color` | `string` | | ☐ | | | `project_statusDetails_name` | `string` | | ☐ | | | `project_updatedAt` | `datetime` | | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `settlementId` | `string` | | ☐ | Only present when obtained via settlement bulk endpoint | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `statusSuccessPercentage` | `decimal` | | ☐ | | | `TEXT` | `string` | | ☐ | | | `textValue` | `string` | Text Value | ☐ | | | `title` | `string` | Title | ☐ | | | `totalExclVat` | `decimal` | | ☐ | | | `totalInclVat` | `decimal` | | ☐ | | | `totalIndirectCosts` | `decimal` | Total Indirect Costs | ☐ | | | `updatedAt_1` | `datetime` | | ☐ | | | `updatedAt` | `datetime` | | ☐ | | | `value` | `decimal` | Value | ☐ | |