# Suppliers_ContactIdsById 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: `Suppliers` ## Columns The columns of the table `Suppliers_ContactIdsById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `createdAt` | `datetime` | | ☐ | | | `deletedAt` | `datetime` | | ☐ | | | `email` | `string` | E-mail | ☐ | | | `extraFields` | `string` | | ☐ | | | `fax` | `string` | Fax | ☐ | | | `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 | ☐ | | | `iban` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `invoiceAddress_addressLine1` | `string` | | ☐ | | | `invoiceAddress_addressLine2` | `string` | | ☐ | | | `invoiceAddress_city` | `string` | | ☐ | | | `invoiceAddress_country` | `string` | | ☐ | | | `invoiceAddress_latitude` | `double` | | ☐ | | | `invoiceAddress_longitude` | `double` | | ☐ | | | `invoiceAddress_postalCode` | `string` | | ☐ | | | `invoiceRemarks` | `string` | Invoice Remarks | ☐ | | | `kvk` | `string` | | ☐ | | | `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` | | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `name` | `string` | Name | ☐ | | | `paymentConditionId` | `string` | | ☐ | | | `planningEmail` | `string` | | ☐ | | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `supplyOrderRemarks` | `string` | | ☐ | | | `tel` | `string` | Phone | ☐ | | | `TEXT` | `string` | | ☐ | Only present in webhook events. | | `type` | `string` | Type | ☐ | | | `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 | ☐ | |