CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptRequestslineslotItemLots

Manages lot information for items controlled by lots but not serial numbers, ensuring traceability.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long Unique identifier for the header interface record in the receiving receipt request, which links the request to the corresponding transaction or batch.
LinesInterfaceTransactionId [KEY] Long Unique identifier for the line interface transaction within the receiving receipt request, helping to trace the specific line transaction related to the request.
LotNumber [KEY] String A unique number identifying the lot associated with a shipment notice or receipt request. Relevant when items are managed under lot control for inventory tracking.
LotExpirationDate Date The expiration date of the item in the lot, used to track the shelf life of goods received under lot control from an advanced shipment notice (ASN) or receipt.
ParentLotNumber String Identifies the parent lot for a given lot, establishing a hierarchical relationship in lot-controlled items for traceability in advanced shipment or receipt lines.
VendorLotNumber String The lot number assigned by the supplier for the lot being received, necessary for matching supplier-originated lots with those controlled within the warehouse.
TransactionQuantity Decimal The quantity of the item in the lot being transacted, reflecting the amount related to the ASN or receipt request and subject to lot control.
PrimaryQuantity Decimal The transaction quantity of the item in the primary unit of measure, as defined for the item in the warehouse's lot control system.
SecondaryTransactionQuantity Decimal The transaction quantity in a secondary unit of measure, which may be different from the primary unit, and is used when the warehouse supports multiple measurement units.
OriginationDate Date The date when the lot was originally created or received, important for tracking inventory history and managing lot expiration or usage.
OriginationType String The type of origination for the lot, indicating whether it was received from a shipment or generated internally, relevant for inventory management and lot traceability.
HoldDate Date The date when a hold was placed on the lot, preventing further transactions or changes due to quality issues, inspection, or other reasons.
ReasonId Long A unique identifier for the reason code associated with the receiving transaction, helping to categorize the cause of the transaction's occurrence.
ReasonName String The descriptive name of the reason associated with the receiving transaction, often tied to inventory adjustments or issues that require action.
MaturityDate Date The date when the lot reaches its maturity, marking the point when the item may no longer be usable or available for further transactions.
GradeCode String An abbreviation or code representing the quality or classification grade of the lot, used to track different quality standards for items.
CustomerId Long A unique identifier for the customer associated with the receiving receipt request, used for linking transactions to specific customers.
CustomerPartyName String The name of the customer or party associated with the receiving receipt request, typically used for contact and transaction identification.
DocumentNumber String The document number for the associated transaction or receipt request, helping to track and reference the specific transaction in external or internal systems.
ExternalSystemTransactionReference String A reference number from an external system related to the receiving transaction, enabling integration and tracking across systems.
Finder String A unique identifier or tool used for locating specific transaction records in the Receiving Receipt Request system.
FromDate Datetime The start date and time of the transaction or receiving request, marking when the item or lot became available or was processed.
FromOrganizationCode String The code identifying the originating organization that created or processed the receiving receipt request.
FromOrganizationId Long The unique identifier for the originating organization, used for traceability and tracking of transactions between different business entities.
GroupId Long A unique identifier for the group to which the receiving receipt request belongs, used for managing bulk transactions or similar items.
HeaderInterfaceId Long A reference to the header interface for the receiving receipt request, linking the line-level details to a broader transaction context.
ItemId Long The unique identifier for the item involved in the receiving transaction, linking the lot or request to a specific item in the inventory system.
ItemNumber String The item number or SKU associated with the receiving transaction, used for referencing the item across various parts of the system.
OrganizationCode String The code that identifies the organization or department processing the receiving receipt request, used for managing cross-organization transactions.
OrganizationId Long The unique identifier for the organization processing the receiving receipt request, ensuring accurate tracking and management of inter-organization transactions.
POHeaderId Long The unique identifier for the purchase order header, linking the receiving receipt request to a specific purchase order for sourcing details.
ProcessingStatusCode String The code indicating the current processing status of the receiving receipt request, helping track whether it is pending, in progress, or completed.
ReceiptAdviceHeaderId Long The identifier for the receipt advice header, which contains information about the receipt transaction being processed.
RMANumber String The return merchandise authorization (RMA) number associated with the receipt, indicating that the item is being returned as part of the receiving process.
ShipmentHeaderId Long The unique identifier for the shipment associated with the receipt, helping to track goods through the shipment and receiving process.
ShipmentNumber String The shipment number assigned to the shipment containing the goods being received, used to identify the shipment in tracking systems.
SourceDocumentCode String The code identifying the source document associated with the receiving receipt request, often linking the request to an original purchase order or shipment.
ToDate Datetime The end date and time for the receiving transaction or receipt request, marking the completion or cutoff for the item being processed.
TransactionStatusCode String The current status of the transaction, indicating whether the receiving receipt request is completed, pending, or in another processing state.
TransactionType String The type of transaction being performed in the receiving receipt request, such as receipt, return, or adjustment.
TransferOrderHeaderId Long The unique identifier for the transfer order header, linking the receipt request to a transfer order for internal movement of inventory.
VendorId Long The unique identifier for the vendor supplying the goods associated with the receiving receipt request, used for vendor management and traceability.
VendorName String The name of the vendor supplying the goods associated with the receiving receipt request, used for identifying and managing vendor relations.
VendorNumber String The vendor number assigned to the supplier in the system, providing a unique way to identify the vendor across transactions.

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