InventoryItemSerialNumbersinventoryAttributesDFF
Manages inventory attribute flexfields linked to serial numbers for detailed data tracking.
Columns
Name | Type | Description |
InventoryItemSerialNumbersInventoryItemId [KEY] | Long | The unique identifier for the inventory item associated with the serialized inventory attributes. This identifier ensures traceability of serialized inventory at the attribute level. |
InventoryItemSerialNumbersOrganizationId [KEY] | Long | The unique identifier for the organization managing the serialized inventory attributes. This identifier supports multi-organization inventory tracking. |
InventoryItemSerialNumbersSerialNumber [KEY] | String | The unique serial number assigned to the inventory item, ensuring traceability of serialized inventory attributes for compliance, warranty tracking, and reporting. |
InventoryItemId [KEY] | Long | The unique identifier for the inventory item associated with the serialized attributes. This identifier ensures accurate linkage between item-level inventory and attribute-specific details. |
SerialNumber [KEY] | String | The serial number associated with the inventory item for tracking unique items across transactions and organizations. |
CurrentOrganizationId [KEY] | Long | The unique identifier for the current organization managing the serialized inventory item. This identifier ensures accurate tracking of stock ownership and operational reporting. |
ProjectId | Long | The unique identifier for the project associated with the serialized inventory. This identifier ensures project-based tracking and cost allocation. |
ProjectId_Display | String | The display value representing the project identifier for easier reference in inventory transactions. |
TaskId | Long | The unique identifier for the specific task within the project linked to this serialized inventory item. This identifier ensures proper cost allocation and tracking in project-based workflows. |
TaskId_Display | String | A display value representing the task identifier for easier reference in inventory transactions. |
CountryOfOriginCode | String | The standardized country code representing the country of origin for the serialized inventory item. This country code ensures compliance with trade regulations and accurate documentation for international shipments. |
CountryOfOriginCode_Display | String | The display name of the country of origin, providing a user-friendly reference for inventory tracking and regulatory compliance. |
_FLEX_Context | String | A descriptive flexfield (DFF) context name that defines the attribute structure for serialized inventory attributes. This field ensures flexibility in tracking additional inventory details. |
_FLEX_Context_DisplayValue | String | A display value representing the context-specific attributes for serialized inventory, ensuring user-friendly identification of additional details. |
BindInventoryItemId | Long | The identifier linking the inventory item to system bindings for integration purposes. This identifier ensures accurate data mapping for serialized inventory attributes in transactions. |
BindItemNumber | String | The item number used in system bindings to ensure consistency in tracking serialized inventory across integrated platforms. |
BindLotNumber | String | The lot number used in system bindings to ensure accurate tracking of lot-controlled serialized inventory. |
BindOrganizationCode | String | The organization code used in system bindings to ensure accurate tracking of serialized inventory across organizations. |
BindSerialNumber | String | The serial number used in system bindings to ensure accurate tracking of serialized inventory in integrated systems. |
Finder | String | The lookup reference used to retrieve and manage serialized inventory attribute records. This reference enables efficient searching, reporting, and system queries. |
OrganizationId | Long | The unique identifier for the organization managing the serialized inventory attributes. This identifier supports tracking inventory ownership across different business entities. |
Param_CycleCountHeaderId | Long | The unique identifier for the cycle count header associated with the serialized inventory attributes. This identifier ensures accurate stock reconciliation during cycle counting. |
Param_InventoryItemId | Long | The unique identifier linking the inventory item to cycle count and transaction processes. This identifier ensures accurate tracking of serialized inventory adjustments. |
Param_LocatorId | Long | The unique identifier for the locator where the serialized item is stored. This identifier ensures precise inventory tracking within a warehouse. |
Param_LotNumber | String | The lot number associated with the serialized item during cycle counting or inventory adjustments. This lot number ensures consistency in lot-controlled stock management. |
Param_OrganizationId | Long | The unique identifier for the organization conducting the cycle count or inventory transaction involving the serialized inventory attributes. |
Param_Subinventory | String | The subinventory where the serialized item is stored. This subinventory ensures accurate tracking of inventory location within an organization for reporting and transaction processing. |
Param_TransactionTypeId | Long | The unique identifier for the transaction type associated with the serialized inventory movement. This identifier ensures proper classification of inventory transactions. |