Please enable JavaScript to view this site.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: SalesInvoice > Tables

SalesInvoiceLines: Exact Online Sales Invoice Lines

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: SalesInvoice

Primary Keys: ID

Label: Sales Invoice Lines

The data in this table is partitioned per value of the Division column.

Can retrieve data and change data using insert, update and delete.

Webhook Topic: SalesInvoices

Webhook Key Field: InvoiceID

Select Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoiceLines

Insert Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoiceLines

Update Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoiceLines

Delete Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoiceLines

Exact Online API Metadata URL: /api/v1/{division}/salesinvoice/$metadata

Field Selection Method: Required

Table Columns

The columns of the table SalesInvoiceLines are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.

Name

Data Type

Label

Required

Documentation

AmountDC

double

Amount Division Currency

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

AmountFC

double

Amount Foreign Currency

For normal lines it's the amount excluding VAT.

CostCenter

string(8)

Cost Center

Reference to Cost center.

CostCenterDescription

string(60)

Cost Center Description

Description of CostCenter.

CostUnit

string(8)

Cost Unit

Reference to Cost unit.

CostUnitDescription

string(60)

Cost Unit Description

Description of CostUnit.

CustomerItemCode

string

 

Code the customer uses for this item.

DeliveryDate

datetime

Delivery Date

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

Description

Description. Can be different for header and lines.

Discount

double

Discount

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

Division

int32

Division

Division code.

DivisionCompanyCoCNumber

string(20)

Division Chamber of Commerce Number

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Division IBAN Number

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Division Company Name

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Division RSIN Number

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Division VAT Number

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Division Wage Tax Number

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Division Label

Label of the Exact Online division.

DivisionName

string(50)

Administration Name

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Subscription Holder Name

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

DivisionOwnerCompanyNumber

string(18)

Subscription Holder Number

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

DivisionShortName

int64

Division Short Name

Short name of the Exact Online division.

Employee

guid

Employee

Link to Employee originating from time and cost transactions.

EmployeeFullName

string(240)

Employee Full Name

Name of employee.

EndTime

datetime

End Time

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

ExtraDutyAmountFC

double

Extra Duty Amount Foreign Currency

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 Duty (%)

Extra duty percentage.

GLAccount

guid

General Ledger Account

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)

GL Account Description

Description of the G/L account.

ID

guid

ID

Primary key.

InvoiceID

guid

Invoice ID

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

Item

guid

Item

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

ItemCode

string(30)

Item Code

Item code.

ItemDescription

string(60)

Item Description

Description of Item.

LineNumber

int32

Line Number

Indicates the sequence of the lines within one invoice.

NetAmountDC

double

Net Amount Division Currency

Net amount in division currency of sales invoice line.

NetAmountFC

double

Net Amount Foreign Currency

Net amount in foreign currency of sales invoice line.

NetPrice

double

Net Price

Net price of the sales invoice line.

Notes

string

Notes

Extra notes.

Pricelist

guid

Price List

Price list.

PricelistDescription

string

Price List Description

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)

Project Description

Description of Project.

ProjectWBS

guid

Project WBS

WBS linked to the sales invoice.

ProjectWBSDescription

string

Project WBS Description

Description of WBS.

Quantity

double

Quantity

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

SalesOrder

guid

Sales Order

Identifies the sales order this invoice line is based on.

SalesOrderLine

guid

Sales Order Line

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

SalesOrderLineNumber

int32

Sales Order Line Number

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

SalesOrderNumber

int32

Sales Order Number

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

StartTime

datetime

Start Time

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

Subscription

guid

Subscription

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

SubscriptionDescription

string(60)

Subscription Description

Description of subscription line.

TaxSchedule

guid

Tax Schedule

Obsolete.

TaxScheduleCode

string

Tax Schedule Code

Obsolete.

TaxScheduleDescription

string

Tax Schedule Description

Obsolete.

UnitCode

string(8)

Unit Code

Code of Unit.

UnitDescription

string(60)

Unit Description

Description of Unit.

UnitPrice

double

Unit Price

Price per unit.

VATAmountDC

double

VAT Amount Division Currency

VAT amount in the default currency of the company.

VATAmountFC

double

VAT Amount Foreign Currency

VAT amount in the currency of the transaction.

VATCode

string(3)

VAT Code

The VAT code that is used when the invoice is registered.

VATCodeDescription

string(60)

VAT Code Description

Description of VAT code.

VATPercentage

double

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

 

14-04-2021 14:43 Version 20.1.394-BETA+3155