ProjectEmployeesByProjectId: Bouw7 Project Employees by Project ID
read only REST
- Catalog:
Bouw7 - Schema:
Project - Label: Project Employees by Project ID
Returns a project associated with the given id. Returns a project associated with the given id.
Can only retrieve data.
Summary
Returns a project associated with the given id.
API Source
- Endpoint:
/project/{project} - Operation:
get /project/{project}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
project |
`` | Project ID |
Table Columns
The columns of the table ProjectEmployeesByProjectId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
additional |
varchar2 |
Additional Work | filters on the platform, writable, ::ancestor. |
Additional work amount for the project. | |
avatar |
varchar2 |
Avatar File Hash | writable, avatar |
File hash of the avatar which belongs to the employee. | |
branch_ |
varchar2 |
Branch Code | filters on the platform, writable, ::ancestor. |
The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Branch ID | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
The name of this branch | |
category_ |
varchar2 |
Category Code | filters on the platform, writable, ::ancestor. |
The code for the category. | |
category_ |
datetime |
Category Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
category_ |
varchar2 |
Category Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
category_ |
varchar2 |
Category General Costs Percentage | filters on the platform, writable, ::ancestor. |
The general costs percentage for the category. | |
category_ |
varchar2 |
Category Gross Profit Margin | filters on the platform, writable, ::ancestor. |
The gross profit margin for the category. | |
category_ |
int64 |
Category ID | filters on the platform, writable, ::ancestor. |
The ID of the category. | |
category_ |
varchar2 |
Category Name | filters on the platform, writable, ::ancestor. |
The name of the category. | |
category_ |
datetime |
Category Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
category_ |
varchar2 |
Category Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
city |
varchar2 |
City | filters on the platform, writable, ::ancestor. |
The city of the project. | |
contact |
varchar2 |
Contact Person City | filters on the platform, writable, ::ancestor. |
The contact person's city. | |
contact |
datetime |
Contact Person Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
contact |
varchar2 |
Contact Person Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
contact |
varchar2 |
Contact Person Email | filters on the platform, writable, ::ancestor. |
The contact person's email address. | |
contact |
varchar2 |
Contact Person First Name | filters on the platform, writable, ::ancestor. |
The contact person's first name. | |
contact |
varchar2 |
Contact Person House Number | filters on the platform, writable, ::ancestor. |
The contact person's house number. | |
contact |
int64 |
Contact Person ID | filters on the platform, writable, ::ancestor. |
The ID of contact person. | |
contact |
varchar2 |
Contact Person Last Name | filters on the platform, writable, ::ancestor. |
The contact person's last name. | |
contact |
varchar2 |
Contact Person Phone Number | filters on the platform, writable, ::ancestor. |
The contact person's phone number. | |
contact |
varchar2 |
Contact Person Street Name | filters on the platform, writable, ::ancestor. |
The contact person's street name. | |
contact |
datetime |
Contact Person Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
contact |
varchar2 |
Contact Person Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
contact |
varchar2 |
Contact Person ZIP Code | filters on the platform, writable, ::ancestor. |
The contact person's zip code. | |
contact_ |
int64 |
Contact Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
country |
varchar2 |
Country Code | filters on the platform, writable, ::ancestor. |
An ISO 3166-2 representation of the country. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
datetime |
Delivery Date | filters on the platform, writable, ::ancestor. |
Delivery date for the project. | |
division_ |
varchar2 |
Division Description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
division_ |
varchar2 |
Division Exact Division ID | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Division General Ledger Account Code | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Division General Ledger Account Code Purchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
Division ID | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
division_ |
varchar2 |
Division Journal Code | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
division_ |
varchar2 |
Division Journal Code Purchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
division_ |
varchar2 |
Division Sales Invoice Number Prefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
end |
datetime |
End Date | filters on the platform, writable, ::ancestor. |
End date for the project in ATOM format. | |
executor_ |
varchar2 |
Executor First Name | filters on the platform, writable, ::ancestor. |
First name of the employee. | |
executor_ |
int64 |
Executor ID | filters on the platform, writable, ::ancestor. |
ID of the employee. | |
executor_ |
varchar2 |
Executor Last Name | filters on the platform, writable, ::ancestor. |
Last name of the employee. | |
extra |
varchar2 |
Extra Work | filters on the platform, writable, ::ancestor. |
Extra work for the project. | |
first |
varchar2 |
First Name | writable, first |
First name of the employee. | |
fixed |
varchar2 |
Fixed Price | filters on the platform, writable, ::ancestor. |
Fixed price for the project. | |
full |
varchar2 |
Full Project Number | filters on the platform, writable, ::ancestor. |
The full project number including year. | |
general |
varchar2 |
General Costs Amount | filters on the platform, writable, ::ancestor. |
General costs amount for the project. | |
has |
char |
itgen_bouw7_hasafasassociation | filters on the platform, writable, ::ancestor. |
Whether the project has an association with AFAS. | |
has |
char |
Has Mare on Association | filters on the platform, writable, ::ancestor. |
Whether or not the project has an association with Mareon. | |
has |
char |
itgen_bouw7_hassecurityobjects | filters on the platform, writable, ::ancestor. |
Whether the project is security coded with security objects. | |
has |
char |
itgen_bouw7_hassubprojects | filters on the platform, writable, ::ancestor. |
Whether the project has subprojects. | |
hours |
varchar2 |
Hours Estimate | filters on the platform, writable, ::ancestor. |
Estimated hours for the project. | |
house |
varchar2 |
House Number | filters on the platform, writable, ::ancestor. |
The house number for the project. | |
id |
int64 |
ID | writable, id |
ID of the employee. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of the project. | |
information |
varchar2 |
Information | filters on the platform, writable, ::ancestor. |
Information about the project. | |
is |
char |
Is Booked | filters on the platform, writable, ::ancestor. |
Whether or not the project has been booked to a bookkeeping system. | |
is |
char |
Is Security Coded | filters on the platform, writable, ::ancestor. |
Whether or not the project is security coded. | |
last |
varchar2 |
Last Name | writable, last |
Last name of the employee. | |
logged |
varchar2 |
Logged Hours | filters on the platform, writable, ::ancestor. |
The amount of hours logged for the project. | |
maintenance |
varchar2 |
Maintenance Status Code | filters on the platform, writable, ::ancestor. |
The maintenance status code for the project. | |
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
The name of the project. | |
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
Notes for the project. | |
parent |
int64 |
Parent ID | filters on the platform, writable, ::ancestor. |
The ID of the parent project if this project is a subproject. | |
plan |
int64 |
Plan Item Count | filters on the platform, writable, ::ancestor. |
The count of plan items associated with this project. | |
planning |
varchar2 |
Planning | filters on the platform, writable, ::ancestor. |
The planning for the project. | |
profit |
varchar2 |
Profit and Risk | filters on the platform, writable, ::ancestor. |
Profit and risk amount for the project. | |
project |
varchar2 |
Project Leader First Name | filters on the platform, writable, ::ancestor. |
First name of the employee. | |
project |
int64 |
Project Leader ID | filters on the platform, writable, ::ancestor. |
ID of the employee. | |
project |
varchar2 |
Project Leader Last Name | filters on the platform, writable, ::ancestor. |
Last name of the employee. | |
project |
varchar2 |
Project Number | filters on the platform, writable, ::ancestor. |
The project number. | |
property |
varchar2 |
Property Asset City | filters on the platform, writable, ::ancestor. |
City of the PropertyAsset. | |
property |
varchar2 |
Property Asset Country | filters on the platform, writable, ::ancestor. |
ISO 3166-1[alpha2] country code of the PropertyAsset. | |
property |
varchar2 |
Property Asset Description | filters on the platform, writable, ::ancestor. |
Description for the PropertyAsset. | |
property |
datetime |
Property Asset First Delivery Date | filters on the platform, writable, ::ancestor. |
First delivery date of the PropertyAsset. | |
property |
varchar2 |
Property Asset House Number | filters on the platform, writable, ::ancestor. |
House number (incl. addition) of the PropertyAsset. | |
property |
int64 |
Property Asset ID | filters on the platform, writable, ::ancestor. |
ID of the PropertyAsset. | |
property |
varchar2 |
Property Asset Invoice Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
property |
int64 |
Property Asset Invoice Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
property |
char |
itgen_bouw7_propertyasset_invoicecontact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
property |
varchar2 |
Property Asset Invoice Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
property |
varchar2 |
itgen_bouw7_propertyasset_invoicecontact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
property |
varchar2 |
Property Asset Name | filters on the platform, writable, ::ancestor. |
Name of the PropertyAsset. | |
property |
varchar2 |
Property Asset Number | filters on the platform, writable, ::ancestor. |
Number for the PropertyAsset. | |
property |
varchar2 |
Property Asset Post Code | filters on the platform, writable, ::ancestor. |
Postcode of the PropertyAsset. | |
property |
varchar2 |
Property Asset Project Name and Number | filters on the platform, writable, ::ancestor. |
The name and number of the Project the PropertyAsset belongs to. | |
property |
varchar2 |
Property Asset Resident Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
property |
int64 |
Property Asset Resident Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
property |
char |
itgen_bouw7_propertyasset_residentcontact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
property |
varchar2 |
Property Asset Resident Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
property |
varchar2 |
itgen_bouw7_propertyasset_residentcontact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
property |
datetime |
Property Asset Second Delivery Date | filters on the platform, writable, ::ancestor. |
Second delivery date of the PropertyAsset. | |
property |
varchar2 |
Property Asset Street Name | filters on the platform, writable, ::ancestor. |
Street name of the PropertyAsset. | |
provisional |
varchar2 |
itgen_bouw7_provisionalcosts | filters on the platform, writable, ::ancestor. |
Provisional cost for the project. | |
reference |
varchar2 |
Reference | filters on the platform, writable, ::ancestor. |
A reference for this project. | |
start |
datetime |
Start Date | filters on the platform, writable, ::ancestor. |
Start date for the project in ATOM format. | |
status_ |
char |
Status Closes Project | filters on the platform, writable, ::ancestor. |
Whether or not this status closes a project. | |
status_ |
datetime |
Status Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
status_ |
varchar2 |
Status Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
status_ |
int64 |
Status ID | filters on the platform, writable, ::ancestor. |
The ID of the status. | |
status_ |
char |
Status Invoices Project | filters on the platform, writable, ::ancestor. |
Whether or not this status invoices a project. | |
status_ |
varchar2 |
Status Name | filters on the platform, writable, ::ancestor. |
The name of the status. | |
status_ |
char |
Status Plans Project | filters on the platform, writable, ::ancestor. |
Whether or not this status plans a project. | |
status_ |
datetime |
Status Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
status_ |
varchar2 |
Status Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
street |
varchar2 |
Street Name | filters on the platform, writable, ::ancestor. |
The street name for the project. | |
type |
int64 |
Type | filters on the platform, writable, ::ancestor. |
The type of project. | |
updated |
datetime |
Updated At | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
work |
varchar2 |
Work Address | filters on the platform, writable, ::ancestor. |
The work address for this project. | |
work |
varchar2 |
Work Planner First Name | filters on the platform, writable, ::ancestor. |
First name of the employee. | |
work |
int64 |
Work Planner ID | filters on the platform, writable, ::ancestor. |
ID of the employee. | |
work |
varchar2 |
Work Planner Last Name | filters on the platform, writable, ::ancestor. |
Last name of the employee. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, ::ancestor. |
The zip code for the project. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: