CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ReceivingReceiptTransactionRequestsserialItemSerialsserialNumbersDFF

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

Columns

Name Type 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 A unique identifier for the document associated with the receiving receipt transaction request, providing a reference for the transaction details.
ExternalSystemTransactionReference String 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 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 An identifier for the group to which the receiving receipt transaction belongs, helping in categorizing related transactions.
InterfaceTransactionId Long A unique identifier assigned to each transaction within the interface for serial item serials and serial numbers in the receiving receipt system.
ItemId String The identifier for the item involved in the receiving receipt transaction, linked to serial numbers and tracked for inventory management.
ItemNumber String A unique number associated with the item in the receiving receipt transaction request, used for identifying the item in inventory systems.
OrganizationCode String The code representing the organization under which the receiving receipt transaction request is processed, used for organizational identification.
OrganizationId String The unique identifier for the organization associated with the receiving receipt transaction request, linking it to the organizational structure.
POHeaderId Long The identifier for the purchase order header related to the receiving receipt transaction, indicating the source of the items in the transaction.
ProcessingStatusCode String The current processing status of the transaction, indicating whether the transaction is pending, completed, or requires further action.
ReceiptAdviceHeaderId Long An identifier for the receipt advice header associated with the receiving receipt transaction request, used for tracking receipt notifications.
RMANumber String The Return Merchandise Authorization (RMA) number associated with the transaction, which is used for processing returns in the receiving system.
ShipmentHeaderId Long The unique identifier for the shipment header, linked to the receiving receipt transaction request and used to track the shipment of goods.
ShipmentNumber String The shipment number associated with the receiving receipt transaction request, identifying the specific shipment involved.
SourceDocumentCode String A code representing the source document that generated the receiving receipt transaction request, used for tracing the origin of the transaction.
ToDate Datetime The end date for the receiving receipt transaction request, used to define the period during which the transaction is valid or processed.
TransactionStatusCode String The status code of the transaction, providing information about its current stage (for example, pending, completed) within the receiving receipt process.
TransactionType String The type of transaction being processed, such as receipt, return, or transfer, for the receiving receipt transaction request involving serial items.
TransferOrderHeaderId Long The identifier for the transfer order header related to the receiving receipt transaction, linking the transaction to an inventory transfer process.

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