maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per SKU with owning client, category, temp class, hazard class, value band, per-unit value, weight/volume, units per pallet, and shelf life. Drives cold-chain and SDS. Hazardous SKUs carry a `safety-data-sheets` `source_uri`; non-hazardous SKUs write an empty string (→ null in staging).
13 of 13
Column
Description
Tests · PII
sku
UUID5 — primary key on the source side. Stable across re-syncs.
2 tests
client_id
The SKU's owning brand. String on the wire; coerced and validated against `whse_clients` in staging.
product_name
Human-readable product name (Faker product-ish). Free-text.
product_category
Product category (low-card free-ish, e.g. `beverages`, `apparel`, `electronics`, `pharma`, `auto_parts`, `chemicals`).
temp_class
Storage temperature class — `ambient`, `chilled`, `frozen`.
hazard_class
ADR hazard class — `none`, `class_2`, `class_3`, `class_6`, `class_8`, `class_9`. `none` for the vast majority.
value_band
Value band — `low`, `medium`, `high`, `very_high`.
unit_value_eur
Per-unit value in EUR (feeds inventory valuation). Coerced to Decimal(14,2) in staging.
weight_kg
Unit weight in kg. Coerced to Decimal(10,3) in staging.
volume_m3
Unit volume in m³. Coerced to Decimal(10,4) in staging.
units_per_pallet
Units per pallet. Coerced to UInt16 in staging.
shelf_life_days
Shelf life in days. `0` for ambient/non-perishable SKUs (always present). Coerced to UInt16 in staging.
source_uri
Deterministic `gs://…/unstructured/safety-data-sheets/<sku>.md` URI only when hazard_class != 'none'; empty (→ null) otherwise. Reconciliation key into the safety-data-sheets corpus.