PaymentsBulk: Exact Online Betalingen

Account

guid

Account

☐

The supplier to which the payment has to be done.

AccountBankAccountID

guid

{res:itgen_eol_accountbankaccountid}

☐

The bank account of the supplier, to which the payment has to be done.

AccountBankAccountNumber

string

{res:itgen_eol_accountbankaccountnumber}

☐

The bank account number of the supplier, to which the payment has to be done.

AccountCode

string

Account Code

☐

The code of the supplier to which the payment has to be done.

AccountContact

guid

Account Contact

☐

Contact person copied from the purchase invoice linked to the related purchase entry. Used as prefered contact when sending reminders.

AccountContactName

string

Naam Relatie Contactpersoon

☐

Name of the contact person of the supplier.

AccountName

string

Accountnaam

☐

Name of the supplier.

AmountDC

double

Bedrag Administratie Munteenheid

☑

The amount in default currency (division currency). Payments are matched on this amount.

AmountDiscountDC

double

Kortingsbedrag (divisievaluta)

☑

The amount of the discount in the default currency.

AmountDiscountFC

double

Kortingsbedrag (vreemde valuta)

☑

The amount of the discount. This is in the amount of the selected currency.

AmountFC

double

Bedrag Vreemde Valuta

☑

The amount of the payment. This is in the amount of the selected currency.

BankAccountID

guid

Bankrekening ID

☐

Own bank account from which the payment must be done.

BankAccountNumber

string

Bankrekeningnummer

☐

Own bank account number from which the payment must be done.

CashflowTransactionBatchCode

string

Kasstroom Transactie Batchcode

☐

When processing payments, all payments with the same processing data are put in a batch. This field contains the code of that batch.

Created

datetime

Gemaakt

☑

Creation date.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of the creator.

CreatorFullName

string

Aanmaker Volledige Naam

☐

Name of the creator.

Currency

string

Valuta

☐

The currency of the payment. This currency can only deviate from the division currency if the module Currency is in the license.

Description

string

Omschrijving

☐

Extra description for the payment that may be included in the bank export file.

DiscountDueDate

datetime

Korting Vervaldag

☐

Date before which the payment must be done to be eligible for discount.

Division

int32

Divisie ID

☑

Unique number of the Exact Online division.

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

☐

Document that is created when processing payments. The bank export file is attached to the document.

DocumentNumber

int32

Documentnummer

☐

Number of the document.

DocumentSubject

string

Document Onderwerp

☐

Subject of the document.

DueDate

datetime

Vervaldag

☐

Date before which the payment must be done.

EndDate

datetime

Einddatum

☐

Date since when the payment is no longer an outstanding item. This is the highest invoice date of all matched payments.

EndPeriod

int16

Eindperiode

☐

Period since when the payment is no longer an outstanding item. This is the highest period of all matched payments.

EndYear

int16

Einde Jaar

☐

Year (of period) since when the payment is no longer an outstanding item. This is the highest year of all matched payments. Used in combination with EndPeriod.

EntryDate

datetime

Boekdatum

☐

Processing date of the payment.

EntryID

guid

Boeking ID

☐

The unique identifier for a set of payments. A payment can be split so that one part is paid on a different date. In that case the two records get a different EntryID.

EntryNumber

int32

Boekingnummer

☐

Entry number of the linked transaction.

GLAccount

guid

Grootboekrekening

☐

G/L account of the payment. Must be of type 22 (Accounts payable).

GLAccountCode

string

Grootboekrekening Code

☐

Code of the G/L account.

GLAccountDescription

string

Grootboekrekening Omschrijving

☐

Description of the G/L account.

ID

guid

ID

☑

Identifier of the payment.

InvoiceDate

datetime

Factuurdatum

☐

Invoice date of the linked transaction.

InvoiceNumber

int32

Factuurnummer

☐

Invoice number of the linked transaction.

IsBatchBooking

int16

Is Batchboeking

☐

Boolean indicating whether the payment is part of a batch booking.

Journal

string

Dagboek

☐

Journal of the linked transaction.

JournalDescription

string

Dagboekomschrijving

☐

Description of the journal.

Modified

datetime

Gewijzigd

☑

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string

Gewijzigd Volledige Naam

☐

Name of modifier.

PaymentBatchNumber

int32

Betalingsbatchnummer

☐

Number assigned during the of processing payments. When payments are processed a bank export file is created. This file contains one or more batches that contain one or more payments. Each batch gets a sequence number that is stored for each payment in that batch.

PaymentCondition

string

Betalingsvoorwaarde

☐

Payment condition of the linked transaction.

PaymentConditionDescription

string

Betalingsconditie Omschrijving

☐

Description of the payment condition.

PaymentDays

int32

Betalingsdagen

☐

Number of days between invoice date and due date.

PaymentDaysDiscount

int32

Kortingsdagen Betaling

☐

Number of days between invoice date and due date of the discount.

PaymentDiscountPercentage

double

{res:itgen_eol_paymentdiscountpercentage}

☐

Payment discount percentage.

PaymentMethod

string

Betalingsmethode

☐

Method of payment. B = On credit (default) I = Collection K = Cash V = Credit card.

PaymentReference

string

Betalingsreferentie

☐

Payment reference for the payment that may be included in the bank export file.

PaymentSelected

datetime

Geselecteerde Betaling

☐

Date and time since when the payment is selected to be paid.

PaymentSelector

guid

Betalingskiezer

☐

User who selected the payment to be paid.

PaymentSelectorFullName

string

{res:itgen_eol_paymentselectorfullname}

☐

Name of the payment selector.

RateFC

double

Wisselkoers Vreemde Valuta

☐

Exchange rate from payment currency to division currency. AmountFC * RateFC = AmountDC.

Source

int32

Bron

☑

The source of the payment. 1 = manual 2 = reconcile 3 = match 4 = import 5 = process.

Status

int16

Status

☐

The status of the payment. 20 = open 30 = selected - payment is selected to be paid 40 = processed - payment has been done 50 = matched - payment is matched with one or more other outstanding items or financial statement lines.

TransactionAmountDC

double

Transactiebedrag Administratievaluta

☑

Total amount of the linked transaction in default currency (division currency).

TransactionAmountFC

double

Transactiebedrag Vreemde Valuta

☑

Total amount of the linked transaction in the selected currency.

TransactionDueDate

datetime

Vervaldatum Transactie

☐

Due date of the linked transaction.

TransactionEntryID

guid

Mutatie Invoer-ID

☐

Linked transaction. Use this as reference to PurchaseEntries.

TransactionID

guid

Transactie ID

☐

Linked transaction line. Use this as reference to BankEntryLines and CashEntryLines.

TransactionIsReversal

boolean

{res:itgen_eol_transactionisreversal}

☑

Indicates if the linked transaction is a reversal entry.

TransactionReportingPeriod

int16

{res:itgen_eol_transactionreportingperiod}

☐

Period of the linked transaction.

TransactionReportingYear

int16

{res:itgen_eol_transactionreportingyear}

☐

Year of the linked transaction.

TransactionStatus

int16

Transactiestatus

☐

Status of the linked transaction.

TransactionType

int32

Transactiesoort

☐

Type of the linked transaction.

YourRef

string

Uw Referentie

☐

Invoice number of the supplier. In case the payment belongs to a bank entry line and is matched with one invoice, YourRef is filled with the YourRef of this invoice.