JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9175

InterfacedPickTransactionsserials

Tracks serial numbers in interfaced pick transactions for serial-controlled items.

Columns

Name Type Description
InterfacedPickTransactionsTransactionInterfaceId [KEY] Long A system-generated identifier that uniquely links an interfaced pick-confirm transaction to its corresponding transaction record in the InterfacedPickTransactionsserials table. This identifier is essential for tracking and managing serial-controlled transactions within Oracle SCM.
FromSerialNumber [KEY] String The starting serial number in a sequential range for a serial-controlled item within the pick-confirm transaction. This serial number is used to track and manage serialized inventory, ensuring accurate traceability and compliance with serial control policies.
ToSerialNumber String The ending serial number in a sequential range for a serial-controlled item within the pick-confirm transaction. This serial number defines the last serial in the range, supporting validation and efficient management of serialized inventory movements.
Finder String The lookup reference used to identify and retrieve interfaced pick-confirm transactions within the system. This reference facilitates efficient searching, tracking, and reconciliation of serial-controlled transactions in Oracle SCM.
TransactionInterfaceId Long The unique identifier assigned to the interfaced pick-confirm transaction, ensuring accurate integration, tracking, and validation of serial-controlled inventory transactions within Oracle SCM.

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