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

mart_mdt_pricing

beta
mart table

Cost line items behind each proposal's ROM (BI-only).

Lineage Builds
Definition

One row per pricing line item (grain line_item_id): device_nickname, category, related_test, quantity/rate/amount, and the proposal currency. The amounts sum to the proposal's total_rom. Confidential-commercial — exposed only to BI + commercial personas.

Watch out for
  • highExposing pricing to AI personas

    amount / rate are confidential-commercial. This mart grants no ai_readonly access and the row-detail is restricted to commercial personas. Do not add ai_readonly to accessible_to.

Questions this answers
  • “How does a proposal's ROM break down by device?”
  • “What are the largest cost line items?”
14 of 14
Column
Type
Description
Tests · PII
line_item_id
String
Primary key — grain of this mart.
2 tests
proposal_id
Nullable(String)
FK to the proposal.
smithers_employee PII
opportunity_id
Nullable(String)
FK to the opportunity.
smithers_employee PII
device_nickname
Nullable(String)
Device this cost line is for.
category
String
Cost category.
related_test
Nullable(String)
Test name this line maps to, if per-test.
description
Nullable(String)
What the line item covers.
quantity
Nullable(Decimal(12, 2))
Number of units.
rate
Nullable(Decimal(12, 2))
Rate per unit. Confidential-commercial.
amount
Nullable(Decimal(14, 2))
Line cost. Confidential-commercial.
currency
String
Proposal currency.
entity
String
Issuing Smithers legal entity.
confidence
Nullable(String)
Provenance of the cost.
issued_month
Nullable(Date)
Proposal issued month (for time filtering).