JDBC Driver for Exact Online

Build 22.0.8462

StockPositions

Usage information for the operation StockPositions.rsd.

Columns

Name Type Description
TimeStamp Datetime TimeStamp.
CurrentStock Double Number of items in stock.
Division Int Division code.
FreeStock Double Quantity of available stock.
ID [KEY] String Primary Key.
ItemCode String Code of the item.
ItemDescription String Description of the item.
ItemId [KEY] String A guid that is the unique identifier of the item.
PlanningIn Double Number of items that are planned to come in.
PlanningOut Double Number of items that are planned to go out.
ProjectedStock Double The quantity of stock projected given all planned future stock changes.
ReorderPoint Double Quantity of items as an indication of when you need to reorder more stock for the warehouse.
ReservedStock Double The quantity in a back to back order process which is already received from the purchase order, but not yet delivered for the sales order.
UnitCode String Code of item unit.
UnitDescription String Description of the item unit.
Warehouse [KEY] String A guid that is the unique identifier of the warehouse.
WarehouseCode String Code of warehouse.
WarehouseDescription String Description of warehouse.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462