bow_quotation.postquotation: Bouw7 Package for quotation operations that could not be mapped to a table.

id

int64

☐

The ID of the quotation.

id_2

int64

☐

ID of the employee.

firstName

string

☐

First name of the employee.

lastName

string

☐

Last name of the employee.

subject

string

☑

The subject of the quotation.

reference

string

☐

The reference of the quotation.

information

string

☐

The information of the quotation.

footer

string

☐

The footer of the quotation.

id_3

int64

☐

ID of the quotation status.

name

string

☐

The name of the quotation status.

quotationNumber

string

☐

The number of the quotation.

id_4

int64

☐

ID of contact.

name_2

string

☐

Name of contact.

email

string

☐

The email address.

phoneNumber

string

☐

The phone number of the contact.

isVatShifted

boolean

☐

Whether VAT is shifted for the contact.

contactType_id

int64

☐

The ID of contact type.

contactType_name

string

☐

The name of contact type.

id_5

int64

☐

The ID of contact person.

firstName_2

string

☐

The contact person's first name.

lastName_2

string

☐

The contact person's last name.

email_2

string

☐

The contact person's email address.

phoneNumber_2

string

☐

The contact person's phone number.

streetName

string

☐

The contact person's street name.

houseNumber

string

☐

The contact person's house number.

zipCode

string

☐

The contact person's zip code.

city

string

☐

The contact person's city.

jobTitle

string

☐

The contact person's job title.

salutation

string

☐

The contact person's salutation.

createdAt

datetime

☐

The creation time of the entity.

createdBy

string

☐

The user that created the entity.

updatedAt

datetime

☐

The last updated time of the entity.

updatedBy

string

☐

The user that last updated the entity.

contactPersonText

string

☐

The contact person text of the quotation.

salutation1

int64

☐

The salutation of this quotation.

salutationText

string

☐

The salutation text of the quotation.

quotationDate

datetime

☑

The date of this quotation.

expectedClosingDate

datetime

☐

The expected closing date of this quotation.

language

string

☑

The locale used by this quotation, e.g.: nl-NL.

note

string

☐

The note of this quotation.

mailSentAt

string

☐

The date when the mail was sent.

id_6

int64

☐

The ID of the project.

projectNumber

string

☐

The project number.

fullProjectNumber

string

☐

The full project number including year.

name_3

string

☐

The name of the project.

streetName_2

string

☐

The street name for the project.

houseNumber_2

string

☐

The house number for the project.

zipCode_2

string

☐

The zip code for the project.

city_2

string

☐

The city of the project.

information_2

string

☐

The information of the project.

reference_2

string

☐

The reference of the project.

startDate

datetime

☐

Start date for the project.

endDate

datetime

☐

End date for the project.

deliveryDate

datetime

☐

Delivery date for the project.

contact_id

int64

☐

ID of contact.

contact_name

string

☐

Name of contact.

contact_email

string

☐

The email address.

contact_phoneNumber

string

☐

The phone number of the contact.

contact_isVatShifted

boolean

☐

Whether VAT is shifted for the contact.

contact_contactType_id

int64

☐

The ID of contact type.

contact_contactType_name

string

☐

The name of contact type.

category_id

int64

☐

The ID of the category.

category_name

string

☐

The name of the category.

category_code

string

☐

The code for the category.

category_generalCostsPercentage

string

☐

The general costs percentage for the category.

category_generalCostsOrProfit

string

☐

The general costs or profit for the category.

category_grossProfitMargin

string

☐

The gross profit margin for the category.

category_createdAt

datetime

☐

The creation time of the entity.

category_createdBy

string

☐

The user that created the entity.

category_updatedAt

datetime

☐

The last updated time of the entity.

category_updatedBy

string

☐

The user that last updated the entity.

status_id

int64

☐

The ID of the status.

status_name

string

☐

The name of the status.

status_closesProject

boolean

☐

Whether or not this status closes a project.

status_invoicesProject

boolean

☐

Whether or not this status invoices a project.

status_plansProject

boolean

☐

Whether or not this status plans a project.

status_createdAt

datetime

☐

The creation time of the entity.

status_createdBy

string

☐

The user that created the entity.

status_updatedAt

datetime

☐

The last updated time of the entity.

status_updatedBy

string

☐

The user that last updated the entity.

branch_id

int64

☐

The ID of the branch.

branch_name

string

☐

The name of this branch

branch_code

string

☐

The code for this branch

branch_division_id

int64

☐

The ID of the division.

branch_division_description

string

☐

The description of the division.

branch_division_exactDivisionId

string

☐

The division ID of an Exact Online environment.

branch_division_glAccountCode

string

☐

A default general ledger account code to use for sales related items.

branch_division_glAccountCodePurchase

string

☐

A default general ledger account code to use for purchase related items.

branch_division_journalCode

string

☐

A default journal code to use for sales related items.

branch_division_journalCodePurchase

string

☐

A default journal code to use for purchase related items.

branch_division_salesInvoiceNumberPrefix

string

☐

The prefix (3 digits) used to generate invoice number range per division.

createdAt_2

datetime

☐

The creation time of the entity.

createdBy_2

string

☐

The user that created the entity.

updatedAt_2

datetime

☐

The last updated time of the entity.

updatedBy_2

string

☐

The user that last updated the entity.

id_7

int64

☐

The ID of the branch.

name_4

string

☐

The name of this branch

code

string

☐

The code for this branch

division_id

int64

☐

The ID of the division.

division_description

string

☐

The description of the division.

division_exactDivisionId

string

☐

The division ID of an Exact Online environment.

division_glAccountCode

string

☐

A default general ledger account code to use for sales related items.

division_glAccountCodePurchase

string

☐

A default general ledger account code to use for purchase related items.

division_journalCode

string

☐

A default journal code to use for sales related items.

division_journalCodePurchase

string

☐

A default journal code to use for purchase related items.

division_salesInvoiceNumberPrefix

string

☐

The prefix (3 digits) used to generate invoice number range per division.

disableQuotationLines

boolean

☐

Whether the quotation lines are disabled.

conditions

string

☐

The conditions of this quotation.

layout

string

☑

The layout of the quotation.

showPricePerLine

boolean

☐

Whether the price is shown per line.

showSubtotalPerChapter

boolean

☐

Whether the subtotal is shown per chapter.

showTotalPrice

boolean

☐

Whether the total price is shown on this quotation.

labourDayPrice

string

☐

The labour day price of this quotation.

calculationLabourDayPrice

string

☐

The calculation labour day price of this quotation.

discount

int64

☐

The discount of this quotation.

overheads

string

☐

The general costs of this quotation.

id_8

int64

☐

ID of the vat tariff.

label

string

☐

Display label of the VAT tariff.

percentage

string

☐

The VAT percentage.

effectiveFrom

string

☐

The datetime in ATOM format since this VAT tariff is effective.

profitAndRisk

string

☐

The profit and risk costs of this quotation.

id_9

int64

☐

ID of the vat tariff.

label_2

string

☐

Display label of the VAT tariff.

percentage_2

string

☐

The VAT percentage.

effectiveFrom_2

string

☐

The datetime in ATOM format since this VAT tariff is effective.

showOverheadsOnPdf

boolean

☐

Whether the general costs and profit and risk should be shown on the quotation PDF.

closingChance

int64

☐

The closing chance of this quotation.

commissionPercentage

string

☐

The commision percentage of this quotation.

isCalculation

boolean

☐

Whether the quotation is a calculation.

activitiesTitle

string

☐

The activities title of the quotation.

createdAt1

datetime

☐

The creation time of the entity.

createdBy1

string

☐

The user that created the entity.

updatedAt1

datetime

☐

The last updated time of the entity.

updatedBy1

string

☐

The user that last updated the entity.