ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryCompletedTransactionsserials

Manages serial-level information for inventory transactions, ensuring accurate tracking for items under serial control.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long A system-generated unique identifier linking this completed inventory transaction to a specific serialized item. This identifier ensures traceability of serialized inventory movements for compliance, warranty tracking, and audit readiness.
SerialNumber [KEY] String The unique serial number assigned to an individual inventory item in this transaction. This serial number ensures precise tracking of serialized inventory, enabling lifecycle management, regulatory compliance, and asset traceability.
SupplierSerialNumber String The serial number assigned to the inventory item by the supplier. This serial number enables end-to-end traceability from supplier to end-user and supports quality control, warranty validation, and recall management.
BindInventoryItemId Long The unique identifier for the inventory item associated with the serialized inventory transaction. This identifier ensures accurate linkage between inventory master records and serialized inventory tracking.
BindItem String The item number associated with the serialized inventory transaction. This value establishes traceability between the inventory master record and serial-tracked inventory movements.
BindOrganization String The name of the organization responsible for managing the serialized inventory in this 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 serialized items and supports cost allocation in project-driven inventory management.
BindPJCProjectNumber String The project number associated with the serialized inventory transaction. This number 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 that serialized items are properly allocated 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 assigned to project-specific activities and cost centers.
BindTransactionDate Datetime The date and time when the 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 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-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 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