InventoryItemSerialNumbers
Handles the serial numbers for items in an organization, ensuring precise tracking and control.
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | The unique identifier for the organization managing the serialized inventory item. This identifier ensures accurate tracking of stock ownership and operational reporting. |
| OrganizationCode | String | An abbreviation that represents the organization responsible for managing the serialized inventory. This abbreviation ensures clear identification in multi-organization environments. |
| OrganizationName | String | The full name of the organization managing the serialized inventory item. This name ensures proper assignment of transactions to business entities. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item associated with the serial number. This identifier ensures traceability of serialized inventory across transactions. |
| ItemNumber | String | The unique identifier assigned to the inventory item. This identifier ensures accurate tracking and reporting of inventory at the item level. |
| ItemDescription | String | A description of the inventory item, providing a user-friendly reference for inventory management and reporting. |
| SerialNumber [KEY] | String | The unique serial number assigned to the inventory item. This serial number ensures precise tracking of serialized inventory for compliance, warranty validation, and recall management. |
| SubinventoryCode | String | The unique code representing the subinventory where the serialized item is stored. This code ensures accurate stock tracking at a detailed storage location level. |
| LocatorId | Long | The unique identifier for the locator where the serialized inventory item is stored. This identifier ensures accurate placement tracking within a warehouse. |
| Locator | String | The name or code of the locator within the subinventory where the serialized item is placed. This information ensures precise inventory location tracking. |
| LotNumber | String | The lot number associated with the serialized item. This lot number ensures traceability for lot-controlled inventory items. |
| Revision | String | The revision number of the inventory item. This number ensures accurate tracking of design or specification changes across serialized inventory. |
| StatusId | Long | The unique identifier for the material status assigned to the serialized item. This identifier ensures accurate classification of inventory availability. |
| StatusCode | String | The status code assigned to the serialized item (for example, 'Available', 'Hold', or 'Scrapped'), indicating its availability for use. |
| UsageCode | String | The usage classification code assigned to the serialized item (for example, 'Production' or 'Customer Return'), ensuring accurate tracking of its intended purpose. |
| Usage | String | The description of the usage classification assigned to the serialized item, providing a clear reference for its purpose in inventory operations. |
| ShippedDate | Datetime | The date when the serialized item was shipped. This date ensures accurate tracking of outbound logistics and customer deliveries. |
| ReceiptDate | Datetime | The date when the serialized item was received into inventory. This date supports traceability and reconciliation of inbound stock. |
| Allocated | String | Indicates whether the serialized item has been allocated for a specific order or transaction. This field ensures visibility into reserved stock for operational planning. |
| Reserved | String | Indicates whether the serialized item is reserved for a specific demand, such as a sales order or production request. This field ensures accurate inventory allocation. |
| Supplier | String | The name of the supplier from whom the serialized item was procured. This name ensures supplier traceability and compliance tracking. |
| SupplierLot | String | The lot number assigned by the supplier to the serialized inventory item. This lot number supports traceability and quality control for lot-controlled stock. |
| SupplierSerialNumber | String | The serial number assigned to the inventory item by the supplier. This serial number ensures end-to-end tracking of serialized inventory from supplier to customer. |
| UniqueDeviceIdentifier | String | The globally unique identifier assigned to the serialized device. This identifier ensures compliance with medical device regulations and traceability requirements. |
| ItemPrimaryImageURL | String | The URL of the primary image associated with the inventory item. This URL supports product visibility and catalog integration. |
| BindInventoryItemId | Long | The identifier linking the inventory item to system bindings for integration purposes. This identifier ensures accurate data mapping in transactions. |
| BindItemNumber | String | The inventory item number used in system bindings to ensure consistency in inventory tracking across integrated platforms. |
| BindLotNumber | String | The lot number used in system bindings to ensure accurate lot tracking for 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 records. This reference facilitates efficient searching, reporting, and system queries. |
| Param_CycleCountHeaderId | Long | The unique identifier for the cycle count header associated with the serialized inventory. 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 item. |
| 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 item movement. This identifier ensures proper classification of inventory transactions. |