Please enable JavaScript to view this site.

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

PurchaseOrderLinesIncremental

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: RequiredExpanded

View Columns

The columns of the view PurchaseOrderLinesIncremental 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

 

CostCenter

guid

Cost Center

 

CostUnit

guid

Cost Unit

 

Created

datetime

Created

 

Creator

guid

Creator

 

Currency

string

Currency

 

DeliveryAccount

guid

Delivery Account

 

DeliveryAddress

guid

Delivery Address

 

DeliveryContact

guid

Delivery Contact Person

 

Description

string

Description

 

Discount

double

Discount

 

Division

int32

Division

 

Document

guid

Document

 

DropShipment

boolean

Drop Shipment

 

ExchangeRate

double

Exchange Rate

 

Expense

guid

Expense

 

ID

guid

ID

 

IncotermAddress

string

 

 

IncotermCode

string

 

 

IncotermVersion

int16

 

 

InvoicedQuantity

double

Invoiced Quantity

 

InvoiceStatus

int32

Invoice Status

 

Item

guid

Item

 

LineNumber

int32

Line Number

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

NetPrice

double

Net Price

 

Notes

string

Notes

 

OrderDate

datetime

Order Date

 

OrderNumber

int32

Order Number

 

OrderStatus

int32

Order Status

 

PaymentCondition

string

Payment Condition

 

Project

guid

Project

 

PurchaseAgent

guid

Purchase Agent

 

PurchaseOrderID

guid

Purchase Order ID

 

Quantity

double

Quantity

 

QuantityInPurchaseUnits

double

Quantity in Purchase Units

 

Rebill

boolean

Rebill

 

ReceiptDate

datetime

Receipt Date

 

ReceiptStatus

int32

Receipt Status

 

ReceivedQuantity

double

Received Quantity

 

Remarks

string

Remarks

 

SalesOrder

guid

Sales Order

 

SalesOrderLine

guid

Sales Order Line

 

SelectionCode

guid

Selection Code

 

SendingMethod

int32

Sending Method

 

ShippingMethod

guid

Shipping Method

 

Source

int16

Source

 

Supplier

guid

Supplier

 

Timestamp

int64

Timestamp

 

Unit

string

Unit

 

UnitPrice

double

Unit Price

 

VATAmount

double

VAT Amount

 

VATCode

string

VAT Code

 

VATPercentage

double

VAT Percentage

 

Warehouse

guid

Warehouse

 

YourRef

string

Your Reference

 

 

15-06-2022 19:32 Version 22.0.232-PROD+3445