maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per order line with the parent order, SKU, line number, units ordered/picked, pick time, unit price, and accuracy / short-pick flags. Aggregated into mart_fulfillment_daily (accurate_lines, total_lines) → metric_pick_accuracy. A line's SKU is always drawn from the parent order's client catalog (INC-22 integrity test).
10 of 10
Column
Description
Tests · PII
order_line_id
UUID5 — primary key on the source side. Stable across re-syncs.
2 tests
order_id
The parent order. String on the wire; coerced and validated against `whse_orders` in staging.
sku
The SKU picked on this line. String on the wire; coerced and validated against `whse_products` in staging. INC-22 integrity test asserts it belongs to the parent order's client_id.
line_no
1-based line index within the order. Coerced to UInt16 in staging.
units_ordered
Units ordered on this line. Coerced to Int32 in staging.
units_picked
Units picked (≤ units_ordered; short-picks drive is_in_full). Coerced to Int32 in staging.
pick_time_sec
Time to pick the line in seconds (feeds labor productivity). Coerced to Int32 in staging.
unit_price_eur
Unit price in EUR. Coerced to Decimal(14,2) in staging.
is_accurate
1 if the line was picked correctly (right SKU, right qty), else 0. Coerced from "true"/"false" → UInt8.
is_short_pick
1 if units_picked < units_ordered, else 0. Coerced from "true"/"false" → UInt8.