Exact Online Data Model

Account

guid

Account

☐

The customer from which the receivable will come.

AccountBankAccountID

guid

☐

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

AccountBankAccountNumber

string

☐

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

Account Contact Name

☐

Name of the contact person of the customer.

AccountCountry

string

Account Country Code

☐

Country code of the customer.

AccountName

string

Account Name

☐

Name of the customer.

AmountDC

double

Amount Division Currency

☑

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

AmountDiscountDC

double

Discount Amount (division currency)

☑

The amount of the discount in the default currency.

AmountDiscountFC

double

Discount Amount (foreign currency)

☑

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

AmountFC

double

Amount Foreign Currency

☑

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

BankAccountID

guid

Bank Account ID

☐

Own bank account to which the receivable will be done.

BankAccountNumber

string

Bank Account Number

☐

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

CashflowTransactionBatchCode

string

Cashflow Transaction Batch Code

☐

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

Created

☑

Creation date.

CreatedUtc

datetime

Created (UTC)

☐

Creation date in UTC.

Creator

guid

Creator

☐

User ID of the creator.

CreatorFullName

string

Creator Full Name

☐

Name of the creator.

Currency

string

Currency

☐

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

Description

string

Description

☐

Description.

DirectDebitMandate

guid

Direct Debit Mandate

☐

Direct Debit Mandate used to collect the receivable.

DirectDebitMandateDescription

string

Direct Debit Mandate Description

☐

Description of the mandate.

DirectDebitMandatePaymentType

int16

Direct Debit Mandate Payment Type

☐

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

DirectDebitMandateReference

string

Direct Debit Mandate Reference

☐

Unique mandate reference.

DirectDebitMandateType

int16

Direct Debit Mandate Type

☐

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

DiscountDueDate

datetime

Discount Due Date

☐

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

Division

int32

Division ID

☑

Unique number of the Exact Online division.

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.

Document

guid

Document

☐

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

DocumentNumber

int32

Document Number

☐

Number of the document.

DocumentSubject

string

Document Subject

☐

Subject of the document.

DueDate

datetime

Due Date

☐

Date before which the payment by the customer must be done.

EndDate

datetime

End Date

☐

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

EndPeriod

int16

End Period

☐

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

EndToEndID

string

End-to-end ID

☐

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

EndYear

int16

End Year

☐

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

Entry Date

☐

Processing date of the receivable.

EntryID

guid

Entry 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

Entry Number

☐

Entry number of the linked transaction.

GLAccount

guid

General Ledger Account

☐

G/L account of the payment. Must be of type 20 (Accounts receivable).

GLAccountCode

string

GL Account Code

☐

Code of the G/L account.

GLAccountDescription

string

GL Account Description

☐

Description of the G/L account.

ID

guid

ID

☑

Identifier of the receivable.

InvoiceDate

datetime

Invoice Date

☐

Invoice date of the linked transaction.

InvoiceNumber

int32

Invoice Number

☐

Invoice number of the linked transaction.

IsBatchBooking

int16

Is Batch Booking

☐

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

IsFullyPaid

boolean

Fully Paid

☑

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

Journal

string

Journal

☐

Journal of the linked transaction.

JournalDescription

string

Journal Description

☐

Description of the journal.

LastPaymentDate

datetime

Last Payment Date

☐

Last payment date.

Modified

datetime

Modified

☑

Last modified date.

ModifiedUtc

datetime

Modified (UTC)

☐

Last modified date in UTC.

Modifier

guid

Modifier

☐

User ID of modifier.

ModifierFullName

string

Modified Full Name

☐

Name of modifier.

PaymentCondition

string

Payment Condition

☐

Payment condition of the linked transaction.

PaymentConditionDescription

string

Payment Condition Description

☐

Description of the payment condition.

PaymentDays

int32

Payment Days

☐

Number of days between invoice date and due date.

PaymentDaysDiscount

int32

☐

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

PaymentDiscountPercentage

double

☐

Payment discount percentage.

PaymentInformationID

string

Payment Information ID

☐

PaymentInformationID tag from the SEPA xml file.

PaymentMethod

string

Payment Method

☐

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

PaymentReference

string

Payment Reference

☐

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

RateFC

double

Rate Foreign Currency

☐

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

ReceivableBatchNumber

int32

Receivable Batch Number

☐

Number assigned during the processing of receivables.

ReceivableSelected

datetime

☐

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

ReceivableSelector

guid

☐

User who selected the receivable to be collected.

ReceivableSelectorFullName

string

☐

Name of the receivable selector.

Source

int32

Source

☑

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

☑

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

TransactionAmountFC

double

☑

Total amount of the linked transaction in the selected currency.

TransactionDueDate

datetime

Transaction Due Date

☐

Due date of the linked transaction.

TransactionEntryID

guid

Transaction Entry ID

☐

Linked transaction. Use this as reference to SalesEntries.

TransactionID

guid

Transaction ID

☐

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

TransactionIsReversal

boolean

☑

Indicates if the linked transaction is a reversal entry.

TransactionReportingPeriod

int16

☐

Period of the linked transaction.

TransactionReportingYear

int16

☐

Year of the linked transaction.

TransactionStatus

int16

Transaction Status

☐

Status of the linked transaction.

TransactionType

int32

Transaction Type

☐

Type of the linked transaction.

YourRef

string

Your Reference

☐

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.