QuotationChapterLines: Bouw7 Quotation Chapter Lines
read only
- Catalog:
Bouw7 - Schema:
Views - Label: Quotation Chapter Lines
Can only retrieve data.
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.
Table Columns
The columns of the table QuotationChapterLines 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 | The activities title of the quotation. | |
additional |
char |
Additional Work | writable | Whether the quotation line chapter has additional work. | |
branch_ |
varchar2 |
Branch Code | filters on the platform, writable | The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable | The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable | The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable | A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable | A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable | The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable | A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable | A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable | The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Branch ID | filters on the platform, writable | The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable | The name of this branch | |
calculation |
varchar2 |
Calculation Labour Day Price | filters on the platform, writable | The calculation labour day price of this quotation. | |
calculation |
varchar2 |
Calculation Total | writable | The calculation total of the quotation line. | |
closing |
int64 |
Closing Chance | filters on the platform, writable | The closing chance of this quotation. | |
commission |
varchar2 |
Commission Percentage | filters on the platform, writable | The commision percentage of this quotation. | |
conditions |
varchar2 |
Conditions | filters on the platform, writable | The conditions of this quotation. | |
contact |
varchar2 |
Contact Person Text | filters on the platform, writable | The contact person text of the quotation. | |
contact |
varchar2 |
Contact Person City | filters on the platform, writable | The contact person's city. | |
contact |
datetime |
Contact Person Created at | filters on the platform, writable | The creation time of the entity. | |
contact |
varchar2 |
Contact Person Created by | filters on the platform, writable | The user that created the entity. | |
contact |
varchar2 |
Contact Person Email | filters on the platform, writable | The contact person's email address. | |
contact |
varchar2 |
Contact Person First Name | filters on the platform, writable | The contact person's first name. | |
contact |
varchar2 |
Contact Person House Number | filters on the platform, writable | The contact person's house number. | |
contact |
int64 |
Contact Person ID | filters on the platform, writable | The ID of contact person. | |
contact |
varchar2 |
Contact Person Job Title | filters on the platform, writable | The contact person's job title. | |
contact |
varchar2 |
Contact Person Last Name | filters on the platform, writable | The contact person's last name. | |
contact |
varchar2 |
Contact Person Phone Number | filters on the platform, writable | The contact person's phone number. | |
contact |
varchar2 |
Contact Person Salutation | filters on the platform, writable | The contact person's salutation. | |
contact |
varchar2 |
Contact Person Street Name | filters on the platform, writable | The contact person's street name. | |
contact |
datetime |
Contact Person Updated at | filters on the platform, writable | The last updated time of the entity. | |
contact |
varchar2 |
Contact Person Updated by | filters on the platform, writable | The user that last updated the entity. | |
contact |
varchar2 |
Contact Person ZIP Code | filters on the platform, writable | The contact person's zip code. | |
contact_ |
int64 |
Contact Contact Type ID | filters on the platform, writable | The ID of contact type. | |
contact_ |
varchar2 |
Contact Contact Type Name | filters on the platform, writable | The name of contact type. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable | The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable | ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable | Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable | Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable | The phone number of the contact. | |
created |
datetime |
Created at | writable | The creation time of the entity. | |
created |
datetime |
Created at | writable | The creation time of the entity. | |
created |
datetime |
itgen_bouw7_createdat_3 | filters on the platform, writable | The creation time of the entity. | |
created |
varchar2 |
Created by | writable | The user that created the entity. | |
created |
varchar2 |
Created by | writable | The user that created the entity. | |
created |
varchar2 |
itgen_bouw7_createdby_3 | filters on the platform, writable | The user that created the entity. | |
description |
varchar2 |
Description | writable | The description of the quotation line. | |
description |
varchar2 |
Description Long | writable | The long description of the quotation line. | |
disable |
char |
Disable Quotation Lines | filters on the platform, writable | Whether the quotation lines are disabled. | |
discount |
int64 |
Discount | filters on the platform, writable | The discount of this quotation. | |
employee_ |
varchar2 |
Employee First Name | filters on the platform, writable | First name of the employee. | |
employee_ |
int64 |
Employee ID | filters on the platform, writable | ID of the employee. | |
employee_ |
varchar2 |
Employee Last Name | filters on the platform, writable | Last name of the employee. | |
equipment |
varchar2 |
Equipment Total | writable | The equipment total of the quotation line. | |
expected |
datetime |
Expected Closing Date | filters on the platform, writable | The expected closing date of this quotation. | |
footer |
varchar2 |
Footer | filters on the platform, writable | The footer of the quotation. | |
garbage |
varchar2 |
Garbage Total | writable | The waste total of the quotation line. | |
has |
char |
Has Price | writable | Whether the quotation line chapter has a price. | |
id |
int64 |
ID | writable | ID of the quotation line. | |
id_2 |
int64 |
ID | writable | ID of the quotation line chapter. | |
id_3 |
int64 |
itgen_bouw7_id_3 | filters on the platform, writable | The ID of the quotation. | |
information |
varchar2 |
Information | filters on the platform, writable | The information of the quotation. | |
is |
char |
Is Calculation | filters on the platform, writable | Whether the quotation is a calculation. | |
labor |
varchar2 |
Labor Quantity | writable | The labour quantity of the quotation line. | |
labor |
varchar2 |
Labor Total | writable | The labour total of the quotation line. | |
labour |
varchar2 |
Labour Day Price | filters on the platform, writable | The labour day price of this quotation. | |
labour |
varchar2 |
Labour Days | writable | The labour days of the quotation line. | |
language |
varchar2 |
Language | filters on the platform, writable | The locale used by this quotation, e.g.: nl-NL. | |
layout |
varchar2 |
Layout | filters on the platform, writable | The layout of the quotation. | |
mail |
varchar2 |
Mail Sent at | filters on the platform, writable | The date when the mail was sent. | |
material |
varchar2 |
Material Description | writable | The material description of the quotation line. | |
material |
varchar2 |
Material Quantity | writable | The material quantity of the quotation line. | |
material |
varchar2 |
Material Total | writable | The material total of the quotation line. | |
material |
varchar2 |
Material Unit Price | writable | The material per unit price of the quotation line. | |
name |
varchar2 |
Name | writable | The name of this quotation line chapter. | |
note |
varchar2 |
Note | filters on the platform, writable | The note of this quotation. | |
option |
char |
Option | writable | Whether the quotation line has an option. | |
overheads |
varchar2 |
Overheads | filters on the platform, writable | The general costs of this quotation. | |
overheads |
varchar2 |
itgen_bouw7_overheadsvattariff_effectivefrom | filters on the platform, writable | The datetime in ATOM format since this VAT tariff is effective. | |
overheads |
int64 |
Overheads VAT Tariff ID | filters on the platform, writable | ID of the vat tariff. | |
overheads |
varchar2 |
Overheads VAT tariff Label | filters on the platform, writable | Display label of the VAT tariff. | |
overheads |
varchar2 |
Overheads VAT Tariff Percentage | filters on the platform, writable | The VAT percentage. | |
price |
varchar2 |
Price | writable | The price of this quotation line. | |
profit |
varchar2 |
Profit and Risk | filters on the platform, writable | The profit and risk costs of this quotation. | |
profit |
varchar2 |
itgen_bouw7_profitandriskvattariff_effectivefrom | filters on the platform, writable | The datetime in ATOM format since this VAT tariff is effective. | |
profit |
int64 |
Profit and Risk VAT Tariff ID | filters on the platform, writable | ID of the vat tariff. | |
profit |
varchar2 |
Profit and Risk VAT Tariff Label | filters on the platform, writable | Display label of the VAT tariff. | |
profit |
varchar2 |
Profit and Risk VAT Tariff Percentage | filters on the platform, writable | The VAT percentage. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable | The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable | The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable | The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable | The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable | The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable | The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable | The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable | The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable | The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable | The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable | The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable | The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable | The user that last updated the entity. | |
project_ |
varchar2 |
Project City | filters on the platform, writable | The city of the project. | |
project_ |
varchar2 |
Project Contact Email | filters on the platform, writable | The email address. | |
project_ |
int64 |
Project Contact ID | filters on the platform, writable | ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable | Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable | Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable | The phone number of the contact. | |
project_ |
datetime |
Project Created at | filters on the platform, writable | The creation time of the entity. | |
project_ |
varchar2 |
Project Created by | filters on the platform, writable | The user that created the entity. | |
project_ |
datetime |
Project Delivery Date | filters on the platform, writable | Delivery date for the project. | |
project_ |
datetime |
Project End Date | filters on the platform, writable | End date for the project. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable | The full project number including year. | |
project_ |
varchar2 |
Project House Number | filters on the platform, writable | The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable | The ID of the project. | |
project_ |
varchar2 |
Project Information | filters on the platform, writable | The information of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable | The name of the project. | |
project_ |
varchar2 |
Project Project Number | filters on the platform, writable | The project number. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable | The reference of the project. | |
project_ |
datetime |
Project Start Date | filters on the platform, writable | Start date for the project. | |
project_ |
char |
Project Status Closes Project | filters on the platform, writable | Whether or not this status closes a project. | |
project_ |
datetime |
Project Status Created at | filters on the platform, writable | The creation time of the entity. | |
project_ |
varchar2 |
Project Status Created by | filters on the platform, writable | The user that created the entity. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable | The ID of the status. | |
project_ |
char |
Project Status Invoices Project | filters on the platform, writable | Whether or not this status invoices a project. | |
project_ |
varchar2 |
Project Status Name | filters on the platform, writable | The name of the status. | |
project_ |
char |
Project Status Plans Project | filters on the platform, writable | Whether or not this status plans a project. | |
project_ |
datetime |
Project Status Updated at | filters on the platform, writable | The last updated time of the entity. | |
project_ |
varchar2 |
Project Status Updated by | filters on the platform, writable | The user that last updated the entity. | |
project_ |
varchar2 |
Project Street Name | filters on the platform, writable | The street name for the project. | |
project_ |
datetime |
Project Updated at | filters on the platform, writable | The last updated time of the entity. | |
project_ |
varchar2 |
Project Updated by | filters on the platform, writable | The user that last updated the entity. | |
project_ |
varchar2 |
Project ZIP Code | filters on the platform, writable | The zip code for the project. | |
purchase |
varchar2 |
Purchase Order Total | writable | The purchase order total of the quotation line. | |
quantity |
varchar2 |
Quantity | writable | The quantity of this quotation line. | |
quotation |
datetime |
Quotation Date | filters on the platform, writable | The date of this quotation. | |
quotation |
varchar2 |
Quotation Number | filters on the platform, writable | The number of the quotation. | |
quotation |
int64 |
Quotation Status ID | filters on the platform, writable | ID of the quotation status. | |
quotation |
varchar2 |
Quotation Status Name | filters on the platform, writable | The name of the quotation status. | |
quotation_ |
int64 |
Branch ID | filters on the platform, writable | The ID of the branch. | |
quotation_ |
varchar2 |
Branch Name | filters on the platform, writable | The name of the branch. | |
quotation_ |
int64 |
Closing Chance | filters on the platform, writable | The closing chance of this quotation. | |
quotation_ |
varchar2 |
Commission Percentage | filters on the platform, writable | The commission percentage of this quotation. | |
quotation_ |
varchar2 |
Contact Person Text | filters on the platform, writable | The contact person text of the quotation. | |
quotation_ |
varchar2 |
Contact Person Email Address | filters on the platform, writable | The email address of the contact person. | |
quotation_ |
varchar2 |
Contact Person First Name | filters on the platform, writable | The first name of this contact person. | |
quotation_ |
int64 |
Contact Person ID | filters on the platform, writable | The ID of the contact person. | |
quotation_ |
varchar2 |
Contact Person Last Name | filters on the platform, writable | The surname of the contact person. | |
quotation_ |
varchar2 |
Contact Person Phone Number | filters on the platform, writable | The phone number of the contact person. | |
quotation_ |
varchar2 |
Contact Email Address | filters on the platform, writable | The email address of the contact. | |
quotation_ |
int64 |
Contact ID | filters on the platform, writable | The ID of the contact. | |
quotation_ |
varchar2 |
Contact Name | filters on the platform, writable | The name of this contact. | |
quotation_ |
varchar2 |
Contact Type | filters on the platform, writable | The type of this contact. | |
quotation_ |
int64 |
Contact Type ID | filters on the platform, writable | The type ID of this contact. | |
quotation_ |
datetime |
Created at | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format | |
quotation_ |
int64 |
Created by ID | filters on the platform, writable | The ID of the user. | |
quotation_ |
varchar2 |
Created by User Name | filters on the platform, writable | The username of the user. | |
quotation_ |
int64 |
Employee Department ID | filters on the platform, writable | The ID of the department this employee is enrolled in. | |
quotation_ |
int64 |
Employee Exact Salary Frequency | filters on the platform, writable | The exact salary frequency of this employee. | |
quotation_ |
varchar2 |
Employee First Name | filters on the platform, writable | The given name of this employee. | |
quotation_ |
int64 |
Employee ID | filters on the platform, writable | The ID of the employee. | |
quotation_ |
varchar2 |
Employee Last Name | filters on the platform, writable | The family name of this employee. | |
quotation_ |
datetime |
Expected Closing Date | filters on the platform, writable | The expected closing date of this quotation, represented in ATOM-format. | |
quotation_ |
int64 |
ID | filters on the platform, writable | The ID of the quotation. | |
quotation_ |
varchar2 |
Internal Note | filters on the platform, writable | The internal note for this quotation. | |
quotation_ |
varchar2 |
Language | filters on the platform, writable | The locale used by this quotation, e.g.: nl-NL. | |
quotation_ |
int64 |
Project Branch ID | filters on the platform, writable | The ID of the branch of this project. | |
quotation_ |
int64 |
Project Category ID | filters on the platform, writable | The ID of the category of this project. | |
quotation_ |
int64 |
Project Division ID | filters on the platform, writable | The ID of the division of this project. | |
quotation_ |
int64 |
Project ID | filters on the platform, writable | The ID of the project. | |
quotation_ |
varchar2 |
Project Name | filters on the platform, writable | The name of the project. | |
quotation_ |
varchar2 |
Project Number | filters on the platform, writable | The number of the project. | |
quotation_ |
varchar2 |
Project Status | filters on the platform, writable | The name of the current status of this project. | |
quotation_ |
int64 |
Project Status ID | filters on the platform, writable | The ID of the status of this project. | |
quotation_ |
datetime |
Quotation Date | filters on the platform, writable | The date of the quotation, represented in ATOM-format. | |
quotation_ |
varchar2 |
Quotation Number | filters on the platform, writable | The number of the quotation. | |
quotation_ |
int64 |
Quotation Status ID | filters on the platform, writable | The ID of the quotation status. | |
quotation_ |
varchar2 |
Quotation Status Name | filters on the platform, writable | The name of the quotation status. | |
quotation_ |
varchar2 |
Reference | filters on the platform, writable | The reference of the quotation. | |
quotation_ |
int64 |
Salutation | filters on the platform, writable | The salutation of this quotation. | |
quotation_ |
varchar2 |
Salutation Text | filters on the platform, writable | The salutation text of the quotation. | |
quotation_ |
varchar2 |
Subject | filters on the platform, writable | The subject of the quotation. | |
quotation_ |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable | The sum of all quotation line subtotals, excluding VAT. | |
quotation_ |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable | The sum of all quotation line subtotals, including VAT. | |
quotation_ |
datetime |
Updated At | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format | |
quotation_ |
int64 |
Updated by ID | filters on the platform, writable | The ID of the user. | |
quotation_ |
varchar2 |
Updated by User Name | filters on the platform, writable | The username of the user. | |
reference |
varchar2 |
Reference | filters on the platform, writable | The reference of the quotation. | |
salutation |
int64 |
Salutation | filters on the platform, writable | The salutation of this quotation. | |
salutation |
varchar2 |
Salutation Text | filters on the platform, writable | The salutation text of the quotation. | |
should |
char |
Should add Page Break | writable | Whether the quotation line should add a page break to the PDF. | |
show |
char |
Show Overheads on PDF | filters on the platform, writable | 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 | Whether the price is shown per line. | |
show |
char |
Show Subtotal per Chapter | filters on the platform, writable | Whether the subtotal is shown per chapter. | |
show |
char |
Show Total Price | filters on the platform, writable | Whether the total price is shown on this quotation. | |
sort |
int64 |
Sort Index | writable | The sort index of the quotation line. | |
sort |
int64 |
itgen_bouw7_sortindex_2 | writable | The sort index of this quotation line chapter. | |
subcontracting |
varchar2 |
Sub Contracting Total | writable | The subcontracting total of the quotation line. | |
subject |
varchar2 |
Subject | filters on the platform, writable | The subject of the quotation. | |
subtotal |
varchar2 |
Subtotal | writable | The price of this quotation line. | |
unit |
varchar2 |
Unit | writable | The unit of the quotation line. | |
updated |
datetime |
Updated At | writable | The last updated time of the entity. | |
updated |
datetime |
Updated at | writable | The last updated time of the entity. | |
updated |
datetime |
itgen_bouw7_updatedat_3 | filters on the platform, writable | The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable | The user that last updated the entity. | |
updated |
varchar2 |
Updated by | writable | The user that last updated the entity. | |
updated |
varchar2 |
itgen_bouw7_updatedby_3 | filters on the platform, writable | The user that last updated the entity. | |
vat |
varchar2 |
VAT Tariff Percentage | writable | The vat tariff of this quotation line. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: