ADO.NET Provider for Oracle Fusion Cloud SCM

Build 26.0.9770

ReceivingReceiptTransactionRequestsserialItemSerialsserialNumbersDFF

Oversees detailed serial number management for serial-controlled items using descriptive flexfields.

Columns

Name Type SupportedFinders Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long The unique identifier for the receiving receipt transaction request within the interface, specific to the serial item and serial numbers descriptive flexfield (DFF) context.
SerialitemserialsFromSerialNumber [KEY] String The serial number that initiates the transaction in the context of serial item serials and serial numbers in Receiving Receipt Transaction Requests. This field represents the starting serial number for processing.
TransactionInterfaceId [KEY] Long A unique identifier for the transaction within the interface, specifically linked to serial items and serial numbers in Receiving Receipt Transaction Requests.
FromSerialNumber [KEY] String The original serial number associated with the receiving receipt transaction request in the serial item and serial numbers descriptive flexfield (DFF).
_FLEX_Context String The context for the descriptive flexfield (DFF) used to capture additional attributes related to serials when the item is placed under lot and serial control by the warehouse.
_FLEX_Context_DisplayValue String The display value for the descriptive flexfield (DFF) context, representing the user-friendly label of the serials context in the warehouse system when lot and serial control is applied.
DocumentNumber String FindByTransactionAttributes A unique identifier for the document associated with the receiving receipt transaction request, providing a reference for the transaction details.
ExternalSystemTransactionReference String FindByTransactionAttributes The reference number for the transaction provided by an external system, ensuring traceability of the transaction across different systems.
Finder String A lookup or search criterion used for identifying specific records within the Receiving Receipt Transaction Requests serial item serials and serial numbers descriptive flexfield (DFF).
FromDate Datetime FindByTransactionAttributes The starting date for the receiving receipt transaction request, used to filter or define the time frame of the transaction in serial and item processing.
GroupId Long FindByTransactionAttributes An identifier for the group to which the receiving receipt transaction belongs, helping in categorizing related transactions.
InterfaceTransactionId Long PrimaryKey A unique identifier assigned to each transaction within the interface for serial item serials and serial numbers in the receiving receipt system.
ItemId String FindByTransactionAttributes The identifier for the item involved in the receiving receipt transaction, linked to serial numbers and tracked for inventory management.
ItemNumber String FindByTransactionAttributes A unique number associated with the item in the receiving receipt transaction request, used for identifying the item in inventory systems.
OrganizationCode String FindByTransactionAttributes The code representing the organization under which the receiving receipt transaction request is processed, used for organizational identification.
OrganizationId String FindByTransactionAttributes The unique identifier for the organization associated with the receiving receipt transaction request, linking it to the organizational structure.
POHeaderId Long FindByTransactionAttributes The identifier for the purchase order header related to the receiving receipt transaction, indicating the source of the items in the transaction.
ProcessingStatusCode String FindByTransactionAttributes The current processing status of the transaction, indicating whether the transaction is pending, completed, or requires further action.
ReceiptAdviceHeaderId Long FindByTransactionAttributes An identifier for the receipt advice header associated with the receiving receipt transaction request, used for tracking receipt notifications.
RMANumber String FindByTransactionAttributes The Return Merchandise Authorization (RMA) number associated with the transaction, which is used for processing returns in the receiving system.
ShipmentHeaderId Long FindByTransactionAttributes The unique identifier for the shipment header, linked to the receiving receipt transaction request and used to track the shipment of goods.
ShipmentNumber String FindByTransactionAttributes The shipment number associated with the receiving receipt transaction request, identifying the specific shipment involved.
SourceDocumentCode String FindByTransactionAttributes A code representing the source document that generated the receiving receipt transaction request, used for tracing the origin of the transaction.
ToDate Datetime FindByTransactionAttributes The end date for the receiving receipt transaction request, used to define the period during which the transaction is valid or processed.
TransactionStatusCode String FindByTransactionAttributes The status code of the transaction, providing information about its current stage (for example, pending, completed) within the receiving receipt process.
TransactionType String FindByTransactionAttributes The type of transaction being processed, such as receipt, return, or transfer, for the receiving receipt transaction request involving serial items.
TransferOrderHeaderId Long FindByTransactionAttributes The identifier for the transfer order header related to the receiving receipt transaction, linking the transaction to an inventory transfer process.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770