QuotationsBulk: Exact Online Offertes

AmountDC

double

Bedrag Administratie Munteenheid

☑

Amount in the default currency of the company.

AmountDiscount

double

Kortingsbedrag

☐

AmountDiscountExclVat

double

Kortingsbedrag exclusief BTW

☐

AmountFC

double

Bedrag Vreemde Valuta

☑

Amount in the currency of the transaction.

CloseDate

datetime

Datum Gesloten

☐

Date on which the customer accepted or rejected the quotation version.

ClosingDate

datetime

Afsluitdatum

☐

Date on which you expect to close/win the deal.

Created

datetime

Gemaakt

☑

Date and time on which the quotation was created.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of the creator.

CreatorFullName

string

Aanmaker Volledige Naam

☐

Name of the creator.

Currency

string

Valuta

☐

The currency of the quotation.

DeliveryAccount

guid

Levering Account

☐

The account where the items should delivered.

DeliveryAccountCode

string

Afleverrelatie Code

☐

The code of the delivery account.

DeliveryAccountContact

guid

Afleverrelatie Contactpersoon

☐

The contact person of the delivery account.

DeliveryAccountContactFullName

string

Afleverrelatie Contactpersoon Volledige Naam

☐

Full name of the delivery account contact person.

DeliveryAccountName

string

Afleverrelatie Naam

☐

The name of the delivery account.

DeliveryAddress

guid

Afleveradres

☐

The id of the delivery address.

DeliveryDate

datetime

Leveringsdatum

☐

Description

string

Omschrijving

☐

The description of the quotation.

Division

int32

Divisie ID

☑

Unique number of the Exact Online division.

DivisionCompanyCoCNumber

string(60)

Divisie Kamer van Koophandel Nummer

☐

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Divisie IBAN Nummer

☐

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Divisie Bedrijfsnaam

☑

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Divisie RSIN Nummer

☐

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Divisie BTW Nummer

☐

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Divisie Loonbelastingnummer

☐

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Divisie Label

☑

Label of the Exact Online division.

DivisionName

string(50)

Administratie Naam

☑

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Naam Abonnementhouder

☑

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Abonnementhoudernummer

☑

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Divisie Korte Naam

☑

Short name of the Exact Online division.

Document

guid

Document

☐

Document linked to the quotation.

DocumentSubject

string

Document Onderwerp

☐

The subject of the document.

DueDate

datetime

Vervaldag

☐

Date after which the quotation is no longer valid.

IncotermAddress

string

Incoterm-adres

☐

IncotermCode

string

Incoterm-code

☐

IncotermVersion

int16

Incoterm-versie

☐

InvoiceAccount

guid

Factuurrekening

☐

The account to which the invoice is sent.

InvoiceAccountCode

string

Factuur Account Code

☐

The code of the invoice account.

InvoiceAccountContact

guid

Factuurrelatie Contactpersoon

☐

The contact person of the invoice account.

InvoiceAccountContactFullName

string

Factuuraccount Volledige Naam Contactpersoon

☐

Full name of the invoice account contact person.

InvoiceAccountName

string

Factuur Accountnaam

☐

The name of the invoice account.

Modified

datetime

Gewijzigd

☑

Date and time on which the quotation was last modified.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of the modifier.

ModifierFullName

string

Gewijzigd Volledige Naam

☐

Name of the modifier.

Opportunity

guid

Verkoopkans

☐

Opportunity linked to the quotation.

OpportunityName

string

Verkoopkans Naam

☐

The name of the opportunity.

OrderAccount

guid

Verkooporder Klant

☐

The account that requested the quotation.

OrderAccountCode

string

Bestelklant Code

☐

The code of the order account.

OrderAccountContact

guid

Verkooporder Relatiecontactpersoon

☐

The contact person of the order account.

OrderAccountContactFullName

string

{res:itgen_eol_orderaccountcontactfullname}

☐

Full name of the order account contact person.

OrderAccountName

string

Bestelling Relatienaam

☐

The name of the order account.

PaymentCondition

string

Betalingsvoorwaarde

☐

PaymentConditionDescription

string

Betalingsconditie Omschrijving

☐

Project

guid

Project

☐

The project linked to the quotation.

ProjectCode

string

Projectcode

☐

The code of the project.

ProjectDescription

string

Projectomschrijving

☐

The description of the project.

QuotationDate

datetime

Offertedatum

☐

Date on which the quotation version is entered or printed. Both during entering and printing this date can be adjusted.

QuotationID

guid

Offerte ID

☑

Identifier of the quotation.

QuotationNumber

int32

Offertenummer

☑

Unique number to indentify the quotation. By default this number is based on the setting for first available number.

Remarks

string

Aantekeningen

☐

Extra text that can be added to the quotation.

SalesChannel

guid

Verkoopkanaal

☐

SalesChannelCode

string

Verkoopkanaalcode

☐

SalesChannelDescription

string

Verkoopkanaalomschrijving

☐

SalesPerson

guid

Verkoper

☐

The user that is responsible for the quotation version.

SalesPersonFullName

string

Verkoper Volledige Naam

☐

Full name of the sales person.

SelectionCode

guid

Selectiecode

☐

ID of selection code. Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing.

SelectionCodeCode

string

Selectiecode

☐

Code of selection code.

SelectionCodeDescription

string

{res:itgen_eol_selectioncodedescription}

☐

Description of selection code.

ShippingMethod

guid

Verzendwijze

☐

ShippingMethodDescription

string

Verzendmethode Omschrijving

☐

Status

int16

Status

☐

The status of the quotation version. 5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = Accepted.

StatusDescription

string

Statusomschrijving

☐

The description of the status.

VATAmountFC

double

BTW-bedrag Vreemde Valuta

☐

Total VAT amount in the currency of the transaction.

VersionNumber

int32

Versienummer

☑

Number indicating the different reviews which are made for the quotation.

YourRef

string

Uw Referentie

☐

The number by which this quotation is identified by the order account.