CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptRequestslineslotSerialItemLotslotNumbersDFF

Supports descriptive flexfields for lot numbers associated with lot and serial-controlled items.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long Unique identifier for the header interface record in the Receiving Receipt Request system. This is used to track the receipt request at the header level.
LinesInterfaceTransactionId [KEY] Long Identifier for the transaction associated with a specific line in the Receiving Receipt Request system. This ID is used to trace individual transactions linked to each receipt request line.
LotserialitemlotsLotNumber [KEY] String Represents the lot number associated with a serial-controlled item in the Receiving Receipt Request system. It helps identify the specific lot for inventory tracking.
TransactionInterfaceId [KEY] Long Unique identifier for the transaction in the Receiving Receipt Request system, used to track the transaction details associated with a receipt request.
LotNumber [KEY] String Identifies the lot number for an item in the inventory. This number is used for tracking the specific batch or group of items within the system.
_FLEX_Context String Context name for a descriptive flexfield used when an item is controlled by lot and serial numbers in the warehouse. This field provides additional contextual information for managing lot-specific details.
_FLEX_Context_DisplayValue String Display value associated with the descriptive flexfield context for lots. It provides a user-friendly label or description of the context applied to the item.
CustomerId Long Identifier for the customer associated with the receipt request. This ID helps in identifying which customer is requesting the receipt or inventory update.
CustomerPartyName String Name of the customer party related to the receipt request. This provides a human-readable reference to the customer involved in the transaction.
DocumentNumber String Document number associated with the receipt request or transaction. This number is used to link the request to a specific document for reference and tracking.
ExternalSystemTransactionReference String Reference identifier from an external system for the transaction. This is used to connect the transaction in OracleSCM with external systems' data for integration purposes.
Finder String A search identifier used within the Receiving Receipt Request system. It helps in locating or referencing specific transactions or items within the system.
FromDate Datetime The start date for the period during which the receipt request is valid. This date marks the beginning of the time range for processing or tracking the request.
FromOrganizationCode String Code representing the organization from which the goods or items are being received. This helps in identifying the origin of the receipt.
FromOrganizationId Long Identifier for the organization that is sending or transferring the items to the receiving organization. This ID helps track the source of the receipt request.
GroupId Long Identifier for the group associated with the receipt request. This ID is used to categorize and track related receipt requests within the system.
HeaderInterfaceId Long Identifier for the header-level interface record, linking the receiving receipt request to its corresponding header record in the system.
ItemId Long Unique identifier for the item being received. This ID helps identify the specific product or material associated with the receipt request.
ItemNumber String Unique number or identifier for the item. This number is used to track and reference the item in the receiving process.
OrganizationCode String Code representing the organization receiving the items. This helps identify the location or department involved in the receipt of goods.
OrganizationId Long Identifier for the organization receiving the goods or materials. This ID helps distinguish different organizations or units within the system.
POHeaderId Long Purchase order header identifier for the items being received. This ID links the receipt request to a specific purchase order for validation and processing.
ProcessingStatusCode String Code representing the current status of the receipt request. It helps indicate whether the request is pending, processed, or has encountered issues.
ReceiptAdviceHeaderId Long Identifier for the receipt advice header, used to track receipt advice related to a purchase or transaction. This helps in validating and confirming receipt information.
RMANumber String Return merchandise authorization (RMA) number, used for tracking the return of items. This number is tied to the receipt of goods being returned.
ShipmentHeaderId Long Identifier for the shipment associated with the receipt request. This ID helps link the receipt to a specific shipment for tracking and processing.
ShipmentNumber String Shipment number associated with the transaction, used for tracking the movement and receipt of goods during the shipment process.
SourceDocumentCode String Code representing the original source document, such as an invoice or purchase order, linked to the receipt request. This helps track the origin of the receipt.
ToDate Datetime The end date for the period during which the receipt request is valid. This date marks the end of the time range for processing or tracking the request.
TransactionStatusCode String Code representing the current status of the transaction, indicating whether it is pending, completed, or has encountered errors.
TransactionType String Type of transaction associated with the receipt request, such as purchase, return, or transfer. This helps classify the nature of the transaction.
TransferOrderHeaderId Long Identifier for the transfer order header, used to track inter-organization transfers. This ID links the receipt request to a specific transfer order.
VendorId Long Identifier for the vendor supplying the items being received. This ID is used to track which vendor the goods are coming from.
VendorName String Name of the vendor supplying the items. This provides a human-readable reference to the vendor in the receipt request.
VendorNumber String Vendor number used to uniquely identify the vendor in the system. This number is used for tracking and managing vendor-related transactions.

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