ProjectEmployeesByProjectId: Bouw7 Project Employees by Project ID
read only REST
- Catalogue :
Bouw7 - Schéma :
Project - Label: Project Employees by Project ID
Returns a project associated with the given id. Returns a project associated with the given id.
Permet uniquement de récupérer des données.
Résumé
Returns a project associated with the given id.
Source de l'API
- Point de terminaison :
/project/{project} - Opération :
get /project/{project}
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 90 |
| Nombre de lignes par minute en mode de balayage complet | 241,000 |
| Nombre de lignes de requêtes ponctuelles par minute | 666 |
Le résultat peut être mis en cache côté client.
Paramètres
| Name | Type de données | Required | Default | Documentation |
|---|---|---|---|---|
project |
`` | Identifiant du projet |
Colonnes de table
Les colonnes de la table ProjectEmployeesByProjectId sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation | |||
|---|---|---|---|---|---|---|---|---|
additional |
varchar2 |
Travaux supplémentaires | filters on the platform, writable, ::ancestor. |
Additional work amount for the project. | ||||
avatar |
varchar2 |
Hachage du fichier d'avatar | writable, avatar |
File hash of the avatar which belongs to the employee. | ||||
branch_ |
varchar2 |
Code d'agence | 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 |
Identifiant de la succursale | filters on the platform, writable, ::ancestor. |
The ID of the branch. | ||||
branch_ |
varchar2 |
Nom de la branche | filters on the platform, writable, ::ancestor. |
The name of this branch | ||||
category_ |
varchar2 |
Code de catégorie | filters on the platform, writable, ::ancestor. |
The code for the category. | ||||
category_ |
datetime |
Catégorie créée le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | ||||
category_ |
varchar2 |
Catégorie créée par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | ||||
category_ |
varchar2 |
Catégorie Frais généraux Pourcentage | filters on the platform, writable, ::ancestor. |
The general costs percentage for the category. | ||||
category_ |
varchar2 |
Catégorie : Marge brute | filters on the platform, writable, ::ancestor. |
The gross profit margin for the category. | ||||
category_ |
int64 |
ID de catégorie | filters on the platform, writable, ::ancestor. |
The ID of the category. | ||||
category_ |
varchar2 |
Nom de la catégorie | filters on the platform, writable, ::ancestor. |
The name of the category. | ||||
category_ |
datetime |
Catégorie Mise à jour le | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | ||||
category_ |
varchar2 |
Catégorie mise à jour par | 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 |
Personne à contacter Ville | filters on the platform, writable, ::ancestor. |
The contact person's city. | ||||
contact |
datetime |
Personne à contacter Créé le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | ||||
contact |
varchar2 |
Interlocuteur Créé par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | ||||
contact |
varchar2 |
E-mail de la personne à contacter | filters on the platform, writable, ::ancestor. |
The contact person's email address. | ||||
contact |
varchar2 |
Prénom de la personne à contacter | filters on the platform, writable, ::ancestor. |
The contact person's first name. | ||||
contact |
varchar2 |
Personne à contacter Numéro de la maison | filters on the platform, writable, ::ancestor. |
The contact person's house number. | ||||
contact |
int64 |
Identifiant de la personne à contacter | filters on the platform, writable, ::ancestor. |
The ID of contact person. | ||||
contact |
varchar2 |
Nom de famille de la personne à contacter | filters on the platform, writable, ::ancestor. |
The contact person's last name. | ||||
contact |
varchar2 |
Numéro de téléphone de la personne à contacter | filters on the platform, writable, ::ancestor. |
The contact person's phone number. | ||||
contact |
varchar2 |
Nom de la rue de la personne à contacter | filters on the platform, writable, ::ancestor. |
The contact person's street name. | ||||
contact |
datetime |
Personne à contacter Mise à jour le | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | ||||
contact |
varchar2 |
Personne à contacter Mise à jour par | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | ||||
contact |
varchar2 |
Nom de la personne à contacter Code postal | filters on the platform, writable, ::ancestor. |
The contact person's zip code. | ||||
contact_ |
int64 |
Contact - Type de contact - ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | ||||
contact_ |
varchar2 |
Contact Type de contact Nom | filters on the platform, writable, ::ancestor. |
The name of contact type. | ||||
contact_ |
varchar2 |
Email du contact | filters on the platform, writable, ::ancestor. |
The email address. | ||||
contact_ |
int64 |
ID de contact | filters on the platform, writable, ::ancestor. |
ID of contact. | ||||
contact_ |
char |
Contact : la TVA est-elle répercutée ? | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | ||||
contact_ |
varchar2 |
Nom du Contact | filters on the platform, writable, ::ancestor. |
Name of contact. | ||||
contact_ |
varchar2 |
Numéro de téléphone | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | ||||
country |
varchar2 |
code du pays | filters on the platform, writable, ::ancestor. |
An ISO 3166-2 representation of the country. | ||||
created |
datetime |
Créé le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | ||||
created |
varchar2 |
Crée par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | ||||
delivery |
datetime |
Date de livraison | filters on the platform, writable, ::ancestor. |
Delivery date for the project. | ||||
division_ |
varchar2 |
Description de la division | filters on the platform, writable, ::ancestor. |
The description of the division. | ||||
division_ |
varchar2 |
Division : ID exact de la division | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | ||||
division_ |
varchar2 |
Code de compte du grand livre général de la division | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | ||||
division_ |
varchar2 |
Division - Code de compte du grand livre général - Achats | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | ||||
division_ |
int64 |
ID de l'entreprise | filters on the platform, writable, ::ancestor. |
The ID of the division. | ||||
division_ |
varchar2 |
Code du journal de division | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | ||||
division_ |
varchar2 |
Code du journal de la division : Achat | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | ||||
division_ |
varchar2 |
Préfixe du numéro de facture de la division des ventes | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | ||||
end |
datetime |
Date de fin | filters on the platform, writable, ::ancestor. |
End date for the project in ATOM format. | ||||
executor_ |
varchar2 |
Prénom de l'exécuteur testamentaire | filters on the platform, writable, ::ancestor. |
First name of the employee. | ||||
executor_ |
int64 |
Identifiant de l'exécuteur testamentaire | filters on the platform, writable, ::ancestor. |
ID of the employee. | ||||
executor_ |
varchar2 |
Nom de famille de l'exécuteur testamentaire | filters on the platform, writable, ::ancestor. |
Last name of the employee. | ||||
extra |
varchar2 |
Heures supplémentaires | filters on the platform, writable, ::ancestor. |
Extra work for the project. | ||||
first |
varchar2 |
Prénom | writable, first |
First name of the employee. | ||||
fixed |
varchar2 |
Prix fixe | filters on the platform, writable, ::ancestor. |
Fixed price for the project. | ||||
full |
varchar2 |
Numéro complet du projet | filters on the platform, writable, ::ancestor. |
The full project number including year. | ||||
general |
varchar2 |
Montant des frais généraux | 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 » sur « 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 |
Estimation du nombre d'heures | filters on the platform, writable, ::ancestor. |
Estimated hours for the project. | ||||
house |
varchar2 |
Numéro de maison | 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 |
Est réservé | filters on the platform, writable, ::ancestor. |
Whether or not the project has been booked to a bookkeeping system. | ||||
is |
char |
La sécurité est-elle codée ? | filters on the platform, writable, ::ancestor. |
Whether or not the project is security coded. | ||||
last |
varchar2 |
Nom | writable, last |
Last name of the employee. | ||||
logged |
varchar2 |
Heures enregistrées | filters on the platform, writable, ::ancestor. |
The amount of hours logged for the project. | ||||
maintenance |
varchar2 |
Code d'état de maintenance | 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 |
Identifiant du parent | filters on the platform, writable, ::ancestor. |
The ID of the parent project if this project is a subproject. | ||||
plan |
int64 |
Nombre d'éléments du plan | 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 |
Bénéfice et risque | filters on the platform, writable, ::ancestor. |
Profit and risk amount for the project. | ||||
project |
varchar2 |
Prénom du chef de projet | filters on the platform, writable, ::ancestor. |
First name of the employee. | ||||
project |
int64 |
Identifiant du chef de projet | filters on the platform, writable, ::ancestor. |
ID of the employee. | ||||
project |
varchar2 |
Nom de famille du chef de projet | filters on the platform, writable, ::ancestor. |
Last name of the employee. | ||||
project |
varchar2 |
Numéro de Projet | filters on the platform, writable, ::ancestor. |
The project number. | ||||
property |
varchar2 |
Immobilier, Actifs, Ville | filters on the platform, writable, ::ancestor. |
City of the PropertyAsset. | ||||
property |
varchar2 |
Bien immobilier Pays | filters on the platform, writable, ::ancestor. |
ISO 3166-1[alpha2] country code of the PropertyAsset. | ||||
property |
varchar2 |
Description du bien immobilier | filters on the platform, writable, ::ancestor. |
Description for the PropertyAsset. | ||||
property |
datetime |
Date de première livraison du bien immobilier | filters on the platform, writable, ::ancestor. |
First delivery date of the PropertyAsset. | ||||
property |
varchar2 |
Numéro de la maison du bien immobilier | filters on the platform, writable, ::ancestor. |
House number (incl. addition) of the PropertyAsset. | ||||
property |
int64 |
Référence du bien immobilier | filters on the platform, writable, ::ancestor. |
ID of the PropertyAsset. | ||||
property |
varchar2 |
Bien immobilier, actif, facture, e-mail de contact | filters on the platform, writable, ::ancestor. |
The email address. | ||||
property |
int64 |
Bien immobilier, actif, facture, ID de contact | 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 |
Bien immobilier, actif, facture, nom du contact | 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 |
Nom du bien immobilier | filters on the platform, writable, ::ancestor. |
Name of the PropertyAsset. | ||||
property |
varchar2 |
Numéro d'actif immobilier | filters on the platform, writable, ::ancestor. |
Number for the PropertyAsset. | ||||
property |
varchar2 |
Code postal du bien immobilier | filters on the platform, writable, ::ancestor. |
Postcode of the PropertyAsset. | ||||
property |
varchar2 |
Nom et numéro du projet immobilier | filters on the platform, writable, ::ancestor. |
The name and number of the Project the PropertyAsset belongs to. | ||||
property |
varchar2 |
Bien immobilier | Actif | Résident | E-mail de contact | filters on the platform, writable, ::ancestor. |
The email address. | |
property |
int64 |
Bien immobilier - Actif - Résident - Identifiant de contact | 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 |
Bien immobilier / Actif / Nom du contact résident | 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 |
Date de la deuxième livraison de l'actif immobilier | filters on the platform, writable, ::ancestor. |
Second delivery date of the PropertyAsset. | ||||
property |
varchar2 |
Nom de la rue où se trouve le bien immobilier | 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 |
Date de début | filters on the platform, writable, ::ancestor. |
Start date for the project in ATOM format. | ||||
status_ |
char |
Statut : projet clôturé | filters on the platform, writable, ::ancestor. |
Whether or not this status closes a project. | ||||
status_ |
datetime |
Statut Créé le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | ||||
status_ |
varchar2 |
Statut Créé par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | ||||
status_ |
int64 |
Identifiant d'état | filters on the platform, writable, ::ancestor. |
The ID of the status. | ||||
status_ |
char |
État d'avancement du projet « Factures » | filters on the platform, writable, ::ancestor. |
Whether or not this status invoices a project. | ||||
status_ |
varchar2 |
Nom du statut | filters on the platform, writable, ::ancestor. |
The name of the status. | ||||
status_ |
char |
Projet « Status Plans » | filters on the platform, writable, ::ancestor. |
Whether or not this status plans a project. | ||||
status_ |
datetime |
Statut mis à jour le | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | ||||
status_ |
varchar2 |
Statut mis à jour par | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | ||||
street |
varchar2 |
Nom de la rue | 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 |
Mise à jour à | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | ||||
updated |
varchar2 |
Mise à jour par | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | ||||
work |
varchar2 |
Adresse professionnelle | filters on the platform, writable, ::ancestor. |
The work address for this project. | ||||
work |
varchar2 |
Prénom du planificateur de travail | filters on the platform, writable, ::ancestor. |
First name of the employee. | ||||
work |
int64 |
Identifiant du planificateur de tâches | filters on the platform, writable, ::ancestor. |
ID of the employee. | ||||
work |
varchar2 |
Nom de famille du responsable de la planification des travaux | filters on the platform, writable, ::ancestor. |
Last name of the employee. | ||||
zip |
varchar2 |
Code postal | filters on the platform, writable, ::ancestor. |
The zip code for the project. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :