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 |
|---|---|---|---|---|---|
activities |
varchar2 |
Titre des activités | filters on the platform, writable, activities |
The activities title of the quotation. | |
branch_ |
varchar2 |
Code d'agence | filters on the platform, writable, branch. |
The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable, branch. |
The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable, branch. |
The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable, branch. |
A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable, branch. |
A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable, branch. |
The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable, branch. |
A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable, branch. |
A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable, branch. |
The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Identifiant de la succursale | filters on the platform, writable, branch. |
The ID of the branch. | |
branch_ |
varchar2 |
Nom de la branche | filters on the platform, writable, branch. |
The name of this branch | |
calculation |
varchar2 |
Calcul du prix pour la Fête du Travail | filters on the platform, writable, calculation |
The calculation labour day price of this quotation. | |
closing |
int64 |
Dernière chance | filters on the platform, writable, closing |
The closing chance of this quotation. | |
commission |
varchar2 |
Pourcentage de commission | filters on the platform, writable, commission |
The commision percentage of this quotation. | |
conditions |
varchar2 |
Conditions | filters on the platform, writable, conditions |
The conditions of this quotation. | |
contact |
varchar2 |
Texte de la personne à contacter | filters on the platform, writable, contact |
The contact person text of the quotation. | |
contact |
varchar2 |
Personne à contacter Ville | filters on the platform, writable, contact |
The contact person's city. | |
contact |
datetime |
Personne à contacter Créé le | filters on the platform, writable, contact |
The creation time of the entity. | |
contact |
varchar2 |
Interlocuteur Créé par | filters on the platform, writable, contact |
The user that created the entity. | |
contact |
varchar2 |
E-mail de la personne à contacter | filters on the platform, writable, contact |
The contact person's email address. | |
contact |
varchar2 |
Prénom de la personne à contacter | filters on the platform, writable, contact |
The contact person's first name. | |
contact |
varchar2 |
Personne à contacter Numéro de la maison | filters on the platform, writable, contact |
The contact person's house number. | |
contact |
int64 |
Identifiant de la personne à contacter | filters on the platform, writable, contact |
The ID of contact person. | |
contact |
varchar2 |
Personne à contacter - Intitulé du poste | filters on the platform, writable, contact |
The contact person's job title. | |
contact |
varchar2 |
Nom de famille de la personne à contacter | filters on the platform, writable, contact |
The contact person's last name. | |
contact |
varchar2 |
Numéro de téléphone de la personne à contacter | filters on the platform, writable, contact |
The contact person's phone number. | |
contact |
varchar2 |
Interlocuteur - Formule d'appel | filters on the platform, writable, contact |
The contact person's salutation. | |
contact |
varchar2 |
Nom de la rue de la personne à contacter | filters on the platform, writable, contact |
The contact person's street name. | |
contact |
datetime |
Personne à contacter Mise à jour le | filters on the platform, writable, contact |
The last updated time of the entity. | |
contact |
varchar2 |
Personne à contacter Mise à jour par | filters on the platform, writable, contact |
The user that last updated the entity. | |
contact |
varchar2 |
Nom de la personne à contacter Code postal | filters on the platform, writable, contact |
The contact person's zip code. | |
contact_ |
int64 |
Contact - Type de contact - ID | filters on the platform, writable, contact. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Type de contact Nom | filters on the platform, writable, contact. |
The name of contact type. | |
contact_ |
varchar2 |
Email du contact | filters on the platform, writable, contact. |
The email address. | |
contact_ |
int64 |
ID de contact | filters on the platform, writable, contact. |
ID of contact. | |
contact_ |
char |
Contact : la TVA est-elle répercutée ? | filters on the platform, writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Nom du Contact | filters on the platform, writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Numéro de téléphone | filters on the platform, writable, contact. |
The phone number of the contact. | |
created |
datetime |
Créé le | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Crée par | filters on the platform, writable, created |
The user that created the entity. | |
disable |
char |
Désactiver les lignes de citation | filters on the platform, writable, disable |
Whether the quotation lines are disabled. | |
discount |
int64 |
Discount | filters on the platform, writable, discount |
The discount of this quotation. | |
employee_ |
varchar2 |
Prénom de l’employé | filters on the platform, writable, employee. |
First name of the employee. | |
employee_ |
int64 |
ID d'employé | filters on the platform, writable, employee. |
ID of the employee. | |
employee_ |
varchar2 |
Nom de famille de l’employé | filters on the platform, writable, employee. |
Last name of the employee. | |
expected |
datetime |
Date prévue de clôture | filters on the platform, writable, expected |
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. | |
is |
char |
Est-ce un calcul ? | filters on the platform, writable, is |
Whether the quotation is a calculation. | |
labour |
varchar2 |
Prix de la Fête du Travail | filters on the platform, writable, labour |
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. | |
mail |
varchar2 |
E-mail envoyé le | filters on the platform, writable, mail |
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. | |
overheads |
varchar2 |
itgen_bouw7_overheadsvattariff_effectivefrom | filters on the platform, writable, overheads |
The datetime in ATOM format since this VAT tariff is effective. | |
overheads |
int64 |
Frais généraux, TVA, numéro d'identification tarifaire | filters on the platform, writable, overheads |
ID of the vat tariff. | |
overheads |
varchar2 |
Frais généraux Taux de TVA Étiquette | filters on the platform, writable, overheads |
Display label of the VAT tariff. | |
overheads |
varchar2 |
Frais généraux Taux de TVA | filters on the platform, writable, overheads |
The VAT percentage. | |
profit |
varchar2 |
Bénéfice et risque | filters on the platform, writable, profit |
The profit and risk costs of this quotation. | |
profit |
varchar2 |
itgen_bouw7_profitandriskvattariff_effectivefrom | filters on the platform, writable, profit |
The datetime in ATOM format since this VAT tariff is effective. | |
profit |
int64 |
Bénéfice et risque - Numéro d'identification TVA | filters on the platform, writable, profit |
ID of the vat tariff. | |
profit |
varchar2 |
Étiquette « Bénéfice et risque » – Taux de TVA | filters on the platform, writable, profit |
Display label of the VAT tariff. | |
profit |
varchar2 |
Bénéfice et risque – Taux de TVA | filters on the platform, writable, profit |
The VAT percentage. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable, project. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, project. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, project. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, project. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, project. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, project. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, project. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, project. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, project. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Ville du projet | filters on the platform, writable, project. |
The city of the project. | |
project_ |
varchar2 |
Adresse e-mail de contact pour le projet | filters on the platform, writable, project. |
The email address. | |
project_ |
int64 |
Référence du projet | filters on the platform, writable, project. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, project. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Nom du responsable du projet | filters on the platform, writable, project. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, project. |
The phone number of the contact. | |
project_ |
datetime |
Projet créé le | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Projet créé par | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
datetime |
Date de livraison du projet | filters on the platform, writable, project. |
Delivery date for the project. | |
project_ |
datetime |
Date de fin du projet | filters on the platform, writable, project. |
End date for the project. | |
project_ |
varchar2 |
Numéro complet du projet | filters on the platform, writable, project. |
The full project number including year. | |
project_ |
varchar2 |
Numéro du projet | filters on the platform, writable, project. |
The house number for the project. | |
project_ |
int64 |
Identifiant du projet | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Informations du projet | filters on the platform, writable, project. |
The information of the project. | |
project_ |
varchar2 |
Nom de projet | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Projet Numéro de projet | filters on the platform, writable, project. |
The project number. | |
project_ |
varchar2 |
Référence du projet | filters on the platform, writable, project. |
The reference of the project. | |
project_ |
datetime |
Date de début du projet | filters on the platform, writable, project. |
Start date for the project. | |
project_ |
char |
Statut du projet : Clôture du projet | filters on the platform, writable, project. |
Whether or not this status closes a project. | |
project_ |
datetime |
Statut du projet Créé le | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Statut du projet Créé par | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
int64 |
Identifiant de l'état du projet | filters on the platform, writable, project. |
The ID of the status. | |
project_ |
char |
État d'avancement du projet Factures Projet | filters on the platform, writable, project. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Nom de l'état d'avancement du projet | filters on the platform, writable, project. |
The name of the status. | |
project_ |
char |
État d'avancement du projet Plans Projet | filters on the platform, writable, project. |
Whether or not this status plans a project. | |
project_ |
datetime |
État d'avancement du projet mis à jour le | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
État du projet mis à jour par | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Nom du projet « Street » | filters on the platform, writable, project. |
The street name for the project. | |
project_ |
datetime |
Mise à jour du projet le | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Projet mis à jour par | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Code postal du projet | filters on the platform, writable, project. |
The zip code for the project. | |
quotation |
datetime |
Date de cotation | filters on the platform, writable, quotation |
The date of this quotation. | |
quotation |
varchar2 |
Numéro de devis | filters on the platform, writable, quotation |
The number of the quotation. | |
quotation |
int64 |
Identifiant du statut de devis | filters on the platform, writable, quotation |
ID of the quotation status. | |
quotation |
varchar2 |
Nom du statut du devis | filters on the platform, writable, quotation |
The name of the quotation status. | |
reference |
varchar2 |
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. | |
salutation |
varchar2 |
Texte de formule de politesse | filters on the platform, writable, salutation |
The salutation text of the quotation. | |
show |
char |
Afficher les diapositives dans le PDF | filters on the platform, writable, show |
Whether the general costs and profit and risk should be shown on the quotation PDF. | |
show |
char |
Afficher le prix par ligne | filters on the platform, writable, show |
Whether the price is shown per line. | |
show |
char |
Afficher le sous-total par chapitre | filters on the platform, writable, show |
Whether the subtotal is shown per chapter. | |
show |
char |
Afficher le prix total | filters on the platform, writable, show |
Whether the total price is shown on this quotation. | |
subject |
varchar2 |
Subject | filters on the platform, writable, subject |
The subject of the quotation. | |
updated |
datetime |
Mise à jour à | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Mise à jour par | filters on the platform, writable, updated |
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 :