CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptTransactionRequestsDFF

Handles descriptive flexfields for managing metadata related to receipt transactions.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long Unique identifier for the transaction in the ReceivingReceiptTransactionRequestsDFF interface table.
InterfaceTransactionId [KEY] Long Identifier for the transaction in the interface table of the ReceivingReceiptTransactionRequestsDFF schema.
_FLEX_Context String Context name for descriptive flexfields related to receipt transaction requests, used to capture additional metadata.
_FLEX_Context_DisplayValue String Human-readable display name of the context for descriptive flexfields associated with receipt transaction requests.
DocumentNumber String Document number associated with the receipt transaction request in the ReceivingReceiptTransactionRequestsDFF table.
ExternalSystemTransactionReference String Reference identifier for the transaction originating from an external system, associated with the receipt transaction request.
Finder String Reference to the finder or search term used to identify the receipt transaction requests in the system.
FromDate Datetime Start date for the time period associated with the receipt transaction request in the ReceivingReceiptTransactionRequestsDFF table.
GroupId Long Identifier for the group to which the receipt transaction request belongs within the ReceivingReceiptTransactionRequestsDFF table.
ItemId String Unique identifier for the item involved in the receipt transaction request.
ItemNumber String Number or code identifying the item related to the receipt transaction request, often used for inventory tracking.
OrganizationCode String Code representing the organization to which the receipt transaction request is associated in the system.
OrganizationId String Unique identifier for the organization linked to the receipt transaction request in the database.
POHeaderId Long Identifier for the purchase order header related to the receipt transaction request, linking it to procurement data.
ProcessingStatusCode String Code indicating the current processing status of the receipt transaction request, used to track its progress.
ReceiptAdviceHeaderId Long Unique identifier for the receipt advice header, which provides additional details for the receipt transaction request.
RMANumber String Return merchandise authorization number associated with the receipt transaction request, often used for returned goods processing.
ShipmentHeaderId Long Identifier for the shipment header associated with the receipt transaction request, linking it to logistics data.
ShipmentNumber String Shipment number related to the receipt transaction request, used for tracking the movement of goods.
SourceDocumentCode String Code that identifies the source document (for example, invoice, order) from which the receipt transaction request originated.
ToDate Datetime End date for the time period associated with the receipt transaction request in the ReceivingReceiptTransactionRequestsDFF table.
TransactionStatusCode String Code indicating the status of the transaction, such as pending, completed, or canceled.
TransactionType String Type of transaction (for example, receipt, return, adjustment) associated with the receipt transaction request.
TransferOrderHeaderId Long Identifier for the transfer order header related to the receipt transaction request, indicating the origin and destination of goods.

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