InventoryCompletedTransactionslotslotSerialsserialStandardDFFs
Manages standard descriptive flexfields for serials to support customization and reporting needs for serial-controlled items.
Columns
Name | Type | Description |
InventoryCompletedTransactionsTransactionId [KEY] | Long | The system-generated unique identifier linking this completed inventory transaction to a specific lot and serial-controlled item with standard descriptive flexfields (DFFs). This identifier ensures traceability of serialized inventory movements with extended standard attributes. |
LotsLotNumber [KEY] | String | The unique lot number associated with the inventory item in this transaction. This value ensures precise tracking of lot-controlled inventory, supporting compliance with quality control, expiration management, and regulatory traceability. |
LotserialsSerialNumber [KEY] | String | The serial number associated with the lot-controlled inventory item. This serial number enables traceability for serialized inventory, ensuring compliance with warranty tracking, recalls, and lifecycle monitoring. |
TransactionId [KEY] | Long | The unique identifier for the completed inventory transaction. This identifier ensures traceability of serialized inventory movements and financial reconciliation with audit compliance. |
SerialNumber [KEY] | String | The unique serial number assigned to an individual inventory item in this transaction. This serial number ensures complete traceability of serialized inventory, supporting asset tracking, regulatory compliance, and system integration. |
_FLEX_Context | String | A standard DFF context name defining the category of additional attributes stored for serialized and lot-controlled inventory. This context name allows businesses to extend inventory tracking with standard attributes based on operational requirements. |
_FLEX_Context_DisplayValue | String | A user-friendly display value for the standard DFF context, providing an intuitive representation of serialized and lot attributes for enhanced usability and reporting. |
BindInventoryItemId | Long | The unique identifier for the inventory item associated with the serialized inventory transaction. This identifierensures accurate linkage between inventory master records and serial-tracked inventory movements. |
BindItem | String | The item number associated with the serialized inventory transaction. This value establishes traceability between the inventory master record and standard attribute tracking via descriptive DFFs. |
BindOrganization | String | The name of the organization responsible for managing the serialized inventory in this transaction. This field ensures accurate inventory ownership tracking and supports financial reconciliation across multiple business units. |
BindOrganizationId | Long | The unique identifier for the organization linked to the serialized inventory transaction. This identifier ensures financial integrity, ownership assignment, and regulatory compliance in 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 serialized items, supporting cost allocation and audit compliance 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 project-related inventory allocations and cost distribution. |
BindPJCTaskId | String | The unique identifier for the project task linked to the serialized inventory transaction. This identifierensures that serialized items are properly allocated to project-specific tasks for accurate 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 with system records. |
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 and lot-based inventory transactions with standard DFFs. This reference enables efficient searching, reporting, and system queries for serialized inventory tracking. |