invantive documentation
Invantive Support ForumsLog In / Sign Up

GoodsDeliveryLineBatchNumbers: Exact Online Goods Delivery Line Batch Numbers

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: SalesOrder
  • Primary Keys: ID
  • Label: Goods Delivery Line Batch Numbers

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

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/salesorder/GoodsDeliveryLines?$select=ID,Created,CreatorFullName,DeliveryDate,Description,Division,EntryID,Item,ItemCode,ItemDescription,LineNumber,Modified,Modifier,ModifierFullName,Notes,QuantityDelivered,QuantityOrdered,SalesOrderLineID,SalesOrderLineNumber,SalesOrderNumber,BatchNumbers,StorageLocation,StorageLocationCode,StorageLocationDescription,TrackingNumber,Unitcode&$expand=BatchNumbers

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 7,200
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table GoodsDeliveryLineBatchNumbers 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
BnrBatchNumber varchar2 Batch Number writable, BatchNumber
BnrBatchNumberID guid Batch Number ID writable, BatchNumberID
BnrCreated datetime Created writable, Created
BnrCreator guid Creator writable, Creator
BnrCreatorFullName varchar2 Creator Full name writable, CreatorFullName
BnrDivision int32 Division writable, Division
BnrDraftStockTransactionID guid itgen_eol_bnrdraftstocktransactionid writable, DraftStockTransactionID
BnrEndDate datetime End Date writable, EndDate
BnrID guid Batch Number ID writable, ID
BnrIsBlocked int16 Is Blocked writable, IsBlocked
BnrIsDraft int16 Is Draft writable, IsDraft
BnrItem guid Item writable, Item
BnrItemCode varchar2 Item Code writable, ItemCode
BnrItemDescription varchar2 Item Description writable, ItemDescription
BnrModified datetime Modified writable, Modified
BnrModifier guid Modifier writable, Modifier
BnrModifierFullName varchar2 Modified Full Name writable, ModifierFullName
BnrQuantity double Quantity writable, Quantity
BnrRemarks varchar2 Remarks writable, Remarks
BnrStockCountLine guid Stock Count Line writable, StockCountLine
BnrStockTransactionID guid itgen_eol_bnrstocktransactionid writable, StockTransactionID
BnrStockTransactionType int32 itgen_eol_bnrstocktransactiontype writable, StockTransactionType
BnrStorageLocation guid Storage Location writable, StorageLocation
BnrStorageLocationCode varchar2 itgen_eol_bnrstoragelocationcode writable, StorageLocationCode
BnrWarehouse guid Warehouse writable, Warehouse
BnrWarehouseCode varchar2 Warehouse Code writable, WarehouseCode
Created datetime Created filters on the platform, writable, ::ancestor.::ancestor.Created
Creator guid Creator filters on the platform, writable, ::ancestor.::ancestor.Creator
CreatorFullName varchar2 Creator Full Name filters on the platform, writable, ::ancestor.::ancestor.CreatorFullName
DeliveryDate datetime Delivery Date filters on the platform, writable, ::ancestor.::ancestor.DeliveryDate
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
EntryID guid Entry ID filters on the platform, writable, ::ancestor.::ancestor.EntryID
ID guid ID filters on the platform, writable, ::ancestor.::ancestor.ID
Item guid Item filters on the platform, writable, ::ancestor.::ancestor.Item
ItemCode varchar2 Item Code filters on the platform, writable, ::ancestor.::ancestor.ItemCode
ItemDescription varchar2 Item Description filters on the platform, writable, ::ancestor.::ancestor.ItemDescription
LineNumber int32 Line Number filters on the platform, writable, ::ancestor.::ancestor.LineNumber
Modified datetime Modified filters on the platform, writable, ::ancestor.::ancestor.Modified
Modifier guid Modifier filters on the platform, writable, ::ancestor.::ancestor.Modifier
ModifierFullName varchar2 Modified Full Name filters on the platform, writable, ::ancestor.::ancestor.ModifierFullName
Notes varchar2 Notes filters on the platform, writable, ::ancestor.::ancestor.Notes
QuantityDelivered double Quantity Delivered filters on the platform, writable, ::ancestor.::ancestor.QuantityDelivered
QuantityOrdered double Quantity Ordered filters on the platform, writable, ::ancestor.::ancestor.QuantityOrdered
SalesOrderLineID guid Sales Order Line ID filters on the platform, writable, ::ancestor.::ancestor.SalesOrderLineID
SalesOrderLineNumber int32 Sales Order Line Number filters on the platform, writable, ::ancestor.::ancestor.SalesOrderLineNumber
SalesOrderNumber int32 Sales Order Number filters on the platform, writable, ::ancestor.::ancestor.SalesOrderNumber
StorageLocation guid Storage Location filters on the platform, writable, ::ancestor.::ancestor.StorageLocation
TrackingNumber varchar2 Tracking Number filters on the platform, writable, ::ancestor.::ancestor.TrackingNumber
Unitcode varchar2 Unit Code filters on the platform, writable, ::ancestor.::ancestor.Unitcode

Release Notes

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