Please enable JavaScript to view this site.

Exact Online Data Model

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

ReceivablesBulk: Exact Online Receivables

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Cashflow

Primary Keys: ID

Label: Receivables

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

This is a read-only table. The Exact Online API may not support changing the data or the Invantive SQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API.

Select Exact Online API URL: /api/v1/{division}/bulk/Cashflow/Receivables

Insert Exact Online API URL: /api/v1/{division}/bulk/Cashflow/Receivables

Update Exact Online API URL: /api/v1/{division}/bulk/Cashflow/Receivables

Delete Exact Online API URL: /api/v1/{division}/bulk/Cashflow/Receivables

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

Field Selection Method: RequiredExpanded

Table Columns

The columns of the table ReceivablesBulk are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

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.

 

12-12-2020 17:59 Version 20.1.301-BETA+3023