invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id int64 Branch ID filters on the platform, writable, branch.id The ID of the branch.
branch_name varchar2 Branch Name filters on the platform, writable, branch.name The name of the branch.
closingChance int64 Closing Chance filters on the platform, writable, closingChance The closing chance of this quotation.
commissionPercentage varchar2 Commission Percentage filters on the platform, writable, commissionPercentage The commission percentage of this quotation.
contactPersonText varchar2(255) Contact Person Text filters on the platform, writable, contactPersonText The contact person text of the quotation.
contactPerson_emailAddress varchar2 Contact Person Email Address filters on the platform, writable, contactPerson.emailAddress The email address of the contact person.
contactPerson_firstName varchar2 Contact Person First Name filters on the platform, writable, contactPerson.firstName The first name of this contact person.
contactPerson_id int64 Contact Person ID filters on the platform, writable, contactPerson.id The ID of the contact person.
contactPerson_lastName varchar2(256) Contact Person Last Name filters on the platform, writable, contactPerson.lastName The surname of the contact person.
contactPerson_phoneNumber varchar2(255) Contact Person Phone Number filters on the platform, writable, contactPerson.phoneNumber The phone number of the contact person.
contact_emailAddress varchar2 Contact Email Address filters on the platform, writable, contact.emailAddress The email address of the contact.
contact_id int64 Contact ID filters on the platform, writable, contact.id The ID of the contact.
contact_name varchar2 Contact Name filters on the platform, writable, contact.name The name of this contact.
contact_type varchar2 Contact Type filters on the platform, writable, contact.type The type of this contact.
contact_typeId int64 Contact Type ID filters on the platform, writable, contact.typeId The type ID of this contact.
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username The username of the user.
employee_departmentId int64 Employee Department ID filters on the platform, writable, employee.departmentId The ID of the department this employee is enrolled in.
employee_exactSalaryFrequency int64 Employee Exact Salary Frequency filters on the platform, writable, employee.exactSalaryFrequency The exact salary frequency of this employee.
employee_firstName varchar2 Employee First Name filters on the platform, writable, employee.firstName The given name of this employee.
employee_id int64 Employee ID filters on the platform, writable, employee.id The ID of the employee.
employee_lastName varchar2 Employee Last Name filters on the platform, writable, employee.lastName The family name of this employee.
expectedClosingDate datetime Expected Closing Date filters on the platform, writable, expectedClosingDate 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.
internalNote varchar2 Internal Note filters on the platform, writable, internalNote 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_branchId int64 Project Branch ID filters on the platform, writable, project.branchId The ID of the branch of this project.
project_categoryId int64 Project Category ID filters on the platform, writable, project.categoryId The ID of the category of this project.
project_divisionId int64 Project Division ID filters on the platform, writable, project.divisionId The ID of the division of this project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project.
project_number varchar2 Project Number filters on the platform, writable, project.number The number of the project.
project_status varchar2 Project Status filters on the platform, writable, project.status The name of the current status of this project.
project_statusId int64 Project Status ID filters on the platform, writable, project.statusId The ID of the status of this project.
quotationDate datetime Quotation Date filters on the platform, writable, quotationDate The date of the quotation, represented in ATOM-format.
quotationNumber varchar2 Quotation Number filters on the platform, writable, quotationNumber The number of the quotation.
quotationStatus_id int64 Quotation Status ID filters on the platform, writable, quotationStatus.id The ID of the quotation status.
quotationStatus_name varchar2 Quotation Status Name filters on the platform, writable, quotationStatus.name 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.
salutationText varchar2(255) Salutation Text filters on the platform, writable, salutationText 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.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: