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

ProjectHourEstimatesPerHourTypeByProjectId: Bouw7 Project Hour Estimates per Hour Type by Project ID

read only REST

  • Catalogue : Bouw7
  • Schéma : Project
  • Label: Project Hour Estimates per Hour Type 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 ProjectHourEstimatesPerHourTypeByProjectId 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
additionalWork varchar2 Travaux supplémentaires filters on the platform, writable, ::ancestor.additionalWork Additional work amount for the project.
branch_code varchar2 Code d'agence filters on the platform, writable, ::ancestor.branch.code The code for this branch
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable, ::ancestor.branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, ::ancestor.branch.division.exactDivisionId The division ID of an Exact Online environment.
branch_division_glAccountCode varchar2 itgen_bouw7_branch_division_glaccountcode filters on the platform, writable, ::ancestor.branch.division.glAccountCode A default general ledger account code to use for sales related items.
branch_division_glAccountCodePurchase varchar2 itgen_bouw7_branch_division_glaccountcodepurchase filters on the platform, writable, ::ancestor.branch.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
branch_division_id int64 itgen_bouw7_branch_division_id filters on the platform, writable, ::ancestor.branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, ::ancestor.branch.division.journalCode A default journal code to use for sales related items.
branch_division_journalCodePurchase varchar2 itgen_bouw7_branch_division_journalcodepurchase filters on the platform, writable, ::ancestor.branch.division.journalCodePurchase A default journal code to use for purchase related items.
branch_division_salesInvoiceNumberPrefix varchar2(3) itgen_bouw7_branch_division_salesinvoicenumberprefix filters on the platform, writable, ::ancestor.branch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
branch_id int64 Identifiant de la succursale filters on the platform, writable, ::ancestor.branch.id The ID of the branch.
branch_name varchar2 Nom de la branche filters on the platform, writable, ::ancestor.branch.name The name of this branch
category_code varchar2 Code de catégorie filters on the platform, writable, ::ancestor.category.code The code for the category.
category_createdAt datetime Catégorie créée le filters on the platform, writable, ::ancestor.category.createdAt The creation time of the entity.
category_createdBy varchar2 Catégorie créée par filters on the platform, writable, ::ancestor.category.createdBy The user that created the entity.
category_generalCostsPercentage varchar2 Catégorie Frais généraux Pourcentage filters on the platform, writable, ::ancestor.category.generalCostsPercentage The general costs percentage for the category.
category_grossProfitMargin varchar2 Catégorie : Marge brute filters on the platform, writable, ::ancestor.category.grossProfitMargin The gross profit margin for the category.
category_id int64 ID de catégorie filters on the platform, writable, ::ancestor.category.id The ID of the category.
category_name varchar2 Nom de la catégorie filters on the platform, writable, ::ancestor.category.name The name of the category.
category_updatedAt datetime Catégorie Mise à jour le filters on the platform, writable, ::ancestor.category.updatedAt The last updated time of the entity.
category_updatedBy varchar2 Catégorie mise à jour par filters on the platform, writable, ::ancestor.category.updatedBy The user that last updated the entity.
city varchar2 City filters on the platform, writable, ::ancestor.city The city of the project.
contactPerson_city varchar2 Personne à contacter Ville filters on the platform, writable, ::ancestor.contactPerson.city The contact person's city.
contactPerson_createdAt datetime Personne à contacter Créé le filters on the platform, writable, ::ancestor.contactPerson.createdAt The creation time of the entity.
contactPerson_createdBy varchar2 Interlocuteur Créé par filters on the platform, writable, ::ancestor.contactPerson.createdBy The user that created the entity.
contactPerson_email varchar2 E-mail de la personne à contacter filters on the platform, writable, ::ancestor.contactPerson.email The contact person's email address.
contactPerson_firstName varchar2 Prénom de la personne à contacter filters on the platform, writable, ::ancestor.contactPerson.firstName The contact person's first name.
contactPerson_houseNumber varchar2(50) Personne à contacter Numéro de la maison filters on the platform, writable, ::ancestor.contactPerson.houseNumber The contact person's house number.
contactPerson_id int64 Identifiant de la personne à contacter filters on the platform, writable, ::ancestor.contactPerson.id The ID of contact person.
contactPerson_lastName varchar2 Nom de famille de la personne à contacter filters on the platform, writable, ::ancestor.contactPerson.lastName The contact person's last name.
contactPerson_phoneNumber varchar2 Numéro de téléphone de la personne à contacter filters on the platform, writable, ::ancestor.contactPerson.phoneNumber The contact person's phone number.
contactPerson_streetName varchar2 Nom de la rue de la personne à contacter filters on the platform, writable, ::ancestor.contactPerson.streetName The contact person's street name.
contactPerson_updatedAt datetime Personne à contacter Mise à jour le filters on the platform, writable, ::ancestor.contactPerson.updatedAt The last updated time of the entity.
contactPerson_updatedBy varchar2 Personne à contacter Mise à jour par filters on the platform, writable, ::ancestor.contactPerson.updatedBy The user that last updated the entity.
contactPerson_zipCode varchar2 Nom de la personne à contacter Code postal filters on the platform, writable, ::ancestor.contactPerson.zipCode The contact person's zip code.
contact_contactType_id int64 Contact - Type de contact - ID filters on the platform, writable, ::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Type de contact Nom filters on the platform, writable, ::ancestor.contact.contactType.name The name of contact type.
contact_email varchar2 Email du contact filters on the platform, writable, ::ancestor.contact.email The email address.
contact_id int64 ID de contact filters on the platform, writable, ::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact : la TVA est-elle répercutée ? filters on the platform, writable, ::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Nom du Contact filters on the platform, writable, ::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Numéro de téléphone filters on the platform, writable, ::ancestor.contact.phoneNumber The phone number of the contact.
countryCode varchar2(2) code du pays filters on the platform, writable, ::ancestor.countryCode An ISO 3166-2 representation of the country.
createdAt datetime Créé le writable, createdAt The creation time of the entity.
createdAt_2 datetime Créé le filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Crée par writable, createdBy The user that created the entity.
createdBy_2 varchar2 Crée par filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
deliveryDate datetime Date de livraison filters on the platform, writable, ::ancestor.deliveryDate Delivery date for the project.
division_description varchar2 Description de la division filters on the platform, writable, ::ancestor.division.description The description of the division.
division_exactDivisionId varchar2 Division : ID exact de la division filters on the platform, writable, ::ancestor.division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Code de compte du grand livre général de la division filters on the platform, writable, ::ancestor.division.glAccountCode A default general ledger account code to use for sales related items.
division_glAccountCodePurchase varchar2 Division - Code de compte du grand livre général - Achats filters on the platform, writable, ::ancestor.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
division_id int64 ID de l'entreprise filters on the platform, writable, ::ancestor.division.id The ID of the division.
division_journalCode varchar2 Code du journal de division filters on the platform, writable, ::ancestor.division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Code du journal de la division : Achat filters on the platform, writable, ::ancestor.division.journalCodePurchase A default journal code to use for purchase related items.
division_salesInvoiceNumberPrefix varchar2(3) Préfixe du numéro de facture de la division des ventes filters on the platform, writable, ::ancestor.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
endDate datetime Date de fin filters on the platform, writable, ::ancestor.endDate End date for the project in ATOM format.
executor_firstName varchar2 Prénom de l'exécuteur testamentaire filters on the platform, writable, ::ancestor.executor.firstName First name of the employee.
executor_id int64 Identifiant de l'exécuteur testamentaire filters on the platform, writable, ::ancestor.executor.id ID of the employee.
executor_lastName varchar2 Nom de famille de l'exécuteur testamentaire filters on the platform, writable, ::ancestor.executor.lastName Last name of the employee.
extraWork varchar2 Heures supplémentaires filters on the platform, writable, ::ancestor.extraWork Extra work for the project.
fixedPrice varchar2 Prix fixe filters on the platform, writable, ::ancestor.fixedPrice Fixed price for the project.
fullProjectNumber varchar2 Numéro complet du projet filters on the platform, writable, ::ancestor.fullProjectNumber The full project number including year.
generalCostsAmount varchar2 Montant des frais généraux filters on the platform, writable, ::ancestor.generalCostsAmount General costs amount for the project.
hasAfasAssociation char itgen_bouw7_hasafasassociation filters on the platform, writable, ::ancestor.hasAfasAssociation Whether the project has an association with AFAS.
hasMareonAssociation char « Has Mare » sur « Association » filters on the platform, writable, ::ancestor.hasMareonAssociation Whether or not the project has an association with Mareon.
hasSecurityObjects char itgen_bouw7_hassecurityobjects filters on the platform, writable, ::ancestor.hasSecurityObjects Whether the project is security coded with security objects.
hasSubprojects char itgen_bouw7_hassubprojects filters on the platform, writable, ::ancestor.hasSubprojects Whether the project has subprojects.
hourType_createdAt datetime Type d'heure Créée le writable, hourType.createdAt The creation time of the entity.
hourType_createdBy varchar2 Type d'heure Créé par writable, hourType.createdBy The user that created the entity.
hourType_id int64 Identifiant du type d'heure writable, hourType.id The ID of HourType.
hourType_name varchar2 Nom du type d'heure writable, hourType.name The name of the HourType.
hourType_updatedAt datetime Type d'heure Mis à jour le writable, hourType.updatedAt The last updated time of the entity.
hourType_updatedBy varchar2 Type d'heure Mis à jour par writable, hourType.updatedBy The user that last updated the entity.
hours varchar2 Hours writable, hours The hours estimated for the hour type.
hoursEstimate varchar2 Estimation du nombre d'heures filters on the platform, writable, ::ancestor.hoursEstimate Estimated hours for the project.
houseNumber varchar2 Numéro de maison filters on the platform, writable, ::ancestor.houseNumber The house number for the project.
id int64 ID writable, id The ID of hours estimate per hour type.
id_2 int64 ID filters on the platform, writable, ::ancestor.id The ID of the project.
information varchar2 Information filters on the platform, writable, ::ancestor.information Information about the project.
isBooked char Est réservé filters on the platform, writable, ::ancestor.isBooked Whether or not the project has been booked to a bookkeeping system.
isSecurityCoded char La sécurité est-elle codée ? filters on the platform, writable, ::ancestor.isSecurityCoded Whether or not the project is security coded.
loggedHours varchar2 Heures enregistrées filters on the platform, writable, ::ancestor.loggedHours The amount of hours logged for the project.
maintenanceStatusCode varchar2 Code d'état de maintenance filters on the platform, writable, ::ancestor.maintenanceStatusCode The maintenance status code for the project.
name varchar2 Name filters on the platform, writable, ::ancestor.name The name of the project.
note varchar2 Note filters on the platform, writable, ::ancestor.note Notes for the project.
parentId int64 Identifiant du parent filters on the platform, writable, ::ancestor.parentId The ID of the parent project if this project is a subproject.
planItemCount int64 Nombre d'éléments du plan filters on the platform, writable, ::ancestor.planItemCount The count of plan items associated with this project.
planning varchar2 Planning filters on the platform, writable, ::ancestor.planning The planning for the project.
profitAndRisk varchar2 Bénéfice et risque filters on the platform, writable, ::ancestor.profitAndRisk Profit and risk amount for the project.
projectLeader_firstName varchar2 Prénom du chef de projet filters on the platform, writable, ::ancestor.projectLeader.firstName First name of the employee.
projectLeader_id int64 Identifiant du chef de projet filters on the platform, writable, ::ancestor.projectLeader.id ID of the employee.
projectLeader_lastName varchar2 Nom de famille du chef de projet filters on the platform, writable, ::ancestor.projectLeader.lastName Last name of the employee.
projectNumber varchar2 Numéro de Projet filters on the platform, writable, ::ancestor.projectNumber The project number.
propertyAsset_city varchar2 Immobilier, Actifs, Ville filters on the platform, writable, ::ancestor.propertyAsset.city City of the PropertyAsset.
propertyAsset_country varchar2 Bien immobilier Pays filters on the platform, writable, ::ancestor.propertyAsset.country ISO 3166-1[alpha2] country code of the PropertyAsset.
propertyAsset_description varchar2 Description du bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.description Description for the PropertyAsset.
propertyAsset_firstDeliveryDate datetime Date de première livraison du bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.firstDeliveryDate First delivery date of the PropertyAsset.
propertyAsset_houseNumber varchar2 Numéro de la maison du bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.houseNumber House number (incl. addition) of the PropertyAsset.
propertyAsset_id int64 Référence du bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.id ID of the PropertyAsset.
propertyAsset_invoiceContact_email varchar2 Bien immobilier, actif, facture, e-mail de contact filters on the platform, writable, ::ancestor.propertyAsset.invoiceContact.email The email address.
propertyAsset_invoiceContact_id int64 Bien immobilier, actif, facture, ID de contact filters on the platform, writable, ::ancestor.propertyAsset.invoiceContact.id ID of contact.
propertyAsset_invoiceContact_isVatShifted char itgen_bouw7_propertyasset_invoicecontact_isvatshifted filters on the platform, writable, ::ancestor.propertyAsset.invoiceContact.isVatShifted Whether VAT is shifted for the contact.
propertyAsset_invoiceContact_name varchar2 Bien immobilier, actif, facture, nom du contact filters on the platform, writable, ::ancestor.propertyAsset.invoiceContact.name Name of contact.
propertyAsset_invoiceContact_phoneNumber varchar2 itgen_bouw7_propertyasset_invoicecontact_phonenumber filters on the platform, writable, ::ancestor.propertyAsset.invoiceContact.phoneNumber The phone number of the contact.
propertyAsset_name varchar2 Nom du bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.name Name of the PropertyAsset.
propertyAsset_number varchar2 Numéro d'actif immobilier filters on the platform, writable, ::ancestor.propertyAsset.number Number for the PropertyAsset.
propertyAsset_postcode varchar2 Code postal du bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.postcode Postcode of the PropertyAsset.
propertyAsset_projectNameAndNumber varchar2 Nom et numéro du projet immobilier filters on the platform, writable, ::ancestor.propertyAsset.projectNameAndNumber The name and number of the Project the PropertyAsset belongs to.
propertyAsset_residentContact_email varchar2 Bien immobilier Actif Résident E-mail de contact filters on the platform, writable, ::ancestor.propertyAsset.residentContact.email The email address.
propertyAsset_residentContact_id int64 Bien immobilier - Actif - Résident - Identifiant de contact filters on the platform, writable, ::ancestor.propertyAsset.residentContact.id ID of contact.
propertyAsset_residentContact_isVatShifted char itgen_bouw7_propertyasset_residentcontact_isvatshifted filters on the platform, writable, ::ancestor.propertyAsset.residentContact.isVatShifted Whether VAT is shifted for the contact.
propertyAsset_residentContact_name varchar2 Bien immobilier / Actif / Nom du contact résident filters on the platform, writable, ::ancestor.propertyAsset.residentContact.name Name of contact.
propertyAsset_residentContact_phoneNumber varchar2 itgen_bouw7_propertyasset_residentcontact_phonenumber filters on the platform, writable, ::ancestor.propertyAsset.residentContact.phoneNumber The phone number of the contact.
propertyAsset_secondDeliveryDate datetime Date de la deuxième livraison de l'actif immobilier filters on the platform, writable, ::ancestor.propertyAsset.secondDeliveryDate Second delivery date of the PropertyAsset.
propertyAsset_streetName varchar2 Nom de la rue où se trouve le bien immobilier filters on the platform, writable, ::ancestor.propertyAsset.streetName Street name of the PropertyAsset.
provisionalCosts varchar2 itgen_bouw7_provisionalcosts filters on the platform, writable, ::ancestor.provisionalCosts Provisional cost for the project.
reference varchar2 Reference filters on the platform, writable, ::ancestor.reference A reference for this project.
startDate datetime Date de début filters on the platform, writable, ::ancestor.startDate Start date for the project in ATOM format.
status_closesProject char Statut : projet clôturé filters on the platform, writable, ::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Statut Créé le filters on the platform, writable, ::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Statut Créé par filters on the platform, writable, ::ancestor.status.createdBy The user that created the entity.
status_id int64 Identifiant d'état filters on the platform, writable, ::ancestor.status.id The ID of the status.
status_invoicesProject char État d'avancement du projet « Factures » filters on the platform, writable, ::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Nom du statut filters on the platform, writable, ::ancestor.status.name The name of the status.
status_plansProject char Projet « Status Plans » filters on the platform, writable, ::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Statut mis à jour le filters on the platform, writable, ::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Statut mis à jour par filters on the platform, writable, ::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Nom de la rue filters on the platform, writable, ::ancestor.streetName The street name for the project.
type int64 Type filters on the platform, writable, ::ancestor.type The type of project.
updatedAt datetime Mise à jour à writable, updatedAt The last updated time of the entity.
updatedAt_2 datetime Mise à jour à filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Mise à jour par writable, updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Mise à jour par filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.
workAddress varchar2 Adresse professionnelle filters on the platform, writable, ::ancestor.workAddress The work address for this project.
workPlanner_firstName varchar2 Prénom du planificateur de travail filters on the platform, writable, ::ancestor.workPlanner.firstName First name of the employee.
workPlanner_id int64 Identifiant du planificateur de tâches filters on the platform, writable, ::ancestor.workPlanner.id ID of the employee.
workPlanner_lastName varchar2 Nom de famille du responsable de la planification des travaux filters on the platform, writable, ::ancestor.workPlanner.lastName Last name of the employee.
zipCode varchar2 Code postal filters on the platform, writable, ::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 :