newQuotationForProject: Bouw7 New Quotation for Project
read only REST
- Catalogus:
Bouw7 - Schema:
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.
Kan alleen gegevens ophalen.
Samenvatting
Returns the document with the project information filled in for a new quotation.
API-bron
- Eindpunt:
/quotation/{project}/new - Operatie:
get /quotation/{project}/new
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 90 |
| Aantal rijen per minuut bij volledige scan | 241,000 |
| Aantal rijen per minuut in een Query | 666 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Parameters
| Name | Datatype | Required | Default | Documentation |
|---|---|---|---|---|
project |
`` | Project ID |
Tabelkolommen
De kolommen van de tabel newQuotationForProject worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
activities |
varchar2 |
Activiteitentitel | filters on the platform, writable, activities |
The activities title of the quotation. | |
branch_ |
varchar2 |
Vestigingscode | 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 |
Vestiging-ID | filters on the platform, writable, branch. |
The ID of the branch. | |
branch_ |
varchar2 |
Filiaalnaam | filters on the platform, writable, branch. |
The name of this branch | |
calculation |
varchar2 |
Berekening Arbeidsdagprijs | filters on the platform, writable, calculation |
The calculation labour day price of this quotation. | |
closing |
int64 |
Sluitingskans | filters on the platform, writable, closing |
The closing chance of this quotation. | |
commission |
varchar2 |
Commissie Percentage | 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 |
Contactpersoon Tekst | filters on the platform, writable, contact |
The contact person text of the quotation. | |
contact |
varchar2 |
Contactpersoon Stad | filters on the platform, writable, contact |
The contact person's city. | |
contact |
datetime |
Contactpersoon Aangemaakt op | filters on the platform, writable, contact |
The creation time of the entity. | |
contact |
varchar2 |
Contactpersoon Aangemaakt door | filters on the platform, writable, contact |
The user that created the entity. | |
contact |
varchar2 |
Contactpersoon E-mail | filters on the platform, writable, contact |
The contact person's email address. | |
contact |
varchar2 |
Contactpersoon Voornaam | filters on the platform, writable, contact |
The contact person's first name. | |
contact |
varchar2 |
Contactpersoon Huisnummer | filters on the platform, writable, contact |
The contact person's house number. | |
contact |
int64 |
Contactpersoon ID | filters on the platform, writable, contact |
The ID of contact person. | |
contact |
varchar2 |
Contactpersoon Functietitel | filters on the platform, writable, contact |
The contact person's job title. | |
contact |
varchar2 |
Contactpersoon Achternaam | filters on the platform, writable, contact |
The contact person's last name. | |
contact |
varchar2 |
Contactpersoon Telefoonnummer | filters on the platform, writable, contact |
The contact person's phone number. | |
contact |
varchar2 |
Contactpersoon Aanhef | filters on the platform, writable, contact |
The contact person's salutation. | |
contact |
varchar2 |
Contactpersoon Straatnaam | filters on the platform, writable, contact |
The contact person's street name. | |
contact |
datetime |
Contactpersoon Bijgewerkt op | filters on the platform, writable, contact |
The last updated time of the entity. | |
contact |
varchar2 |
Contactpersoon Bijgewerkt door | filters on the platform, writable, contact |
The user that last updated the entity. | |
contact |
varchar2 |
Contactpersoon Postcode | filters on the platform, writable, contact |
The contact person's zip code. | |
contact_ |
int64 |
Contact Soort ID | filters on the platform, writable, contact. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Soort Naam | filters on the platform, writable, contact. |
The name of contact type. | |
contact_ |
varchar2 |
Contact E-mail | filters on the platform, writable, contact. |
The email address. | |
contact_ |
int64 |
Contactpersoon ID | filters on the platform, writable, contact. |
ID of contact. | |
contact_ |
char |
Contact is BTW Verlegd | filters on the platform, writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contactpersoon Naam | filters on the platform, writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Contact Telefoonnummer | filters on the platform, writable, contact. |
The phone number of the contact. | |
created |
datetime |
Aangemaakt op | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Gemaakt door | filters on the platform, writable, created |
The user that created the entity. | |
disable |
char |
Offerteregels Uitschakelen | 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 |
Medewerker Voornaam | filters on the platform, writable, employee. |
First name of the employee. | |
employee_ |
int64 |
Werknemer ID | filters on the platform, writable, employee. |
ID of the employee. | |
employee_ |
varchar2 |
Medewerker Achternaam | filters on the platform, writable, employee. |
Last name of the employee. | |
expected |
datetime |
Verwachte sluitingsdatum | 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 |
Is Berekening | filters on the platform, writable, is |
Whether the quotation is a calculation. | |
labour |
varchar2 |
Arbeidsdag Prijs | 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 |
Mail Verstuurd op | 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 |
Overheadkosten BTW Tarief-ID | filters on the platform, writable, overheads |
ID of the vat tariff. | |
overheads |
varchar2 |
Overhead BTW-tarief Label | filters on the platform, writable, overheads |
Display label of the VAT tariff. | |
overheads |
varchar2 |
Overheadkosten BTW Tariefpercentage | filters on the platform, writable, overheads |
The VAT percentage. | |
profit |
varchar2 |
Winst en Risico | 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 |
Winst en Risico BTW Tarief-ID | filters on the platform, writable, profit |
ID of the vat tariff. | |
profit |
varchar2 |
Winst en Risico BTW-tarief Label | filters on the platform, writable, profit |
Display label of the VAT tariff. | |
profit |
varchar2 |
Winst en Risico BTW-tariefpercentage | 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 |
Project Stad | filters on the platform, writable, project. |
The city of the project. | |
project_ |
varchar2 |
Projectcontactpersoon E-mail | filters on the platform, writable, project. |
The email address. | |
project_ |
int64 |
Projectcontactpersoon-ID | 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 |
Project Contactnaam | 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 |
Project Gemaakt op | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Gemaakt door | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
datetime |
Project Opleverdatum | filters on the platform, writable, project. |
Delivery date for the project. | |
project_ |
datetime |
Project Einddatum | filters on the platform, writable, project. |
End date for the project. | |
project_ |
varchar2 |
Volledig Projectnummer | filters on the platform, writable, project. |
The full project number including year. | |
project_ |
varchar2 |
Project Huisnummer | filters on the platform, writable, project. |
The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Projectgegevens | filters on the platform, writable, project. |
The information of the project. | |
project_ |
varchar2 |
Projectnaam | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Projectnummer | filters on the platform, writable, project. |
The project number. | |
project_ |
varchar2 |
Projectreferentie | filters on the platform, writable, project. |
The reference of the project. | |
project_ |
datetime |
Project Startdatum | filters on the platform, writable, project. |
Start date for the project. | |
project_ |
char |
Projectstatus Sluit Project af | filters on the platform, writable, project. |
Whether or not this status closes a project. | |
project_ |
datetime |
Projectstatus Gemaakt op | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Projectstatus Gemaakt door | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
int64 |
Projectstatus-ID | filters on the platform, writable, project. |
The ID of the status. | |
project_ |
char |
Projectstatus Projectfacturen | filters on the platform, writable, project. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Projectstatusnaam | filters on the platform, writable, project. |
The name of the status. | |
project_ |
char |
Projectstatus Plannen Project | filters on the platform, writable, project. |
Whether or not this status plans a project. | |
project_ |
datetime |
Projectstatus Bijgewerkt op | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Projectstatus Bijgewerkt door | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Projectstraatnaam | filters on the platform, writable, project. |
The street name for the project. | |
project_ |
datetime |
Project Bijgewerkt op | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Bijgewerkt door | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Postcode | filters on the platform, writable, project. |
The zip code for the project. | |
quotation |
datetime |
Offertedatum | filters on the platform, writable, quotation |
The date of this quotation. | |
quotation |
varchar2 |
Offertenummer | filters on the platform, writable, quotation |
The number of the quotation. | |
quotation |
int64 |
Offertestatus-ID | filters on the platform, writable, quotation |
ID of the quotation status. | |
quotation |
varchar2 |
Offertestatus Naam | 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 |
Aanhef Tekst | filters on the platform, writable, salutation |
The salutation text of the quotation. | |
show |
char |
Toon Overheadkosten op PDF | filters on the platform, writable, show |
Whether the general costs and profit and risk should be shown on the quotation PDF. | |
show |
char |
Toon Prijs per Regel | filters on the platform, writable, show |
Whether the price is shown per line. | |
show |
char |
Toon Subtotaal per Hoofdstuk | filters on the platform, writable, show |
Whether the subtotal is shown per chapter. | |
show |
char |
Toon Totale Prijs | 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 |
Bijgewerkt op | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Bijgewerkt door | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: