Please enable JavaScript to view this site.

Exact Online API Data Model

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

SalesOrderLinesIncremental

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

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.

Field Selection Method: NotRequired

View Columns

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

Name

Data Type

Label

Required

Documentation

AmountDC

double

Amount Division Currency

Amount in the default currency of the company.

AmountDiscount

double

Amount Discount

Discount amount in the default currency of the company.

AmountDiscountExclVat

double

Amount Discount excluding VAT

Discount amount excluding VAT in the default currency of the company.

AmountFC

double

Amount Foreign Currency

Amount in the currency of the transaction.

AmountFCExclVat

double

Amount Foreign Currency excluding VAT

Amount exclude VAT in the currency of the transaction.

ApprovalStatus

int16

Approval Status

Shows if this sales order is approved.

Approved

datetime

Approved

Approval date/time.

Approver

guid

Approver

User who approved the sales order.

CostCenter

string(8)

Cost Center

Reference to Cost Center.

CostPriceFC

double

Cost Price Foreign Currency

Item cost price.

CostUnit

string(8)

Cost Unit

Reference to Cost Unit.

Created

datetime

Created

 

Creator

guid

Creator

User ID of creator.

Currency

string

Currency

Currency code.

CustomerItemCode

string

 

Code the customer uses for this item.

DeliverTo

guid

Deliver to

Reference to the delivery customer. For an existing sales order this value can not be changed.

DeliverToContactPerson

guid

Deliver to Contact Person

Reference to contact person of delivery customer.

DeliveryAddress

guid

Delivery Address

Delivery address.

DeliveryDate

datetime

Delivery Date

Delivery date of this line.

DeliveryStatus

int16

Delivery Status

Shipping status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=Cancelled.

Description

string

Description

Description.

Discount

double

Discount

Discount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item.

Division

int32

Division

Division code.

Document

guid

Document

Document that is manually linked to the sales order.

ID

guid

ID

Primary key.

InvoiceStatus

int16

Invoice Status

Invoice status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=Cancelled.

InvoiceTo

guid

Invoice to

Reference to the customer who will receive the invoice. For an existing sales order this value can not be changed.

InvoiceToContactPerson

guid

Invoice to Contact Person

Reference to the contact person of the customer who will receive the invoice.

Item

guid

Item

Reference to the Item that is sold in this sales order line.

ItemVersion

guid

Item Version

Version of item.

LineNumber

int32

Line Number

Line number.

Modified

datetime

Modified

 

Modifier

guid

Modifier

User ID of modifier.

NetPrice

double

Net Price

Net price of the sales order line.

Notes

string

Notes

Extra notes.

OrderDate

datetime

Order Date

Order date.

OrderedBy

guid

Ordered by

Customer who ordered the sales order. For an existing sales order this value can not be changed.

OrderedByContactPerson

guid

Ordered by Contact Person

Contact person of the customer who ordered the sales order.

OrderID

guid

Order ID

Reference to Sales Order. All the lines of a sales order have the same OrderID.

OrderNumber

int32

Order Number

Number of sales order.

PaymentCondition

string(2)

Payment Condition

The payment condition used for due date and discount calculation.

PaymentReference

string(60)

Payment Reference

Payment reference for sales order.

Pricelist

guid

Price List

Reference to Price List.

Project

guid

Project

Reference to Project. The project can be different per line. Sometimes also the project in the header is filled although this is not really used.

PurchaseOrder

guid

Purchase Order

Reference to Purchase Order.

PurchaseOrderLine

guid

Purchase Order Line

Reference to Purchase Order Line.

Quantity

double

Quantity

Number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor.

QuantityDelivered

double

Quantity Delivered

The number of items delivered.

QuantityInvoiced

double

Quantity Invoiced

The number of items invoiced.

Remarks

string

Remarks

 

Salesperson

guid

Sales Person

Reference to sales person.

SelectionCode

guid

 

Reference to selection code.

ShippingMethod

guid

Shipping Method

Reference to shipping method code.

ShopOrder

guid

Shop Order

Reference to Shop Order.

Status

int16

Status

The status of the sales order. 12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled.

Timestamp

int64

 

 

UnitCode

string(8)

Unit Code

Code of item unit.

UnitPrice

double

Unit Price

Price per unit in the currency of the transaction.

UseDropShipment

int16

Use Drop Shipment

Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler).

VATAmount

double

VAT Amount

VAT amount in the currency of the transaction.

VATCode

string(3)

VAT Code

VAT code.

WarehouseID

guid

Warehouse ID

Reference to warehouse.

YourRef

string

Your Reference

Reference number of the customer.

 

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