SalesOrders: Exact Online Verkooporders

AmountDC

double

Bedrag Administratie Munteenheid

☑

Amount in the default currency of the company.

AmountDiscount

double

Kortingsbedrag

☐

Discount amount in the default currency of the company.

AmountDiscountExclVat

double

Kortingsbedrag exclusief BTW

☐

Discount amount exclude VAT in the default currency of the company.

AmountFC

double

Bedrag Vreemde Valuta

☑

Amount in the currency of the transaction.

AmountFCExclVat

double

Bedrag Vreemde Valuta exclusief BTW

☐

Amount exclude VAT in the currency of the transaction.

ApprovalStatus

int16

Goedkeuringsstatus

☑

Shows if this sales order is approved.

ApprovalStatusDescription

string

{res:itgen_eol_approvalstatusdescription}

☐

Description of ApprovalStatus.

Approved

datetime

Goedgekeurd

☐

Approval datetime.

Approver

guid

Goedkeurder

☐

User who approved the sales order.

ApproverFullName

string(240)

Goedkeurder Volledige naam

☐

Name of approver.

Created

datetime

Gemaakt

☑

Creation date.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of creator.

CreatorFullName

string(240)

Aanmaker Volledige Naam

☐

Name of creator.

Currency

string(30)

Valuta

☐

Currency code.

DeliverTo

guid

Leveren aan

☐

Reference to delivery customer.

DeliverToContactPerson

guid

Bezorg aan Contactpersoon

☐

Reference to contact person of delivery customer.

DeliverToContactPersonFullName

string(240)

Leveringscontactpersoon Volledige naam

☐

Name of contact person of delivery customer.

DeliverToName

string

Leveren aan Naam

☐

Name of delivery customer.

DeliveryAddress

guid

Afleveradres

☐

Delivery address.

DeliveryDate

datetime

Leveringsdatum

☐

Delivery date.

DeliveryStatus

int16

Afleverstatus

☐

Delivery status; 12=Open, 20=Partial, 21=Complete, 45=Canceled.

DeliveryStatusDescription

string

Afleverstatusomschrijving

☐

Description of DeliveryStatus.

Description

string

Omschrijving

☐

Description.

Discount

double

Korting

☐

Discount percentage.

Division

int32

Divisie

☑

Division code.

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 that is manually linked to the sales order.

DocumentNumber

int32

Documentnummer

☐

Number of the document.

DocumentSubject

string(256)

Document Onderwerp

☐

Subject of the document.

IncotermAddress

string

Incoterm-adres

☐

IncotermCode

string

Incoterm-code

☐

IncotermVersion

int16

Incoterm-versie

☐

InvoiceStatus

int16

Factuurstatus

☐

Invoice status; 10=draft, 20=open, 50=processed.

InvoiceStatusDescription

string

Factuurstatusomschrijving

☐

Description of InvoiceStatus.

InvoiceTo

guid

Factuur aan

☐

Reference to the Customer who will receive the invoice.

InvoiceToContactPerson

guid

Factuur aan Contactpersoon

☐

Reference to the Contact person of the customer who will receive the invoice.

InvoiceToContactPersonFullName

string(240)

Factuur voor Contactpersoon Volledige naam

☐

Name of the contact person of the customer who will receive the invoice.

InvoiceToName

string

Factuur aan Naam

☐

Name of the customer who will receive the invoice.

Modified

datetime

Gewijzigd

☑

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string(240)

Gewijzigd Volledige Naam

☐

Name of modifier.

OrderDate

datetime

Besteldatum

☐

Order date.

OrderedBy

guid

Besteld door

☐

Customer who ordered the sales order.

OrderedByContactPerson

guid

Besteld door Contactpersoon

☐

Contact person of the customer who ordered the sales order.

OrderedByContactPersonFullName

string(240)

Besteld door Contactpersoon Volledige naam

☐

Name of contact person of the customer who ordered the sales order.

OrderedByName

string(50)

Besteld door Naam

☐

Name of the customer who ordered the sales order.

OrderID

guid

Order ID

☑

Primary key.

OrderNumber

int32

Ordernummer

☑

Number of sales order.

PaymentCondition

string(2)

Betalingsvoorwaarde

☐

The payment condition used for due date and discount calculation.

PaymentConditionDescription

string(60)

Betalingsconditie Omschrijving

☐

Description of PaymentCondition.

PaymentReference

string(60)

Betalingsreferentie

☐

Payment reference for sales order.

Remarks

string

Aantekeningen

☐

Extra remarks.

SalesChannel

guid

Verkoopkanaal

☐

SalesChannelCode

string

Verkoopkanaalcode

☐

SalesChannelDescription

string

Verkoopkanaalomschrijving

☐

Salesperson

guid

Verkoper

☐

Sales representative.

SalespersonFullName

string(240)

Verkoper Volledige Naam

☐

Name of sales representative.

SelectionCode

guid

Selectiecode

☐

ID of selection code.

SelectionCodeCode

string

Selectiecode

☐

Code of selection code.

SelectionCodeDescription

string

{res:itgen_eol_selectioncodedescription}

☐

Description of selection code.

ShippingMethod

guid

Verzendwijze

☐

ShippingMethod.

ShippingMethodDescription

string

Verzendmethode Omschrijving

☐

Description of ShippingMethod.

Status

int16

Status

☐

The status of the sales order. 12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled.

StatusDescription

string

Statusomschrijving

☐

Description of Status.

TaxSchedule

guid

Belastingplan

☐

Obsolete.

TaxScheduleCode

string

Belasting Planningscode

☐

Obsolete.

TaxScheduleDescription

string

Belasting Planningsomschrijving

☐

Obsolete.

WarehouseCode

string

Magazijncode

☐

Code of Warehouse.

WarehouseDescription

string

Magazijnomschrijving

☐

Description of Warehouse.

WarehouseID

guid

Magazijn ID

☐

Warehouse.

YourRef

string(30)

Uw Referentie

☐

The reference number of the customer.