ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryStagedTransactionsserials

Handles the management of serial numbers associated with staged inventory transactions for serial-controlled items.

Columns

Name Type Description
InventoryStagedTransactionsTransactionInterfaceId [KEY] Long The unique identifier for the transaction interface record associated with the staged inventory transaction. This identifier ensures that serialized inventory transactions are correctly linked within the system.
TransactionInterfaceId [KEY] Long The unique identifier for the staged inventory transaction. This identifier helps track and manage serialized inventory movements.
FmSerialNumber [KEY] String The starting serial number in a range of serial numbers assigned to items within the inventory transaction. This serial number ensures accurate traceability of serialized inventory.
ToSerialNumber String The ending serial number in a range of serial numbers assigned to items within the inventory transaction. This serial number helps track serialized inventory efficiently in bulk transactions.
SourceCode String An abbreviation representing the source of the inventory transaction. This abbreviation helps classify inventory movements based on procurement, manufacturing, or distribution processes.
SourceLineId Long The unique identifier for the source line associated with the inventory transaction. This identifier ensures proper linkage between the transaction and its originating document.
ErrorCode String A system-generated abbreviation representing an error encountered during the inventory transaction. This abbreviation helps in troubleshooting and resolving transaction processing issues.
OriginationDate Date The date when this serialized inventory record was created. This date is essential for tracking inventory history, compliance, and traceability requirements.
StatusId Long The unique identifier for the status of the serialized inventory transaction. This identifier ensures proper tracking of inventory states, such as available, in transit, or on hold.
StatusName String A descriptive name of the current status of the serialized inventory transaction. This descriptive name provides meaningful insight into the inventory condition.
StatusCode String A system-generated abbreviation representing the current status of the serialized inventory transaction. This abbreviation helps in categorizing inventory for reporting and operational control.
Finder String A reference attribute used for searching and retrieving specific serialized inventory transaction records. This attribute enhances system usability by allowing users to locate serialized inventory transactions based on predefined criteria.

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