invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseReturnLineBatchNumbers: Exact Online Purchase Return Line Batch Numbers

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: PurchaseOrder
  • Primary Keys: ID
  • Label: Purchase Return 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/PurchaseReturnLines?$select=CreateCredit,Created,Creator,CreatorFullName,Division,EntryID,GoodsReceiptLineID,ID,Item,ItemCode,ItemDescription,LineNumber,Location,LocationCode,LocationDescription,Modified,Modifier,ModifierFullName,Notes,PurchaseOrderLineID,PurchaseOrderNumber,ReceiptNumber,ReceivedQuantity,ReturnQuantity,ReturnReasonCodeDescription,ReturnReasonCodeID,SupplierItemCode,UnitCode,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 PurchaseReturnLineBatchNumbers 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
CreateCredit char itgen_eol_createcredit filters on the platform, writable, ::ancestor.::ancestor.CreateCredit
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
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
EntryID guid Entry ID filters on the platform, writable, ::ancestor.::ancestor.EntryID
GoodsReceiptLineID guid Goods Receipt Line ID filters on the platform, writable, ::ancestor.::ancestor.GoodsReceiptLineID
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
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
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
ReceiptNumber int32 Receipt Number filters on the platform, writable, ::ancestor.::ancestor.ReceiptNumber
ReceivedQuantity double Received Quantity filters on the platform, writable, ::ancestor.::ancestor.ReceivedQuantity
ReturnQuantity double Return Quantity filters on the platform, writable, ::ancestor.::ancestor.ReturnQuantity
ReturnReasonCodeDescription varchar2 itgen_eol_returnreasoncodedescription filters on the platform, writable, ::ancestor.::ancestor.ReturnReasonCodeDescription
ReturnReasonCodeID guid Return Reason Code ID filters on the platform, writable, ::ancestor.::ancestor.ReturnReasonCodeID
SupplierItemCode varchar2 Supplier Item Code filters on the platform, writable, ::ancestor.::ancestor.SupplierItemCode
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: