SalesInvoiceLines: Exact Online Verkoopfactuurregels

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.

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.

CustomerItemCode

string

Klant Artikelcode

☐

Code the customer uses for this item.

CustomField

string

{res:itgen_eol_customfield}

☐

DeliveryDate

datetime

Leveringsdatum

☐

Delivery date of an item in a sales invoice. This is used for VAT on prepayments, only if sales order is not used in the license.

Description

string

Omschrijving

☐

Description. Can be different for header and lines.

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.

Employee

guid

Medewerker

☐

Link to Employee originating from time and cost transactions.

EmployeeFullName

string(240)

Medewerker Volledige Naam

☐

Name of employee.

EndTime

datetime

Eindtijd

☐

EndTime is used to store the last date of a period. EndTime is used in combination with StartTime.

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.

GLAccount

guid

Grootboekrekening

☐

The GL Account of the sales invoice line. This field is mandatory. 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.

GLAccountDescription

string(60)

Grootboekrekening Omschrijving

☐

Description of the G/L account.

ID

guid

ID

☑

Primary key.

InvoiceID

guid

Factuur ID

☑

The InvoiceID identifies the sales invoice. All the lines of a sales invoice have the same InvoiceID.

Item

guid

Artikel

☐

Reference to the item that is sold in this sales invoice line.

ItemCode

string(30)

Artikelcode

☐

Item code.

ItemDescription

string(255)

Artikelomschrijving

☐

Description of Item.

LineNumber

int32

Regelnummer

☐

Indicates the sequence of the lines within one invoice.

NetAmountDC

double

Nettobedrag Administratie Valuta

☐

Net amount in division currency of sales invoice line.

NetAmountFC

double

Netto Bedrag Vreemde Valuta

☐

Net amount in foreign currency of sales invoice line.

NetPrice

double

Netto Prijs

☐

Net price of the sales invoice line.

Notes

string

Notities

☐

Extra notes.

Pricelist

guid

Prijslijst

☐

Price list.

PricelistDescription

string

Prijslijstomschrijving

☐

Description of Pricelist.

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

☐

WBS linked to the sales invoice.

ProjectWBSDescription

string

Project WBS Omschrijving

☐

Description of WBS.

Quantity

double

Aantal

☐

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

SalesOrder

guid

Verkooporder

☐

Identifies the sales order this invoice line is based on.

SalesOrderLine

guid

Verkooporderregel

☐

Identifies the sales order line this sales invoice line is based on.

SalesOrderLineNumber

int32

Verkooporder Regelnummer

☐

Then line number of the sales order line on which this invoice line is based on.

SalesOrderNumber

int32

Verkoopordernummer

☐

The order number of the sales order on which this invoice line is based on.

StartTime

datetime

Starttijd

☐

StartTime is used to store the first date of a period. StartTime is used in combination with EndTime.

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 line.

TaxSchedule

guid

Belastingplan

☐

Obsolete.

TaxScheduleCode

string

Belasting Planningscode

☐

Obsolete.

TaxScheduleDescription

string

Belasting Planningsomschrijving

☐

Obsolete.

UnitCode

string(8)

Unit Code

☐

Code of Unit.

UnitDescription

string(60)

Omschrijving Unit

☐

Description of Unit.

UnitPrice

double

Prijs per Eenheid

☐

Price per unit.

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.

VATCode

string(3)

BTW-code

☐

The VAT code that is used when the invoice is 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 for the default calculation of VAT amounts and VAT base amounts.