invantive documentation
Invantive Support ForumsLog In / Sign Up

GoodsDeliveryLineSerialNumbers: Exact Online Goods Delivery Line Serial Numbers

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: SalesOrder
  • Primary Keys: ID
  • Label: Goods Delivery 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}/salesorder/GoodsDeliveryLines?$select=ID,Created,CreatorFullName,DeliveryDate,Description,Division,EntryID,Item,ItemCode,ItemDescription,LineNumber,Modified,Modifier,ModifierFullName,Notes,QuantityDelivered,QuantityOrdered,SalesOrderLineID,SalesOrderLineNumber,SalesOrderNumber,SerialNumbers,StorageLocation,StorageLocationCode,StorageLocationDescription,TrackingNumber,Unitcode&$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 GoodsDeliveryLineSerialNumbers 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, 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
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
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: