inventorynumber

Tracks unique inventory numbers assigned to specific stock items, enabling businesses to maintain accurate records and reporting.

Columns


Name	Type	References	Description
id [KEY]	Integer		The unique internal identifier for the inventory number record, used for system reference and database management.
expirationdate	Date		The date on which the inventory number expires, indicating when the associated item should no longer be used or sold.
externalid	String		A unique identifier assigned externally to track the inventory number in an external system, ensuring consistency across platforms.
item	String		The name or unique identifier of the inventory item associated with this inventory number, linking it to a specific product or Stock Keeping Unit (SKU).
memo	String		A free-text field that allows users to enter additional notes or comments related to the inventory number, such as storage conditions or special handling instructions.