Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptRequestslineslotItemLotslotAttributesDFF

Supports descriptive flexfields for lot attributes linked to non-serial-controlled items, enabling customization.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long Unique identifier for the header interface in the Receiving Receipt Requests schema, representing the source or origin of the receiving receipt transaction.
LinesInterfaceTransactionId [KEY] Long Unique identifier for the transaction associated with the lines in the Receiving Receipt Requests schema, linking specific line items to the transaction.
LotitemlotsLotNumber [KEY] String Alphanumeric code representing the lot number associated with item lots, used to track and manage inventory at the lot level.
TransactionInterfaceId [KEY] Long Unique identifier for the transaction interface within the Receiving Receipt Requests schema, representing the specific transaction linked to the receipt request.
LotNumber [KEY] String The lot number used to identify and track specific inventory lots within the receiving receipt request process.
_FLEX_Context String The name of the descriptive flexfield context associated with lot attributes, which is relevant when items are managed under lot and serial control in a warehouse.
_FLEX_Context_DisplayValue String The display value for the descriptive flexfield context, providing a user-friendly description for the lot attributes under lot and serial control in a warehouse.
CustomerId Long Unique identifier for the customer associated with the receiving receipt request, representing the customer for whom the goods are being received.
CustomerPartyName String The name of the customer or customer party involved in the receiving receipt request, typically the entity receiving the goods.
DocumentNumber String The unique identifier for the document related to the receiving receipt request, used for reference and tracking in the system.
ExternalSystemTransactionReference String Reference number from an external system associated with the transaction, used for cross-system tracking and reconciliation.
Finder String Identifier used to find or query relevant records within the system, potentially used for locating related documents or transactions.
FromDate Datetime The start date for the receiving receipt request transaction, indicating the beginning of the period during which the receipt is valid.
FromOrganizationCode String The unique code representing the organization from which the goods or items are being received, indicating the source organization.
FromOrganizationId Long Unique identifier for the organization from which the goods or items are being received, typically linking to the specific organizational entity in the database.
GroupId Long Unique identifier for the group associated with the receiving receipt request, used for grouping related records or transactions.
HeaderInterfaceId Long Unique identifier for the interface header in the receiving receipt request, serving as the primary reference for managing the receipt process.
ItemId Long Unique identifier for the item in the receiving receipt request, linking to the specific product or inventory being received.
ItemNumber String The number or code used to uniquely identify the item within the system, facilitating the tracking and management of inventory.
OrganizationCode String The unique code representing the organization where the receiving receipt request is processed or where the goods are being received.
OrganizationId Long Unique identifier for the organization where the receiving receipt request is being processed or where the goods are being received.
POHeaderId Long Unique identifier for the purchase order header, linking the receiving receipt request to the associated purchase order.
ProcessingStatusCode String The current processing status of the receiving receipt request, used to track the progress of the transaction through the receiving process.
ReceiptAdviceHeaderId Long Unique identifier for the receipt advice header, indicating the document or record advising on the receipt of goods.
RMANumber String Unique identifier for the return merchandise authorization (RMA), used to track and manage the return process for goods.
ShipmentHeaderId Long Unique identifier for the shipment header, linking the receiving receipt request to a specific shipment of goods or materials.
ShipmentNumber String The unique identifier or number for the shipment, used to track the shipment of goods from the vendor to the receiving organization.
SourceDocumentCode String Code representing the source document for the receiving receipt request, providing a reference to the originating document (for example, purchase order, RMA).
ToDate Datetime The end date for the receiving receipt request transaction, indicating the end of the period during which the receipt is valid.
TransactionStatusCode String Code representing the current status of the transaction in the receiving receipt request, indicating whether the transaction is pending, completed, or otherwise.
TransactionType String The type of transaction being performed in the receiving receipt request, such as receipt, return, or transfer, indicating the nature of the transaction.
TransferOrderHeaderId Long Unique identifier for the transfer order header, linking the receiving receipt request to a specific transfer order if applicable.
VendorId Long Unique identifier for the vendor providing the goods or services related to the receiving receipt request.
VendorName String The name of the vendor supplying the goods or services for the receiving receipt request.
VendorNumber String The number or code associated with the vendor, typically used for internal tracking and vendor identification.

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