Stock Unit By Storage Category

Table name (referenced in Insights SQL queries): marts_mdc__stock_unit_by_storage_category

Current SKU-lot inventory quantities in the warehouse grouped by address location storage category regardless of their state (i.e. including unavailable, quarantined, ...).

Columns

Column	Type	Description
warehouse_id	number	A unique identifier of the warehouse.
warehouse_name	varchar	Name of the warehouse where the inventory is stored.
storage_category	varchar	Broad storage classification based on address location where the inventory is stored. Pallet: Pallets in the backstock Narrow Aisle: Narrow Aisle in the backstock Transit: Any storage holding the inventory temporarily, e.g. receiving area, wholesale staging, decanting for picking zone, picking carts, forklifts, ... Picking: Main picking zone, Floor Narrow Aisle picking and Subscription Batch Kitting Other: Quarantine, Damaged and other auxiliary locations
account_id	number	Unique identifier of the account owning the inventory
account_name	varchar	Name of the account owning the inventory
product_id	number	A unique identifier of the product.
sku	varchar	SKU of the product
product_name	varchar	Name of the product
product_type	varchar	Type of the product, one of pick_and_pack, insert, packaging
lot_number	varchar	Lot number of the inventory
expiration_date	date	Expiration date of the inventory
quantity	number	Total inventory quantity in the warehouse per storage category
refreshed_at_utc	timestamp_tz	UTC timestamp when the report data have been refreshed