Please enable JavaScript to view this site.

Exact Online API Data Model

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

PurchaseOrders: Exact Online Purchase Orders

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: PurchaseOrder

Primary Keys: PurchaseOrderID

Label: Purchase Orders

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

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

Webhook Topic: PurchaseOrders

Select Exact Online API URL: /api/v1/{division}/purchaseorder/PurchaseOrders

Insert Exact Online API URL: /api/v1/{division}/purchaseorder/PurchaseOrders

Update Exact Online API URL: /api/v1/{division}/purchaseorder/PurchaseOrders

Delete Exact Online API URL: /api/v1/{division}/purchaseorder/PurchaseOrders

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

Field Selection Method: Required

Table Columns

The columns of the table PurchaseOrders 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

AmountDC

double

Amount Division Currency

Total amount in the default currency of the company.

AmountFC

double

Amount Foreign Currency

Total amount in the currency of the transaction.

Created

datetime

Created

Creation date.

CreatedUtc

datetime

Created (UTC)

Creation date in UTC.

Creator

guid

Creator

User ID of creator.

CreatorFullName

string(240)

Creator Full Name

Name of creator.

Currency

string(30)

Currency

Currency code.

DeliveryAccount

guid

Delivery Account

Reference to account for delivery.

DeliveryAccountCode

string(18)

Delivery Account Code

Delivery account code.

DeliveryAccountName

string(50)

Delivery Account Name

Name of account.

DeliveryAddress

guid

Delivery Address

Reference to shipping address.

DeliveryContact

guid

Delivery Contact Person

Reference to contact for delivery.

DeliveryContactPersonFullName

string(240)

Delivery Contact Person Full Name

Name of the contact person of the customer who will receive delivered goods.

Description

string

Description

Description of the purchase order.

Division

int32

Division

Division code.

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 manually linked to the purchase order.

DocumentSubject

string(256)

Document Subject

Subject of the document.

DropShipment

boolean

Drop Shipment

Shows if it is a drop shipment purchase order.

ExchangeRate

double

Exchange Rate

Allows you to set the currency for the invoice. You can only do this if you have checked the Variable: Currency and Variable: Exchange rate fields in the sales journal settings. Once a line has been created in the invoice, the currency can no longer be changed.

InvoiceStatus

int32

Invoice Status

Invoice status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled.

Modified

datetime

Modified

Last modified date.

ModifiedUtc

datetime

Modified (UTC)

Last modified date in UTC.

Modifier

guid

Modifier

User ID of modifier.

ModifierFullName

string(240)

Modified Full Name

Name of modifier.

OrderDate

datetime

Order Date

Order date.

OrderNumber

int32

Order Number

Human readable id of the purchase order.

OrderStatus

int32

Order Status

Purchase order status: 10-Open, 20-Partial, 30-Complete, 40-Canceled.

PaymentCondition

string(2)

Payment Condition

The payment condition code used for due date and discount calculation.

PaymentConditionDescription

string(60)

Payment Condition Description

Description of payment condition.

PurchaseAgent

guid

Purchase Agent

Purchase agent.

PurchaseAgentFullName

string(240)

Purchase Agent Full Name

Name of purchase agent.

PurchaseOrderID

guid

Purchase Order ID

Primary key.

ReceiptDate

datetime

Receipt Date

This field shows the date the goods are expected to be received.

ReceiptStatus

int32

Receipt Status

Receipt status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled.

Remarks

string

Remarks

Include any relevant remarks regarding the purchase order.

SalesOrder

guid

Sales Order

Reference to sales order when purchase order generated via back to back sales order.

SalesOrderNumber

int32

Sales Order Number

Number of the sales order.

SelectionCode

guid

 

ID of selection code.

SelectionCodeCode

string

 

Code of selection code.

SelectionCodeDescription

string

 

Description of selection code.

ShippingMethod

guid

Shipping Method

ShippingMethod.

ShippingMethodDescription

string

Shipping Method Description

Description of ShippingMethod.

Source

int16

Source

This shows how the purchase order was created: 1-Manual entry, 2-Import, 3-Other, 4-Purchase order, 5-Sales order, 6-Supplier's items, 7-Subcontract, 8-Purchase order advice, 9-Shop order, 10-MRP calculation.

Supplier

guid

Supplier

Reference to supplier account.

SupplierCode

string(18)

Supplier Code

Code of supplier.

SupplierContact

guid

Supplier Contact Person

Contact of supplier.

SupplierContactPersonFullName

string(240)

Supplier Contact Person Full Name

Contact person full name of supplier.

SupplierName

string(50)

Supplier Name

Name of supplier.

VATAmount

double

VAT Amount

Total VAT amount in the currency of the transaction.

Warehouse

guid

Warehouse

Warehouse.

WarehouseCode

string

Warehouse Code

Code of Warehouse.

WarehouseDescription

string

Warehouse Description

Description of Warehouse.

YourRef

string(30)

Your Reference

Shows the reference number associated with the purchase order. Enter a description and reference to make the purchase order easier to identify.

 

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