# ProjectConstructionPartnerIdsByProjectId: ROBAWS ID's projectbouwpartners per project-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: `ProjectConstructionPartners` - Label: Project Construction Partner IDs by Project ID ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☐ | | | | `projectId` | `string` | ☐ | | | ## Columns The columns of the table `ProjectConstructionPartnerIdsByProjectId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | Archived at | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `id` | `string` | ID | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `project__metadata_description` | `string` | | ☐ | | | `project__metadata_href` | `string` | | ☐ | | | `project__metadata_resource` | `string` | | ☐ | | | `project__metadata_resourceTypeId` | `string` | | ☐ | | | `project_archivedAt` | `datetime` | | ☐ | | | `project_checkInAtWork` | `string` | | ☐ | | | `project_client_archivedAt` | `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_generalLedgerAccountId` | `string` | | ☐ | | | `project_client_gsm` | `string` | | ☐ | | | `project_client_id` | `string` | | ☐ | | | `project_client_invoiceEmail` | `string` | | ☐ | | | `project_client_language` | `string` | | ☐ | | | `project_client_legalFormId` | `string` | | ☐ | | | `project_client_lockedAt` | `datetime` | | ☐ | | | `project_client_name` | `string` | | ☐ | | | `project_client_paymentConditionId` | `string` | | ☐ | | | `project_client_priceGroupId` | `string` | | ☐ | | | `project_client_status` | `string` | | ☐ | | | `project_client_tel` | `string` | | ☐ | | | `project_client_title` | `string` | | ☐ | | | `project_client_updatedAt` | `datetime` | | ☐ | | | `project_client_vatIdNumber` | `string` | | ☐ | | | `project_client_vatTariffId` | `string` | | ☐ | | | `project_client_website` | `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_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_archivedAt` | `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_generalLedgerAccountId` | `string` | | ☐ | | | `project_endClient_gsm` | `string` | | ☐ | | | `project_endClient_id` | `string` | | ☐ | | | `project_endClient_invoiceEmail` | `string` | | ☐ | | | `project_endClient_language` | `string` | | ☐ | | | `project_endClient_legalFormId` | `string` | | ☐ | | | `project_endClient_lockedAt` | `datetime` | | ☐ | | | `project_endClient_name` | `string` | | ☐ | | | `project_endClient_paymentConditionId` | `string` | | ☐ | | | `project_endClient_priceGroupId` | `string` | | ☐ | | | `project_endClient_status` | `string` | | ☐ | | | `project_endClient_tel` | `string` | | ☐ | | | `project_endClient_title` | `string` | | ☐ | | | `project_endClient_updatedAt` | `datetime` | | ☐ | | | `project_endClient_vatIdNumber` | `string` | | ☐ | | | `project_endClient_vatTariffId` | `string` | | ☐ | | | `project_endClient_website` | `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_archivedAt` | `datetime` | | ☐ | | | `project_siteManager_createdAt` | `datetime` | | ☐ | | | `project_siteManager_deletedAt` | `datetime` | | ☐ | | | `project_siteManager_email` | `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 | ☐ | | | `receivesClaimStates` | `boolean` | Receives Claim Statements | ☐ | | | `supplier__metadata_description` | `string` | | ☐ | | | `supplier__metadata_href` | `string` | | ☐ | | | `supplier__metadata_resource` | `string` | | ☐ | | | `supplier__metadata_resourceTypeId` | `string` | | ☐ | | | `supplier_archivedAt` | `datetime` | | ☐ | | | `supplier_createdAt` | `datetime` | | ☐ | | | `supplier_deletedAt` | `datetime` | | ☐ | | | `supplier_email` | `string` | | ☐ | | | `supplier_extraFields` | `string` | | ☐ | | | `supplier_fax` | `string` | | ☐ | | | `supplier_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `supplier_generalLedgerAccount_code` | `string` | | ☐ | | | `supplier_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `supplier_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `supplier_generalLedgerAccount_extraFields` | `string` | | ☐ | | | `supplier_generalLedgerAccount_id` | `string` | | ☐ | | | `supplier_generalLedgerAccount_lockedAt` | `datetime` | | ☐ | | | `supplier_generalLedgerAccount_name` | `string` | | ☐ | | | `supplier_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `supplier_generalLedgerAccountId` | `string` | | ☐ | | | `supplier_gsm` | `string` | | ☐ | | | `supplier_iban` | `string` | | ☐ | | | `supplier_id` | `string` | | ☐ | | | `supplier_invoiceAddress_addressLine1` | `string` | | ☐ | | | `supplier_invoiceAddress_addressLine2` | `string` | | ☐ | | | `supplier_invoiceAddress_city` | `string` | | ☐ | | | `supplier_invoiceAddress_country` | `string` | | ☐ | | | `supplier_invoiceAddress_latitude` | `double` | | ☐ | | | `supplier_invoiceAddress_longitude` | `double` | | ☐ | | | `supplier_invoiceAddress_postalCode` | `string` | | ☐ | | | `supplier_invoiceRemarks` | `string` | | ☐ | | | `supplier_kvk` | `string` | | ☐ | | | `supplier_language` | `string` | | ☐ | | | `supplier_legalForm_archivedAt` | `datetime` | | ☐ | | | `supplier_legalForm_createdAt` | `datetime` | | ☐ | | | `supplier_legalForm_deletedAt` | `datetime` | | ☐ | | | `supplier_legalForm_extraFields` | `string` | | ☐ | | | `supplier_legalForm_id` | `string` | | ☐ | | | `supplier_legalForm_legalAbbreviation` | `string` | | ☐ | | | `supplier_legalForm_lockedAt` | `datetime` | | ☐ | | | `supplier_legalForm_name` | `string` | | ☐ | | | `supplier_legalForm_updatedAt` | `datetime` | | ☐ | | | `supplier_legalForm_vatLiable` | `boolean` | | ☐ | | | `supplier_legalFormId` | `string` | | ☐ | | | `supplier_lockedAt` | `datetime` | | ☐ | | | `supplier_logicId` | `string` | | ☐ | | | `supplier_name` | `string` | | ☐ | | | `supplier_paymentConditionId` | `string` | | ☐ | | | `supplier_planningEmail` | `string` | | ☐ | | | `supplier_status` | `string` | | ☐ | | | `supplier_statusDetails_color` | `string` | | ☐ | | | `supplier_statusDetails_name` | `string` | | ☐ | | | `supplier_supplyOrderRemarks` | `string` | | ☐ | | | `supplier_tel` | `string` | | ☐ | | | `supplier_type` | `string` | | ☐ | | | `supplier_updatedAt` | `datetime` | | ☐ | | | `supplier_vatIdNumber` | `string` | | ☐ | | | `supplier_vatTariff_additionalMention` | `string` | | ☐ | | | `supplier_vatTariff_archivedAt` | `datetime` | | ☐ | | | `supplier_vatTariff_category` | `string` | | ☐ | | | `supplier_vatTariff_createdAt` | `datetime` | | ☐ | | | `supplier_vatTariff_deletedAt` | `datetime` | | ☐ | | | `supplier_vatTariff_description` | `string` | | ☐ | | | `supplier_vatTariff_excludedFromFinancialDiscount` | `boolean` | | ☐ | | | `supplier_vatTariff_extraFields` | `string` | | ☐ | | | `supplier_vatTariff_id` | `string` | | ☐ | | | `supplier_vatTariff_inclusive` | `boolean` | | ☐ | | | `supplier_vatTariff_lockedAt` | `datetime` | | ☐ | | | `supplier_vatTariff_name` | `string` | | ☐ | | | `supplier_vatTariff_percentage` | `decimal` | | ☐ | | | `supplier_vatTariff_updatedAt` | `datetime` | | ☐ | | | `supplier_vatTariffId` | `string` | | ☐ | | | `supplier_website` | `string` | | ☐ | | | `supplierContact__metadata_description` | `string` | | ☐ | | | `supplierContact__metadata_href` | `string` | | ☐ | | | `supplierContact__metadata_resource` | `string` | | ☐ | | | `supplierContact__metadata_resourceTypeId` | `string` | | ☐ | | | `supplierContact_archivedAt` | `datetime` | | ☐ | | | `supplierContact_createdAt` | `datetime` | | ☐ | | | `supplierContact_deletedAt` | `datetime` | | ☐ | | | `supplierContact_email` | `string` | | ☐ | | | `supplierContact_extraFields` | `string` | | ☐ | | | `supplierContact_gsm` | `string` | | ☐ | | | `supplierContact_id` | `string` | | ☐ | | | `supplierContact_lockedAt` | `datetime` | | ☐ | | | `supplierContact_name` | `string` | | ☐ | | | `supplierContact_position` | `string` | | ☐ | | | `supplierContact_surname` | `string` | | ☐ | | | `supplierContact_tel` | `string` | | ☐ | | | `supplierContact_title` | `string` | | ☐ | | | `supplierContact_updatedAt` | `datetime` | | ☐ | | | `supplierContactId` | `string` | Supplier Contact ID | ☐ | | | `supplierId` | `string` | Supplier ID | ☐ | | | `type` | `string` | Type | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | |