maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per order with client, site, consignee, order/promised/ ship/delivered dates, derived `ship_month`, carrier, destination country/region, status, order value, denormalized line count and units, and precomputed OTIF flags (is_on_time / is_in_full / is_otif). The table the isolation gate reads via mart_order_outcomes. `dest_region` is the ship-to region — a distinct column from the site-derived `site_region` dimension.
20 of 20
Column
Description
Tests · PII
client_id
Owning client — the row-policy key. String on the wire; coerced and validated against `whse_clients` in staging.
site_id
Fulfilling site. String on the wire; coerced and validated against `whse_sites` in staging.
consignee_id
Delivery recipient. String on the wire; coerced and validated against `whse_consignees` in staging. Points at consumer PII.
order_ref
Human order number. Free-text.
order_date
ISO-8601 date the order was placed. Coerced to Date in staging.
promised_date
ISO-8601 SLA promise date (order_date + 1..7d). Coerced to Date in staging.
ship_date
ISO-8601 ship date. Coerced to Nullable(Date); null while unshipped.
delivered_date
ISO-8601 delivery date. Coerced to Nullable(Date); null until delivered.
ship_month
Derived `toStartOfMonth(ship_date)` in staging — grain key for mart_fulfillment_daily / metric_fulfillment.
carrier
Carrier — `dhl`, `dpd`, `ups`, `fedex`, `gls`, `hermes`.
dest_country
ISO-3166 alpha-2 destination country.
dest_region
Ship-to region — `EU`, `UK`, `NA`, `APAC`. Distinct from the site-derived site_region dimension (INC-08).
order_status
Order status — `open`, `picking`, `packed`, `shipped`, `delivered`, `cancelled`.
order_value_eur
Order value in EUR. Coerced to Decimal(14,2). RAW name aliased to `order_value` downstream (INC-11).
line_count
Denormalized count of child order lines. Coerced to UInt16 in staging.
units_total
Total units across all lines. Coerced to Int32 in staging.
is_on_time
1 if delivered_date <= promised_date, else 0. Coerced from "true"/"false" → UInt8.
is_in_full
1 if all lines shipped complete, else 0. Coerced from "true"/"false" → UInt8.
is_otif
1 if is_on_time AND is_in_full, else 0. Coerced from "true"/"false" → UInt8.