Constraints

Column type
Metric
Feature level
Conditional
Allows nulls
Yes
Data type
Decimal
Value format
Numeric Format
Number range
Any valid non-negative decimal value

Description

The Pricing Currency List Unit Price represents the suggested service-provider-published unit price for a single Pricing Unit of the associated SKU, exclusive of any discounts. This price is denominated in the Pricing Currency. The Pricing Currency List Unit Price is commonly used for calculating savings based on various rate optimization activities.

Requirements

PricingCurrencyListUnitPrice adheres to the following requirements:

  • PricingCurrencyListUnitPrice presence in a Cost and Usage FOCUS dataset is defined as follows:
    • PricingCurrencyListUnitPrice MUST be present in a Cost and Usage FOCUS dataset when the service provider supports prices in virtual currency and publishes unit prices exclusive of discounts.
    • PricingCurrencyListUnitPrice is RECOMMENDED to be present in a Cost and Usage FOCUS dataset when the service provider supports pricing and billing in different currencies and publishes unit prices exclusive of discounts.
    • PricingCurrencyListUnitPrice MAY be present in a Cost and Usage FOCUS dataset in all other cases.
  • PricingCurrencyListUnitPrice MUST be of type Decimal.
  • PricingCurrencyListUnitPrice MUST conform to NumericFormat requirements.
  • PricingCurrencyListUnitPrice nullability is defined as follows:
    • PricingCurrencyListUnitPrice MUST be null when SkuPriceId is null.
    • PricingCurrencyListUnitPrice MUST be null when ChargeCategory is "Tax".
    • PricingCurrencyListUnitPrice MUST NOT be null when SkuPriceId is not null.
    • PricingCurrencyListUnitPrice MUST NOT be null when ChargeCategory is "Usage" or "Purchase" and ChargeClass is not "Correction".
    • PricingCurrencyListUnitPrice MAY be null in all other cases.
  • When PricingCurrencyListUnitPrice is not null, PricingCurrencyListUnitPrice adheres to the following additional requirements:
    • PricingCurrencyListUnitPrice MUST be a non-negative decimal value.
    • PricingCurrencyListUnitPrice MUST be denominated in the PricingCurrency.
Read the source on focus.finops.org ↗