# ProjectEmployeesByProjectId: Bouw7 Project Employees by Project ID Returns a project associated with the given id. Returns a project associated with the given id. - Catalog: `Bouw7` - Schema: `Project` - Label: Project Employees by Project ID This is a read-only table function. The Bouw7 API may not support changing the data or the Invantive UniversalSQL driver for Bouw7 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Bouw7 API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `ProjectEmployeesByProjectId`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `project` | `` | ☑ | | Project ID | ## Columns of Table Function The columns of the table function `ProjectEmployeesByProjectId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `additionalWork` | `varchar2` | Additional Work | ☐ | Additional work amount for the project. | | `avatarFileHash` | `varchar2` | Avatar File Hash | ☐ | File hash of the avatar which belongs to the employee. | | `branch_code` | `varchar2` | Branch Code | ☐ | The code for this branch | | `branch_division_description` | `varchar2` | | ☐ | The description of the division. | | `branch_division_exactDivisionId` | `varchar2` | | ☐ | The division ID of an Exact Online environment. | | `branch_division_glAccountCode` | `varchar2` | | ☐ | A default general ledger account code to use for sales related items. | | `branch_division_glAccountCodePurchase` | `varchar2` | | ☐ | A default general ledger account code to use for purchase related items. | | `branch_division_id` | `int64` | | ☐ | The ID of the division. | | `branch_division_journalCode` | `varchar2` | | ☐ | A default journal code to use for sales related items. | | `branch_division_journalCodePurchase` | `varchar2` | | ☐ | A default journal code to use for purchase related items. | | `branch_division_salesInvoiceNumberPrefix` | `varchar2`(3) | | ☐ | The prefix (3 digits) used to generate invoice number range per division. | | `branch_id` | `int64` | Branch ID | ☐ | The ID of the branch. | | `branch_name` | `varchar2` | Branch Name | ☐ | The name of this branch | | `category_code` | `varchar2` | Category Code | ☐ | The code for the category. | | `category_createdAt` | `datetime` | Category Created at | ☐ | The creation time of the entity. | | `category_createdBy` | `varchar2` | Category Created by | ☐ | The user that created the entity. | | `category_generalCostsPercentage` | `varchar2` | Category General Costs Percentage | ☐ | The general costs percentage for the category. | | `category_grossProfitMargin` | `varchar2` | Category Gross Profit Margin | ☐ | The gross profit margin for the category. | | `category_id` | `int64` | Category ID | ☐ | The ID of the category. | | `category_name` | `varchar2` | Category Name | ☐ | The name of the category. | | `category_updatedAt` | `datetime` | Category Updated at | ☐ | The last updated time of the entity. | | `category_updatedBy` | `varchar2` | Category Updated by | ☐ | The user that last updated the entity. | | `city` | `varchar2` | City | ☐ | The city of the project. | | `contact_contactType_id` | `int64` | Contact Contact Type ID | ☐ | The ID of contact type. | | `contact_contactType_name` | `varchar2` | Contact Contact Type Name | ☐ | The name of contact type. | | `contact_email` | `varchar2` | Contact Email | ☐ | The email address. | | `contact_id` | `int64` | Contact ID | ☐ | ID of contact. | | `contact_isVatShifted` | `char` | Contact Is VAT Shifted | ☐ | Whether VAT is shifted for the contact. | | `contact_name` | `varchar2` | Contact Name | ☐ | Name of contact. | | `contact_phoneNumber` | `varchar2` | Contact Phone Number | ☐ | The phone number of the contact. | | `contactPerson_city` | `varchar2` | Contact Person City | ☐ | The contact person's city. | | `contactPerson_createdAt` | `datetime` | Contact Person Created at | ☐ | The creation time of the entity. | | `contactPerson_createdBy` | `varchar2` | Contact Person Created by | ☐ | The user that created the entity. | | `contactPerson_email` | `varchar2` | Contact Person Email | ☐ | The contact person's email address. | | `contactPerson_firstName` | `varchar2` | Contact Person First Name | ☐ | The contact person's first name. | | `contactPerson_houseNumber` | `varchar2`(50) | Contact Person House Number | ☐ | The contact person's house number. | | `contactPerson_id` | `int64` | Contact Person ID | ☐ | The ID of contact person. | | `contactPerson_lastName` | `varchar2` | Contact Person Last Name | ☐ | The contact person's last name. | | `contactPerson_phoneNumber` | `varchar2` | Contact Person Phone Number | ☐ | The contact person's phone number. | | `contactPerson_streetName` | `varchar2` | Contact Person Street Name | ☐ | The contact person's street name. | | `contactPerson_updatedAt` | `datetime` | Contact Person Updated at | ☐ | The last updated time of the entity. | | `contactPerson_updatedBy` | `varchar2` | Contact Person Updated by | ☐ | The user that last updated the entity. | | `contactPerson_zipCode` | `varchar2` | Contact Person ZIP Code | ☐ | The contact person's zip code. | | `countryCode` | `varchar2`(2) | Country Code | ☐ | An ISO 3166-2 representation of the country. | | `createdAt` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `deliveryDate` | `datetime` | Delivery Date | ☐ | Delivery date for the project. | | `division_description` | `varchar2` | Division Description | ☐ | The description of the division. | | `division_exactDivisionId` | `varchar2` | Division Exact Division ID | ☐ | The division ID of an Exact Online environment. | | `division_glAccountCode` | `varchar2` | Division General Ledger Account Code | ☐ | A default general ledger account code to use for sales related items. | | `division_glAccountCodePurchase` | `varchar2` | Division General Ledger Account Code Purchase | ☐ | A default general ledger account code to use for purchase related items. | | `division_id` | `int64` | Division ID | ☐ | The ID of the division. | | `division_journalCode` | `varchar2` | Division Journal Code | ☐ | A default journal code to use for sales related items. | | `division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | ☐ | A default journal code to use for purchase related items. | | `division_salesInvoiceNumberPrefix` | `varchar2`(3) | Division Sales Invoice Number Prefix | ☐ | The prefix (3 digits) used to generate invoice number range per division. | | `endDate` | `datetime` | End Date | ☐ | End date for the project in ATOM format. | | `executor_firstName` | `varchar2` | Executor First Name | ☐ | First name of the employee. | | `executor_id` | `int64` | Executor ID | ☐ | ID of the employee. | | `executor_lastName` | `varchar2` | Executor Last Name | ☐ | Last name of the employee. | | `extraWork` | `varchar2` | Extra Work | ☐ | Extra work for the project. | | `firstName` | `varchar2` | First Name | ☐ | First name of the employee. | | `fixedPrice` | `varchar2` | Fixed Price | ☐ | Fixed price for the project. | | `fullProjectNumber` | `varchar2` | Full Project Number | ☐ | The full project number including year. | | `generalCostsAmount` | `varchar2` | General Costs Amount | ☐ | General costs amount for the project. | | `hasAfasAssociation` | `char` | | ☐ | Whether the project has an association with AFAS. | | `hasMareonAssociation` | `char` | Has Mare on Association | ☐ | Whether or not the project has an association with Mareon. | | `hasSecurityObjects` | `char` | | ☐ | Whether the project is security coded with security objects. | | `hasSubprojects` | `char` | | ☐ | Whether the project has subprojects. | | `hoursEstimate` | `varchar2` | Hours Estimate | ☐ | Estimated hours for the project. | | `houseNumber` | `varchar2` | House Number | ☐ | The house number for the project. | | `id_2` | `int64` | ID | ☐ | The ID of the project. | | `id` | `int64` | ID | ☐ | ID of the employee. | | `information` | `varchar2` | Information | ☐ | Information about the project. | | `isBooked` | `char` | Is Booked | ☐ | Whether or not the project has been booked to a bookkeeping system. | | `isSecurityCoded` | `char` | Is Security Coded | ☐ | Whether or not the project is security coded. | | `lastName` | `varchar2` | Last Name | ☐ | Last name of the employee. | | `loggedHours` | `varchar2` | Logged Hours | ☐ | The amount of hours logged for the project. | | `maintenanceStatusCode` | `varchar2` | Maintenance Status Code | ☐ | The maintenance status code for the project. | | `name` | `varchar2` | Name | ☐ | The name of the project. | | `note` | `varchar2` | Note | ☐ | Notes for the project. | | `parentId` | `int64` | Parent ID | ☐ | The ID of the parent project if this project is a subproject. | | `planItemCount` | `int64` | Plan Item Count | ☐ | The count of plan items associated with this project. | | `planning` | `varchar2` | Planning | ☐ | The planning for the project. | | `profitAndRisk` | `varchar2` | Profit and Risk | ☐ | Profit and risk amount for the project. | | `projectLeader_firstName` | `varchar2` | Project Leader First Name | ☐ | First name of the employee. | | `projectLeader_id` | `int64` | Project Leader ID | ☐ | ID of the employee. | | `projectLeader_lastName` | `varchar2` | Project Leader Last Name | ☐ | Last name of the employee. | | `projectNumber` | `varchar2` | Project Number | ☐ | The project number. | | `propertyAsset_city` | `varchar2` | Property Asset City | ☐ | City of the PropertyAsset. | | `propertyAsset_country` | `varchar2` | Property Asset Country | ☐ | ISO 3166-1[alpha2] country code of the PropertyAsset. | | `propertyAsset_description` | `varchar2` | Property Asset Description | ☐ | Description for the PropertyAsset. | | `propertyAsset_firstDeliveryDate` | `datetime` | Property Asset First Delivery Date | ☐ | First delivery date of the PropertyAsset. | | `propertyAsset_houseNumber` | `varchar2` | Property Asset House Number | ☐ | House number (incl. addition) of the PropertyAsset. | | `propertyAsset_id` | `int64` | Property Asset ID | ☐ | ID of the PropertyAsset. | | `propertyAsset_invoiceContact_email` | `varchar2` | Property Asset Invoice Contact Email | ☐ | The email address. | | `propertyAsset_invoiceContact_id` | `int64` | Property Asset Invoice Contact ID | ☐ | ID of contact. | | `propertyAsset_invoiceContact_isVatShifted` | `char` | | ☐ | Whether VAT is shifted for the contact. | | `propertyAsset_invoiceContact_name` | `varchar2` | Property Asset Invoice Contact Name | ☐ | Name of contact. | | `propertyAsset_invoiceContact_phoneNumber` | `varchar2` | | ☐ | The phone number of the contact. | | `propertyAsset_name` | `varchar2` | Property Asset Name | ☐ | Name of the PropertyAsset. | | `propertyAsset_number` | `varchar2` | Property Asset Number | ☐ | Number for the PropertyAsset. | | `propertyAsset_postcode` | `varchar2` | Property Asset Post Code | ☐ | Postcode of the PropertyAsset. | | `propertyAsset_projectNameAndNumber` | `varchar2` | Property Asset Project Name and Number | ☐ | The name and number of the Project the PropertyAsset belongs to. | | `propertyAsset_residentContact_email` | `varchar2` | Property Asset Resident Contact Email | ☐ | The email address. | | `propertyAsset_residentContact_id` | `int64` | Property Asset Resident Contact ID | ☐ | ID of contact. | | `propertyAsset_residentContact_isVatShifted` | `char` | | ☐ | Whether VAT is shifted for the contact. | | `propertyAsset_residentContact_name` | `varchar2` | Property Asset Resident Contact Name | ☐ | Name of contact. | | `propertyAsset_residentContact_phoneNumber` | `varchar2` | | ☐ | The phone number of the contact. | | `propertyAsset_secondDeliveryDate` | `datetime` | Property Asset Second Delivery Date | ☐ | Second delivery date of the PropertyAsset. | | `propertyAsset_streetName` | `varchar2` | Property Asset Street Name | ☐ | Street name of the PropertyAsset. | | `provisionalCosts` | `varchar2` | | ☐ | Provisional cost for the project. | | `reference` | `varchar2` | Reference | ☐ | A reference for this project. | | `startDate` | `datetime` | Start Date | ☐ | Start date for the project in ATOM format. | | `status_closesProject` | `char` | Status Closes Project | ☐ | Whether or not this status closes a project. | | `status_createdAt` | `datetime` | Status Created at | ☐ | The creation time of the entity. | | `status_createdBy` | `varchar2` | Status Created by | ☐ | The user that created the entity. | | `status_id` | `int64` | Status ID | ☐ | The ID of the status. | | `status_invoicesProject` | `char` | Status Invoices Project | ☐ | Whether or not this status invoices a project. | | `status_name` | `varchar2` | Status Name | ☐ | The name of the status. | | `status_plansProject` | `char` | Status Plans Project | ☐ | Whether or not this status plans a project. | | `status_updatedAt` | `datetime` | Status Updated at | ☐ | The last updated time of the entity. | | `status_updatedBy` | `varchar2` | Status Updated by | ☐ | The user that last updated the entity. | | `streetName` | `varchar2` | Street Name | ☐ | The street name for the project. | | `type` | `int64` | Type | ☐ | The type of project. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. | | `workAddress` | `varchar2` | Work Address | ☐ | The work address for this project. | | `workPlanner_firstName` | `varchar2` | Work Planner First Name | ☐ | First name of the employee. | | `workPlanner_id` | `int64` | Work Planner ID | ☐ | ID of the employee. | | `workPlanner_lastName` | `varchar2` | Work Planner Last Name | ☐ | Last name of the employee. | | `zipCode` | `varchar2` | ZIP Code | ☐ | The zip code for the project. |