invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

ProjectFile_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_projectfile_projectcategorydivisionsettings_plural

read only REST

  • Catalogue : Bouw7
  • Schéma : Project
  • Étiquette : itgen_bouw7_projectfile_projectcategorydivisionsettings_plural

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
projectFile `` Identifiant du projet

Colonnes de table

Les colonnes de la table ProjectFile_ProjectCategoryDivisionSettings 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
branch_code varchar2 Code d'agence writable, ::ancestor.::ancestor.branch.code The code for this branch
branch_id int64 Identifiant de la succursale writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_name varchar2 Nom de la branche writable, ::ancestor.::ancestor.branch.name The name of this branch
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
code varchar2 Code writable, ::ancestor.code The code for the category.
contact_contactType_id int64 Contact - Type de contact - ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Type de contact Nom filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.name The name of contact type.
contact_email varchar2 Email du contact writable, ::ancestor.::ancestor.contact.email The email address.
contact_email_2 varchar2 itgen_bouw7_contact_email_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.email The email address.
contact_id int64 ID de contact writable, ::ancestor.::ancestor.contact.id ID of contact.
contact_id_2 int64 itgen_bouw7_contact_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact : la TVA est-elle répercutée ? writable, ::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_isVatShifted_2 char itgen_bouw7_contact_isvatshifted_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Nom du Contact writable, ::ancestor.::ancestor.contact.name Name of contact.
contact_name_2 varchar2 itgen_bouw7_contact_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Numéro de téléphone writable, ::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
contact_phoneNumber_2 varchar2 itgen_bouw7_contact_phonenumber_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
createdAt datetime Créé le writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Créé le writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_3 datetime itgen_bouw7_createdat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Crée par writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Crée par writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_3 varchar2 itgen_bouw7_createdby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryDate datetime Date de livraison writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
endDate datetime Date de fin writable, ::ancestor.::ancestor.endDate End date for the project.
file_createdAt datetime Fichier créé le filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.createdAt The creation time of the entity.
file_createdBy varchar2 Fichier créé par filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.createdBy The user that created the entity.
file_extension varchar2 Extension de fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.extension The extension of the file.
file_id int64 ID de fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.id The ID of this file
file_modelId int64 ID du modèle de fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.modelId The ID of the associated type.
file_modelType varchar2 Type de modèle de fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.modelType The category of the file.
file_name varchar2 Nom de fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.name The public name of the file.
file_secureHash varchar2 itgen_bouw7_file_securehash filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
file_size int64 Taille du fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.size The size of the file in bytes.
file_updatedAt datetime Fichier mis à jour le filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.updatedAt The last updated time of the entity.
file_updatedBy varchar2 Fichier mis à jour par filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.updatedBy The user that last updated the entity.
file_uri varchar2 URI du fichier filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.uri The URI of the file, used to fetch the contents.
fullProjectNumber varchar2 Numéro complet du projet writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
generalCostsOrProfit varchar2 Frais généraux ou bénéfice writable, ::ancestor.generalCostsOrProfit The general costs or profit for the category.
generalCostsPercentage varchar2 Pourcentage des frais généraux writable, ::ancestor.generalCostsPercentage The general costs percentage for the category.
grossProfitMargin varchar2 Marge brute writable, ::ancestor.grossProfitMargin The gross profit margin for the category.
houseNumber varchar2 Numéro de maison writable, ::ancestor.::ancestor.houseNumber The house number for the project.
id int64 ID writable, ::ancestor.id The ID of the category.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of this project file metadata.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
information_2 varchar2 itgen_bouw7_information_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.information The information of this project file metadata.
name varchar2 Name writable, ::ancestor.name The name of the category.
name_2 varchar2 itgen_bouw7_name_2 writable, ::ancestor.::ancestor.name The name of the project.
name_3 varchar2(255) itgen_bouw7_name_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.name The name of this project file metadata.
projectFileCategory_id int64 Identifiant de catégorie du fichier de projet filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectFileCategory.id The ID of the file category.
projectFileCategory_name varchar2 Nom de la catégorie du fichier de projet filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectFileCategory.name The name of the file category.
projectNumber varchar2 Numéro de Projet writable, ::ancestor.::ancestor.projectNumber The project number.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
startDate datetime Date de début writable, ::ancestor.::ancestor.startDate Start date for the project.
status_closesProject char Statut : projet clôturé writable, ::ancestor.::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Statut Créé le writable, ::ancestor.::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Statut Créé par writable, ::ancestor.::ancestor.status.createdBy The user that created the entity.
status_id int64 Identifiant d'état writable, ::ancestor.::ancestor.status.id The ID of the status.
status_invoicesProject char État d'avancement du projet « Factures » writable, ::ancestor.::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Nom du statut writable, ::ancestor.::ancestor.status.name The name of the status.
status_plansProject char Projet « Status Plans » writable, ::ancestor.::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Statut mis à jour le writable, ::ancestor.::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Statut mis à jour par writable, ::ancestor.::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Nom de la rue writable, ::ancestor.::ancestor.streetName The street name for the project.
updatedAt datetime Mise à jour à writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Mise à jour à writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_3 datetime itgen_bouw7_updatedat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Mise à jour par writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Mise à jour par writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_3 varchar2 itgen_bouw7_updatedby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
zipCode varchar2 Code postal writable, ::ancestor.::ancestor.zipCode 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 :