ProjectFileDepartmentsByProjectId: Bouw7 Project File Departments by Project ID
read only REST
- Catalogue :
Bouw7 - Schéma :
Project - Label: Project File Departments by Project ID
Returns a project file associated with the given id. Returns a project file associated with the given id.
Permet uniquement de récupérer des données.
Résumé
Returns a project file associated with the given id.
Source de l'API
- Point de terminaison :
/project/file/{projectFile} - Opération :
get /project/file/{projectFile}
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 ProjectFileDepartmentsByProjectId 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 |
|---|---|---|---|---|---|
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. | |
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. | |
file_ |
datetime |
Fichier créé le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
file_ |
varchar2 |
Fichier créé par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
file_ |
varchar2 |
Extension de fichier | filters on the platform, writable, ::ancestor. |
The extension of the file. | |
file_ |
int64 |
ID de fichier | filters on the platform, writable, ::ancestor. |
The ID of this file | |
file_ |
int64 |
ID du modèle de fichier | filters on the platform, writable, ::ancestor. |
The ID of the associated type. | |
file_ |
varchar2 |
Type de modèle de fichier | filters on the platform, writable, ::ancestor. |
The category of the file. | |
file_ |
varchar2 |
Nom de fichier | filters on the platform, writable, ::ancestor. |
The public name of the file. | |
file_ |
varchar2 |
itgen_bouw7_file_securehash | filters on the platform, writable, ::ancestor. |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
file_ |
int64 |
Taille du fichier | filters on the platform, writable, ::ancestor. |
The size of the file in bytes. | |
file_ |
datetime |
Fichier mis à jour le | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
file_ |
varchar2 |
Fichier mis à jour par | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
file_ |
varchar2 |
URI du fichier | filters on the platform, writable, ::ancestor. |
The URI of the file, used to fetch the contents. | |
id |
int64 |
ID | writable, id |
ID of the department. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of this project file metadata. | |
information |
varchar2 |
Information | filters on the platform, writable, ::ancestor. |
The information of this project file metadata. | |
name |
varchar2 |
Name | writable, name |
Name of the department. | |
name_2 |
varchar2 |
itgen_bouw7_name_2 | filters on the platform, writable, ::ancestor. |
The name of this project file metadata. | |
project |
int64 |
Identifiant de catégorie du fichier de projet | filters on the platform, writable, ::ancestor. |
The ID of the file category. | |
project |
varchar2 |
Nom de la catégorie du fichier de projet | filters on the platform, writable, ::ancestor. |
The name of the file category. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable, ::ancestor. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, ::ancestor. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, ::ancestor. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, ::ancestor. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, ::ancestor. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, ::ancestor. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, ::ancestor. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, ::ancestor. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Ville du projet | filters on the platform, writable, ::ancestor. |
The city of the project. | |
project_ |
varchar2 |
Adresse e-mail de contact pour le projet | filters on the platform, writable, ::ancestor. |
The email address. | |
project_ |
int64 |
Référence du projet | filters on the platform, writable, ::ancestor. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Nom du responsable du projet | filters on the platform, writable, ::ancestor. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
project_ |
datetime |
Projet créé le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
Projet créé par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
datetime |
Date de livraison du projet | filters on the platform, writable, ::ancestor. |
Delivery date for the project. | |
project_ |
datetime |
Date de fin du projet | filters on the platform, writable, ::ancestor. |
End date for the project. | |
project_ |
varchar2 |
Numéro complet du projet | filters on the platform, writable, ::ancestor. |
The full project number including year. | |
project_ |
varchar2 |
Numéro du projet | filters on the platform, writable, ::ancestor. |
The house number for the project. | |
project_ |
int64 |
Identifiant du projet | filters on the platform, writable, ::ancestor. |
The ID of the project. | |
project_ |
varchar2 |
Informations du projet | filters on the platform, writable, ::ancestor. |
The information of the project. | |
project_ |
varchar2 |
Nom de projet | filters on the platform, writable, ::ancestor. |
The name of the project. | |
project_ |
varchar2 |
Projet Numéro de projet | filters on the platform, writable, ::ancestor. |
The project number. | |
project_ |
varchar2 |
Référence du projet | filters on the platform, writable, ::ancestor. |
The reference of the project. | |
project_ |
datetime |
Date de début du projet | filters on the platform, writable, ::ancestor. |
Start date for the project. | |
project_ |
char |
Statut du projet : Clôture du projet | filters on the platform, writable, ::ancestor. |
Whether or not this status closes a project. | |
project_ |
datetime |
Statut du projet Créé le | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
Statut du projet Créé par | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
int64 |
Identifiant de l'état du projet | filters on the platform, writable, ::ancestor. |
The ID of the status. | |
project_ |
char |
État d'avancement du projet Factures Projet | filters on the platform, writable, ::ancestor. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Nom de l'état d'avancement du projet | filters on the platform, writable, ::ancestor. |
The name of the status. | |
project_ |
char |
État d'avancement du projet Plans Projet | filters on the platform, writable, ::ancestor. |
Whether or not this status plans a project. | |
project_ |
datetime |
État d'avancement du projet mis à jour le | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
État du projet mis à jour par | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Nom du projet « Street » | filters on the platform, writable, ::ancestor. |
The street name for the project. | |
project_ |
datetime |
Mise à jour du projet le | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
Projet mis à jour par | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Code postal du projet | filters on the platform, writable, ::ancestor. |
The zip code for the 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. |
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 :