Please enable JavaScript to view this site.

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

StorageLocationStockPositionsIncremental: Exact Online Storage Location Stock Positions

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

Label: Storage Location Stock Positions

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

Name

Data Type

Label

Required

Documentation

Division

int32

Division

 

ID

guid

ID

 

Item

guid

Item

 

Stock

double

Stock

 

StorageLocation

guid

Storage Location

 

Timestamp

int64

Timestamp

 

UnitCode

string

Unit Code

 

Warehouse

guid

Warehouse

 

 

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