CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryCompletedTransactionslots

Provides detailed lot-level information for inventory transactions, including lot number, quantity, and expiration data for items under lot control.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long A system-generated unique identifier linking this completed inventory transaction to a specific lot-controlled item. This identifier ensures traceability of lot-based inventory movements.
LotNumber [KEY] String The unique lot number assigned to the inventory item in this transaction. This value is critical for lot-controlled inventory tracking, ensuring compliance with quality control, traceability regulations, and expiration management.
ParentLot String The lot number of the parent lot from which this lot was derived. This number is used for tracking hierarchical lot relationships, such as lot splits, merges, or sub-lots in manufacturing and distribution processes.
TransactionQuantity Decimal The total quantity of the item moved, issued, or received in this transaction, expressed in the primary unit of measure (UOM). This value is essential for accurate inventory tracking and reconciliation.
Status String The current status of the lot in the transaction (for example, 'Active', 'On Hold', or 'Expired'). This value ensures proper inventory handling and regulatory compliance.
StatusId Long The unique identifier associated with the lot's status. This value is used internally for system processing and status validation in inventory tracking.
SupplierLotNumber String The lot number assigned by the supplier to the inventory item. This value ensures end-to-end traceability from supplier to end-user and supports compliance with quality and recall management.
GradeCode String The quality grade code assigned to the lot, used for categorizing inventory based on predefined quality standards, inspection results, or product characteristics.
OriginationTypeCode Long The system-defined code representing the origination type of the lot (for example, 'Manufactured', 'Procured', or 'Transferred'). This value is used to determine the source of inventory movements.
OriginationType String The description of the origination type for the lot, indicating whether the inventory was received from a supplier, manufactured internally, or transferred from another location.
OriginationDate Date The date on which the lot was first created, manufactured, or received into inventory. This date ensures proper tracking of inventory lifecycles and supports quality control processes.
RetestDate Date The date on which the lot is scheduled for retesting to determine if it remains usable. This date is crucial for inventory that requires periodic quality checks before further use or sale.
ExpirationActionCode String The system-defined action code that specifies what happens when the lot reaches its expiration date (for example, 'Dispose', 'Rework', or 'Hold').
ExpirationAction String The description of the action to be taken when the lot expires. This description ensures proper handling of expired or obsolete inventory.
ExpirationActionDate Date The date on which the expiration action is scheduled to take place. This date helps inventory managers proactively handle expired stock and avoid regulatory non-compliance.
HoldDate Date The date on which the lot was placed on hold, preventing further transactions involving the inventory. This date is used for quality holds, regulatory compliance, or issue resolution.
MaturityDate Date The date on which the inventory in this lot reaches maturity, such as aged products or materials requiring a curing period before usage.
Reason String The justification for a specific action taken on the lot, such as placing it on hold, expiring it, or adjusting its status. This field is critical for audit trails and compliance reporting.
ReasonId Long A system-generated unique identifier for the reason associated with the inventory transaction. This identifier ensures consistent categorization of transaction justifications across the system.
BindInventoryItemId Long The unique identifier for the inventory item associated with the lot transaction. This identifier ensures accurate linkage between lot-controlled inventory movements and the item master data.
BindItem String The item number linked to the lot transaction, ensuring traceability between item master records and lot-tracked inventory movements.
BindOrganization String The name of the organization responsible for the inventory in this lot transaction. This name ensures proper inventory ownership tracking in multi-entity business structures.
BindOrganizationId Long The unique identifier for the organization responsible for managing the inventory lot transaction. This identifier supports financial tracking and inventory reconciliation in multi-org environments.
BindPJCProjectId String The unique identifier for the project associated with the lot transaction. This identifier enables project-based inventory tracking and cost allocation.
BindPJCProjectNumber String The project number associated with the inventory lot transaction, providing clear visibility into project-related stock movements.
BindPJCTaskId String The unique identifier for the project task related to the lot transaction. This identifier ensures accurate tracking of inventory assigned to specific project tasks and cost centers.
BindPJCTaskNumber String The task number linked to the lot transaction, ensuring proper allocation of inventory to project-specific activities.
BindTransactionDate Datetime The date and time when the bound lot transaction occurred. This information supports chronological tracking and financial reconciliation of lot-based inventory transactions.
BindTransactionId Long The unique identifier for the inventory transaction linked to this lot record. This identifier ensures proper reference and traceability in reporting and auditing.
Finder String The lookup reference used to retrieve and manage completed lot-based inventory transactions. This reference enables efficient searching, reporting, and query execution for lot-controlled inventory.
TransactionId Long A system-generated unique identifier for the inventory transaction involving a lot-controlled item. This identifier ensures accurate integration with financial, supply chain, and compliance systems.

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