SalesOrderLines: Exact Online Verkooporderregels

AmountDC

double

Bedrag Administratie Munteenheid

☑

Amount in the default currency of the company.

AmountFC

double

Bedrag Vreemde Valuta

☑

Amount in the currency of the transaction.

CostCenter

string(8)

Kostenplaats

☐

Reference to Cost Center.

CostCenterDescription

string(60)

Kostenplaats Omschrijving

☐

Description of cost center.

CostPriceFC

double

Kostprijs Vreemde Valuta

☐

Item cost price.

CostUnit

string(8)

Kostendrager

☐

Reference to Cost Unit.

CostUnitDescription

string(60)

Kostendrager Omschrijving

☐

Description of cost unit.

CustomerItemCode

string

Klant Artikelcode

☐

Code the customer uses for this item.

CustomField

string

{res:itgen_eol_customfield}

☐

DeliveryDate

datetime

Leveringsdatum

☐

Delivery date of this line.

DeliveryStatus

int16

Afleverstatus

☐

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

Description

string

Omschrijving

☐

Description.

Discount

double

Korting

☐

Discount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item.

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.

ID

guid

ID

☑

Primary key.

InvoiceStatus

int16

Factuurstatus

☐

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

Item

guid

Artikel

☐

Reference to the Item that is sold in this sales order line.

ItemCode

string(30)

Artikelcode

☐

Code of the item.

ItemDescription

string(255)

Artikelomschrijving

☐

Description of Item.

ItemVersion

guid

Artikelversie

☐

Version of item.

ItemVersionDescription

string

Artikelversie Omschrijving

☐

Description of Item Version.

LineNumber

int32

Regelnummer

☑

Line number.

Margin

double

Marge

☐

Sales margin of the sales order line.

NetPrice

double

Netto Prijs

☐

Net price of the sales order line.

Notes

string

Notities

☐

Extra notes.

OrderID

guid

Order ID

☑

Reference to Sales Order. All the lines of a sales order have the same OrderID.

OrderNumber

int32

Ordernummer

☑

Number of sales order.

OrderStatus

int16

Orderstatus

☐

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

Pricelist

guid

Prijslijst

☐

Reference to Price List.

PricelistDescription

string

Prijslijstomschrijving

☐

Description of Price List.

Project

guid

Project

☐

Reference to Project. The project can be different per line. Sometimes also the project in the header is filled although this is not really used.

ProjectDescription

string(60)

Projectomschrijving

☐

Description of Project.

PurchaseOrder

guid

Inkooporder

☐

Reference to Purchase Order.

PurchaseOrderLine

guid

Inkooporderregel

☐

Reference to Purchase Order Line.

PurchaseOrderLineNumber

int32

Inkoop Orderregel Nummer

☐

Line number of referenced Purchase Order Line.

PurchaseOrderNumber

int32

Inkoopordernummer

☐

Number of referenced Purchase Order.

Quantity

double

Aantal

☐

Number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor.

QuantityDelivered

double

Geleverde Hoeveelheid

☐

The number of items delivered.

QuantityInvoiced

double

Gefactureerd Aantal

☐

The number of items invoiced.

ShopOrder

guid

Productieorder

☐

Reference to Shop Order.

TaxSchedule

guid

Belastingplan

☐

Obsolete.

TaxScheduleCode

string

Belasting Planningscode

☐

Obsolete.

TaxScheduleDescription

string

Belasting Planningsomschrijving

☐

Obsolete.

UnitCode

string(8)

Unit Code

☐

Code of item unit.

UnitDescription

string(60)

Omschrijving Unit

☐

Description of Item Unit.

UnitPrice

double

Prijs per Eenheid

☐

Price per unit in the currency of the transaction.

UseDropShipment

int16

Gebruik Drop Shipment

☑

Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler).

VATAmount

double

BTW-bedrag

☐

VAT amount in the currency of the transaction.

VATCode

string(3)

BTW-code

☐

VAT code.

VATCodeDescription

string(60)

BTW Code Omschrijving

☐

Description of VAT code.

VATPercentage

double

BTW-percentage

☐

The VAT percentage of the VAT code. This is the percentage at the moment the sales order is created. It's also used for the default calculation of VAT amounts and VAT base amounts.