Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

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

SalesOrdersExploded: Exact Online Sales Orders (Exploded Structure)

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: SalesOrder

Primary Keys: SolID

Label: Sales Orders (Exploded Structure)

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

This is a read-only view. 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}/salesorder/SalesOrders?$expand=SalesOrderLines

Insert Exact Online API URL: /api/v1/{division}/salesorder/SalesOrders?$expand=SalesOrderLines

Update Exact Online API URL: /api/v1/{division}/salesorder/SalesOrders?$expand=SalesOrderLines

Delete Exact Online API URL: /api/v1/{division}/salesorder/SalesOrders?$expand=SalesOrderLines

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

Field Selection Method: NotRequired

Base Path: SalesOrderLines.results[*]

View Columns

The columns of the view SalesOrdersExploded are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

AmountDC

double

Amount Division Currency

 

AmountFC

double

Amount Foreign Currency

 

ApprovalStatus

int16

Approval Status

 

ApprovalStatusDescription

string

 

 

Approved

datetime

Approved

 

Approver

guid

Approver

 

ApproverFullName

string

Approver Full Name

 

Created

datetime

Created

 

Creator

guid

Creator

 

CreatorFullName

string

Creator Full Name

 

Currency

string

Currency

 

DeliverTo

guid

Deliver to

 

DeliverToContactPerson

guid

Deliver to Contact Person

 

DeliverToContactPersonFullName

string

Deliver To Contact Person Full Name

 

DeliverToName

string

Deliver to Name

 

DeliveryAddress

guid

Delivery Address

 

DeliveryDate

datetime

Delivery Date

 

DeliveryStatus

int16

Delivery Status

 

DeliveryStatusDescription

string

Delivery Status Description

 

Description

string

Description

 

Division

int32

Division

 

Document

guid

Document

 

DocumentNumber

int32

Document Number

 

DocumentSubject

string

Document Subject

 

InvoiceStatus

int16

Invoice Status

 

InvoiceStatusDescription

string

Invoice Status Description

 

InvoiceTo

guid

Invoice to

 

InvoiceToContactPerson

guid

Invoice to Contact Person

 

InvoiceToContactPersonFullName

string

Invoice To Contact Person Full Name

 

InvoiceToName

string

Invoice to Name

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

ModifierFullName

string

Modified Full Name

 

OrderDate

datetime

Order Date

 

OrderedBy

guid

Ordered by

 

OrderedByContactPerson

guid

Ordered by Contact Person

 

OrderedByContactPersonFullName

string

Ordered by Contact Person Full Name

 

OrderedByName

string

Ordered by Name

 

OrderID

guid

Order ID

 

OrderNumber

int32

Order Number

 

PaymentCondition

string

Payment Condition

 

PaymentConditionDescription

string

Payment Condition Description

 

PaymentReference

string

Payment Reference

 

Remarks

string

Remarks

 

Salesperson

guid

Sales Person

 

SalespersonFullName

string

Sales Person Full Name

 

ShippingMethod

guid

Shipping Method

 

ShippingMethodDescription

string

Shipping Method Description

 

SolAmountDC

double

 

 

SolAmountFC

double

 

 

SolCostCenter

string

 

 

SolCostCenterDescription

string

 

 

SolCostPriceFC

double

 

 

SolCostUnit

string

 

 

SolCostUnitDescription

string

 

 

SolDeliveryDate

datetime

 

 

SolDescription

string

 

 

SolDiscount

double

 

 

SolDivision

int32

 

 

SolID

guid

 

 

SolItem

guid

 

 

SolItemCode

string

 

 

SolItemDescription

string

 

 

SolItemVersion

guid

 

 

SolItemVersionDescription

string

 

 

SolLineNumber

int32

 

 

SolMargin

double

 

 

SolNetAmountFC

double

 

 

SolNetPrice

double

 

 

SolNotes

string

 

 

SolOrderNumber

int32

 

 

SolPricelist

guid

 

 

SolPricelistDescription

string

 

 

SolProject

guid

 

 

SolProjectDescription

string

 

 

SolQuantity

double

 

 

SolQuantityDelivered

double

 

 

SolQuantityInvoiced

double

 

 

SolShopOrder

guid

 

 

SolTaxSchedule

guid

 

 

SolTaxScheduleCode

string

 

 

SolTaxScheduleDescription

string

 

 

SolUnitCode

string

 

 

SolUnitDescription

string

 

 

SolUnitPrice

double

 

 

SolUseDropShipment

int16

 

 

SolVATAmountFC

double

 

 

SolVATCode

string

 

 

SolVATCodeDescription

string

 

 

SolVATPercentage

double

 

 

Status

int16

Status

 

StatusDescription

string

Status Description

 

TaxSchedule

guid

Tax Schedule

 

TaxScheduleCode

string

Tax Schedule Code

 

TaxScheduleDescription

string

Tax Schedule Description

 

WarehouseCode

string

Warehouse Code

 

WarehouseDescription

string

Warehouse Description

 

WarehouseID

guid

Warehouse ID

 

YourRef

string

Your Reference

 

 

07-11-2021 09:07 Version 20.2.94-PROD+3513