newQuotationForProject_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_newquotationforproject_projectcategorydivisionsettings_plural
read only REST
- Catalog:
Bouw7 - Schema:
Quotation - Label: itgen_bouw7_newquotationforproject_projectcategorydivisionsettings_plural
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.
Can only retrieve data.
Summary
Returns the document with the project information filled in for a new quotation.
API Source
- Endpoint:
/quotation/{project}/new - Operation:
get /quotation/{project}/new
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 |
|---|---|---|---|---|
project |
`` | Project ID |
Table Columns
The columns of the table newQuotationForProject_ProjectCategoryDivisionSettings 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. | |
branch_ |
varchar2 |
Branch Code | writable, ::ancestor. |
The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_code_2 | 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 | writable, ::ancestor. |
The ID of the branch. | |
branch_ |
int64 |
itgen_bouw7_branch_id_2 | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | writable, ::ancestor. |
The name of this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_name_2 | 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. | |
city |
varchar2 |
City | writable, ::ancestor. |
The city of the project. | |
closing |
int64 |
Closing Chance | filters on the platform, writable, ::ancestor. |
The closing chance of this quotation. | |
code |
varchar2 |
Code | writable, ::ancestor. |
The code for the category. | |
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 | writable, ::ancestor. |
The email address. | |
contact_ |
varchar2 |
itgen_bouw7_contact_email_2 | filters on the platform, writable, ::ancestor. |
The email address. | |
contact_ |
int64 |
Contact ID | writable, ::ancestor. |
ID of contact. | |
contact_ |
int64 |
itgen_bouw7_contact_id_2 | filters on the platform, writable, ::ancestor. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
char |
itgen_bouw7_contact_isvatshifted_2 | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | writable, ::ancestor. |
Name of contact. | |
contact_ |
varchar2 |
itgen_bouw7_contact_name_2 | filters on the platform, writable, ::ancestor. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | writable, ::ancestor. |
The phone number of the contact. | |
contact_ |
varchar2 |
itgen_bouw7_contact_phonenumber_2 | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
itgen_bouw7_createdat_3 | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
itgen_bouw7_createdby_3 | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
datetime |
Delivery Date | writable, ::ancestor. |
Delivery date for the project. | |
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. | |
end |
datetime |
End Date | writable, ::ancestor. |
End date for the project. | |
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. | |
full |
varchar2 |
Full Project Number | writable, ::ancestor. |
The full project number including year. | |
general |
varchar2 |
General Costs or Profit | writable, ::ancestor. |
The general costs or profit for the category. | |
general |
varchar2 |
General Costs Percentage | writable, ::ancestor. |
The general costs percentage for the category. | |
gross |
varchar2 |
Gross Profit Margin | writable, ::ancestor. |
The gross profit margin for the category. | |
house |
varchar2 |
House Number | writable, ::ancestor. |
The house number for the project. | |
id |
int64 |
ID | writable, ::ancestor. |
The ID of the category. | |
id_2 |
int64 |
ID | writable, ::ancestor. |
The ID of the project. | |
id_3 |
int64 |
itgen_bouw7_id_3 | filters on the platform, writable, ::ancestor. |
The ID of the quotation. | |
information |
varchar2 |
Information | writable, ::ancestor. |
The information of the project. | |
information_ |
varchar2 |
itgen_bouw7_information_2 | 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, ::ancestor. |
The name of the category. | |
name_2 |
varchar2 |
itgen_bouw7_name_2 | writable, ::ancestor. |
The name of the project. | |
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 |
Project Number | writable, ::ancestor. |
The project number. | |
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 | writable, ::ancestor. |
The reference of the project. | |
reference_ |
varchar2 |
itgen_bouw7_reference_2 | 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. | |
start |
datetime |
Start Date | writable, ::ancestor. |
Start date for the project. | |
status_ |
char |
Status Closes Project | writable, ::ancestor. |
Whether or not this status closes a project. | |
status_ |
datetime |
Status Created at | writable, ::ancestor. |
The creation time of the entity. | |
status_ |
varchar2 |
Status Created by | writable, ::ancestor. |
The user that created the entity. | |
status_ |
int64 |
Status ID | writable, ::ancestor. |
The ID of the status. | |
status_ |
char |
Status Invoices Project | writable, ::ancestor. |
Whether or not this status invoices a project. | |
status_ |
varchar2 |
Status Name | writable, ::ancestor. |
The name of the status. | |
status_ |
char |
Status Plans Project | writable, ::ancestor. |
Whether or not this status plans a project. | |
status_ |
datetime |
Status Updated at | writable, ::ancestor. |
The last updated time of the entity. | |
status_ |
varchar2 |
Status Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
street |
varchar2 |
Street Name | writable, ::ancestor. |
The street name for the project. | |
subject |
varchar2 |
Subject | filters on the platform, writable, ::ancestor. |
The subject of the quotation. | |
updated |
datetime |
Updated At | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
Updated at | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
itgen_bouw7_updatedat_3 | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
itgen_bouw7_updatedby_3 | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
zip |
varchar2 |
ZIP Code | writable, ::ancestor. |
The zip code for the project. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: