Please enable JavaScript to view this site.

Exact Online API Data Model

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

PurchaseInvoices: Exact Online Purchase Invoices

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Purchase

Primary Keys: ID

Label: Purchase Invoices

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

Can retrieve data and change data using insert, update and delete.

Select Exact Online API URL: /api/v1/{division}/purchase/PurchaseInvoices

Insert Exact Online API URL: /api/v1/{division}/purchase/PurchaseInvoices

Update Exact Online API URL: /api/v1/{division}/purchase/PurchaseInvoices

Delete Exact Online API URL: /api/v1/{division}/purchase/PurchaseInvoices

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

Field Selection Method: Required

Table Columns

The columns of the table PurchaseInvoices are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.

Name

Data Type

Label

Required

Documentation

Amount

double

Amount

The amount including VAT in the currency of the invoice.

ContactPerson

guid

Contact Person

Guid identifying the contact person of the supplier.

Currency

string(30)

Currency

The code of the currency of the invoiced amount.

Description

string

Description

The description of the invoice.

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

Guid identifying a document that is attached to the invoice.

DueDate

datetime

Due Date

The date before which the invoice has to be paid.

EntryNumber

int32

Entry Number

The unique number of the purchase invoice. The entry number is based on a setting in the purchase journal and incremented for each new purchase invoice.

ExchangeRate

double

Exchange Rate

The exchange rate between the invoice currency and the default currency of the division.

FinancialPeriod

int16

Financial Period

Financial period.

FinancialYear

int16

Financial Year

The financial year in which the invoice is entered.

ID

guid

ID

A GUID that is the unique identifier of the purchase invoice.

InvoiceDate

datetime

Invoice Date

The date on which the supplier entered the invoice.

Journal

string(20)

Journal

The code of the purchase journal in which the invoice is entered.

Modified

datetime

Modified

Last modified date.

ModifiedUtc

datetime

Modified (UTC)

Last modified date in UTC.

PaymentCondition

string(2)

Payment Condition

The code of the payment condition that is used to calculate the due date and discount.

PaymentReference

string(60)

Payment Reference

Unique reference to match payments and invoices.

Remarks

string

Remarks

The user can enter remarks related to the invoice here.

Source

int16

Source

Indicates the origin of the invoice. 1 Manual entry, 3 Purchase invoice, 4 Purchase order, 5 Web service.

Status

int16

Status

The status of the invoice. 10 Draft, 20 Open, 50 Processed.

Supplier

guid

Supplier

Guid that identifies the supplier.

Type

int16

Type

Indicates the type of the purchase invoice. 8030 Direct purchase invoice, 8031 Direct purchase invoice (Credit), 8033 Purchase invoice, 8034 Purchase invoice (Credit).

VATAmount

double

VAT Amount

The total VAT amount of the purchase invoice.

Warehouse

guid

Warehouse

Guid that identifies the warehouse that will receive the purchased goods. This is mandatory for creating a direct purchase invoice.

YourRef

string(30)

Your Reference

The invoice number provided by the supplier.

 

14-04-2021 14:43 Version 20.1.394-BETA+3155