Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

OpenPickLinesitemSerials

Tracks serial details for picked items, ensuring traceability for serialized inventory.

Columns

Name Type Description
OpenPickLinesTransactionId [KEY] Long The unique identifier for the OpenPickLines transaction in the OpenPickLinesitemSerials table. This ID links the serials data to a specific pick line transaction.
FromSerialNumber [KEY] String The starting serial number for the range of serials being processed in the OpenPickLinesitemSerials. This value identifies the first item in the batch for picking.
ToSerialNumber String The ending serial number for the range of serials being processed in the OpenPickLinesitemSerials. This value identifies the last item in the batch for picking.
Finder String The identifier for the entity or process that initiated the pick line operation. This could be used for tracking the origin of the transaction.
PItem String The product item code associated with the pick line transaction. This value links the pick line record to a specific item in the inventory system.
PMovementRequest String The movement request code tied to the pick line transaction, indicating the reason for inventory movement or the associated request.
POrder String The purchase order number that is associated with the pick line. It links the pick line records to specific orders in the system.
POrganization String The code representing the organization within the system that is responsible for the inventory transaction in OpenPickLinesitemSerials.
POrganizationId String The unique identifier of the organization in the database. This value helps to differentiate between different organizations within the SCM system.
PPickSlip String The pick slip number linked to the pick line. This value identifies the document used to pick items for shipment.
PPickWave String The pick wave identifier that associates the pick line with a specific batch or group of items being picked in the system.
PSourceSubinventory String The source subinventory location from where the items are being picked. This refers to the inventory location from which stock is moved.
PTransactionType String The type of transaction being processed in the OpenPickLinesitemSerials, such as a movement, receipt, or shipment.
TransactionId Long The unique transaction ID for the specific entry in the OpenPickLinesitemSerials table. This serves as a reference for tracking the transaction details.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175