Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptRequestslinestransactionDFF

Manages the descriptive flexfields for additional information related to receipt transaction requests.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long Unique identifier for the header interface record of the receiving receipt requests in the ReceivingReceiptRequestslinestransactionDFF table.
LinesInterfaceTransactionId [KEY] Long Unique identifier for each transaction line within the ReceivingReceiptRequestslinestransactionDFF table, linking it to the header record.
InterfaceTransactionId [KEY] Long A reference ID that connects the transaction in the interface to its corresponding data in the ReceivingReceiptRequestslinestransactionDFF table.
_FLEX_Context String Context name associated with the descriptive flexfield for the receipt line requests, enabling flexible data capture for specific business needs.
_FLEX_Context_DisplayValue String The display value of the descriptive flexfield context for receipt line requests, providing a user-friendly description.
CustomerId Long Unique identifier for the customer associated with the receiving receipt transaction, linking to customer data in other tables.
CustomerPartyName String Name of the customer party in the receiving receipt transaction, reflecting the customer entity in the system.
DocumentNumber String Unique document number associated with the receipt request, often used for tracking and reconciliation purposes.
ExternalSystemTransactionReference String Reference number from an external system that ties the transaction to the originating system, ensuring integration compatibility.
Finder String A custom search key or identifier used to locate or reference the receiving receipt transaction within the system.
FromDate Datetime The starting date of the receipt request, indicating the time frame for the transaction or process being tracked.
FromOrganizationCode String Code representing the originating organization for the receipt transaction, used for identifying which organizational unit initiated the request.
FromOrganizationId Long Unique identifier for the originating organization of the receipt request, providing a reference for internal system linkage.
GroupId Long Identifier for the group of receipt transactions, used to categorize and manage multiple related transactions together.
HeaderInterfaceId Long ID of the header interface record for the receiving receipt transaction, providing a connection to the main transaction record.
ItemId Long Unique identifier for the item involved in the receipt request, used to link the transaction to the specific item in inventory.
ItemNumber String Unique number or code for the item in the system, used for identifying and tracking inventory items during receiving.
OrganizationCode String Code for the organization involved in the receiving receipt transaction, aiding in organizational tracking and reporting.
OrganizationId Long Unique identifier for the organization participating in the transaction, ensuring accurate organization-level tracking.
POHeaderId Long Purchase order header identifier, linking the receipt transaction to a specific purchase order for accurate order processing.
ProcessingStatusCode String Code representing the current processing status of the transaction, such as 'Pending', 'Completed', or 'Error'.
ReceiptAdviceHeaderId Long ID for the receipt advice header record, providing a link to the detailed receipt advice for reconciliation purposes.
RMANumber String Return merchandise authorization number, used when the receipt involves returning goods, linking to the RMA process.
ShipmentHeaderId Long Unique identifier for the shipment header, linking this receipt request to a specific shipment record in the system.
ShipmentNumber String Number assigned to the shipment, used for tracking and identifying the physical shipment associated with the receipt.
SourceDocumentCode String Code that identifies the source document related to the transaction, used for reference and audit purposes.
ToDate Datetime The end date for the receipt transaction, defining the time frame for when the transaction or process is considered complete.
TransactionStatusCode String Code representing the status of the transaction, indicating whether it is active, completed, or in another state.
TransactionType String Type of transaction, such as 'Receipt', 'Return', or 'Exchange', used to categorize different receipt operations.
TransferOrderHeaderId Long Identifier for the transfer order header, linking this receipt request to a specific internal transfer order transaction.
VendorId Long Unique identifier for the vendor associated with the receipt, providing a link to vendor-specific data for procurement processes.
VendorName String Name of the vendor supplying the goods or services for the receipt transaction, used for vendor-related reporting.
VendorNumber String Unique identification number assigned to the vendor, facilitating vendor-specific tracking and management.

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