QuotationChaptersByQuotationId: Bouw7 Quotation Chapters by Quotation ID
read only REST
- Catalog:
Bouw7 - Schema:
Quotation - Label: Quotation Chapters by Quotation ID
Returns the document of an existing quotation. Returns the document of the given quotation.
Can only retrieve data.
Summary
Returns the document of the given quotation.
API Source
- Endpoint:
/quotation/{quotation} - Operation:
get /quotation/{quotation}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
quotation |
`` | Quotation ID |
Table Columns
The columns of the table QuotationChaptersByQuotationId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
activities |
varchar2 |
Activities Title | filters on the platform, writable, ::ancestor. |
The activities title of the quotation. | |
additional |
char |
Additional Work | writable, additional |
Whether the quotation line chapter has additional work. | |
branch_ |
varchar2 |
Branch Code | filters on the platform, writable, ::ancestor. |
The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Branch ID | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
The name of this branch | |
calculation |
varchar2 |
Calculation Labour Day Price | filters on the platform, writable, ::ancestor. |
The calculation labour day price of this quotation. | |
closing |
int64 |
Closing Chance | filters on the platform, writable, ::ancestor. |
The closing chance of this quotation. | |
commission |
varchar2 |
Commission Percentage | filters on the platform, writable, ::ancestor. |
The commision percentage of this quotation. | |
conditions |
varchar2 |
Conditions | filters on the platform, writable, ::ancestor. |
The conditions of this quotation. | |
contact |
varchar2 |
Contact Person Text | filters on the platform, writable, ::ancestor. |
The contact person text of the quotation. | |
contact |
varchar2 |
Contact Person City | filters on the platform, writable, ::ancestor. |
The contact person's city. | |
contact |
datetime |
Contact Person Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
contact |
varchar2 |
Contact Person Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
contact |
varchar2 |
Contact Person Email | filters on the platform, writable, ::ancestor. |
The contact person's email address. | |
contact |
varchar2 |
Contact Person First Name | filters on the platform, writable, ::ancestor. |
The contact person's first name. | |
contact |
varchar2 |
Contact Person House Number | filters on the platform, writable, ::ancestor. |
The contact person's house number. | |
contact |
int64 |
Contact Person ID | filters on the platform, writable, ::ancestor. |
The ID of contact person. | |
contact |
varchar2 |
Contact Person Job Title | filters on the platform, writable, ::ancestor. |
The contact person's job title. | |
contact |
varchar2 |
Contact Person Last Name | filters on the platform, writable, ::ancestor. |
The contact person's last name. | |
contact |
varchar2 |
Contact Person Phone Number | filters on the platform, writable, ::ancestor. |
The contact person's phone number. | |
contact |
varchar2 |
Contact Person Salutation | filters on the platform, writable, ::ancestor. |
The contact person's salutation. | |
contact |
varchar2 |
Contact Person Street Name | filters on the platform, writable, ::ancestor. |
The contact person's street name. | |
contact |
datetime |
Contact Person Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
contact |
varchar2 |
Contact Person Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
contact |
varchar2 |
Contact Person ZIP Code | filters on the platform, writable, ::ancestor. |
The contact person's zip code. | |
contact_ |
int64 |
Contact Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
created |
datetime |
Created at | writable, created |
The creation time of the entity. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | writable, created |
The user that created the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
disable |
char |
Disable Quotation Lines | filters on the platform, writable, ::ancestor. |
Whether the quotation lines are disabled. | |
discount |
int64 |
Discount | filters on the platform, writable, ::ancestor. |
The discount of this quotation. | |
employee_ |
varchar2 |
Employee First Name | filters on the platform, writable, ::ancestor. |
First name of the employee. | |
employee_ |
int64 |
Employee ID | filters on the platform, writable, ::ancestor. |
ID of the employee. | |
employee_ |
varchar2 |
Employee Last Name | filters on the platform, writable, ::ancestor. |
Last name of the employee. | |
expected |
datetime |
Expected Closing Date | filters on the platform, writable, ::ancestor. |
The expected closing date of this quotation. | |
footer |
varchar2 |
Footer | filters on the platform, writable, ::ancestor. |
The footer of the quotation. | |
has |
char |
Has Price | writable, has |
Whether the quotation line chapter has a price. | |
id |
int64 |
ID | writable, id |
ID of the quotation line chapter. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of the quotation. | |
information |
varchar2 |
Information | filters on the platform, writable, ::ancestor. |
The information of the quotation. | |
is |
char |
Is Calculation | filters on the platform, writable, ::ancestor. |
Whether the quotation is a calculation. | |
labour |
varchar2 |
Labour Day Price | filters on the platform, writable, ::ancestor. |
The labour day price of this quotation. | |
language |
varchar2 |
Language | filters on the platform, writable, ::ancestor. |
The locale used by this quotation, e.g.: nl-NL. | |
layout |
varchar2 |
Layout | filters on the platform, writable, ::ancestor. |
The layout of the quotation. | |
mail |
varchar2 |
Mail Sent at | filters on the platform, writable, ::ancestor. |
The date when the mail was sent. | |
name |
varchar2 |
Name | writable, name |
The name of this quotation line chapter. | |
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
The note of this quotation. | |
overheads |
varchar2 |
Overheads | filters on the platform, writable, ::ancestor. |
The general costs of this quotation. | |
overheads |
varchar2 |
itgen_bouw7_overheadsvattariff_effectivefrom | filters on the platform, writable, ::ancestor. |
The datetime in ATOM format since this VAT tariff is effective. | |
overheads |
int64 |
Overheads VAT Tariff ID | filters on the platform, writable, ::ancestor. |
ID of the vat tariff. | |
overheads |
varchar2 |
Overheads VAT tariff Label | filters on the platform, writable, ::ancestor. |
Display label of the VAT tariff. | |
overheads |
varchar2 |
Overheads VAT Tariff Percentage | filters on the platform, writable, ::ancestor. |
The VAT percentage. | |
profit |
varchar2 |
Profit and Risk | filters on the platform, writable, ::ancestor. |
The profit and risk costs of this quotation. | |
profit |
varchar2 |
itgen_bouw7_profitandriskvattariff_effectivefrom | filters on the platform, writable, ::ancestor. |
The datetime in ATOM format since this VAT tariff is effective. | |
profit |
int64 |
Profit and Risk VAT Tariff ID | filters on the platform, writable, ::ancestor. |
ID of the vat tariff. | |
profit |
varchar2 |
Profit and Risk VAT Tariff Label | filters on the platform, writable, ::ancestor. |
Display label of the VAT tariff. | |
profit |
varchar2 |
Profit and Risk VAT Tariff Percentage | filters on the platform, writable, ::ancestor. |
The VAT percentage. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable, ::ancestor. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, ::ancestor. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, ::ancestor. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, ::ancestor. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, ::ancestor. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, ::ancestor. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, ::ancestor. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, ::ancestor. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project City | filters on the platform, writable, ::ancestor. |
The city of the project. | |
project_ |
varchar2 |
Project Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
project_ |
int64 |
Project Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
project_ |
datetime |
Project Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
datetime |
Project Delivery Date | filters on the platform, writable, ::ancestor. |
Delivery date for the project. | |
project_ |
datetime |
Project End Date | filters on the platform, writable, ::ancestor. |
End date for the project. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable, ::ancestor. |
The full project number including year. | |
project_ |
varchar2 |
Project House Number | filters on the platform, writable, ::ancestor. |
The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, ::ancestor. |
The ID of the project. | |
project_ |
varchar2 |
Project Information | filters on the platform, writable, ::ancestor. |
The information of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, ::ancestor. |
The name of the project. | |
project_ |
varchar2 |
Project Project Number | filters on the platform, writable, ::ancestor. |
The project number. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable, ::ancestor. |
The reference of the project. | |
project_ |
datetime |
Project Start Date | filters on the platform, writable, ::ancestor. |
Start date for the project. | |
project_ |
char |
Project Status Closes Project | filters on the platform, writable, ::ancestor. |
Whether or not this status closes a project. | |
project_ |
datetime |
Project Status Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Status Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, ::ancestor. |
The ID of the status. | |
project_ |
char |
Project Status Invoices Project | filters on the platform, writable, ::ancestor. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Project Status Name | filters on the platform, writable, ::ancestor. |
The name of the status. | |
project_ |
char |
Project Status Plans Project | filters on the platform, writable, ::ancestor. |
Whether or not this status plans a project. | |
project_ |
datetime |
Project Status Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Status Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Street Name | filters on the platform, writable, ::ancestor. |
The street name for the project. | |
project_ |
datetime |
Project Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project ZIP Code | filters on the platform, writable, ::ancestor. |
The zip code for the project. | |
quotation |
datetime |
Quotation Date | filters on the platform, writable, ::ancestor. |
The date of this quotation. | |
quotation |
varchar2 |
Quotation Number | filters on the platform, writable, ::ancestor. |
The number of the quotation. | |
quotation |
int64 |
Quotation Status ID | filters on the platform, writable, ::ancestor. |
ID of the quotation status. | |
quotation |
varchar2 |
Quotation Status Name | filters on the platform, writable, ::ancestor. |
The name of the quotation status. | |
reference |
varchar2 |
Reference | filters on the platform, writable, ::ancestor. |
The reference of the quotation. | |
salutation |
int64 |
Salutation | filters on the platform, writable, ::ancestor. |
The salutation of this quotation. | |
salutation |
varchar2 |
Salutation Text | filters on the platform, writable, ::ancestor. |
The salutation text of the quotation. | |
show |
char |
Show Overheads on PDF | filters on the platform, writable, ::ancestor. |
Whether the general costs and profit and risk should be shown on the quotation PDF. | |
show |
char |
Show Price per Line | filters on the platform, writable, ::ancestor. |
Whether the price is shown per line. | |
show |
char |
Show Subtotal per Chapter | filters on the platform, writable, ::ancestor. |
Whether the subtotal is shown per chapter. | |
show |
char |
Show Total Price | filters on the platform, writable, ::ancestor. |
Whether the total price is shown on this quotation. | |
sort |
int64 |
Sort Index | writable, sort |
The sort index of this quotation line chapter. | |
subject |
varchar2 |
Subject | filters on the platform, writable, ::ancestor. |
The subject of the quotation. | |
updated |
datetime |
Updated At | writable, updated |
The last updated time of the entity. | |
updated |
datetime |
Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable, updated |
The user that last updated the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: