Column dictionary

PricingCurrencyContractedUnitPrice

Pricing Currency Contracted Unit Price · Cost and Usage dataset

Feature level
Conditional
Data type
Decimal
Allows nulls
Yes
Column type
Metric

What it is

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 (11)

Verbatim from the specification. These are the statements the validator checks against.

  • PricingCurrencyContractedUnitPrice MUST be of type Decimal.
  • PricingCurrencyContractedUnitPrice MUST conform to NumericFormat requirements.
  • PricingCurrencyContractedUnitPrice MUST adhere to the following nullability requirements:
  • 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 MUST adhere to the following requirements:
  • PricingCurrencyContractedUnitPrice MUST be a non-negative decimal value.
  • PricingCurrencyContractedUnitPrice MUST be denominated in the PricingCurrency.

Check your own export

The FOCUS 1.4 validator checks this column and 122 others against your file, in your browser, with no size cap and nothing uploaded.

Other Cost and Usage columns

Definition taken from the FOCUS 1.4 specification. FOCUS is published by the FinOps Foundation under CC BY 4.0.

One column is a definition. A pipeline is a project.

Finitizer ingests FOCUS from every provider you run and reports across all of them.