invantive documentation
Forum di supporto InvantiveAccedi / Registrati

newQuotationForProject_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_newquotationforproject_projectcategorydivisionsettings_plural

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

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
activitiesTitle varchar2(255) Activities Title filters on the platform, writable, ::ancestor.::ancestor.::ancestor.activitiesTitle The activities title of the quotation.
branch_code varchar2 Branch Code writable, ::ancestor.::ancestor.branch.code The code for this branch
branch_code_2 varchar2 itgen_bouw7_branch_code_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.code The code for this branch
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.exactDivisionId The division ID of an Exact Online environment.
branch_division_glAccountCode varchar2 itgen_bouw7_branch_division_glaccountcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.glAccountCode A default general ledger account code to use for sales related items.
branch_division_glAccountCodePurchase varchar2 itgen_bouw7_branch_division_glaccountcodepurchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
branch_division_id int64 itgen_bouw7_branch_division_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.journalCode A default journal code to use for sales related items.
branch_division_journalCodePurchase varchar2 itgen_bouw7_branch_division_journalcodepurchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.journalCodePurchase A default journal code to use for purchase related items.
branch_division_salesInvoiceNumberPrefix varchar2(3) itgen_bouw7_branch_division_salesinvoicenumberprefix filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
branch_id int64 Branch ID writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_id_2 int64 itgen_bouw7_branch_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.id The ID of the branch.
branch_name varchar2 Branch Name writable, ::ancestor.::ancestor.branch.name The name of this branch
branch_name_2 varchar2 itgen_bouw7_branch_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.name The name of this branch
calculationLabourDayPrice varchar2 Calculation Labour Day Price filters on the platform, writable, ::ancestor.::ancestor.::ancestor.calculationLabourDayPrice The calculation labour day price of this quotation.
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
closingChance int64 Closing Chance filters on the platform, writable, ::ancestor.::ancestor.::ancestor.closingChance The closing chance of this quotation.
code varchar2 Code writable, ::ancestor.code The code for the category.
commissionPercentage varchar2 Commission Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.commissionPercentage The commision percentage of this quotation.
conditions varchar2 Conditions filters on the platform, writable, ::ancestor.::ancestor.::ancestor.conditions The conditions of this quotation.
contactPersonText varchar2(255) Contact Person Text filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPersonText The contact person text of the quotation.
contactPerson_city varchar2(255) Contact Person City filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.city The contact person's city.
contactPerson_createdAt datetime Contact Person Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.createdAt The creation time of the entity.
contactPerson_createdBy varchar2 Contact Person Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.createdBy The user that created the entity.
contactPerson_email varchar2(256) Contact Person Email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.email The contact person's email address.
contactPerson_firstName varchar2(256) Contact Person First Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.firstName The contact person's first name.
contactPerson_houseNumber varchar2(50) Contact Person House Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.houseNumber The contact person's house number.
contactPerson_id int64 Contact Person ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.id The ID of contact person.
contactPerson_jobTitle varchar2(64) Contact Person Job Title filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.jobTitle The contact person's job title.
contactPerson_lastName varchar2(256) Contact Person Last Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.lastName The contact person's last name.
contactPerson_phoneNumber varchar2(255) Contact Person Phone Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.phoneNumber The contact person's phone number.
contactPerson_salutation varchar2(32) Contact Person Salutation filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.salutation The contact person's salutation.
contactPerson_streetName varchar2(255) Contact Person Street Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.streetName The contact person's street name.
contactPerson_updatedAt datetime Contact Person Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.updatedAt The last updated time of the entity.
contactPerson_updatedBy varchar2 Contact Person Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.updatedBy The user that last updated the entity.
contactPerson_zipCode varchar2(20) Contact Person ZIP Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.zipCode The contact person's zip code.
contact_contactType_id int64 Contact Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.name The name of contact type.
contact_email varchar2 Contact Email writable, ::ancestor.::ancestor.contact.email The email address.
contact_email_2 varchar2 itgen_bouw7_contact_email_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.email The email address.
contact_id int64 Contact ID writable, ::ancestor.::ancestor.contact.id ID of contact.
contact_id_2 int64 itgen_bouw7_contact_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted writable, ::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_isVatShifted_2 char itgen_bouw7_contact_isvatshifted_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name writable, ::ancestor.::ancestor.contact.name Name of contact.
contact_name_2 varchar2 itgen_bouw7_contact_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number writable, ::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
contact_phoneNumber_2 varchar2 itgen_bouw7_contact_phonenumber_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_3 datetime itgen_bouw7_createdat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_3 varchar2 itgen_bouw7_createdby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
disableQuotationLines char Disable Quotation Lines filters on the platform, writable, ::ancestor.::ancestor.::ancestor.disableQuotationLines Whether the quotation lines are disabled.
discount int64 Discount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.discount The discount of this quotation.
employee_firstName varchar2 Employee First Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.employee.firstName First name of the employee.
employee_id int64 Employee ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.employee.id ID of the employee.
employee_lastName varchar2 Employee Last Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.employee.lastName Last name of the employee.
endDate datetime End Date writable, ::ancestor.::ancestor.endDate End date for the project.
expectedClosingDate datetime Expected Closing Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.expectedClosingDate The expected closing date of this quotation.
footer varchar2 Footer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.footer The footer of the quotation.
fullProjectNumber varchar2 Full Project Number writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
generalCostsOrProfit varchar2 General Costs or Profit writable, ::ancestor.generalCostsOrProfit The general costs or profit for the category.
generalCostsPercentage varchar2 General Costs Percentage writable, ::ancestor.generalCostsPercentage The general costs percentage for the category.
grossProfitMargin varchar2 Gross Profit Margin writable, ::ancestor.grossProfitMargin The gross profit margin for the category.
houseNumber varchar2 House Number writable, ::ancestor.::ancestor.houseNumber The house number for the project.
id int64 ID writable, ::ancestor.id The ID of the category.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of the quotation.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
information_2 varchar2 itgen_bouw7_information_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.information The information of the quotation.
isCalculation char Is Calculation filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isCalculation Whether the quotation is a calculation.
labourDayPrice varchar2 Labour Day Price filters on the platform, writable, ::ancestor.::ancestor.::ancestor.labourDayPrice The labour day price of this quotation.
language varchar2 Language filters on the platform, writable, ::ancestor.::ancestor.::ancestor.language The locale used by this quotation, e.g.: nl-NL.
layout varchar2 Layout filters on the platform, writable, ::ancestor.::ancestor.::ancestor.layout The layout of the quotation.
mailSentAt varchar2 Mail Sent at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mailSentAt The date when the mail was sent.
name varchar2 Name writable, ::ancestor.name The name of the category.
name_2 varchar2 itgen_bouw7_name_2 writable, ::ancestor.::ancestor.name The name of the project.
note varchar2 Note filters on the platform, writable, ::ancestor.::ancestor.::ancestor.note The note of this quotation.
overheads varchar2 Overheads filters on the platform, writable, ::ancestor.::ancestor.::ancestor.overheads The general costs of this quotation.
overheadsVatTariff_effectiveFrom varchar2 itgen_bouw7_overheadsvattariff_effectivefrom filters on the platform, writable, ::ancestor.::ancestor.::ancestor.overheadsVatTariff.effectiveFrom The datetime in ATOM format since this VAT tariff is effective.
overheadsVatTariff_id int64 Overheads VAT Tariff ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.overheadsVatTariff.id ID of the vat tariff.
overheadsVatTariff_label varchar2 Overheads VAT tariff Label filters on the platform, writable, ::ancestor.::ancestor.::ancestor.overheadsVatTariff.label Display label of the VAT tariff.
overheadsVatTariff_percentage varchar2 Overheads VAT Tariff Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.overheadsVatTariff.percentage The VAT percentage.
profitAndRisk varchar2 Profit and Risk filters on the platform, writable, ::ancestor.::ancestor.::ancestor.profitAndRisk The profit and risk costs of this quotation.
profitAndRiskVatTariff_effectiveFrom varchar2 itgen_bouw7_profitandriskvattariff_effectivefrom filters on the platform, writable, ::ancestor.::ancestor.::ancestor.profitAndRiskVatTariff.effectiveFrom The datetime in ATOM format since this VAT tariff is effective.
profitAndRiskVatTariff_id int64 Profit and Risk VAT Tariff ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.profitAndRiskVatTariff.id ID of the vat tariff.
profitAndRiskVatTariff_label varchar2 Profit and Risk VAT Tariff Label filters on the platform, writable, ::ancestor.::ancestor.::ancestor.profitAndRiskVatTariff.label Display label of the VAT tariff.
profitAndRiskVatTariff_percentage varchar2 Profit and Risk VAT Tariff Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.profitAndRiskVatTariff.percentage The VAT percentage.
projectNumber varchar2 Project Number writable, ::ancestor.::ancestor.projectNumber The project number.
quotationDate datetime Quotation Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.quotationDate The date of this quotation.
quotationNumber varchar2 Quotation Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.quotationNumber The number of the quotation.
quotationStatus_id int64 Quotation Status ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.quotationStatus.id ID of the quotation status.
quotationStatus_name varchar2 Quotation Status Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.quotationStatus.name The name of the quotation status.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
reference_2 varchar2(255) itgen_bouw7_reference_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.reference The reference of the quotation.
salutation int64 Salutation filters on the platform, writable, ::ancestor.::ancestor.::ancestor.salutation The salutation of this quotation.
salutationText varchar2(255) Salutation Text filters on the platform, writable, ::ancestor.::ancestor.::ancestor.salutationText The salutation text of the quotation.
showOverheadsOnPdf char Show Overheads on PDF filters on the platform, writable, ::ancestor.::ancestor.::ancestor.showOverheadsOnPdf Whether the general costs and profit and risk should be shown on the quotation PDF.
showPricePerLine char Show Price per Line filters on the platform, writable, ::ancestor.::ancestor.::ancestor.showPricePerLine Whether the price is shown per line.
showSubtotalPerChapter char Show Subtotal per Chapter filters on the platform, writable, ::ancestor.::ancestor.::ancestor.showSubtotalPerChapter Whether the subtotal is shown per chapter.
showTotalPrice char Show Total Price filters on the platform, writable, ::ancestor.::ancestor.::ancestor.showTotalPrice Whether the total price is shown on this quotation.
startDate datetime Start Date writable, ::ancestor.::ancestor.startDate Start date for the project.
status_closesProject char Status Closes Project writable, ::ancestor.::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Status Created at writable, ::ancestor.::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Status Created by writable, ::ancestor.::ancestor.status.createdBy The user that created the entity.
status_id int64 Status ID writable, ::ancestor.::ancestor.status.id The ID of the status.
status_invoicesProject char Status Invoices Project writable, ::ancestor.::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Status Name writable, ::ancestor.::ancestor.status.name The name of the status.
status_plansProject char Status Plans Project writable, ::ancestor.::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Status Updated at writable, ::ancestor.::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Status Updated by writable, ::ancestor.::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Street Name writable, ::ancestor.::ancestor.streetName The street name for the project.
subject varchar2(255) Subject filters on the platform, writable, ::ancestor.::ancestor.::ancestor.subject The subject of the quotation.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_3 datetime itgen_bouw7_updatedat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_3 varchar2 itgen_bouw7_updatedby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
zipCode varchar2 ZIP Code writable, ::ancestor.::ancestor.zipCode The zip code for the project.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: