CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ReceivingReceiptTransactionRequestsserialItemSerialsserialAttributesDFF

Manages serial attributes via descriptive flexfields for items controlled by both lot and serial management.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long The unique identifier for the transaction in the ReceivingReceiptTransactionRequests interface table. This identifier is crucial for tracking and processing the transaction request.
SerialitemserialsFromSerialNumber [KEY] String The starting serial number associated with the serial item. This value helps identify the range of serial numbers involved in the receiving process.
TransactionInterfaceId [KEY] Long The identifier linking the transaction to the receiving receipt transaction interface. This ID is used for mapping transactions to external systems or to other parts of the system.
FromSerialNumber [KEY] String The serial number from which the item is being processed or transferred. This serial number is used to track the item during its movement or receiving process.
_FLEX_Context String The context for the descriptive flexfield associated with serial attributes. It is used to capture additional information required by the warehouse when the item is under lot and serial control.
_FLEX_Context_DisplayValue String The display value of the descriptive flexfield context for serial attributes. This value is used for better visualization and understanding of the flexfield context in the warehouse system.
DocumentNumber String The document number related to the receiving receipt transaction request. This value is essential for tracking and referencing the specific document within the system.
ExternalSystemTransactionReference String A reference to the transaction in an external system. This field allows the system to link the transaction with an external process or system for further integration.
Finder String A search or identifier string that helps locate specific transaction requests in the receiving receipt system. This field is useful for querying specific requests by criteria.
FromDate Datetime The starting date for the receiving transaction. This timestamp is used to determine when the transaction started and helps track the process duration.
GroupId Long A unique identifier for a group of transactions. This ID is useful when handling multiple related transactions or grouping items for processing.
InterfaceTransactionId Long An identifier for the transaction in the interface system. This helps to map the internal transaction with its corresponding entry in the external interface system.
ItemId String The unique identifier for the item being processed. This ID is used to track the item throughout the receiving process and link it to relevant records in the system.
ItemNumber String The item number associated with the receiving transaction. It is used to identify the specific item within a larger catalog or inventory system.
OrganizationCode String The code representing the organization handling the receiving receipt transaction. This helps track which organizational unit the transaction belongs to.
OrganizationId String The unique identifier for the organization responsible for the transaction. This ID is crucial for managing cross-organizational transactions and data.
POHeaderId Long The purchase order header ID related to the transaction. This ID helps link the receiving transaction to its corresponding purchase order.
ProcessingStatusCode String The status code representing the current processing state of the receiving transaction. This value is used for tracking and reporting the transaction’s progress.
ReceiptAdviceHeaderId Long The identifier for the receipt advice associated with the transaction. This ID is used to link the receipt advice with the receiving receipt transaction.
RMANumber String The return material authorization (RMA) number related to the transaction. This number is essential for managing returns or exchanges in the system.
ShipmentHeaderId Long The identifier for the shipment header associated with the receiving transaction. It helps track the shipment that the transaction is related to.
ShipmentNumber String The number identifying the specific shipment for the receiving transaction. This number is used for shipment tracking and process flow integration.
SourceDocumentCode String The code referencing the original document that initiated the transaction. This is used for tracing the transaction back to its source for verification or audit purposes.
ToDate Datetime The ending date for the receiving transaction. This timestamp is used to track when the transaction ended and calculate the duration of the process.
TransactionStatusCode String The status code of the transaction. This value is used to track the transaction’s current state (e.g., pending, completed, error) and is essential for reporting.
TransactionType String The type of transaction being processed, such as receiving, return, or adjustment. This helps categorize the transaction for reporting and processing purposes.
TransferOrderHeaderId Long The identifier for the transfer order header associated with the receiving transaction. This ID links the transaction to a specific transfer order for inventory movement.

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