Constraints

Column type
Metric
Feature level
Mandatory
Allows nulls
Yes
Data type
Decimal
Value format
Numeric Format

Description

The Pricing Quantity represents the volume of a given SKU associated with a resource or service used or purchased, based on the Pricing Unit. Distinct from Consumed Quantity (complementary to Consumed Unit), it focuses on pricing and cost, not resource and service consumption.

Requirements

PricingQuantity adheres to the following requirements:

  • PricingQuantity MUST be present in a Cost and Usage FOCUS dataset.
  • PricingQuantity MUST be of type Decimal.
  • PricingQuantity MUST conform to NumericFormat requirements.
  • PricingQuantity nullability is defined as follows:
    • PricingQuantity MUST be null when SkuPriceId is null.
    • PricingQuantity MUST be null when ChargeCategory is "Tax".
    • PricingQuantity MUST NOT be null when ChargeCategory is "Usage" or "Purchase" and ChargeClass is not "Correction".
    • PricingQuantity MAY be null in all other cases.
  • PricingQuantity MUST be a valid decimal value when not null.
  • Cost metric (e.g., ContractedCost) MUST equal the product of the corresponding unit price (e.g., ContractedUnitPrice) and PricingQuantity when the unit price is not null and PricingQuantity is not null.
Read the source on focus.finops.org ↗