Please enable JavaScript to view this site.

Navigation: Schema: ProjectConstructionsPartners > Tables

ProjectConstructionPartnersByProjectId

Find all

Catalog: Robaws

Schema: ProjectConstructionsPartners

This is a read-only table function. The Robaws API may not support changing the data or the Invantive SQL driver for Robaws does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Robaws API.

Select Robaws API URL: /api/v2/projects/{projectId}/construction-partners

Insert Robaws API URL: /api/v2/projects/{projectId}/construction-partners

Update Robaws API URL: /api/v2/projects/{projectId}/construction-partners

Delete Robaws API URL: /api/v2/projects/{projectId}/construction-partners

Field Selection Method: NotRequired

Base Path: items[*]

Select Robaws API Operation: get /api/v2/projects/{projectId}/construction-partners

Table Function Columns

The columns of the table function ProjectConstructionPartnersByProjectId are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

archivedAt

datetime

 

☐

 

createdAt

datetime

 

☐

 

deletedAt

datetime

 

☐

 

id

string

ID

☐

 

project_archivedAt

datetime

 

☐

 

project_checkInAtWork

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_assignedUserId

string

 

☐

 

project_client_createdAt

datetime

 

☐

 

project_client_deletedAt

datetime

 

☐

 

project_client_email

string

 

☐

 

project_client_fax

string

 

☐

 

project_client_generalLedgerAccount_archivedAt

datetime

 

☐

 

project_client_generalLedgerAccount_code

string

 

☐

 

project_client_generalLedgerAccount_createdAt

datetime

 

☐

 

project_client_generalLedgerAccount_deletedAt

datetime

 

☐

 

project_client_generalLedgerAccount_id

string

 

☐

 

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_archivedAt

datetime

 

☐

 

project_client_legalForm_createdAt

datetime

 

☐

 

project_client_legalForm_deletedAt

datetime

 

☐

 

project_client_legalForm_id

string

 

☐

 

project_client_legalForm_legalAbbreviation

string

 

☐

 

project_client_legalForm_name

string

 

☐

 

project_client_legalForm_updatedAt

datetime

 

☐

 

project_client_legalForm_vatLiable

boolean

 

☐

 

project_client_legalFormId

string

 

☐

 

project_client_name

string

 

☐

 

project_client_paymentCondition_archivedAt

datetime

 

☐

 

project_client_paymentCondition_createdAt

datetime

 

☐

 

project_client_paymentCondition_deletedAt

datetime

 

☐

 

project_client_paymentCondition_id

string

 

☐

 

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_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_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_id

string

 

☐

 

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_archivedAt

datetime

 

☐

 

project_clientContact_createdAt

datetime

 

☐

 

project_clientContact_deletedAt

datetime

 

☐

 

project_clientContact_email

string

 

☐

 

project_clientContact_gsm

string

 

☐

 

project_clientContact_id

string

 

☐

 

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_createdAt

datetime

 

☐

 

project_date

datetime

 

☐

 

project_deletedAt

datetime

 

☐

 

project_distance

int32

 

☐

 

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_assignedUserId

string

 

☐

 

project_endClient_createdAt

datetime

 

☐

 

project_endClient_deletedAt

datetime

 

☐

 

project_endClient_email

string

 

☐

 

project_endClient_fax

string

 

☐

 

project_endClient_generalLedgerAccount_archivedAt

datetime

 

☐

 

project_endClient_generalLedgerAccount_code

string

 

☐

 

project_endClient_generalLedgerAccount_createdAt

datetime

 

☐

 

project_endClient_generalLedgerAccount_deletedAt

datetime

 

☐

 

project_endClient_generalLedgerAccount_id

string

 

☐

 

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_archivedAt

datetime

 

☐

 

project_endClient_legalForm_createdAt

datetime

 

☐

 

project_endClient_legalForm_deletedAt

datetime

 

☐

 

project_endClient_legalForm_id

string

 

☐

 

project_endClient_legalForm_legalAbbreviation

string

 

☐

 

project_endClient_legalForm_name

string

 

☐

 

project_endClient_legalForm_updatedAt

datetime

 

☐

 

project_endClient_legalForm_vatLiable

boolean

 

☐

 

project_endClient_legalFormId

string

 

☐

 

project_endClient_name

string

 

☐

 

project_endClient_paymentCondition_archivedAt

datetime

 

☐

 

project_endClient_paymentCondition_createdAt

datetime

 

☐

 

project_endClient_paymentCondition_deletedAt

datetime

 

☐

 

project_endClient_paymentCondition_id

string

 

☐

 

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_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_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_id

string

 

☐

 

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_archivedAt

datetime

 

☐

 

project_endClientContact_createdAt

datetime

 

☐

 

project_endClientContact_deletedAt

datetime

 

☐

 

project_endClientContact_email

string

 

☐

 

project_endClientContact_gsm

string

 

☐

 

project_endClientContact_id

string

 

☐

 

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_id

string

 

☐

 

project_logicId

string

 

☐

 

project_nssoDeclarationOfWorks

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_fullName

string

 

☐

 

project_siteManager_id

string

 

☐

 

project_siteManager_locked

boolean

 

☐

 

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

 

☐

 

supplier_archivedAt

datetime

 

☐

 

supplier_createdAt

datetime

 

☐

 

supplier_deletedAt

datetime

 

☐

 

supplier_email

string

 

☐

 

supplier_fax

string

 

☐

 

supplier_generalLedgerAccount_archivedAt

datetime

 

☐

 

supplier_generalLedgerAccount_code

string

 

☐

 

supplier_generalLedgerAccount_createdAt

datetime

 

☐

 

supplier_generalLedgerAccount_deletedAt

datetime

 

☐

 

supplier_generalLedgerAccount_id

string

 

☐

 

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_id

string

 

☐

 

supplier_legalForm_legalAbbreviation

string

 

☐

 

supplier_legalForm_name

string

 

☐

 

supplier_legalForm_updatedAt

datetime

 

☐

 

supplier_legalForm_vatLiable

boolean

 

☐

 

supplier_legalFormId

string

 

☐

 

supplier_logicId

string

 

☐

 

supplier_name

string

 

☐

 

supplier_paymentConditionId

string

 

☐

 

supplier_planningEmail

string

 

☐

 

supplier_status

string

 

☐

 

supplier_supplyOrderRemarks

string

 

☐

 

supplier_tel

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_id

string

 

☐

 

supplier_vatTariff_name

string

 

☐

 

supplier_vatTariff_percentage

decimal

 

☐

 

supplier_vatTariff_updatedAt

datetime

 

☐

 

supplier_vatTariffId

string

 

☐

 

supplier_website

string

 

☐

 

supplierContact_archivedAt

datetime

 

☐

 

supplierContact_createdAt

datetime

 

☐

 

supplierContact_deletedAt

datetime

 

☐

 

supplierContact_email

string

 

☐

 

supplierContact_gsm

string

 

☐

 

supplierContact_id

string

 

☐

 

supplierContact_name

string

 

☐

 

supplierContact_position

string

 

☐

 

supplierContact_surname

string

 

☐

 

supplierContact_tel

string

 

☐

 

supplierContact_title

string

 

☐

 

supplierContact_updatedAt

datetime

 

☐

 

supplierContactId

string

 

☐

 

supplierId

string

 

☐

 

type

string

Type

☐

 

updatedAt

datetime

 

☐

 

 

17-06-2022 11:59 Version 22.1.46-BETA+3385