ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryCompletedTransactionslotslotSerials

Tracks serial-level details for items governed by both lot and serial control, offering insights into individual units.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long A system-generated unique identifier linking this completed inventory transaction to a specific lot and serial-controlled item. This identifier ensures traceability of serial-tracked inventory movements and compliance with audit requirements.
LotsLotNumber [KEY] String The unique lot number associated with the inventory item in this transaction. This value enables precise tracking of lot-controlled inventory for quality control, expiration management, and regulatory compliance.
SerialNumber [KEY] String The unique serial number assigned to an individual inventory item in this transaction. This serial number ensures traceability for serialized inventory movements, warranty tracking, and regulatory compliance.
SupplierSerialNumber String The serial number assigned to the inventory item by the supplier. This serial number enables full traceability from supplier to end-user and supports compliance with quality control, warranty tracking, and recalls.
BindInventoryItemId Long The unique identifier for the inventory item linked to the lot and serial transaction. This identifier ensures accurate tracking of serial and lot-controlled inventory items.
BindItem String The item number associated with the lot and serial transaction. This value establishes traceability between the inventory master record and serial-tracked inventory movements.
BindOrganization String The name of the organization responsible for the inventory in this serial-tracked transaction. This name ensures accurate ownership tracking and supports financial reconciliation in multi-entity environments.
BindOrganizationId Long The unique identifier for the organization managing the serialized inventory transaction. This identifier is essential for financial tracking and ownership assignment across warehouses and business units.
BindPJCProjectId String The unique identifier for the project associated with the serialized inventory transaction. This identifier enables project-based tracking of serial-tracked items and supports cost allocation in project-driven inventory management.
BindPJCProjectNumber String The project number associated with the serialized inventory transaction. This field provides a user-friendly reference for tracking inventory that is assigned to a specific project.
BindPJCTaskId String The unique identifier for the project task linked to the serialized inventory transaction. This identifier ensures proper allocation of serialized items to project-specific tasks for cost tracking and financial reporting.
BindPJCTaskNumber String The task number assigned within the project to track serialized inventory usage. This task number ensures that serialized items are properly allocated to specific project tasks and cost centers.
BindTransactionDate Datetime The date and time when the bound serialized inventory transaction occurred. This information supports chronological tracking of serial-tracked inventory movements and financial reconciliation.
BindTransactionId Long The unique identifier for the inventory transaction linked to this lot and serial record. This identifier ensures proper reference and traceability in reporting, auditing, and compliance tracking.
Finder String The lookup reference used to retrieve and manage completed serial and lot-based inventory transactions. This reference enables efficient searching, reporting, and system queries for serialized inventory tracking.
TransactionId Long A system-generated unique identifier for the inventory transaction involving a serialized and 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