SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF

Manages the lot number details through descriptive flexfields for items that are lot-controlled.

Columns

Name Type SupportedFinders Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long The unique identifier for the transaction in the receiving receipt transaction requests interface, associated with the specific transaction request entry in the ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF table.
LotitemlotsLotNumber [KEY] String The lot number associated with the item in the receiving receipt transaction request. This is a unique identifier for the lot being processed.
TransactionInterfaceId [KEY] Long The identifier for the transaction interface used to track the transaction details within the system, specific to the ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF.
LotNumber [KEY] String The unique lot number for the item in question. This is used to track the item within the warehouse under lot control.
_FLEX_Context String The context name for the descriptive flexfield that provides additional details for lots, applicable when the item is placed under lot control within the warehouse.
_FLEX_Context_DisplayValue String The display value for the descriptive flexfield context name, used in the user interface when the item is under lot control in the warehouse.
DocumentNumber String FindByTransactionAttributes The document number associated with the receiving receipt transaction, used to track and identify the document in the system.
ExternalSystemTransactionReference String FindByTransactionAttributes A reference identifier used for cross-referencing the transaction with an external system's records.
Finder String A reference used to locate or identify specific records in the ReceivingReceiptTransactionRequestslotItemLotslotNumbersDFF table based on given search criteria.
FromDate Datetime FindByTransactionAttributes The start date for the transaction or receipt activity, marking when the transaction or receipt is valid or initiated.
GroupId Long FindByTransactionAttributes The identifier for a specific group of related transactions or records, used to categorize multiple entries that are processed together in the system.
InterfaceTransactionId Long PrimaryKey A unique identifier for the transaction within the system interface, used to track the transaction across various modules.
ItemId String FindByTransactionAttributes The unique identifier for the item involved in the receiving receipt transaction, used to associate the item with its transaction record.
ItemNumber String FindByTransactionAttributes The specific item number associated with the transaction or receipt, used to uniquely identify the item within the inventory or order system.
OrganizationCode String FindByTransactionAttributes The code used to identify the organization responsible for processing the transaction or managing the inventory in which the item resides.
OrganizationId String FindByTransactionAttributes A unique identifier for the organization within the system, linked to the specific organization handling the transaction.
POHeaderId Long FindByTransactionAttributes The identifier for the purchase order header that this receiving receipt transaction is linked to, representing the purchase order under which the item was requested.
ProcessingStatusCode String FindByTransactionAttributes A code indicating the current processing status of the receiving receipt transaction, helping to track whether the transaction is pending, completed, or in another stage.
ReceiptAdviceHeaderId Long FindByTransactionAttributes The identifier for the receipt advice header, linked to the receipt advice document associated with the receiving transaction.
RMANumber String FindByTransactionAttributes The Return Merchandise Authorization (RMA) number, if applicable, for tracking the return of items through the system.
ShipmentHeaderId Long FindByTransactionAttributes The identifier for the shipment header associated with the transaction, used to link the receipt with the corresponding shipment.
ShipmentNumber String FindByTransactionAttributes The unique number assigned to the shipment in which the item is received or processed, providing a reference to the shipment logistics.
SourceDocumentCode String FindByTransactionAttributes The code associated with the source document from which the receiving receipt transaction originates, used for cross-referencing between documents.
ToDate Datetime FindByTransactionAttributes The end date for the transaction or receipt activity, marking when the transaction or receipt is no longer valid or when the action is completed.
TransactionStatusCode String FindByTransactionAttributes A code representing the current status of the transaction, used to determine whether the transaction is completed, pending, or in error.
TransactionType String FindByTransactionAttributes The type of transaction being processed, such as receiving, shipping, or return, used to categorize the nature of the transaction in the system.
TransferOrderHeaderId Long FindByTransactionAttributes The identifier for the transfer order header, which ties the receiving receipt transaction to the transfer order under which the item is moved.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770