unitsitems

Unitsitems are a data construct used in inventory, logistics, and data modeling to express quantities that are tied to a specific item and measured in a defined unit. A unitsitem records how much of a particular item exists, with the unit of measure attached to the item identity to create a precise quantity statement, such as 25 kilograms of rice or 12 liters of milk.

In practice, a unitsitem record typically includes item_id (or SKU), unit_id (or unit name), quantity, and optional attributes such as batch or lot number, expiration date, container type, and packaging. This structure supports calculations across different units (for example, converting between kilograms and pounds) and ensures consistent unit handling in inventories and orders.

Purpose and applications: unitsitems are used in ERP and inventory management to standardize stock data, enable accurate ordering, pricing, and replenishment, and support reporting across warehouses. They facilitate transfers, manufacturing consumption, and batch tracking by associating quantities with specific items and units.

Variations: some systems treat unitsitems as a sub-record within a larger item or transaction, while others model them as independent records enabling multiunit management for a single item. They are related to concepts such as units of measure and item catalog entries.

See also: Units of measure, Inventory management, Bill of materials, SKU.