# Clients_ItemsContactIds 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: `Clients` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `email` | `string` | ☐ | | | | `logicId` | `string` | ☐ | | | | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `updatedFrom` | `datetime` | ☐ | | | | `vatIdNumber` | `string` | ☐ | | | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `Clients_ItemsContactIds` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `address_addressLine1` | `string` | | ☐ | | | `address_addressLine2` | `string` | | ☐ | | | `address_city` | `string` | City | ☐ | | | `address_country` | `string` | Country | ☐ | | | `address_latitude` | `double` | | ☐ | | | `address_longitude` | `double` | | ☐ | | | `address_postalCode` | `string` | | ☐ | | | `archivedAt` | `datetime` | | ☐ | | | `assignedUser__metadata_description` | `string` | | ☐ | | | `assignedUser__metadata_href` | `string` | | ☐ | | | `assignedUser__metadata_resource` | `string` | | ☐ | | | `assignedUser__metadata_resourceTypeId` | `string` | | ☐ | | | `assignedUser_archivedAt` | `datetime` | | ☐ | | | `assignedUser_createdAt` | `datetime` | | ☐ | | | `assignedUser_deletedAt` | `datetime` | | ☐ | | | `assignedUser_email` | `string` | | ☐ | | | `assignedUser_emailAccount_from` | `string` | | ☐ | | | `assignedUser_emailAccountActive` | `boolean` | | ☐ | | | `assignedUser_extraFields` | `string` | | ☐ | | | `assignedUser_fullName` | `string` | | ☐ | | | `assignedUser_id` | `string` | | ☐ | | | `assignedUser_locale` | `string` | | ☐ | | | `assignedUser_locked` | `boolean` | | ☐ | | | `assignedUser_lockedAt` | `datetime` | | ☐ | | | `assignedUser_updatedAt` | `datetime` | | ☐ | | | `assignedUserId` | `string` | | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `createdAt` | `datetime` | | ☐ | | | `creditStatus` | `string` | Credit Status | ☐ | | | `deletedAt` | `datetime` | | ☐ | | | `email` | `string` | E-mail | ☐ | | | `extraFields` | `string` | | ☐ | | | `fax` | `string` | Fax | ☐ | | | `followUpDate` | `datetime` | Follow-up Date | ☐ | | | `generalLedgerAccount__metadata_description` | `string` | | ☐ | | | `generalLedgerAccount__metadata_href` | `string` | | ☐ | | | `generalLedgerAccount__metadata_resource` | `string` | | ☐ | | | `generalLedgerAccount__metadata_resourceTypeId` | `string` | | ☐ | | | `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` | | ☐ | | | `gsm` | `string` | Mobile | ☐ | | | `id` | `string` | ID | ☐ | | | `invoiceAddress_addressLine1` | `string` | | ☐ | | | `invoiceAddress_addressLine2` | `string` | | ☐ | | | `invoiceAddress_city` | `string` | | ☐ | | | `invoiceAddress_country` | `string` | | ☐ | | | `invoiceAddress_latitude` | `double` | | ☐ | | | `invoiceAddress_longitude` | `double` | | ☐ | | | `invoiceAddress_postalCode` | `string` | | ☐ | | | `invoiceEmail` | `string` | Invoice Email | ☐ | | | `language` | `string` | Language | ☐ | | | `legalForm__metadata_description` | `string` | | ☐ | | | `legalForm__metadata_href` | `string` | | ☐ | | | `legalForm__metadata_resource` | `string` | | ☐ | | | `legalForm__metadata_resourceTypeId` | `string` | | ☐ | | | `legalForm_archivedAt` | `datetime` | | ☐ | | | `legalForm_createdAt` | `datetime` | | ☐ | | | `legalForm_deletedAt` | `datetime` | | ☐ | | | `legalForm_extraFields` | `string` | | ☐ | | | `legalForm_id` | `string` | Legal Form ID | ☐ | | | `legalForm_legalAbbreviation` | `string` | | ☐ | | | `legalForm_lockedAt` | `datetime` | | ☐ | | | `legalForm_name` | `string` | Legal Form Name | ☐ | | | `legalForm_updatedAt` | `datetime` | | ☐ | | | `legalForm_vatLiable` | `boolean` | | ☐ | | | `legalFormId` | `string` | | ☐ | | | `lockedAt` | `datetime` | | ☐ | | | `name` | `string` | Name | ☐ | | | `paymentCondition__metadata_description` | `string` | | ☐ | | | `paymentCondition__metadata_href` | `string` | | ☐ | | | `paymentCondition__metadata_resource` | `string` | | ☐ | | | `paymentCondition__metadata_resourceTypeId` | `string` | | ☐ | | | `paymentCondition_archivedAt` | `datetime` | | ☐ | | | `paymentCondition_createdAt` | `datetime` | | ☐ | | | `paymentCondition_deletedAt` | `datetime` | | ☐ | | | `paymentCondition_extraFields` | `string` | | ☐ | | | `paymentCondition_id` | `string` | | ☐ | | | `paymentCondition_lockedAt` | `datetime` | | ☐ | | | `paymentCondition_name` | `string` | | ☐ | | | `paymentCondition_purchase` | `boolean` | | ☐ | | | `paymentCondition_sales` | `boolean` | | ☐ | | | `paymentCondition_updatedAt` | `datetime` | | ☐ | | | `paymentConditionId` | `string` | | ☐ | | | `priceGroupId` | `string` | | ☐ | | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `tel` | `string` | Phone | ☐ | | | `TEXT` | `string` | | ☐ | Only present in webhook events. | | `title` | `string` | Title | ☐ | | | `updatedAt` | `datetime` | | ☐ | | | `vatIdNumber` | `string` | | ☐ | | | `vatTariff__metadata_description` | `string` | | ☐ | | | `vatTariff__metadata_href` | `string` | | ☐ | | | `vatTariff__metadata_resource` | `string` | | ☐ | | | `vatTariff__metadata_resourceTypeId` | `string` | | ☐ | | | `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` | | ☐ | | | `website` | `string` | Website | ☐ | |