InventoryCompletedTransactionslotslotAttributeDFFs
Manages custom attributes for lot-level details using descriptive flexfields, applicable for items under lot control.
Columns
| Name | Type | Description |
| InventoryCompletedTransactionsTransactionId [KEY] | Long | A system-generated unique identifier linking this lot attribute descriptive flexfield (DFF) entry to a specific completed inventory transaction. This identifier ensures accurate referencing of additional lot-level attributes. |
| LotsLotNumber [KEY] | String | The unique lot number associated with the inventory item in this transaction. This number enables detailed tracking of lot-controlled inventory for compliance, quality control, and traceability. |
| TransactionId [KEY] | Long | The unique identifier for the completed inventory transaction. This identifier ensures traceability in inventory movement, financial reconciliation, and system integration. |
| LotNumber [KEY] | String | The lot number assigned to the inventory item in this transaction. This number ensures compliance with lot control policies and supports traceability for expiration, quality, and regulatory reporting. |
| _FLEX_Context | String | A DFF context name associated with the inventory transaction's lot attributes. This context name defines the category of additional attributes stored, allowing for flexible customization based on business needs. |
| _FLEX_Context_DisplayValue | String | A user-friendly display value for the DFF context, providing a readable representation of the context category for enhanced usability and reporting. |
| BindInventoryItemId | Long | The unique identifier for the inventory item associated with the lot attribute DFF entry. This identifier ensures that additional attributes captured via DFFs are correctly linked to specific inventory items. |
| BindItem | String | The item number associated with the inventory transaction's lot attributes. This number provides traceability between inventory master data and lot-level DFF extensions. |
| BindOrganization | String | The name of the organization associated with the lot attribute DFF-enabled inventory transaction. This name ensures that organization-specific DFF attributes are properly recorded for multi-entity businesses. |
| BindOrganizationId | Long | The unique identifier for the organization linked to the lot attribute DFF entry. This identifier ensures precise reporting, ownership tracking, and financial allocation. |
| BindPJCProjectId | String | The unique identifier for the project associated with the inventory transaction's lot attributes. This identifier enables project-based tracking of inventory usage and supports financial reporting for project-specific stock movements. |
| BindPJCProjectNumber | String | The user-friendly project number associated with the lot attribute DFF entry. This value ensures accurate visibility into project-related inventory allocations and costs. |
| BindPJCTaskId | String | The unique identifier for the project task associated with the lot attribute transaction. This identifier ensures granular tracking of inventory costs and usage within specific project tasks. |
| BindPJCTaskNumber | String | The task number assigned to the lot attribute transaction. This task number allow for detailed tracking of inventory movements within a project’s task structure. |
| BindTransactionDate | Datetime | The date and time when the bound lot attribute transaction occurred. This information ensures accurate historical tracking of lot-specific inventory movements and reconciliation with financial systems. |
| BindTransactionId | Long | The unique identifier for the inventory transaction linked to this lot attribute DFF entry. This identifier provides a direct reference for reporting, auditing, and system integration. |
| Finder | String | The lookup reference used to retrieve and manage lot attribute DFF entries for completed inventory transactions. This reference enables efficient searching, reporting, and system queries for lot-controlled inventory. |