Preview

OrderUnifiedItem is in Preview status and is subject to change without notice. For more information about Preview status, see the GraphQL API policy.

OrderUnifiedItem

An order in the unified system.

This page contains

    Fields

    id: ID!

    Stable identifier for this order.

    orderNumber: String

    Business key (order number) in the source system.

    orderName: String

    Display name for the order.

    sourceSystem: String!

    Source system of record.

    normalizedStatus: String

    Normalized order status (e.g. new, in_progress, completed, cancelled, refunded).

    customerName: String

    Customer display name.

    customerEmail: String

    Plain String (not EmailAddress scalar) — same rationale as QuoteUnifiedItem.

    customerPhone: String

    Plain String (not PhoneNumber scalar) — same rationale as QuoteUnifiedItem.

    customerAddress: String

    Customer address.

    providerName: String

    Provider display name.

    quoteId: String

    Related quote identifier.

    canonicalPartyId: ID

    Canonical party identifier when the order is linked to a unified customer profile (warehouse canonical_party_id).

    subscriptionUuid: String

    Monolith subscription/entitlement UUID for routing to the catalog admin subscription page. Null for every non-monolith source and for monolith POs with no linked entitlement (renewals, billing-only, addons). Reseller URL: /reseller/subscriptions/<subscriptionUuid>; marketplace manager: /channel/subscriptions/<subscriptionUuid>.

    boxContractGuid: String

    Box contract GUID for routing to the Box contract detail page. Null for every non-box source.

    salesAgentId: String

    Source-system identifier of the sales agent / order creator. Null when no agent attribution is available.

    salesAgentName: String

    Display name of the sales agent. Rendered by the UI as the "by " subtitle under Created Date on the orders table.

    advisorUuid: ID

    Canonical lowercase advisor UUID for this order (matches party_xref.advisor_uuid). Marketplace-manager UIs use this to filter the list down to a single advisor.

    advisorName: String

    Display name of the advisor that owns this order; null when no advisor is resolved (e.g. an unmapped UUID).

    totalPrice: Float

    Total order price.

    mrr: Float

    Monthly recurring revenue.

    nrr: Float

    Net recurring revenue (detail view only).

    createdAt: DateTime

    Order creation timestamp (RFC 3339).

    updatedAt: DateTime

    Last-activity timestamp (RFC 3339). Per source system: monolith from purchase_orders.last_modified; PS from mcorderlocationdetail.OrderStatusDate; firstbase from dim_fb_orders.etl_last_modified; box from box_bronze.contract.last_action_date.

    lineItemCount: Int!

    Number of line items on this order.

    productNames: String

    Distinct product display names aggregated for list views (comma-separated). Null when none are available.

    lineItems: [OrderUnifiedLineItem!]! PREVIEW

    Nested line items (populated on detail queries only).

    Parent objects of OrderUnifiedItem

    OrderUnifiedPage PREVIEW

    Cursor-paginated list of unified orders.

    Queries for OrderUnifiedItem

    orderUnifiedDetailByAdvisorId PREVIEW

    Full order detail including line items, scoped to advisor. Returns null when not found.

    orderUnifiedDetailByMarketplaceTenant PREVIEW

    Full order detail including line items, scoped to marketplace tenant. Returns null when not found. Authorized for ROLE_CHANNEL_ADMIN only.

    orderUnifiedListByAdvisorId PREVIEW

    Cursor-paginated list of unified orders for the advisor with optional search and status filter. first is capped at 100 server-side.

    orderUnifiedListByMarketplaceTenant PREVIEW

    Cursor-paginated list of unified orders in a marketplace tenant. Filters on gold.golden_orders.marketplace_tenant; spans every advisor in the marketplace. first is capped at 100 server-side. Authorized for ROLE_CHANNEL_ADMIN only.