invantive documentation
Invantive Support ForumsLog In / Sign Up

GoodsReceiptLineBatchNumbers: Exact Online Goods Receipt Line Batch Numbers

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: PurchaseOrder
  • Primary Keys: ID
  • Label: Goods Receipt 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}/purchaseorder/GoodsReceiptLines?$select=Created,Creator,CreatorFullName,Description,Division,GoodsReceiptID,ID,Item,ItemCode,ItemDescription,ItemUnitCode,LineNumber,Location,LocationCode,LocationDescription,Modified,Modifier,ModifierFullName,Notes,Project,ProjectCode,ProjectDescription,PurchaseOrderID,PurchaseOrderLineID,PurchaseOrderNumber,QuantityOrdered,QuantityReceived,SupplierItemCode,BatchNumbers&$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 GoodsReceiptLineBatchNumbers 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
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
GoodsReceiptID guid Goods Receipt ID filters on the platform, writable, ::ancestor.::ancestor.GoodsReceiptID
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
ItemUnitCode varchar2 Item Unit Code filters on the platform, writable, ::ancestor.::ancestor.ItemUnitCode
LineNumber int32 Line Number filters on the platform, writable, ::ancestor.::ancestor.LineNumber
Location guid Location filters on the platform, writable, ::ancestor.::ancestor.Location
LocationCode varchar2 Location Code filters on the platform, writable, ::ancestor.::ancestor.LocationCode
LocationDescription varchar2 Location Description filters on the platform, writable, ::ancestor.::ancestor.LocationDescription
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
Project guid Project filters on the platform, writable, ::ancestor.::ancestor.Project
ProjectCode varchar2 Project Code filters on the platform, writable, ::ancestor.::ancestor.ProjectCode
ProjectDescription varchar2 Project Description filters on the platform, writable, ::ancestor.::ancestor.ProjectDescription
PurchaseOrderID guid Purchase Order ID filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderID
PurchaseOrderLineID guid Purchase Order Line ID filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderLineID
PurchaseOrderNumber int32 Purchase Order Number filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderNumber
QuantityOrdered double Quantity Ordered writable, ::ancestor.::ancestor.QuantityOrdered
QuantityReceived double Quantity Receveid writable, ::ancestor.::ancestor.QuantityReceived
SupplierItemCode varchar2 Supplier Item Code filters on the platform, writable, ::ancestor.::ancestor.SupplierItemCode

Release Notes

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