maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmarts

mart_pricing_guardrails

certified
mart table

The discount / margin guardrails for each SKU in each market.

Definition

One row per (sku, region, segment) price-book entry, joined to the product catalogue for product_name, category, and unit_cost. It is the deal desk's pricing envelope: `list_price` is the region/segment-adjusted catalogue price; `floor_price` is the HARD floor a quote must never cross; `unit_cost` is the margin basis; `target_margin_pct` and `max_discount_pct` are the policy bounds; and `margin_headroom_pct = (list_price − floor_price) / list_price · 100` is the maximum discount the floor permits. Snapshot of the current price book — not a time series. Commercially sensitive, but accessible to all RFX personas including AI (ai_readonly / rfx_contributor) per the 2026-06-29 decision to surface pricing to AI assistants.

Watch out for
  • highTreating floor_price as a soft target rather than the hard floor

    `floor_price` is the absolute minimum a quote may reach — a quote below it must never be issued. It is NOT a margin target and is NOT equal to cost (it is set ≥ implied cost). Deriving a minimum from `list_price` and `max_discount_pct` and ignoring `floor_price` can produce a quote below the floor. Always clamp at `floor_price`.

  • highAssuming pricing is hidden from AI personas

    As of the 2026-06-29 decision, ai_readonly and rfx_contributor CAN read this mart (incl. floor_price / unit_cost / max_discount_pct) via query_records('price_book'). Pricing is still absent from the metric layer — it reaches AI only as governed row detail, never as free aggregates or raw SQL. Treat the figures as commercially sensitive even though AI can now see them.

  • mediumReading margin_headroom_pct when list_price is missing or zero

    `margin_headroom_pct` is null when `list_price` is null or 0 — there is no defined headroom. Filtering or sorting on it without guarding for null silently drops those rows; treat null as "headroom undefined", not "zero headroom".

Questions this answers
  • “What is the lowest price we can quote this SKU in EMEA for the enterprise segment?”
  • “Which SKUs in NA have less than 10% discount headroom before hitting the floor?”
  • “Show the target margin and discount ceiling for SKU X across all markets.”
12 of 12
Column
Type
Description
Tests · PII
sku
String
Stock-keeping unit code. Part of the (sku, region, segment) grain. FK to the product catalogue.
2 tests
product_name
Nullable(String)
Human-readable product name. From `stg_gcs__rfx_products_services.name` via LEFT JOIN — Nullable if the catalogue row is missing.
category
Nullable(String)
Product category (software / services / support / hardware / training). From `stg_gcs__rfx_products_services.category` (LEFT JOIN).
region
String
`NA` / `EMEA` / `APAC` / `LATAM`. Part of the grain. From `stg_gcs__rfx_price_book.region`.
1 test
segment
String
`enterprise` / `mid` / `smb`. Part of the grain. From `stg_gcs__rfx_price_book.segment`.
1 test
list_price
Nullable(Decimal(14, 2))
Region/segment-adjusted catalogue list price. From `stg_gcs__rfx_price_book.list_price`.
floor_price
Nullable(Decimal(14, 2))
The HARD floor — the absolute minimum a quote may reach for this SKU in this market. A quote must never go below it. Set ≥ implied cost; it is NOT cost and NOT a target. From `stg_gcs__rfx_price_book.floor_price`.
unit_cost
Nullable(Decimal(14, 2))
Catalogue unit cost — the margin basis. From `stg_gcs__rfx_products_services.unit_cost` (LEFT JOIN); < list_price by construction.
target_margin_pct
Nullable(Decimal(6, 2))
Policy target margin for this SKU/market, as a percentage. From `stg_gcs__rfx_price_book.target_margin_pct`.
max_discount_pct
Nullable(Decimal(6, 2))
Maximum discount the policy permits off list, as a percentage. The floor still binds independently — see `floor_price`. From `stg_gcs__rfx_price_book.max_discount_pct`.
margin_headroom_pct
Nullable(Decimal(6, 2))
Derived — `(list_price − floor_price) / list_price · 100`. The maximum discount (as a % of list) the floor permits. Null when list_price is null or 0 (headroom undefined).
currency
Nullable(String)
`USD` / `EUR` / `GBP`. From `stg_gcs__rfx_price_book.currency`.