invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseReturnLineSerialNumbers: Exact Online Purchase Return Line Serial Numbers

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: PurchaseOrder
  • Primary Keys: SsrID
  • Label: Purchase Return Line Serial 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,SerialNumbers&$expand=SerialNumbers

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 PurchaseReturnLineSerialNumbers 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
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
SsrCreated datetime Serial Number Created writable, Created
SsrCreator guid Serial Number Creator writable, Creator
SsrCreatorFullName varchar2 Serial Number Creator Full Name writable, CreatorFullName
SsrDivision int32 Serial Number Division writable, Division
SsrDraftStockTransactionID guid itgen_eol_ssrdraftstocktransactionid writable, DraftStockTransactionID
SsrEndDate datetime Serial Number End Date writable, EndDate
SsrID guid Serial Number ID writable, ID
SsrIsBlocked int16 Serial Number Is Blocked writable, IsBlocked
SsrIsDraft int16 Serial Number Is Draft writable, IsDraft
SsrItem guid Serial Number Item writable, Item
SsrItemCode varchar2 Serial Number Item Code writable, ItemCode
SsrItemDescription varchar2 Serial Number Item Description writable, ItemDescription
SsrModified datetime Serial Number Modified writable, Modified
SsrModifier guid Serial Number Modifier writable, Modifier
SsrModifierFullName varchar2 Serial Number Modifier Full name writable, ModifierFullName
SsrRemarks varchar2 Serial Number Remarks writable, Remarks
SsrSerialNumber varchar2 Serial Number writable, SerialNumber
SsrSerialNumberID guid Serial Number ID writable, SerialNumberID
SsrStartDate datetime Serial Number Start Date writable, StartDate
SsrStockCountLine guid Serial Number Stock Count Line writable, StockCountLine
SsrStockTransactionID guid itgen_eol_ssrstocktransactionid writable, StockTransactionID
SsrStockTransactionType int32 itgen_eol_ssrstocktransactiontype writable, StockTransactionType
SsrStorageLocation guid Serial Number Storage Location writable, StorageLocation
SsrStorageLocationCode varchar2 itgen_eol_ssrstoragelocationcode writable, StorageLocationCode
SsrWarehouse guid Serial Number Warehouse writable, Warehouse
SsrWarehouseCode varchar2 Serial Number Warehouse Code writable, WarehouseCode
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: