CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials

Manages serial number details associated with specific lots for items that are both lot and serial-controlled.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long Unique identifier for the receiving receipt transaction request in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table.
LotserialitemlotsLotNumber [KEY] String Represents the lot number for items in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table, which helps track items by their lot designation.
FromSerialNumber [KEY] String The starting serial number in a range for the receipt transaction request, applicable when items are managed with lot and serial control at the warehouse.
ToSerialNumber String The ending serial number in a range for the receipt transaction request, applicable when items are managed with lot and serial control at the warehouse.
VendorSerialNumber String The supplier's serial number corresponding to the range of serial numbers in the receipt transaction request. This attribute is relevant when items are tracked under lot and serial control.
DocumentNumber String A reference number for the document associated with the receipt transaction request in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table.
ExternalSystemTransactionReference String The reference identifier from an external system for the transaction related to the receipt request, ensuring integration with other systems.
Finder String A lookup or search key for retrieving records in the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table.
FromDate Datetime The starting date for the receipt transaction request, indicating when the items are expected to be available, especially for items under lot and serial control.
GroupId Long An identifier representing the group or batch of related items involved in the receipt transaction request within the ReceivingReceiptTransactionRequestslotSerialItemLotslotSerialItemSerials table.
InterfaceTransactionId Long An identifier for the interface transaction that maps the receipt transaction request to its corresponding external or internal processing system.
ItemId String The unique identifier for the item being received in the receipt transaction request. This element helps identify specific products or materials.
ItemNumber String A numerical identifier for the item, often used for tracking and sorting items in the warehouse during receipt processing.
OrganizationCode String The code that specifies the organization associated with the receipt transaction request. It helps determine the location or business unit handling the receipt.
OrganizationId String A unique identifier for the organization involved in the receipt transaction, assisting in multi-organization systems to distinguish between different business units.
POHeaderId Long The purchase order header identifier associated with the receipt transaction request, linking the receipt to the originating purchase order.
ProcessingStatusCode String Indicates the current processing status of the receipt transaction request, such as 'Pending', 'Completed', or 'In Progress'.
ReceiptAdviceHeaderId Long The identifier for the receipt advice header, which is used for tracking the document or notification confirming the receipt of goods.
RMANumber String The return merchandise authorization (RMA) number, which links the receipt transaction to a returned item or order.
ShipmentHeaderId Long A reference identifier for the shipment header associated with the receipt transaction, helping link the receipt to the originating shipment.
ShipmentNumber String A unique number assigned to the shipment, which helps track the specific shipment related to the receipt transaction request.
SourceDocumentCode String The code that identifies the source document for the receipt transaction, such as a purchase order, sales order, or other related document.
ToDate Datetime The end date for the receipt transaction request, marking the cutoff for processing or tracking the receipt of items in the system.
TransactionStatusCode String A code that indicates the status of the transaction, such as 'Completed', 'Pending', or 'Failed', providing insight into the state of processing.
TransactionType String Describes the type of transaction for the receipt, such as 'Purchase', 'Return', or 'Transfer', to categorize the nature of the receipt.
TransferOrderHeaderId Long The identifier for the transfer order header, used when the receipt transaction is part of an inter-warehouse or internal transfer process.

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