ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptTransactionRequestsinventoryStripingDFF

Tracks inventory striping attributes such as project, task, and origin country via descriptive flexfields to enhance receipt and transaction tracking.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long The unique identifier for a transaction in the receiving receipt transaction requests interface. It is used to track individual transaction entries in the system.
InterfaceTransactionId [KEY] Long A unique identifier for each transaction, allowing system processes to track and differentiate each transaction. This value is tied to a specific feature that requires user consent to activate.
ProjectId Long A unique identifier for a project, used to associate the transaction with a specific project in the system. This attribute is part of an optional feature.
ProjectId_Display String The display number assigned to the project, serving as a user-friendly identifier. This is tied to an optional feature that requires user consent.
TaskId Long A unique identifier for a task, associated with a specific project or transaction. This field is linked to a feature that is only accessible if the user opts in.
TaskId_Display String The display number assigned to a task, providing an easily identifiable reference to the task within the system. This attribute is also part of an optional feature.
CountryOfOriginCode String A code representing the country where the item was manufactured or produced. This attribute is linked to a feature that requires the user to opt in.
CountryOfOriginCode_Display String The full name of the country of origin for the item. This field is related to an optional feature that requires user consent.
_FLEX_Context String The context name for the descriptive flexfield, specifically used for inventory striping attributes. This attribute is part of a feature that requires opt-in from the user.
_FLEX_Context_DisplayValue String The display value associated with the descriptive flexfield context for inventory striping attributes. It provides a user-friendly label for the context and is part of an optional feature.
DocumentNumber String The document number assigned to the transaction in the ReceivingReceiptTransactionRequestsinventoryStripingDFF table, used for tracking purposes.
ExternalSystemTransactionReference String A reference identifier from an external system, used to correlate transactions across systems. This value is essential for integration with external applications.
Finder String A field used for locating and identifying specific records in the ReceivingReceiptTransactionRequestsinventoryStripingDFF table. It acts as a search key for users.
FromDate Datetime The start date for the transaction, indicating when the transaction or relevant event began. This value is crucial for time-based queries and reports.
GroupId Long An identifier for the group associated with the transaction, used for organizing related transactions or records within the system.
ItemId String A unique identifier for the item involved in the transaction, used to track and reference the item across the system.
ItemNumber String The item number associated with the transaction, providing a reference to a specific item in the inventory system.
OrganizationCode String A code that identifies the organization related to the transaction, used to classify and manage transactions within different organizational contexts.
OrganizationId String A unique identifier for the organization that initiated or received the transaction. This field is critical for transactions involving multiple organizations.
POHeaderId Long The unique identifier for the purchase order header, used to link the transaction to a specific purchase order in the system.
ProcessingStatusCode String A code indicating the current processing status of the transaction, providing insights into its progress within the system.
ReceiptAdviceHeaderId Long The unique identifier for the receipt advice header, linking the transaction to the corresponding receipt advice document in the system.
RMANumber String The Return Material Authorization (RMA) number assigned to the transaction, used to track the return of goods or materials.
ShipmentHeaderId Long The unique identifier for the shipment header, connecting the transaction to a specific shipment record in the system.
ShipmentNumber String The shipment number that identifies a specific shipment related to the transaction, used for logistics and tracking purposes.
SourceDocumentCode String A code representing the source document for the transaction, providing a reference to the original document or record from which the transaction was initiated.
ToDate Datetime The end date for the transaction, indicating when the transaction or relevant event concluded. It is used for time-based filtering and reporting.
TransactionStatusCode String A code representing the current status of the transaction, used to track whether it is in progress, completed, or requires further action.
TransactionType String The type of transaction being processed, such as receipt, return, or exchange, providing clarity on the nature of the transaction.
TransferOrderHeaderId Long The unique identifier for the transfer order header, used to link the transaction to a specific transfer order in the system.

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