InventoryCompletedTransactionslotslotSerialsserialAttributeDFFs
Handles custom attributes for serial details using descriptive flexfields, designed 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 lot and serial-controlled item with additional attribute tracking via descriptive flexfields (DFFs). This identifier ensures traceability of serial-tracked inventory movements with extended attributes. |
| LotsLotNumber [KEY] | String | The unique lot number associated with the inventory item in this transaction. This value ensures full traceability of lot-controlled inventory for compliance, quality control, and expiration management. |
| LotserialsSerialNumber [KEY] | String | The serial number assigned to the lot-controlled inventory item. This serial number ensures that each individual unit is uniquely tracked, enabling warranty validation, recall management, and compliance with serial tracking requirements. |
| TransactionId [KEY] | Long | The unique identifier for the completed inventory transaction. This identifier ensures proper referencing of inventory movements, enabling financial reconciliation, compliance tracking, and system integration. |
| SerialNumber [KEY] | String | The unique serial number assigned to an individual inventory item in this transaction. This serial number enables precise tracking of serialized inventory movements, supporting regulatory compliance and asset traceability. |
| _FLEX_Context | String | A DFF context name for the transaction, defining the category of additional attributes stored for serialized and lot-controlled inventory. This field allows businesses to extend inventory tracking based on custom requirements. |
| _FLEX_Context_DisplayValue | String | A user-friendly display value for the DFF context, providing a readable representation of the context category for improved usability and reporting. |
| BindInventoryItemId | Long | The unique identifier for the inventory item associated with the lot and serial attribute tracking transaction. This identifier ensures accurate linkage between inventory master records and serial-tracked inventory movements. |
| BindItem | String | The item number associated with the lot and serial attribute tracking transaction. This number establishes traceability between the inventory master record and extended attribute tracking. |
| BindOrganization | String | The name of the organization responsible for managing the inventory in this lot and serial attribute transaction. This name ensures accurate inventory ownership tracking and supports financial reconciliation across business units. |
| BindOrganizationId | Long | The unique identifier for the organization linked to the lot and serial attribute transaction. This identifier ensures accurate financial tracking, ownership assignment, and multi-entity inventory management. |
| 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 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 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 with extended attribute tracking. This reference enables efficient searching, reporting, and system queries for serialized inventory management. |