invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesOrderLinesV2Incremental: Exact Online Sales Order Lines

popular read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Sales Order Lines

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

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 191
Full scan rows per minute 68,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table SalesOrderLinesV2Incremental 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 and update.

Name Data Type Label Required Marks Documentation
AmountDC double Amount Division Currency filters on the platform
AmountFC double Amount Foreign Currency filters on the platform
CostCenter varchar2 Cost Centre filters on the platform
CostPriceFC double Cost Price Foreign Currency filters on the platform
CostUnit varchar2 Cost Unit filters on the platform
Created datetime Created filters on the platform
Creator guid Creator filters on the platform
DeliveryDate datetime Delivery Date filters on the platform
DeliveryStatus int16 Delivery Status filters on the platform
Description varchar2 Description filters on the platform
Discount double Discount filters on the platform
Division int32 Division
ID guid ID filters on the platform
InvoiceStatus int16 Invoice Status filters on the platform
Item guid Item filters on the platform
ItemVersion guid Item Version filters on the platform
LineNumber int32 Line Number filters on the platform
Margin double Margin filters on the platform
Modified datetime Modified filters on the platform
Modifier guid Modifier filters on the platform
NetPrice double Net Price filters on the platform
Notes varchar2 Notes filters on the platform
OrderID guid Order ID filters on the platform
Pricelist guid Price List filters on the platform
Project guid Project filters on the platform
PurchaseOrder guid Purchase Order filters on the platform
PurchaseOrderLine guid Purchase Order Line filters on the platform
Quantity double Quantity filters on the platform
QuantityDelivered double Quantity Delivered
QuantityInvoiced double Quantity Invoiced
ShopOrder guid Shop Order filters on the platform
Status int16 Status filters on the platform
Timestamp int64 Timestamp filters on the platform
UnitCode varchar2 Unit Code filters on the platform
UnitPrice double Unit Price filters on the platform
UseDropShipment int16 Use Drop Shipment filters on the platform
VATAmount double VAT Amount filters on the platform
VATCode varchar2 VAT Code filters on the platform
VATPercentage double VAT Percentage filters on the platform

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: