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

newQuotationForProject: Bouw7 New Quotation for Project

read only REST

  • Catalogue : Bouw7
  • Schéma : Quotation
  • Label: New Quotation for Project

Returns the document with the project information filled in for a new quotation. Returns the document with the project information filled in for a new quotation.

Permet uniquement de récupérer des données.

Résumé

Returns the document with the project information filled in for a new quotation.

Source de l'API

  • Point de terminaison : /quotation/{project}/new
  • Opération : get /quotation/{project}/new

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 newQuotationForProject 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
activitiesTitle varchar2(255) Titre des activités filters on the platform, writable, activitiesTitle The activities title of the quotation.
branch_code varchar2 Code d'agence filters on the platform, writable, branch.code The code for this branch
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable, branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, 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, 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, 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, branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, 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, 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, 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, branch.id The ID of the branch.
branch_name varchar2 Nom de la branche filters on the platform, writable, branch.name The name of this branch
calculationLabourDayPrice varchar2 Calcul du prix pour la Fête du Travail filters on the platform, writable, calculationLabourDayPrice The calculation labour day price of this quotation.
closingChance int64 Dernière chance filters on the platform, writable, closingChance The closing chance of this quotation.
commissionPercentage varchar2 Pourcentage de commission filters on the platform, writable, commissionPercentage The commision percentage of this quotation.
conditions varchar2 Conditions filters on the platform, writable, conditions The conditions of this quotation.
contactPersonText varchar2(255) Texte de la personne à contacter filters on the platform, writable, contactPersonText The contact person text of the quotation.
contactPerson_city varchar2(255) Personne à contacter Ville filters on the platform, writable, contactPerson.city The contact person's city.
contactPerson_createdAt datetime Personne à contacter Créé le filters on the platform, writable, contactPerson.createdAt The creation time of the entity.
contactPerson_createdBy varchar2 Interlocuteur Créé par filters on the platform, writable, contactPerson.createdBy The user that created the entity.
contactPerson_email varchar2(256) E-mail de la personne à contacter filters on the platform, writable, contactPerson.email The contact person's email address.
contactPerson_firstName varchar2(256) Prénom de la personne à contacter filters on the platform, writable, contactPerson.firstName The contact person's first name.
contactPerson_houseNumber varchar2(50) Personne à contacter Numéro de la maison filters on the platform, writable, contactPerson.houseNumber The contact person's house number.
contactPerson_id int64 Identifiant de la personne à contacter filters on the platform, writable, contactPerson.id The ID of contact person.
contactPerson_jobTitle varchar2(64) Personne à contacter - Intitulé du poste filters on the platform, writable, contactPerson.jobTitle The contact person's job title.
contactPerson_lastName varchar2(256) Nom de famille de la personne à contacter filters on the platform, writable, contactPerson.lastName The contact person's last name.
contactPerson_phoneNumber varchar2(255) Numéro de téléphone de la personne à contacter filters on the platform, writable, contactPerson.phoneNumber The contact person's phone number.
contactPerson_salutation varchar2(32) Interlocuteur - Formule d'appel filters on the platform, writable, contactPerson.salutation The contact person's salutation.
contactPerson_streetName varchar2(255) Nom de la rue de la personne à contacter filters on the platform, writable, contactPerson.streetName The contact person's street name.
contactPerson_updatedAt datetime Personne à contacter Mise à jour le filters on the platform, writable, contactPerson.updatedAt The last updated time of the entity.
contactPerson_updatedBy varchar2 Personne à contacter Mise à jour par filters on the platform, writable, contactPerson.updatedBy The user that last updated the entity.
contactPerson_zipCode varchar2(20) Nom de la personne à contacter Code postal filters on the platform, writable, contactPerson.zipCode The contact person's zip code.
contact_contactType_id int64 Contact - Type de contact - ID filters on the platform, writable, contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Type de contact Nom filters on the platform, writable, contact.contactType.name The name of contact type.
contact_email varchar2 Email du contact filters on the platform, writable, contact.email The email address.
contact_id int64 ID de contact filters on the platform, writable, contact.id ID of contact.
contact_isVatShifted char Contact : la TVA est-elle répercutée ? filters on the platform, writable, contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Nom du Contact filters on the platform, writable, contact.name Name of contact.
contact_phoneNumber varchar2 Numéro de téléphone filters on the platform, writable, contact.phoneNumber The phone number of the contact.
createdAt datetime Créé le filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Crée par filters on the platform, writable, createdBy The user that created the entity.
disableQuotationLines char Désactiver les lignes de citation filters on the platform, writable, disableQuotationLines Whether the quotation lines are disabled.
discount int64 Discount filters on the platform, writable, discount The discount of this quotation.
employee_firstName varchar2 Prénom de l’employé filters on the platform, writable, employee.firstName First name of the employee.
employee_id int64 ID d'employé filters on the platform, writable, employee.id ID of the employee.
employee_lastName varchar2 Nom de famille de l’employé filters on the platform, writable, employee.lastName Last name of the employee.
expectedClosingDate datetime Date prévue de clôture filters on the platform, writable, expectedClosingDate The expected closing date of this quotation.
footer varchar2 Footer filters on the platform, writable, footer The footer of the quotation.
id int64 ID filters on the platform, writable, id The ID of the quotation.
information varchar2 Information filters on the platform, writable, information The information of the quotation.
isCalculation char Est-ce un calcul ? filters on the platform, writable, isCalculation Whether the quotation is a calculation.
labourDayPrice varchar2 Prix de la Fête du Travail filters on the platform, writable, labourDayPrice The labour day price of this quotation.
language varchar2 Language filters on the platform, writable, language The locale used by this quotation, e.g.: nl-NL.
layout varchar2 Layout filters on the platform, writable, layout The layout of the quotation.
mailSentAt varchar2 E-mail envoyé le filters on the platform, writable, mailSentAt The date when the mail was sent.
note varchar2 Note filters on the platform, writable, note The note of this quotation.
overheads varchar2 Overheads filters on the platform, writable, overheads The general costs of this quotation.
overheadsVatTariff_effectiveFrom varchar2 itgen_bouw7_overheadsvattariff_effectivefrom filters on the platform, writable, overheadsVatTariff.effectiveFrom The datetime in ATOM format since this VAT tariff is effective.
overheadsVatTariff_id int64 Frais généraux, TVA, numéro d'identification tarifaire filters on the platform, writable, overheadsVatTariff.id ID of the vat tariff.
overheadsVatTariff_label varchar2 Frais généraux Taux de TVA Étiquette filters on the platform, writable, overheadsVatTariff.label Display label of the VAT tariff.
overheadsVatTariff_percentage varchar2 Frais généraux Taux de TVA filters on the platform, writable, overheadsVatTariff.percentage The VAT percentage.
profitAndRisk varchar2 Bénéfice et risque filters on the platform, writable, profitAndRisk The profit and risk costs of this quotation.
profitAndRiskVatTariff_effectiveFrom varchar2 itgen_bouw7_profitandriskvattariff_effectivefrom filters on the platform, writable, profitAndRiskVatTariff.effectiveFrom The datetime in ATOM format since this VAT tariff is effective.
profitAndRiskVatTariff_id int64 Bénéfice et risque - Numéro d'identification TVA filters on the platform, writable, profitAndRiskVatTariff.id ID of the vat tariff.
profitAndRiskVatTariff_label varchar2 Étiquette « Bénéfice et risque » – Taux de TVA filters on the platform, writable, profitAndRiskVatTariff.label Display label of the VAT tariff.
profitAndRiskVatTariff_percentage varchar2 Bénéfice et risque – Taux de TVA filters on the platform, writable, profitAndRiskVatTariff.percentage The VAT percentage.
project_branch_code varchar2 itgen_bouw7_project_branch_code filters on the platform, writable, project.branch.code The code for this branch
project_branch_id int64 itgen_bouw7_project_branch_id filters on the platform, writable, project.branch.id The ID of the branch.
project_branch_name varchar2 itgen_bouw7_project_branch_name filters on the platform, writable, project.branch.name The name of this branch
project_category_code varchar2 itgen_bouw7_project_category_code filters on the platform, writable, project.category.code The code for the category.
project_category_createdAt datetime itgen_bouw7_project_category_createdat filters on the platform, writable, project.category.createdAt The creation time of the entity.
project_category_createdBy varchar2 itgen_bouw7_project_category_createdby filters on the platform, writable, project.category.createdBy The user that created the entity.
project_category_generalCostsOrProfit varchar2 itgen_bouw7_project_category_generalcostsorprofit filters on the platform, writable, project.category.generalCostsOrProfit The general costs or profit for the category.
project_category_generalCostsPercentage varchar2 itgen_bouw7_project_category_generalcostspercentage filters on the platform, writable, project.category.generalCostsPercentage The general costs percentage for the category.
project_category_grossProfitMargin varchar2 itgen_bouw7_project_category_grossprofitmargin filters on the platform, writable, project.category.grossProfitMargin The gross profit margin for the category.
project_category_id int64 itgen_bouw7_project_category_id filters on the platform, writable, project.category.id The ID of the category.
project_category_name varchar2 itgen_bouw7_project_category_name filters on the platform, writable, project.category.name The name of the category.
project_category_updatedAt datetime itgen_bouw7_project_category_updatedat filters on the platform, writable, project.category.updatedAt The last updated time of the entity.
project_category_updatedBy varchar2 itgen_bouw7_project_category_updatedby filters on the platform, writable, project.category.updatedBy The user that last updated the entity.
project_city varchar2 Ville du projet filters on the platform, writable, project.city The city of the project.
project_contact_email varchar2 Adresse e-mail de contact pour le projet filters on the platform, writable, project.contact.email The email address.
project_contact_id int64 Référence du projet filters on the platform, writable, project.contact.id ID of contact.
project_contact_isVatShifted char itgen_bouw7_project_contact_isvatshifted filters on the platform, writable, project.contact.isVatShifted Whether VAT is shifted for the contact.
project_contact_name varchar2 Nom du responsable du projet filters on the platform, writable, project.contact.name Name of contact.
project_contact_phoneNumber varchar2 itgen_bouw7_project_contact_phonenumber filters on the platform, writable, project.contact.phoneNumber The phone number of the contact.
project_createdAt datetime Projet créé le filters on the platform, writable, project.createdAt The creation time of the entity.
project_createdBy varchar2 Projet créé par filters on the platform, writable, project.createdBy The user that created the entity.
project_deliveryDate datetime Date de livraison du projet filters on the platform, writable, project.deliveryDate Delivery date for the project.
project_endDate datetime Date de fin du projet filters on the platform, writable, project.endDate End date for the project.
project_fullProjectNumber varchar2 Numéro complet du projet filters on the platform, writable, project.fullProjectNumber The full project number including year.
project_houseNumber varchar2 Numéro du projet filters on the platform, writable, project.houseNumber The house number for the project.
project_id int64 Identifiant du projet filters on the platform, writable, project.id The ID of the project.
project_information varchar2 Informations du projet filters on the platform, writable, project.information The information of the project.
project_name varchar2 Nom de projet filters on the platform, writable, project.name The name of the project.
project_projectNumber varchar2 Projet Numéro de projet filters on the platform, writable, project.projectNumber The project number.
project_reference varchar2 Référence du projet filters on the platform, writable, project.reference The reference of the project.
project_startDate datetime Date de début du projet filters on the platform, writable, project.startDate Start date for the project.
project_status_closesProject char Statut du projet : Clôture du projet filters on the platform, writable, project.status.closesProject Whether or not this status closes a project.
project_status_createdAt datetime Statut du projet Créé le filters on the platform, writable, project.status.createdAt The creation time of the entity.
project_status_createdBy varchar2 Statut du projet Créé par filters on the platform, writable, project.status.createdBy The user that created the entity.
project_status_id int64 Identifiant de l'état du projet filters on the platform, writable, project.status.id The ID of the status.
project_status_invoicesProject char État d'avancement du projet Factures Projet filters on the platform, writable, project.status.invoicesProject Whether or not this status invoices a project.
project_status_name varchar2 Nom de l'état d'avancement du projet filters on the platform, writable, project.status.name The name of the status.
project_status_plansProject char État d'avancement du projet Plans Projet filters on the platform, writable, project.status.plansProject Whether or not this status plans a project.
project_status_updatedAt datetime État d'avancement du projet mis à jour le filters on the platform, writable, project.status.updatedAt The last updated time of the entity.
project_status_updatedBy varchar2 État du projet mis à jour par filters on the platform, writable, project.status.updatedBy The user that last updated the entity.
project_streetName varchar2 Nom du projet « Street » filters on the platform, writable, project.streetName The street name for the project.
project_updatedAt datetime Mise à jour du projet le filters on the platform, writable, project.updatedAt The last updated time of the entity.
project_updatedBy varchar2 Projet mis à jour par filters on the platform, writable, project.updatedBy The user that last updated the entity.
project_zipCode varchar2 Code postal du projet filters on the platform, writable, project.zipCode The zip code for the project.
quotationDate datetime Date de cotation filters on the platform, writable, quotationDate The date of this quotation.
quotationNumber varchar2 Numéro de devis filters on the platform, writable, quotationNumber The number of the quotation.
quotationStatus_id int64 Identifiant du statut de devis filters on the platform, writable, quotationStatus.id ID of the quotation status.
quotationStatus_name varchar2 Nom du statut du devis filters on the platform, writable, quotationStatus.name The name of the quotation status.
reference varchar2(255) Reference filters on the platform, writable, reference The reference of the quotation.
salutation int64 Salutation filters on the platform, writable, salutation The salutation of this quotation.
salutationText varchar2(255) Texte de formule de politesse filters on the platform, writable, salutationText The salutation text of the quotation.
showOverheadsOnPdf char Afficher les diapositives dans le PDF filters on the platform, writable, showOverheadsOnPdf Whether the general costs and profit and risk should be shown on the quotation PDF.
showPricePerLine char Afficher le prix par ligne filters on the platform, writable, showPricePerLine Whether the price is shown per line.
showSubtotalPerChapter char Afficher le sous-total par chapitre filters on the platform, writable, showSubtotalPerChapter Whether the subtotal is shown per chapter.
showTotalPrice char Afficher le prix total filters on the platform, writable, showTotalPrice Whether the total price is shown on this quotation.
subject varchar2(255) Subject filters on the platform, writable, subject The subject of the quotation.
updatedAt datetime Mise à jour à filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Mise à jour par filters on the platform, writable, updatedBy 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 :