InventoryItemSerialNumbersserialStandardDFF
Stores standard descriptive flexfields for serial numbers, ensuring consistent data structure.
Columns
| Name | Type | Description |
| InventoryItemSerialNumbersInventoryItemId [KEY] | Long | The unique identifier for the inventory item associated with the standard serial number 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 standard attributes. This identifier supports multi-organization inventory tracking and reporting. |
| InventoryItemSerialNumbersSerialNumber [KEY] | String | The unique serial number assigned to the inventory item, ensuring traceability for compliance, warranty tracking, and inventory control. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item associated with the serial number standard attributes. This identifier ensures accurate linkage between item-level inventory and serial-specific attributes. |
| SerialNumber [KEY] | String | The serial number assigned to the inventory item for tracking unique items across inventory transactions and organizational transfers. |
| CurrentOrganizationId [KEY] | Long | The unique identifier for the organization currently managing the serialized inventory item. This identifier ensures accurate tracking of stock ownership and inventory transfers. |
| _FLEX_Context | String | A descriptive flexfield (DFF) context name defining the attribute structure for standard serial number attributes. This field enables tracking of additional custom inventory details. |
| _FLEX_Context_DisplayValue | String | A display value representing the context-specific attributes for standard serial numbers, 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 serial number 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 serialized inventory within lot-controlled stock. |
| 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 standard attribute records. This reference enables efficient searching, reporting, and system queries. |
| OrganizationId | Long | The unique identifier for the organization managing the serialized inventory standard 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 standard 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 standard 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. |