InventoryCompletedTransactionslotslotStandardDFFs
Maintains descriptive flexfields for lot attributes, enhancing data customization for items under lot control.
Columns
Name | Type | Description |
InventoryCompletedTransactionsTransactionId [KEY] | Long | The system-generated unique identifier linking this completed inventory transaction to a specific lot-controlled item with standard descriptive flexfields (DFFs). This identifier ensures traceability of lot-tracked 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. |
TransactionId [KEY] | Long | The unique identifier for the completed inventory transaction. This identifier ensures traceability of lot-tracked inventory movements and financial reconciliation with audit compliance. |
LotNumber [KEY] | String | The lot number assigned to an inventory item in this transaction. This value enables lot-specific tracking of stock movements, supporting expiration monitoring, regulatory compliance, and product recalls. |
_FLEX_Context | String | The standard DFF context name defining the category of additional attributes stored for lot-controlled inventory. This field enables businesses to extend inventory tracking with predefined system attributes. |
_FLEX_Context_DisplayValue | String | A user-friendly display value for the standard DFF context, providing an intuitive representation of lot attributes for enhanced usability and reporting. |
BindInventoryItemId | Long | The unique identifier for the inventory item associated with the lot transaction. This identifierensures accurate linkage between inventory master records and lot-tracked inventory movements. |
BindItem | String | The item number associated with the lot-controlled inventory transaction. This number establishes traceability between the inventory master record and extended attribute tracking via standard DFFs. |
BindOrganization | String | The name of the organization responsible for managing the lot-controlled inventory in this transaction. This name ensures accurate inventory ownership tracking and supports financial reconciliation across multiple business units. |
BindOrganizationId | Long | The unique identifier for the organization linked to the lot-controlled 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 lot-controlled inventory transaction. This identifier enables project-based tracking of lot-tracked items and supports cost allocation in project-driven inventory management. |
BindPJCProjectNumber | String | The project number associated with the lot-controlled inventory transaction. This project 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 lot-controlled inventory transaction. This identifier ensures that lot-tracked 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 lot-controlled inventory usage. This task number ensures that lot-tracked items are properly assigned to project-specific activities and cost centers. |
BindTransactionDate | Datetime | The date and time when the lot-controlled inventory transaction occurred. This information supports chronological tracking of lot-tracked inventory movements and financial reconciliation with system records. |
BindTransactionId | Long | The unique identifier for the inventory transaction linked to this lot 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 lot-based inventory transactions with standard DFFs. This reference enables efficient searching, reporting, and system queries for lot-controlled inventory tracking. |