invantive documentation
Invantive Support ForumsLog In / Sign Up

StockSerialBatchNumbersIncremental: Exact Online Stock Serial Batch Numbers

read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Stock Serial Batch Numbers

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) 187
Full scan rows per minute 50,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table StockSerialBatchNumbersIncremental 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
Created datetime Created filters on the platform
Creator guid Creator filters on the platform
Division int32 Division
DraftStockTransactionLocation guid itgen_eol_draftstocktransactionlocation filters on the platform
DraftTransactionID guid itgen_eol_drafttransactionid filters on the platform
ID guid ID filters on the platform
IsDraft int16 Is Draft filters on the platform
Item guid Item
Modified datetime Modified filters on the platform
Modifier guid Modifier filters on the platform
ParentID guid Parent ID filters on the platform
PickOrderLine guid Pickorder Line filters on the platform
PicklistLine guid Picklist Line filters on the platform
PurchaseTransaction guid Purchase Transaction filters on the platform
Quantity double Quantity filters on the platform
Remarks varchar2 Remarks
SalesOrderLine guid Sales Order Line
SalesReturnLine guid Sales Return Line filters on the platform
SalesTransaction guid Sales Transaction filters on the platform
SerialBatchNumber guid Serial Batch Number filters on the platform
StockCountLine guid Stock Count Line filters on the platform
StockTransactionID guid Stock Transaction ID filters on the platform
StockTransactionLocation guid itgen_eol_stocktransactionlocation filters on the platform
StockTransactionType int32 itgen_eol_stocktransactiontype filters on the platform
StorageLocation guid Storage Location filters on the platform
Timestamp int64 Timestamp filters on the platform
Warehouse guid Warehouse filters on the platform
WarehouseTransferLine guid itgen_eol_warehousetransferline filters on the platform

Release Notes

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