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 Contracted Unit Price represents the agreed-upon unit price for a single Pricing Unit of the associated SKU, inclusive of negotiated discounts, if present, while excluding negotiated commitment discounts or any other discounts. This price is denominated in the Pricing Currency. When negotiated discounts do not apply to unit prices and instead are applied to exchange rates, the Pricing Currency Contracted Unit Price defaults to the Pricing Currency List Unit Price. The Pricing Currency Contracted Unit Price is commonly used to calculate savings based on negotiation activities.

Requirements

PricingCurrencyContractedUnitPrice adheres to the following requirements:

  • PricingCurrencyContractedUnitPrice presence in a Cost and Usage FOCUS dataset is defined as follows:
    • PricingCurrencyContractedUnitPrice 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.
    • PricingCurrencyContractedUnitPrice 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.
    • PricingCurrencyContractedUnitPrice MAY be present in a Cost and Usage FOCUS dataset in all other cases.
  • PricingCurrencyContractedUnitPrice MUST be of type Decimal.
  • PricingCurrencyContractedUnitPrice MUST conform to NumericFormat requirements.
  • PricingCurrencyContractedUnitPrice nullability is defined as follows:
    • PricingCurrencyContractedUnitPrice MUST be null when SkuPriceId is null.
    • PricingCurrencyContractedUnitPrice MUST be null when ChargeCategory is "Tax".
    • PricingCurrencyContractedUnitPrice MUST NOT be null when SkuPriceId is not null.
    • PricingCurrencyContractedUnitPrice MUST NOT be null when ChargeCategory is "Usage" or "Purchase" and ChargeClass is not "Correction".
    • PricingCurrencyContractedUnitPrice MAY be null in all other cases.
  • When PricingCurrencyContractedUnitPrice is not null, PricingCurrencyContractedUnitPrice adheres to the following additional requirements:
    • PricingCurrencyContractedUnitPrice MUST be a non-negative decimal value.
    • PricingCurrencyContractedUnitPrice MUST be denominated in the PricingCurrency.
Read the source on focus.finops.org ↗