ReceivablesBulk: Exact Online Debiteuren

Account

guid

Account

☐

The customer from which the receivable will come.

AccountBankAccountID

guid

{res:itgen_eol_accountbankaccountid}

☐

The bank account of the customer, from which the receivable will come.

AccountBankAccountNumber

string

{res:itgen_eol_accountbankaccountnumber}

☐

The bank account number of the customer, from which the receivable will come.

AccountCode

string

Account Code

☐

The code of the customer from which the receivable will come.

AccountContact

guid

Account Contact

☐

Contact person copied from the purchase invoice linked to the related purchase entry.

AccountContactName

string

Naam Relatie Contactpersoon

☐

Name of the contact person of the customer.

AccountCountry

string

Relatie Landcode

☐

Country code of the customer.

AccountName

string

Accountnaam

☐

Name of the customer.

AmountDC

double

Bedrag Administratie Munteenheid

☑

The amount in default currency (division currency). Receivables 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 receivable. This is in the amount of the selected currency.

BankAccountID

guid

Bankrekening ID

☐

Own bank account to which the receivable will be done.

BankAccountNumber

string

Bankrekeningnummer

☐

Own bank account number to which the receivable will be done.

CashflowTransactionBatchCode

string

Kasstroom Transactie Batchcode

☐

When processing receivables, all receivable 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 receivable. This currency can only deviate from the division currency if the module Currency is in the license.

Description

string

Omschrijving

☐

Description.

DirectDebitMandate

guid

Machtiging Automatische Incasso

☐

Direct Debit Mandate used to collect the receivable.

DirectDebitMandateDescription

string

Mandaatomschrijving Automatische Incasso

☐

Description of the mandate.

DirectDebitMandatePaymentType

int16

Soort Automatische Incassomachtiging

☐

Payment type of the mandate. 0 = One off payment 1 = Recurrent payment.

DirectDebitMandateReference

string

Incassomandaat Referentie

☐

Unique mandate reference.

DirectDebitMandateType

int16

Soort Automatische Incassomachtiging

☐

Type of the mandate. 0 = Core 1 = Business-to-business.

DiscountDueDate

datetime

Korting Vervaldag

☐

Date before which the payment by the customer 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 collections. 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 by the customer must be done.

EndDate

datetime

Einddatum

☐

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

EndPeriod

int16

Eindperiode

☐

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

EndToEndID

string

Eind-tot-eind ID

☐

The value of the tag 'EndToEndID' when generating a SEPA file.

EndYear

int16

Einde Jaar

☐

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

EntryDate

datetime

Boekdatum

☐

Processing date of the receivable.

EntryID

guid

Boeking ID

☐

The unique identifier for a set of receivables. A receivable can be split so that one part is received 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 20 (Accounts receivable).

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

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 receivable is part of a batch booking.

IsFullyPaid

boolean

Volledig Betaald

☑

Boolean indicating whether the receivable was fully paid by the customer.

Journal

string

Dagboek

☐

Journal of the linked transaction.

JournalDescription

string

Dagboekomschrijving

☐

Description of the journal.

LastPaymentDate

datetime

Laatste Betalingsdatum

☐

Last payment date.

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.

OrderNumber

int32

Ordernummer

☐

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.

PaymentInformationID

string

Betalingsinformatie ID

☐

PaymentInformationID tag from the SEPA xml file.

PaymentMethod

string

Betalingsmethode

☐

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

PaymentReference

string

Betalingsreferentie

☐

Payment reference for the receivable that may be included In the bank export file.

RateFC

double

Wisselkoers Vreemde Valuta

☐

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

ReceivableBatchNumber

int32

Ontvangsten Batchnummer

☐

Number assigned during the processing of receivables.

ReceivableSelected

datetime

Ontvangbaar Geselecteerd

☐

Date and time since when the receivable is selected to be collected.

ReceivableSelector

guid

Ontvangbaarkiezer

☐

User who selected the receivable to be collected.

ReceivableSelectorFullName

string

{res:itgen_eol_receivableselectorfullname}

☐

Name of the receivable selector.

Source

int32

Bron

☑

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

Status

int16

Status

☐

The status of the receivable. 20 = open 30 = selected - receivable is selected to be collected 40 = processed - collection has been done 50 = matched - receivable 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 SalesEntries.

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. In case the receivable belongs to a bank entry line and is matched with one invoice, YourRef is filled with the YourRef of this invoice.