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. |