THE LINUX FOUNDATION PROJECTS
FOCUS Logo
Docs navigation
On this page

    2.21 Verification, Comparison, and Fluctuation Tracking of Unit Prices

    2.21.1 Description

    When a service provider supports unit pricing concepts, FOCUS allows practitioners to:

    • Verify that the correct List Unit Prices and Contracted Unit Prices are applied.
    • Compare applied Contracted Unit Prices across different billing accounts and with applied List Unit Prices at specific points in time.
    • Track fluctuations in unit prices over time.

    2.21.2 Directly Dependent Columns

    Contracted Unit Price List Unit Price SKU ID SKU Price Details SKU Price ID

    2.21.3 Supporting Columns

    Billing Currency BillingPeriodId Charge Period End Charge Period Start

    2.21.4 Example SQL Query

    Example SQL Query

    SELECT DISTINCT
  SkuId,
  SkuPriceId,
  SkuPriceDetails,
  BillingPeriodId,
  ChargePeriodStart,
  ChargePeriodEnd,
  BillingCurrency,
  ListUnitPrice,
  ContractedUnitPrice
FROM focus_data_table
WHERE
  SkuPriceId = ?
  AND ChargePeriodStart >= ?
  AND ChargePeriodEnd < ?
    Previous Participating Entity Identification Next Datasets