SalesEntryLines: Exact Online Verkoopboekingsregels

AmountDC

double

Bedrag Administratie Munteenheid

☑

Amount in the default currency of the company. For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC.

AmountFC

double

Bedrag Vreemde Valuta

☑

For normal lines it's the amount excluding VAT.

Asset

guid

Activum

☐

Reference to Asset.

AssetDescription

string

Activa Omschrijving

☐

Description of Asset.

CostCenter

string(8)

Kostenplaats

☐

Reference to Cost center.

CostCenterDescription

string(60)

Kostenplaats Omschrijving

☐

Description of CostCenter.

CostUnit

string(8)

Kostendrager

☐

Reference to Cost unit.

CostUnitDescription

string(60)

Kostendrager Omschrijving

☐

Description of CostUnit.

CustomField

string

{res:itgen_eol_customfield}

☐

Description

string

Omschrijving

☐

Description. Can be different for header and lines.

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.

EntryID

guid

Boeking ID

☑

The unique ID of the entry. Via this ID all transaction lines of a single entry can be retrieved.

ExtraDutyAmountFC

double

Extra Belasting Bedrag Vreemde Valuta

☐

Extra duty amount in the currency of the transaction. Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated.

ExtraDutyPercentage

double

Extra Belasting (%)

☐

Extra duty percentage for the item.

From

datetime

Van

☐

From date for deferred revenue.

GLAccount

guid

Grootboekrekening

☐

The GL Account of the invoice line. This field is generated based on the revenue account of the item (or the related item group). G/L Account is also used to determine whether the costcenter / costunit is mandatory.

GLAccountCode

string(30)

Grootboekrekening Code

☐

Code of the G/L account.

GLAccountDescription

string(60)

Grootboekrekening Omschrijving

☐

Description of the G/L account.

ID

guid

ID

☑

Primary key.

IntraStatArea

string

Intrastat Gebied

☐

IntraStat area.

IntraStatCountry

string

Intrastat Land

☐

IntraStatCountry.

IntraStatDeliveryTerm

string

Intrastat Afleverconditie

☐

IntraStat delivery term.

IntraStatTransactionA

string(1)

Intrastat Transactie A

☐

IntraStat transaction a.

IntraStatTransactionB

string

Intrastat Transactie B

☐

IntraStatTransportMethod

string(1)

Intrastat Transportmethode

☐

IntraStat transport method.

LineNumber

int32

Regelnummer

☐

Indicates the sequence of the lines within one entry.

NetAmountDC

double

Nettobedrag Administratie Valuta

☐

Net amount in division currency of sales entry line.

NetAmountFC

double

Netto Bedrag Vreemde Valuta

☐

Net amount in foreign currency of sales entry line.

Notes

string

Notities

☐

Extra notes.

Project

guid

Project

☐

The project to which the sales transaction line is linked. 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.

ProjectWBS

guid

Project WBS

☐

Project WBS ID.

ProjectWBSDescription

string

Project WBS Omschrijving

☐

Project WBS description.

Quantity

double

Aantal

☐

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

SerialNumber

string(30)

Serienummer

☐

Serial number.

StatisticalNetWeight

double

Statistisch Nettogewicht

☐

Statistical NetWeight.

StatisticalNumber

string

Statistisch Aantal

☐

Statistical Number (also known as 'Goederencode').

StatisticalQuantity

double

Statistische Hoeveelheid

☐

Statistical Quantity.

StatisticalValue

double

Statistische Waarde

☐

Statistical Value.

Subscription

guid

Abonnement

☐

When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines.

SubscriptionDescription

string(60)

Abonnementsomschrijving

☐

Description of Subscription.

TaxSchedule

guid

Belastingplan

☐

Obsolete.

To

datetime

Aan

☐

To date for deferred revenue.

TrackingNumber

guid

Tracking Nummer

☐

Reference to TrackingNumber.

TrackingNumberDescription

string(240)

Tracking Nummer Omschrijving

☐

Description of TrackingNumber.

Type

int32

Soort

☐

Type: 20 = Sales entry, 21 = Sales credit note.

VATAmountDC

double

BTW Bedrag Administratie Valuta

☐

VAT amount in the default currency of the company.

VATAmountFC

double

BTW-bedrag Vreemde Valuta

☐

VAT amount in the currency of the transaction. Use this property to specify a VAT amount that differs from the VAT amount that is automatically calculated. However if the transaction uses extra duty, extra duty amount also needs to be specified.

VATBaseAmountDC

double

BTW-basisbedrag Administratievaluta

☐

The VAT base amount in the default currency of the company. This is calculated based on the VATBaseAmountFC.

VATBaseAmountFC

double

BTW-basisbedrag Vreemde Valuta

☐

The VAT base amount in invoice currency. This is calculated with the use of VAT codes. It's an internal value.

VATCode

string(3)

BTW-code

☐

The VAT code used when the invoice was registered.

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 invoice is created. It's also used by the default calculation of VAT amounts and VAT base amounts.