Please enable JavaScript to view this site.

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

StockPositionsIncremental: Exact Online Stock Positions (Incremental)

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

Label: Stock Positions (Incremental)

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 StockPositionsIncremental are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CurrentStock

double

 

 

Division

int32

Division

 

FreeStock

double

 

 

ID

guid

ID

 

ItemId

guid

 

 

PlanningIn

double

 

 

PlanningOut

double

 

 

ProjectedStock

double

Projected Stock

 

ReorderPoint

double

 

 

ReservedStock

double

 

 

Timestamp

int64

Timestamp

 

UnitCode

string

Unit Code

 

Warehouse

guid

Warehouse

 

 

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