TransactionLines: Exact Online Transactieregels

Account

guid

Account

☐

Reference to account.

AccountCode

string(18)

Account Code

☐

Code of the Account.

AccountName

string(50)

Accountnaam

☐

Name of account.

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.

AmountVATBaseFC

double

BTW-bedrag Basis Vreemde Valuta

☐

Vat base amount in the currency of the transaction.

AmountVATFC

double

Bedrag BTW Buitenlandse Valuta

☐

Vat amount in the currency of the transaction.

Asset

guid

Activum

☐

Reference to asset.

AssetCode

string(30)

Activacode

☐

Code of Asset.

AssetDescription

string(60)

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.

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.

CustomField

string

{res:itgen_eol_customfield}

☐

Date

datetime

Datum

☐

Date.

Description

string(60)

Omschrijving

☐

Description.

DisplayDocumentsUrl

string

Weergave Documenten (URL)

☐

URL to display documents attached to this transaction using Get My Report.

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

☐

Reference to document.

DocumentNumber

int32

Documentnummer

☐

Number of the document.

DocumentSubject

string(256)

Document Onderwerp

☐

Subject of the document.

DueDate

datetime

Vervaldag

☐

Date that payment should be done.

EntryID

guid

Boeking ID

☐

The transaction lines that make up a financial entry share the same EntryID.

EntryNumber

int32

Boekingnummer

☐

Entry number of the header.

ExchangeRate

double

Wisselkoers

☐

Exchange rate.

ExternalLinkDescription

string

Externe Link Omschrijving

☐

ExternalLinkReference

string

Externe Link Referentie

☐

ExtraDutyAmountFC

double

Extra Belasting Bedrag Vreemde Valuta

☐

Extra duty amount.

ExtraDutyPercentage

double

Extra Belasting (%)

☐

Extra duty percentage.

FinancialPeriod

int16

Boekperiode

☐

Financial period.

FinancialYear

int16

Boekjaar

☐

Financial year.

GLAccount

guid

Grootboekrekening

☐

General ledger account.

GLAccountBalanceSide

string(1)

Grootboekrekening Balanszijde

☑

Balance side of transactions on this GL account.

GLAccountBalanceType

string(1)

Grootboekrekening Balanssoort

☑

Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss.

GLAccountCode

string(30)

Grootboekrekening Code

☐

Code of the G/L account.

GLAccountDescription

string(60)

Grootboekrekening Omschrijving

☐

Description of the G/L account.

GLAccountRevalueCurrency

boolean

Grootboekrekening Herwaarderingsvaluta

☑

Whether to revalue amounts posted on this GL account.

GLAccountSearchCode

string(9)

Grootboekrekening Zoekcode

☐

User-friendly search code for the GL account.

GLAccountType

int32

Grootboekrekeningsoort

☑

Type of GL account. See view GLAccountTypes.

GLAccountTypeDescription

string

Grootboekrekeningsoortomschrijving

☑

Description of the GL account type.

GLAccountUseCostCenter

boolean

Gebruik Kostenplaats

☑

Indicator whether to use cost centers for transaction lines on the GL account.

GLAccountUseCostUnit

boolean

Gebruik Kostendrager

☑

Indicator whether to use cost units for transaction lines on the GL account.

GLAccountVatCode

string(3)

BTW Code van Grootboekrekening

☐

Associated VAT code of the GL account.

ID

guid

ID

☑

Primary key.

InvoiceNumber

int32

Factuurnummer

☐

Invoice number.

Item

guid

Artikel

☐

Reference to item.

ItemCode

string(30)

Artikelcode

☐

Code of Item.

ItemDescription

string(255)

Artikelomschrijving

☐

Description of Item.

JournalCode

string(20)

Dagboekcode

☐

The journal code.

JournalDescription

string(60)

Dagboekomschrijving

☐

The journal description.

LineNumber

int32

Regelnummer

☐

Line number.

LineType

int16

Regelsoort

☑

Line type.

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.

Notes

string

Notities

☐

Extra remarks.

OffsetID

guid

Grootboektegenrekening ID

☐

OffsetID.

OrderNumber

int32

Ordernummer

☐

Order number.

PaymentDiscountAmount

double

Betaalkortingsbedrag

☐

Discount amount when paid in time.

PaymentReference

string(60)

Betalingsreferentie

☐

Payment reference.

Project

guid

Project

☐

Reference to project.

ProjectCode

string(20)

Projectcode

☐

Code of Project.

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

☐

Quantity.

SerialNumber

string(30)

Serienummer

☐

Serial number of item.

ShopOrder

guid

Productieorder

☐

Reference to shop order.

Status

int16

Status

☐

20 = Open, 50 = Processed.

Subscription

guid

Abonnement

☐

Reference to subscription line.

SubscriptionDescription

string(60)

Abonnementsomschrijving

☐

Description of subscription line.

TrackingNumber

string(100)

Tracking Nummer

☐

Tracking number of item.

TrackingNumberDescription

string(240)

Tracking Nummer Omschrijving

☐

Tracking number description.

Type

int32

Soort

☑

The transaction type. Possible values: see TransactionLineTypes.

VATCode

string(3)

BTW-code

☐

VAT code.

VATCodeDescription

string(60)

BTW Code Omschrijving

☐

Description of VAT code.

VATPercentage

double

BTW-percentage

☐

Vat percentage.

VATType

string(1)

BTW Soort

☐

VAT type.

YourRef

string(30)

Uw Referentie

☐

Your reference (of customer).