Quotations: Bouw7 Quotations
popular read only REST
- Catalog:
Bouw7 - Schema:
Quotation - Label: Quotations
Returns a list of quotations associated with your organization. Returns a list of quotations associated with your organization.
Can only retrieve data.
Summary
Returns a list of quotations associated with your organization.
API Source
- Endpoint:
/list/quotations - Operation:
get /list/quotations
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 66 |
| Full scan rows per minute | 215,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string |
Table Columns
The columns of the table Quotations 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 |
|---|---|---|---|---|---|
branch_ |
int64 |
Branch ID | filters on the platform, writable, branch. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, branch. |
The name of the branch. | |
closing |
int64 |
Closing Chance | filters on the platform, writable, closing |
The closing chance of this quotation. | |
commission |
varchar2 |
Commission Percentage | filters on the platform, writable, commission |
The commission percentage of this quotation. | |
contact |
varchar2 |
Contact Person Text | filters on the platform, writable, contact |
The contact person text of the quotation. | |
contact |
varchar2 |
Contact Person Email Address | filters on the platform, writable, contact |
The email address of the contact person. | |
contact |
varchar2 |
Contact Person First Name | filters on the platform, writable, contact |
The first name of this contact person. | |
contact |
int64 |
Contact Person ID | filters on the platform, writable, contact |
The ID of the contact person. | |
contact |
varchar2 |
Contact Person Last Name | filters on the platform, writable, contact |
The surname of the contact person. | |
contact |
varchar2 |
Contact Person Phone Number | filters on the platform, writable, contact |
The phone number of the contact person. | |
contact_ |
varchar2 |
Contact Email Address | filters on the platform, writable, contact. |
The email address of the contact. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, contact. |
The ID of the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, contact. |
The name of this contact. | |
contact_ |
varchar2 |
Contact Type | filters on the platform, writable, contact. |
The type of this contact. | |
contact_ |
int64 |
Contact Type ID | filters on the platform, writable, contact. |
The type ID of this contact. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
employee_ |
int64 |
Employee Department ID | filters on the platform, writable, employee. |
The ID of the department this employee is enrolled in. | |
employee_ |
int64 |
Employee Exact Salary Frequency | filters on the platform, writable, employee. |
The exact salary frequency of this employee. | |
employee_ |
varchar2 |
Employee First Name | filters on the platform, writable, employee. |
The given name of this employee. | |
employee_ |
int64 |
Employee ID | filters on the platform, writable, employee. |
The ID of the employee. | |
employee_ |
varchar2 |
Employee Last Name | filters on the platform, writable, employee. |
The family name of this employee. | |
expected |
datetime |
Expected Closing Date | filters on the platform, writable, expected |
The expected closing date of this quotation, represented in ATOM-format. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the quotation. | |
internal |
varchar2 |
Internal Note | filters on the platform, writable, internal |
The internal note for this quotation. | |
language |
varchar2 |
Language | filters on the platform, writable, language |
The locale used by this quotation, e.g.: nl-NL. | |
project_ |
int64 |
Project Branch ID | filters on the platform, writable, project. |
The ID of the branch of this project. | |
project_ |
int64 |
Project Category ID | filters on the platform, writable, project. |
The ID of the category of this project. | |
project_ |
int64 |
Project Division ID | filters on the platform, writable, project. |
The ID of the division of this project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Number | filters on the platform, writable, project. |
The number of the project. | |
project_ |
varchar2 |
Project Status | filters on the platform, writable, project. |
The name of the current status of this project. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status of this project. | |
quotation |
datetime |
Quotation Date | filters on the platform, writable, quotation |
The date of the quotation, represented in ATOM-format. | |
quotation |
varchar2 |
Quotation Number | filters on the platform, writable, quotation |
The number of the quotation. | |
quotation |
int64 |
Quotation Status ID | filters on the platform, writable, quotation |
The ID of the quotation status. | |
quotation |
varchar2 |
Quotation Status Name | 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 |
Salutation Text | filters on the platform, writable, salutation |
The salutation text of the quotation. | |
subject |
varchar2 |
Subject | filters on the platform, writable, subject |
The subject of the quotation. | |
subtotal |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable, subtotal |
The sum of all quotation line subtotals, excluding VAT. | |
total |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable, total |
The sum of all quotation line subtotals, including VAT. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: